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

Lists <[email protected]>
Newsgroups gmane.network.proftpd.user
Message-ID <[email protected]>
Any suggestions for this issue?

Geoffrey Myers

> On Feb 22, 2017, at 10:13 AM, Geoffrey Myers <[email protected]> wrote:
> 
> 
> 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

------------------------------------------------------------------------------
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.