[Kamailio-Users] creating openser db on an external mysql server

[Alex R.S.M]

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.westerholt at 1und1.de
To: users at 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_rsm at hotmail.com; osas at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20090508/d565749c/attachment.htm>