Description of problem: If in config have SQLAuthTypes Backend then get an error: [root@server server]# Message from syslogd@server at Jul 1 22:44:04 ... oftpd: 192.168.1.3:36064: PASS (hidden): symbol lookup error: /usr/libexec/proftpd/mod_sql_mysql.so: undefined symbol: make_scrambled_password Message from syslogd@server at Jul 1 22:44:57 ... oftpd: 192.168.1.3:36084: PASS (hidden): symbol lookup error: /usr/libexec/proftpd/mod_sql_mysql.so: undefined symbol: make_scrambled_password ^C Version-Release number of selected component (if applicable): [root@server server]# proftpd -v ProFTPD Version 1.3.4rc2 How reproducible: Just use SQL auth Actual results: Message from syslogd@server at Jul 1 22:44:04 ... oftpd: 192.168.1.3:36064: PASS (hidden): symbol lookup error: /usr/libexec/proftpd/mod_sql_mysql.so: undefined symbol: make_scrambled_password Message from syslogd@server at Jul 1 22:44:57 ... oftpd: 192.168.1.3:36084: PASS (hidden): symbol lookup error: /usr/libexec/proftpd/mod_sql_mysql.so: undefined symbol: make_scrambled_password ^C
Created attachment 510928 [details] my conf
Looks very similar to Bug #690346 for pure-ftpd. Can you give this scratch build a try? http://koji.fedoraproject.org/koji/taskinfo?taskID=3175023
How to download it?
Just follow the "Descendent Tasks" -> "build" link for your architecture and you'll get a page with download links, e.g. http://koji.fedoraproject.org/koji/taskinfo?taskID=3175025 for the i386 build.
Thanks, error is gone, but mysql auth still not working (I will look for why...)
I have a new build for you to try, this time with a slightly different fix from upstream: http://koji.fedoraproject.org/koji/taskinfo?taskID=3185886 As it has the same version/release as the previous build, you'll need to use "rpm -Uvh --replacefiles --replacepkgs" to install it. Please let me know how it goes.
(In reply to comment #6) > I have a new build for you to try, this time with a slightly different fix from > upstream: > > http://koji.fedoraproject.org/koji/taskinfo?taskID=3185886 > > As it has the same version/release as the previous build, you'll need to use > "rpm -Uvh --replacefiles --replacepkgs" to install it. Please let me know how > it goes. Have you been able to try this new build? Does it help?
Hello, sorry for wait, I install this package but it does not work. If I connect to FTP with use mysql, have this error in ssh [root@server tmp]# rpm -U http://visionscms.com/proftpd-1.3.4-0.11.rc2.fc15.i686.rpm http://visionscms.com/proftpd-mysql-1.3.4-0.11.rc2.fc15.i686.rpm [root@server tmp]# mv /etc/proftpd.conf.rpmsave /etc/proftpd.conf mv: переписать «/etc/proftpd.conf»? y [root@server tmp]# service proftpd restart Restarting proftpd (via systemctl): [ OK ] [root@server tmp]# Message from syslogd@server at Jul 13 21:22:49 ... oftpd: 192.168.1.3:54135: PASS (hidden): symbol lookup error: /usr/libexec/proftpd/mod_sql_mysql.so: undefined symbol: my_make_scrambled_password_323 ^C
(In reply to comment #8) > Hello, sorry for wait, I install this package but it does not work. If I > connect to FTP with use mysql, have this error in ssh > > [root@server tmp]# rpm -U > http://visionscms.com/proftpd-1.3.4-0.11.rc2.fc15.i686.rpm > http://visionscms.com/proftpd-mysql-1.3.4-0.11.rc2.fc15.i686.rpm > [root@server tmp]# mv /etc/proftpd.conf.rpmsave /etc/proftpd.conf > mv: переписать «/etc/proftpd.conf»? y > [root@server tmp]# service proftpd restart > Restarting proftpd (via systemctl): [ OK ] > [root@server tmp]# > Message from syslogd@server at Jul 13 21:22:49 ... > oftpd: 192.168.1.3:54135: PASS (hidden): symbol lookup error: > /usr/libexec/proftpd/mod_sql_mysql.so: undefined symbol: > my_make_scrambled_password_323 This is because the mysql libraries are only exporting my_make_scrambled_password and not my_make_scrambled_password_323 (Bug #742222). I'm going to include the last patch in the new 1.3.4rc3 build, which should work with a fixed mysql.
proftpd-1.3.4-0.14.rc3.fc16 has been submitted as an update for Fedora 16. https://admin.fedoraproject.org/updates/proftpd-1.3.4-0.14.rc3.fc16
proftpd-1.3.4-0.14.rc3.fc15 has been submitted as an update for Fedora 15. https://admin.fedoraproject.org/updates/proftpd-1.3.4-0.14.rc3.fc15
[root@server server]# yum --enablerepo=updates-testing update proftpd .... ================================================================================ Обновить 2 пакет(а,ов) Объем загрузки: 3.4 M Продолжить? [y/N]: y .... Обновлено: proftpd.i686 0:1.3.4-0.14.rc3.fc15 Зависимости обновлены: proftpd-mysql.i686 0:1.3.4-0.14.rc3.fc15 Готово! [root@server server]# service proftpd restart Restarting proftpd (via systemctl): [ OK ] // Try Mysql AUTH [root@server server]# Message from syslogd@server at Oct 2 15:42:07 ... oftpd: 192.168.1.3:38513: PASS (hidden): symbol lookup error: /usr/libexec/proftpd/mod_sql_mysql.so: undefined symbol: my_make_scrambled_password_323 ^C Bug still not resolved. How can I help you?
(In reply to comment #12) > [root@server server]# service proftpd restart > Restarting proftpd (via systemctl): [ OK ] > // Try Mysql AUTH > [root@server server]# > Message from syslogd@server at Oct 2 15:42:07 ... > oftpd: 192.168.1.3:38513: PASS (hidden): symbol lookup error: > /usr/libexec/proftpd/mod_sql_mysql.so: undefined symbol: > my_make_scrambled_password_323 > ^C > > > > Bug still not resolved. How can I help you? We need a fix for mysql Bug #742222 as well before this will work.
I've submitted a new update (proftpd-1.3.4-0.15.rc3.fc15) with a change from upstream that removes support for stored passwords from prior to MySQL 4.1 (as generated using the make_scrambled_password_323 function) if the MySQL library doesn't export it, which is now the case in Fedora. This will fix the problem from Comment 8 and Comment 12 at the expense of not working with very old stored passwords.
proftpd-1.3.4-0.15.rc3.fc16 has been pushed to the Fedora 16 stable repository. If problems still persist, please make note of it in this bug report.
proftpd-1.3.4-0.15.rc3.fc15 has been pushed to the Fedora 15 stable repository. If problems still persist, please make note of it in this bug report.
Thanks all work good in new mysql hashes :)))