JDBC MySQL again

2002-08-12 Thread Jan Willem Penterman
Hi, I searched the archives for a solution to my problem, but couldn't find any. Like many, I keep getting the following error: SQLException: Cannot connect to MySQL server on localhost:3306. Is there a MySQL server running on the machine/port you are trying to connect to?

RE: JDBC MySQL again

2002-08-12 Thread Shapira, Yoav
Starting service Tomcat-Standalone Apache Tomcat/4.0.4 PARSE error at line 1 column 10 org.xml.sax.SAXParseException: Element type web-app must be declared. Howdy, I haven't seen your original message, which presumably has to do with the MySQL error. However, the above is enough to suggest

RE: JDBC MySQL again

2002-08-12 Thread Mike Jackson
:1114/contact_mgr, username, password ); --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Jan Willem Penterman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 8:15 AM To: [EMAIL PROTECTED] Subject: JDBC MySQL again Hi, I searched

Re: JDBC MySQL again

2002-08-12 Thread Colin Chalmers
Hi, What happens when you use another version of mysql driver, I was having trouble with version 14. /colin - Original Message - From: Jan Willem Penterman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 12, 2002 5:14 PM Subject: JDBC MySQL again Hi, I searched

Re: JDBC MySQL again

2002-08-12 Thread Peter T. Abplanalp
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, Aug 12, 2002 at 05:14:46PM +0200, Jan Willem Penterman wrote: SQLException: Cannot connect to MySQL server on localhost:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.net.ConnectException)

Re: JDBC MySQL again

2002-08-12 Thread Larry Meadors
Also, if you are using ipchains or iptables as a firewall, you may need to open a conduit to allow access to port 3306. Even on localhost, ipchains will not allow access unless configured to do so. Larry [EMAIL PROTECTED] 08/12/02 09:35 AM generally, if you see this problem, your driver is

RE: JDBC MySQL again

2002-08-12 Thread Jan Willem Penterman
generally, if you see this problem, your driver is loaded correctly; however, it is unable to connect to your mysql server. i would test this by trying to telnet to port 3306 on localhost and see if you get a connection. if you don't, you need to make sure your mysql is allowing

Re: JDBC MySQL again

2002-08-12 Thread Peter T. Abplanalp
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, Aug 12, 2002 at 06:57:09PM +0200, Jan Willem Penterman wrote: generally, if you see this problem, your driver is loaded correctly; however, it is unable to connect to your mysql server. i would test this by trying to telnet to port

RE: JDBC MySQL again

2002-08-12 Thread Jan Willem Penterman
yay! do i get a medal or something? ;-) Yes you get a medal. Only thing is that it is so incredibly heavy that I can't send it by mail. You have to come pick it up at our office in Amsterdam :P O and I gave my thanks to Hoang, but I was mistaken. Thanks Peter! [off-topic] Is that also

Re: JDBC MySQL again

2002-08-12 Thread Peter T. Abplanalp
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, Aug 12, 2002 at 07:45:03PM +0200, Jan Willem Penterman wrote: Yes you get a medal. Only thing is that it is so incredibly heavy that I can't send it by mail. You have to come pick it up at our office in Amsterdam :P next time i'm in

mySQL again

2001-03-01 Thread Herchel Wojciech
Hi! My connectionURL in server.xml now looks like this: "jdbc:mysql://localhost/auth?user=rootpassword=somepassword" and tomcat doesn't start up (although there is no error msg or anything) and when i execute tomcat stop i get the following exception: org.xml.sax.SAXParseException: Next

re: mySQL again

2001-03-01 Thread leak
Hi! My connectionURL in server.xml now looks like this: "jdbc:mysql://localhost/auth?user=rootpassword=somepassword" and tomcat doesn't start up (although there is no error msg or anything) and when i execute tomcat stop i get the following exception: org.xml.sax.SAXParseException: Next

Re: mySQL again

2001-03-01 Thread Andrew Robson
Hi, You might want to try something like the following. It works for me. RequestInterceptor className="org.apache.tomcat.request.JDBCRealm" debug="99" driverName="org.gjt.mm.mysql.Driver" connectionURL="jdbc:mysql://localhost/somedb"

Protecting mysql access (was: re: mySQL again)

2001-03-01 Thread Rob Tanner
Slightly off topic, but important! Having seen way too much in terms of hacking and system compromises, might I suggest you create another, and far less privileged user than root, for accessing mysql. Unless you've gone into the grant tables and creatd a different mysql superuser and reduced

Re: Protecting mysql access (was: re: mySQL again)

2001-03-01 Thread Rick Herrick
On our server, we basically grant NO remote access privileges to ANY users, including root. This means that any access to the database has to be done from the localhost. So instead of doing the two normal grants you might do, like this: GRANT SELECT,INSERT,UPDATE ON *.* TO soandso@localhost

Re: Protecting mysql access (was: re: mySQL again)

2001-03-01 Thread Rob Tanner
But that doesn't address the basic issue. If you have login privs on the machine and a shell account, or you've managed to sniff a password of someone who does, etc, than you have a potential security hole. Remember also, that more damage in terms of dallar value comes from inside, from