Activity log for bug #1574900

Date Who What changed Old value New value Message
2016-04-25 23:51:25 OwN bug added bug
2016-05-16 05:25:54 Logan Rosen bug watch added https://bugzilla.redhat.com/show_bug.cgi?id=709534
2016-05-16 05:25:54 Logan Rosen bug task added pam-mysql (Fedora)
2016-05-16 05:26:30 Logan Rosen bug added subscriber Logan Rosen
2016-05-17 14:08:03 Launchpad Janitor pam-mysql (Ubuntu): status New Confirmed
2016-05-18 15:01:00 Damiano Migliorini bug added subscriber Damiano Migliorini
2016-05-23 02:15:24 Jared Fernandez bug added subscriber Jared Fernandez
2016-05-29 09:23:44 Kaijia Feng information type Public Public Security
2016-05-29 09:23:48 Kaijia Feng information type Public Security Public
2016-05-29 09:24:05 Kaijia Feng bug added subscriber Kaijia Feng
2016-05-29 10:01:45 Kaijia Feng bug watch added http://bugs.mysql.com/bug.php?id=80974
2016-05-29 12:23:59 Kaijia Feng attachment added libpam-mysql.patch https://bugs.launchpad.net/ubuntu/+source/pam-mysql/+bug/1574900/+attachment/4672241/+files/libpam-mysql.patch
2016-05-29 12:29:04 Ubuntu Foundations Team Bug Bot tags patch
2016-05-29 12:29:16 Ubuntu Foundations Team Bug Bot bug added subscriber Ubuntu Review Team
2016-07-02 17:03:29 Angel Granados Gonzalez bug added subscriber Angel Granados Gonzalez
2016-08-11 15:21:02 Dirk Fries bug added subscriber Dirk Fries
2016-08-28 09:46:05 Tomas 'tt' Krag bug added subscriber Tomas 'tt' Krag
2016-10-29 05:19:49 David.Guo bug added subscriber David.Guo
2016-11-27 20:47:14 Andras Herczig bug added subscriber Andras Herczig
2017-02-28 08:47:42 Kaijia Feng pam-mysql (Ubuntu): status Confirmed Fix Committed
2017-03-14 16:42:15 Nish Aravamudan nominated for series Ubuntu Xenial
2017-03-14 16:42:15 Nish Aravamudan bug task added pam-mysql (Ubuntu Xenial)
2017-03-14 16:42:33 Nish Aravamudan nominated for series Ubuntu Yakkety
2017-03-14 16:42:33 Nish Aravamudan bug task added pam-mysql (Ubuntu Yakkety)
2017-03-14 17:14:03 Nish Aravamudan pam-mysql (Ubuntu Xenial): assignee Nish Aravamudan (nacc)
2017-03-14 17:14:06 Nish Aravamudan pam-mysql (Ubuntu Yakkety): assignee Nish Aravamudan (nacc)
2017-03-14 17:14:07 Nish Aravamudan pam-mysql (Ubuntu): status Fix Committed Fix Released
2017-03-14 17:14:13 Nish Aravamudan pam-mysql (Ubuntu Xenial): status New In Progress
2017-03-14 17:14:15 Nish Aravamudan pam-mysql (Ubuntu Yakkety): status New In Progress
2017-03-14 19:15:28 Nish Aravamudan description In Ubuntu 16.04, the libpam-mysql package does not work. It crashes with the below error: PAM unable to dlopen(pam_mysql.so): /lib/security/pam_mysql.so: undefined symbol: make_scrambled_password I fixed this issue by download the source for the package and applying the patches that come from this source RPM: http://dinofly.com/files/linux/pam_mysql-0.7-0.20.rc1.fc23.src.rpm I then created unofficial packages after applying the patch. They can be downloaded here: http://www.dinofly.com/files/linux/libpam-mysql_0.7~RC1-4ubuntu3_amd64.deb http://www.dinofly.com/files/linux/libpam-mysql_0.7~RC1-4ubuntu3_i386.deb libpam-mysql now works again on Ubuntu 16.04 x86 and x64. Here is the initial RedHat bug report: https://bugzilla.redhat.com/show_bug.cgi?id=709534 [Impact] * libpam-mysql is unable to be used because of an upstream symbol change in libmysqlclient. * Upstream libpam-mysql has fixed this by updating the source to use the now-exported API. [Test Case] [Regression Potential] * There is currently no fix or workaround, as the library is basically broken as installed from Ubuntu. * I believe the regression potential to be very low because the current code does not work. --- In Ubuntu 16.04, the libpam-mysql package does not work. It crashes with the below error: PAM unable to dlopen(pam_mysql.so): /lib/security/pam_mysql.so: undefined symbol: make_scrambled_password I fixed this issue by download the source for the package and applying the patches that come from this source RPM: http://dinofly.com/files/linux/pam_mysql-0.7-0.20.rc1.fc23.src.rpm I then created unofficial packages after applying the patch. They can be downloaded here: http://www.dinofly.com/files/linux/libpam-mysql_0.7~RC1-4ubuntu3_amd64.deb http://www.dinofly.com/files/linux/libpam-mysql_0.7~RC1-4ubuntu3_i386.deb libpam-mysql now works again on Ubuntu 16.04 x86 and x64. Here is the initial RedHat bug report: https://bugzilla.redhat.com/show_bug.cgi?id=709534
2017-03-14 19:17:26 Dennie de Lange bug added subscriber Dennie de Lange
2017-03-14 19:42:43 Dennie de Lange description [Impact] * libpam-mysql is unable to be used because of an upstream symbol change in libmysqlclient. * Upstream libpam-mysql has fixed this by updating the source to use the now-exported API. [Test Case] [Regression Potential] * There is currently no fix or workaround, as the library is basically broken as installed from Ubuntu. * I believe the regression potential to be very low because the current code does not work. --- In Ubuntu 16.04, the libpam-mysql package does not work. It crashes with the below error: PAM unable to dlopen(pam_mysql.so): /lib/security/pam_mysql.so: undefined symbol: make_scrambled_password I fixed this issue by download the source for the package and applying the patches that come from this source RPM: http://dinofly.com/files/linux/pam_mysql-0.7-0.20.rc1.fc23.src.rpm I then created unofficial packages after applying the patch. They can be downloaded here: http://www.dinofly.com/files/linux/libpam-mysql_0.7~RC1-4ubuntu3_amd64.deb http://www.dinofly.com/files/linux/libpam-mysql_0.7~RC1-4ubuntu3_i386.deb libpam-mysql now works again on Ubuntu 16.04 x86 and x64. Here is the initial RedHat bug report: https://bugzilla.redhat.com/show_bug.cgi?id=709534 [Impact]  * libpam-mysql is unable to be used because of an upstream symbol change in libmysqlclient.  * Upstream libpam-mysql has fixed this by updating the source to use the now-exported API. [Test Case] Steps to reproduce (with vsftpd): Installation requirements: mysqlserver 5.7.x, libpam-mysql, vsftpd create vsftpd user: useradd --home /home/vsftpd --gid nogroup -m --shell /bin/false vsftpd create mysql database and user: == // Start SQL CREATE DATABASE vsftpd; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON vsftpd.* TO 'vsftpd'@'localhost' IDENTIFIED BY 'ftpdpass'; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON vsftpd.* TO 'vsftpd'@'localhost.localdomain' IDENTIFIED BY 'ftpdpass'; FLUSH PRIVILEGES; USE vsftpd; CREATE TABLE `accounts` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `username` VARCHAR( 30 ) NOT NULL , `pass` VARCHAR( 50 ) NOT NULL , UNIQUE ( `username` )); insert into accounts(username,pass) values('user',password('password')); ==// End SQL Configure PAM: insert into /etc/pam.d/vsftpd: auth required pam_mysql.so verbose=1 user=vsftpd host=localhost db=vsftpd table=accounts usercolumn=username passwdcolumn=pass crypt=3 passwd=ftpdpass account required pam_mysql.so verbose=1 user=vsftpd host=localhost db=vsftpd table=accounts usercolumn=username passwdcolumn=pass crypt=3 passwd=ftpdpass Configure vsftpd (/etc/vsftpd.conf) : listen=YES anonymous_enable=NO local_enable=YES write_enable=YES local_umask=022 dirmessage_enable=YES xferlog_enable=YES connect_from_port_20=YES nopriv_user=vsftpd chroot_local_user=YES secure_chroot_dir=/var/run/vsftpd pam_service_name=vsftpd guest_enable=YES guest_username=vsftpd local_root=/home/vsftpd/$USER user_sub_token=$USER virtual_use_local_privs=YES restart vsftpd: /etc/init.d/vsftpd restart check /var/log/auth.log [Regression Potential]  * There is currently no fix or workaround, as the library is basically broken as installed from Ubuntu.  * I believe the regression potential to be very low because the current code does not work. --- In Ubuntu 16.04, the libpam-mysql package does not work. It crashes with the below error: PAM unable to dlopen(pam_mysql.so): /lib/security/pam_mysql.so: undefined symbol: make_scrambled_password I fixed this issue by download the source for the package and applying the patches that come from this source RPM: http://dinofly.com/files/linux/pam_mysql-0.7-0.20.rc1.fc23.src.rpm I then created unofficial packages after applying the patch. They can be downloaded here: http://www.dinofly.com/files/linux/libpam-mysql_0.7~RC1-4ubuntu3_amd64.deb http://www.dinofly.com/files/linux/libpam-mysql_0.7~RC1-4ubuntu3_i386.deb libpam-mysql now works again on Ubuntu 16.04 x86 and x64. Here is the initial RedHat bug report: https://bugzilla.redhat.com/show_bug.cgi?id=709534
2017-03-14 21:51:51 Nish Aravamudan summary libpam-mysql undefined symbol: make_scrambled_password - Needs Patches Applied by RedHat / Fedora Community to Fix Ubuntu 16.04 libpam-mysql undefined symbol: make_scrambled_password
2017-03-16 17:13:57 Brian Murray pam-mysql (Ubuntu Xenial): status In Progress Fix Committed
2017-03-16 17:14:02 Brian Murray bug added subscriber Ubuntu Stable Release Updates Team
2017-03-16 17:14:04 Brian Murray bug added subscriber SRU Verification
2017-03-16 17:14:11 Brian Murray tags patch patch verification-needed
2017-03-16 17:18:53 Brian Murray pam-mysql (Ubuntu Yakkety): status In Progress Fix Committed
2017-03-20 13:48:47 Christian Ehrhardt  tags patch verification-needed patch verification-done-yenial verification-needed-yakkety
2017-05-11 20:14:39 Andreas Hasenack description [Impact]  * libpam-mysql is unable to be used because of an upstream symbol change in libmysqlclient.  * Upstream libpam-mysql has fixed this by updating the source to use the now-exported API. [Test Case] Steps to reproduce (with vsftpd): Installation requirements: mysqlserver 5.7.x, libpam-mysql, vsftpd create vsftpd user: useradd --home /home/vsftpd --gid nogroup -m --shell /bin/false vsftpd create mysql database and user: == // Start SQL CREATE DATABASE vsftpd; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON vsftpd.* TO 'vsftpd'@'localhost' IDENTIFIED BY 'ftpdpass'; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON vsftpd.* TO 'vsftpd'@'localhost.localdomain' IDENTIFIED BY 'ftpdpass'; FLUSH PRIVILEGES; USE vsftpd; CREATE TABLE `accounts` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `username` VARCHAR( 30 ) NOT NULL , `pass` VARCHAR( 50 ) NOT NULL , UNIQUE ( `username` )); insert into accounts(username,pass) values('user',password('password')); ==// End SQL Configure PAM: insert into /etc/pam.d/vsftpd: auth required pam_mysql.so verbose=1 user=vsftpd host=localhost db=vsftpd table=accounts usercolumn=username passwdcolumn=pass crypt=3 passwd=ftpdpass account required pam_mysql.so verbose=1 user=vsftpd host=localhost db=vsftpd table=accounts usercolumn=username passwdcolumn=pass crypt=3 passwd=ftpdpass Configure vsftpd (/etc/vsftpd.conf) : listen=YES anonymous_enable=NO local_enable=YES write_enable=YES local_umask=022 dirmessage_enable=YES xferlog_enable=YES connect_from_port_20=YES nopriv_user=vsftpd chroot_local_user=YES secure_chroot_dir=/var/run/vsftpd pam_service_name=vsftpd guest_enable=YES guest_username=vsftpd local_root=/home/vsftpd/$USER user_sub_token=$USER virtual_use_local_privs=YES restart vsftpd: /etc/init.d/vsftpd restart check /var/log/auth.log [Regression Potential]  * There is currently no fix or workaround, as the library is basically broken as installed from Ubuntu.  * I believe the regression potential to be very low because the current code does not work. --- In Ubuntu 16.04, the libpam-mysql package does not work. It crashes with the below error: PAM unable to dlopen(pam_mysql.so): /lib/security/pam_mysql.so: undefined symbol: make_scrambled_password I fixed this issue by download the source for the package and applying the patches that come from this source RPM: http://dinofly.com/files/linux/pam_mysql-0.7-0.20.rc1.fc23.src.rpm I then created unofficial packages after applying the patch. They can be downloaded here: http://www.dinofly.com/files/linux/libpam-mysql_0.7~RC1-4ubuntu3_amd64.deb http://www.dinofly.com/files/linux/libpam-mysql_0.7~RC1-4ubuntu3_i386.deb libpam-mysql now works again on Ubuntu 16.04 x86 and x64. Here is the initial RedHat bug report: https://bugzilla.redhat.com/show_bug.cgi?id=709534 [Impact]  * libpam-mysql is unable to be used because of an upstream symbol change in libmysqlclient.  * Upstream libpam-mysql has fixed this by updating the source to use the now-exported API. [Test Case] Steps to reproduce (with vsftpd): Installation requirements: mysqlserver 5.7.x, libpam-mysql, vsftpd create vsftpd user: useradd --home /home/vsftpd --gid nogroup -m --shell /bin/false vsftpd create mysql database and user: == // Start SQL     CREATE DATABASE vsftpd;     GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON vsftpd.* TO 'vsftpd'@'localhost' IDENTIFIED BY 'ftpdpass';     GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON vsftpd.* TO 'vsftpd'@'localhost.localdomain' IDENTIFIED BY 'ftpdpass';     FLUSH PRIVILEGES;     USE vsftpd;     CREATE TABLE `accounts` (       `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,       `username` VARCHAR( 30 ) NOT NULL ,       `pass` VARCHAR( 50 ) NOT NULL ,     UNIQUE (       `username`     ));     insert into accounts(username,pass) values('user',password('password')); ==// End SQL Configure PAM: insert into /etc/pam.d/vsftpd:     auth required pam_mysql.so verbose=1 user=vsftpd host=localhost db=vsftpd table=accounts usercolumn=username passwdcolumn=pass crypt=2 passwd=ftpdpass     account required pam_mysql.so verbose=1 user=vsftpd host=localhost db=vsftpd table=accounts usercolumn=username passwdcolumn=pass crypt=2 passwd=ftpdpass Configure vsftpd (/etc/vsftpd.conf) :     listen=YES     anonymous_enable=NO     local_enable=YES     write_enable=YES     local_umask=022     dirmessage_enable=YES     xferlog_enable=YES     connect_from_port_20=YES     nopriv_user=vsftpd     chroot_local_user=YES     secure_chroot_dir=/var/run/vsftpd     pam_service_name=vsftpd     guest_enable=YES     guest_username=vsftpd     local_root=/home/vsftpd/$USER     user_sub_token=$USER     virtual_use_local_privs=YES restart vsftpd:  /etc/init.d/vsftpd restart check /var/log/auth.log [Regression Potential]  * There is currently no fix or workaround, as the library is basically broken as installed from Ubuntu.  * I believe the regression potential to be very low because the current code does not work. --- In Ubuntu 16.04, the libpam-mysql package does not work. It crashes with the below error: PAM unable to dlopen(pam_mysql.so): /lib/security/pam_mysql.so: undefined symbol: make_scrambled_password I fixed this issue by download the source for the package and applying the patches that come from this source RPM: http://dinofly.com/files/linux/pam_mysql-0.7-0.20.rc1.fc23.src.rpm I then created unofficial packages after applying the patch. They can be downloaded here: http://www.dinofly.com/files/linux/libpam-mysql_0.7~RC1-4ubuntu3_amd64.deb http://www.dinofly.com/files/linux/libpam-mysql_0.7~RC1-4ubuntu3_i386.deb libpam-mysql now works again on Ubuntu 16.04 x86 and x64. Here is the initial RedHat bug report: https://bugzilla.redhat.com/show_bug.cgi?id=709534
2017-05-16 13:38:11 Andy Whitcroft tags patch verification-done-yenial verification-needed-yakkety patch verification-failed-xenial verification-failed-yakkety
2017-05-17 18:16:38 Andreas Hasenack bug watch added https://github.com/NigelCunningham/pam-MySQL/issues/29
2017-05-28 12:06:53 johndros bug added subscriber johndros
2017-09-06 19:10:03 Andreas Hasenack bug added subscriber Andreas Hasenack
2017-09-19 18:19:14 Launchpad Janitor merge proposal linked https://code.launchpad.net/~ahasenack/ubuntu/+source/pam-mysql/+git/pam-mysql/+merge/331007
2017-10-27 23:17:47 Bug Watch Updater pam-mysql (Fedora): status Unknown Fix Released
2017-10-27 23:17:47 Bug Watch Updater pam-mysql (Fedora): importance Unknown Critical
2017-10-27 23:17:51 Bug Watch Updater bug watch added https://bugzilla.redhat.com/show_bug.cgi?id=708287
2019-09-16 08:52:43 Roland Steinbach pam-mysql (Ubuntu Yakkety): status Fix Committed Fix Released
2019-09-22 17:06:46 Andras Herczig removed subscriber Andras Herczig