[rt-users] Upgrading to 3.8.0: schema.mysql, column_info selection problem

[Jesse Vincent]

On Jul 18, 2008, at 4:55 PM, Ryan Hardester wrote:

> 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?
>
To start, try

sudo cpan DBD::mysql


> 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
> _______________________________________________
> 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
>