TCAdmin Error / MySQL

[barracuda]

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.

[HIS-MOTHER]

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.

[barracuda]

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.

[Steven Crothers]

I see the issue quite often with MySQL "going away" under load on Windows.

 

I prefer to use an offloaded Linux MySQL setup, seems to run much more stably.

[barracuda]

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.

[Steven Crothers]

You can install the MYD/MYF (I think its MYF) on your Linux server and provision new access rights to the database.

 

Its "hackish" but it'll work.

[Steven Crothers]

MYI/FRM damn extensions.

[HIS-MOTHER]

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.

[HIS-MOTHER]

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.

[HIS-MOTHER]

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

 

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.

[Steven Crothers]

He would need the password to the database though which he doesn't have

 

I still think his best bet is to tear out the data and re-assemble it on his cPanel box.

[HIS-MOTHER]

He would need the password to the database though which he doesn't have

 

I still think his best bet is to tear out the data and re-assemble it on his cPanel box.

 

Edit my.ini and he now has access.

 

 

That contains the ROOT PW.

 

These files are in plain english unencrypted.

[Steven Crothers]

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?

[HIS-MOTHER]

You can also edit it using this Tutorial.

 

 

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

 

And I was incorrect. 5.1 doesnt contain it in the .ini.

[Steven Crothers]

Just a note, mysqldump does not work (as I thought it wouldn't) if the server is offline.