8 May
2009
8 May
'09
1:55 p.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(a)1und1.de
To: users(a)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(a)hotmail.com; osas(a)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(a)'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