You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by Venkata Suneel Babu Mallela <su...@simplifydc.com> on 2014/09/16 15:20:43 UTC
Error Importing Sql Dumpfile
HI All,
I'm trying to configure DataBase replication for ACS 4.4.0, and followed the below steps.
1. I've exported the existing data of master using the command "mysqldump -u root -p --all-databases --master-data > dbdump.db".
2. When I tried to import dumpfile into the slave using the command "mysql -u root -p < /root/dbdump.db", I'm getting the below error,
[root@pocdb02 ~]# mysql -u root < dbdump.db
ERROR 1449 (HY000) at line 11293: The user specified as a definer ('cloud'@'%') does not exist
Can anyone please advise how to resolve this problem?
Thank you,
Suneel Mallela
Re: Error Importing Sql Dumpfile
Posted by Ian Duffy <ia...@ianduffy.ie>.
Hi Suneel,
You will need to grant your cloud user access to the databases accordingly.
e.g.
grant all privileges on cloud.* to cloud@'%'
Hope this helps,
Ian
On 16 September 2014 17:11, Venkata Suneel Babu Mallela <
suneel.m@simplifydc.com> wrote:
> Hi Ian Duffy,
>
> Thank you for your reply. I'm able to login with 'cloud' user without
> password, but with this user I'm unable to see the "cloud" and
> "cloud_usage" databases. I'm able to see these databases with root user.
> Is there anything I missed? Please suggest.
>
> Thank you,
> Suneel Mallela
>
> -----Original Message-----
> From: Ian Duffy [mailto:ian@ianduffy.ie]
> Sent: Tuesday, September 16, 2014 6:56 PM
> To: users@cloudstack.apache.org
> Subject: Re: Error Importing Sql Dumpfile
>
> Hi Suneel,
>
> The error suggests a cloud user doesn't exist within your mysql database.
>
> Please create a new user and it should solve the error.
>
> e.g.
>
> CREATE USER 'cloud'@'%' IDENTIFIED BY 'password';
>
> On 16 September 2014 14:20, Venkata Suneel Babu Mallela <
> suneel.m@simplifydc.com> wrote:
>
> > HI All,
> >
> > I'm trying to configure DataBase replication for ACS 4.4.0, and
> > followed the below steps.
> >
> >
> > 1. I've exported the existing data of master using the command
> > "mysqldump -u root -p --all-databases --master-data > dbdump.db".
> >
> > 2. When I tried to import dumpfile into the slave using the command
> > "mysql -u root -p < /root/dbdump.db", I'm getting the below error,
> >
> > [root@pocdb02 ~]# mysql -u root < dbdump.db ERROR 1449 (HY000) at line
> > 11293: The user specified as a definer ('cloud'@'%') does not exist
> >
> > Can anyone please advise how to resolve this problem?
> >
> > Thank you,
> > Suneel Mallela
> >
>
RE: Error Importing Sql Dumpfile
Posted by Venkata Suneel Babu Mallela <su...@simplifydc.com>.
Hi Ian Duffy,
Thank you for your reply. I'm able to login with 'cloud' user without password, but with this user I'm unable to see the "cloud" and "cloud_usage" databases. I'm able to see these databases with root user.
Is there anything I missed? Please suggest.
Thank you,
Suneel Mallela
-----Original Message-----
From: Ian Duffy [mailto:ian@ianduffy.ie]
Sent: Tuesday, September 16, 2014 6:56 PM
To: users@cloudstack.apache.org
Subject: Re: Error Importing Sql Dumpfile
Hi Suneel,
The error suggests a cloud user doesn't exist within your mysql database.
Please create a new user and it should solve the error.
e.g.
CREATE USER 'cloud'@'%' IDENTIFIED BY 'password';
On 16 September 2014 14:20, Venkata Suneel Babu Mallela < suneel.m@simplifydc.com> wrote:
> HI All,
>
> I'm trying to configure DataBase replication for ACS 4.4.0, and
> followed the below steps.
>
>
> 1. I've exported the existing data of master using the command
> "mysqldump -u root -p --all-databases --master-data > dbdump.db".
>
> 2. When I tried to import dumpfile into the slave using the command
> "mysql -u root -p < /root/dbdump.db", I'm getting the below error,
>
> [root@pocdb02 ~]# mysql -u root < dbdump.db ERROR 1449 (HY000) at line
> 11293: The user specified as a definer ('cloud'@'%') does not exist
>
> Can anyone please advise how to resolve this problem?
>
> Thank you,
> Suneel Mallela
>
Re: Error Importing Sql Dumpfile
Posted by Ian Duffy <ia...@ianduffy.ie>.
Hi Suneel,
The error suggests a cloud user doesn't exist within your mysql database.
Please create a new user and it should solve the error.
e.g.
CREATE USER 'cloud'@'%' IDENTIFIED BY 'password';
On 16 September 2014 14:20, Venkata Suneel Babu Mallela <
suneel.m@simplifydc.com> wrote:
> HI All,
>
> I'm trying to configure DataBase replication for ACS 4.4.0, and followed
> the below steps.
>
>
> 1. I've exported the existing data of master using the command
> "mysqldump -u root -p --all-databases --master-data > dbdump.db".
>
> 2. When I tried to import dumpfile into the slave using the command
> "mysql -u root -p < /root/dbdump.db", I'm getting the below error,
>
> [root@pocdb02 ~]# mysql -u root < dbdump.db
> ERROR 1449 (HY000) at line 11293: The user specified as a definer ('cloud'@'%')
> does not exist
>
> Can anyone please advise how to resolve this problem?
>
> Thank you,
> Suneel Mallela
>