barracuda Posted November 12, 2009 Share Posted November 12, 2009 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 More sharing options...
HIS-MOTHER Posted November 12, 2009 Share Posted November 12, 2009 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 More sharing options...
barracuda Posted November 12, 2009 Author Share Posted November 12, 2009 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. Link to comment Share on other sites More sharing options...
Steven Crothers Posted November 12, 2009 Share Posted November 12, 2009 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. Link to comment Share on other sites More sharing options...
barracuda Posted November 12, 2009 Author Share Posted November 12, 2009 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 More sharing options...
Steven Crothers Posted November 12, 2009 Share Posted November 12, 2009 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. Link to comment Share on other sites More sharing options...
Steven Crothers Posted November 12, 2009 Share Posted November 12, 2009 MYI/FRM damn extensions. Link to comment Share on other sites More sharing options...
HIS-MOTHER Posted November 12, 2009 Share Posted November 12, 2009 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 More sharing options...
HIS-MOTHER Posted November 12, 2009 Share Posted November 12, 2009 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 More sharing options...
HIS-MOTHER Posted November 12, 2009 Share Posted November 12, 2009 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. Link to comment Share on other sites More sharing options...
Steven Crothers Posted November 12, 2009 Share Posted November 12, 2009 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. Link to comment Share on other sites More sharing options...
HIS-MOTHER Posted November 12, 2009 Share Posted November 12, 2009 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. Link to comment Share on other sites More sharing options...
Steven Crothers Posted November 12, 2009 Share Posted November 12, 2009 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 More sharing options...
HIS-MOTHER Posted November 12, 2009 Share Posted November 12, 2009 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. Link to comment Share on other sites More sharing options...
Steven Crothers Posted November 13, 2009 Share Posted November 13, 2009 Just a note, mysqldump does not work (as I thought it wouldn't) if the server is offline. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.