The mailing list for listmasters using Sympa

["True, James Scott" <address@concealed>]

David,

Have you had success with this? When you say move the list, you are including data in the database correct? Did you export the data from the database for just the one list and then import it into the new database?

Has anyone had any experience with migrating lists one by one to a new upgrade list environment? We are moving from Sympa 6.1.1 on RHEL6 to Sympa 6.2.52 on CentOS 7. We would like to migrate some individual list first as a pilot. Any thoughts? 

Thanks for any suggestions,

Jim True 
Campus Communications Infrastructure
Indiana University

address@concealed
812-855-7519 (Office)

On Oct 5, 2020, at 6:38 AM, David Verdin <address@concealed> wrote:

From a server to another server, the simplest is to close the list, move the list (and archive) irectory to the other server, then reopen the list.

It should be enough to retrieve all data.

Regards,

David

On 02/10/2020 18:16, Pinson, Brian wrote:

Is there a simple way to move lists from one sympa system to another?

-----Original Message-----
From: address@concealed <address@concealed> On Behalf Of Pinson, Brian
Sent: Thursday, October 1, 2020 9:53 AM
To: Stefan Hornburg (Racke) <address@concealed>; address@concealed
Subject: RE: [sympa-users] Sympa Install

Figured I'd ask 😃 I have sent it over to our AD team.

-----Original Message-----
From: Stefan Hornburg (Racke) <address@concealed>
Sent: Thursday, October 1, 2020 9:24 AM
To: Pinson, Brian <address@concealed>; address@concealed
Subject: Re: [sympa-users] Sympa Install

On 10/1/20 4:20 PM, Pinson, Brian wrote:

Thank you for sharing! Can you or someone explain the this part? Specifically the last part with all the numbers.

    get_dn_by_email_filter
(&(objectcategory=person)(mail=[sender])(!(userAccountControl:1.2.840.
113556.1.4.803:=2)))

Sorry I can't .. this filter was provided by the client so I simply pasted it into the auth.conf.

As I said, the actual configuration might differ between AD installations. Ask your AD admins for the correct string.

Regards
         Racke

-----Original Message-----
From: address@concealed
<address@concealed> On Behalf Of Stefan Hornburg
(Racke)
Sent: Thursday, October 1, 2020 9:15 AM
To: address@concealed
Subject: Re: [sympa-users] Sympa Install

On 10/1/20 4:02 PM, Pinson, Brian wrote:

I was able to get it figured out. There was a typo in my sympa.conf file… Thanks to everyone that helped!

 
Does anyone have any pointers on getting sympa to work against AD
with LDAP? The documentation I saw on sympa’s site didn’t go into
much detail. I found the auth.conf file but how does work? I made the changes and it still seems to be using the local authentication method.

 
https://urldefense.com/v3/__https://sympa-community.github.io/manual/
customize/ldap-auth.html__;!!H8mHWRdzp34!r5XltFUOlox0-bl-ucftpd4r2cE_
4Bz2jp83g7Kw4zL9_zWySHC15v1MEQajZoQ$

I suppose the actual configuration depends on your local setup.

Here is a real life example from one of my clients (redacted for privacy):

--- snip ---
ldap
    regexp .*
    host ldap.linuxia.de:636
    bind_dn address@concealed
    bind_password nevairbe
    timeout 20
    suffix dc=linuxia,dc=de
    get_dn_by_uid_filter (uid=[sender])
    get_dn_by_email_filter (&(objectcategory=person)(mail=[sender])(!(userAccountControl:1.2.840.113556.1.4.803:=2)))
    email_attribute mail
    scope sub
    use_ssl 1
    ca_file /etc/ssl/linuxia-chain.pem
    ca_verify required


user_table
  regexp .*
--- snap ---

The blank line between the two entries is mandatory.

Regards
         Racke

 
 
*From:* address@concealed
<address@concealed> *On Behalf Of *Colas Nahaboo
*Sent:* Thursday, October 1, 2020 2:38 AM
*To:* Stefan Hornburg (Racke) <address@concealed>
*Cc:* address@concealed
*Subject:* Re: [sympa-users] Sympa Install

 
ATTENTION: This email originated from a sender outside of MCW. Use caution when clicking on links or opening attachments.

---------------------------------------------------------------------
-
--------------------------------------------------

