16 Nov
2013
16 Nov
'13
5:05 p.m.
From the error, it looks like the tables, etc were created and the
failure was in granting the privileges.
You can always grant them manually, or drop the kamailio database and
try the script again.
Fred Posner | The Palner Group
direct: 503-914-0999 | fax: 954-472-2896
On 11/16/2013 04:10 PM, Thomas Secula wrote:
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?
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users