[SR-Users] kamdbctl create ?

[Thomas Secula]

I seem to be in a catch 22, sure it's something I've done wrong.

 

I set dbhost in kamctlrc to be the ip of my remote mysql server

I run kamdbctl create and I get

 

root at pcscf:/etc/kamailio# kamdbctl create

MySQL password for root:

database engine 'mysql' loaded

INFO: test server charset

INFO: creating database kamailio ...

INFO: granting privileges to database kamailio ...

ERROR 1044 (42000) at line 1: Access denied for user 'root'@'172.16.101.27'
to database 'kamailio'

ERROR: granting privileges to database kamailio failed!

root at pcscf:/etc/kamailio#

 

Before I run the create from mysql:

 

 

mysql>  select user,host from mysql.user;

+------+---------------+

| user | host          |

+------+---------------+

| root | %             |

| root | 172.16.101.27 |

| root | 172.16.101.28 |

| root | 172.16.101.29 |

| root | localhost     |

+------+---------------+

5 rows in set (0.00 sec)

 

mysql> show grants for 'root'@'%';

+---------------------------------------------------------------------------
-----------------------------------+

| Grants for root@%
|

+---------------------------------------------------------------------------
-----------------------------------+

| GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD
'*FE04940F3F9B339AB9361B2D01AD3D940B215B52' |

+---------------------------------------------------------------------------
-----------------------------------+

1 row in set (0.00 sec)

 

If I rerun it the create scripts says:

 

root at pcscf:/etc/kamailio# kamdbctl create

MySQL password for root:

database engine 'mysql' loaded

INFO: test server charset

INFO: creating database kamailio ...

ERROR 1007 (HY000) at line 1: Can't create database 'kamailio'; database
exists

ERROR: Creating database kamailio failed!

root at pcscf:/etc/kamailio#

 

any ideas?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20131116/19f6fa0e/attachment.html>