Locked out of kloxo

gistfile1.sh

# If you've been locked out of kloxo and you've tried everything google suggested for you
# then most likely it's a database problem. Please try the following at your own will
# and hit cmd+y (or ctrl+w) if you don't know the impact this will have on your system.
# Disclaimer: if you break your server it won't be my fault. you've been warned
#
# The "recommended" way to login to your kloxo installation is the following:
# as described in http://wiki.lxcenter.org/Change+Password+via+SSH
[root@server]$ sh /script/resetpassword master {newpassword}

# if this doesn't work try the following:

# copy the mysql kloxo user password from your kloxo.pass file
[root@server]$ cat /usr/local/lxlabs/kloxo/etc/conf/kloxo.pass

# repair your database tables
[root@server]$ mysqlcheck -A --auto-repair -ukloxo -p{PASSWORD AS IN KLOXO.PASS FILE}

# if you try to login and you get a "This login has been Disabled" error try the following:
mysql> use kloxo;
mysql> update client set cpstatus='on' where nname='admin';