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

Max Mühlbronner mm at 42com.com
Mon Dec 28 12:39:46 CET 2015


not sure, but this might help:


modparam("auth_db", "skip_version_check", 1)

Although in the long term, it's probably better to upgrade mysql.


Max M.

On 28.12.2015 12:04, Husnain Taseer wrote:
> 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'
> enabled)*
> *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.
> Regards,
> Husnain Taseer
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

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

More information about the Users mailing list