[opencms-dev] Trouble connecting to MySQL during wizard setup

[Eelco Hillenius]

Sorry, I seem to have trouble with reading before responding lately.

Setting up JDBC should be very straightforward in most cases, so I think
(like Thomas) you should look into your MySQL configuration. Are (local)
connections allowed for the given user? I remember from the times that I
installed MySQL on Linux (usually I work on Windows) that by default outside
connections were allowed for user root, but local connections were not.
Check table mysql/user if there is an entry that allowes for local access to
your database. (e.g. you could try: INSERT INTO user
VALUES("localhost","root","","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y"
,"Y","Y");).

Good luck,

Eelco

----- Original Message -----
From: "David De Graff" <opencms at platformglobal.com>
To: <opencms-dev at www.opencms.org>
Sent: Thursday, January 30, 2003 6:48 PM
Subject: Re: [opencms-dev] Trouble connecting to MySQL during wizard setup


> Thanks for the quick response. As noted in my message, I did attempt to
> connect with both the server name localhost and the actual hostname. The
> server name is tomcat (maybe I should change that - named it so b/c it's a
> test machine for a tomcat installation).
>
> Dave
>
> ----- Original Message -----
> From: "Eelco Hillenius" <eelco.hillenius at topicus.nl>
> To: <opencms-dev at www.opencms.org>
> Sent: Thursday, January 30, 2003 9:40 AM
> Subject: RE: [opencms-dev] Trouble connecting to MySQL during wizard setup
>
>
> > what is the name of your mysql server? Try using localhost or
(servername)
> > instead of tomcat.
> >
> > Eelco
> >
> > -----Original Message-----
> > From: owner-opencms-dev at www.opencms.org
> > [mailto:owner-opencms-dev at www.opencms.org]On Behalf Of David De Graff
> > Sent: donderdag 30 januari 2003 18:12
> > To: opencms-dev at opencms.com
> > Subject: [opencms-dev] Trouble connecting to MySQL during wizard setup
> >
> >
> > When trying to set up OpenCms with the setup wizard, I get the following
> > error at the database creation step:
> >
> > >>
> > Could no connect to database via: jdbc:mysql://tomcat:3306/
> > java.sql.SQLException: Cannot connect to MySQL server on tomcat:3306. Is
> > there a MySQL server running on the machine/port you are trying to
connect
> > to? (java.security.AccessControlException)
> >
> > -------------------------------------------
> > java.lang.NullPointerException
> >
> > -------------------------------------------
> > <<
> >
> > I'm running Tomcat 4.04 with Sun JDK 1.4.1 and MySQL 3.23.55 on Debian
3.
> I
> > have tried the connection to 'localhost' and using the actual hostname
of
> > the server, and have also made sure to enable networking for the MySQL
db.
> > Still no connection after these changes.
> >
> > Any ideas as to what might be wrong and how to troubleshoot it?
> >
> > Is there a simple and definite way to test that jdbc is installed
> correctly
> > and is configured to enable connections to MySQL?
> >
> > Thanks for any help.
> >
> > Dave De Graff
> >
> >
>
>