Sfs 2x not able to connect to MySql database

[xenomorphangel]

i'm having problems connecting SFS 2x to MySql, i followed the tutorial at http://docs2x.smartfoxserver.com/GettingStarted/howtos#item2

but i'm getting

Code: Select all

 >> Zone: Heritage
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

11:34:02,453 ERROR [main] db.SFSDBManager     -
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
Exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException
Message: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driv
er has not received any packets from the server.
Description: The DBManager Test SQL failed
Please double check your SQL code and make sure that Database server is running.

it would be greatly appreciated if some one can direct me to a step by step procedure on how to solve this. does my MySql database port need to be changed? if so how.

SFS 2x RC3 + MySQL version 5.5

[appels]

http://docs2x.smartfoxserver.com/DevelopmentBasics/database-recipes

Did you install the MySQL lib in the right place ?

[xenomorphangel]

if u mean this file: mysql-connector-java-5.1.17-bin.jar

it's in the G:\SFS2X-RC1a\SFS2X\lib

[xenomorphangel]

i realized that the connection string for my setup is jdbc:mysql://localhost:3306/game. now it connects but i’m still getting another error:

Code: Select all

::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
>> Zone: test
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
09:15:07,172 INFO [main] Extensions – {LoginExtension}: Login extension sta
rting.
09:15:07,176 INFO [main] api.SFSApi – Room created: [ Room: AdminRoom, Id:
2, Group: default, isGame: false ]
09:15:07,181 INFO [main] core.AdminToolService – AdminTool Service started
09:15:08,139 INFO [main] http.SFSHttpServer – Http Server started.
09:15:08,177 WARN [main] bootLogger – Was not able to bind socket: { 127.0.
0.1:9933, (Tcp) }
09:15:08,180 ERROR [main] bootLogger – No bound sockets! Check the boot logs
for possible problems!
09:15:08,184 INFO [main] v2.SmartFoxServer – Listening Sockets:
09:15:08,185 INFO [main] v2.SmartFoxServer -

and the boot logs shows:

Code: Select all

24 Sep 2011 09:15:08,153 INFO [main] bootLogger – Session manager ready: com.smartfoxserver.bitswarm.sessions.DefaultSessionManager@1db88745
24 Sep 2011 09:15:08,163 INFO [main] bootLogger – ReaderSelector opened
24 Sep 2011 09:15:08,175 INFO [main] bootLogger – AcceptSelector opened
24 Sep 2011 09:15:08,177 WARN [main] bootLogger – Was not able to bind socket: { 127.0.0.1:9933, (Tcp) }
24 Sep 2011 09:15:08,178 INFO [main] bootLogger – Controller started: com.smartfoxserver.v2.controllers.SystemController — Queue: 0/20000
24 Sep 2011 09:15:08,179 INFO [main] bootLogger – Controller started: com.smartfoxserver.v2.controllers.ExtensionController — Queue: 0/20000
24 Sep 2011 09:15:08,180 INFO [main] bootLogger – IOHandler: com.smartfoxserver.v2.protocol.SFSIoHandler@61ed627d
24 Sep 2011 09:15:08,180 INFO [main] bootLogger – SocketReader started
24 Sep 2011 09:15:08,180 INFO [main] bootLogger – SocketAcceptor initialized
24 Sep 2011 09:15:08,180 ERROR [main] bootLogger – No bound sockets! Check the boot logs for possible problems!
24 Sep 2011 09:15:08,181 INFO [main] bootLogger – Socket Writer started (pool size:1)
24 Sep 2011 09:15:08,181 INFO [Scheduler1-thread-1] bootLogger – Scheduler started: scheduler
24 Sep 2011 09:15:08,182 INFO [main] bootLogger – Security Manager started
24 Sep 2011 09:15:08,183 INFO [main] bootLogger – [[[ ===--- Boot sequence complete ---=== ]]]

[Bax]

It seems you have some issues with your server configuration, as SFS is not able to bind 127.0.0.1

[xenomorphangel]

i solved it. it seems because i did not create exceptions on my windows firewall for SFS default port