Admin user locked out

[chrisk611]

Hi There
A bit embarrassing but I've disabled the admin user and cannot get back in, does anyone know how to re-enable it please?

[chrisk611]

OK I've fixed this by adding a new admin user through mysql on the command line as follows:


>msql -p

use asterisk;

\. /usr/src/astguiclient/extras/MySQL_AST_CREATE_tables.sql


insert into vicidial_users (user,pass,full_name,user_level,user_group,load_leads,campaign_detail, ast_admin_access,modify_users) values('XXXX','XXXX','Admin','9','ADMIN','1','1','1','1');