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?
_______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
