Skip to Content.
Sympa Menu

en - Problem Include sql

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: address@concealed
  • To: address@concealed
  • Subject: Problem Include sql
  • Date: Fri, 21 Feb 2003 14:34:38 +0100

Hello everybody,

I am upgrading to sympa 3.4.3.1.
My configuration:
Red Hat 8.0
Database to server sympa - Mysql

I created the list docente that needs to get users from other Database
(Sybase), here is part of list's configuration:

-------- config ----------
...
user_data_source include
...
include_sql_query
passwd XXXX
db_name agestatdb
db_type Sybase
user user01
sql_query select distinct email from web_usuario where not (email = null or
email = '')
host desenv
...
--------------------------

I know that BDB::Sybase is working and SQL's query is right, but sympa refuse
to distribute any message, here is part of log:
----- LOG ---------
Feb 21 10:00:09 CAPES01 sympa[15670]: Processing message for docente with
priority 5, <address@concealed>
Feb 21 10:00:09 CAPES01 sympa[15670]: Key 486cb4bf2ad3fa8af5355f1d726094b8
for list docente from address@concealed sent to editors,
/address@concealed
Feb 21 10:01:30 CAPES01 sympa[15670]: Parsing: DISTRIBUTE docente
486cb4bf2ad3fa8af5355f1d726094b8
Feb 21 10:01:30 CAPES01 sympa[15670]: No subscriber for sending msg in list
docente
Feb 21 10:01:30 CAPES01 sympa[15670]: Multipart message changed to singlepart
Feb 21 10:01:30 CAPES01 sympa[15670]: No command found in message
Feb 21 10:01:30 CAPES01 sympa[15670]: Moving bad file
address@concealed to bad/
Feb 21 10:01:38 CAPES01 archived[15677]: Archiving
address@concealed for list
address@concealed
--------------------

I will be glad with any help.

Thank you,
Gustavo Araujo Bittencourt.

PS: I correct a error with List.pm when connect to Sybase, I will report to
developers.


  • Problem Include sql, gustavo . bittencourt, 02/21/2003

Archive powered by MHonArc 2.6.19+.

Top of Page