tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Bremford" <>
Subject RE: SQL Exception (same erro) (SOLVED)
Date Tue, 08 Aug 2000 15:42:47 GMT
Hi araman

mysqld does a DNS lookup to see who's connecting.

Take a look at
There are a couple of points about 10 bulletpoints down which give more

Cheers... Mike

-----Original Message-----
From: []
Sent: 08 August 2000 15:37
To: Tomcat
Subject: Re: SQL Exception (same erro) (SOLVED)

hi guys
Managed to solve the problem but still I AM CONFUSED WITH WHATS HAPPENING..
After browsing thru some other mail archives it was suggested to have a look
at the strace output for a sample application..

Though i didnt understand what strace generated i could make out was that
the connection was getting refused somehow or the other..

This started off a long tedious recursive trials and one permutation clicked
for me..

I used to mention the ip address of the machine, but the connect string used
to convert it into the DNS name and mysql refused such a connection as there
was no such entry in the access control tables.. Now what is confusing me is
that why should the connect string try to get the fully qualified name when
being supplied with the IP address..

Will anyone will be kind enough to go thru the strace output generated and
give me the feedback..

The attached strace file was generated when i tried to connect to the
database using the IP address but the connect string chose to query the name
server for the fully qualified domain name on port 53..

Today said

> Please ignore if it has already been delivered..
> Thanx
> Anand
> ---------- Forwarded message ----------
> Date: Tue, 8 Aug 2000 14:22:02 +0530 (IST)
> From:
> To: Tomcat <>
> Subject: SQL Exception (same error)
> Hi again
> After reading all ur mails i tried to the following
> 1.	create a fresh user in the mysql database
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("");
> 				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

View raw message