Bug 718327 - Mysql AUTH no work...
Summary: Mysql AUTH no work...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Fedora
Classification: Fedora
Component: proftpd
Version: 15
Hardware: i386
OS: Linux
unspecified
medium
Target Milestone: ---
Assignee: Matthias Saou
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On: 742222
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-07-01 19:45 UTC by dobs
Modified: 2011-10-19 22:58 UTC (History)
2 users (show)

Fixed In Version: proftpd-1.3.4-0.15.rc3.fc15
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-10-19 21:07:26 UTC
Type: ---
Embargoed:


Attachments (Terms of Use)
my conf (11.72 KB, application/octet-stream)
2011-07-01 19:50 UTC, dobs
no flags Details


Links
System ID Private Priority Status Summary Last Updated
ProFTPD 3669 0 None None None Never

Description dobs 2011-07-01 19:45:29 UTC
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

Comment 1 dobs 2011-07-01 19:50:33 UTC
Created attachment 510928 [details]
my conf

Comment 2 Paul Howarth 2011-07-01 20:54:37 UTC
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

Comment 3 dobs 2011-07-01 21:37:16 UTC
How to download it?

Comment 4 Paul Howarth 2011-07-01 21:54:39 UTC
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.

Comment 5 dobs 2011-07-01 22:38:41 UTC
Thanks, error is gone, but mysql auth still not working (I will look for why...)

Comment 6 Paul Howarth 2011-07-07 20:47:48 UTC
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.

Comment 7 Paul Howarth 2011-07-13 13:29:44 UTC
(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?

Comment 8 dobs 2011-07-13 18:16:50 UTC
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

Comment 9 Paul Howarth 2011-09-29 12:40:05 UTC
(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.

Comment 10 Fedora Update System 2011-09-29 17:25:48 UTC
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

Comment 11 Fedora Update System 2011-09-29 17:25:57 UTC
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

Comment 12 dobs 2011-10-02 12:32:58 UTC
[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?

Comment 13 Paul Howarth 2011-10-02 13:40:59 UTC
(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.

Comment 14 Paul Howarth 2011-10-06 16:49:03 UTC
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.

Comment 15 Fedora Update System 2011-10-16 00:59:59 UTC
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.

Comment 16 Fedora Update System 2011-10-18 22:17:17 UTC
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.

Comment 17 dobs 2011-10-19 21:07:26 UTC
Thanks all work good in new mysql hashes :)))


Note You need to log in before you can comment on or make changes to this bug.