The mailing list for listmasters using Sympa

[KC Wise <address@concealed>]

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