The mailing list for listmasters using Sympa

[Steve Shipway <address@concealed>]

If I understand the format of the auth.conf file correctly, then your errors are because you have the blank line inserted, no section header and no leading spaces on the parameters.

 

Do it like this:

 

ldap

        host                            0249.xy.xy.com:636

        timeout                         20

        suffix                          dc=xyxyxy

        get_dn_by_uid_filter            (uid=[sender])

        get_dn_by_email_filter          (mail=[sender])

        email_attribute                 mail

        scope                           sub

 

Note – the initial section header ‘ldap’ is not commented out.  There are no blank lines in the section, only before and after.

 

Steve

 

---

Steve Shipway

ITS Unix Services Design Lead

University of Auckland, New Zealand

Floor 1, 58 Symonds Street, Auckland

Phone: +64 (0)9 3737599 ext 86487

DDI: +64 (0)9 924 6487

Mobile: +64 (0)21 753 189

Email: address@concealed

P Please consider the environment before printing this e-mail : 打印本邮件，将减少一棵树存活的机会

 

From: address@concealed [mailto:address@concealed] On Behalf Of KC Wise
Sent: Friday, 30 November 2012 8:23 a.m.
To: address@concealed
Subject: [sympa-users] LDAP config Issues

 

I'm still trying to get LDAP to work with the sympa login.

 

I'm seeing this error in the sympa logs:

Nov 28 12:59:01 novprvlin0194 sympa[2601]: info Configuration file read, default log level 0

Nov 28 12:59:02 novprvlin0194 sympa[2601]: err Conf::_load_auth() _load_auth: unknown keyword 'host' in /home/sympa/default/auth.conf line 31

Nov 28 12:59:02 novprvlin0194 sympa[2601]: err Conf::_load_auth() _load_auth: unknown keyword 'timeout' in /home/sympa/default/auth.conf line 32

Nov 28 12:59:02 novprvlin0194 sympa[2601]: err Conf::_load_auth() _load_auth: unknown keyword 'suffix' in /home/sympa/default/auth.conf line 33

Nov 28 12:59:02 novprvlin0194 sympa[2601]: err Conf::_load_auth() _load_auth: unknown keyword 'get_dn_by_uid_filter' in /home/sympa/default/auth.conf line 34

Nov 28 12:59:02 novprvlin0194 sympa[2601]: err Conf::_load_auth() _load_auth: unknown keyword 'get_dn_by_email_filter' in /home/sympa/default/auth.conf line 35

Nov 28 12:59:02 novprvlin0194 sympa[2601]: err Conf::_load_auth() _load_auth: unknown keyword 'email_attribute' in /home/sympa/default/auth.conf line 36

Nov 28 12:59:02 novprvlin0194 sympa[2601]: err Conf::_load_auth() _load_auth: unknown keyword 'scope' in /home/sympa/default/auth.conf line 37

Nov 28 12:59:02 novprvlin0194 sympa[2601]: err Conf::_load_auth() _load_auth: unknown keyword 'host' in /home/sympa/default/auth.conf line 31

Nov 28 12:59:02 novprvlin0194 sympa[2601]: err Conf::_load_auth() _load_auth: unknown keyword 'timeout' in /home/sympa/default/auth.conf line 32

Nov 28 12:59:02 novprvlin0194 sympa[2601]: err Conf::_load_auth() _load_auth: unknown keyword 'suffix' in /home/sympa/default/auth.conf line 33

Nov 28 12:59:02 novprvlin0194 sympa[2601]: err Conf::_load_auth() _load_auth: unknown keyword 'get_dn_by_uid_filter' in /home/sympa/default/auth.conf line 34

Nov 28 12:59:02 novprvlin0194 sympa[2601]: err Conf::_load_auth() _load_auth: unknown keyword 'get_dn_by_email_filter' in /home/sympa/default/auth.conf line 35

Nov 28 12:59:02 novprvlin0194 sympa[2601]: err Conf::_load_auth() _load_auth: unknown keyword 'email_attribute' in /home/sympa/default/auth.conf line 36

Nov 28 12:59:02 novprvlin0194 sympa[2601]: err Conf::_load_auth() _load_auth: unknown keyword 'scope' in /home/sympa/default/auth.conf line 37

Nov 28 12:59:02 novprvlin0194 sympa[2601]: err Conf::_load_auth() _load_auth: unknown keyword 'host' in /home/sympa/default/auth.conf line 31

Nov 28 12:59:02 novprvlin0194 sympa[2601]: err Conf::_load_auth() _load_auth: unknown keyword 'timeout' in /home/sympa/default/auth.conf line 32

Nov 28 12:59:02 novprvlin0194 sympa[2601]: err Conf::_load_auth() _load_auth: unknown keyword 'suffix' in /home/sympa/default/auth.conf line 33

Nov 28 12:59:02 novprvlin0194 sympa[2601]: err Conf::_load_auth() _load_auth: unknown keyword 'get_dn_by_uid_filter' in /home/sympa/default/auth.conf line 34

Nov 28 12:59:02 novprvlin0194 sympa[2601]: err Conf::_load_auth() _load_auth: unknown keyword 'get_dn_by_email_filter' in /home/sympa/default/auth.conf line 35

Nov 28 12:59:02 novprvlin0194 sympa[2601]: err Conf::_load_auth() _load_auth: unknown keyword 'email_attribute' in /home/sympa/default/auth.conf line 36

Nov 28 12:59:02 novprvlin0194 sympa[2601]: err Conf::_load_auth() _load_auth: unknown keyword 'scope' in /home/sympa/default/auth.conf line 37

Nov 28 12:59:02 novprvlin0194 sympa[2611]: err List::get_user_db() Unable to execute SQL statement "SELECT email_user AS email, gecos_user AS gecos, password_user AS password, cookie_delay_user AS cookie_delay, lang_user AS lang , attributes_user AS attributes, data_user AS data, last_login_date_user AS last_login_date, wrong_login_count_user AS wrong_login_count, last_login_host_user AS last_login_host FROM user_table WHERE email_user = 'address@concealed' " : Lost connection to MySQL server during query

Nov 28 12:59:03 novprvlin0194 bulk[2615]: info Configuration file read, default log level 0

Nov 28 12:59:03 novprvlin0194 bulk[2615]: info Starting bulk master daemon, pid 2618

 

I have this set up in the /home/sympa/default/auth.conf  which correlates to lines 31 through 37 of the file.  I'm not sure about what the error is meaning on this.

#  LDAP

        host                            0249.xy.xy.com:636

 

        timeout                         20

        suffix                          dc=xyxyxy

        get_dn_by_uid_filter            (uid=[sender])

        get_dn_by_email_filter          (mail=[sender])

        email_attribute                 mail

        scope                           sub

 

The port is open'd up on the firewall and confirmed.  I'm just not sure of what the errors are in the log.

 

##### Secondly ####

I still want to be able to get data from an oracle data source.  What file do I add to do this and where do I put it?  This documentation isn't that helpful.

 

I've created a /home/sympa/etc/search_filters/its.sql  

where I want to add users that are in the ITS Dept from the SQL DB.  So do I need to create a search filter for each list?

 

Confused...

-- KC

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