[racktables-users] Upgrading from 0.20.5 to 0.20.8 DB Issue
- From: Bruno Henrique Barbosa <bruno-barbosa@xxxxxxxxxxxxxxx>
- To: racktables-users@xxxxxxxxxxxxx
- Date: Fri, 4 Jul 2014 10:21:38 -0300 (BRT)
Hi everyone!
I'm having some trouble migrating my Racktables from 0.20.5 to 0.20.8, from
different servers. I proceeded as it follows:
1- Dumped racktables database (0.20.5) with mysqldump ;
2- Installed from scratch on new server the version 0.20.8;
3- Created racktables database on the new server;
4- Restored the dumped sql file from 0.20.5 into the new server;
5- Accessed racktables app, it warned about database version being different
from app version, and proceeded with upgrading;
6- The upgrade worked without any errors;
7- Accessing 'IPv4 space' shows me everything I had in 0.20.5 perfectly but..
8- Accessing any other menu, such as 'Objects' (depot) or 'Rackspace' shows me
this:
Pdo exception: PDOException
SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for
user 'uracktables'@'noc02.example.com' (using password: YES) ( 28000 )
at file /var/www/html/racktables/inc/database.php , line 3902
/var/www/html/racktables/inc/database.php:3902 execute(Array
(
)
)
/var/www/html/racktables/inc/database.php:5559 usePreparedSelectBlade('SELECT
COUNT(*) FROM `Rack`')
/var/www/html/racktables/inc/interface.php:429 getEntitiesCount('rack')
renderRackspace(NULL)
/var/www/html/racktables/index.php:34 call_user_func('renderRackspace', NULL)
Error info:
Array
(
[0] => 28000
[1] => 1045
[2] => Access denied for user 'uracktables'@'noc02.example.com' (using
password: YES)
) Parameters:
GET
page rackspace POST
COOKIE
PHPSESSID 5n6p4fav68i34qmogbavk5bhs3
Important information:
On my previous server (0.20.5) the database and application were hosted
together. This time, app is hosted on noc02.example.com and database in
noc01.example.com.
Grants for racktables user on noc01.example.com are:
+-------------------------------------------------------------+
| Grants for uracktables@% |
+-------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'uracktables'@'%' |
| GRANT ALL PRIVILEGES ON `racktables`.* TO 'uracktables'@'%' |
+-------------------------------------------------------------+
+-------------------------------------------------------------------------------------------------------------------------------------+
| Grants for uracktables@xxxxxxxxxxxxxxxxx |
+-------------------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'uracktables'@'noc02.example.com' IDENTIFIED BY
PASSWORD 'longhashinhere |
| GRANT ALL PRIVILEGES ON `racktables`.* TO 'uracktables'@'noc02.example.com |
+-------------------------------------------------------------------------------------------------------------------------------------+
Please help me out!
Other related posts:
