Re: [Proftpd-user] Failed database write stops file

Geoffrey Myers <[email protected]>
Newsgroups gmane.network.proftpd.user
Message-ID <[email protected]>
On February 10, 2017 at 3:51 PM TJ Saunders <[email protected]> wrote:

We discovered yesterday that if proftpd is unable to write to our
Microsoft sql db, it does not complete the transfer. Is there a solution
to this problem? We need the file to be transferred regardless of db
write is successful or not.

Could you show us the proftpd config, particularly the mod_sql portion,
that you're using? There may be a way to deal with the situation...

Cheers,
TJ

<IfModule mod_sql.c>

SQLEngine log

SQLBackend tds
SQLAuthenticate off

SQLLogFile /home/ftp/sql.log

SQLConnectInfo [email protected]:12345 user password PERCONNECTION

SQLNamedQuery insertfileinfo INSERT "'%U', '%{time:%Y-%m-%d %H:%M:%S}', '%f', '%m' , '', '%{protocol}', %b, '%a'" tableName

SQLLog STOR,RETR insertfileinfo

</IfModule>

------------------------------------------------------------------------------Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot

_______________________________________________
ProFTPD Users List <[email protected]>
Unsubscribe problems?
http://www.proftpd.org/list-unsub.html

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot

_______________________________________________
ProFTPD Users List   <[email protected]>
Unsubscribe problems?
http://www.proftpd.org/list-unsub.html
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.