Hi!
My host have done a migration to a new platform and in this process changed the name and credentials of a couple of databases connected to sites where I run CMSMS. The sites are down and I can't access the admin panels in CMSMS.
I obviously didn't read the documentation regarding the migration thoroghly enough so here I am, asking for advise!
Can I solve this in a swift way by editing DB-credentials for CMSMS through phpMyAdmin to get the sites up and running again?
Please say I can!
/C
Post database migration problems
Re: Post database migration problems
You need to change the database name and credentials, and perhaps server path in the config.php file! Clear cache after that.
- + - + - + - + - + - + -
LATEST TUTORIAL AT CMS CAN BE SIMPLE:
Migrating Company Directory module to LISE
Migrating Company Directory module to LISE
- + - + - + - + - + - + -
Re: Post database migration problems
Thanks for the answer, but it wasn't as easy as I hoped for me who aint an expert on these things!
I have tried to change it but can't get it to work. Someone, please advise!
This is the content my old config file:
And this is the info from phpMyAdmin:
Server: 10.209.41.8 via TCP/IP
Server version: 5.5.52-MariaDB-cll-lve
Protocol version: 10
User: 2004707_umgstad@10.211.59.34
MySQL charset: UTF-8 Unicode (utf8)
And this is the new credentials that my host sent me:
New database credentials for db1123260_mgstad:
Host: dbmgstad-2004707.mysql.crystone.se
Database: 2004707-dbmgstad
Username: 2004707_umgstad
Password: ###############
I have tried to change it but can't get it to work. Someone, please advise!
This is the content my old config file:
Code: Select all
<?php
# CMS Made Simple Configuration File#
Documentation: /doc/CMSMS_config_reference.pdf#$config['dbms'] = 'mysqli';
$config['db_hostname'] = '83.168.227.23';
$config['db_username'] = 'u1123260_mgstad';
$config['db_password'] = '################';
$config['db_name'] = 'db1123260_mgstad';
$config['db_prefix'] = 'mgstad_';
$config['timezone'] = 'Europe/Stockholm';
?>
Server: 10.209.41.8 via TCP/IP
Server version: 5.5.52-MariaDB-cll-lve
Protocol version: 10
User: 2004707_umgstad@10.211.59.34
MySQL charset: UTF-8 Unicode (utf8)
And this is the new credentials that my host sent me:
New database credentials for db1123260_mgstad:
Host: dbmgstad-2004707.mysql.crystone.se
Database: 2004707-dbmgstad
Username: 2004707_umgstad
Password: ###############
Re: Post database migration problems
The most obvious way would be:
$config['db_hostname'] => Host
$config['db_username'] => Username
$config['db_password'] => Password
$config['db_name'] => Database
And after that clear cache!
If that doesn't work you should contact your web host. Nothing we can do here...
Grtz. Rolf
$config['db_hostname'] => Host
$config['db_username'] => Username
$config['db_password'] => Password
$config['db_name'] => Database
And after that clear cache!
If that doesn't work you should contact your web host. Nothing we can do here...
Grtz. Rolf
- + - + - + - + - + - + -
LATEST TUTORIAL AT CMS CAN BE SIMPLE:
Migrating Company Directory module to LISE
Migrating Company Directory module to LISE
- + - + - + - + - + - + -
Re: Post database migration problems
Thanks Rolf
It seems like I managed to access the DB with your help, but new problems occurs. Now I get a 404 instead of a DB error message.
"Not Found
The requested URL was not found on this server."
Any ideas?
//C
It seems like I managed to access the DB with your help, but new problems occurs. Now I get a 404 instead of a DB error message.
"Not Found
The requested URL was not found on this server."
Any ideas?
//C
Re: Post database migration problems
Problem started after the web host made changes. Only they know what was done and how it can be fixed. I can give you several pointers but all of them assumes a normal stable hosting.
So contact your web host first.
So contact your web host first.
- + - + - + - + - + - + -
LATEST TUTORIAL AT CMS CAN BE SIMPLE:
Migrating Company Directory module to LISE
Migrating Company Directory module to LISE
- + - + - + - + - + - + -
Re: Post database migration problems
Problem started after the web host made changes. Only they know what was done and how it can be fixed. I can give you several pointers but all of them assumes a normal stable hosting. So it will be more like guessing what could have happened.
So contact your web host first.
So contact your web host first.
- + - + - + - + - + - + -
LATEST TUTORIAL AT CMS CAN BE SIMPLE:
Migrating Company Directory module to LISE
Migrating Company Directory module to LISE
- + - + - + - + - + - + -
Re: Post database migration problems
I have contacted the support but no answer yet. I have a hunch that they will point at my CMS...I will get back when I know.