FUDforum: Bug Reports » how to change DB host when no access to admin because of db connexion error

Home » FUDforum Development » Bug Reports » how to change DB host when no access to admin because of db connexion error (

) 2 Votes

Show: Today's Messages :: Polls :: Message Navigator

how to change DB host when no access to admin because of db connexion error [message #29101]

Tue, 29 November 2005 23:45

matthieu_phpmv

Messages: 44
Registered: November 2004

Karma: 0

Member

Hello

today my DB access have changed (the host becomes 'localhost'), and so the forums don't work anymore

Warning: mysql_connect(): Access denied for user: 'Xxxxx' (Using password: YES) in /home/phpmyvis/www/forums/index.php on line 70

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/phpmyvis/www/forums/index.php on line 70

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/phpmyvis/www/forums/index.php on line 70

Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /home/phpmyvis/www/forums/index.php on line 58

I don't have access to administration because of this error.
I can 't download and upload GLOBALS.php files because I don't have to right to do so (FTP rights not enough).

How can I do to edit the configuration?

I can't understand why, when there is such a problem, there is no possibility to log in and change DB config. For example, in phpmyvisites, I have set a super admin, his info are in a configuration file, and so he can log in even when the db is down. He can edit db properties.

I'm waiting for you Smile

Thank you in advance
Matthieu

http://www.phpmyvisites.net/

http://www.phpmyvisites.net/forums/

Report message to a moderator

Re: how to change DB host when no access to admin because of db connexion error [message #29102 is a reply to message #29101]

Tue, 29 November 2005 23:53

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

You can write a little php script that will chmod GLOBALS.php 666 and then edit it to change the SQL configuration.

FUDforum Core Developer

Report message to a moderator

Re: how to change DB host when no access to admin because of db connexion error [message #29104 is a reply to message #29102]

Wed, 30 November 2005 00:03

matthieu_phpmv

Messages: 44
Registered: November 2004

Karma: 0

Member

Ok I know actually, but that's not so much 'user friendly' Wink

That would be an interesting feature, but not so easy of you didn't think of it at the beginning of development.

Report message to a moderator

Re: how to change DB host when no access to admin because of db connexion error [message #29105 is a reply to message #29104]

Wed, 30 November 2005 00:11

matthieu_phpmv

Messages: 44
Registered: November 2004

Karma: 0

Member

Code for people who whants to chmod the GLOBALS.php file
To upload in /www/yourforumadmindirectory/chmod.php

<?php
if(chmod(dirname(__FILE__).'/include/GLOBALS.php', 0777)) print("ok"); else print("error");
?>

Report message to a moderator

Re: how to change DB host when no access to admin because of db connexion error [message #29115 is a reply to message #29104]

Wed, 30 November 2005 14:37

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

There is no way to auto-update your MySQL settings.

FUDforum Core Developer

Report message to a moderator

Previous Topic:	bug in 2.7.3? Post message don't redirect to forum
Next Topic:	Error - mass email

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 02 01:39:31 GMT 2024

Total time taken to generate the page: 0.02752 seconds