Page 1 of 1

SFS Pro doesn't start on XP Pro, "cannot start H2 Engin

Posted: 27 Dec 2009, 23:24
by michaell
I downloaded SmartFoxServer Pro demo version onto my Windows XP Pro machine, installed and tried run it, using SmartFoxServerPRO_1.6.6\start.bat file. It generated some output and it threw some exceptions, so that it basically didn't start. I turned off firewall during installation, but that didn't help.

EXCEPTIONS ARE AS FOLLOWS:

C:\Program Files\SmartFoxServerPRO_1.6.6>start.bat >> log.txt
16:59:06.437 - [ INFO ] > Starting h2 engine...
16:59:06.546 - [ WARNING ] > Cannot start H2 Engine: org.h2.jdbc.JdbcSQLExceptio
n: IO Exception: java.net.SocketException: Unrecognized Windows Sockets error: 1
0106: create; port: 9009 ssl: false [90031-60]
org.h2.jdbc.JdbcSQLException: IO Exception: java.net.SocketException: Unrecogniz
ed Windows Sockets error: 10106: create; port: 9009 ssl: false [90031-60]
at org.h2.message.Message.getSQLException(Message.java:84)
at org.h2.message.Message.convertIOException(Message.java:176)
at org.h2.util.NetUtils.createServerSocketTry(NetUtils.java:57)
at org.h2.util.NetUtils.createServerSocket(NetUtils.java:39)
at org.h2.server.TcpServer.start(TcpServer.java:125)
at org.h2.tools.Server.start(Server.java:362)
at it.gotoandplay.smartfoxserver.SmartFoxServer.bootH2Engine(SmartFoxSer
ver.java:530)
at it.gotoandplay.smartfoxserver.SmartFoxServer.run(SmartFoxServer.java:
579)
Caused by: java.net.SocketException: Unrecognized Windows Sockets error: 10106:
create
at java.net.ServerSocket.createImpl(ServerSocket.java:255)
at java.net.ServerSocket.getImpl(ServerSocket.java:205)
at java.net.ServerSocket.bind(ServerSocket.java:319)
at java.net.ServerSocket.<init>(ServerSocket.java:185)
at java.net.ServerSocket.<init>(ServerSocket.java:97)
at org.h2.util.NetUtils.createServerSocketTry(NetUtils.java:51)
... 5 more
16:59:08.812 - [ INFO ] > Default Buddy List Persister <INITED>
16:59:10.000 - [ INFO ] > Zone Extension [ json ] created, for zone:simpleChat
16:59:10.015 - [ INFO ] > Default Buddy List Persister <INITED>
16:59:11.156 - [ INFO ] > Zone Extension [ dbTest ] created, for zone:dbZone
16:59:11.578 - [ INFO ] > Zone Extension [ dbTestAdv ] created, for zone:dbZone
16:59:12.406 - [ INFO ] > Zone Extension [ simpleExt ] created, for zone:dbZone
16:59:12.812 - [ INFO ] > Zone Extension [ loginEx ] created, for zone:loginZone

16:59:13.515 - [ INFO ] > Zone Extension [ slogin ] created, for zone:slogin
16:59:14.390 - [ INFO ] > Zone Extension [ pixel ] created, for zone:pixel
16:59:14.828 - [ INFO ] > Zone Extension [ Letters ] created, for zone:letters
16:59:14.875 - [ INFO ] > Default Buddy List Persister <INITED>
16:59:14.968 - [ INFO ] > Zone Extension [ smsg ] created, for zone:messenger
16:59:15.062 - [ INFO ] > Zone Extension [ imgman ] created, for zone:imgMan
16:59:15.140 - [ SEVERE ] > DbManager could not retrive a connection. org.h2.jdb
c.JdbcSQLException: Connection is broken [90067-60]
it.gotoandplay.smartfoxserver.exceptions.DbManagerException: The Test SQL statem
ent failed! Please check your configuration.
at it.gotoandplay.smartfoxserver.SmartFoxServer.setupZone(SmartFoxServer
.java:1843)
at it.gotoandplay.smartfoxserver.lib.ConfigReader.parse_Zones(ConfigRead
er.java:806)
at it.gotoandplay.smartfoxserver.lib.ConfigReader.readZoneConfig(ConfigR
eader.java:174)
at it.gotoandplay.smartfoxserver.SmartFoxServer.initServerSocket(SmartFo
xServer.java:339)
at it.gotoandplay.smartfoxserver.SmartFoxServer.run(SmartFoxServer.java:
607)
it.gotoandplay.smartfoxserver.exceptions.ConfigurationException: The Test SQL st
atement failed! Please check your configuration.
at it.gotoandplay.smartfoxserver.lib.ConfigReader.readZoneConfig(ConfigR
eader.java:199)
at it.gotoandplay.smartfoxserver.SmartFoxServer.initServerSocket(SmartFo
xServer.java:339)
at it.gotoandplay.smartfoxserver.SmartFoxServer.run(SmartFoxServer.java:
607)

