Skip to Content.
Sympa Menu

en - Re: [sympa-users] Sympa 6.2b.2 Errors

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: David Verdin <address@concealed>
  • To: address@concealed
  • Subject: Re: [sympa-users] Sympa 6.2b.2 Errors
  • Date: Tue, 27 Jan 2015 17:54:02 +0100

Hi Brian, and sorry for this late answer.

Soji took care of your issues:

  • make install fail: Soji fixed the problem in code.
  • db creation: you don't actually need the db creation script with MySQL, as sympa.pl --health_check does it for you. Soji removed the forme creation scripts. I'll update the documentation accordingly,
  • I don't know why you had troubles with the CPAN install. What were the module causing the troubles?
  • Finally, I'm glad you switch from majordomo! We have a set of migration scripts that were contributed by Mathias Warkus, to move from Sympa to Majordomo. You can find them here: https://www.sympa.org/contribs/migration_and_archives/index#majordomo2sympa6

I'll tag a new Sympa 6.2 beta tomorrow. You can then try to use it to finish your install.

Best regards,

David

Le 25/01/15 08:57, Brian Eliassen a écrit :
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

--
A bug in Sympa? Quick! To the bug tracker!

 
David Verdin
Études et projets applicatifs
 
Tél : +33 2 23 23 69 71
Fax : +33 2 23 23 71 21
 
www.renater.fr
RENATER
263 Avenue du Gal Leclerc
35042 Rennes Cedex



PNG image

Attachment: smime.p7s
Description: Signature cryptographique S/MIME




Archive powered by MHonArc 2.6.19+.

Top of Page