[Rt-devel] Need help with RT post upgrade

[Jacob Helwig]

On Wed, Oct 15, 2008 at 12:05, Janet Houser <jhouser at cfa.harvard.edu> wrote:
>
>
> Ruslan Zakirov wrote:
>> On Tue, Oct 14, 2008 at 4:11 PM, Janet L. Houser
>> <jhouser at cfa.harvard.edu> wrote:
>>
>>>Hi Panu,
>>>
>>>
>>>>>mysql db is version 5 (both prior and post upgrade) and didn't have to
>>>>>be upgraded using:
>>>>>
>>>>>    perl etc/upgrade/schema.mysql-4.0-4.1.pl db user pass > sql.queries
>>>>>
>>>>>Do you happen to know how to fix this problem the "proper" way?
>>>>
>>>>Answer below:
>>>>
>>>>
>>>>>>This should be done even if you already have mysql 5 or 4.1
>>>>>>installed. Better name for the file should be
>>>>>>"mysql_schema_upgrade_for_3.8.1" IMO.
>>>
>>>
>>>Yeah, I tried this and it gave me errors and wouldn't run.  That is why
>>>I thought I didn't need it with mysql vs. 5.
>>
>> Have you reported those errors?
>
> No.  I wanted to see if it was something in the script that I could fix first but
> I haven't had a chance to look into this.
>
>
>  From the UPGRADING.mysql file in rt-3.8.1, it says:
>
>  >=== Upgrading RT from versions prior to 3.8.0 ===
>  >
>  >4) Apply mysql 4.0->4.1 schema changes. RT tarball has script
>  >etc/upgrade/schema.mysql-4.0-4.1.pl that generates SQL queries to upgrade schema of
>  >the DB. Run it:
>  >
>  >    perl etc/upgrade/schema.mysql-4.0-4.1.pl db user pass > sql.queries
>
> When I ran this command, I got the error:
>
> [root at rt rt-3.8.1]# perl etc/upgrade/schema.mysql-4.0-4.1.pl  db user pass  (using db=rt3 and user=root or rt_user)
> DBD::mysql version 4.002 required--this is only version 3.0007 at etc/upgrade/schema.mysql-4.0-4.1.pl line 7.
> BEGIN failed--compilation aborted at etc/upgrade/schema.mysql-4.0-4.1.pl line 7.
>
> [root at rt rt-3.8.1]# mysql --version
> mysql  Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (i686) using readline 5.0
>
> [root at rt rt-3.8.1]# cat /etc/redhat-release
> CentOS release 5.2 (Final)
>
> I don't quite understand the error.  This is a fresh install of centos and I followed the upgrade
> procedures.  I assumed since it was for mysql-4.0 and 4.1 that the error resulted from the fact
> that I have mysql vs. 5.0.45.  However, Panu suggested that it should also be run for
> mysql vs. 5.
>
> thanks.
>
> janet
>
>
>
>>
>>
>>>>If you upgrade from version below 3.8 and use Mysql you have to use the
>>>>method describe above.
>>>>
>>>>The schema script has some bugs so make sure you check the things it
>>>>suggests changing (and better yet try to understand what they mean,
>>>>luckily I got help pointing the errors for me probably saving some time
>>>>and frustration)
>>>
>>>Thanks for your help.
>>>
>>>j
>>>_______________________________________________
>>>List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
>>>
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>> Spam detection software, running on the system "raincoat.cfa.harvard.edu", has
>> identified this incoming email as possible spam.  The original message
>> has been attached to this so you can view it (if it isn't spam) or label
>> similar future email.  If you have any questions, see
>> fst at ipa.harvard.edu for details.
>>
>> Content preview:  On Tue, Oct 14, 2008 at 4:11 PM, Janet L. Houser <jhouser at cfa.harvard.edu>
>>    wrote: > Hi Panu, > >>> >>> mysql db is version 5 (both prior and post upgrade)
>>    and didn't have to >>> be upgraded using: >>> >>> perl etc/upgrade/schema.mysql-4.0-4.1.pl
>>    db user pass > sql.queries >>> >>> Do you happen to know how to fix this
>>   problem the "proper" way? >> >> Answer below: >> >>>> This should be done
>>   even if you already have mysql 5 or 4.1 >>>> installed. Better name for the
>>    file should be >>>> "mysql_schema_upgrade_for_3.8.1" IMO. > > > Yeah, I tried
>>    this and it gave me errors and wouldn't run. That is why > I thought I didn't
>>    need it with mysql vs. 5. Have you reported those errors? [...]
>>
>> Content analysis details:   (4.8 points, 4.0 required)
>>
>>  pts rule name              description
>> ---- ---------------------- --------------------------------------------------
>>  1.4 SPF_NEUTRAL            SPF: sender does not match SPF record (neutral)
>> [SPF failed: Please see http://www.openspf.org/why.html?sender=ruslan.zakirov%40gmail.com&ip=131.142.41.8&receiver=raincoat.cfa.harvard.edu]
>>  2.0 DNS_FROM_SECURITYSAGE  RBL: Envelope sender in
>>                             blackholes.securitysage.com
>>  1.4 DNS_FROM_RFC_POST      RBL: Envelope sender in postmaster.rfc-ignorant.org
>>
>>
>
> --
> Dr. Janet L. Houser
> Chandra X-ray Observatory
> Smithsonian Astrophysical Observatory
> Mail Stop 33
> 60 Garden Street
> Cambridge, MA  02138
> E-mail:    jhouser at cfa.harvard.edu
> Telephone: 617-496-7082
> Fax:       617-496-7049
> _______________________________________________
> List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
>

The problem isn't your MySQL version, it's your DBD::mysql (perl
module) version.  You need to upgrade that to version >= 4.002

-Jacob