8 May
2009
8 May
'09
7:42 p.m.
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