Cannot connect to SQL

محروم.كوم · #1 07-28-2009, 03:50 AM

History: My forum has been running for ages and is a bit aged too. Sadly I have a special hack which would have to be totally rewritten so I’m stuck where I am now. Over the years there’s been a lot of people poking fingers in the pie and this server is well and goodly messed up. For instance, cpanel doesn’t work at all, so I can’t use any of those tools. It’s command line linux native commands and editing config files only.

Current Issue: A week or so ago the server barfed, I asked the host for help and they ran a command I specifically told them not to, went from barfed to all http destroyed. Of course after the employee did this he promptly clocked out and went on vacation for 3 days. When he got back he was able to restore the files he trashed – something everyone else said was impossible.
Took me about an hour of poking around to figure out and fix the problem. All was good, or so I thought, then I ran a repair/optimize and this trashed the forum…because it ran out of disk space and damaged the tables.

So I cleared off some space, but the tables had been corrupted. When I tried to log into sql and fix it the root password was not known, so I reset the root password for mysql to match the root password.

Seems this busted the forum but good, now all I get are , can’t even get into the admin panel.
Link-ID == false, connect failed
mysql error:

mysql error number: 0

Which I think tells me that vBulletin can’t connect to mysql.

So I poked around a little more and found that the /include/config.php has the $dbusername set to ‘root’ and $dbpassword set to something cryptic, which obviously doesn’t match what I set root’s mysql password to.

So I edited the config.php and I've set it to the root password we used, this doesn't work. NO joy.
I've set the root password back to the one listed in the config.php file, that doesn't work.
Finally I set the root mysql password back to the root password, changed the config.php back to the root password and exited. Still no joy.
I know I have the right config.php file because when I change the tech email it changes the error email.

I’m thinking one solution would be to reset the forum user account’s mysql password to something I would know, then change the config.php to have the user be the forum user and that password, but I have no idea how to go about doing that.

Anyway, I’ve searched for answers all over the place and I’m stumped. Yes, I searched and read numerous threads on the topic, but it's not getting me to the goal line. I am NOT a linux guru, strictly monkey see monkey do and I have no one to rely on. I’ve renewed my license with vB just to get an answer to this question so I’d sure appreciate it if someone could help.

Thanks in advance. __DEFINE_LIKE_SHARE__

أدوات الموضوع
مشاهدة صفحة طباعة الموضوع أرسل هذا الموضوع إلى صديق
انواع عرض الموضوع
العرض العادي الانتقال إلى العرض المتطور الانتقال إلى العرض الشجري

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
CMS FB Connect on CMS	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	07-09-2010 09:10 PM
FB Connect - Lasts a short time before requiring new Connect/Login	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-15-2010 01:10 AM
VB Connect	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-03-2010 02:40 PM
Database Error: Unable to connect to the database:Could not connect to MySQL	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	01-18-2010 10:50 AM
The d has failed to connect because you dont have permission to connect to db	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	07-30-2009 05:20 AM