Jump to content


Photo

MySQL problem with installation

mysql centos linux install zurmo

  • Please log in to reply
1 reply to this topic

#1 blank_jack

blank_jack

    Newbie

  • New Members
  • Pip
  • 2 posts

Posted 09 August 2013 - 06:15 PM

Hello,


I was installing Zurmo today for a client on a CentOS server:

 

 

Linux version 2.6.32-358.6.2.el6.i686 (mockbuild@c6b8.bsys.dev.centos.org) (gcc version 4.4.7 20120313 (Red Hat 4.4.7-3) (GCC) ) #1 SMP Thu May 16 18:12:13 UTC 2013

 

PHP version: 
 

 

PHP 5.3.3 (cli) (built: Jul 12 2013 20:21:47)
Copyright © 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright © 1998-2010 Zend Technologies
    with Suhosin v0.9.29, Copyright © 2007, by SektionEins GmbH

 

MySQL: 
 

 

mysql  Ver 14.14 Distrib 5.1.69, for redhat-linux-gnu (i386) using readline 5.1

 

I get an error: 

 

 

Database default collation is: utf8_general_ci . Database default collation should not be in: utf8_general_ci

 

The above check however is incorrect as I have my MySQL configuration file like this: 

 

 

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake

 

And the collation is correct: 

 

 

mysql> show variables like 'char%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
 
mysql> show variables like 'collation%';
+----------------------+-----------------+
| Variable_name        | Value           |
+----------------------+-----------------+
| collation_connection | utf8_unicode_ci |
| collation_database   | utf8_unicode_ci |
| collation_server     | utf8_unicode_ci |
+----------------------+-----------------+
3 rows in set (0.00 sec)

 

 

Any help would be greatly appreciated, 

 

Thanks!



#2 Stafford

Stafford

    Zurmo Member

  • Moderators
  • 212 posts

Posted 13 August 2013 - 01:57 PM

Can you join the Dev Session today so we can go over your issue? We have Developer Sessions every Tuesday at 10:00AM Chicago Time (http://zurmo.org/for...arning-session/).







Also tagged with one or more of these keywords: mysql, centos, linux, install zurmo

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users