<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
I fix the problem by granting 'root' user as follow:<br><br>GRANT ALL PRIVILEGES ON *.* TO root@'????' IDENTIFIED BY '####' <b>WITH GRANT OPTION</b>;<br><br>Thanks to everyone who responded to my email.<br><br>A R<br><br><br><br><br><br><hr id="stopSpelling">From: henning.westerholt@1und1.de<br>To: users@lists.kamailio.org<br>Subject: Re: [Kamailio-Users] creating openser db on an external mysql server<br>Date: Fri, 8 May 2009 18:42:37 +0200<br>CC: alex_rsm@hotmail.com; osas@voipembedded.com<br><br>
<style>
.ExternalClass p, .ExternalClass li
{white-space:pre-wrap;}
</style>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="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; text-indent: 0px;"><br></p>Hi Alex,<br>
<p style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; text-indent: 0px;"><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="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; text-indent: 0px;"><br></p>Cheers,<br>
<p style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; text-indent: 0px;"><br></p>Henning<BR><br /><hr />Windows Live™: Keep your life in sync. <a href='http://windowslive.com/explore?ocid=TXT_TAGLM_BR_life_in_synch_052009' target='_new'>Check it out.</a></body>
</html>