[OpenSIPS-Users] Disable MySQL secure auth in db_mysql module

Husnain Taseer husnain.taseer at gmail.com
Mon Dec 28 12:04:32 CET 2015

Dear Users,
We have opensips deployed in production environment on a Centos
machine.Version of MySQL installed on that machine is old so the
authentication plugin which is being used on that mysql server is
mysql_old_password. The db user supports old (pre-4.1) Hashing method and
we don't want to upgrade it to newer version because we have too many users
which are using that database. Now when I try to connect opensips with the
db using mysql module it gives me this error:

* ERROR:db_mysql:db_mysql_connect: driver error(2049): Connection using old
(pre-4.1.1) authentication protocol refused (client option 'secure_auth'
*Dec 28 13:21:40 AppServerI ../../sbin/opensips[5211]:
ERROR:db_mysql:db_mysql_new_connection: initial connect failed*
*Dec 28 13:21:40 AppServerI ../../sbin/opensips[5211]:
ERROR:core:db_do_init: could not add connection to the pool*
*Dec 28 13:21:40 AppServerI ../../sbin/opensips[5211]: ERROR:uri:mod_init:
Could not connect to database*
*Dec 28 13:21:40 AppServerI ../../sbin/opensips[5211]: ERROR:core:init_mod:
failed to initialize module uri*
*Dec 28 13:21:40 AppServerI ../../sbin/opensips[5211]: ERROR:core:main:
error while initializing modules*

Is there any way to disable secure_auth in mysql_db module of opensips ?
like from shell mysql client we can use --skip-secure-auth to disable it.

Husnain Taseer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20151228/cc231387/attachment.htm>

More information about the Users mailing list