[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

About a bug in libpam-mysql package on squeeze


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:

  `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`)

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', '', '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,


Reply to: