desktop-packages team mailing list archive

Thread
Date
[Bug 1419131] [NEW] Can't unlock screen saver with pam_mysql

To: desktop-packages@xxxxxxxxxxxxxxxxxxx
From: Mitch Claborn <1419131@xxxxxxxxxxxxxxxxxx>
Date: Fri, 06 Feb 2015 19:57:20 -0000
Reply-to: Bug 1419131 <1419131@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

Description:	Ubuntu 14.04.1 LTS
Release:	14.04
unity:
  Installed: 7.2.4+14.04.20141217-0ubuntu1

We are using pam_mysql to login to the workstation.  Excerpt from
/etc/pam.d/lightdm.conf:

auth     required      pam_mysql.so verbose=1 user=xxxxx passwd=xxxxx
db=xxxx host=xxx table=operator usercolumn=username
passwdcolumn=password crypt=0 where=operator.enabled=1

There is a similar line in /etc/pam.d/gnome-screensaver

Login to the workstation works fine.  Up until this week, unlocking the
screen saver worked fine also.  Now it is not working to unlock from the
screen saver.  I added the verbose=1 option and can see the logging when
user logs in, but no logging shows up when the user attempts to unlock
the screen saver, leading me to believe it is not calling pam_mysql.

I tried a similar config in /etc/pam.d/unity but that did not help.

This are the entries from /var/log/apt/history.log from the day it stopped working:
Start-Date: 2015-02-05  05:12:23
Install: 
	linux-image-extra-3.13.0-45-generic:amd64 (3.13.0-45.74, automatic), 
	linux-image-3.13.0-45-generic:amd64 (3.13.0-45.74, automatic), 
	linux-headers-3.13.0-45-generic:amd64 (3.13.0-45.74, automatic), 
	linux-headers-3.13.0-45:amd64 (3.13.0-45.74, automatic)
Upgrade: 
	libclamav6:amd64 (0.98.5+addedllvm-0ubuntu0.14.04.1, 0.98.6+dfsg-0ubuntu0.14.04.1), 
	linux-headers-generic:amd64 (3.13.0.44.51, 3.13.0.45.52), 
	unity:amd64 (7.2.3+14.04.20140826-0ubuntu1, 7.2.4+14.04.20141217-0ubuntu1), 
	indicator-session:amd64 (12.10.5+14.04.20140410-0ubuntu1, 12.10.5+14.04.20140925-0ubuntu1), 
	libunity-core-6.0-9:amd64 (7.2.3+14.04.20140826-0ubuntu1, 7.2.4+14.04.20141217-0ubuntu1), 
	tzdata-java:amd64 (2014i-0ubuntu0.14.04, 2015a-0ubuntu0.14.04), 
	file:amd64 (5.14-2ubuntu3.2, 5.14-2ubuntu3.3), 
	libmagic1:amd64 (5.14-2ubuntu3.2, 5.14-2ubuntu3.3), 
	unity-services:amd64 (7.2.3+14.04.20140826-0ubuntu1, 7.2.4+14.04.20141217-0ubuntu1), 
	clamav-freshclam:amd64 (0.98.5+addedllvm-0ubuntu0.14.04.1, 0.98.6+dfsg-0ubuntu0.14.04.1), 
	clamav-base:amd64 (0.98.5+addedllvm-0ubuntu0.14.04.1, 0.98.6+dfsg-0ubuntu0.14.04.1), 
	unzip:amd64 (6.0-9ubuntu1.1, 6.0-9ubuntu1.2), 
	clamav:amd64 (0.98.5+addedllvm-0ubuntu0.14.04.1, 0.98.6+dfsg-0ubuntu0.14.04.1), 
	tzdata:amd64 (2014i-0ubuntu0.14.04, 2015a-0ubuntu0.14.04), 
	linux-libc-dev:amd64 (3.13.0-44.73, 3.13.0-45.74), 
	linux-image-generic:amd64 (3.13.0.44.51, 3.13.0.45.52), 
	linux-generic:amd64 (3.13.0.44.51, 3.13.0.45.52)
End-Date: 2015-02-05  05:13:35

