Problem loggin with pam_mysql

Fernando Arconada Oróstegui fernando.arconada at saicar.es
Mon Jan 17 11:16:45 EST 2005


why pam_mysql dont log the host ip? my /var/log/auth says: 
 
---------------------------------------------------------------------------------------

Jan 17 17:06:43 linares saslauthd[22506]: returning 0. 
Jan 17 17:06:43 linares saslauthd[22506]: pam_mysql: acct_mgmt called
but not implemented. Dont panic though :) 
Jan 17 17:06:43 linares saslauthd[22505]: pam_sm_authenticate called. 
Jan 17 17:06:43 linares saslauthd[22505]: dbuser changed. 
Jan 17 17:06:43 linares saslauthd[22505]: dbpasswd changed. 
Jan 17 17:06:43 linares saslauthd[22505]: host changed. 
Jan 17 17:06:43 linares saslauthd[22505]: database changed. 
Jan 17 17:06:43 linares saslauthd[22505]: table changed. 
Jan 17 17:06:43 linares saslauthd[22505]: usercolumn changed. 
Jan 17 17:06:43 linares saslauthd[22505]: passwdcolumn changed. 
Jan 17 17:06:43 linares saslauthd[22505]: crypt changed. 
Jan 17 17:06:43 linares saslauthd[22505]: logtable changed. 
Jan 17 17:06:43 linares saslauthd[22505]: logmsgcolumn changed. 
Jan 17 17:06:43 linares saslauthd[22505]: logusercolumn changed. 
Jan 17 17:06:43 linares saslauthd[22505]: loghostcolumn changed. 
Jan 17 17:06:43 linares saslauthd[22505]: logpidcolumn changed. 
Jan 17 17:06:43 linares saslauthd[22505]: logtimecolumn changed. 
Jan 17 17:06:43 linares saslauthd[22505]: db_connect  called. 
Jan 17 17:06:43 linares saslauthd[22505]: returning 0 . 
Jan 17 17:06:43 linares saslauthd[22505]: db_checkpasswd called. 
Jan 17 17:06:43 linares saslauthd[22505]: pam_mysql: where clause = 
Jan 17 17:06:43 linares saslauthd[22505]: SELECT password FROM
accountuser WHERE username='marenill' 
Jan 17 17:06:43 linares saslauthd[22505]: sqlLog called. 
Jan 17 17:06:43 linares saslauthd[22505]: insert into log (msg, user,
host, pid, time) values('AUTH SUCCESSFUL', 'marenill', '', '22505',
NOW()) 
Jan 17 17:06:43 linares saslauthd[22505]: Returning 0 
----------------------------------------------------------------------------------------

this is one of my pam.d files 
 
account required pam_mysql.so user=myuser passwd=mypass host=localhost
db=mail table=accountuser usercolumn=username passwdcolumn=password
crypt=1 logtable=log logmsgcolumn=msg logusercolumn=user
loghostcolumn=host logpidcolumn=pid logtimecolumn=time 
 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://lists.andrew.cmu.edu/mailman/private/info-cyrus/attachments/20050117/9a4f9697/attachment.html


More information about the Info-cyrus mailing list