Hi,
Still, I am have problem connecting kamailio to a remote mySQL. Here is what I have done so far:
Let's assume my kamailio and mySQL servers have the following IP: Kamailio: 1.1.1.1 mySQL: 2.2.2.2
I granted "root" user to a access all tables from kamailio host: GRANT ALL ON *.* TO root@'1.1.1.1' IDENTIFIED BY '????';
mysql> select host,user,password from user; 1.1.1.1 | root | *669148???????????????????
After that, I prefectly can connect to the remote mySQL from kamailio directly using "root" user: mysql -h 2.2.2.2 -u root -p??? Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18 Server version: 5.0.51a-3ubuntu5.1-log (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql>
However, When I try to create "openser" database using "kamdbctl create" command I am getting the following error:
$ kamdbctl create MySQL password for root: INFO: test server charset INFO: creating database openser ... ERROR 1044 (42000) at line 2: Access denied for user 'root'@'1.1.1.1' to database 'openser' ERROR: Creating core database and grant privileges failed!
Here is my kamctlrc config file:
DBENGINE=MYSQL
## database host DBHOST=2.2.2.2
## database name DBNAME=openser
# database path used by dbtext or db_berkeley # DB_PATH="/usr/local/etc/openser/dbtext"
## database read/write user #DBRWUSER=openser
## password for database read/write user #DBRWPW="openserrw"
## database read only user #DBROUSER=openserro
## password for database read only user #DBROPW=openserro
## database super user DBROOTUSER="root"
# user name column # USERCOL="username"
Am I missing anything?
Thanks, A R
Date: Thu, 7 May 2009 14:25:41 -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
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@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@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. Check it out.
_________________________________________________________________ Hotmail® has ever-growing storage! Don’t worry about storage limits. http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tutoria...