[Kamailio-Users] creating openser db on an external mysql server

Ovidiu Sas osas at voipembedded.com
Thu May 7 19:30:37 CEST 2009


You need to properly configure mysql by granting proper privileges for
root for remote connections.  This is not a kamailio issue.

Regards,
Ovidiu Sas

On Thu, May 7, 2009 at 1:14 PM, Alex R.S.M <alex_rsm at hotmail.com> wrote:
> DBHOST is already set to the external server ip.
>
> DBHOST=<external_mysql_server_ip>
>
> The openser db is created but with no table. Here is the error I am getting:
>
>
> MySQL password for root:
> INFO: test server charset
> INFO: creating database openser ...
> ERROR 1044 (42000) at line 2: Access denied for user 'root'@'%' to database
> 'openser'
> ERROR: Creating core database and grant privileges failed!
>
> user "root" on all hosts ("%") is manually added.
>
>
>
>
>> Date: Thu, 7 May 2009 17:56:54 +0200
>> From: miconda at gmail.com
>> To: alex_rsm at hotmail.com
>> CC: users at lists.kamailio.org
>> Subject: Re: [Kamailio-Users] creating openser db on an external mysql
>> server
>>
>> there is also the variant of setting DBHOST env variable.
>>
>> Cheers,
>> Daniel
>>
>> On 05/07/2009 05:24 PM, Ovidiu Sas wrote:
>> > Define the correct settings in kamctlrc.
>> >
>> > Regards,
>> > Ovidiu Sas
>> >
>> > On Thu, May 7, 2009 at 11:19 AM, Alex R.S.M <alex_rsm at hotmail.com>
>> > wrote:
>> >
>> >> Hi,
>> >>
>> >> Creating openser database on the localhost works fine using "kamdbctl
>> >> create".
>> >>
>> >> However, I need to create openser database on an external mysql server.
>> >> I
>> >> tried the following command but it's not working:
>> >>
>> >> kamdbctl create openser@<external_mysql_server_ip>
>> >>
>> >> What's the correct command?
>> >>
>> >> Thanks,
>> >> A R
>> >>
>> >>
>> >>
>> >> ________________________________
>> >> Windows Live™: Keep your life in sync. Check it out.
>> >> _______________________________________________
>> >> Kamailio (OpenSER) - Users mailing list
>> >> Users at lists.kamailio.org
>> >> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>> >> http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
>> >>
>> >>
>> >
>> > _______________________________________________
>> > Kamailio (OpenSER) - Users mailing list
>> > Users at lists.kamailio.org
>> > http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>> > http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
>> >
>> >
>>
>> --
>> Daniel-Constantin Mierla
>> http://www.asipto.com/
>>
>
> ________________________________
> Hotmail® has a new way to see what's up with your friends. Check it out.
> _______________________________________________
> Kamailio (OpenSER) - Users mailing list
> Users at lists.kamailio.org
> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
> http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
>



More information about the Users mailing list