View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
1687 | RackTables | default | public | 2016-09-14 17:10 | 2016-09-15 13:15 |
Reporter | valery | Assigned To | |||
Priority | high | Severity | minor | Reproducibility | have not tried |
Status | closed | Resolution | no change required | ||
Platform | x86_64 | OS | Linux | OS Version | Debian GNU/Linux |
Summary | 1687: Database connection failed | ||||
Description | I try to migrate existing (and well working) racktable server to another host. Racktables MySql hosted in another virtual machine. 1. I copy /var/www/racktables/ to another host 2. Setup nginx + racktables (on 90 port) 3. Try to login through someserver:90, but catch up error Database connection failed: SQLSTATE[28000] [1045] Access denied for user 'racktables'@'newhostnam' (using password: YES) So, racktables did not reade info about ip of database from secret.php and try to find and connect to database in newhost. Again, database did not migrate, it's live in some another host as before. -r-------- 1 www-data www-data 1936 Sep 14 17:13 wwwroot/inc/secret.php | ||||
Tags | No tags attached. | ||||
The message likely means the MySQL server still expects the user to come from the old VM address. You would need to grant a new permission for the new VM address: http://dev.mysql.com/doc/refman/5.7/en/grant.html |
|
Thanks alot, that helps | |
Date Modified | Username | Field | Change |
---|---|---|---|
2016-09-14 17:10 | valery | New Issue | |
2016-09-14 17:44 | infrastation | Note Added: 0003479 | |
2016-09-15 10:29 | valery | Note Added: 0003481 | |
2016-09-15 13:15 | infrastation | Status | new => closed |
2016-09-15 13:15 | infrastation | Resolution | open => no change required |