[SR-Users] kamdbctl create ?

[Fred Posner]

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