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 <[EMAIL PROTECTED]>: > 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: [EMAIL PROTECTED] > ------------------------------------------------------------------------ > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
