tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kaneda K <zouy...@yahoo.com>
Subject RE: SQL Exception (same error) (fwd)
Date Wed, 09 Aug 2000 08:06:35 GMT
 There is a DNS probleme, with localhost. which is
turn into localhost.localdomain. so try to connect to
127.0.0.1
I was not able to really explain this bug but it did
block me times agos.
keep me inform, good luck.

--- Christian Mack <cmack@spcie.de> wrote:
> Hi Anand
> 
> It is not necessary to flush after an GRANT.
> 
> But perhaps MySQL is started with -skip-networking
> as an option.
> This will prevent an TCP/IP connection to it.
> The mysql client will work, because it uses named
> pipes when used on
> localhost.
> 
> Tschau
> Christian
> 
> > -----Original Message-----
> > From: Brian Richards [mailto:ncmusic@pobox.com]
> > Sent: Tuesday, August 08, 2000 3:34 PM
> > To: tomcat-user@jakarta.apache.org
> > Subject: Re: SQL Exception (same error) (fwd)
> > 
> > 
> > Did you flush the permissions?  "mysqladmin
> reload"
> > 
> > -Brian
> > ----- Original Message -----
> > From: <araman@india-today.com>
> > To: "Tomcat" <tomcat-user@jakarta.apache.org>
> > Sent: Tuesday, August 08, 2000 6:53 AM
> > Subject: SQL Exception (same error) (fwd)
> > 
> > 
> > > Hi again
> > > After reading all ur mails i tried to the
> following
> > >
> > > 1. create a fresh user in the mysql database
> > >
> > > GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON
> subscriptions.* to
> > subs@localhost identified by 'some_pass';
> > >
> > > 2. create a sample application and test
> connectivity to the database
> > >
> > > import java.sql.*;
> > >
> > > public class trial {
> > > Connection conn;
> > > Statement stmt;
> > >
> > > public static void main(String args[]) {
> > > trial tr = new trial();
> > > String
> DBURL="jdbc:mysql:localhost///subscriptions";
> > > try{
> > > Class.forName("org.gjt.mm.mysql.Driver");
> > >
>
tr.conn=DriverManager.getConnection(DBURL,"subs","some_pass");
> > > tr.stmt=tr.conn.createStatement();
> > > System.out.println("In connect");
> > > System.out.println(tr.stmt);
> > > } catch(Exception ex){
> > > System.out.println(ex.toString());
> > > }
> > > }
> > > }
> > >
> > > 3. On compiling and excuting I still manage to
> get the 
> > following error
> > >
> > > java.sql.SQLException: Server configuration
> denies access 
> > to data source
> > >
> > > Why is this coming.. I have gone over the
> privileges table 
> > many times and
> > everything seems to be fine..  I am also able to
> connect to 
> > the database
> > using the mysql client and the same login and
> passwd..
> > >
> > > This thing is totally driving me up the wall if
> ay one of u 
> > could tell me
> > why it is happening so..
> > >
> > > Thanx for ur time
> > > Anand Raman
> > >
> > >
> > >
> > >
> > >
> > >
> > 


__________________________________________________
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/

Mime
View raw message