- priority: 5 --> 1
Dear developer,
I and another individual that I found in the forums
are having issues with using pam_mysql.so on SSHd.
Basically if you connect, the system throws back:
> This account is currently not available.
> Connection to x.x.x.x closed.
Putty will connect, sit there for a few seconds and
then just terminate. WinSCP will connect and report
this error:
> Received too large (1416128883 B) SFTP packet.
> Max supported packet size is 102400 B.
> The error is typically caused by message printed
> from startup script (like .profile). The message
> may start with "This".
All winbind account or local accounts connect fine.
The home directories have proper permissions and
everything seems to be correct.
Below I have included my pam.d/sshd config file. Any
help that you can provide is greatly appreciated. No
one on the web seems to have an answer, just postings
of very similar questions. So I really hope you can
help. Thanks in advance for your help!
-Cheers, Peter.
[SNIP]
auth sufficient pam_mysql.so user=vsftpd_pam
passwd=xxx db=pam_auth table=foo usercolumn=User
passwdcolumn=Passwd crypt=0 verbose=1
[where=Disabled=0 AND UNIX_TIMESTAMP(Expires)
>UNIX_TIMESTAMP(CURDATE())]
auth sufficient pam_winbind.so
auth sufficient pam_stack.so service=system-
auth
auth required pam_shells.so
auth required pam_deny.so
#-------------------------------
password sufficient pam_mysql.so user=vsftpd_pam
passwd=xxx db=pam_auth table=foo usercolumn=User
passwdcolumn=Passwd crypt=0 verbose=1
password sufficient pam_winbind.so
password sufficient pam_stack.so service=system-
auth
password required pam_deny.so
#-------------------------------
account sufficient pam_mysql.so user=vsftpd_pam
passwd=xxx db=pam_auth table=foo usercolumn=User
passwdcolumn=Passwd crypt=0 verbose=1
account sufficient pam_winbind.so
account sufficient pam_stack.so service=system-
auth
#-------------------------------
session sufficient pam_mysql.so user=vsftpd_pam
passwd=xxx db=pam_auth table=foo usercolumn=User
passwdcolumn=Passwd crypt=0 verbose=1
session sufficient pam_winbind.so
session sufficient pam_stack.so service=system-
auth
session required pam_limits.so
session optional pam_console.so
[/SNIP]