Upgrading to 3.8.0: schema.mysql, column_info selection problem

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

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@acelle                                             
         ra.com>                                                    To 
         Sent by:                  rt-users@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@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@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@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

In 3.8.0 it’s one step :slight_smile:

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@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@acelle
        ra.com>                                                    To
        Sent by:                  rt-users@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@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@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@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@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.

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

[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Ruslan
ZakirovSent: Wednesday, July 16, 2008 6:57 AM
To: jmoseley@corp.xanadoo.com
Cc: rt-users@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 :slight_smile:

However, we’ve done changes to mysql DB that require additional
upgrade steps for mysql, and this step fails.

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@acelle
        ra.com>

To

        Sent by:                  rt-users@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@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@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@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@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@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

So, if you are upgrading from 3.6.x to 3.8.0, you don’t need to follow the
step below?

You may also need to update RT’s database. To find out, type:

  ls etc/upgrade

Also, which step that you refer to below fails? Fails for everyone?

James Moseley

         "Ruslan Zakirov"                                              
         <ruz@bestpractica                                             
         l.com>                                                     To 
         Sent by:                  jmoseley@corp.xanadoo.com           
         ruslan.zakirov@gm                                          cc 
         ail.com                   rt-users@lists.bestpractical.com    
                                                               Subject 
                                   Re: [rt-users] Upgrading to 3.8.0:  
         07/16/2008 08:56          schema.mysql, column_info selection 
         AM                        problem                             

In 3.8.0 it’s one step :slight_smile:

However, we’ve done changes to mysql DB that require additional
upgrade steps for mysql, and this step fails.

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@c                                             
         i.tracy.ca.us>                                             To 
                                   "Ruslan Zakirov"                    
         07/16/2008 10:41          <ruz@bestpractical.com>,            
         AM                        <jmoseley@corp.xanadoo.com>         
                                                                    cc 
                                   <rt-users@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

[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Ruslan
ZakirovSent: Wednesday, July 16, 2008 6:57 AM
To: jmoseley@corp.xanadoo.com
Cc: rt-users@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 :slight_smile:

However, we’ve done changes to mysql DB that require additional
upgrade steps for mysql, and this step fails.

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@acelle
        ra.com>

To

        Sent by:                  rt-users@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@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@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@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@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@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Well I ran all the etc/upgrade/3.7.* upgrades and then created the
query script with schema.mysql-4.0-4.1.pl and I get this error,

ERROR 1067 (42000) at line 36: Invalid default value for ‘LookupType’

I am using Server version: 5.0.51a.

I am confused as well, if you are already on mysql > 4.0 do you need
to run the queries created by schema.mysql-4.0-4.1.pl? I think the
answer is probably yes, since the char set is changed to utf8.On Wed, 2008-07-16 at 11:03 -0500, jmoseley@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@c                                             
         i.tracy.ca.us>                                             To 
                                   "Ruslan Zakirov"                    
         07/16/2008 10:41          <ruz@bestpractical.com>,            
         AM                        <jmoseley@corp.xanadoo.com>         
                                                                    cc 
                                   <rt-users@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@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Ruslan
Zakirov
Sent: Wednesday, July 16, 2008 6:57 AM
To: jmoseley@corp.xanadoo.com
Cc: rt-users@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 :slight_smile:

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@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@acelle
        ra.com>

To

        Sent by:                  rt-users@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@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@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@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@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@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@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

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@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@c
        i.tracy.ca.us>                                             To
                                  "Ruslan Zakirov"
        07/16/2008 10:41          <ruz@bestpractical.com>,
        AM                        <jmoseley@corp.xanadoo.com>
                                                                   cc
                                  <rt-users@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@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Ruslan
Zakirov
Sent: Wednesday, July 16, 2008 6:57 AM
To: jmoseley@corp.xanadoo.com
Cc: rt-users@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 :slight_smile:

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@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@acelle
        ra.com>

To

        Sent by:                  rt-users@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@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@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@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@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@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.

Your local version of DBD::mysql is out of date. The relevant notes from my rt3.8 upgrade on Debian Etch are below. Hope that helps.

Kris Boutilier
Information Services Coordinator
Sunshine Coast Regional District

‘column_info failed: column_info doesn’t support column selection’ means DBD::mysql is probably out of date, so check installed version of DBD::mysql

perl -MCPAN -e 'print CPAN::Shell->r ’

Package namespace installed latest in CPAN file

DBD::mysql 3.0008 4.007 CAPTTOFU/DBD-mysql-4.007.tar.gz

What does Debian provide as a package and are we up to date?

rt38:/# apt-cache search DBD::mysql
libdbd-mysql-perl - A Perl5 database interface to the MySQL database

rt38:/# apt-get install libdbd-mysql-perl
Reading package lists… Done
Building dependency tree… Done
libdbd-mysql-perl is already the newest version.

Hmmm… http://packages.debian.org tells us that 4.007-1 is available in Testing. Can we easily install the package from Testing on this Stable machine?

[don’t bother trying this route, it fails miserably…] rt38:/usr/src# wget http://http.us.debian.org/debian/pool/main/libd/libdbd-mysql-perl/libdbd-mysql-perl_4.007-1_amd64.deb

[clip]

… So, no. How about installing from sources, via CPAN?

rt38:/usr/src# wget http://search.cpan.org/CPAN/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.007.tar.gz

{clip}

12:12:57 (444.49 KB/s) - `DBD-mysql-4.007.tar.gz’ saved [123516/123516]

rt38:/usr/src# tar -xvzf DBD-mysql-4.007.tar.gz

rt38:/usr/src/DBD-mysql-4.007# perl Makefile.PL

Hmmmm… it needs access to the mysql_client binary to build, so:

rt38:/# apt-get install libmysqlclient15-dev

rt38:/usr/src/DBD-mysql-4.007# perl Makefile.PL
rt38:/usr/src/DBD-mysql-4.007# make
rt38:/usr/src/DBD-mysql-4.007# make install

And, try again:

rt38:/usr/src/rt-3.8.0rc3# perl etc/upgrade/schema.mysql-4.0-4.1.pl rt3 root ‘’ > sql.queries
rt3.Groups.Instance has type VARCHAR however mapping is missing.

Odd message, but everything seems to work now.-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of web master
Sent: Wednesday, July 16, 2008 3:00 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Upgrading to 3.8.0: schema.mysql, column_info selection problem

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.

{clip}

[X@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.

{clip}

Ruslan, thanks for sharing this.

James Moseley

         "Ruslan Zakirov"                                              
         <ruz@bestpractica                                             
         l.com>                                                     To 
         Sent by:                  jmoseley@corp.xanadoo.com           
         ruslan.zakirov@gm                                          cc 
         ail.com                   rt-users@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@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@c
        i.tracy.ca.us>                                             To
                                  "Ruslan Zakirov"
        07/16/2008 10:41          <ruz@bestpractical.com>,
        AM                        <jmoseley@corp.xanadoo.com>
                                                                   cc
                                  <rt-users@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@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Ruslan
Zakirov
Sent: Wednesday, July 16, 2008 6:57 AM
To: jmoseley@corp.xanadoo.com
Cc: rt-users@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 :slight_smile:

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@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@acelle
        ra.com>

To

        Sent by:                  rt-users@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@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@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@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@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@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.

Well I ran all the etc/upgrade/3.7.* upgrades and then created the
query script with schema.mysql-4.0-4.1.pl and I get this error,

ERROR 1067 (42000) at line 36: Invalid default value for ‘LookupType’

I looked at the sql,

ALTER TABLE CustomFields MODIFY LookupType VARBINARY(255) NOT NULL DEFAULT NULL;

…I guess it doesn’t like “NOT NULL” defaulting to …well NULL. :slight_smile:

There were 5 of these, so I removed the “DEFAULT NULL” and all was well.

grep “NOT NULL DEFAULT NULL” sql.queries

ALTER TABLE CustomFields MODIFY LookupType VARCHAR(255) CHARACTER SET ascii NOT NULL DEFAULT NULL;
ALTER TABLE ObjectCustomFieldValues MODIFY ObjectType VARBINARY(255) NOT NULL DEFAULT NULL;
ALTER TABLE ObjectCustomFieldValues MODIFY ObjectType VARCHAR(255) CHARACTER SET ascii NOT NULL DEFAULT NULL;
ALTER TABLE Transactions MODIFY ObjectType VARBINARY(64) NOT NULL DEFAULT NULL;
ALTER TABLE Transactions MODIFY ObjectType VARCHAR(64) CHARACTER SET ascii NOT NULL DEFAULT NULL;

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@corp.xanadoo.com escreveu:

Ruslan, thanks for sharing this.

James Moseley

         "Ruslan Zakirov"
         <ruz@bestpractica
         l.com>                                                     To
         Sent by:                  jmoseley@corp.xanadoo.com
         ruslan.zakirov@gm                                          cc
         ail.com                   rt-users@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@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@c
        i.tracy.ca.us>                                             To
                                  "Ruslan Zakirov"
        07/16/2008 10:41          <ruz@bestpractical.com>,
        AM                        <jmoseley@corp.xanadoo.com>
                                                                   cc
                                  <rt-users@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@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Ruslan
Zakirov
Sent: Wednesday, July 16, 2008 6:57 AM
To: jmoseley@corp.xanadoo.com
Cc: rt-users@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 :slight_smile:

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@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@acelle
        ra.com>

To

        Sent by:                  rt-users@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@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@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@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@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@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@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

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

[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Ruslan
ZakirovSent: Wednesday, July 16, 2008 11:10 AM
To: jmoseley@corp.xanadoo.com
Cc: rt-users@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?

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@c
        i.tracy.ca.us>

To

                                  "Ruslan Zakirov"
        07/16/2008 10:41          <ruz@bestpractical.com>,
        AM                        <jmoseley@corp.xanadoo.com>

cc

rt-users@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@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Ruslan
Zakirov
Sent: Wednesday, July 16, 2008 6:57 AM
To: jmoseley@corp.xanadoo.com
Cc: rt-users@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 :slight_smile:

However, we’ve done changes to mysql DB that require additional
upgrade steps for mysql, and this step fails.

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@acelle
        ra.com>

To

        Sent by:

rt-users@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@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@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@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@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@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@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

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

That did it … in a roundabout way. On the DB server it was installed,
but the latest CPAN offered would fail testing. I moved back to RT’s
machine (newer version of the system) and was able to install the latest
version of DBD::mysql and edited the script to point to our DB server
instead of localhost.

That was the recipe for success!

Thanks

–RyanFrom: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Friday, July 18, 2008 2:07 PM
To: Ryan Hardester
Cc: Ruslan Zakirov; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Upgrading to 3.8.0: schema.mysql, column_info
selection problem

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@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Ruslan
Zakirov
Sent: Wednesday, July 16, 2008 11:10 AM
To: jmoseley@corp.xanadoo.com
Cc: rt-users@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?

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@c
       i.tracy.ca.us>

To

                                 "Ruslan Zakirov"
       07/16/2008 10:41          <ruz@bestpractical.com>,
       AM                        <jmoseley@corp.xanadoo.com>

cc

rt-users@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@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Ruslan
Zakirov
Sent: Wednesday, July 16, 2008 6:57 AM
To: jmoseley@corp.xanadoo.com
Cc: rt-users@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 :slight_smile:

However, we’ve done changes to mysql DB that require additional
upgrade steps for mysql, and this step fails.

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@acelle
       ra.com>

To

       Sent by:

rt-users@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@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@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@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@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@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@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@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

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

I have some problems about this here:

  • I ran the 4.0-4.1 script on the DB, no errors
  • the rt UI display now weird caracters :frowning: direct select on mysql command
    line looks ok
  • I looked at the original dump of my DB (before script), everything
    seems in latin1
  • so I dumped with "–default-character-set=latin1 --skip-set-charset"
    and get a working dump in latin1
  • I converted it with iconv to utf8
  • then I did a new import in an utf8 db, with
    –default-character-set=utf8
  • still weird characters, direct select on mysql command
    line looks ok
  • I added in Handle.pm a “SET NAMES utf8”, now the rt UI is ok …

I’m a bit lost with MySQL encoding :frowning:

Any help there ?

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

I have some problems about this here:

  • I ran the 4.0-4.1 script on the DB, no errors

You ran the script, which generates the SQL commands, and you then ran
those SQL commands on the database, right? It’s a two-step process.

Tim

The Wellcome Trust Sanger Institute is operated by Genome Research
Limited, a charity registered in England with number 1021457 and a
company registered in England with number 2742969, whose registered
office is 215 Euston Road, London, NW1 2BE.

You ran the script, which generates the SQL commands, and you then ran
those SQL commands on the database, right? It’s a two-step process.

Of course :wink: