RT database repointing

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?

[Thu May 19 14:21:15 2005] [notice] Accept mutex: sysvsem (Default:
sysvsem)

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.

RT_SiteConfig.pm is the one you are supposed to modify, not
RT_Config.pmOn Thu, 19 May 2005, Kevin Moran wrote:

Is there something else I have to do other then change the RT_Config.pm?

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,
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?

[Thu May 19 14:21:15 2005] [notice] Accept mutex: sysvsem (Default:
sysvsem)

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

I

have to do other then change the RT_Config.pm?

[Thu May 19 14:21:15 2005] [notice] Accept mutex: sysvsem (Default:
sysvsem)

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.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Daniel Foster
Technical Director

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

I

have to do other then change the RT_Config.pm?

[Thu May 19 14:21:15 2005] [notice] Accept mutex: sysvsem (Default:
sysvsem)

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.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Daniel Foster
Technical Director

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?

KevFrom: Daniel Foster [mailto:daniel@34SP.com]
Sent: 19 May 2005 16:26
To: Kevin Moran
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT database repointing

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

I

have to do other then change the RT_Config.pm?

[Thu May 19 14:21:15 2005] [notice] Accept mutex: sysvsem (Default:
sysvsem)

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.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Daniel Foster
Technical Director

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.

HI,

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?

Kev

-----Original Message-----
From: Daniel Foster [mailto:daniel@34SP.com]
Sent: 19 May 2005 16:26
To: Kevin Moran
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT database repointing

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

I

have to do other then change the RT_Config.pm?

[Thu May 19 14:21:15 2005] [notice] Accept mutex: sysvsem (Default:
sysvsem)

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.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com


Daniel Foster
Technical Director
34SP.com

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.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

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,

-anya

This will fix it:

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

I

have to do other then change the RT_Config.pm?

[Thu May 19 14:21:15 2005] [notice] Accept mutex: sysvsem (Default:
sysvsem)

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.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Stewart Tranter
Computing Services
Loughborough University

E: s.g.tranter@lboro.ac.uk
W: http://www.lboro.ac.uk/computing/
T: +44 (0) 1509 223179
F: +44 (0) 1509 211586