Can anyone help I am trying to repoint my RT3.2.1 to a new server with a
dump of my mysql db. It doesn’t seem to repointing away from the
localhost as you can see from the logs below. Is there something else I
have to do other then change the RT_Config.pm?
DBI connect(‘dbname=rt3;host=localhost’,‘rt’,…) failed: Can’t connect
to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 132
[Thu May 19 14:21:33 2005] [error] Connect Failed Can’t connect to local
MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
at /opt/rt3/lib/RT.pm line 168
Thanks,
Kevin
This e-mail contains confidential information or information belonging to Servecentric Ltd and is intended solely for the addressee(s). The unauthorized disclosure, use, dissemination or copy (either in whole or in part) of this e-mail, or any information it contains, is prohibited. Any views or opinions presented are solely those of the author and do not necessarily represent those of Servecentric Ltd. E-mails are susceptible to alteration and their integrity cannot be guaranteed. Servecentric shall not be liable for the contents of this e-mail if modified or falsified. If you are not the intended recipient of this e-mail, please delete it immediately from your system and notify the sender of the wrong delivery and of the email’s deletion.
It seemed to take a while but it picked up that it should be pointing
elsewhere but then I found I had to upgrade my MySQL client which I did.
I still an error even though I can access the database from command
line.
DBI connect(‘dbname=rt3;host=212.147.132.31;port=3306’,‘rt’,…) failed:
Client does not support authentication protocol requested by server;
consider upgrading MySQL client at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 132
[Thu May 19 15:28:11 2005] [error] Connect Failed Client does not
support authentication protocol requested by server; consider upgrading
MySQL client
at /opt/rt3/lib/RT.pm line 168
Can anyone help? BTW my perl version is 5.8.5 but it seems as though RT
is still using my old perl version of 5.8.0. Is there anyway of getting
it to use 5.8.5?
Cheers,
KevinFrom: Ramon Kagan [mailto:rkagan@yorku.ca]
Sent: 19 May 2005 14:59
To: Kevin Moran
Subject: Re: [rt-users] RT database repointing
Have you restared your web server?
Ramon Kagan
York University, Computing and Network Services
Information Security - Senior Information Security Analyst
(416)736-2100 #20263
rkagan@yorku.ca
I have not failed. I have just I don’t know the secret to
success,
found 10,000 ways that don’t work. but the secret to failure is
trying to please everybody.
- Thomas Edison - Bill Cosby
Hi,
Can anyone help I am trying to repoint my RT3.2.1 to a new server with
a
dump of my mysql db. It doesn’t seem to repointing away from the
localhost as you can see from the logs below. Is there something else
I
have to do other then change the RT_Config.pm?
DBI connect(‘dbname=rt3;host=localhost’,‘rt’,…) failed: Can’t
connect
to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 132
[Thu May 19 14:21:33 2005] [error] Connect Failed Can’t connect to
local
MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
at /opt/rt3/lib/RT.pm line 168
Thanks,
Kevin
This e-mail contains confidential information or information belonging
to Servecentric Ltd and is intended solely for the addressee(s). The
unauthorized disclosure, use, dissemination or copy (either in whole or
in part) of this e-mail, or any information it contains, is prohibited.
Any views or opinions presented are solely those of the author and do
not necessarily represent those of Servecentric Ltd. E-mails are
susceptible to alteration and their integrity cannot be guaranteed.
Servecentric shall not be liable for the contents of this e-mail if
modified or falsified. If you are not the intended recipient of this
e-mail, please delete it immediately from your system and notify the
sender of the wrong delivery and of the email’s deletion.
Take a look at the MySQL database - OLD_PASSWORD and the like are what
you need.
Kevin Moran wrote:
Hi Ramon,
It seemed to take a while but it picked up that it should be pointing
elsewhere but then I found I had to upgrade my MySQL client which I did.
I still an error even though I can access the database from command
line.
DBI connect(‘dbname=rt3;host=212.147.132.31;port=3306’,‘rt’,…) failed:
Client does not support authentication protocol requested by server;
consider upgrading MySQL client at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 132
[Thu May 19 15:28:11 2005] [error] Connect Failed Client does not
support authentication protocol requested by server; consider upgrading
MySQL client
at /opt/rt3/lib/RT.pm line 168
Can anyone help? BTW my perl version is 5.8.5 but it seems as though RT
is still using my old perl version of 5.8.0. Is there anyway of getting
it to use 5.8.5?
Cheers,
Kevin
-----Original Message-----
From: Ramon Kagan [mailto:rkagan@yorku.ca]
Sent: 19 May 2005 14:59
To: Kevin Moran
Subject: Re: [rt-users] RT database repointing
Have you restared your web server?
Ramon Kagan
York University, Computing and Network Services
Information Security - Senior Information Security Analyst
(416)736-2100 #20263
rkagan@yorku.ca
I have not failed. I have just I don’t know the secret to
success,
found 10,000 ways that don’t work. but the secret to failure is
trying to please everybody.
Thomas Edison - Bill Cosby
Hi,
Can anyone help I am trying to repoint my RT3.2.1 to a new server with
a
dump of my mysql db. It doesn’t seem to repointing away from the
localhost as you can see from the logs below. Is there something else
to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 132
[Thu May 19 14:21:33 2005] [error] Connect Failed Can’t connect to
local
MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
at /opt/rt3/lib/RT.pm line 168
Thanks,
Kevin
This e-mail contains confidential information or information belonging
to Servecentric Ltd and is intended solely for the addressee(s). The
unauthorized disclosure, use, dissemination or copy (either in whole or
in part) of this e-mail, or any information it contains, is prohibited.
Any views or opinions presented are solely those of the author and do
not necessarily represent those of Servecentric Ltd. E-mails are
susceptible to alteration and their integrity cannot be guaranteed.
Servecentric shall not be liable for the contents of this e-mail if
modified or falsified. If you are not the intended recipient of this
e-mail, please delete it immediately from your system and notify the
sender of the wrong delivery and of the email’s deletion.
Sorry, that should have been MySQL documentation not database.
Long day…
Kevin Moran wrote:
Hi Ramon,
It seemed to take a while but it picked up that it should be pointing
elsewhere but then I found I had to upgrade my MySQL client which I did.
I still an error even though I can access the database from command
line.
DBI connect(‘dbname=rt3;host=212.147.132.31;port=3306’,‘rt’,…) failed:
Client does not support authentication protocol requested by server;
consider upgrading MySQL client at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 132
[Thu May 19 15:28:11 2005] [error] Connect Failed Client does not
support authentication protocol requested by server; consider upgrading
MySQL client
at /opt/rt3/lib/RT.pm line 168
Can anyone help? BTW my perl version is 5.8.5 but it seems as though RT
is still using my old perl version of 5.8.0. Is there anyway of getting
it to use 5.8.5?
Cheers,
Kevin
-----Original Message-----
From: Ramon Kagan [mailto:rkagan@yorku.ca]
Sent: 19 May 2005 14:59
To: Kevin Moran
Subject: Re: [rt-users] RT database repointing
Have you restared your web server?
Ramon Kagan
York University, Computing and Network Services
Information Security - Senior Information Security Analyst
(416)736-2100 #20263
rkagan@yorku.ca
I have not failed. I have just I don’t know the secret to
success,
found 10,000 ways that don’t work. but the secret to failure is
trying to please everybody.
Thomas Edison - Bill Cosby
Hi,
Can anyone help I am trying to repoint my RT3.2.1 to a new server with
a
dump of my mysql db. It doesn’t seem to repointing away from the
localhost as you can see from the logs below. Is there something else
to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 132
[Thu May 19 14:21:33 2005] [error] Connect Failed Can’t connect to
local
MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
at /opt/rt3/lib/RT.pm line 168
Thanks,
Kevin
This e-mail contains confidential information or information belonging
to Servecentric Ltd and is intended solely for the addressee(s). The
unauthorized disclosure, use, dissemination or copy (either in whole or
in part) of this e-mail, or any information it contains, is prohibited.
Any views or opinions presented are solely those of the author and do
not necessarily represent those of Servecentric Ltd. E-mails are
susceptible to alteration and their integrity cannot be guaranteed.
Servecentric shall not be liable for the contents of this e-mail if
modified or falsified. If you are not the intended recipient of this
e-mail, please delete it immediately from your system and notify the
sender of the wrong delivery and of the email’s deletion.
Thanks for the info but that doesn’t seem to be the issue. I can access
through the cli using:
Mysql -u rt -h x.x.x.x -p
I use to get
failed: Client does not support authentication protocol requested by
server;
consider upgrading MySQL client
But since I upgraded the client there hasn’t been an issue. RT doesn’t
seem to have recognised the updated Mysql client. Would this have
anything to do with perl modules?
Sorry, that should have been MySQL documentation not database.
Long day…
Kevin Moran wrote:
Hi Ramon,
It seemed to take a while but it picked up that it should be pointing
elsewhere but then I found I had to upgrade my MySQL client which I
did.
I still an error even though I can access the database from command
line.
DBI connect(‘dbname=rt3;host=212.147.132.31;port=3306’,‘rt’,…)
failed:
Client does not support authentication protocol requested by server;
consider upgrading MySQL client at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 132
[Thu May 19 15:28:11 2005] [error] Connect Failed Client does not
support authentication protocol requested by server; consider
upgrading
MySQL client
at /opt/rt3/lib/RT.pm line 168
Can anyone help? BTW my perl version is 5.8.5 but it seems as though
RT
is still using my old perl version of 5.8.0. Is there anyway of
getting
it to use 5.8.5?
Cheers,
Kevin
-----Original Message-----
From: Ramon Kagan [mailto:rkagan@yorku.ca]
Sent: 19 May 2005 14:59
To: Kevin Moran
Subject: Re: [rt-users] RT database repointing
Have you restared your web server?
Ramon Kagan
York University, Computing and Network Services
Information Security - Senior Information Security Analyst
(416)736-2100 #20263
rkagan@yorku.ca
I have not failed. I have just I don’t know the secret
to
success,
found 10,000 ways that don’t work. but the secret to failure is
trying to please everybody.
Thomas Edison - Bill Cosby
Hi,
Can anyone help I am trying to repoint my RT3.2.1 to a new server with
a
dump of my mysql db. It doesn’t seem to repointing away from the
localhost as you can see from the logs below. Is there something else
to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 132
[Thu May 19 14:21:33 2005] [error] Connect Failed Can’t connect to
local
MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
at /opt/rt3/lib/RT.pm line 168
Thanks,
Kevin
This e-mail contains confidential information or information belonging
to Servecentric Ltd and is intended solely for the addressee(s). The
unauthorized disclosure, use, dissemination or copy (either in whole
or
in part) of this e-mail, or any information it contains, is
prohibited.
Any views or opinions presented are solely those of the author and do
not necessarily represent those of Servecentric Ltd. E-mails are
susceptible to alteration and their integrity cannot be guaranteed.
Servecentric shall not be liable for the contents of this e-mail if
modified or falsified. If you are not the intended recipient of this
e-mail, please delete it immediately from your system and notify the
sender of the wrong delivery and of the email’s deletion.
This e-mail contains confidential information or information belonging to Servecentric Ltd and is intended solely for the addressee(s). The unauthorized disclosure, use, dissemination or copy (either in whole or in part) of this e-mail, or any information it contains, is prohibited. Any views or opinions presented are solely those of the author and do not necessarily represent those of Servecentric Ltd. E-mails are susceptible to alteration and their integrity cannot be guaranteed. Servecentric shall not be liable for the contents of this e-mail if modified or falsified. If you are not the intended recipient of this e-mail, please delete it immediately from your system and notify the sender of the wrong delivery and of the email’s deletion.
It could be your perl modules. If they (especially DBI, DBD) were
compiled against mysql libraries prior to your mysql version then you’ll
have problems. If this is an upgrade from 4.0x to 4.1x then you should
add:
old-passwords
to your my.cnf. They changed the password format in 4.1
Ramon Kagan
York University, Computing and Network Services
Information Security - Senior Information Security Analyst
(416)736-2100 #20263
rkagan@yorku.ca
I have not failed. I have just I don’t know the secret to success,
found 10,000 ways that don’t work. but the secret to failure is
trying to please everybody.
- Thomas Edison - Bill Cosby
----------------------------------- ------------------------------------On Thu, 19 May 2005, Kevin Moran wrote:
Hi Daniel,
Thanks for the info but that doesn’t seem to be the issue. I can access
through the cli using:
Mysql -u rt -h x.x.x.x -p
I use to get
failed: Client does not support authentication protocol requested by
server;
consider upgrading MySQL client
But since I upgraded the client there hasn’t been an issue. RT doesn’t
seem to have recognised the updated Mysql client. Would this have
anything to do with perl modules?
Sorry, that should have been MySQL documentation not database.
Long day…
Kevin Moran wrote:
Hi Ramon,
It seemed to take a while but it picked up that it should be pointing
elsewhere but then I found I had to upgrade my MySQL client which I
did.
I still an error even though I can access the database from command
line.
DBI connect(‘dbname=rt3;host=212.147.132.31;port=3306’,‘rt’,…)
failed:
Client does not support authentication protocol requested by server;
consider upgrading MySQL client at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 132
[Thu May 19 15:28:11 2005] [error] Connect Failed Client does not
support authentication protocol requested by server; consider
upgrading
MySQL client
at /opt/rt3/lib/RT.pm line 168
Can anyone help? BTW my perl version is 5.8.5 but it seems as though
RT
is still using my old perl version of 5.8.0. Is there anyway of
getting
it to use 5.8.5?
Cheers,
Kevin
-----Original Message-----
From: Ramon Kagan [mailto:rkagan@yorku.ca]
Sent: 19 May 2005 14:59
To: Kevin Moran
Subject: Re: [rt-users] RT database repointing
Have you restared your web server?
Ramon Kagan
York University, Computing and Network Services
Information Security - Senior Information Security Analyst
(416)736-2100 #20263
rkagan@yorku.ca
I have not failed. I have just I don’t know the secret
to
success,
found 10,000 ways that don’t work. but the secret to failure is
trying to please everybody.
- Thomas Edison - Bill Cosby
On Thu, 19 May 2005, Kevin Moran wrote:
Hi,
Can anyone help I am trying to repoint my RT3.2.1 to a new server with
a
dump of my mysql db. It doesn’t seem to repointing away from the
localhost as you can see from the logs below. Is there something else
to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 132
[Thu May 19 14:21:33 2005] [error] Connect Failed Can’t connect to
local
MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
at /opt/rt3/lib/RT.pm line 168
Thanks,
Kevin
This e-mail contains confidential information or information belonging
to Servecentric Ltd and is intended solely for the addressee(s). The
unauthorized disclosure, use, dissemination or copy (either in whole
or
in part) of this e-mail, or any information it contains, is
prohibited.
Any views or opinions presented are solely those of the author and do
not necessarily represent those of Servecentric Ltd. E-mails are
susceptible to alteration and their integrity cannot be guaranteed.
Servecentric shall not be liable for the contents of this e-mail if
modified or falsified. If you are not the intended recipient of this
e-mail, please delete it immediately from your system and notify the
sender of the wrong delivery and of the email’s deletion.
This e-mail contains confidential information or information belonging to Servecentric Ltd and is intended solely for the addressee(s). The unauthorized disclosure, use, dissemination or copy (either in whole or in part) of this e-mail, or any information it contains, is prohibited. Any views or opinions presented are solely those of the author and do not necessarily represent those of Servecentric Ltd. E-mails are susceptible to alteration and their integrity cannot be guaranteed. Servecentric shall not be liable for the contents of this e-mail if modified or falsified. If you are not the intended recipient of this e-mail, please delete it immediately from your system and notify the sender of the wrong delivery and of the email’s deletion.
You should set:
Set($DatabaseHost , ‘your_db_host’);
in RT_SiteConfig.pm rather than in RT_Config.pm.
In fact, all of your site-specific configs should go in
RT_SiteConfig.pm.
During startup, RT loads settings from RT_Config.pm and then loads those
from RT_SiteConfig.pm. So if you have a variable, say, $DatabaseHost
set to ‘A’ in RT_Config.pm and also set in RT_SiteConfig.pm to ‘B’, the
resulting $DatabaseHost variable will be set to ‘B’.
Hope this helps,
At a MySQL prompt: \u mysql
Then: update user set
Password=OLD_PASSWORD(‘insert_your_password_here’) where user=‘rt_user’;
Then: update user set
Password=OLD_PASSWORD(‘insert_your_password_here’) where user=‘root’
Stewart
Kevin Moran wrote:
Hi Ramon,
It seemed to take a while but it picked up that it should be pointing
elsewhere but then I found I had to upgrade my MySQL client which I did.
I still an error even though I can access the database from command
line.
DBI connect(‘dbname=rt3;host=212.147.132.31;port=3306’,‘rt’,…) failed:
Client does not support authentication protocol requested by server;
consider upgrading MySQL client at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 132
[Thu May 19 15:28:11 2005] [error] Connect Failed Client does not
support authentication protocol requested by server; consider upgrading
MySQL client
at /opt/rt3/lib/RT.pm line 168
Can anyone help? BTW my perl version is 5.8.5 but it seems as though RT
is still using my old perl version of 5.8.0. Is there anyway of getting
it to use 5.8.5?
Cheers,
Kevin
-----Original Message-----
From: Ramon Kagan [mailto:rkagan@yorku.ca]
Sent: 19 May 2005 14:59
To: Kevin Moran
Subject: Re: [rt-users] RT database repointing
Have you restared your web server?
Ramon Kagan
York University, Computing and Network Services
Information Security - Senior Information Security Analyst
(416)736-2100 #20263
rkagan@yorku.ca
I have not failed. I have just I don’t know the secret to
success,
found 10,000 ways that don’t work. but the secret to failure is
trying to please everybody.
Thomas Edison - Bill Cosby
Hi,
Can anyone help I am trying to repoint my RT3.2.1 to a new server with
a
dump of my mysql db. It doesn’t seem to repointing away from the
localhost as you can see from the logs below. Is there something else
to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 132
[Thu May 19 14:21:33 2005] [error] Connect Failed Can’t connect to
local
MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
at /opt/rt3/lib/RT.pm line 168
Thanks,
Kevin
This e-mail contains confidential information or information belonging
to Servecentric Ltd and is intended solely for the addressee(s). The
unauthorized disclosure, use, dissemination or copy (either in whole or
in part) of this e-mail, or any information it contains, is prohibited.
Any views or opinions presented are solely those of the author and do
not necessarily represent those of Servecentric Ltd. E-mails are
susceptible to alteration and their integrity cannot be guaranteed.
Servecentric shall not be liable for the contents of this e-mail if
modified or falsified. If you are not the intended recipient of this
e-mail, please delete it immediately from your system and notify the
sender of the wrong delivery and of the email’s deletion.