Re: Re: About a bug in libpam-mysql package on squeeze

[Onur R. Bingol]

Hello Camaleón,

verbose variable is set to 1 in this case. If not, I cannot retrieve 
any information regarding to this problem.


You are right about the date of the update, but I will just give a try 
by submitting this problem as a bug.


Thank you your answer :)

Regards,

--
Onur R. Bingol


--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org

Archive: http://lists.debian.org/4f3c2de7.8090...@gmail.com

About a bug in libpam-mysql package on squeeze

[Onur R. Bingol]

Hello,

I am a total noob on bug reporting and I am having problems with 
libpam-mysql package on squeeze.


I am using these packages:

root@debian:~# lsb_release -a
...
Description:Debian GNU/Linux 6.0.4 (squeeze)
Release:6.0.4
Codename:   squeeze

root@debian:~# dpkg --status libpam-mysql
...
Version: 0.7~RC1-4+b1
...

I have created a logging table with the following credentals:

CREATE TABLE IF NOT EXISTS `pam_logs` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT,
  `message` text NOT NULL,
  `username` text NOT NULL,
  `hostname` text NOT NULL,
  `time` text NOT NULL,
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

and my pam-mysql.conf file is

...
log.enabled = 1
log.table   = pam_logs
log.message_column  = pam_logs.message
#log.pid_column = pid
log.user_column = pam_logs.username
log.host_column = pam_logs.hostname
#log.rhost_column   = (logrhostcolumn) *2
log.time_column = pam_logs.time

Loading pam_mysql.so with config_file=/etc/pam-mysql.conf as written 
on the README file.


As you see log.pid_column is disabled. However, I am getting these logs 
in my /var/log/auth.log


Feb  7 23:15:23 debian sshd[3391]: pam_mysql - INSERT INTO pam_logs 
(pam_logs.message, pam_logs.username, pam_logs.hostname, , 
pam_logs.time) VALUES ('AUTHENTICATION SUCCESS (FIRST_PASS)', 'deneme', 
'127.0.1.1', '3391', NOW())
Feb  7 23:15:23 debian sshd[3391]: pam_mysql - MySQL error (You have an 
error in your SQL syntax; check the manual that corresponds to your 
MySQL server version for the right syntax to use near ' pam_logs.time) 
VALUES ('AUTHENTICATION SUCCESS (FIRST_PASS)', 'deneme', '127.0.' at line 1)



Although pid column is disabled in pam-mysql.conf file, it makes a query 
including the pid value or somehow it needs it.


Does this information is enough for submitting a bug report on 
libpam-mysql package?


Best regards,

Onur