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
