Greetings,
I am deploying a new sogo server on a Ubuntu 16.04.1 using Slavek's
repos. While reading the docs I found the item "5.9.1. MySQL complete
Unicode compliance". Why not? So, I changed mysql and sogo conf
accordingly and created the database with the command:
create database sogo character set='utf8mb4';
Then downloaded sogo sources, untared, found the mysql-utf8mb4.sql
script but when going to load it to create the tables I get the error:
mysql -p -v sogo < mysql-utf8mb4.sql
Enter password:
--
--
(... many empty lines after...)
--
CREATE TABLE sogo_acl (
c_folder_id int(11) NOT NULL,
c_objectvarchar(255) NOT NULL,
c_uid varchar(255) NOT NULL,
c_role varchar(80) NOT NULL,
KEY sogo_acl_c_folder_id_idx (c_folder_id),
KEY sogo_acl_c_uid_idx (c_uid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC
--
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near
'--
(... many empty lines after...)
' at line 1
root@sogov3:~#
Searching google found many posts with similar problems but no working
solution for this case. Can anybody please help me?
Thanks, best regards.
--
*Marcio Merlone*
--
users@sogo.nu
https://inverse.ca/sogo/lists