If you compile and use proftpd-1.3.1_rc2 with mysql, nls and softquota, the mysql query won't work at least with some environments. My locale is de_DE.UTF8 (i think it will work with most other settings (see below) Reproducible: Always Steps to Reproduce: 1.Compile proftpd with USE flags mysql nls and softquota 2.Login to the server under control of mod_qoutatab 3.Try to send a file Actual Results: Jan 30 21:39:50 mod_sql/4.2.2[6381]: query "UPDATE quotatallies SET bytes_in_used = bytes_in_used + 0,000000, bytes_out_used = bytes_out_used + 0,000000, byt es_xfer_used = bytes_xfer_used + 0,000000, files_in_used = files_in_used + 0, files_out_used = files_out_used + 0, files_xfer_used = files_xfer_used + 0 WHER E name = 'user' AND quota_type = 'group'" Jan 30 21:39:50 mod_sql/4.2.2[6381]: entering mysql cmd_close Jan 30 21:39:50 mod_sql/4.2.2[6381]: connection 'default' count is now 1 Jan 30 21:39:50 mod_sql/4.2.2[6381]: exiting mysql cmd_close Jan 30 21:39:50 mod_sql/4.2.2[6381]: exiting mysql cmd_update Jan 30 21:39:50 mod_sql/4.2.2[6381]: <<< _process_named_query Jan 30 21:39:50 mod_sql/4.2.2[6381]: unrecoverable backend error Jan 30 21:39:50 mod_sql/4.2.2[6381]: error: '1064' Jan 30 21:39:50 mod_sql/4.2.2[6381]: message: 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the r ight syntax to use near '000000, bytes_out_used = bytes_out_used + 0,000000, bytes_xfer_used = bytes_xfer' at line 1' Jan 30 21:39:50 mod_sql/4.2.2[6381]: entering mysql cmd_exit Jan 30 21:39:50 mod_sql/4.2.2[6381]: entering mysql cmd_close Jan 30 21:39:50 mod_sql/4.2.2[6381]: connection 'default' closed Expected Results: It should update the quota table in mysql as it did before and/or without nls As mentioned above a workaround is to compile proftpd without nls support to get rid of the error. The problem is that because of european way of writing floating points (100,00 - comma!) instead od american way (100.00 - dot) the mysql query fails because of the special meaning of "," in the query. Nls support is partly broken in upstream.
The nsl USE flag and features are very much experimental in the RCs still, please report this upstream and link the bug back here, so I'll be able to add the patches to the tree once they're out. Best regards, CHTEKK.
Posted in the ProFTPd bug tracker http://bugs.proftpd.org/show_bug.cgi?id=2888
The bug has been resolved in ProFTPd CVS (i did not test it personally). Until a new version comes out it would be helpful to give a warning when compiling ProFTPd with quotatab, mysql, nls and a locale different from POSIX or US...
Fixed in net-ftp/proftpd-1.3.1_rc2-r1. Best regards, CHTEKK.
