Requesting help to fix the SmartFoxServer connection

[smartfox_n00b]

Hi all,

I am new to the Smartfox Server world and am looking to get it to work with our server. We have hired a cloud server which runs on RHEL 5 (Kernel Linux 2.6.18-194.11.4.el5xen) and are running PHP 5.3.8 with MySQL. We have installed Smartfox Server PRO 1.6.6 on this server.

While uploading the config.xml file to SFSPRO1.6.6/Server, when the value of DatabaseManager active="false", at that time, the SFS Service runs without a problem and shows up in the Running Processes. However, when the DatabaseManager active="true", the service starts, but stops immediately.

Any/All help is appreciated.

The config.xml file looks like this:

<DatabaseManager active="true">
<Driver>org.gjt.mm.mysql.Driver</Driver>
<ConnectionString>jdbc:mysql://IPaddress:3306/dbname</ConnectionString>
<UserName>my_username</UserName>
<Password>the_password</Password>
<TestSQL><![CDATA[SELECT COUNT(*) FROM TABLENAME]]></TestSQL>
<MaxActive>10</MaxActive>
<MaxIdle>10</MaxIdle>
<OnExhaustedPool>fail</OnExhaustedPool>
<BlockTime>5000</BlockTime>
</DatabaseManager>


Steps tried already
After going thru the forums, i have tried to make modifications in the wrapper.conf file, the start.sh file but still didnt work. I have also tried to download a new MySQL connector from the MySQL website with the same results. Another solution found in the forums was to check the location of the MySQL driver. It resides within the SFSPro1.6/jre/lib/ext folder which I gather is the right location.

Unfortunately I do not know where to look for the log file to see wat is goin' on.. Can anyone help me with this?

Is/Are there any steps that I am missing out on?

[smartfox_n00b]

wrapper | --> Wrapper Started as Console
wrapper | Launching a JVM...
jvm 1 | Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.org
jvm 1 | Copyright 1999-2006 Tanuki Software, Inc. All Rights Reserved.
jvm 1 |
jvm 1 | |::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::|
jvm 1 | | |
jvm 1 | | ...::: SmartFoxServer :::... |
jvm 1 | | Multiplayer Socket Server |
jvm 1 | | version 1.6.6 |
jvm 1 | | --- |
jvm 1 | | (c) 2004 - 2009 gotoAndPlay() |
jvm 1 | | www.smartfoxserver.com |
jvm 1 | | www.gotoandplay.it |
jvm 1 | | |
jvm 1 | |::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::|
jvm 1 |
jvm 1 | 06:36:25.485 - [ INFO ] > Starting h2 engine...
jvm 1 |
jvm 1 |
jvm 1 | --- [ System Info ] ------------------------------------------
jvm 1 |
jvm 1 | System CPU(s): 4
jvm 1 | VM Max memory: 517 MB
jvm 1 |
jvm 1 | os.name: Linux
jvm 1 | os.arch: i386
jvm 1 | os.version: 2.6.18-194.11.4.el5xen
jvm 1 | java.version: 1.6.0_13
jvm 1 | java.vendor: Sun Microsystems Inc.
jvm 1 | java.vendor.url: http://java.sun.com/
jvm 1 | java.vm.specification.version: 1.0
jvm 1 | java.vm.version: 11.3-b02
jvm 1 | java.vm.vendor: Sun Microsystems Inc.
jvm 1 | java.vm.name: Java HotSpot(TM) Server VM
jvm 1 |
jvm 1 |
jvm 1 | --- [ Network Cards ] -----------------------------------------
jvm 1 |
jvm 1 | Card:eth1
jvm 1 | -> fe80:0:0:0:4240:5eff:fe5c:573c%3
jvm 1 | -> 10.181.130.25
jvm 1 | Card:eth0
jvm 1 | -> fe80:0:0:0:4240:9fff:fe56:eb73%2
jvm 1 | -> 184.106.80.241
jvm 1 | Card:lo
jvm 1 | -> 0:0:0:0:0:0:0:1%1
jvm 1 | -> 127.0.0.1
jvm 1 |
jvm 1 |
jvm 1 | --- [ Licence Loaded ] ------------------------------------
jvm 1 |
jvm 1 | License Type -> PRO
jvm 1 | License Owner -> --== Free Demo Licence ==--
jvm 1 | Max. Clients -> 20
jvm 1 | BlueBox Type -> Demo Version
jvm 1 |
jvm 1 | --- [ Zones & Rooms ] -------------------------------------
jvm 1 |
jvm 1 | 06:36:26.657 - [ INFO ] > Default Buddy List Persister <INITED>
jvm 1 | DB Manager Activated ( org.gjt.mm.mysql.Driver )
jvm 1 | 06:36:26.843 - [ SEVERE ] > DbManager could not retrive a connection. java.sql.SQLException: Access denied for user 'administrator'@'localhost' (using password: YES)
jvm 1 | it.gotoandplay.smartfoxserver.exceptions.DbManagerException: The Test SQL statement failed! Please check your configuration.
jvm 1 | at it.gotoandplay.smartfoxserver.SmartFoxServer.setupZone(SmartFoxServer.java:1843)
jvm 1 | at it.gotoandplay.smartfoxserver.lib.ConfigReader.parse_Zones(ConfigReader.java:806)
jvm 1 | at it.gotoandplay.smartfoxserver.lib.ConfigReader.readZoneConfig(ConfigReader.java:174)
jvm 1 | at it.gotoandplay.smartfoxserver.SmartFoxServer.initServerSocket(SmartFoxServer.java:339)
jvm 1 | at it.gotoandplay.smartfoxserver.SmartFoxServer.run(SmartFoxServer.java:607)
jvm 1 | Problems in config file: The Test SQL statement failed! Please check your configuration.
jvm 1 | it.gotoandplay.smartfoxserver.exceptions.ConfigurationException: The Test SQL statement failed! Please check your configuration.
jvm 1 | at it.gotoandplay.smartfoxserver.lib.ConfigReader.readZoneConfig(ConfigReader.java:199)
jvm 1 | at it.gotoandplay.smartfoxserver.SmartFoxServer.initServerSocket(SmartFoxServer.java:339)
jvm 1 | at it.gotoandplay.smartfoxserver.SmartFoxServer.run(SmartFoxServer.java:607)
jvm 1 |
jvm 1 | Errors found in configuration files.
jvm 1 | Unable to start the server.
jvm 1 |
jvm 1 |
jvm 1 | Shutting down server...
jvm 1 |
wrapper | <-- Wrapper Stopped

Pls help..

[BigFIsh]

java.sql.SQLException: Access denied for user 'administrator'@'localhost' (using password: YES)

That's pretty much the reason. Make sure you have configured your database correctly. Check permissions and remote access (if required) settings. Try connecting to your database outside of SmartFoxServer as a step to narrow down the issue.