utf-8 in ispconfig database

[guardian]

Why not use utf-8 encoding for ispconfig database?

Now when I create a Client with Cyrillic name there's a problem displaying it

http://don.adminbg.info/ispc/ispc1.jpg
http://don.adminbg.info/ispc/ispc2.jpg

[till]

Please try to change the encoding of the database and all tables to utf-8, does it work then?

[guardian]

I have change db encoding and encoding for table client and the problem still exist.

I forgot to mention that when you try to edit client all is displayed correctly.
http://don.adminbg.info/ispc/ispc3.jpg

[till]

What is the problem if everything is displayed correctly when you edit the client?

[guardian]

The problem is that listing of clients isn't displayed correctly. So you actually don't now who is who until you open a client for editing.
http://don.adminbg.info/ispc/ispc1.jpg

[till]

Ok, that has nothing to do with the charset of the mysql database then. Most likely there is a conversion issue in the php class that creates the lists.

[vogelor]

i think, changing the encoding of the db is not enought!
you also have to change the encoding of the data itself!

i think "set "fieldname" = utf8(fieldname)" or somthing like this. read the mysql manual and try this - maybe this helps

Olli

[radim_h]

I have same problem

MySQl is set to utf-8, in /etc/mysql/my.cnf
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
default-character-set = utf8

[mysqld]
.
.
default-character-set = utf8
character-set-server = utf8
collation-server = utf8_czech_ci
default-collation = utf8_czech_ci


When editing client, everything is shown correctly
http://www.tvujweb.cz/trash/ispc3-1.jpg

On client overview page it is not:
http://www.tvujweb.cz/trash/ispc3-2.jpg

And in phpmyadmin, there is also chaos
http://www.tvujweb.cz/trash/ispc3-3.jpg

BTW: behaviour in ISPC2 is same i can see correct characters in administration, but not in Mysql database

[guardian]

Revision 624 fixed the problem. Thanks.

[radim_h]

Please, how should i update SVN installation of ISPC3 to last revision ?

[guardian]

cd /tmp
svn export svn://svn.ispconfig.org/ispconfig3/trunk/
cd trunk/install
php -q update.php

[till]

Or run the following comamnd on the shell:

ispconfig_update_from_svn.sh

[radim_h]

will it overwrite my own language files as i'm allmost finished with translating ISPC3 to Czech. ?

If so, what is the best way to backup language before update ?

Actually how should i backup ispconfig before update in case something goes wrong? Is it enough to backup directory /usr/local/ispconfig and database ??

[till]

The Update overwrites all files. But you can use the import and export functions of the ispconfig language file editor to make a backup of your language file and restore it afterwards.

[radim_h]

I'd like just to check for info:

was there any change in language files in ISPConfig 3.0.0.8.630 from last version?

I'd like to know if file /usr/local/ispconfig/interface/web/monitor/lib/lang/en.lng in ISPConfig 3.0.0.8.630 contains string "$wb['Show RKHunter-Log']"

as after update this item is missing in language file. Just want to be sure that language files are overwrited during update and merge will be working
(i suppose this string just wasnt added,
rkhuter is example that was first new item i have noticed after update)

========

UTF8 problemis fixed.

[vogelor]

I'd like just to check for info:

was there any change in language files in ISPConfig 3.0.0.8.630 from last version?

I'd like to know if file /usr/local/ispconfig/interface/web/monitor/lib/lang/en.lng in ISPConfig 3.0.0.8.630 contains string "$wb['Show RKHunter-Log']"

as after update this item is missing in language file. Just want to be sure that language files are overwrited during update and merge will be working
(i suppose this string just wasnt added,
rkhuter is example that was first new item i have noticed after update)

========

UTF8 problemis fixed.

that's right.
i am actually doint heavy develpoment on the monitor - module. i liked to implement the rkhunter some days ago but haven't much time.

so rkhunter is "removed". last weekend i had the time, so rkhunter is added again ;-)

[radim_h]

so the answer is - i have not to worry, it wasnt included in the lang file? .o)

[vogelor]

so the answer is - i have not to worry, it wasnt included in the lang file? .o)
YEP! you are right