[rt-users] Rt at Glance and upgrade from 3.2.1 to 3.8.0

[Jean-Michel Barbet]

d tbsky wrote:
> hi:
> maybe your version of DBD::mysql is too old?
> you can try rt3.8.1rc2, the "make testdeps" will check DBD::mysql version.
> i got errors before upgrade my DBD::mysql, but i forgot the error message.

Thanks,

The problem of having an empty "RT at Glance" page is now fixed.
But I have problems with accents not displayed correctly (see
at the end).

Here is the log of my actions :

a) Starting MySQL for the first time and putting a root password :

service mysqld start
Initializing MySQL database:  Installing MySQL system tables...
OK
/usr/bin/mysqladmin -u root password 'xxxxxxxx'

b) Install the RT 3.8.0 initial database

(I believe this has to be done to create users and rights for the rt3
  database in mysql )

make initialize-database
/usr/bin/perl sbin/rt-setup-database --action init --dba root
--prompt-for-dba-password

c) Install a newer DBD::mysql module than the one from distro
    (the installed version was perl-DBD-MySQL-3.0007-1.fc6).
    This is to make the script etc/upgrade/schema.mysql-4.0-4.1.pl
    work.

perl -MCPAN -e shell
install DBD:mysql

d) dump the data from RT 3.2.1 and load them in the new RT 3.8.0

oldserver>
mysqldump -u rt_user --password=xxxxxxx --single-transaction \
--databases rt3 > rt3-migrate.sql

newserver>
mysql -u root -p --default-character-set=binary < ~/rt3-migrate.sql
Enter password:

e) run mysql upgrade script. I had to modify the script because
    some tables do not exist in the DB from 3.2.1 :

diff etc/upgrade/schema.mysql-4.0-4.1-new.pl \
      etc/upgrade/schema.mysql-4.0-4.1.pl
47a48,49
 >     ObjectCustomFields
 >     ObjectCustomFieldValues

cd rt-3.8.0
perl etc/upgrade/schema.mysql-4.0-4.1-new.pl rt3 \
rt_user xxxxxx  > etc/upgrade/upgrade-mysql-4-5.sql
mysql -u root -p rt3 < etc/upgrade/upgrade-mysql-4-5.sql

f) upgrade schemas etc from 3.2.1 to 3.8.0 :

/opt/rt3/sbin/rt-setup-database --dba root \
--prompt-for-dba-password --action upgrade

=> Now I have another problem :
###############################

In the ticket lists diplayed on the "RT at Glance" page, the
french accentued characters are replaced by a comma. I could send
a new request on the list for that but I suppose it is linked
to this issue of character sets !

Moreover, in some elements, french accents are correctly
displayed and in some not :

Not Correct :
- Titles of migrated tickets
- Names of people acting on the tickets
- Name of attachments if they have accents for newly created tickets
- Body (template) of email message to the sender in reponse for a new
   ticket
Correct :
- Body of migrated tickets
- Titles of newly created tickets

If someone can help ...

JM



Jean-Michel.





-- 
------------------------------------------------------------------------
Jean-michel BARBET                    | Tel: +33 (0)2 51 85 84 86
Laboratoire SUBATECH Nantes France    | Fax: +33 (0)2 51 85 84 79
CNRS-IN2P3/Ecole des Mines/Universite | E-Mail: barbet at subatech.in2p3.fr
------------------------------------------------------------------------