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'(a)'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?