[cvs] [Wiki] changed: CentOS5InstallationNotes

[Wiki Guest]

guest [189.33.98.244]  Sun, 07 Feb 2010 22:15:47 -0500

Modified page: http://wiki.horde.org/CentOS5InstallationNotes
New Revision:  1.37
Change log:  Added some more tips and MySQL UTF-8 configuration

@@ -13,8 +13,9 @@
  * !MySQL 5.0.22 (db server)
  * Postfix 2.3.3 (mail server)
  * Dovecot 1.0 (IMAP server)

+(Although this how to has been made with the above versions, it may  
work just the same for newer versions of Horde)

  ++ Set up your host name and address

  //This is only necessary if you didn't do it at installation.//
@@ -72,14 +73,16 @@
                 php-pear-DB php-pear-File php-pear-Log  
php-pear-Mail-Mime php-pear-Auth-SASL php-pear-Date
                 php-pear-HTTP-Request php-pear-Mail  
php-pear-Net-Sieve php-pear-Net-Socket php-pear-Net-SMTP
                 php-pear-MDB2-Driver-mysql php-gd php-xmlrpc php-soap

-yum install -y php-pear-Date-Holidays            <-- (for now, this  
package is available in the EPEL repo)
+yum install -y php-pear-Date-Holidays            <-- (for now, this  
package is available in the EPEL[1] repo)

  yum install -y openssl mod_ssl crypto-utils perl-Net-SSLeay          
<--(for https secure browsing)

  yum install -y php-devel gcc      <--(if you want to install extra  
pecl modules - PS: use 'pear install pecl/modulename')
  </code>
+
+[1] About EPEL repo: http://fedoraproject.org/wiki/EPEL


  ++ Configuring Postfix and Dovecot

@@ -153,8 +156,28 @@
  </code>


  ++ Creating database and tables in !MySQL
+
++++ For those who want everything in UTF-8
+
+MySQL default charset is "latin1" (or ISO-8859-1).
+
+It happens that keeping evertyhing in UTF-8 is a good practice and  
prevent a lot of trouble in the future, as mentioned  
[http://www.oreillynet.com/onlamp/blog/2006/01/turning_mysql_data_in_latin1_t.html  
here].
+
+If you whish to do so, before you even create your db tables for  
horde, turn your MySQL installation to UTF-8, inserting these lines  
into your **/etc/my.cnf** file:
+
+<code>
+[mysqld]
+collation_server=utf8_general_ci
+character_set_server=utf8
+init_connect="SET NAMES 'utf8'"
+
+[client]
+default_character_set=utf8
+</code>
+
+If you do not want your DB to be UTF-8, just leave the my.cnf as it is.

  +++ Run the setup.php script:

  <code>
@@ -163,9 +186,9 @@
  </code>

  If asked, choose /horde.

-Press 1; choose mysql; Persistent connection: 0; Username horde;  
Choose a password for mysql-user-horde; Unix sockets; Location  
/var/lib/mysql/mysql.sock; DB name horde;
+Press 1; choose mysql; Persistent connection: 0; Username horde;  
Choose a password for mysql-user-horde; Unix sockets; Location  
/var/lib/mysql/mysql.sock; DB name horde; internally used charset ut-8  
or iso-8859-1 (depends on how you have configured your mysql encoding  
- see above)

  Press 2; yes; root; root-mysql-password.

  Press 3; specify an existing IMAP user to have horde administration  
permissions (i.e. your current linux user).
@@ -336,9 +359,9 @@
  (PS2: Remember to check $conf['cookie']['path'] = '/horde'; in  
horde/config/conf.php to match the path you use to access horde on  
your server)

  Fell free to change other options, as you like. The good thing about  
Horde Groupware Webmail Edition is it comes pretty much configured and  
ready for use!

-Remember to restart httpd after you make changes:
+Remember to restart **httpd** after you make changes:

  <code>
  service httpd restart
  </code>