The mailing list for listmasters using Sympa

[Matthew Promenchenkel <address@concealed>]

You need to make the following change in the mysql config.  

    vi /etc/my.conf

        [mysqld]

        net_buffer_length=1000000

        max_allowed_packet=1000000000


Now restart mysql

        
        service mysqld restart

And test to make sure this is in place:

        mysql> show variables like 'max_allowed_packet';

        +--------------------+---------+

        | Variable_name      | Value   |

        +--------------------+---------+

        | max_allowed_packet | 1048576 |

        +--------------------+---------+

        1 row in set (0.18 sec)


Matthew 



----- Original Message -----
From: "Ibirisol Fontes Ferreira" <address@concealed>
To: "sympa-users" <address@concealed>
Sent: Wednesday, August 8, 2012 8:12:57 AM
Subject: [sympa-users] Erro in Bulk spool

Hi there,

I got a error message that is shown below.

---
Aug  8 04:32:44 websrv sympa[17700]: err Bulk::store() Unable to add
message in bulkspool_table "INSERT INTO bulkspool_table
(messagekey_bulkspool, messageid_bulkspool, message_bulkspool,
lock_bulkspool, dkim_d_bulkspool, dkim_i_bulkspool,
dkim_selector_bulkspool, dkim_privatekey_bulkspool,
dkim_header_list_bulkspool) VALUES ('920da5279431bfd0a3735ae27101cc44',
'<rt-3.6.7-8237-1344423258-1849.5020-29-0@NOC PoP-BA/RNP>',
'UmV0dXJuLVBhdGg6IDx3d3ctZGF0YUBnZXJlbmNpYS5wb3AtYmEucm5wLmJyPgpYLU9yaWdpbmFs\nLVRvOiBvcGVyYWNhb0BsaXN',
 1, NULL ,NULL ,NULL, '', NULL)"; error : Got a packet bigger than 
'max_allowed_packet' bytes
---

I tried configure the max_allowed_packet variable in mysql client in
sympa server, but don't worked. Anyone know as fix this error? if is in
mysql-server or in mysql client on sympa server?

Bye,
-- 
IBIRISOL FONTES FERREIRA