View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
1687RackTablesdefaultpublic2016-09-14 17:102016-09-15 13:15
Reportervalery Assigned To 
PriorityhighSeverityminorReproducibilityhave not tried
Status closedResolutionno change required 
Platformx86_64OSLinuxOS VersionDebian GNU/Linux
Summary1687: Database connection failed
DescriptionI 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
TagsNo tags attached.

Activities

infrastation

infrastation

2016-09-14 17:44

administrator   ~0003479

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
valery

valery

2016-09-15 10:29

reporter   ~0003481

Thanks alot, that helps

Issue History

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