Ok, this night I will start traffic capture and tomorrow I will send you.
2013/5/13 Jean Raby <[email protected]> > 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<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 >> > > -- > [email protected] > https://inverse.ca/sogo/lists > -- ----------------------- Fabio Onorini -- [email protected] https://inverse.ca/sogo/lists
