Hi Team,
We have SSL in mySQL DB.So I need to add configuration in kamailio also.I am adding the configuration I tried. Please help me to achieve this.Its little urgent.
My /etc/mysql/my.cnf [client] socket = /run/mysqld/mysqld.sock ssl_key=/var/lib/mysql/Quant-certs/client-key.pem ssl_cert=/var/lib/mysql/Quant-certs/client_ca_cert.pem ssl_ca=/var/lib/mysql/Quant-certs/server-ca.pem #require_secure_transport = ON
[kamailio] socket = /run/mysqld//mysqld.sock #require_secure_transport = ON user = kamailio password = kamailiorw host=xxx.xxx.xxx.xxx default-character-set = utf8 ssl_key=/var/lib/mysql/Quant-certs/client-key.pem ssl_cert=/var/lib/mysql/Quant-certs/client_ca_cert.pem ssl_ca=/var/lib/mysql/Quant-certs/server-ca.pem ssl_verify=1
/etc/kamailio/kamailio.cfg
#!ifndef DBURL #!define DBURL "mysql://kamailio:kamailiorw@xx.xx.xxx.xxx/kamailio" #!endif
gateqeeper-kam-dev kamailio[7879]: 0(7879) DEBUG: db_mysql [km_my_con.c:107]: db_mysql_new_connection(): opening connection: mysql://xxxx:xxxx@xx.xxx.xx.xxx/kamailio Jun 27 06:53:12 gateqeeper-kam-dev kamailio[7879]: 0(7879) ERROR: db_mysql [km_my_con.c:139]: db_mysql_new_connection(): driver error: Access denied for user 'kamailio'@'xx.xxx.xx.xx' (using password: YES)
Please help me to get it solved.
Thanks & Regards Jeetha P J