[Rt-devel] Need help with RT post upgrade

[Janet Houser]

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