That looks like is a MySQL permission error.. make sure you grant access to the user and database.
Luis On 7/4/14, 8:21 AM, Bruno Henrique Barbosa wrote:
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!
