[rt-users] RT database repointing

Thu May 19 12:10:37 EDT 2005

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 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 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 at 34SP.com]
> Sent: 19 May 2005 16:26
> To: Kevin Moran
> Cc: rt-users at 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 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
> >
>
>
> --
> 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
>
>