[racktables-users] Re: Upgrading from 0.20.5 to 0.20.8 DB Issue [CLOSE]
- From: David Taylor <david.taylor@xxxxxxxxxxxxx>
- To: "racktables-users@xxxxxxxxxxxxx" <racktables-users@xxxxxxxxxxxxx>
- Date: Fri, 12 Sep 2014 03:16:47 +0000
Ok the issue has been resolved. What seems to happen is that the application
hard codes the user@IP_address combination of the server it is installed on
into the view definers in in so doing makes the application server
non-portable. In this case for some reason the issue didn’t show up until long
after the server was actually moved. Does the view definer actually need to be
locked like that? IT also makes it hard to scale to multiple servers.
The resolution for me was simple.
1) dump the database to a text file
2) make a copy of the file
3) in the copy do a find and replace on the old server address with the
new server address
4) drop the database
5) create a new database with the old name
6) load the modified sql dump into the fresh db
7) turn frown upside down and remove sharp objects from body and return to
users
Best regards
David Taylor
From: racktables-users-bounce@xxxxxxxxxxxxx
[mailto:racktables-users-bounce@xxxxxxxxxxxxx] On Behalf Of David Taylor
Sent: Friday, 12 September 2014 11:52 AM
To: racktables-users@xxxxxxxxxxxxx
Subject: [racktables-users] Re: Upgrading from 0.20.5 to 0.20.8 DB Issue [CLOSE]
I’m having the same error, however the fix listed doesn’t return any values for
me. Also it seems to have just started happening without any DB or Application
changes outside those made by the application itself. Any help would be greatly
appreciated.
Best regards
David Taylor
From:
racktables-users-bounce@xxxxxxxxxxxxx<mailto:racktables-users-bounce@xxxxxxxxxxxxx>
[mailto:racktables-users-bounce@xxxxxxxxxxxxx] On Behalf Of Bruno Henrique
Barbosa
Sent: Tuesday, 8 July 2014 1:31 AM
To: racktables-users@xxxxxxxxxxxxx<mailto:racktables-users@xxxxxxxxxxxxx>
Subject: [racktables-users] Re: Upgrading from 0.20.5 to 0.20.8 DB Issue [CLOSE]
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!
________________________________
De: "LUIS LACAYO" <llacayo@xxxxxxxx<mailto:llacayo@xxxxxxxx>>
Para: racktables-users@xxxxxxxxxxxxx<mailto: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<mailto: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:
