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. Check it out.