ProblemType: Bug
DistroRelease: Ubuntu 14.04
Package: unity 7.2.4+14.04.20141217-0ubuntu1
ProcVersionSignature: Ubuntu 3.13.0-45.74-generic 3.13.11-ckt13
Uname: Linux 3.13.0-45-generic x86_64
ApportVersion: 2.14.1-0ubuntu3.6
Architecture: amd64
CompizPlugins: No value set for `/apps/compiz-1/general/screen0/options/active_plugins'
Date: Fri Feb  6 13:47:10 2015
InstallationDate: Installed on 2015-01-22 (15 days ago)
InstallationMedia: Ubuntu 14.04.1 LTS "Trusty Tahr" - Release amd64+mac (20140722.2)
ProcEnviron:
 TERM=xterm
 PATH=(custom, no user)
 XDG_RUNTIME_DIR=<set>
 LANG=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: unity
UpgradeStatus: No upgrade log present (probably fresh install)

** Affects: unity (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: amd64 apport-bug trusty

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to unity in Ubuntu.
Matching subscriptions: dp-unity
https://bugs.launchpad.net/bugs/1419131

Title:
  Can't unlock screen saver with pam_mysql

Status in unity package in Ubuntu:
  New

Bug description:
  Description:	Ubuntu 14.04.1 LTS
  Release:	14.04
  unity:
    Installed: 7.2.4+14.04.20141217-0ubuntu1

  We are using pam_mysql to login to the workstation.  Excerpt from
  /etc/pam.d/lightdm.conf:

  auth     required      pam_mysql.so verbose=1 user=xxxxx passwd=xxxxx
  db=xxxx host=xxx table=operator usercolumn=username
  passwdcolumn=password crypt=0 where=operator.enabled=1

  There is a similar line in /etc/pam.d/gnome-screensaver

  Login to the workstation works fine.  Up until this week, unlocking
  the screen saver worked fine also.  Now it is not working to unlock
  from the screen saver.  I added the verbose=1 option and can see the
  logging when user logs in, but no logging shows up when the user
  attempts to unlock the screen saver, leading me to believe it is not
  calling pam_mysql.

  I tried a similar config in /etc/pam.d/unity but that did not help.

  This are the entries from /var/log/apt/history.log from the day it stopped working:
  Start-Date: 2015-02-05  05:12:23
  Install: 
  	linux-image-extra-3.13.0-45-generic:amd64 (3.13.0-45.74, automatic), 
  	linux-image-3.13.0-45-generic:amd64 (3.13.0-45.74, automatic), 
  	linux-headers-3.13.0-45-generic:amd64 (3.13.0-45.74, automatic), 
  	linux-headers-3.13.0-45:amd64 (3.13.0-45.74, automatic)
  Upgrade: 
  	libclamav6:amd64 (0.98.5+addedllvm-0ubuntu0.14.04.1, 0.98.6+dfsg-0ubuntu0.14.04.1), 
  	linux-headers-generic:amd64 (3.13.0.44.51, 3.13.0.45.52), 
  	unity:amd64 (7.2.3+14.04.20140826-0ubuntu1, 7.2.4+14.04.20141217-0ubuntu1), 
  	indicator-session:amd64 (12.10.5+14.04.20140410-0ubuntu1, 12.10.5+14.04.20140925-0ubuntu1), 
  	libunity-core-6.0-9:amd64 (7.2.3+14.04.20140826-0ubuntu1, 7.2.4+14.04.20141217-0ubuntu1), 
  	tzdata-java:amd64 (2014i-0ubuntu0.14.04, 2015a-0ubuntu0.14.04), 
  	file:amd64 (5.14-2ubuntu3.2, 5.14-2ubuntu3.3), 
  	libmagic1:amd64 (5.14-2ubuntu3.2, 5.14-2ubuntu3.3), 
  	unity-services:amd64 (7.2.3+14.04.20140826-0ubuntu1, 7.2.4+14.04.20141217-0ubuntu1), 
  	clamav-freshclam:amd64 (0.98.5+addedllvm-0ubuntu0.14.04.1, 0.98.6+dfsg-0ubuntu0.14.04.1), 
  	clamav-base:amd64 (0.98.5+addedllvm-0ubuntu0.14.04.1, 0.98.6+dfsg-0ubuntu0.14.04.1), 
  	unzip:amd64 (6.0-9ubuntu1.1, 6.0-9ubuntu1.2), 
  	clamav:amd64 (0.98.5+addedllvm-0ubuntu0.14.04.1, 0.98.6+dfsg-0ubuntu0.14.04.1), 
  	tzdata:amd64 (2014i-0ubuntu0.14.04, 2015a-0ubuntu0.14.04), 
  	linux-libc-dev:amd64 (3.13.0-44.73, 3.13.0-45.74), 
  	linux-image-generic:amd64 (3.13.0.44.51, 3.13.0.45.52), 
  	linux-generic:amd64 (3.13.0.44.51, 3.13.0.45.52)
  End-Date: 2015-02-05  05:13:35

  ProblemType: Bug
  DistroRelease: Ubuntu 14.04
  Package: unity 7.2.4+14.04.20141217-0ubuntu1
  ProcVersionSignature: Ubuntu 3.13.0-45.74-generic 3.13.11-ckt13
  Uname: Linux 3.13.0-45-generic x86_64
  ApportVersion: 2.14.1-0ubuntu3.6
  Architecture: amd64
  CompizPlugins: No value set for `/apps/compiz-1/general/screen0/options/active_plugins'
  Date: Fri Feb  6 13:47:10 2015
  InstallationDate: Installed on 2015-01-22 (15 days ago)
  InstallationMedia: Ubuntu 14.04.1 LTS "Trusty Tahr" - Release amd64+mac (20140722.2)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, no user)
   XDG_RUNTIME_DIR=<set>
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: unity
  UpgradeStatus: No upgrade log present (probably fresh install)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/unity/+bug/1419131/+subscriptions
Follow ups

[Bug 1419131] [NEW] Can't unlock screen saver with pam_mysql
From: Mitch Claborn, 2015-02-06
References

[Bug 1419131] [NEW] Can't unlock screen saver with pam_mysql
From: Mitch Claborn, 2015-02-06