samba pam authentication postgres

[sureshprasanna]

hai to everybody

i tried to configure the smaba with pam authentication with postgres
database
my configuration is
/etc/samba/smb.conf

[global]
log file = /var/log/samba/%m.log
load printers = yes
smb passwd file = /etc/samba/smbpasswd
security = user
passwd chat = *New*password* %n\n *Retype*new*password* %n\n
*passwd:*all*authentication$
obey pam restrictions = yes
socket options = TCP_NODELAY SO_RCVBUF=8192 SO_SNDBUF=8192
encrypt passwords = no
update encrypted = No
allow trusted domains = Yes
min password length = 6
null passwords = No
public = yes
passwd program = /usr/bin/passwd %u
dns proxy = no
netbios name = bpmac4
writeable = yes
server string = 10.0.0.195
printing = cups
unix password sync = yes
workgroup = bharatplanetnew
os level = 45
printcap name = /etc/printcap
security = user
max log size = 0

and some shares .....

/etc/pam.d/samba
auth required /lib/security/pam_pgsql.so
account required /lib/security/pam_pgsql.so
password required /lib/security/pam_pgsql.so

and /etc/pam_psql.conf

database = samba_pam
user = postgres
table = users
user_column = login
pwd_column = password
debug
these all my configuration details
the username and password are in correct procedure in database.
when i tried
smbclient \\\\localhost\username

i got the following error
session setup failed: NT_STATUS_LOGON_FAILURE

please help

regards
prasanna