OTHER OUTPUT, which I piped to a log file, is as follows:

|::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::|
| |
| ...::: SmartFoxServer :::... |
| Multiplayer Socket Server |
| version 1.6.6 |
| --- |
| (c) 2004 - 2009 gotoAndPlay() |
| www.smartfoxserver.com |
| www.gotoandplay.it |
| |
|::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::|

::::::::::: { BlueBox INITED } ::::::::::::
: :
: Version 1.0.5 -- (c) 2008 gotoAndPlay() :
: :
:::::::::::::::::::::::::::::::::::::::::::


--- [ System Info ] ------------------------------------------

System CPU(s): 1
VM Max memory: 66 MB

os.name: Windows XP
os.arch: x86
os.version: 5.1
java.version: 1.6.0_13
java.vendor: Sun Microsystems Inc.
java.vendor.url: http://java.sun.com/
java.vm.specification.version: 1.0
java.vm.version: 11.3-b02
java.vm.vendor: Sun Microsystems Inc.
java.vm.name: Java HotSpot(TM) Server VM


--- [ Network Cards ] -----------------------------------------

Card:MS TCP Loopback interface
-> 127.0.0.1
Card:Broadcom 440x 10/100 Integrated Controller - Packet Scheduler Miniport
Card:Dell Wireless 1390 WLAN Mini-Card - Packet Scheduler Miniport
-> (censored)


--- [ Licence Loaded ] ------------------------------------

License Type -> PRO
License Owner -> --== Free Demo Licence ==--
Max. Clients -> 20
BlueBox Type -> Demo Version

--- [ Zones & Rooms ] -------------------------------------

Zone: simpleChat

The Hall (id: 1, max: 50, pass:N)
The Kitchen (id: 2, max: 50, pass:N)
The Garden (id: 3, max: 50, pass:N)
The Bathroom (id: 4, max: 50, pass:N)
The Garage (id: 5, max: 50, pass:N)
The Living Room (id: 6, max: 50, pass:Y)
[jsonSample.as]: JSON Example initialized

Zone: dbZone

MainRoom (id: 7, max: 10, pass:N)
[dbExtension.as]: Initing dbExtension
[dbExtension.as]: DB Manager is not active in this Zone!
[dbExtensionAdv.as]: DB Manager is not active in this Zone!
[simpleExt.as]: Hello from the Simple Extension Example!

Zone: sftris

The Entrance (id: 8, max: 50, pass:N)

Zone: mazeGame

The Entrance (id: 9, max: 50, pass:N)

Zone: loginZone

The Hall (id: 10, max: 50, pass:N)

Zone: multiChat

Main Lobby (id: 11, max: 50, pass:N)

Zone: yahtzee

The Entrance (id: 12, max: 50, pass:N)

Zone: slogin

The Lobby (id: 13, max: 50, pass:N)
The Garden (id: 14, max: 50, pass:N)
The Swimming Pool (id: 15, max: 50, pass:N)

Zone: pixel

The Basement (id: 16, max: 4, pass:N)
[pixelGame.as]: PixelGame extension started!

Zone: letters

Main (id: 17, max: 50, pass:N)
[Letters.as]: Letters script running.

Zone: messenger

Main (id: 18, max: 40, pass:N)

Zone: imgMan

MainLobby (id: 19, max: 50, pass:N)
[imageManager.as]: Image Manager extension starts...

Zone: bomberman

Lobby (id: 20, max: 50, pass:N)

DB Manager Activated ( org.h2.Driver )
Problems in config file: The Test SQL statement failed! Please check your configuration.

Errors found in configuration files.
Unable to start the server.


Shutting down server...

Press any key to continue . . .

Posted: 28 Dec 2009, 00:03
by michaell
additional comments. I saw that this error 10106 is mentioned by many people who had to deal with Java apps using sockets. However, I cannot make any sense of what they are saying, and it seems that few of them actually got it fixed, even though it was in their own code and not in 3rd party app.

In particular, I made sure that I do have the SystemUser variable set correctly and even tried setting it inside the start.bat batch file. That didn't help.

Posted: 29 Dec 2009, 08:15
by Lapo
This is quite new to me and I've never seen this under XP.
I saw that this error 10106 is mentioned by many people who had to deal with Java apps using sockets.
Where did you see this mentioned by many people?

It definitely looks like a socket problem, although it's not clear what's going on. Are you running a personal firewall? If so have you tried disabling it and see if anything changes?

Does your user under XP have admin rights?

Posted: 29 Dec 2009, 08:17
by Lapo

Posted: 29 Dec 2009, 23:34
by michaell
I searched for Java 10106 sockets. There are some forum discussions about this type of errors that seem to have gone nowhere. Perhaps I am the first guy claiming this problem on SFS.

Yes, I did try this as Windows XP Pro admin and with firewall shut down.

I also succeeded in getting it run on another Windows XP Pro machine, thankfully. I have no idea what is the difference between them, if any.