The mailing list for listmasters using Sympa

[Matthew Goebel <address@concealed>]

Sympa 6.2.56 with mariadb, postfix and apache on Redhat 7

Seems to be an issue where when you don't have gecos name field set to something besides NULL the software throws lots of errors into log file 

in /home/sympa/spool/tmp and sometimes when you restart the service it tries to allocate massive amounts of memory, because I think it is throwing 

errors due to NULL gecos field and not spitting them into the temp file but holding them in memory for some reason.

from tmp file 

Use of uninitialized value $value in printf at /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN1179904> line 1.

Use of uninitialized value $value in printf at /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN1179904> line 1.

Use of uninitialized value $value in printf at /home/sympa/bin/Sympa/DataSource/SQL.pm line 91, <GEN1179904> line 1.

Matt

On Sat, Oct 3, 2020 at 2:30 PM Stefan Hornburg (Racke) <address@concealed> wrote:

On 10/3/20 3:03 AM, Matthew Goebel wrote:
> Hello,
>
>   I've noticed some issues which seemed to be caused by most of our users not have the
>
> gecos_user field set ( is NULL ).  Anyone think of anything bad that would 
>
> happen if I ran the following command in mariadb?
>
>
> update user_table set gecos_user = ' ' where gecos_user is NULL;
>

Don't think you need the whitespace. It should work OK, but I can't give
a guarantee on it.

It would helpful if you describe the issues (with log messages when available), so
we can actually fix the bug instead of working around.

Also please let us know which Sympa version you are using.

Regards
         Rake

>
> Thanks,
> Matt
>
> --
> Matthew Goebel : m <mailto:address@concealed>address@concealed <mailto:address@concealed> : Unix Jockey @ EMU : Hail
> Eris
> Neo-Student, Net Lurker, Donut consumer, and procrastinating medher...
>  "Always with the negative waves, Moriarty" - Oddball
>  "Comfort the troubled, and trouble the comfortable." - Dietrich Bonhoeffer
>
>


--
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration. Provisioning with Ansible.

--

Matthew Goebel : maddress@concealed : Unix Jockey @ EMU : Hail Eris
Neo-Student, Net Lurker, Donut consumer, and procrastinating medher...
 "Always with the negative waves, Moriarty" - Oddball
 "Comfort the troubled, and trouble the comfortable." - Dietrich Bonhoeffer