The mailing list for listmasters using Sympa

[David Verdin <address@concealed>]

Hi,

Most of the time, this is due to a problem on the database side. Maybe 
the database is unreachable, or the rights have been changed, the 
firewall rules modified, etc.

Cheers,

j2 a écrit :
> (Running 5.4.5)
>
> All of a sudden I get an error on a list 
>
> " subscribers update failed for list festinfo
>
> Sympa could not include subscribers from external data sources ; the
> database or LDAP directory might be unreachable. 
> Kontrollera Sympa's loggfiler för mer information
>
> "
>
> I upped debug to 4, but i cannot see the problem. The config is below. If I
> use mysql with the same arguments, I get the list as normal. 
>
> ==========================
>
> cat config
>
> visibility secret
>
> reply_to_header
> apply respect
> value list
>
> web_archive
> access private
>
> pictures_feature on
>
> serial 26
>
> subject [Festinfo från KinkyNights!]
>
> subscribe closed
>
> shared_doc
> d_edit owner
> d_read owner
>
> clean_delay_queuemod 15
>
> editor
> email [removed for list posting]
> reception mail
> visibility noconceal
> gecos xlace
>
> editor
> email [removed for list posting]
> reception mail
> visibility noconceal
>
> info private
>
> del closed
>
> unsubscribe closed
>
> creation
> email [removed for list posting]
> date 13 feb 2008 at 19:09:00
> date_epoch 1202926140
>
> update
> email [removed for list posting]
> date 09 apr 2009 at 23:04:39
> date_epoch 1239311079
>
> invite closed
>
> review owner
>
> send moderators_only
>
> add closed
>
> status open
>
> ttl 1800
>
> user_data_source include2
>
> available_user_options
> reception
> digest,digestplain,html,mail,nomail,not_me,notice,summary,txt,urlize
>
> rfc2369_header_fields archive,help,owner,post,subscribe,unsubscribe
>
> owner
> email address@concealed
> profile privileged
> reception mail
> visibility noconceal
>
> archive
> period month
> access owner
>
> include_sql_query
> db_name insidan
> name festinfo
> db_port 3306
> host localhost
> passwd [removed for list posting]
> db_type mysql
> user kn-utils
> sql_query select distinct email from jos_events_registrations where
> session_id = (select session_id from jos_events_sessions where email <> ''
> and title like 'KinkyNights%' and status <> '3' order by session_up desc
> limit 1)
>
> digest 5 20:56
>
> custom_subject [Festinfo från KinkyNights!]
>
> ===================================================================
>
> As we can see; running the query manually works:
>
> mysql> use insidan
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Database changed
> mysql>  select distinct email from jos_events_registrations where session_id
> = (select session_id from jos_events_sessions where email <> '' and title
> like 'KinkyNights%' and status <> '3' order by session_up desc limit 1)
>     -> ;
> +---------------------------------+
> | email                           |
> +---------------------------------+
> | [removed for list posting]@hotmail.com   |
> | [removed for list posting]@hotmail.com             |
> | [removed for list posting]@hotmail.com       |
> | [removed for list posting]@kinkynights.se            |
> | [removed for list posting]@hotmail.com       |
>
> Etc etc....
>
>
>
>
>   

--
David Verdin
Comité réseau des universités