<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Sorry, skip_version_check() of auth_db
module seems to be related to the auth table (not the general
mysql auth).<br>
<br>
<br>
my fault.<br>
<br>
BR<br>
<br>
Max M.<br>
<br>
On 28.12.2015 12:39, Max Mühlbronner wrote:<br>
</div>
<blockquote cite="mid:56811F82.9050101@42com.com" type="cite">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>
modparam("auth_db", "skip_version_check", 1)
<br>
<br>
<br>
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>
<blockquote type="cite">Dear Users,
<br>
We have opensips deployed in production environment on a Centos
<br>
machine.Version of MySQL installed on that machine is old so the
<br>
authentication plugin which is being used on that mysql server
is
<br>
mysql_old_password. The db user supports old (pre-4.1) Hashing
method and
<br>
we don't want to upgrade it to newer version because we have too
many users
<br>
which are using that database. Now when I try to connect
opensips with the
<br>
db using mysql module it gives me this error:
<br>
<br>
* ERROR:db_mysql:db_mysql_connect: driver error(2049):
Connection using old
<br>
(pre-4.1.1) authentication protocol refused (client option
'secure_auth'
<br>
enabled)*
<br>
*Dec 28 13:21:40 AppServerI ../../sbin/opensips[5211]:
<br>
ERROR:db_mysql:db_mysql_new_connection: initial connect failed*
<br>
*Dec 28 13:21:40 AppServerI ../../sbin/opensips[5211]:
<br>
ERROR:core:db_do_init: could not add connection to the pool*
<br>
*Dec 28 13:21:40 AppServerI ../../sbin/opensips[5211]:
ERROR:uri:mod_init:
<br>
Could not connect to database*
<br>
*Dec 28 13:21:40 AppServerI ../../sbin/opensips[5211]:
ERROR:core:init_mod:
<br>
failed to initialize module uri*
<br>
*Dec 28 13:21:40 AppServerI ../../sbin/opensips[5211]:
ERROR:core:main:
<br>
error while initializing modules*
<br>
<br>
Is there any way to disable secure_auth in mysql_db module of
opensips ?
<br>
like from shell mysql client we can use --skip-secure-auth to
disable it.
<br>
<br>
Regards,
<br>
Husnain Taseer
<br>
<br>
<br>
<br>
_______________________________________________
<br>
Users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<br>
<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>
<br>
</blockquote>
<br>
<br>
<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>
<br>
</body>
</html>