Discussion:
[Proftpd-user] Failed database write stops file
Lists
2017-02-10 19:47:28 UTC
Permalink
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.

--
Geoffrey Myers
TJ Saunders
2017-02-10 20:51:28 UTC
Permalink
Post by Lists
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
Geoffrey Myers
2017-02-22 15:13:27 UTC
Permalink
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
Lists
2017-02-27 19:17:19 UTC
Permalink
Any suggestions for this issue?

Geoffrey Myers
Post by Lists
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
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
_______________________________________________
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
_______________________________________________
Unsubscribe problems?
http://www.proftpd.org/list-unsub.html
Loading...