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

[Alex R.S.M]

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.
http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tutorial_Storage1_052009
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20090507/ae459f28/attachment.htm>