<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
Hi,<br><br>Still, I am have problem connecting kamailio to a remote mySQL. Here is 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 directly using "root" user:<br>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" command I am getting the following error:<br><br>$ kamdbctl create<br>MySQL password for root: <br>INFO: test server charset<br>INFO: creating database openser ...<br>ERROR 1044 (42000) at line 2: Access denied for user 'root'@'1.1.1.1' to database 'openser'<br>ERROR: Creating core database and grant privileges failed!<br><br>Here is my kamctlrc config file:<br><br>DBENGINE=MYSQL<br><br>## database host<br>DBHOST=2.2.2.2<br><br>## database name<br>DBNAME=openser<br><br># database path used by dbtext or db_berkeley<br># DB_PATH="/usr/local/etc/openser/dbtext"<br><br>## database read/write user<br>#DBRWUSER=openser<br><br>## password for database read/write user<br>#DBRWPW="openserrw"<br><br>## database read only user<br>#DBROUSER=openserro<br><br>## password for database read only user<br>#DBROPW=openserro<br><br>## database super user<br>DBROOTUSER="root"<br><br># user name column<br># USERCOL="username"<br><br>Am I missing anything?<br><br>Thanks,<br>A R<br><br><br><br><br><br>> Date: Thu, 7 May 2009 14:25:41 -0400<br>> Subject: Re: [Kamailio-Users] creating openser db on an external mysql server<br>> From: osas@voipembedded.com<br>> To: alex_rsm@hotmail.com<br>> CC: miconda@gmail.com; users@lists.kamailio.org<br>> <br>> IIRC I ran into a similar issue. You will need to replace % with the<br>> IP of your remote machine and it will work.<br>> <br>> <br>> Regards,<br>> Ovidiu Sas<br>> <br>> On Thu, May 7, 2009 at 1:39 PM, Alex R.S.M <alex_rsm@hotmail.com> wrote:<br>> ><br>> > root has full privilege and is accessible from remote connection.<br>> > This is how I granted:<br>> ><br>> > GRANT ALL ON *.* TO root@'%' IDENTIFIED BY '???';<br>> ><br>> ><br>> ><br>> >> Date: Thu, 7 May 2009 13:30:37 -0400<br>> >> Subject: Re: [Kamailio-Users] creating openser db on an external mysql<br>> >> server<br>> >> From: osas@voipembedded.com<br>> >> To: alex_rsm@hotmail.com<br>> >> CC: miconda@gmail.com; users@lists.kamailio.org<br>> >><br>> >> You need to properly configure mysql by granting proper privileges for<br>> >> root for remote connections. This is not a kamailio issue.<br>> >><br>> >> Regards,<br>> >> Ovidiu Sas<br>> >><br>> >> On Thu, May 7, 2009 at 1:14 PM, Alex R.S.M <alex_rsm@hotmail.com> wrote:<br>> >> > DBHOST is already set to the external server ip.<br>> >> ><br>> >> > DBHOST=<external_mysql_server_ip><br>> >> ><br>> >> > The openser db is created but with no table. Here is the error I am<br>> >> > getting:<br>> >> ><br>> >> ><br>> >> > MySQL password for root:<br>> >> > INFO: test server charset<br>> >> > INFO: creating database openser ...<br>> >> > ERROR 1044 (42000) at line 2: Access denied for user 'root'@'%' to<br>> >> > database<br>> >> > 'openser'<br>> >> > ERROR: Creating core database and grant privileges failed!<br>> >> ><br>> >> > user "root" on all hosts ("%") is manually added.<br>> >> ><br>> >> ><br>> >> ><br>> >> ><br>> >> >> Date: Thu, 7 May 2009 17:56:54 +0200<br>> >> >> From: miconda@gmail.com<br>> >> >> To: alex_rsm@hotmail.com<br>> >> >> CC: users@lists.kamailio.org<br>> >> >> Subject: Re: [Kamailio-Users] creating openser db on an external mysql<br>> >> >> server<br>> >> >><br>> >> >> there is also the variant of setting DBHOST env variable.<br>> >> >><br>> >> >> Cheers,<br>> >> >> Daniel<br>> >> >><br>> >> >> On 05/07/2009 05:24 PM, Ovidiu Sas wrote:<br>> >> >> > Define the correct settings in kamctlrc.<br>> >> >> ><br>> >> >> > Regards,<br>> >> >> > Ovidiu Sas<br>> >> >> ><br>> >> >> > On Thu, May 7, 2009 at 11:19 AM, Alex R.S.M <alex_rsm@hotmail.com><br>> >> >> > wrote:<br>> >> >> ><br>> >> >> >> Hi,<br>> >> >> >><br>> >> >> >> Creating openser database on the localhost works fine using<br>> >> >> >> "kamdbctl<br>> >> >> >> create".<br>> >> >> >><br>> >> >> >> However, I need to create openser database on an external mysql<br>> >> >> >> server.<br>> >> >> >> I<br>> >> >> >> tried the following command but it's not working:<br>> >> >> >><br>> >> >> >> kamdbctl create openser@<external_mysql_server_ip><br>> >> >> >><br>> >> >> >> What's the correct command?<br>> >> >> >><br>> >> >> >> Thanks,<br>> >> >> >> A R<br>> >> >> >><br>> >> >> >><br>> >> >> >><br>> >> >> >> ________________________________<br>> >> >> >> Windows Live™: Keep your life in sync. Check it out.<br>> >> >> >> _______________________________________________<br>> >> >> >> Kamailio (OpenSER) - Users mailing list<br>> >> >> >> Users@lists.kamailio.org<br>> >> >> >> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users<br>> >> >> >> http://lists.openser-project.org/cgi-bin/mailman/listinfo/users<br>> >> >> >><br>> >> >> >><br>> >> >> ><br>> >> >> > _______________________________________________<br>> >> >> > Kamailio (OpenSER) - Users mailing list<br>> >> >> > Users@lists.kamailio.org<br>> >> >> > http://lists.kamailio.org/cgi-bin/mailman/listinfo/users<br>> >> >> > http://lists.openser-project.org/cgi-bin/mailman/listinfo/users<br>> >> >> ><br>> >> >> ><br>> >> >><br>> >> >> --<br>> >> >> Daniel-Constantin Mierla<br>> >> >> http://www.asipto.com/<br>> >> >><br>> >> ><br>> >> > ________________________________<br>> >> > Hotmail® has a new way to see what's up with your friends. Check it out.<br>> >> > _______________________________________________<br>> >> > Kamailio (OpenSER) - Users mailing list<br>> >> > Users@lists.kamailio.org<br>> >> > http://lists.kamailio.org/cgi-bin/mailman/listinfo/users<br>> >> > http://lists.openser-project.org/cgi-bin/mailman/listinfo/users<br>> >> ><br>> ><br>> > ________________________________<br>> > Hotmail® has ever-growing storage! Don’t worry about storage limits. Check<br>> > it out.<br><br /><hr />Hotmail® has ever-growing storage! Don’t worry about storage limits. <a href='http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tutorial_Storage1_052009' target='_new'>Check it out.</a></body>
</html>