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