From: Jeff K. <kop...@ee...> - 2002-04-16 05:53:45
|
I'm running jython 2.1 on MacOSX 10.1.3 and have the MM driver, version 2.0.12. Using the jython.org example, I get the following error (excuse the email formatting): ------------------------ Jython 2.1 on java1.3.1 (JIT: null) Type "copyright", "credits" or "license" for more information. >>> from com.ziclix.python.sql import zxJDBC >>> db = zxJDBC.connect("jdbc:mysql://localhost:3306/test", None, None, "org.gjt.mm.mysql.Driver") Traceback (innermost last): File "<console>", line 1, in ? DatabaseError: Server configuration denies access to data source ------------------------ I can verify that the password/id are correct and working with mysql: ------------------------ [localhost:~] kopmanis% mysql --no-defaults test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 58 to server version: 3.23.44entropy.ch-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> ------------------------ What's up? I've gotten the Swing stuff to come up for the most part, but JDBC doesn't seem to be cooperating. I didn't change my CLASSPATH, but I *did* install the items directly into the /Library/Java/Extensions folder, eliminating the need for CLASSPATH changes. Any clues? -Jeff. :) ------- University of Michigan Artificial Intelligence Lab ------- Jeff Kopmanis, Sr. Sys Analyst, 1101 Beal Ave, Ann Arbor, MI 48109-2110 Office: 734-763-9352 http://ai.eecs.umich.edu/people/kopmanis Soul Kitchen Rhythm & Blues: http://spring.eecs.umich.edu/sk Monroe Big Band: http://monroebigband.com |
From: brian z. <bz...@zi...> - 2002-04-16 12:58:00
|
Jeff, Searching the mysql JDBC archive shows this question comes up with some frequency (a couple of OSX references): http://www.geocrawler.com/mail/thread.php3?subject=Server+configuration+ denies+access+to+data+source&list=193 It seems there might be a couple of solutions: (1) Type `hostname` and use the resulting value rather than 'localhost'. (2) Try '127.0.0.1' rather than 'localhost'. (3) "This happens when your IP doesn't reverse-map to the name(s) you used in your GRANT tables." (4) Update the GRANT table (I'm no MySQL DBA so I'm not sure why the mysql interactive shell works and JDBC doesn't). To rule out zxJDBC, execute the following: #--- start --- import java, org driver = org.gjt.mm.mysql.Driver() url, user, pwd = "jdbc:mysql://localhost:3306/test", None, None conn = java.sql.DriverManager.getConnection(url, user, pwd) assert conn is not None, "connection is null" print "database: " + conn.getMetaData().getDatabaseProductName() print " version: " + conn.getMetaData().getDatabaseProductVersion() print " driver: " + conn.getMetaData().getDriverName() print " version: " + conn.getMetaData().getDriverVersion() #--- stop --- Let me know if you need more help. thanks, brian > -----Original Message----- > From: jyt...@li... > [mailto:jyt...@li...] On Behalf > Of Jeff Kopmanis > Sent: Tuesday, April 16, 2002 12:54 AM > To: jyt...@li... > Subject: [Jython-users] jython-zxJDBC connect error > Importance: High > > > I'm running jython 2.1 on MacOSX 10.1.3 and have the MM > driver, version > 2.0.12. Using the jython.org example, I get the following > error (excuse > the email formatting): > > > ------------------------ > Jython 2.1 on java1.3.1 (JIT: null) > Type "copyright", "credits" or "license" for more information. > >>> from com.ziclix.python.sql import zxJDBC > >>> db = zxJDBC.connect("jdbc:mysql://localhost:3306/test", > None, None, > "org.gjt.mm.mysql.Driver") > Traceback (innermost last): > File "<console>", line 1, in ? > DatabaseError: Server configuration denies access to data source > ------------------------ > > I can verify that the password/id are correct and working with mysql: > > ------------------------ > [localhost:~] kopmanis% mysql --no-defaults test > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 58 to server version: > 3.23.44entropy.ch-log > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> > ------------------------ > > What's up? I've gotten the Swing stuff to come up for the most part, > but JDBC doesn't seem to be cooperating. I didn't change my > CLASSPATH, > but I *did* install the items directly into the > /Library/Java/Extensions > folder, eliminating the need for CLASSPATH changes. Any clues? > > -Jeff. :) > > ------- University of Michigan Artificial Intelligence Lab > ------- > Jeff Kopmanis, Sr. Sys Analyst, 1101 Beal Ave, Ann Arbor, MI > 48109-2110 > Office: 734-763-9352 > http://ai.eecs.umich.edu/people/kopmanis > Soul Kitchen Rhythm > & Blues: http://spring.eecs.umich.edu/sk > Monroe Big Band: http://monroebigband.com > > > _______________________________________________ > Jython-users mailing list > Jyt...@li... > https://lists.sourceforge.net/lists/listinfo/jython-users > |