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@voipembedded.com To: alex_rsm@hotmail.com CC: miconda@gmail.com; users@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@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@gmail.com To: alex_rsm@hotmail.com CC: users@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@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@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@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@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_Tutoria...