2009-07-15 22:07:52 UTC
ps.. Ignore the above post.. Upgrading mysql driver doesnt fix the 'Cannot Connect to Server' Issue..
After investigating/googling some more, it appears that by default MySQL closes the db connection after 8 hours of non-use.. So after 8 hours if a user connets to the game server they are thrown out.. (This is consistent with my initial findings)..
Have added ?autoReconnect=true to the MySQL URL.. A few forum posts suggest this fixes the issue.. (Will test tomorrow, after 8 hours of non-use... Fingers crossed).