Jump to content

TCAdmin Error / MySQL


barracuda

Recommended Posts

ExecuteReader requires an open and available Connection. The connection's current state is closed. 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 = 'jeffery'

 

I've got that error, And. I'm very aware of how to fix the issue. It's the MySQL Service that had been stoped. I go to re-launch the service and it requests a password. I nor no one else knows this password. Any idea about the how - to's of to reset the password with out re-doing MySQL and prevent from losing the database. - That's last step we want to take.

Link to comment
Share on other sites

ExecuteReader requires an open and available Connection. The connection's current state is closed. 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 = 'jeffery'

 

I've got that error, And. I'm very aware of how to fix the issue. It's the MySQL Service that had been stoped. I go to re-launch the service and it requests a password. I nor no one else knows this password. Any idea about the how - to's of to reset the password with out re-doing MySQL and prevent from losing the database. - That's last step we want to take.

 

my.ini file inside your SQL install has the root password where it can be reset.

 

 

Just a bit of info.

 

Yesterday we had the same issues but it wasn't a security issue, it was just that SQL server kept shutting down and was tossing all kinds of errors.

 

Our resolution.............

 

Uninstall TCA on master.. Uninstall SQL , Reinstall SQL, Reinstall TCA, Import Backup DB.

 

Boom Back in business............ :)

 

You should also make sure you always have automated backups of your SQL DB and save it offsite. Makes life OH SO MUCH MORE PLEASANT.

Link to comment
Share on other sites

Yeah, As it seems the MySQL I've noticed is a lot more reliable on Linux Servers. Our Website is ran using cPanel / Linux so as it seems you do bring that up and sounds quite a nice idea to run it off there it would possibly save some trouble. I'm worried about getting this restored and back online and then I'll take that into consideration.

Link to comment
Share on other sites

Just create a sql backup.

 

 

Put this in a bat file and put it in your sql bin folder and run it.

 

@echo off
echo Starting Backup of Database: %1

For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set dt=%%c-%%a-%%b)
For /f "tokens=1-4 delims=:." %%a in ('echo %time%') do (set tm=%%a%%b)
set bkupfilename=%1 %dt%-%tm%.sql
echo Backing up to file: %bkupfilename%

mysqldump %1 --routines -uYOURDBUSERNAME -pYOURDBPASSWORD tcadmin > C:\SQL_Backups\"%bkupfilename%"

echo Backup Complete!

echo on

 

Edit this line

 

C:\SQL_Backups\

and of course the username and password.

 

 

 

To a path and folder you created. Or just make a SQL_BACKUPS folder on your C: drive and it will dump to there.

 

SQL server does not need to be running for it to create this backup.

Link to comment
Share on other sites

Just create a sql backup.

 

 

Put this in a bat file and put it in your sql bin folder and run it.

 

@echo off
echo Starting Backup of Database: %1

For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set dt=%%c-%%a-%%b)
For /f "tokens=1-4 delims=:." %%a in ('echo %time%') do (set tm=%%a%%b)
set bkupfilename=%1 %dt%-%tm%.sql
echo Backing up to file: %bkupfilename%

mysqldump %1 --routines -uYOURDBUSERNAME -pYOURDBPASSWORD tcadmin > C:\SQL_Backups\"%bkupfilename%"

echo Backup Complete!

echo on

 

Edit this line

 

C:\SQL_Backups\

and of course the username and password.

 

 

 

To a path and folder you created. Or just make a SQL_BACKUPS folder on your C: drive and it will dump to there.

 

SQL server does not need to be running for it to create this backup. ;)

Link to comment
Share on other sites

Where exactly is the my.ini file located at? I'm not too lets say fimilar with MySQL I'm use to PHPMyAdmin to make life so much easier.

 

It should be in a similar path to this.

 

C:\Program Files\MySQL\MySQL Server 5.1\my.ini :D

 

Install MYSQL GUI tools.. Has a admin and a backup feature but SQL server must be running for it to connect.

 

Just use the .bat I posted and your all good.

Link to comment
Share on other sites

I was unaware that you could override the root password with the my.ini successfully...

 

I always assumed you must use an init sql script and launch it via console for a second.

 

EDIT: Actually, I can't find anything on the subject about a my.ini root takeover.... what version of MySQL are you running? Perhaps thats a legacy argument in the my.ini?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Terms of Use