this is now solved will post a h2 -> mysql migration solution a bit later

I have come up with the following commmand hoping to created a back up sql script of the complete h2 database schema so I can determine the smartfox buddy list database and tables:

/home/playbin/www/SFS/SFS_PRO_1.6.2/jre/bin/java -cp h2.jar org.h2.tools.Script -url jdbc:h2:~/INFORMATION_SCHEMA ...

I need to create a backup of the tables specific to the buddylists.


I have already created a custom persister for the AbstractBuddyList as part of our migration from h2 to mysql.

Through talking to Lapo I know that the buddylists use the following table structure:

CREATE TABLE <TableName ...

yes you must also get you provider to remove apache on SFS server to free up the ports.

Yes below exception is thrown every time the server starts.




The first exception seen in the stack trace:
Quote:
INFO | jvm 1 | 2008/03/05 10:57:24 | java.net.ConnectException: Connection refused
INFO | jvm 1 | 2008/03/05 10:57:24 | at sun.nio.ch.Net.connect(Native Method)
INFO | jvm 1 | 2008 ...

I still need some help with this issue guys.

Hi lapo

Smartfox port config:

<ServerIP>127.0.0.1</ServerIP>
<ServerPort>9339</ServerPort>




bluebox.properties:

#:::::::::::::::::::::::::::::::::::::::::::::::::::::::
# {{ SmartFoxServer - BlueBox }}
# Configuration File
# version 1.0
#
# (c) 2004-2007 gotoAndPlay()
# www.smartfoxserver ...

RESOLVED BELOW EXCEPTION THIS IS CAUSED BY USERS TRYING TO CONNECT VIA BLUEBOX WHEN SFS IS IN MIDDLE OF RESTARTING. SOLVED BY REDIRECTING USERS TO HOLDING PAGE WHILST SERVER IS RESTARTING. STILL LOOKING INTO ZOMBIE USERS




tobypb:

I have considered the solution you mentioned but the problem is ...

Hi all, we are having a problem with user connections. It appears that on a regular basis our server will think that a user is logged into a zone/room even if they have no active socket connection and we are left with Zombie user objects that prevent the user from logging in to the server.

These ...

thanks lapo

I have the same problem as above: server version 1.5.5. WHat was the solution???