[rt-users] Upgrading to 3.8.0: schema.mysql, column_info selection problem
Fernando Frota Machado de Morais
frota at cecom.ufmg.br
Wed Jul 16 21:58:44 EDT 2008
I think my experience will not help anyone, but it's from all the others, so I
think it can be usefull:
I had the same problem in my production RT server. But I did a brand new
installation of RT 3.8 in my personal computer, then I removed completely the
database and restored a copy from the production server. I had no problems
during the execution of the script, but I had problems when I was executing
the "sql.queries" at the line
#ALTER TABLE CustomFields MODIFY LookupType VARCHAR(255) CHARACTER SET ascii
NOT NULL DEFAULT NULL
So, I comented the line and continue to run the script. Things are working
well.
Im my production server, I was not able to generate the "sql.queries" file,
but, despite of that, things are working fine. I had to run mannually all the
update scripts since 3.6.5, but it's ok, probably documentation will be
updated for 3.8.1.
RT production server ir running
mysql-server-5.0.45-6.fc7 and
perl-DBD-MySQL-3.0008-1.fc7 (DBD::mysql v3.0008)
My working computer is running
mysql-server-5.0.51a-1.fc9 and
perl-DBD-MySQL-4.005-8.fc9
but testdeps and fixdeps executed fine at both computers.
Em Wednesday 16 July 2008 16:13:24 jmoseley at corp.xanadoo.com escreveu:
> Ruslan, thanks for sharing this.
>
>
> James Moseley
>
>
>
>
>
> "Ruslan Zakirov"
> <ruz at bestpractica
> l.com> To
> Sent by: jmoseley at corp.xanadoo.com
> ruslan.zakirov at gm cc
> ail.com rt-users at lists.bestpractical.com
> Subject
> Re: [rt-users] Upgrading to 3.8.0:
> 07/16/2008 01:09 schema.mysql,column_info selection
> PM problem
>
>
>
>
>
>
>
>
>
>
> Let's make it clear:
> * you still must upgrade DB using files in etc/upgrade/x.x.x/
> * however in 3.8.0 you can do it using one command:
>
> rt-setup-database --dba root --prompt-for-dba-password --action upgrade
>
> it will ask for the old version (for example you can enter 3.6.7) and
> will apply all steps up to the installed version (in this case it's
> 3.8.0)
>
> * then you do mysql schema changes using the script
> * these schema changes are required for all mysql versions greater
> than mysql 4.1.0
>
> * people installing for the first time will get new DB schema as there
> are two different schema files for mysql in etc/, so they don't need
> to do all these steps
> * people upgrading mysql server from 4.0 to 4.1 and newer should use
> the script two
>
> * I tested this script several times, but only on my dev PC, so it's
> VERY recommended to backup and make tests
>
> Clear?
>
> On Wed, Jul 16, 2008 at 8:03 PM, <jmoseley at corp.xanadoo.com> wrote:
> > Interesting. We're running 5.0.27 and the script worked just fine.
> > However, I ran all the schema/acl/insert upgrade commands using all the
> > 5.7.xx directories in etc/upgrade.
> >
> > Still waiting to hear from Ruslan to confirm 100% that you don't need to
> > run all these commands and you need only run the schema.mysql-4.0-4.1.pl
> > script.
> >
> > Additionally, not entirely sure, but it sounds like he acknowledges there
> > is a problem with the script.
> >
> >
> > James Moseley
> >
> >
> >
> >
> >
> > "Ryan Hardester"
> > <Ryan.Hardester at c
> > i.tracy.ca.us> To
> > "Ruslan Zakirov"
> > 07/16/2008 10:41 <ruz at bestpractical.com>,
> > AM <jmoseley at corp.xanadoo.com>
> > cc
> > <rt-users at lists.bestpractical.com>
> > Subject
> > RE: [rt-users] Upgrading to 3.8.0:
> > schema.mysql,column_info selection
> > problem
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > I am getting the same column_info failed error message when running the
> > script. I'm using mysql5.0.22 on Ubuntu. I did have to move this file to
> > the DB server since we are not running RT and the DB on the same
> > machine.
> >
> > --Ryan
> >
> > -----Original Message-----
> > From: rt-users-bounces at lists.bestpractical.com
> > [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Ruslan
> > Zakirov
> > Sent: Wednesday, July 16, 2008 6:57 AM
> > To: jmoseley at corp.xanadoo.com
> > Cc: rt-users at lists.bestpractical.com
> > Subject: Re: [rt-users] Upgrading to 3.8.0: schema.mysql,column_info
> > selection problem
> >
> > In 3.8.0 it's one step :)
> >
> > However, we've done changes to mysql DB that require additional
> > upgrade steps for mysql, and this step fails.
> >
> > On Wed, Jul 16, 2008 at 5:24 PM, <jmoseley at corp.xanadoo.com> wrote:
> >> Did you follow these steps first?
> >>
> >> You may also need to update RT's database. To find out, type:
> >>
> >> ls etc/upgrade
> >>
> >> For each item in that directory whose name is greater than
> >> your previously installed RT version, run:
> >>
> >> /opt/rt3/sbin/rt-setup-database --action schema \
> >> --datadir etc/upgrade/<version>
> >> /opt/rt3/sbin/rt-setup-database --action acl \
> >> --datadir etc/upgrade/<version>
> >> /opt/rt3/sbin/rt-setup-database --action insert \
> >> --datadir etc/upgrade/<version>
> >>
> >>
> >> There are 10 3.7.xx directories that you'll need to go through.
> >>
> >>
> >> James Moseley
> >>
> >>
> >>
> >>
> >>
> >> "web master"
> >> <webmaster at acelle
> >> ra.com>
> >
> > To
> >
> >> Sent by: rt-users at lists.bestpractical.com
> >> rt-users-bounces@
> >
> > cc
> >
> >> lists.bestpractic
> >> al.com
> >
> > Subject
> >
> >> [rt-users] Upgrading to 3.8.0:
> >> schema.mysql, column_info
> >> 07/16/2008 05:00 selection problem
> >> AM
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> Hi there
> >> I am having schema.mysql-4.0-4.1.pl problems upgrading to version
> >> 3.8.0 from 3.6.6.
> >> make upgrade worked well.
> >>
> >> As in point 4) of UPGRADING.mysql
> >>
> >> [X at Y]#perl etc/upgrade/schema.mysql-4.0-4.1.pl > sql.queries
> >>
> >> but
> >>
> >> usage: etc/upgrade/schema.mysql-4.0-4.1.pl db_name db_user db_password
> >>
> >> Ok, then I inserted the info needed
> >>
> >> [X at Y]#perl etc/upgrade/schema.mysql-4.0-4.1.pl DB USER PASS >
> >
> > sql.queries
> >
> >> but
> >>
> >> DBD::mysql::db column_info failed: column_info doesn't support column
> >> selection at etc/upgrade/schema.mysql-4.0-4.1.pl line 227.
> >> DBD::mysql::db column_info failed: column_info doesn't support column
> >> selection at etc/upgrade/schema.mysql-4.0-4.1.pl line 227.
> >>
> >> RT 3.6.6 was installed a month ago on MySQL 5.0, maybe I do not need
> >> to run chema.mysql-4.0-4.1.pl, but UPGRADING.mysql (not present in
> >> 3.6.6 tarball), it seems to suggest so.
> >>
> >> Can anybody please help?
> >> Cheers
> >> _______________________________________________
> >> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> >>
> >> Community help: http://wiki.bestpractical.com
> >> Commercial support: sales at 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: sales at bestpractical.com
> >>
> >>
> >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> >> Buy a copy at http://rtbook.bestpractical.com
> >
> > --
> > Best regards, Ruslan.
> > _______________________________________________
> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> >
> > Community help: http://wiki.bestpractical.com
> > Commercial support: sales at bestpractical.com
> >
> >
> > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> > Buy a copy at http://rtbook.bestpractical.com
>
> --
> Best regards, Ruslan.
>
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
--
Fernando Frota Machado de Morais
IR Team - Divisao de Redes de Comunicacao
Centro de Computacao
Universidade Federal de Minas Gerais
Brasil
Tel. +55(31)3409.4007 Fax. +55(31)3409.4004
More information about the rt-users
mailing list