www.ProFTPD.de

ProFTPD => ProFTPD - English => Thema gestartet von: Magnus am 11. Februar 2004, 13:18:31



Titel: When does proftpd update mysql database ?
Beitrag von: Magnus am 11. Februar 2004, 13:18:31
I wonder when proftpd updates mysql database
is it when the transfer initiates or when the transfer is finished succesfully ?

:)

//Magnus


Titel: Re: When does proftpd update mysql database ?
Beitrag von: stonki am 11. Februar 2004, 13:50:59
Zitat von: "Magnus"
I wonder when proftpd updates mysql database
is it when the transfer initiates or when the transfer is finished succesfully ?
//Magnus


IMHO after...

cu
stonki


Titel: When does proftpd update mysql database ?
Beitrag von: Magnus am 12. Februar 2004, 19:04:07
ok i hope so :)

i have built an app that triggers when
timestamp of files transfered is present

wouldnt be so good if it executed ther "app" when the file is incomplete....


//Magnus


Titel: When does proftpd update mysql database ?
Beitrag von: Wörsty am 12. Februar 2004, 21:14:11
The query is executed AFTER an operation.
But there are different SQLQueries.

Normal / Successfully mode - After complete (good) transfer
And ERR_ after problems - e.g. transfer aborted.

Example:
Code:

#Good Case Logging
SQLLog *  history
SQLNamedQuery history     INSERT "'%U', '%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'ok', NULL" ftp_history
#Faulty Case Logging
SQLLOG ERR_* history_err
SQLNamedQuery history_err INSERT "'%U', '%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'nicht ok', NULL" ftp_history


Code:
USE ftpserver;

#
# Table structure for table 'benutzer'
#

DROP TABLE IF EXISTS benutzer;
CREATE TABLE `benutzer` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `owner_id` int(11) unsigned NOT NULL default '0',
  `gid` tinyint(3) unsigned default '1',
  `beschreibung` text,
  `loginname` varchar(30) NOT NULL default '',
  `passwort` varchar(16) NOT NULL default '',
  `verzeichnis` varchar(255) NOT NULL default '/',
  `anmerkung` text,
  `login_count` int(10) unsigned default '0',
  `add_datum` datetime default NULL,
  `gueltig_bis` datetime default NULL,
  `last_login` datetime default NULL,
  `active` set('on','off') default 'on',
  `hidden` set('true','false') NOT NULL default 'false',
  `deleted` set('true','false') NOT NULL default 'false',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `Login` (`loginname`)
) TYPE=MyISAM COMMENT='FTP-Benutzer';

#
# Table structure for table 'gruppen'
#

DROP TABLE IF EXISTS gruppen;
CREATE TABLE `gruppen` (
  `ID` tinyint(3) unsigned NOT NULL auto_increment,
  `name` varchar(16) NOT NULL default '',
  `mitglieder` text,
  `basedir` varchar(30) default NULL,
  UNIQUE KEY `ID` (`ID`,`name`)
) TYPE=MyISAM COMMENT='FTP-Benutzergruppen';

#
# 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`)
) TYPE=MyISAM COMMENT='FTP-Befehlshistory';


Titel: When does proftpd update mysql database ?
Beitrag von: Magnus am 13. Februar 2004, 05:50:21
Thanks :)
that is PERFECT !

i must take the oportunity to thank for the swift support answers !
and a great product !

//Magnus