exit 1
fi
-INITPW=$(sudo -u hcoop psql hcoop_hcoop -tc "select unix_passwd from MemberApp where name = '${USERNM}';")
+INITPW=$(sudo -u hcoop psql -h postgres -p 5433 hcoop_portal3 -tc "select unix_passwd from MemberApp where name = '${USERNM}' order by id desc limit 1;")
#
# Create user
#
-/afs/hcoop.net/common/etc/scripts/create-user $USERNM || \
+/afs/hcoop.net/common/etc/scripts/create-user-new $USERNM || \
( echo "create-user $USERNM failed" && exit 2 )
#
else
echo Setting password from database
actual_user=`whoami`
- sudo sh -c "echo $INITPW | tee -| /afs/hcoop.net/common/etc/scripts/change-user-password $USERNM" || \
+ sudo sh -c "printf '%s\n%s\n' $INITPW $INITPW | /afs/hcoop.net/common/etc/scripts/change-user-password $USERNM" || \
( echo "echo XXX | tee - | change-user-password $USERNM failed" && exit 5 )
fi