[rt-users] RT database repointing

[Stewart Tranter]

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 at 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 at 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


-- 
------------------------------------------------
Stewart Tranter
Computing Services
Loughborough University

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