Well, I guess the RPM package can work. It is just that before using
the Debian package of Sympa (that I used apache, mysql, postfix), I
have been installing from source, and looking at the amount of manual
work left once the RPM package was installed, I thought that it did not save much compared to installing by hand, so why bother (and adding one more dependency, aka potential for failure)?

 
Out of curiosity, I will try to use the Debian package on Ubuntu however,  before resorting to installing by hand.

 
 
On Thu, 1 Oct 2020 at 08:39, Stefan Hornburg (Racke) <address@concealed <mailto:address@concealed>> wrote:

    On 9/30/20 11:57 PM, Colas Nahaboo wrote:
    > Just a warning on the linux distribution packages I tried 2 months ago:
    >
    >   * Ubuntu doesn't work (archiving doesn't work) and has not been maintained for 2 years.
    >   * Debian works nicely, and updates sympa versions.
    >   * RHEL is not  useful. It just copies files, but do not attempt to really install things (no database setup, no
    >     integration with the mail system, ...) and I don't think it will be of any use for upgrading.
    >

    Thanks for your valuable input. I can improve the Debian packages, but the other ones are out
    of my scope.

    I have a client with Sympa installed on CentOS 7 from RPM. Last upgrade was fine there.

    Regards
             Racke

    >
    >
    > On Wed, 30 Sep 2020 at 23:02, Pinson, Brian <address@concealed <mailto:address@concealed> <mailto:address@concealed
    <mailto:address@concealed>>> wrote:
    >
    >     Thank you! That helped. Final stretch here... so I go to the webpage and I'm getting:
    >
    >     Forbidden
    >
    >     You don't have permission to access /sympa on this server.
    >
    >
    >     Anything come to mind with this?
    >
    >     -----Original Message-----
    >     From: address@concealed <mailto:address@concealed>
    <mailto:address@concealed <mailto:address@concealed>>
    >     <address@concealed <mailto:address@concealed>
    <mailto:address@concealed <mailto:address@concealed>>> On Behalf Of Stefan
    Hornburg
    >     (Racke)
    >     Sent: Wednesday, September 30, 2020 2:12 PM
    >     To: address@concealed <mailto:address@concealed> <mailto:address@concealed
    <mailto:address@concealed>>
    >     Subject: Re: [sympa-users] Sympa Install
    >
    >     On 9/30/20 9:08 PM, Pinson, Brian wrote:
    >     > I'm getting stuck with configuring the sendmail part.
    >     > (https://urldefense.com/v3/__https://sympa-community.github.io/manual/install/configure-mail-serve__;!!H8mHWRdzp34!r5XltFUOlox0-bl-ucftpd4r2cE_4Bz2jp83g7Kw4zL9_zWySHC15v1MlBjKTtM$
    <https://urldefense.com/v3/__https:/sympa-community.github.io/manual/install/configure-mail-serve__;!!H8mHWRdzp34!s0RhBNoCKz8XH3jbRbv0tJ0QY8cvIgMuqNkNZKQ9M12pXKIegLsrpCQUYz8vvO8$>
    >     > r-sendmail.html)
    >     >
    >     > Particularly the alias part. What is the "$SENDMAIL_ALIAS" thing it's talking about?
    >
    >     These variables are explained here: https://urldefense.com/v3/__https://sympa-community.github.io/manual/layout.html__;!!H8mHWRdzp34!r5XltFUOlox0-bl-ucftpd4r2cE_4Bz2jp83g7Kw4zL9_zWySHC15v1M5cM1KAw$
    <https://urldefense.com/v3/__https:/sympa-community.github.io/manual/layout.html__;!!H8mHWRdzp34!s0RhBNoCKz8XH3jbRbv0tJ0QY8cvIgMuqNkNZKQ9M12pXKIegLsrpCQUEeWgc8E$>.
    >
    >     Regards
    >             Racke
    >
    >     >
    >     > -----Original Message-----
    >     > From: address@concealed <mailto:address@concealed>
    <mailto:address@concealed <mailto:address@concealed>>
    >     > <address@concealed <mailto:address@concealed>
    <mailto:address@concealed <mailto:address@concealed>>> On Behalf Of Stefan
    Hornburg
    >     > (Racke)
    >     > Sent: Wednesday, September 30, 2020 10:52 AM
    >     > To: address@concealed <mailto:address@concealed>
    <mailto:address@concealed <mailto:address@concealed>>
    >     > Subject: Re: [sympa-users] Sympa Install
    >     >
    >     > On 9/30/20 5:48 PM, Pinson, Brian wrote:
    >     >> Wish me luck! Going to try the RPM.
    >     >>
    >     >
    >     > Let us know how it goes ... maybe you can suggest improvements to the documentation if you find it unclear or
    >     missing useful information.
    >     >
    >     > Good luck
    >     >
    >     >     Racke
    >     >
    >     >> -----Original Message-----
    >     >> From: address@concealed <mailto:address@concealed>
    <mailto:address@concealed <mailto:address@concealed>>
    >     >> <address@concealed <mailto:address@concealed>
    <mailto:address@concealed <mailto:address@concealed>>> On Behalf Of David Verdin
    >     >> Sent: Wednesday, September 30, 2020 10:25 AM
    >     >> To: address@concealed <mailto:address@concealed>
    <mailto:address@concealed <mailto:address@concealed>>
    >     >> Subject: Re: [sympa-users] Sympa Install
    >     >>
    >     >> Another point of attention: The distribution has no impact on Sympa
    >     >> administration. Around 45 % of installs are under Redhat (or Fedora,
    >     >> centos, etc.), 45 % under Debian (or Ubuntu and the like) and most of
    >     >> the 10% remaining are FreeBSD.
    >     >>
    >     >> The only impact of distribution is which Sympa version is packaged.
    >     >>
    >     >> About it, Soji maintains the RPM, so RedHat can always have the
    >     >> latest version packaged, but you need to set up the dedicated
    >     >> repository. I don't know how it works for Debian if you want the
    >     >> latest version packaged. It seems that current version in Debian is
    >     >> something like
    >     >> 6.2.40 which is good enough.
    >     >>
    >     >> Personally, I always install from sources, so I don't care and use
    >     >> Ubuntu servers.
    >     >>
    >     >> Cheers!
    >     >>
    >     >> David
    >     >>
    >     >> On 30/09/2020 17:14, Pinson, Brian wrote:
    >     >>> We are generally a RHEL or OEL shop. But, from what I've discovered is Debian seems to be the go-to option. Is
    >     the Sympa documentation accurate for the Debian install? I haven't found that their documentation is the best.
    >     >>>
    >     >>> Thank you so much for you input. We are trying to move away from
    >     >>> Mailman and Sympa seems promising if I could just get it installed!
    >     >>> 😃
    >     >
    >     >>>>>
    >     >>> -----Original Message-----
    >     >>> From: address@concealed <mailto:address@concealed>
    <mailto:address@concealed <mailto:address@concealed>>
    >     >>> <address@concealed <mailto:address@concealed>
    <mailto:address@concealed <mailto:address@concealed>>> On Behalf Of Stefan
    Hornburg
    >     >>> (Racke)
    >     >>> Sent: Wednesday, September 30, 2020 10:12 AM
    >     >>> To: address@concealed <mailto:address@concealed>
    <mailto:address@concealed <mailto:address@concealed>>
    >     >>> Subject: Re: [sympa-users] Sympa Install
    >     >>>
    >     >>> On 9/30/20 4:54 PM, Pinson, Brian wrote:
    >     >>>> I'm starting from scratch. I'm basically just wanting to feel out what the community recommends. We have one
    >     system running Ubuntu but it just doesn't seem to be working right. We have to reset our passwords almost everyday
    >     right now. I would just rather rebuild as I think something was installed incorrectly the first time.
    >     >>>>
    >     >>> The community has several opinions and different infrastructure concerns, so there is no general
    recommendation.
    >     >>>
    >     >>> Here is the list of what I prefer:
    >     >>>
    >     >>> Distribution: Debian
    >     >>> Web server: Nginx (faster and more consistent than Apache)
    >     >>> Database: PostgreSQL (more mature and less surprises than MySQL /
    >     >>> MariaDB) Mail server: Exim (but Postfix is fine too)
    >     >>>
    >     >>> Regards
    >     >>>           Racke
    >     >>>
    >     >>>
    >     >>>> -----Original Message-----
    >     >>>> From: address@concealed <mailto:address@concealed>
    <mailto:address@concealed <mailto:address@concealed>>
    >     >>>> <address@concealed <mailto:address@concealed>
    <mailto:address@concealed <mailto:address@concealed>>> On Behalf Of Stefan
    >     >>>> Hornburg
    >     >>>> (Racke)
    >     >>>> Sent: Wednesday, September 30, 2020 9:52 AM
    >     >>>> To: address@concealed <mailto:address@concealed>
    <mailto:address@concealed <mailto:address@concealed>>
    >     >>>> Subject: Re: [sympa-users] Sympa Install
    >     >>>>
    >     >>>> On 9/30/20 4:42 PM, Pinson, Brian wrote:
    >     >>>>> Good Morning all,
    >     >>>>>
    >     >>>>> Is there anyone out there that has a good step-by-step
    >     >>>>> installation for Sympa? All the ones that I have tried are either incomplete or just don't work.
    >     >>>>>
    >     >>>>>
    >     >>>>>
    >     >>>>> Any guidance is greatly appreciated!
    >     >>>> Hello Brian,
    >     >>>>
    >     >>>> it depends on a couple of things:
    >     >>>>
    >     >>>> How do you install it? From sources?
    >     >>>> Which distribution is installed on your server?
    >     >>>>
    >     >>>> Database?
    >     >>>> MTA?
    >     >>>> Web server?
    >     >>>>
    >     >>>> Regards
    >     >>>>         Racke
    >     >>>>
    >     >>>>
    >     >>>> --
    >     >>>> Ecommerce and Linux consulting + Perl and web application programming.
    >     >>>> Debian and Sympa administration. Provisioning with Ansible.
    >     >>>>
    >     >>>>
    >     >>>
    >     >>> --
    >     >>> Ecommerce and Linux consulting + Perl and web application programming.
    >     >>> Debian and Sympa administration. Provisioning with Ansible.
    >     >>>
    >     >
    >     >
    >     > --
    >     > Ecommerce and Linux consulting + Perl and web application programming.
    >     > Debian and Sympa administration. Provisioning with Ansible.
    >     >
    >
    >
    >     --
    >     Ecommerce and Linux consulting + Perl and web application programming.
    >     Debian and Sympa administration. Provisioning with Ansible.
    >
    >
    >
    > --
    > Colas Nahaboo - https://urldefense.com/v3/__https://colas.nahaboo.net__;!!H8mHWRdzp34!r5XltFUOlox0-bl-ucftpd4r2cE_4Bz2jp83g7Kw4zL9_zWySHC15v1MVKZ9gsg$
    <https://urldefense.com/v3/__https:/colas.nahaboo.net__;!!H8mHWRdzp34!s0RhBNoCKz8XH3jbRbv0tJ0QY8cvIgMuqNkNZKQ9M12pXKIegLsrpCQUinnjIWM$>
    <https://urldefense.com/v3/__http://colas.nahaboo.net__;!!H8mHWRdzp34
