By dugawug on

I'm trying to change the database that Drupal is using in settings.php to be my new production database. It's currently set (and has forever been set) to our test database. Now I'm simply changing the connection string:

$db_url = 'mysql://[user]:[pwrd]@localhost/[dbname]';

to match the new database setup and when I do, the site shows the "under maintenance" page! I can't login or access a single thing anymore. I switch it back and it's fine.

And yes, the string is correct, the user exists, is assigned to the database, has ALL privledges, etc.

I can't figure out what's going on. Is there more I should be doing when switching the database Drupal is working from?

⋅ Categories: Drupal 5.x

Comments

zeta ζ’s picture

zeta ζ commented

If you set it as you have done, then go to www.example.com/?q=user and see if you can log in. If you can, go to the admin page and put the site back online.

See: http://drupal.org/node/56995
___________________
Explore your /admin page!
It’s in the detaιls…
demonstration portfolio

dugawug’s picture

dugawug commented

well, that for some reason boots me back out to my intro page. how can i manually put the site back online?

or i should also ask, is changing databases for Drupal as simple as updating the settings.php file? no other steps i've missed?

dugawug’s picture

dugawug commented

i tried manually putting the site online by going into the variables table and setting site_offline row to s:1:"0"; instead of s:1:"1";
but that didn't work :(

zeta ζ’s picture

zeta ζ commented

See: http://drupal.org/node/56995
___________________
Explore your /admin page!
It’s in the detaιls…
demonstration portfolio

dugawug’s picture

dugawug commented

OMG, it was the cache! One tiny record has been driving me crazy for about an hour now! ;)
I'm eternally indebted to zeta!

zeta ζ’s picture

zeta ζ commented

At what stage does it boot you back out? And what do you mean by intro page? What is its URL?
___________________
Post a link?
Explore your /admin page!
It’s in the detaιls…
demonstration portfolio

dugawug’s picture

dugawug commented

as soon as i hit enter for URL www.example.com/?q=user, i get kicked to my default page at www.mydomain.com, which is not the technical Drupal homepage but a static HTML page that I believe htaccess has set to take priority over the index.php for Drupal. so index.html is my "intro" page at www.mydomain.com but index.php is my Drupal "home" page.

i'm wondering why my manual database edits to the site_offline_message, etc. are not working. i'm trying on both test and live database and not seeing any change.

zeta ζ’s picture

zeta ζ commented

Delete, move or rename index.html !
___________________
It’s in the detaιls…
demonstration portfolio

dugawug’s picture

dugawug commented

CHEERS zeta! if you didn't see my post above, deleting that cache fixed it. that would have only taken me between 2 to 2.2 billion hours to figure out on my own ;)

any explanation on what that cache was all about?