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

[Ovidiu Sas]

IIRC I ran into a similar issue. You will need to replace % with the
IP of your remote machine and it will work.


Regards,
Ovidiu Sas

On Thu, May 7, 2009 at 1:39 PM, Alex R.S.M <alex_rsm at hotmail.com> wrote:
>
> root has full privilege and is accessible from remote connection.
> This is how I granted:
>
> GRANT ALL ON *.* TO root@'%' IDENTIFIED BY '???';
>
>
>
>> Date: Thu, 7 May 2009 13:30:37 -0400
>> Subject: Re: [Kamailio-Users] creating openser db on an external mysql
>> server
>> From: osas at voipembedded.com
>> To: alex_rsm at hotmail.com
>> CC: miconda at gmail.com; users at lists.kamailio.org
>>
>> 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
>> >
>
> ________________________________
> Hotmail® has ever-growing storage! Don’t worry about storage limits. Check
> it out.