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

[d tbsky]

hi:
 why are you using rt 3.8.0? you can try rt 3.8.1rc2. it is utf8 ok.
if you use 3.8.0, you may need to tune mysql utf8 parameters.


2008/8/8 Jean-Michel Barbet <Jean-Michel.Barbet at subatech.in2p3.fr>:
> 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
> ------------------------------------------------------------------------
>