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)
root@debian:~# dpkg --status libpam-mysql
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: 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: 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?