We are running wwwthreads 5.4.3 (yes, old, but usta work) on a military server.

We patched the NT4 server yesterday with a MS04-011 required security update (http://www.microsoft.com/technet/security/bulletin/ms04-011.mspx) Security Update for Microsoft Windows (835732), and now we can no longer get to the wwwthreads site - the error reported is:

DBI->connect(cmrsurvey:callmail.army.mil) failed: Access denied for user: 'administrator@CALLMAIL' to database 'cmrsurvey' at modules/w3t.pm line 516
Content-type: text/htmlSystem Error: DBI->connect(cmrsurvey:callmail.army.mil) failed: Access denied for user: 'administrator@CALLMAIL' to database 'cmrsurvey' at modules/w3t.pm line 516

Neither the userid nor the password has been changed. There are no apparent changes in the mysql databases since the day before the patch.

Are there any suggestions on how to fix this? Besides the removal of the MS04-011 patch (not an option).

TIA
Steve

Steve,

I think you need to go and do this the hard way.

- Locate the folder which the databases are kept (you can look at your my.ini under your WINNT folder).
- Stop MySQL and copy the whole folder as a backup somewhere else.
- Uninstall MySQL completely from the system. Delete any traces of it (also make sure WinMySQLAdmin doesn't run otherwise the folders will not be deleted.
- Download the latest version of MySQL (always a good thing) and install it on the server.
- Reboot the system just to be in the safe side and make sure the service started.
- Try to connect to the database. If it fails, check the my.ini where MySQL thinks that the databases are located. Change the file accordingly to point to the old location of the databases (make sure the service was stopped at that time.
- Start the service again. This should do it really. Also try to connect to the database either through the MSDOS prompt (using the mysql -u(user) -p(password) mysql). That will give you an indication of the username password validity.

If all these fail please let me know and I can tell you a couple more tricks to try and get the system operational.

Thanks. Not sure what was broke, but the steps you suggested, plus changing the root account did the deed.
Your detailed note is much apprecaited.
Steve

No problem. Glad it worked