tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject Re: SQL Exception (same erro) (SOLVED)
Date Tue, 08 Aug 2000 14:36:42 GMT
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
> 	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("");
> 				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
> Thanx for ur time
> Anand Raman

View raw message