MySQL Connect errorr

LDB · April 17, 2008, 1:02pm

I am receiving the following error when I connect my apache instance
of RT:

[Thu Apr 17 08:57:46 2008] [error] [client 192.168.10.66] Connect
Failed Client does not support authentication protocol requested by
server; consider upgrading MySQL client\n at /opt/rt3/lib/RT.pm line
220\n

My MySQL version is 5.0.26 on SuSE 9 SP4 using the latest version of
RT. My /etc/apache2/vhosts.d/rt.conf is …

<VirtualHost 192.168.100.48:80>
ServerName rt.example.org
DocumentRoot /opt/rt3/share/html
ServerAdmin noc@example.org
LogLevel debug
ErrorLog /var/log/apache2/rt_error_log
TransferLog /var/log/apache2/rt_access_log

AddDefaultCharset UTF-8

# this line applies to Apache2+mod_perl2 only
# Below line might be incorrect, I had to use:
#     PerlModule Apache2::compat
# mod_perl 2.0.1 from FC4 Linux
#PerlModule Apache2 Apache::compat

SetHandler perl-script
PerlHandler RT::Mason

Alias /rt "/opt/rt3/share/html"
PerlModule Apache::DBI
PerlRequire /opt/rt3/bin/webmux.pl

<Directory /opt/rt3/share/html>
  AllowOverride All
  Options ExecCGI FollowSymLinks
  <IfModule mod_access.c>
     Order allow,deny
      Allow from all
  </IfModule>
</Directory>

<Location /rt>
  RewriteEngine On
  RedirectMatch permanent (.*)/$ $1/index.html
</Location>

Any ideas??

Ruslan_Zakirov1 · April 17, 2008, 1:17pm

This problem is related to mysql and has nothing to do with RT. It’s
very well documented on mysql site.On Thu, Apr 17, 2008 at 5:02 PM, LDB ldbout@gmail.com wrote:

I am receiving the following error when I connect my apache instance
of RT:

[Thu Apr 17 08:57:46 2008] [error] [client 192.168.10.66] Connect
Failed Client does not support authentication protocol requested by
server; consider upgrading MySQL client\n at /opt/rt3/lib/RT.pm line
220\n

My MySQL version is 5.0.26 on SuSE 9 SP4 using the latest version of
RT. My /etc/apache2/vhosts.d/rt.conf is …

<VirtualHost 192.168.100.48:80>
ServerName rt.example.org
DocumentRoot /opt/rt3/share/html
ServerAdmin noc@example.org
LogLevel debug
ErrorLog /var/log/apache2/rt_error_log
TransferLog /var/log/apache2/rt_access_log
AddDefaultCharset UTF-8

# this line applies to Apache2+mod_perl2 only
# Below line might be incorrect, I had to use:
#     PerlModule Apache2::compat
# mod_perl 2.0.1 from FC4 Linux
#PerlModule Apache2 Apache::compat

SetHandler perl-script
PerlHandler RT::Mason

Alias /rt "/opt/rt3/share/html"
PerlModule Apache::DBI
PerlRequire /opt/rt3/bin/webmux.pl

<Directory /opt/rt3/share/html>
  AllowOverride All
  Options ExecCGI FollowSymLinks
  <IfModule mod_access.c>
     Order allow,deny
      Allow from all
  </IfModule>
</Directory>

<Location /rt>
  RewriteEngine On
  RedirectMatch permanent (.*)/$ $1/index.html
</Location>
Any ideas??

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

LDB · April 17, 2008, 1:19pm

Yes, I have looked through the documentation there and none of it
seemingly
applies. I will search again though …

LDBOn Apr 17, 2008, at 9:17 AM, Ruslan Zakirov wrote:

This problem is related to mysql and has nothing to do with RT. It’s
very well documented on mysql site.

On Thu, Apr 17, 2008 at 5:02 PM, LDB ldbout@gmail.com wrote:

I am receiving the following error when I connect my apache instance
of RT:

[Thu Apr 17 08:57:46 2008] [error] [client 192.168.10.66] Connect
Failed Client does not support authentication protocol requested by
server; consider upgrading MySQL client\n at /opt/rt3/lib/RT.pm line
220\n

My MySQL version is 5.0.26 on SuSE 9 SP4 using the latest version of
RT. My /etc/apache2/vhosts.d/rt.conf is …

<VirtualHost 192.168.100.48:80>
ServerName rt.example.org
DocumentRoot /opt/rt3/share/html
ServerAdmin noc@example.org
LogLevel debug
ErrorLog /var/log/apache2/rt_error_log
TransferLog /var/log/apache2/rt_access_log

AddDefaultCharset UTF-8

this line applies to Apache2+mod_perl2 only

Below line might be incorrect, I had to use:

PerlModule Apache2::compat

mod_perl 2.0.1 from FC4 Linux

#PerlModule Apache2 Apache::compat

SetHandler perl-script
PerlHandler RT::Mason

Alias /rt “/opt/rt3/share/html”
PerlModule Apache::DBI
PerlRequire /opt/rt3/bin/webmux.pl

<Directory /opt/rt3/share/html>
AllowOverride All
Options ExecCGI FollowSymLinks

Order allow,deny
Allow from all

<Location /rt>
RewriteEngine On
RedirectMatch permanent (.*)/$ $1/index.html

Any ideas??

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

–
Best regards, Ruslan.

LDB · April 17, 2008, 1:22pm

Does the following apply to RT …

Tell the server to use the older password hashing algorithm

?

Thanks,

LDBOn Apr 17, 2008, at 9:17 AM, Ruslan Zakirov wrote:

This problem is related to mysql and has nothing to do with RT. It’s
very well documented on mysql site.

