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

Max Mühlbronner mm at 42com.com
Mon Dec 28 14:18:37 CET 2015


Sorry, skip_version_check() of auth_db module seems to be related to the 
auth table (not the general mysql auth).


my fault.

BR

Max M.

On 28.12.2015 12:39, Max Mühlbronner wrote:
> Hi,
>
> not sure, but this might help:
>
> http://www.opensips.org/html/docs/modules/1.11.x/auth_db.html#id293636
>
> modparam("auth_db", "skip_version_check", 1)
>
>
> Although in the long term, it's probably better to upgrade mysql.
>
> BR
>
>
> 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
>
>
>
>
> _______________________________________________
> 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/071a6a06/attachment.htm>


More information about the Users mailing list