The mailing list for listmasters using Sympa

[Brian Eliassen <address@concealed>]

Greetings everyone,

I'm in the process of installing a new Sympa server and elected to use  
the 6.2b.2 beta version.  During the installation process, I've  
discovered a few items that probably should be addressed.

Environment: Solaris 10, gcc 3.4.6, GNU make 3.82, perl v5.14.2, MySQL  
5.6.22, everything built from source

./configure --prefix=/usr/local/sympa
make
make install

The "make install" fails as file src/libexec/Makefile on line 677  
contains:

        install -d -m755 $(DESTDIR)$(smrshdir)

In order to get this to install, the Makefile needed the space between  
"-m" and "755":

        install -d -m 755 $(DESTDIR)$(smrshdir)

After the extensive "sympa_wizard.pl --check" process where several  
modules needed to be manually created as the automated process enters  
several error loops, it was time to create the database.

/usr/local/mysql/bin> mysql -u root -p < ~sympa/bin/create_db.mysql
Enter password:
ERROR 1064 (42000) at line 38: 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 ') DEFAULT CHARACTER SET utf8' at line 18

The file create_db.mysql appears to have a line missing and the  
reported error with create_db.mysql looks like this:

CREATE TABLE admin_table (
         comment_admin   varchar(150),
         date_admin      datetime,
         include_sources_admin   varchar(50),
         included_admin          int(1),
         info_admin      varchar(150),
         list_admin      varchar(50),
         profile_admin   enum('privileged','normal'),
         reception_admin         varchar(20),
         robot_admin     varchar(80),
         role_admin      enum('listmaster','owner','editor'),
         subscribed_admin        int(1),
         update_admin    datetime,
         user_admin      varchar(100),
         visibility_admin        varchar(20),
,
         INDEX admin_user_index ( user_admin )
 ) DEFAULT CHARACTER SET utf8;

Figuring MySQL didn't like the extra comma, I removed it but the error  
remains.  It appears to dislike the DEFAULT CHARACTER SET command for  
some reason.  I tried the example create_db.mysql from the website  
which showed the missing line was "PRIMARY KEY (robot_admin,  
list_admin, role_admin, user_admin)," but the same error occurs.  Any  
idea what is happening?  I'll admit my MySQL skills are limited and I  
hope I'm not just missing something simple.  Any help would be greatly  
appreciated as I'm finally at the "create database and then make  
mailing lists" stage.  Time for me to finally retire Majordomo.

Thank you.

Brian