On Mon, 2010-01-18 at 07:42 -0600, Caldarale, Charles R wrote:
> > From: Rick Bragg [mailto:li...@gmnet.net]
> > Subject: RE: Cyclos Webapp Trouble (404)
> > 
> > Error connecting to database at jdbc:mysql://localhost/cyclos3
> 
> Besides verifying that MySQL is actually running as David suggested, note 
> that there's a mismatch in the cyclos installation instructions compared to 
> what's in the cyclos.properties file.  The instructions say to create a 
> database named "cyclos", but the properties file refers to one named 
> "cyclos3" in a couple of places - as does your error message.  You need to 
> resolve the discrepancy.
> 
>  - Chuck
> 
> 
> THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY 
> MATERIAL and is thus for use only by the intended recipient. If you received 
> this in error, please contact the sender and delete the e-mail and its 
> attachments from all computers

Thanks Chuck,

Yes I notices that as well, I forgot to post my cyclos.properies Here is
the "mysql" section...

### MySQL
hibernate.dialect = org.hibernate.dialect.MySQLInnoDBDialect
hibernate.connection.driver_class = com.mysql.jdbc.Driver
hibernate.connection.url = jdbc:mysql://127.0.0.1:3306/cyclos
hibernate.connection.username = cyclos
hibernate.connection.password = test1234
### Connection provider properties
hibernate.connection.provider_class = 
org.hibernate.connection.C3P0ConnectionProvider
hibernate.c3p0.minPoolSize = 1
hibernate.c3p0.maxPoolSize = 100
hibernate.c3p0.acquireIncrement = 1
hibernate.c3p0.maxIdleTime = 21600
hibernate.c3p0.testConnectionOnCheckout = true
hibernate.c3p0.preferredTestQuery = select 1
hibernate.c3p0.acquireRetryAttempts = 5
hibernate.c3p0.numHelperThreads = 3

my database name is "cyclos", MySQL is also in "production" so and is
accessed by other php and perl libs on the local host.  I have also
tried some variations on the connection.url such as:

hibernate.connection.url = jdbc:mysql://localhost:3306/cyclos
and
hibernate.connection.url = jdbc:mysql://localhost/cyclos

In MySQL, I have the user set up privileges for the user to access via
localhost AND 127.0.0.1








---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org

Reply via email to