Hi, i have a game and i get a error when i change the databaseManager to "true". can someone help me to fix that?
Posted: 13 Sep 2016, 01:14
here is the config.xml
<!--
Zones Configuration.
-->
<Zones>
<Zone name="virtualworld" customLogin="false" buddyList="20">
<Rooms>
<Room name="Lobby" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" />
</Rooms>
<Extensions>
<extension name="virtualWorld" className="virtualworld.as" type="script" />
</Extensions>
<DatabaseManager active="true">
<Driver>org.gjt.mm.mysql.Driver</Driver>
<ConnectionString>jdbc:mysql://127.0.0.1:3306/flash_virtual_world</ConnectionString>
<UserName>root</UserName>
<Password>root</Password>
<TestSQL><![CDATA[SELECT NOW()]]></TestSQL>
<MaxActive>10</MaxActive>
<MaxIdle>10</MaxIdle>
<OnExhaustedPool>fail</OnExhaustedPool>
<BlockTime>5000</BlockTime>
</DatabaseManager>
</Zone>
<Zone name="simpleChat" uCountUpdate="true" buddyList="20" maxUsers="4000" customLogin="false">
<Rooms>
<Room name="The Hall" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" uCountUpdate="true" />
<Room name="The Kitchen" maxUsers="50" isPrivate="false" isGame="false" isTemp="false" />
<Room name="The Garden" maxUsers="50" isPrivate="false" isTemp="false" />
<Room name="The Bathroom" maxUsers="50" isPrivate="false" isTemp="false" />
<Room name="The Garage" maxUsers="50" isPrivate="false" isTemp="false" />
<Room name="The Living Room" maxUsers="50" isPrivate="true" isTemp="false" pwd="test" />
</Rooms>
<Extensions>
<extension name="json" className="jsonSample.as" type="script" />
</Extensions>
<Moderators status="on">
<Mod name="modName" pwd="modPass" />
</Moderators>
</Zone>
<Zone name="dbZone" customLogin="false" buddyList="20">
<Rooms>
<Room name="MainRoom" maxUsers="10" isPrivate="false" isTemp="false" autoJoin="true" />
</Rooms>
<Extensions>
<extension name="dbTest" className="dbExtension.as" type="script" />
<extension name="dbTestAdv" className="dbExtensionAdv.as" type="script" />
<extension name="simpleExt" className="simpleExt.as" type="script" />
</Extensions>
<DatabaseManager active="false">
<Driver>sun.jdbc.odbc.JdbcOdbcDriver</Driver>
<ConnectionString>jdbc:odbc:sfsTest</ConnectionString>
<!--
Example connecting to MySQL
<Driver>org.gjt.mm.mysql.Driver</Driver>
<ConnectionString>jdbc:mysql://192.168.0.1:3306/sfsTest</ConnectionString>
-->
<UserName>yourname</UserName>
<Password>yourpassword</Password>
<TestSQL><![CDATA[SELECT COUNT(*) FROM contacts]]></TestSQL>
<MaxActive>10</MaxActive>
<MaxIdle>10</MaxIdle>
<OnExhaustedPool>fail</OnExhaustedPool>
<BlockTime>5000</BlockTime>
</DatabaseManager>
</Zone>
<Zone name="sftris" emptyNames="true">
<Rooms>
<Room name="The Entrance" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" />
</Rooms>
</Zone>
<Zone name="mazeGame">
<Rooms>
<Room name="The Entrance" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" />
</Rooms>
</Zone>
<Zone name="loginZone" emptyNames="false" customLogin="true">
<Rooms>
<Room name="The Hall" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" />
</Rooms>
<Extensions>
<extension name="loginEx" className="loginExample.as" type="script" />
</Extensions>
</Zone>
<Zone name="multiChat">
<Rooms>
<Room name="Main Lobby" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" />
</Rooms>
</Zone>
<Zone name="yahtzee">
<Rooms>
<Room name="The Entrance" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" />
</Rooms>
</Zone>
<Zone name="slogin" emptyNames="false" customLogin="true">
<Rooms>
<Room name="The Lobby" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" />
<Room name="The Garden" maxUsers="50" isPrivate="false" isTemp="false" />
<Room name="The Swimming Pool" maxUsers="50" isPrivate="false" isTemp="false" />
</Rooms>
<Extensions>
<extension name="slogin" className="secureLogin.as" type="script" />
</Extensions>
</Zone>
<Zone name="pixel" uCountUpdate="true" customLogin="true">
<Rooms>
<Room name="The Basement" maxUsers="4" isPrivate="false" isGame="false" isTemp="false" />
</Rooms>
<Extensions>
<extension name="pixel" className="pixelGame.as" type="script" />
<!--
To use the java extension instead of the Actionscript one substitute the above line with this:
<extension name="pixel" className="it.gotoandplay.extensions.examples.PixelGame" type="java" />
-->
</Extensions>
</Zone>
<Zone name="letters">
<Rooms>
<Room name="Main" maxUsers="50" autoJoin="true" />
</Rooms>
<Extensions>
<extension name="Letters" className="Letters.as" type="script" />
</Extensions>
</Zone>
<Zone name="messenger" customLogin="true" buddyList="200">
<MaxBuddyVars>2</MaxBuddyVars>
<Rooms>
<Room name="Main" autoJoin="true" limbo="true"/>
</Rooms>
<Extensions>
<extension name="smsg" className="smartMessenger.as" type="script" />
</Extensions>
</Zone>
<Zone name="imgMan" emptyNames="true">
<AutoReloadExtensions>true</AutoReloadExtensions>
<Rooms>
<Room name="MainLobby" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" />
</Rooms>
<Extensions>
<extension name="imgman" className="imageManager.as" type="script"></extension>
</Extensions>
</Zone>
<Zone name="bomberman" emptyNames="true">
<Rooms>
<Room name="Lobby" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" />
</Rooms>
</Zone>
<Zone name="h2dbzone" customLogin="false">
<AutoReloadExtensions>true</AutoReloadExtensions>
<Rooms>
<Room name="Lobby" maxUsers="10" isPrivate="false" isTemp="false" autoJoin="true" />
</Rooms>
<DatabaseManager active="true">
<Driver>org.h2.Driver</Driver>
<ConnectionString>jdbc:h2:tcp://localhost:9009/examples</ConnectionString>
<UserName>sa</UserName>
<Password></Password>
<TestSQL><![CDATA[SELECT COUNT(*) FROM retrocomputers]]></TestSQL>
<MaxActive>10</MaxActive>
<MaxIdle>10</MaxIdle>
<OnExhaustedPool>fail</OnExhaustedPool>
<BlockTime>5000</BlockTime>
</DatabaseManager>
<Extensions>
<extension name="h2db_ext" className="internalDbDemo.as" type="script" />
</Extensions>
</Zone>
<Zone name="advBuddyList">
<BuddyList active="true">
<size>200</size>
<maxBuddyVariables>5</maxBuddyVariables>
<mode>advanced</mode>
<!-- Apply only for advanced mode -->
<offLineBuddyVariables>true</offLineBuddyVariables>
<permissionTimeOut>10</permissionTimeOut>
<mutualAddBuddy>true</mutualAddBuddy>
<mutualRemoveBuddy>true</mutualRemoveBuddy>
</BuddyList>
<Rooms>
<Room name="Lobby" autoJoin="true" limbo="true" maxUsers="10000"/>
</Rooms>
</Zone>
<Zone name="sloader">
<Rooms>
<Room name="Lobby" autoJoin="true" limbo="true" maxUsers="10000"/>
</Rooms>
<Extensions>
<extension name="loader" className="it.gotoandplay.extensions.examples.SocketFileLoader" type="java" />
</Extensions>
</Zone>
<Zone name="SmartVideoClipPlayer" uCountUpdate="true" maxUsers="50" customLogin="false">
<Rooms>
<Room name="The Lobby" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" uCountUpdate="true" />
</Rooms>
<Extensions>
<extension name="__$RedBox$__" className="com.smartfoxserver.redbox.RedBoxExtension" type="java" />
</Extensions>
</Zone>
<Zone name="SmartMessengerAV" customLogin="true" buddyList="200">
<MaxBuddyVars>2</MaxBuddyVars>
<Rooms>
<Room name="Main" autoJoin="true" limbo="true"/>
</Rooms>
<Extensions>
<extension name="smsg" className="smartMessenger.as" type="script" />
<extension name="__$RedBox$__" className="com.smartfoxserver.redbox.RedBoxExtension" type="java" />
</Extensions>
</Zone>
<Zone name="SmartChatAV" uCountUpdate="true" maxUsers="4000" customLogin="false">
<Rooms>
<Room name="The Hall" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" uCountUpdate="true" />
<Room name="The Kitchen" maxUsers="50" isPrivate="false" isTemp="false" />
<Room name="The Garden" maxUsers="50" isPrivate="false" isTemp="false" />
<Room name="The Bathroom" maxUsers="50" isPrivate="false" isTemp="false" />
<Room name="The Garage" maxUsers="50" isPrivate="false" isTemp="false" />
</Rooms>
<Extensions>
<extension name="__$RedBox$__" className="com.smartfoxserver.redbox.RedBoxExtension" type="java" />
</Extensions>
</Zone>
<Zone name="SmartVideoConference" uCountUpdate="true" maxUsers="4000" customLogin="false">
<Rooms>
<Room name="Conference hall 1" maxUsers="10" isPrivate="false" isTemp="false" autoJoin="true" />
<Room name="Conference hall 2" maxUsers="10" isPrivate="false" isGame="false" isTemp="false" />
<Room name="Conference hall 3" maxUsers="10" isPrivate="false" isGame="false" isTemp="false" />
</Rooms>
</Zone>
<Zone name="openspace" uCountUpdate="true" maxUsers="200" customLogin="false">
<Rooms>
<Room name="Ranch (inside)" maxUsers="50" isPrivate="false" isTemp="false" uCountUpdate="true" />
<Room name="Ranch (outside)" maxUsers="50" isPrivate="false" isTemp="false" uCountUpdate="true" />
<Room name="Slopes area" maxUsers="50" isPrivate="false" isTemp="false" uCountUpdate="true" />
</Rooms>
</Zone>
</Zones>
</SmartFoxConfig>
this is the error
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)
Problems in config file: The Test SQL statement failed! Please check your config
uration.
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)
Errors found in configuration files.
Unable to start the server.
Shutting down server...
I have a Mac computer and I am using smartfoxserver Pro 1.6.6. With My SQL connector and Mamp phpadmin
<!--
Zones Configuration.
-->
<Zones>
<Zone name="virtualworld" customLogin="false" buddyList="20">
<Rooms>
<Room name="Lobby" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" />
</Rooms>
<Extensions>
<extension name="virtualWorld" className="virtualworld.as" type="script" />
</Extensions>
<DatabaseManager active="true">
<Driver>org.gjt.mm.mysql.Driver</Driver>
<ConnectionString>jdbc:mysql://127.0.0.1:3306/flash_virtual_world</ConnectionString>
<UserName>root</UserName>
<Password>root</Password>
<TestSQL><![CDATA[SELECT NOW()]]></TestSQL>
<MaxActive>10</MaxActive>
<MaxIdle>10</MaxIdle>
<OnExhaustedPool>fail</OnExhaustedPool>
<BlockTime>5000</BlockTime>
</DatabaseManager>
</Zone>
<Zone name="simpleChat" uCountUpdate="true" buddyList="20" maxUsers="4000" customLogin="false">
<Rooms>
<Room name="The Hall" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" uCountUpdate="true" />
<Room name="The Kitchen" maxUsers="50" isPrivate="false" isGame="false" isTemp="false" />
<Room name="The Garden" maxUsers="50" isPrivate="false" isTemp="false" />
<Room name="The Bathroom" maxUsers="50" isPrivate="false" isTemp="false" />
<Room name="The Garage" maxUsers="50" isPrivate="false" isTemp="false" />
<Room name="The Living Room" maxUsers="50" isPrivate="true" isTemp="false" pwd="test" />
</Rooms>
<Extensions>
<extension name="json" className="jsonSample.as" type="script" />
</Extensions>
<Moderators status="on">
<Mod name="modName" pwd="modPass" />
</Moderators>
</Zone>
<Zone name="dbZone" customLogin="false" buddyList="20">
<Rooms>
<Room name="MainRoom" maxUsers="10" isPrivate="false" isTemp="false" autoJoin="true" />
</Rooms>
<Extensions>
<extension name="dbTest" className="dbExtension.as" type="script" />
<extension name="dbTestAdv" className="dbExtensionAdv.as" type="script" />
<extension name="simpleExt" className="simpleExt.as" type="script" />
</Extensions>
<DatabaseManager active="false">
<Driver>sun.jdbc.odbc.JdbcOdbcDriver</Driver>
<ConnectionString>jdbc:odbc:sfsTest</ConnectionString>
<!--
Example connecting to MySQL
<Driver>org.gjt.mm.mysql.Driver</Driver>
<ConnectionString>jdbc:mysql://192.168.0.1:3306/sfsTest</ConnectionString>
-->
<UserName>yourname</UserName>
<Password>yourpassword</Password>
<TestSQL><![CDATA[SELECT COUNT(*) FROM contacts]]></TestSQL>
<MaxActive>10</MaxActive>
<MaxIdle>10</MaxIdle>
<OnExhaustedPool>fail</OnExhaustedPool>
<BlockTime>5000</BlockTime>
</DatabaseManager>
</Zone>
<Zone name="sftris" emptyNames="true">
<Rooms>
<Room name="The Entrance" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" />
</Rooms>
</Zone>
<Zone name="mazeGame">
<Rooms>
<Room name="The Entrance" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" />
</Rooms>
</Zone>
<Zone name="loginZone" emptyNames="false" customLogin="true">
<Rooms>
<Room name="The Hall" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" />
</Rooms>
<Extensions>
<extension name="loginEx" className="loginExample.as" type="script" />
</Extensions>
</Zone>
<Zone name="multiChat">
<Rooms>
<Room name="Main Lobby" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" />
</Rooms>
</Zone>
<Zone name="yahtzee">
<Rooms>
<Room name="The Entrance" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" />
</Rooms>
</Zone>
<Zone name="slogin" emptyNames="false" customLogin="true">
<Rooms>
<Room name="The Lobby" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" />
<Room name="The Garden" maxUsers="50" isPrivate="false" isTemp="false" />
<Room name="The Swimming Pool" maxUsers="50" isPrivate="false" isTemp="false" />
</Rooms>
<Extensions>
<extension name="slogin" className="secureLogin.as" type="script" />
</Extensions>
</Zone>
<Zone name="pixel" uCountUpdate="true" customLogin="true">
<Rooms>
<Room name="The Basement" maxUsers="4" isPrivate="false" isGame="false" isTemp="false" />
</Rooms>
<Extensions>
<extension name="pixel" className="pixelGame.as" type="script" />
<!--
To use the java extension instead of the Actionscript one substitute the above line with this:
<extension name="pixel" className="it.gotoandplay.extensions.examples.PixelGame" type="java" />
-->
</Extensions>
</Zone>
<Zone name="letters">
<Rooms>
<Room name="Main" maxUsers="50" autoJoin="true" />
</Rooms>
<Extensions>
<extension name="Letters" className="Letters.as" type="script" />
</Extensions>
</Zone>
<Zone name="messenger" customLogin="true" buddyList="200">
<MaxBuddyVars>2</MaxBuddyVars>
<Rooms>
<Room name="Main" autoJoin="true" limbo="true"/>
</Rooms>
<Extensions>
<extension name="smsg" className="smartMessenger.as" type="script" />
</Extensions>
</Zone>
<Zone name="imgMan" emptyNames="true">
<AutoReloadExtensions>true</AutoReloadExtensions>
<Rooms>
<Room name="MainLobby" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" />
</Rooms>
<Extensions>
<extension name="imgman" className="imageManager.as" type="script"></extension>
</Extensions>
</Zone>
<Zone name="bomberman" emptyNames="true">
<Rooms>
<Room name="Lobby" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" />
</Rooms>
</Zone>
<Zone name="h2dbzone" customLogin="false">
<AutoReloadExtensions>true</AutoReloadExtensions>
<Rooms>
<Room name="Lobby" maxUsers="10" isPrivate="false" isTemp="false" autoJoin="true" />
</Rooms>
<DatabaseManager active="true">
<Driver>org.h2.Driver</Driver>
<ConnectionString>jdbc:h2:tcp://localhost:9009/examples</ConnectionString>
<UserName>sa</UserName>
<Password></Password>
<TestSQL><![CDATA[SELECT COUNT(*) FROM retrocomputers]]></TestSQL>
<MaxActive>10</MaxActive>
<MaxIdle>10</MaxIdle>
<OnExhaustedPool>fail</OnExhaustedPool>
<BlockTime>5000</BlockTime>
</DatabaseManager>
<Extensions>
<extension name="h2db_ext" className="internalDbDemo.as" type="script" />
</Extensions>
</Zone>
<Zone name="advBuddyList">
<BuddyList active="true">
<size>200</size>
<maxBuddyVariables>5</maxBuddyVariables>
<mode>advanced</mode>
<!-- Apply only for advanced mode -->
<offLineBuddyVariables>true</offLineBuddyVariables>
<permissionTimeOut>10</permissionTimeOut>
<mutualAddBuddy>true</mutualAddBuddy>
<mutualRemoveBuddy>true</mutualRemoveBuddy>
</BuddyList>
<Rooms>
<Room name="Lobby" autoJoin="true" limbo="true" maxUsers="10000"/>
</Rooms>
</Zone>
<Zone name="sloader">
<Rooms>
<Room name="Lobby" autoJoin="true" limbo="true" maxUsers="10000"/>
</Rooms>
<Extensions>
<extension name="loader" className="it.gotoandplay.extensions.examples.SocketFileLoader" type="java" />
</Extensions>
</Zone>
<Zone name="SmartVideoClipPlayer" uCountUpdate="true" maxUsers="50" customLogin="false">
<Rooms>
<Room name="The Lobby" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" uCountUpdate="true" />
</Rooms>
<Extensions>
<extension name="__$RedBox$__" className="com.smartfoxserver.redbox.RedBoxExtension" type="java" />
</Extensions>
</Zone>
<Zone name="SmartMessengerAV" customLogin="true" buddyList="200">
<MaxBuddyVars>2</MaxBuddyVars>
<Rooms>
<Room name="Main" autoJoin="true" limbo="true"/>
</Rooms>
<Extensions>
<extension name="smsg" className="smartMessenger.as" type="script" />
<extension name="__$RedBox$__" className="com.smartfoxserver.redbox.RedBoxExtension" type="java" />
</Extensions>
</Zone>
<Zone name="SmartChatAV" uCountUpdate="true" maxUsers="4000" customLogin="false">
<Rooms>
<Room name="The Hall" maxUsers="50" isPrivate="false" isTemp="false" autoJoin="true" uCountUpdate="true" />
<Room name="The Kitchen" maxUsers="50" isPrivate="false" isTemp="false" />
<Room name="The Garden" maxUsers="50" isPrivate="false" isTemp="false" />
<Room name="The Bathroom" maxUsers="50" isPrivate="false" isTemp="false" />
<Room name="The Garage" maxUsers="50" isPrivate="false" isTemp="false" />
</Rooms>
<Extensions>
<extension name="__$RedBox$__" className="com.smartfoxserver.redbox.RedBoxExtension" type="java" />
</Extensions>
</Zone>
<Zone name="SmartVideoConference" uCountUpdate="true" maxUsers="4000" customLogin="false">
<Rooms>
<Room name="Conference hall 1" maxUsers="10" isPrivate="false" isTemp="false" autoJoin="true" />
<Room name="Conference hall 2" maxUsers="10" isPrivate="false" isGame="false" isTemp="false" />
<Room name="Conference hall 3" maxUsers="10" isPrivate="false" isGame="false" isTemp="false" />
</Rooms>
</Zone>
<Zone name="openspace" uCountUpdate="true" maxUsers="200" customLogin="false">
<Rooms>
<Room name="Ranch (inside)" maxUsers="50" isPrivate="false" isTemp="false" uCountUpdate="true" />
<Room name="Ranch (outside)" maxUsers="50" isPrivate="false" isTemp="false" uCountUpdate="true" />
<Room name="Slopes area" maxUsers="50" isPrivate="false" isTemp="false" uCountUpdate="true" />
</Rooms>
</Zone>
</Zones>
</SmartFoxConfig>
this is the error
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)
Problems in config file: The Test SQL statement failed! Please check your config
uration.
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)
Errors found in configuration files.
Unable to start the server.
Shutting down server...
I have a Mac computer and I am using smartfoxserver Pro 1.6.6. With My SQL connector and Mamp phpadmin