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

I also added the following

## database super user DBROOTUSER="root"

From: alex_rsm@hotmail.com To: miconda@gmail.com Date: Thu, 7 May 2009 13:14:00 -0400 CC: users@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@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. _________________________________________________________________ Windows Live™: Keep your life in sync. http://windowslive.com/explore?ocid=TXT_TAGLM_BR_life_in_synch_052009

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...

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...

I fix the problem by granting 'root' user as follow:

GRANT ALL PRIVILEGES ON *.* TO root@'????' IDENTIFIED BY '####' WITH GRANT OPTION;

Thanks to everyone who responded to my email.

A R

From: henning.westerholt@1und1.de To: users@lists.kamailio.org Subject: Re: [Kamailio-Users] creating openser db on an external mysql server Date: Fri, 8 May 2009 18:42:37 +0200 CC: alex_rsm@hotmail.com; osas@voipembedded.com

On Freitag, 8. Mai 2009, Alex R.S.M wrote:

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:

Hi Alex,

i've tried to reproduce your problem on a remote mysql with db. I run into the same problem as you if i failed to grant the "Grant_priv" to my remote user. Can you take a look if the root user has this right? This right is aparently not included in '*.*'.

Cheers,

Henning

_________________________________________________________________ Windows Live™: Keep your life in sync. http://windowslive.com/explore?ocid=TXT_TAGLM_BR_life_in_synch_052009