Ich poste mal meine Konfiguration.
Vielleicht hilft dir das.
SQLLog * history
SQLLog PASS updatecount
SQLLog PASS letzter_zugriff
SQLLog DELE delfile
SQLLog RETR getfile
SQLLog * history
SQLNamedQuery history INSERT "'%U', '%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'ok', NULL" history
SQLNamedQuery history_err INSERT "'%U', '%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'nicht ok', NULL" history
SQLNamedQuery updatecount UPDATE "ftp_login_count=ftp_login_count+1 WHERE loginname='%u'" users
SQLNamedQuery letzter_zugriff UPDATE "last_ftp_login = now() where loginname = '%u'" users
SQLNamedQuery delfile UPDATE "deleted ='ja' where loginname = '%u' and dateiname = '%F'" ftp_query
SQLNamedQuery getfile UPDATE "downloadcount = downloadcount + 1, last_download = now() where fullpath = '%f' and loginname = '%u'" ftp_query
SQLNamedQuery history INSERT "'%U', '%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'ok', NULL" ftp_history
SQLNamedQuery history_err INSERT "'%U', '%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'nicht ok', NULL" ftp_history
#
# Table structure for table 'ftp_history'
#
DROP TABLE IF EXISTS `ftp_history`;
CREATE TABLE `ftp_history` (
`loginname` varchar(30) default NULL,
`identname` varchar(30) default NULL,
`filename` text,
`size` bigint(20) default NULL,
`host` varchar(80) default NULL,
`ip` varchar(16) default NULL,
`aktion` varchar(255) default NULL,
`dauer` varchar(10) default NULL,
`zeit_lokal` datetime default NULL,
`status` set('ok','nicht ok','test') default NULL,
`ui` bigint(20) NOT NULL auto_increment,
PRIMARY KEY (`ui`)
) TYPE=MyISAM COMMENT='Ausgeführte FTP-Befehle (FTP-Warteschlange)';
#
# Table structure for table 'ftp_query'
#
DROP TABLE IF EXISTS `ftp_query`;
CREATE TABLE `ftp_query` (
`ftp_query_id` int(10) unsigned NOT NULL auto_increment,
`dateiname` char(255) NOT NULL default '',
`user_id` int(10) unsigned NOT NULL default '0',
`query_date` datetime NOT NULL default '0000-00-00 00:00:00',
`downloadcount` smallint(5) unsigned NOT NULL default '0',
`last_download` datetime default NULL,
`byte` int(10) unsigned NOT NULL default '0',
`files_id` int(10) unsigned default NULL,
`loginname` char(255) NOT NULL default '',
`deleted` enum('nein','ja') NOT NULL default 'nein',
`fullpath` char(255) NOT NULL default '',
PRIMARY KEY (`ftp_query_id`),
UNIQUE KEY `ftp_query_id` (`ftp_query_id`),
KEY `ftp_query_id_2` (`ftp_query_id`)
) TYPE=MyISAM COMMENT='Dateien in den FTP-Warteschlagen';
#
# Table structure for table 'history'
#
DROP TABLE IF EXISTS `history`;
CREATE TABLE `history` (
`loginname` varchar(30) default NULL,
`filename` text,
`size` bigint(20) default NULL,
`host` varchar(80) default NULL,
`ip` varchar(16) default NULL,
`aktion` varchar(255) default NULL,
`dauer` varchar(10) default NULL,
`zeit_lokal` datetime default NULL,
`status` set('ok','nicht ok') default NULL,
`ui` bigint(20) NOT NULL auto_increment,
PRIMARY KEY (`ui`),
KEY `zeit` (`zeit_lokal`),
KEY `loginname` (`loginname`)
) TYPE=MyISAM COMMENT='FTP-Befehlshistory für den Server Port 21';
Zeige Beiträge