!r5XltFUOlox0-bl-ucftpd4r2cE_4Bz2jp83g7Kw4zL9_zWySHC15v1MV7FAwPo$
    <https://urldefense.com/v3/__http:/colas.nahaboo.net__;!!H8mHWRdzp34!
s 0RhBNoCKz8XH3jbRbv0tJ0QY8cvIgMuqNkNZKQ9M12pXKIegLsrpCQUj-puZPU$>>


    --
    Ecommerce and Linux consulting + Perl and web application programming.
    Debian and Sympa administration. Provisioning with Ansible.



--

Colas Nahaboo -
https://urldefense.com/v3/__https://colas.nahaboo.net__;!!H8mHWRdzp34
!r5XltFUOlox0-bl-ucftpd4r2cE_4Bz2jp83g7Kw4zL9_zWySHC15v1MVKZ9gsg$
<https://urldefense.com/v3/__http:/colas.nahaboo.net__;!!H8mHWRdzp34!
s 0RhBNoCKz8XH3jbRbv0tJ0QY8cvIgMuqNkNZKQ9M12pXKIegLsrpCQUj-puZPU$>

--
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration. Provisioning with Ansible.

--
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration. Provisioning with Ansible.

-- 
"Mieux vaut viser la perfection et la rater que viser la médiocrité et l'atteindre."
- Francis Blanche

David Verdin
Chef de Projet Collaboratif
Département PROduits NUMériques
Direction des Services Applicatifs
RENATER - Rennes