DatabaseStartupException

[Migrated From Jforum.net]

Hi all.

I'm having problems configuring jForum 2.1.4 on a server running Tomcat 4.0.6 and MySQL 4.0.20 and I get the following error:

net.jforum.exceptions.DatabaseStartupException: Error while trying to start the database: java.sql.SQLException: Server connection failure during transaction.
Attempted reconnect 3 times. Giving up.

The database, hostname, port, username and password are correct. Any ideas?

I'd be very grateful of any information, perhaps something I haven't checked. I can get it to work fine on a development server using Tomcat 5.5 and MySQL 4.1, but it does not work on the production server.


Thanks a million!

Barry Broom
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Well, there are 2 places you should look:

WEB-INF/config/database/mysql/mysql.properties

and

WEB-INF/config/jforum-custom.conf

Settings in jforum-custom.conf have priority over any other system setting, so take a look there for incorrect database configurations (and vice-versa)

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Aha! I hadn't changed the database settings in jforum-custom.conf; it works now!

Thank you ever so much! I am using jForum as part of my MSc project at De Montfort University, Leicester, UK. I will give you credit for your help in my dissertation! See www.clubtogether.org.uk.

Thank you once again.

Barry
[originally posted on jforum.net by Anonymous]