Ruslan Zakirov 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 ===
-
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@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@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@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@ipa.harvard.edu for details.
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@cfa.harvard.edu
Telephone: 617-496-7082
Fax: 617-496-7049