Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Aug 2001
Posts: 2
Lurker
Lurker
Offline
Joined: Aug 2001
Posts: 2
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

Sponsored Links
Joined: Aug 2002
Posts: 1,191
Kahuna
Kahuna
Joined: Aug 2002
Posts: 1,191
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.


Nikos
Joined: Aug 2001
Posts: 2
Lurker
Lurker
Offline
Joined: Aug 2001
Posts: 2
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

Joined: Aug 2002
Posts: 1,191
Kahuna
Kahuna
Joined: Aug 2002
Posts: 1,191
No problem. Glad it worked


Nikos

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Posts: 70
Joined: January 2007
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)