The mailing list for listmasters using Sympa

["Lorenz, Sabine (SCC)" <address@concealed>]

Hi all,

 

we have a sympa installation (sympa 6.1.23 as debian package) with two  virtual robots.

Until now the local sympa user accounts had only one password that fits for both robots.

That was not a problem for us but even an advantage that the users were not confused by two different passwords for two sympa robots.

But now we want to add another external mailinglist-domain as a third virtual robot and it is necessary that all sympa accounts have a different passwort for every  robot.

 

How can we do that?

To be sure that it is not a fault on our productive server I installed another sympa server as a testserver with two virtual robots and an new database but also on this server the sympa accounts have only one password that fits for both robots.

 

When I watch the structure of the table user_table in sympa database at  https://www.sympa.org/manual/database#database_structure I see that there is only one field „password_user“:

 

create table user_table

(

                 attributes_user              varchar(500),

                 cookie_delay_user       numeric,

                 data_user          varchar(500),

                 email_user        varchar(100) NOT NULL,

                 gecos_user       varchar(150),

                 lang_user          varchar(10),

                 last_login_date_user   numeric,

                 last_login_host_user   varchar(60),

                 password_user               varchar(40),

                 wrong_login_count_user          numeric,

                 last_active_date_user numeric,

                constraint ind_user PRIMARY KEY (email_user)

)

 

Normally I would expect another field like „robot_user“ to distinguish the passwords of a user with the same value for „email_user“ for two different virtual robots.

 

I am pretty sure that it must be possible that the sympa users have a different password for every virtual robot but I do not know how to implement that.

 

Does anyone have an idea?

Thanks in advance for any hints.

Best regards,

Sabine Lorenz

 

----------

Sabine Lorenz
Karlsruher Institut für Technologie (KIT)
Steinbuch Centre for Computing

Hermann von Helmholtz Platz 1
76344 Eggenstein-Leopoldshafen
Telefon: +49 721 608-28633

E-Mail: address@concealed
www.kit.edu/scc

KIT - Universität des Landes Baden-Württemberg und
nationales Großforschungszentrum in der Helmholtz-Gemeinschaft

Das KIT ist seit 2010 als familiengerechte Hochschule zertifiziert.

 

Attachment: smime.p7s
Description: S/MIME cryptographic signature