<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Hi,<br>
<br>
not sure, but this might help:<br>
<br>
<a class="moz-txt-link-freetext" href="http://www.opensips.org/html/docs/modules/1.11.x/auth_db.html#id293636">http://www.opensips.org/html/docs/modules/1.11.x/auth_db.html#id293636</a><br>
<br>
<pre class="programlisting">modparam("auth_db", "skip_version_check", 1)
</pre>
Although in the long term, it's probably better to upgrade mysql.<br>
<br>
BR<br>
<br>
<br>
Max M.<br>
<br>
On 28.12.2015 12:04, Husnain Taseer wrote:<br>
</div>
<blockquote
cite="mid:CALkA4hK45-LkSu1oeZ0StOgboCBvF9vMYJH8iFOauEGSUVd5rQ@mail.gmail.com"
type="cite">
<pre wrap="">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
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>