search

sympa-community / sympa

Sympa, Mailing List Management Software
https://www.sympa.community/sympa
GNU General Public License v2.0
244 stars 97 forks source link

Editors defined from a SQL source missing people #1759

Closed Kkspike closed 3 months ago

Kkspike commented 10 months ago

We have numerous lists configured by families. I have a problem with one of the lists. We are getting the list of editors with a SQL query in one of our systems. The query returns 8 emails, when we synchronize the editors, only 5 are getting added/modified. I've checked on the SQL server and the query is good, I've logged on to the SQL server as the user who is using the query to get the editors and it returns 8 emails also. But whenever I syncrhonize the editors on that list, only the same 5 out of 8 are getting added/modified. I can't seem to find this action in the logs (I wanted to check if there was an error or something). What could cause the omittance of those 3 editors in particular ? They have no special characters in their emails (apostophes or the like)

Version

6.2.72

Installation method

yum install

Expected behavior

From a SQL source, 8 editors should be added/modified in the editors list

Actual behavior

Only the same 5 are added as editors out of the 8 from the query.

Additional information

Actual editors editors

From the query query

racke commented 10 months ago

Please check Sympa's exclusion_table for the missing editors.

Kkspike commented 10 months ago

Do you mean the exclusion table for that list or is there another table that I'm not aware of ? I thought about it before but there are no exclusions for that list exclusion

Kkspike commented 10 months ago

One user was present in the exclusion_table for another list (excluded from subscribers). I removed her exclusion but it had no effect on this exclusion on the editors on the list.

Kkspike commented 10 months ago

Is there a verbose log somewhere that keeps track of members, owners and editors modifications from external sources ?

ikedas commented 10 months ago

Hi @Kkspike ,

First, could you please present the log of Sympa before, during and after synchronizing the editors?

Kkspike commented 10 months ago

I started a tail -f on /var/log/sympa.log before synchronizing the editors. But nothing seems to be logged when I do. I see anything getting added to the log about this list at all. I've put the log level to 4 for this test and I still can't find any logs regarding this list added to sympa.log

I wish I could find an error or something.

ikedas commented 10 months ago

Some kind of log should be output (Log level may not be changed). How about restarting rsyslog.service?

Kkspike commented 10 months ago

This is something I haven't thought about. However, no luck even after restarting the rsyslog service. I'm at lost, here...

stale[bot] commented 3 months ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.