[rt-users] Upgrading to 3.8.0: schema.mysql, column_info selection problem
Ryan Hardester
Ryan.Hardester at ci.tracy.ca.us
Fri Jul 18 16:55:45 EDT 2008
I am still trying to get the last script to run successfully.
My issue to start with is RT is not on the same server as the DB. So
running the mysql scheme script from the RT box is not working. I copy
that file to our DB server and I get the column_info failed error:
DBD::mysql::db column_info failed: column_info doesn't support column
selection at schema.mysql-4.0-4.1.pl line 227.
DBD::mysql::db column_info failed: column_info doesn't support column
selection at schema.mysql-4.0-4.1.pl line 227.
Any ideas on what to do to fix this?
And short of fixing it is there an issue with using the system in its
current state in production? Or should I look to roll back to backups?
--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 11:10 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
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
More information about the rt-users
mailing list