The mailing list for listmasters using Sympa

[Matthew Goebel <address@concealed>]

I have hand applied this fix for this on my production boxes and it has fixed the issues that I was experiencing.

Thanks,
Matt

On Mon, Oct 5, 2020 at 12:04 PM Stefan Hornburg (Racke) <address@concealed> wrote:

On 10/5/20 4:20 PM, Matthew Goebel wrote:
> Sympa 6.2.56 <https://www.sympa.org/> 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
>

This problem has been fixed by pull request https://github.com/sympa-community/sympa/pull/941 and will be included
in the next release of Sympa (6.2.58).

Regards
         Racke

>
> On Sat, Oct 3, 2020 at 2:30 PM Stefan Hornburg (Racke) <address@concealed <mailto: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 <mailto:address@concealed>>address@concealed
>     <mailto:address@concealed> <mailto: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 : 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