Error when starting SFS

GolceaVlad · Post by **GolceaVlad** » 07 Feb 2011, 08:11

Hey guys
I am running SFS with a particularised database.

Config XML :
<DatabaseManager active="true">
<Driver>org.gjt.mm.mysql.Driver</Driver>
<ConnectionString>jdbc:mysql://127.0.0.1:3306/chatzone</ConnectionString>

The driver is in it's place :
jre/lib/ext/org/gjt/mm/mysql/Driver.java

The error I get is :
[url]http://img193.imageshack.us/i/errorwg.jpg/[/url]

Do you have any idea what might be causing this ?

OS : Windows 2003 server
version : SFS Pro

Post by **Lapo** » 07 Feb 2011, 08:43

You should make sure that the test SQL in your config is valid and produces a recordset.

GolceaVlad · Post by **GolceaVlad** » 07 Feb 2011, 15:47

Well, the SQL statement is running well.
I am currently running the same thing on Win 7, same database, same config, same everything ( IP is for local ) , the only difference is that I recently installed Java on the Win 2003 server machine.
It's working in Win 7 perfectly, it won't start on 2003.

Any clues ?

BigFIsh · Post by **BigFIsh** » 07 Feb 2011, 21:27

The beginning of that error stack dump would be of interest to us.

Please paste the entire stack dump. You could copy the stackdump from {your sfs installation path}\Server\logs\wrapper_NNNNNNN.log

GolceaVlad · Post by **GolceaVlad** » 08 Feb 2011, 03:03

Hmmm
Are you certain that's the file ? it seems very odd to me...

http://pastebin.com/3bGDwDfP

BigFIsh · Post by **BigFIsh** » 08 Feb 2011, 04:45

Sorry, you're right. It doesn't contain useful information of the crash.

Try this:
1. Right click in the command prompt
2. Select 'Mark'
3. Mark the entire stack dump of the crash
4. Press 'Enter' to copy the information into your clipboard
5. Paste it here with Code tags.

GolceaVlad · Post by **GolceaVlad** » 08 Feb 2011, 07:29

http://pastebin.com/YLisHfC4

Seems strange to me that it doesn't load the driver, the placement is good and the driver is loaded in Win 7 without problems.

BigFIsh · Post by **BigFIsh** » 08 Feb 2011, 22:57

You'll find that this problem is quite common. Using the search tool, I found: http://forums.smartfoxserver.com/viewtopic.php?t=9410. You may need to add a sql-connector jar file and add reference to it in your start.bat

GolceaVlad · Post by **GolceaVlad** » 09 Feb 2011, 06:26

It works now, thank you !

RockMan · Post by **RockMan** » 09 Feb 2011, 22:07

I have this same same error but idk how to fix it :/