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: _______________________________________________ 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

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: -- Daniel-Constantin Mierla http://www.asipto.com/

Date: Thu, 7 May 2009 13:30:37 -0400 Subject: Re: [Kamailio-Users] creating openser db on an external mysql server From: osas(a)voipembedded.com To: alex_rsm(a)hotmail.com CC: miconda(a)gmail.com; users(a)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 &lt;alex_rsm(a)hotmail.com&gt; 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(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 &lt;alex_rsm(a)hotmail.com&gt; >> > 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. > _______________________________________________ > 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 >

Date: Thu, 7 May 2009 14:25:41 -0400 Subject: Re: [Kamailio-Users] creating openser db on an external mysql server From: osas(a)voipembedded.com To: alex_rsm(a)hotmail.com CC: miconda(a)gmail.com; users(a)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 &lt;alex_rsm(a)hotmail.com&gt; 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(a)voipembedded.com >> To: alex_rsm(a)hotmail.com >> CC: miconda(a)gmail.com; users(a)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 &lt;alex_rsm(a)hotmail.com&gt; 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(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 &lt;alex_rsm(a)hotmail.com&gt; >> >> > 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. >> > _______________________________________________ >> > 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 >> > > > ________________________________ > Hotmail® has ever-growing storage! Don’t worry about storage limits. Check > it out.

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(a)&#39;1.1.1.1&#39; 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.

However, When I try to create "openser" database using "kamdbctl create"

command I am getting the following error: