samba: Jul 14 10:28:37 fileserver smbd_vscan-clamav[3440]: [2006/07/14 10:28:37, 0] smbd/session.c:session_yield(264) Jul 14 10:28:37 fileserver smbd_vscan-clamav[3440]: executed sql-querry 'UPDATE loginout set outtime=NOW() WHERE username='hb' and host='192.168.0.1' and sessionid='smb/3440/101' and outtime = 0 LIMIT 1;' Jul 14 10:28:43 fileserver smbd_vscan-clamav[8696]: [2006/07/14 10:28:43, 0] smbd/session.c:session_yield(264) Jul 14 10:28:43 fileserver smbd_vscan-clamav[8696]: executed sql-querry 'UPDATE loginout set outtime=NOW() WHERE username='hb' and host='192.168.0.1' and sessionid='smb/8696/101' and outtime = 0 LIMIT 1;' Jul 14 10:28:44 fileserver smbd_vscan-clamav[18650]: [2006/07/14 10:28:44, 0] smbd/session.c:session_yield(264) Jul 14 10:28:44 fileserver smbd_vscan-clamav[18650]: executed sql-querry 'UPDATE loginout set outtime=NOW() WHERE username='hb' and host='192.168.0.1' and sessionid='smb/18650/101' and outtime = 0 LIMIT 1;' Jul 14 10:32:14 fileserver smbd_vscan-clamav[6196]: [2006/07/14 10:32:14, 0] smbd/session.c:session_yield(264) Jul 14 10:32:14 fileserver smbd_vscan-clamav[6196]: executed sql-querry 'UPDATE loginout set outtime=NOW() WHERE username='01mazde' and host='192.168.10.15' and sessionid='smb/6196/105' and outtime = 0 LIMIT 1;' Jul 14 10:35:03 fileserver smbd_vscan-clamav[29354]: [2006/07/14 10:35:03, 0] lib/util_sock.c:read_data(534) Jul 14 10:35:03 fileserver smbd_vscan-clamav[29354]: read_data: read failure for 4 bytes to client 192.168.127.6. Error = Keine Route zum Zielrechner Jul 14 10:35:03 fileserver smbd_vscan-clamav[29354]: [2006/07/14 10:35:03, 0] smbd/session.c:session_yield(264) Jul 14 10:35:03 fileserver smbd_vscan-clamav[29354]: executed sql-querry 'UPDATE loginout set outtime=NOW() WHERE username='04sifri' and host='192.168.127.6' and sessionid='smb/29354/101' and outtime = 0 LIMIT 1;' Jul 14 10:35:08 fileserver smbd_vscan-clamav[19435]: [2006/07/14 10:35:08, 0] lib/util_sock.c:read_data(534) Jul 14 10:35:08 fileserver smbd_vscan-clamav[19435]: read_data: read failure for 4 bytes to client 192.168.127.6. Error = Keine Route zum Zielrechner Jul 14 10:35:08 fileserver smbd_vscan-clamav[19435]: [2006/07/14 10:35:08, 0] lib/util_sock.c:write_data(562) Jul 14 10:35:08 fileserver smbd_vscan-clamav[19435]: write_data: write failure in writing to client 192.168.127.6. Error Datenübergabe unterbrochen (broken pipe) Jul 14 10:35:08 fileserver smbd_vscan-clamav[19435]: [2006/07/14 10:35:08, 0] lib/util_sock.c:send_smb(769) Jul 14 10:35:08 fileserver smbd_vscan-clamav[19435]: Error writing 75 bytes to client. -1. (Datenübergabe unterbrochen (broken pipe)) Jul 14 10:35:15 fileserver smbd_vscan-clamav[4596]: [2006/07/14 10:35:15, 0] smbd/session.c:session_yield(264) Jul 14 10:35:15 fileserver smbd_vscan-clamav[4596]: executed sql-querry 'UPDATE loginout set outtime=NOW() WHERE username='05nirei' and host='192.168.10.2' and sessionid='smb/4596/251' and outtime = 0 LIMIT 1;' Jul 14 10:41:49 fileserver smbd_vscan-clamav[3437]: [2006/07/14 10:41:49, 0] lib/util_sock.c:read_data(534) Jul 14 10:41:49 fileserver smbd_vscan-clamav[3437]: read_data: read failure for 4 bytes to client 192.168.127.6. Error = Keine Route zum Zielrechner Jul 14 10:42:19 fileserver smbd_vscan-clamav[6734]: [2006/07/14 10:42:19, 0] lib/util_sock.c:read_data(534) Jul 14 10:42:19 fileserver smbd_vscan-clamav[6734]: read_data: read failure for 4 bytes to client 192.168.10.11. Error = Keine Route zum Zielrechner Jul 14 10:42:19 fileserver smbd_vscan-clamav[6734]: [2006/07/14 10:42:19, 0] lib/util_sock.c:write_data(562) Jul 14 10:42:19 fileserver smbd_vscan-clamav[6734]: write_data: write failure in writing to client 192.168.10.11. Error Datenübergabe unterbrochen (broken pipe) Jul 14 10:42:19 fileserver smbd_vscan-clamav[6734]: [2006/07/14 10:42:19, 0] lib/util_sock.c:send_smb(769) Jul 14 10:42:19 fileserver smbd_vscan-clamav[6734]: Error writing 75 bytes to client. -1. (Datenübergabe unterbrochen (broken pipe)) Jul 14 10:42:55 fileserver smbd_vscan-clamav[10743]: [2006/07/14 10:42:55, 0] smbd/session.c:session_yield(264) Jul 14 10:42:55 fileserver smbd_vscan-clamav[10743]: executed sql-querry 'UPDATE loginout set outtime=NOW() WHERE username='00dedra' and host='192.168.10.13' and sessionid='smb/10743/355' and outtime = 0 LIMIT 1;' Jul 14 10:43:57 fileserver smbd_vscan-clamav[10743]: [2006/07/14 10:43:57, 0] smbd/session.c:session_yield(264) Jul 14 10:43:57 fileserver smbd_vscan-clamav[10743]: executed sql-querry 'UPDATE loginout set outtime=NOW() WHERE username='00dedra' and host='192.168.10.13' and sessionid='smb/10743/391' and outtime = 0 LIMIT 1;' Jul 14 10:46:45 fileserver smbd_vscan-clamav[13283]: [2006/07/14 10:46:45, 0] lib/util_sock.c:read_data(534) Jul 14 10:46:45 fileserver smbd_vscan-clamav[13283]: read_data: read failure for 4 bytes to client 192.168.18.1. Error = Keine Route zum Zielrechner Jul 14 10:46:45 fileserver smbd_vscan-clamav[13283]: [2006/07/14 10:46:45, 0] lib/util_sock.c:write_data(562) Jul 14 10:46:45 fileserver smbd_vscan-clamav[13283]: write_data: write failure in writing to client 192.168.18.1. Error Datenübergabe unterbrochen (broken pipe) Jul 14 10:46:45 fileserver smbd_vscan-clamav[13283]: [2006/07/14 10:46:45, 0] lib/util_sock.c:send_smb(769) Jul 14 10:46:45 fileserver smbd_vscan-clamav[13283]: Error writing 75 bytes to client. -1. (Datenübergabe unterbrochen (broken pipe)) Jul 14 10:51:02 fileserver smbd_vscan-clamav[7218]: [2006/07/14 10:51:02, 0] lib/util_sock.c:read_data(534) Jul 14 10:51:02 fileserver smbd_vscan-clamav[7218]: read_data: read failure for 4 bytes to client 192.168.18.5. Error = Keine Route zum Zielrechner Jul 14 10:51:02 fileserver smbd_vscan-clamav[7218]: [2006/07/14 10:51:02, 0] smbd/session.c:session_yield(264) Jul 14 10:51:02 fileserver smbd_vscan-clamav[7218]: executed sql-querry 'UPDATE loginout set outtime=NOW() WHERE username='00jabo' and host='192.168.18.5' and sessionid='smb/7218/105' and outtime = 0 LIMIT 1;' Jul 14 10:53:10 fileserver smbd_vscan-clamav[4596]: [2006/07/14 10:53:10, 0] smbd/session.c:session_yield(264) Jul 14 10:53:10 fileserver smbd_vscan-clamav[4596]: executed sql-querry 'UPDATE loginout set outtime=NOW() WHERE username='01kahe' and host='192.168.10.2' and sessionid='smb/4596/259' and outtime = 0 LIMIT 1;' Jul 14 10:54:11 fileserver smbd[27992]: [2006/07/14 10:54:11, 0] smbd/session.c:session_yield(264) Jul 14 10:54:11 fileserver smbd[27992]: executed sql-querry 'UPDATE loginout set outtime=NOW() WHERE username='mo' and host='192.168.0.1' and sessionid='smb/27992/100' and outtime = 0 LIMIT 1;' Jul 14 10:56:11 fileserver smbd[20516]: [2006/07/14 10:56:11, 0] smbd/session.c:session_yield(264) Jul 14 10:56:11 fileserver smbd[20516]: executed sql-querry 'UPDATE loginout set outtime=NOW() WHERE username='zm' and host='192.168.0.1' and sessionid='smb/20516/100' and outtime = 0 LIMIT 1;' mysql: mysql> select username,sessionid,intime,outtime from loginout where outtime = 0; +------------------------+---------------+---------------------+---------------------+ | username | sessionid | intime | outtime | +------------------------+---------------+---------------------+---------------------+ | 05tile | smb/6734/107 | 2006-07-14 09:27:32 | 0000-00-00 00:00:00 | | 04sifri | smb/19435/105 | 2006-07-14 09:51:38 | 0000-00-00 00:00:00 | | 00jawe | smb/13283/101 | 2006-07-14 10:23:30 | 0000-00-00 00:00:00 | +------------------------+---------------+---------------------+---------------------+