On Thu, Apr 17, 2008 at 5:02 PM, LDB ldbout@gmail.com wrote:

I am receiving the following error when I connect my apache instance
of RT:

[Thu Apr 17 08:57:46 2008] [error] [client 192.168.10.66] Connect
Failed Client does not support authentication protocol requested by
server; consider upgrading MySQL client\n at /opt/rt3/lib/RT.pm line
220\n

My MySQL version is 5.0.26 on SuSE 9 SP4 using the latest version of
RT. My /etc/apache2/vhosts.d/rt.conf is …

<VirtualHost 192.168.100.48:80>
ServerName rt.example.org
DocumentRoot /opt/rt3/share/html
ServerAdmin noc@example.org
LogLevel debug
ErrorLog /var/log/apache2/rt_error_log
TransferLog /var/log/apache2/rt_access_log

AddDefaultCharset UTF-8

this line applies to Apache2+mod_perl2 only

Below line might be incorrect, I had to use:

PerlModule Apache2::compat

mod_perl 2.0.1 from FC4 Linux

#PerlModule Apache2 Apache::compat

SetHandler perl-script
PerlHandler RT::Mason

Alias /rt “/opt/rt3/share/html”
PerlModule Apache::DBI
PerlRequire /opt/rt3/bin/webmux.pl

<Directory /opt/rt3/share/html>
AllowOverride All
Options ExecCGI FollowSymLinks

Order allow,deny
Allow from all

<Location /rt>
RewriteEngine On
RedirectMatch permanent (.*)/$ $1/index.html

Any ideas??

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

–
Best regards, Ruslan.

LDB · April 17, 2008, 1:25pm

Sure enough that was it …

It uses the old client protocol …

Thanks,

LDBOn Apr 17, 2008, at 9:17 AM, Ruslan Zakirov wrote:

This problem is related to mysql and has nothing to do with RT. It’s
very well documented on mysql site.

On Thu, Apr 17, 2008 at 5:02 PM, LDB ldbout@gmail.com wrote:

I am receiving the following error when I connect my apache instance
of RT:

[Thu Apr 17 08:57:46 2008] [error] [client 192.168.10.66] Connect
Failed Client does not support authentication protocol requested by
server; consider upgrading MySQL client\n at /opt/rt3/lib/RT.pm line
220\n

My MySQL version is 5.0.26 on SuSE 9 SP4 using the latest version of
RT. My /etc/apache2/vhosts.d/rt.conf is …

<VirtualHost 192.168.100.48:80>
ServerName rt.example.org
DocumentRoot /opt/rt3/share/html
ServerAdmin noc@example.org
LogLevel debug
ErrorLog /var/log/apache2/rt_error_log
TransferLog /var/log/apache2/rt_access_log

AddDefaultCharset UTF-8

this line applies to Apache2+mod_perl2 only

Below line might be incorrect, I had to use:

PerlModule Apache2::compat

mod_perl 2.0.1 from FC4 Linux

#PerlModule Apache2 Apache::compat

SetHandler perl-script
PerlHandler RT::Mason

Alias /rt “/opt/rt3/share/html”
PerlModule Apache::DBI
PerlRequire /opt/rt3/bin/webmux.pl

<Directory /opt/rt3/share/html>
AllowOverride All
Options ExecCGI FollowSymLinks

Order allow,deny
Allow from all

<Location /rt>
RewriteEngine On
RedirectMatch permanent (.*)/$ $1/index.html

Any ideas??

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

–
Best regards, Ruslan.

Ruslan_Zakirov1 · April 17, 2008, 2:21pm

the server != RT, but == mysql server! If you’re going to use “older
password hashing algorithm” then you should read mysql docs to
understand consequences.On Thu, Apr 17, 2008 at 5:22 PM, LDB ldbout@gmail.com wrote:

Does the following apply to RT …
    Tell the server to use the older password hashing algorithm
?

Thanks,

LDB

On Apr 17, 2008, at 9:17 AM, Ruslan Zakirov wrote:

This problem is related to mysql and has nothing to do with RT. It’s
very well documented on mysql site.

On Thu, Apr 17, 2008 at 5:02 PM, LDB ldbout@gmail.com wrote:

I am receiving the following error when I connect my apache instance
of RT:

[Thu Apr 17 08:57:46 2008] [error] [client 192.168.10.66] Connect
Failed Client does not support authentication protocol requested by
server; consider upgrading MySQL client\n at /opt/rt3/lib/RT.pm line
220\n

My MySQL version is 5.0.26 on SuSE 9 SP4 using the latest version of
RT. My /etc/apache2/vhosts.d/rt.conf is …

<VirtualHost 192.168.100.48:80>
ServerName rt.example.org
DocumentRoot /opt/rt3/share/html
ServerAdmin noc@example.org
LogLevel debug
ErrorLog /var/log/apache2/rt_error_log
TransferLog /var/log/apache2/rt_access_log

AddDefaultCharset UTF-8

this line applies to Apache2+mod_perl2 only

Below line might be incorrect, I had to use:

PerlModule Apache2::compat

mod_perl 2.0.1 from FC4 Linux

#PerlModule Apache2 Apache::compat

SetHandler perl-script
PerlHandler RT::Mason

Alias /rt “/opt/rt3/share/html”
PerlModule Apache::DBI
PerlRequire /opt/rt3/bin/webmux.pl

<Directory /opt/rt3/share/html>
AllowOverride All
Options ExecCGI FollowSymLinks

Order allow,deny
Allow from all

<Location /rt>
RewriteEngine On
RedirectMatch permanent (.*)/$ $1/index.html

Any ideas??

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

–
Best regards, Ruslan.

Best regards, Ruslan.