tag 604018 + patch thanks On Fri, 19 Nov 2010 04:42:12 -0800, fab wrote:
> Pure-ftpd fails to authenticate using a table in PostGreSQL DBMS. > I found the bug in this configuration file: /etc/pure-ftpd/db/postgresql.conf > There are some SQL queries, but it missing double quotes. > To correct them you have to copy and paste the queries from this web pages: > http://download.pureftpd.org/pub/pure-ftpd/doc/README.PGSQL Looking at the source package, it's indeed interesting to so the differences between README.PGSQL and pureftpd-pgsql.conf I'm attaching a debdiff, but I won't upload it now; maybe it helps the maintainer, maybe someone can test and confirm the bug and the fix ... Cheers, gregor -- .''`. http://info.comodo.priv.at/ -- GPG key IDs: 0x8649AA06, 0x00F3CFE4 : :' : Debian GNU/Linux user, admin, & developer - http://www.debian.org/ `. `' Member of VIBE!AT & SPI, fellow of Free Software Foundation Europe `- BOFH excuse #132: SCSI Chain overterminated
diff -u pure-ftpd-1.0.28/debian/changelog pure-ftpd-1.0.28/debian/changelog --- pure-ftpd-1.0.28/debian/changelog +++ pure-ftpd-1.0.28/debian/changelog @@ -1,3 +1,12 @@ +pure-ftpd (1.0.28-2.1) UNRELEASED; urgency=low + + * Non-maintainer upload. + * Fix "fails to authenticate, errors in configuration file (SQL)": add + quotation marks to pureftpd-pgsql.conf, as explained in README.PGSQL + (closes: #604018). + + -- gregor herrmann <gre...@debian.org> Sat, 27 Nov 2010 12:49:00 +0100 + pure-ftpd (1.0.28-2) unstable; urgency=low * fixes crash on stopping server (Closes: #572362) diff -u pure-ftpd-1.0.28/debian/po/pt.po pure-ftpd-1.0.28/debian/po/pt.po --- pure-ftpd-1.0.28/debian/po/pt.po +++ pure-ftpd-1.0.28/debian/po/pt.po @@ -11,6 +11,7 @@ "PO-Revision-Date: 2007-06-16 21:00+0100\n" "Last-Translator: Pedro Ribeiro <p.m42.ribe...@gmail.com>\n" "Language-Team: Portuguese <tra...@debianpt.org>\n" +"Language: pt\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=utf-8\n" "Content-Transfer-Encoding: 8bit\n" diff -u pure-ftpd-1.0.28/debian/po/cs.po pure-ftpd-1.0.28/debian/po/cs.po --- pure-ftpd-1.0.28/debian/po/cs.po +++ pure-ftpd-1.0.28/debian/po/cs.po @@ -19,6 +19,7 @@ "PO-Revision-Date: 2006-06-04 17:55+0200\n" "Last-Translator: Miroslav Kure <ku...@debian.cz>\n" "Language-Team: Czech <debian-l10n-cz...@lists.debian.org>\n" +"Language: cs\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" "Content-Transfer-Encoding: 8bit\n" diff -u pure-ftpd-1.0.28/debian/po/gl.po pure-ftpd-1.0.28/debian/po/gl.po --- pure-ftpd-1.0.28/debian/po/gl.po +++ pure-ftpd-1.0.28/debian/po/gl.po @@ -10,6 +10,7 @@ "PO-Revision-Date: 2008-05-17 21:28+0100\n" "Last-Translator: Jacobo Tarrio <jtar...@debian.org>\n" "Language-Team: Galician <proxe...@trasno.net>\n" +"Language: gl\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" "Content-Transfer-Encoding: 8bit\n" diff -u pure-ftpd-1.0.28/debian/po/it.po pure-ftpd-1.0.28/debian/po/it.po --- pure-ftpd-1.0.28/debian/po/it.po +++ pure-ftpd-1.0.28/debian/po/it.po @@ -11,6 +11,7 @@ "PO-Revision-Date: 2007-02-24 12:13+0100\n" "Last-Translator: Luca Monducci <luca...@tiscali.it>\n" "Language-Team: Italian <t...@lists.linux.it>\n" +"Language: it\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=ISO-8859-1\n" "Content-Transfer-Encoding: 8bit\n" diff -u pure-ftpd-1.0.28/debian/po/eu.po pure-ftpd-1.0.28/debian/po/eu.po --- pure-ftpd-1.0.28/debian/po/eu.po +++ pure-ftpd-1.0.28/debian/po/eu.po @@ -11,6 +11,7 @@ "PO-Revision-Date: 2008-08-12 11:13+0200\n" "Last-Translator: Piarres Beobide <p...@beobide.net>\n" "Language-Team: Euskara <debian-l10n-bas...@lists.debian.org>\n" +"Language: \n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" "Content-Transfer-Encoding: 8bit\n" diff -u pure-ftpd-1.0.28/debian/po/fi.po pure-ftpd-1.0.28/debian/po/fi.po --- pure-ftpd-1.0.28/debian/po/fi.po +++ pure-ftpd-1.0.28/debian/po/fi.po @@ -6,6 +6,7 @@ "PO-Revision-Date: 2008-08-01 22:11+0200\n" "Last-Translator: Esko Arajärvi <e...@iki.fi>\n" "Language-Team: Finnish <debian-l10n-finn...@lists.debian.org>\n" +"Language: fi\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=utf-8\n" "Content-Transfer-Encoding: 8bit\n" diff -u pure-ftpd-1.0.28/debian/po/vi.po pure-ftpd-1.0.28/debian/po/vi.po --- pure-ftpd-1.0.28/debian/po/vi.po +++ pure-ftpd-1.0.28/debian/po/vi.po @@ -10,6 +10,7 @@ "PO-Revision-Date: 2008-09-24 22:26+0930\n" "Last-Translator: Clytie Siddall <cly...@riverland.net.au>\n" "Language-Team: Vietnamese <vi...@googlegroups.com>\n" +"Language: vi\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" "Content-Transfer-Encoding: 8bit\n" @@ -110,12 +111,13 @@ "then delete the unused OPTIONS line to avoid seeing this message in the " "future." msgstr "" -"Pure-ftpd lúc bây giờ sử dụng tập tin cấu hình « /etc/pure-ftpd.conf » (thông " -"qua « pure-config.pl ») để cấu hình ở chế độ hoặc độc lập hoặc inetd. Có nên " -"kiểm tra bất cứ sự sửa đổi nào bạn đã làm trong các TÙY CHỌN (OPTIONS) « /etc/" -"default/pure-ftpd » cũng phản hồi trong « /etc/pure-ftpd.conf », vì chưa tìm " -"một phương pháp tự động hữu hiệu trong mọi trường hợp. Sau đó thì bạn có thể " -"xoá dòng TÙY CHỌN không dùng để tránh xem thông điệp này lần nữa." +"Pure-ftpd lúc bây giờ sử dụng tập tin cấu hình « /etc/pure-ftpd.conf " +"» (thông qua « pure-config.pl ») để cấu hình ở chế độ hoặc độc lập hoặc " +"inetd. Có nên kiểm tra bất cứ sự sửa đổi nào bạn đã làm trong các TÙY CHỌN " +"(OPTIONS) « /etc/default/pure-ftpd » cũng phản hồi trong « /etc/pure-ftpd." +"conf », vì chưa tìm một phương pháp tự động hữu hiệu trong mọi trường hợp. " +"Sau đó thì bạn có thể xoá dòng TÙY CHỌN không dùng để tránh xem thông điệp " +"này lần nữa." #. Type: note #. Description diff -u pure-ftpd-1.0.28/debian/po/fr.po pure-ftpd-1.0.28/debian/po/fr.po --- pure-ftpd-1.0.28/debian/po/fr.po +++ pure-ftpd-1.0.28/debian/po/fr.po @@ -17,6 +17,7 @@ "PO-Revision-Date: 2006-05-19 06:21+0200\n" "Last-Translator: Michel Grentzinger <mic.gre...@online.fr>\n" "Language-Team: French <debian-l10n-fre...@lists.debian.org>\n" +"Language: fr\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=ISO-8859-15\n" "Content-Transfer-Encoding: 8bit\n" diff -u pure-ftpd-1.0.28/debian/po/ja.po pure-ftpd-1.0.28/debian/po/ja.po --- pure-ftpd-1.0.28/debian/po/ja.po +++ pure-ftpd-1.0.28/debian/po/ja.po @@ -20,6 +20,7 @@ "PO-Revision-Date: 2007-01-10 10:03+0100\n" "Last-Translator: Hideki Yamane (Debian-JP) <henr...@debian.or.jp>\n" "Language-Team: Japanese <debian-japan...@lists.debian.org>\n" +"Language: ja\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" "Content-Transfer-Encoding: 8bit\n" diff -u pure-ftpd-1.0.28/debian/po/nl.po pure-ftpd-1.0.28/debian/po/nl.po --- pure-ftpd-1.0.28/debian/po/nl.po +++ pure-ftpd-1.0.28/debian/po/nl.po @@ -11,6 +11,7 @@ "PO-Revision-Date: 2007-03-05 21:23+0100\n" "Last-Translator: Bart Cornelis <cob...@skolelinux.no>\n" "Language-Team: debian-l10n-dutch <debian-l10n-du...@lists.debian.org>\n" +"Language: \n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=utf-8\n" "Content-Transfer-Encoding: 8bit\n" diff -u pure-ftpd-1.0.28/debian/po/sv.po pure-ftpd-1.0.28/debian/po/sv.po --- pure-ftpd-1.0.28/debian/po/sv.po +++ pure-ftpd-1.0.28/debian/po/sv.po @@ -19,6 +19,7 @@ "PO-Revision-Date: 2008-07-21 16:09+0100\n" "Last-Translator: Martin Bagge <brot...@bsnet.se>\n" "Language-Team: Swedish <s...@li.org>\n" +"Language: sv\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=iso-8859-1\n" "Content-Transfer-Encoding: 8bit\n" diff -u pure-ftpd-1.0.28/debian/po/es.po pure-ftpd-1.0.28/debian/po/es.po --- pure-ftpd-1.0.28/debian/po/es.po +++ pure-ftpd-1.0.28/debian/po/es.po @@ -37,6 +37,7 @@ "PO-Revision-Date: 2009-03-03 11:29+0100\n" "Last-Translator: Fernando González de Requena <fgrequ...@gmail.com>\n" "Language-Team: Spanish <debian-l10n-span...@lists.debian.org>\n" +"Language: es\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" "Content-Transfer-Encoding: 8bit\n" diff -u pure-ftpd-1.0.28/debian/po/ru.po pure-ftpd-1.0.28/debian/po/ru.po --- pure-ftpd-1.0.28/debian/po/ru.po +++ pure-ftpd-1.0.28/debian/po/ru.po @@ -11,12 +11,13 @@ "PO-Revision-Date: 2008-08-02 21:24+0400\n" "Last-Translator: Yuri Kozlov <kozlo...@gmail.com>\n" "Language-Team: Russian <debian-l10n-russ...@lists.debian.org>\n" +"Language: ru\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" "Content-Transfer-Encoding: 8bit\n" "X-Generator: KBabel 1.11.4\n" -"Plural-Forms: nplurals=3; plural=(n%10==1 && n%100!=11 ? 0 : n%10>=2 && n%" -"10<=4 && (n%100<10 || n%100>=20) ? 1 : 2);\n" +"Plural-Forms: nplurals=3; plural=(n%10==1 && n%100!=11 ? 0 : n%10>=2 && n" +"%10<=4 && (n%100<10 || n%100>=20) ? 1 : 2);\n" #. Type: select #. Choices diff -u pure-ftpd-1.0.28/debian/po/de.po pure-ftpd-1.0.28/debian/po/de.po --- pure-ftpd-1.0.28/debian/po/de.po +++ pure-ftpd-1.0.28/debian/po/de.po @@ -16,10 +16,11 @@ msgstr "" "Project-Id-Version: pure-ftpd 1.0.21-5\n" "Report-Msgid-Bugs-To: pure-f...@packages.debian.org\n" -"POT-Creation-Date: 2006-10-19 01:21+0200\n" +"POT-Creation-Date: 2010-01-11 09:05+0000\n" "PO-Revision-Date: 2006-11-24 18:22-0500\n" "Last-Translator: Matthias Julius <m...@julius-net.net>\n" "Language-Team: German <debian-l10n-ger...@lists.debian.org>\n" +"Language: de\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" "Content-Transfer-Encoding: 8bit\n" @@ -136,7 +137,8 @@ #. Description #: ../pure-ftpd-common.templates:4001 msgid "Your old pure-ftpd configuration from inetd.conf has been saved" -msgstr "Ihre alte »pure-ftpd«-Konfiguration aus der inetd.conf wurde gespeichert." +msgstr "" +"Ihre alte »pure-ftpd«-Konfiguration aus der inetd.conf wurde gespeichert." #. Type: note #. Description @@ -197 +198,0 @@ - only in patch2: unchanged: --- pure-ftpd-1.0.28.orig/pureftpd-pgsql.conf +++ pure-ftpd-1.0.28/pureftpd-pgsql.conf @@ -43,12 +43,12 @@ # Query to execute in order to fetch the password -PGSQLGetPW SELECT Password FROM users WHERE User='\L' +PGSQLGetPW SELECT "Password" FROM "users" WHERE "User"='\L' # Query to execute in order to fetch the system user name or uid -PGSQLGetUID SELECT Uid FROM users WHERE User='\L' +PGSQLGetUID SELECT "Uid" FROM "users" WHERE "User"='\L' # Optional : default UID - if set this overrides PGSQLGetUID @@ -58,7 +58,7 @@ # Query to execute in order to fetch the system user group or gid -PGSQLGetGID SELECT Gid FROM users WHERE User='\L' +PGSQLGetGID SELECT "Gid" FROM "users" WHERE "User"='\L' # Optional : default GID - if set this overrides PGSQLGetGID @@ -68,31 +68,31 @@ # Query to execute in order to fetch the home directory -PGSQLGetDir SELECT Dir FROM users WHERE User='\L' +PGSQLGetDir SELECT "Dir" FROM "users" WHERE "User"='\L' # Optional : query to get the maximal number of files # Pure-FTPd must have been compiled with virtual quotas support. -# PGSQLGetQTAFS SELECT QuotaFiles FROM users WHERE User='\L' +# PGSQLGetQTAFS SELECT "QuotaFiles" FROM "users" WHERE "User"='\L' # Optional : query to get the maximal disk usage (virtual quotas) # The number should be in Megabytes. # Pure-FTPd must have been compiled with virtual quotas support. -# PGSQLGetQTASZ SELECT QuotaSize FROM users WHERE User='\L' +# PGSQLGetQTASZ SELECT "QuotaSize" FROM "users" WHERE "User"='\L' # Optional : ratios. The server has to be compiled with ratio support. -# PGSQLGetRatioUL SELECT ULRatio FROM users WHERE User='\L' -# PGSQLGetRatioDL SELECT DLRatio FROM users WHERE User='\L' +# PGSQLGetRatioUL SELECT "ULRatio" FROM "users" WHERE "User"='\L' +# PGSQLGetRatioDL SELECT "DLRatio" FROM "users" WHERE "User"='\L' # Optional : bandwidth throttling. # The server has to be compiled with throttling support. # Values are in KB/s . -# PGSQLGetBandwidthUL SELECT ULBandwidth FROM users WHERE User='\L' -# PGSQLGetBandwidthDL SELECT DLBandwidth FROM users WHERE User='\L' +# PGSQLGetBandwidthUL SELECT "ULBandwidth" FROM "users" WHERE "User"='\L' +# PGSQLGetBandwidthDL SELECT "DLBandwidth" FROM "users" WHERE "User"='\L'
signature.asc
Description: Digital signature
