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

Alex R.S.M alex_rsm at hotmail.com
Thu May 7 19:18:26 CEST 2009



I also added the following

## database super user
DBROOTUSER="root"



From: alex_rsm at hotmail.com
To: miconda at gmail.com
Date: Thu, 7 May 2009 13:14:00 -0400
CC: users at lists.kamailio.org
Subject: Re: [Kamailio-Users] creating openser db on an external mysql server








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.
_________________________________________________________________
Windows Live™: Keep your life in sync.
http://windowslive.com/explore?ocid=TXT_TAGLM_BR_life_in_synch_052009
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20090507/5c59a5f1/attachment.htm 


More information about the Users mailing list