<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
<br>I also added the following<br><br>## database super user<br>DBROOTUSER="root"<br><br><br><br><hr id="stopSpelling">From: alex_rsm@hotmail.com<br>To: miconda@gmail.com<br>Date: Thu, 7 May 2009 13:14:00 -0400<br>CC: users@lists.kamailio.org<br>Subject: Re: [Kamailio-Users] creating openser db on an external mysql server<br><br>
<style>
.ExternalClass .EC_hmmessage P
{padding:0px;}
.ExternalClass body.EC_hmmessage
{font-size:10pt;font-family:Verdana;}
</style>
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 '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 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> 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. 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><hr>Hotmail® has a new way to see what's up with your friends. <a href="http://windowslive.com/Tutorial/Hotmail/WhatsNew?ocid=TXT_TAGLM_WL_HM_Tutorial_WhatsNew1_052009">Check it out.</a><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>