Hi,
I try to run my first TrinityCore server (on Debian Squeeze). I have an issue and i'm not understand why....
I build a server with the "stable" version in a windows, no problem it's working.
In my Debian, The build work fine (I used this to help me : (http://collab.kpsn.org/display/tc/How-to_Win)
NOTE : I have import the databases from the version under windows.
The authserver works but not the worldserver and I don't know why !
This is logs:
user@debian:~$ cd TrinityCore/bin/bin/
user@debian:~/TrinityCore/bin/bin$ ./authserver
TrinityCore rev. 1970-01-01 00:00:00 +0000 (Archived) (Unix, Release) (authserver)
<Ctrl-C> to stop.
Using configuration file /home/user/TrinityCore/bin/etc/authserver.conf.
OpenSSL 0.9.8o 01 Jun 2010 (Library: OpenSSL 0.9.8o 01 Jun 2010)
Daemon PID: 3239
Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connection s: 1.
MySQL client library: 5.1.66
MySQL server ver: 5.1.66-0+squeeze1
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.1.66
MySQL server ver: 5.1.66-0+squeeze1
Connected to MySQL database at 127.0.0.1
DatabasePool 'auth' opened successfully. 2 total connections running.
Started auth database connection pool.
Updating Realm List...
Added realm "Trinity" at 127.0.0.1:8085.
^CClosing down DatabasePool 'auth'.
Asynchronous connections on DatabasePool 'auth' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'auth' closed.
Halting process...
user@debian:~/TrinityCore/bin/bin$ ./worldserver
Using configuration file /home/user/TrinityCore/bin/etc/worldserver.conf.
Using SSL version: OpenSSL 0.9.8o 01 Jun 2010 (library: OpenSSL 0.9.8o 01 Jun 20 10)
Using ACE version: 6.0.3
TrinityCore rev. 1970-01-01 00:00:00 +0000 (Archived) (Unix, Release) (worldserver-daemon)
<Ctrl-C> to stop.
______ __
/__ _ __ __/ __
/_/ / _ __ /_ ___ /_ , _ __ __
/`'__/ /' _ `/ / / /
/ / / _ _
_ _ _ _ _ _ __/`____
/_//_/ /_//_//_//_//__/ `/___/>
C O R E /___/
http://TrinityCore.org /__/
Daemon PID: 3243
In mysql_stmt_prepare() id: 58, sql: "SELECT c.country FROM ip2nationCountries c , ip2nation i WHERE i.ip < ? AND c.code = i.country ORDER BY i.ip DESC LIMIT 0,1 "
Table 'world.ip2nationCountries' doesn't exist
DatabasePool world NOT opened. There were errors opening the MySQL connections.
Check your SQLDriverLogFile for specific errors.
Cannot connect to world database 127.0.0.1;3306;trinity;*********;world
user@debian:~/TrinityCore/bin/bin$
OK, I check in my .conf, no config problem.
OK, it said : "The table ip2nationCountries" doesn't exist, I check, the table exist and not broken
it said "Cannot connect to world database" but my trinity user have GRANT ALL on my world database.
And there is no "SQLDriverLogFile" in my logs folder
I try to rebuild the server, change the mysql user with root, restart the machine, but nothing work
Where is the problem? Why authserver can connect to MySQL and worldserver not?
regards
