Marcin Posted January 15, 2014 Share Posted January 15, 2014 Hi all, I wonder if someone will be able to help me. I'm moving master server to new hardware with W2012R2 installed and it seems it can't connect to old mysql database correctly. I'm receiving connection error when connecting to exisitng database: Object reference not set to an instance of an object. SQL Command: SELECT USER_ID, FIRST_NAME, LAST_NAME, PASSWORD, TYPE, ADDRESS1, ADDRESS2, ADDRESS3, CITY, STATE, COUNTRY, ZIP, HOME_PHONE, MOBILE_PHONE, EMAIL1, EMAIL2, STATUS, PARENT_ACCOUNT, EXTERNAL_ID, BILLING_ID, BILLING_STATUS, GROUP_ID, FILE_SERVER_ACCOUNT, ALLOWED_IPS, SUBUSER_ACCESS_SUPPORT, FILE_SERVER_CUSTOM_GAMES, MD5_PASSWORD FROM TC_USERS WHERE USER_ID = '' As soon as I will reinitialize database using TCAdmin config (start with empty/fresh) I can connect and login into it without any problems. Database is located on a 2nd server running Centos, so it's completely independent from old server. Regards, Marcin Link to comment Share on other sites More sharing options...
dimitrifrom31 Posted January 16, 2014 Share Posted January 16, 2014 does your user have remote mysql access for the "old" database? Try to connect from mysql client , alternatively dump the database and import it on a local mysql server on your new master. Link to comment Share on other sites More sharing options...
Marcin Posted January 16, 2014 Author Share Posted January 16, 2014 I created empty database and configured master monitor with it - database has been initialize correctly and I've been able to connect to it as admin. As soon as I imported sql file into that database I had the same error again when I tried to login from TCAdmin interface. In both cases I can connect from mysql admistrator to remote database. Link to comment Share on other sites More sharing options...
Marcin Posted January 17, 2014 Author Share Posted January 17, 2014 All sorted out. Link to comment Share on other sites More sharing options...
Raizio Posted January 17, 2014 Share Posted January 17, 2014 Do tell what the end issue and solution was. Someone else might run into it too. Link to comment Share on other sites More sharing options...
Marcin Posted January 17, 2014 Author Share Posted January 17, 2014 Wrong permissions for web files. Link to comment Share on other sites More sharing options...
Raizio Posted January 17, 2014 Share Posted January 17, 2014 Wow, didn't expect that to be the issue, what a twist. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.