Hellos,
I moved a website from server A to B.
my db connection settings on server A were $db_url = 'mysqli://userold:passold@localhost/dbold'; and on the new server $db_url = 'mysqli://usernew:passnew@localhost/dbnew';
I am getting a white "under maintenance screen" with error "The mysqli error was: Access denied for user 'userold'@'localhost' (using password: YES)."
There is no trace of userold in the settings.php file
what could be the problem?
Could be the old cache is still pointing to your old DB access. Can you go into phpmyadmin or mysql from the shell and truncate (clear out) all the tables beginning with 'cache'?
At 11:47 AM 6/16/2011, Mutuku Ndeti wrote:
Hellos,
I moved a website from server A to B.
my db connection settings on server A were $db_url = 'mysqli://userold:passold@localhost/dbold'; and on the new server $db_url = 'mysqli://usernew:passnew@localhost/dbnew';
I am getting a white "under maintenance screen" with error "The mysqli error was: Access denied for user 'userold'@'localhost' (using password: YES)."
There is no trace of userold in the settings.php file
what could be the problem?
Tel:254722490994 www.agile.co.ke | www.zetu.co.ke -- [ Drupal support list | http://lists.drupal.org/ ]
Thanks Marty for the response. I have done that but the problem persists
On 16/06/2011, Marty Landman mlandman@face2interface.com wrote:
Could be the old cache is still pointing to your old DB access. Can you go into phpmyadmin or mysql from the shell and truncate (clear out) all the tables beginning with 'cache'?
At 11:47 AM 6/16/2011, Mutuku Ndeti wrote:
Hellos,
I moved a website from server A to B.
my db connection settings on server A were $db_url = 'mysqli://userold:passold@localhost/dbold'; and on the new server $db_url = 'mysqli://usernew:passnew@localhost/dbnew';
I am getting a white "under maintenance screen" with error "The mysqli error was: Access denied for user 'userold'@'localhost' (using password: YES)."
There is no trace of userold in the settings.php file
what could be the problem?
Tel:254722490994 www.agile.co.ke | www.zetu.co.ke -- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
On 16 Jun 2011, at 5:47 PM, Mutuku Ndeti wrote:
Hellos,
I moved a website from server A to B.
my db connection settings on server A were $db_url = 'mysqli://userold:passold@localhost/dbold'; and on the new server $db_url = 'mysqli://usernew:passnew@localhost/dbnew';
I am getting a white "under maintenance screen" with error "The mysqli error was: Access denied for user 'userold'@'localhost' (using password: YES)."
There is no trace of userold in the settings.php file
what could be the problem?
The only thing I can think of: is did you GRANT permissions to the usernew database user?
I granted all permissions to usernew
On 16/06/2011, Jeff jeff@wildcoast.com wrote:
On 16 Jun 2011, at 5:47 PM, Mutuku Ndeti wrote:
Hellos,
I moved a website from server A to B.
my db connection settings on server A were $db_url = 'mysqli://userold:passold@localhost/dbold'; and on the new server $db_url = 'mysqli://usernew:passnew@localhost/dbnew';
I am getting a white "under maintenance screen" with error "The mysqli error was: Access denied for user 'userold'@'localhost' (using password: YES)."
There is no trace of userold in the settings.php file
what could be the problem?
The only thing I can think of: is did you GRANT permissions to the usernew database user?
-- [ Drupal support list | http://lists.drupal.org/ ]
On Thu, Jun 16, 2011 at 9:45 PM, Mutuku Ndeti jnmutuku@gmail.com wrote:
I am getting a white "under maintenance screen" with error "The mysqli error was: Access denied for user 'userold'@'localhost' (using password: YES)."
There is no trace of userold in the settings.php file
what could be the problem?
Are you able to access mysql console with the given credentials ?
-- Sivaji +91 9941 571 690
I have had this problem myself. This is how I fixed it.
Old site:
Use backup & migrate to do a back up. or Use MySQL Admin and do a db dump
use text editor's search and replace to change name of the the old db to the name of the new db. (if name is different) (I have only had 3 places where this change was made.)
New site:
delete the settings.php file. (or rename if you want to keep a back up) make a copy of the default.settings.php file and rename it to settings.php
run your site like you are installing drupal for the first time. when done, use backup & migrate to import the db back up you make from the old site.
Done.
Hope this will help you like it did me.
thanks Cory. it's working now. Found out that this comes up when you are using modules that save database credentials in the database. In my case I am using the phplist module
On 16/06/2011, Cory Gilliam imaaxa@gmail.com wrote:
I have had this problem myself. This is how I fixed it.
Old site:
Use backup & migrate to do a back up. or Use MySQL Admin and do a db dump
use text editor's search and replace to change name of the the old db to the name of the new db. (if name is different) (I have only had 3 places where this change was made.)
New site:
delete the settings.php file. (or rename if you want to keep a back up) make a copy of the default.settings.php file and rename it to settings.php
run your site like you are installing drupal for the first time. when done, use backup & migrate to import the db back up you make from the old site.
Done.
Hope this will help you like it did me.
Cory Gilliam Knoxville, TN 37921 imaaxa@gmail.com 865.335.3250
anyone know any good tutorials with themeing your Ubercart products and catalog? CSS/HTML
Cheers Kevin
-
Cory Gilliam -
Jeff -
Kevin Anderson -
Marty Landman -
Mutuku Ndeti -
sivaji j.g