<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
<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 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 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 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 "kamdbctl<br>> >> >> create".<br>> >> >><br>> >> >> However, I need to create openser database on an external mysql 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 /><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>