I also added the following
## database super user
DBROOTUSER="root"
From: alex_rsm(a)hotmail.com
To: miconda(a)gmail.com
Date: Thu, 7 May 2009 13:14:00 -0400
CC: users(a)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(a)gmail.com
To: alex_rsm(a)hotmail.com
CC: users(a)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(a)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(a)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(a)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