On 13-05-13 4:35 AM, Fabio Onorini wrote:
Hello sogo users,
every morning I need to restart samba service on my sogo test server.
Without this operation, I can't connect with outlook.
This is only test server, that not receive or send mail during night.
this is really strange and looks like bug #2303
(http://sogo.nu/bugs/view.php?id=2303 - sorry this is in french)
Can you get a pcap of the communication between samba(sogo) and mysql?
Use tcpdump to capture traffic while the communication works, let it run over
night, and the reproduce the problem the next morning, then stop the capture.
Then send me the pcap in private.
Also, can you paste a few more lines of contexts from the samba log? (50 lines
above what you showed would be helpful)
Thanks.
Today I see this rows in samba log:
2013-05-13 07:54:10.841 samba[2436] <MySQL4Channel[0x0x17ffc00]
connection=0x0x2116900> SQL: SELECT count(*) FROM socfs_sogo1;
2013-05-13 07:54:10.861 samba[2436] <MySQL4Channel[0x0x17ffc00]
connection=0x0x2116900> ERROR: MySQL server has gone away
2013-05-13 07:54:10.861 samba[2436] <MySQL4Channel[0x0x17ffc00]
connection=0x0x2116900> SQL: CREATE TABLE socfs_sogo1 ( c_path VARCHAR(255)
PRIMARY KEY, c_parent_path VARCHAR(255), c_type TINYINT NOT NULL, c_creationdate
INT NOT NULL, c_lastmodified INT NOT NULL, c_version INT NOT NULL DEFAULT 0,
c_deleted TINYINT NOT NULL DEFAULT 0, c_content LONGTEXT);
2013-05-13 07:54:10.861 samba[2436] <MySQL4Channel[0x0x17ffc00]
connection=0x0x2116900> ERROR: MySQL server has gone away
/usr/sbin/samba: Uncaught exception MAPIStoreIOException, reason: could not
create special table 'socfs_sogo1'
[2013/05/13 07:54:11, 0]
mapiproxy/servers/default/nspi/dcesrv_exchange_nsp.c:1394(dcesrv_exchange_nsp_unbind)
dcesrv_exchange_nsp_unbind
Maybe with no activity on server, samba lost connection with mysql and need
restart to work correctly.
Any suggestion?
--
-----------------------
Fabio Onorini
--
users@sogo.nu
https://inverse.ca/sogo/lists
