<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd"><html><head><meta name="qrichtext" content="1" /><style type="text/css">p, li { white-space: pre-wrap; }</style></head><body style=" font-family:'Lucida Console'; font-size:9pt; font-weight:400; font-style:normal;">On Freitag, 8. Mai 2009, Alex R.S.M wrote:<br>
> Hi,<br>
><br>
> Still, I am have problem connecting kamailio to a remote mySQL. Here is<br>
> what I have done so far:<br>
><br>
> Let's assume my kamailio and mySQL servers have the following IP:<br>
> Kamailio: 1.1.1.1<br>
> mySQL: 2.2.2.2<br>
><br>
><br>
> I granted "root" user to a access all tables from kamailio host:<br>
> GRANT ALL ON *.* TO root@'1.1.1.1' IDENTIFIED BY '????';<br>
><br>
> mysql> select host,user,password from user;<br>
> 1.1.1.1 | root | *669148???????????????????<br>
><br>
><br>
> After that, I prefectly can connect to the remote mySQL from kamailio<br>
> directly using "root" user: mysql -h 2.2.2.2 -u root -p???<br>
> Welcome to the MySQL monitor. Commands end with ; or \g.<br>
> Your MySQL connection id is 18<br>
> Server version: 5.0.51a-3ubuntu5.1-log (Ubuntu)<br>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.<br>
> mysql><br>
><br>
><br>
> However, When I try to create "openser" database using "kamdbctl create"<br>
> command I am getting the following error:<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Hi Alex,<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>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 '*.*'.<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Cheers,<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Henning</p></body></html>