[racktables-users] Re: Upgrading from 0.20.5 to 0.20.8 DB Issue [CLOSE]
- From: Bruno Henrique Barbosa <bruno-barbosa@xxxxxxxxxxxxxxx>
- To: racktables-users@xxxxxxxxxxxxx
- Date: Mon, 7 Jul 2014 12:30:49 -0300 (BRT)
Hi everyone.
After getting around different ways, I finally made it. It was an permission
issue, not related with grant permissions, but view definers. I have no DBA
experience, but I solved it this way:
- Redumped 0.20.5 database from old server as MySQL root;
- Created and restored 0.20.5 database to new server as MySQL root;
- Granted permissions;
- Trying this: mysql> select * from Rack;
- Returned me this: ERROR 1449 (HY000): The user specified as a definer
('racktables_user'@'localhost') does not exist
- So after some research, I found this very useful command (since I was
migrating servers, I also changed racktables user account on MySQL):
SELECT CONCAT("ALTER DEFINER=`uracktables`@`noc02.example.com` VIEW
",table_name," AS ", view_definition,";") FROM information_schema.views WHERE
table_schema='racktables'
- It showed me 4 SQL queries which I runned right after, to change the definer
of those Views;
- Pulled 0.20.8 version, which warned for updates, and it finally worked out.
So, case closed.
Thanks!
----- Mensagem original -----
De: "LUIS LACAYO" <llacayo@xxxxxxxx>
Para: racktables-users@xxxxxxxxxxxxx
Enviadas: Sábado, 5 de julho de 2014 0:35:44
Assunto: [racktables-users] Re: Upgrading from 0.20.5 to 0.20.8 DB Issue
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!
Other related posts:
