reset Administrator astguiclient rc3

[xedlinux]

hi after changing my Administrator password. i cant log in it anymore.

[mflorell]

your VICIDIAL administrator password, or your Linux password?

[xedlinux]

yes. Vicidial Administrator password. please help me with this one. i have a live operation after 3 hours. thanks.

[xedlinux]

i look at the asterisk | 1 | admin | admin_etc | Admin | 9 | ADMIN | NULL | NULL | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | NULL | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | DISABLED | NOT_ACTIVE |
+---------+-------+-----------+-----------+------------+------------+-----------

results from: select * from vicidial_users

i used to log in as: username: admin password: admin_etc but still the same i cant log in into Administrator in Vicidial Portal.

[mflorell]

change it in the database to not use the underscore. No special characters can be used for usernames and passwords.

[xedlinux]

thanks a lot matt. i got it.

[xedlinux]

hi matt i can log in by inserting new user into vicidial_users but unfortunately i cant change any users and change or add any campaigns because it says "You do not have permission to view this page"

[williamconley]

check the syntax but;
# mysql -p

(enter your root mysql password, you may have to add -uroot above)
>use asterisk;
>update vicidial_users set pass=2021 where user=2020;

I would recommend replacing "2021" with the password you want and "2020" with the user name to change. Probably work better.

[williamconley]

Do a little research on "mysqldump". Very handy utlility. Do a daily database dump (and copy off the box). Then when you have a problem with your data ... you can easily recover from something like this, or something worse. You can even do it selectively (like only put back the user table!).