[rt-users] DBD::mysql error when installing rt 3.8.2 on Cent OS 5.2

2009-02-18 Thread Shannon Adams
I am in the process of migrating RT from an old server running Fedora Core 4, 
RT ver 3.8.1, and mysql version 4.1.20-log.  I upgraded RT on this old server a 
while back and ran into the random logouts, binary attachment problems, etc.
  
I have installed a new server running Cent OS 5.2.  The installation of RT 
3.8.2 and restore of the data from the old server is complete. This server is 
running mysql version 5.0.45.

>From what I have read in all the documents, I need to upgrade my database on 
>the new server since it was running on an old version of mysql.  However, when 
>I run this:  "perl etc/upgrade/upgrade-mysql-schema.pl rt3 password password > 
>sql.queries", it returns:

DBD::mysql version 4.002 required--this is only version 3.0007 at etc/upgrade/up
grade-mysql-schema.pl line 7.   
BEGIN failed--compilation aborted at etc/upgrade/upgrade-mysql-schema.pl line 7.

To attempt to upgrade DBD::mysql, I run: perl -MCPAN -e'install DBD::mysql' 
but, it returns:

Running make install
make test had returned bad status, won't install without force

Any ideas?


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

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


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


Re: [rt-users] DBD::mysql error when installing rt 3.8.2 on Cent OS 5.2

2009-02-18 Thread Chaim Rieger
Shannon Adams wrote:
> I am in the process of migrating RT from an old server running Fedora Core 4, 
> RT ver 3.8.1, and mysql version 4.1.20-log.  I upgraded RT on this old server 
> a while back and ran into the random logouts, binary attachment problems, etc.
>   
> I have installed a new server running Cent OS 5.2.  The installation of RT 
> 3.8.2 and restore of the data from the old server is complete. This server is 
> running mysql version 5.0.45.
> 
> From what I have read in all the documents, I need to upgrade my database on 
> the new server since it was running on an old version of mysql.  However, 
> when I run this:  "perl etc/upgrade/upgrade-mysql-schema.pl rt3 password 
> password > sql.queries", it returns:
> 
> DBD::mysql version 4.002 required--this is only version 3.0007 at 
> etc/upgrade/up
> grade-mysql-schema.pl line 7. 
>   
> BEGIN failed--compilation aborted at etc/upgrade/upgrade-mysql-schema.pl line 
> 7.
> 
> To attempt to upgrade DBD::mysql, I run: perl -MCPAN -e'install DBD::mysql' 
> but, it returns:
> 
> Running make install
> make test had returned bad status, won't install without force
> 
> Any ideas?
> 
> 
thats because the test user on your mysql db requires a passwd

cpan
look DBD::mysql
read the docs and provide the passwd for the test user
perl Makefile.pl
..

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

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


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


Re: [rt-users] DBD::mysql error when installing rt 3.8.2 on Cent OS 5.2

2009-02-18 Thread Sean Corey
cpan

upgrade DBD::mysql

Your version of DBD::mysql is to old to do the upgrade. I ran into this 
earlier today.

Thanks,
Sean Corey

Shannon Adams wrote:
> I am in the process of migrating RT from an old server running Fedora Core 4, 
> RT ver 3.8.1, and mysql version 4.1.20-log.  I upgraded RT on this old server 
> a while back and ran into the random logouts, binary attachment problems, etc.
>   
> I have installed a new server running Cent OS 5.2.  The installation of RT 
> 3.8.2 and restore of the data from the old server is complete. This server is 
> running mysql version 5.0.45.
>
> From what I have read in all the documents, I need to upgrade my database on 
> the new server since it was running on an old version of mysql.  However, 
> when I run this:  "perl etc/upgrade/upgrade-mysql-schema.pl rt3 password 
> password > sql.queries", it returns:
>
> DBD::mysql version 4.002 required--this is only version 3.0007 at 
> etc/upgrade/up
> grade-mysql-schema.pl line 7. 
>   
> BEGIN failed--compilation aborted at etc/upgrade/upgrade-mysql-schema.pl line 
> 7.
>
> To attempt to upgrade DBD::mysql, I run: perl -MCPAN -e'install DBD::mysql' 
> but, it returns:
>
> Running make install
> make test had returned bad status, won't install without force
>
> Any ideas?
>
>
>   
> ___
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sa...@bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>   

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

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


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