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@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@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@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@pcscf:/etc/kamailio#

any ideas?