java.sql.SQLException: Configuration file not found

[mistermind]

Hello there again,
When trying to start SFS manually instead of a service, I get this message:

Code: Select all

20:48:21.296 - [ SEVERE ] > DbManager could not retrive a connection. java.sql.SQLException: Configuration file not found

it.gotoandplay.smartfoxserver.exceptions.DbManagerException: The Test SQL statement failed! Please check your configuration.


I'm currently running a database extension on MySQL, and it works just fine when I run as a service, but when trying running the start.bat I get this error followed by a shutdown.

I'm running a Windows Server btw.

Thanks!

[Lapo]

You have a problem with your test SQL. Double check the syntax, table name etc...

[mistermind]

You have a problem with your test SQL. Double check the syntax, table name etc...

ahmm that doesn't make sense Lapo...
As I said, SFS works fine when I run as a service. It does not work when I run manually.
The problem as you can see does not have anything to do with the Test SQL. The Test SQL statement failed (obviously) because of the first problem:

Code: Select all

20:48:21.296 - [ SEVERE ] > DbManager could not retrive a connection. java.sql.SQLException: Configuration file not found

[craftyfirefox]

I had the exact same Problem.

But I was able to solve it. Just in the two lines above that strange "Configuration file not found", there were the line "DB Manager Activated ( org.gjt.mm.mysql.Driver )" and something like "Couldn't load org.gjt.mm.mysql.Driver" printed

Well, the key was to fix the Classpath given to the shell script so it includes the Classpath of the mysql.jar file. Now it works like a charm.

[mistermind]

awsome!
Thanks craftyfirefox! You saved my life here lol

[Ricky]

Hi ,

i set the classpath for mysql-connector-java-3.2.0-alpha-bin.jar, but still am getting the same error & server getting shutdown can anyone tell how to set exact classpath for this.+

[Lapo]

As suggested in the docs, you could simply put the file in the jre/lib/ext/ folder. (the jre embedded with SFS)

[Ricky]

thanks Lapo....,

Its working....

[p3dro.sola]

As suggested in the docs, you could simply put the file in the jre/lib/ext/ folder. (the jre embedded with SFS)

I'm using SFS Pro for Mac. I did a search, but can't find any "jre" directory.
The server is crashin with:

Code: Select all

2010/04/03 16:59:14.963 - [ SEVERE ] [id: 10] (DbManager.executeQuery): DbManager could not retrive a connection. java.sql.SQLException: Configuration file not found