Help - Search - Members
Full Version: Error restoting a bakup
Kaspersky Lab Forum > English User Forum > Protection for Small and Medium Businesses
alaurent
Hello, I'm restoring the systems from a Backup, and I'm reciving this error:

FAILED - error code 1950 ('Generic db error: "Database error: code = 1449, message='There is no 'kl'@'xxx.xx.xx.xxx' registered', LastStatement='CALL AK_CREATE_TABLES()'"')

This is the configuration

xxx.xx.xx.xxx is the Administration Kit IP
Adminstration kit Server: Windows 2000 Server
Administration Kit Vresion: 6.0.1572

Database Server: Debian
Database Server Manager: MySql 5.0.32-7etch5

Thanks in advanced.

mpsilva
Probably user 'kl' was not found.
alaurent
Don't found where?
who must to create this user and how to create it?


QUOTE(mpsilva @ 15.04.2008 12:48) *
Probably user 'kl' was not found.
mpsilva
Not found at "xxx.xxx.xxx.xxx", your MySQL server.

You must create it, using MySQL Administrator.
alaurent
I start again from cero, and that is what is happening:

The first time I try to restore the data, the log says:
FAILED - error code 8 ('')

Then, if I try to restore again the same backup the system says:
FAILED - error code 1950 ('Generic db error: "Database error: code = 1449, message='There is no 'kl'@'172.xx.xx.xx' registered', LastStatement='CALL AK_CREATE_TABLES()'"')

172.xx.xx.xx is the Administration Kit IP address, not the MySql IP

I don’t know the old MySql Owner credentials (user name and password in the old MySql server), Are there necessary?

Thanks again.


QUOTE(mpsilva @ 15.04.2008 13:34) *
Not found at "xxx.xxx.xxx.xxx", your MySQL server.

You must create it, using MySQL Administrator.

andkaz
QUOTE(alaurent @ 15.04.2008 21:17) *
I start again from cero, and that is what is happening:

The first time I try to restore the data, the log says:
FAILED - error code 8 ('')

Then, if I try to restore again the same backup the system says:
FAILED - error code 1950 ('Generic db error: "Database error: code = 1449, message='There is no 'kl'@'172.xx.xx.xx' registered', LastStatement='CALL AK_CREATE_TABLES()'"')

172.xx.xx.xx is the Administration Kit IP address, not the MySql IP

I don’t know the old MySql Owner credentials (user name and password in the old MySql server), Are there necessary?

Thanks again.


User name is `kl`@`172.xx.xx.xx`, password may be other.

The problem is that while backing up database mysqldump writes into dump DEFINER=`kl`@`172.xx.xx.xx`. So that definer must exist when database is being restored. And administration server must use `kl` account while connecting to the mysql server.


This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.