By djax80 on

hi

i created a 'backup' site of my 'live' site - it has different root folder (but exact same files copied over from 'live' site) - and a different separate database - but imported the 'live' site sql data and structure (postgresql), so again its an exact copy, bar the db name

i then changed the 'settings.php' file to point to the backup database - and all was ok - new 'backup' site looks exactly like 'live' site

problem is i cant login as admin using the password from the 'live' site - ive tried changing the admin password in the 'backup' database 'users' table - but still cant login - i just get a 'Page Unavailable'

Anyone know if ive missed a step here?

many thanks in advance

djax

⋅ Categories: Drupal 5.x

Comments

ezraw’s picture

ezraw commented

Can you navigate to other pages as an anonymous user? Maybe a clean URLs problem? Is the backup on a different server that might not support clean URLs?

Ezra Wolfe
DLC Solutions
EthosCE

djax80’s picture

djax80 commented

Yes - its the same server and i can navigate to other pages as an anonymous user

i tried your suggestion of clean urls, and that appears to be it - i just have to add the odd '?q=' to the url i want to get to

many thanks

djax80’s picture

djax80 commented

Actually i now have another wierd problem, i thought you may have encounted

the problem i have is that the backup site is still pointing to the live site database, even though ive changed the 'settings.php' of the backup site to point to the backup db????

if i update a page in backup, its updates the live db - (again - i repeat i have changed the $db_url = 'mysql://username:password@localhost/databasename'; in settings.php to point to the backup db) - i have ensured i am on the backup site url when editing a page

this doesnt make sense - is there some setting that is recorded in the live db (that ive imported into the backup db) that points to the original live db?

djax

ezraw’s picture

ezraw commented

Can you confirm that your web server is pointing to the correct Drupal instance for live vs. backup? Try removing settings.php completely and see if the site still runs. If so this might be it. If not, are you running a multisite instance?

Ezra Wolfe
DLC Solutions
EthosCE

djax80’s picture

djax80 commented

it required the rewrite base url in .htaccess to be set to the test site

it seems so obvious once i realised