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