Alright, I realise you get support threads about this topic every single day. Typically this is something id easily be able to solve on my own, but thanks to Spp building that lovely new logging system and refusing to revert it; all my logs are broken despite setting them up to the best of my ability.
Ive compiled on windows over the past few months very successfully on a heap of different commits, compiled on Debian as of two years ago. Everything's usually fine.
This time we're trying it on Ubuntu 12.04 LTS 64-bit. MySQL server is running on the same box fine and im connecting to it no problem remotely from heidi and querying it no problem. The World/Auth/Character databases are exported from a mysql server running on windows - don't think this should have been a problem. I also believe ive applied all the updates; I checked the updates folder in the older source I previously was using on the windows server then checked the updates folder in the mmaps source id pulled onto the ubuntu server and simply applied any ones that didnt exist in the older source in order to hopefully catch all the "new" updates.
Created a new mysql user with all privileges and a password I was certain of; made sure it was correct in the configs.
Cant think of much else I can do, however; every time I go to start authserver, it fails to start. Can only manage to get it to log Auth.log which gives the output:
TrinityCore rev. 2012-08-31 14:48:10 -0500 (a8d514914be2+) (Unix, Release) (authserver)
<Ctrl-C> to stop.
Using configuration file /usr/local/etc/authserver.conf.
OpenSSL 1.0.1 14 Mar 2012 (Library: OpenSSL 1.0.1 14 Mar 2012)
Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.
Could not connect to MySQL database at 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111)
Could not connect to MySQL database at 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111)
DatabasePool auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Unable to get SQLDriver.log to log for authserver so I thought I might try to get it to log for worldserver, on starting worldserver im getting, for Server.log;
Using configuration file /usr/local/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.1 14 Mar 2012 (library: OpenSSL 1.0.1 14 Mar 2012)
Using ACE version: 6.0.0
TrinityCore rev. 2012-08-31 14:48:10 -0500 (a8d514914be2+) (Unix, Release) (worldserver-daemon)
<Ctrl-C> to stop.
______ __
/\__ _\ __ __/\ \__
\/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
C O R E /\___/
http://TrinityCore.org \/__/
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
Cannot connect to world database 127.0.0.1;3306;USER-HIDDEN;PASSWORD-HIDDEN;world
And all I can force SQLDriver.log to give me is:
2012-09-03_19:14:32 ERROR [SQL DRIVER] DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Which is rather hilarious if im honest...
Anyway. If anyone can give me any ideas as to why this might not be working or could advise me on how to give the bastardised logger system the kick it needs to give me more information - don't hesitate. Given up now - at a loss as to what to do.
