I fix the problem by granting 'root' user as follow:
GRANT ALL PRIVILEGES ON *.* TO root@'????' IDENTIFIED BY '####' WITH GRANT
OPTION;
Thanks to everyone who responded to my email.
A R
From: henning.westerh...@1und1.de
To: users@lists.kamailio.org
Subject: Re: [Kamailio-Users] creating openser db on an external mysql server
Date: Fri, 8 May 2009 18:42:37 +0200
CC: alex_...@hotmail.com; o...@voipembedded.com
On Freitag, 8. Mai 2009, Alex R.S.M wrote:
> Hi,
>
> Still, I am have problem connecting kamailio to a remote mySQL. Here is
> what I have done so far:
>
> Let's assume my kamailio and mySQL servers have the following IP:
> Kamailio: 1.1.1.1
> mySQL: 2.2.2.2
>
>
> I granted "root" user to a access all tables from kamailio host:
> GRANT ALL ON *.* TO root@'1.1.1.1' IDENTIFIED BY '????';
>
> mysql> select host,user,password from user;
> 1.1.1.1 | root | *669148???????????????????
>
>
> After that, I prefectly can connect to the remote mySQL from kamailio
> directly using "root" user: mysql -h 2.2.2.2 -u root -p???
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 18
> Server version: 5.0.51a-3ubuntu5.1-log (Ubuntu)
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> mysql>
>
>
> However, When I try to create "openser" database using "kamdbctl create"
> command I am getting the following error:
Hi Alex,
i've tried to reproduce your problem on a remote mysql with db. I run into the
same problem as you if i failed to grant the "Grant_priv" to my remote user.
Can you take a look if the root user has this right? This right is aparently
not included in '*.*'.
Cheers,
Henning
_________________________________________________________________
Windows Live™: Keep your life in sync.
http://windowslive.com/explore?ocid=TXT_TAGLM_BR_life_in_synch_052009
_______________________________________________
Kamailio (OpenSER) - Users mailing list
Users@lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
