reset vicidial admin password

vicidial password retrivel

by striker » Sun Jan 16, 2011 9:24 pm

hi 

if you know the admin username then follow the below steps to get the admin password and then login to the vicidial admin gui and then reset it 

1.Login to your mysql database. type the following 
mysql -ucron -p1234 asterisk 

2. once you entered the mysql cli type the following ie after the mysql> 

select * from vicidial_users where user='admin'; 
NOTE: in the field of user='admin' enter your admin username 

once entering the above command it will give you some quiries as below 

+---------+-------+-------------+-----------+------------+------------+-------------+------------+--------------+--------------------+--------------+------------------+-----------------+----------------------+------------+-----------------+------------------+-------------------+----------------+--------------+----------------+-----------------------+-----------------------+------------------+---------------------+---------------------+------------------+--------------------+--------------------+----------------+-------------------------------+------------------------+-------------------+-------------------+--------------+------------------+--------------+----------------+----------------+-----------------+-------------------+---------------------+----------------+--------------+-----------------------------+-------------------------+------------+---------------+---------+-----------+-----------+-------------------+----------------------+----------------------+--------------------------+----------------------+---------------------+---------------------+ 
| 1 | admin | vicidialnow | 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 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | NOT_ACTIVE | 0 | 0 | 0 | 
+---------+-------+-------------+-----------+------------+------------+-------------+------------+--------------+--------------------+--------------+------------------+-----------------+----------------------+------------+-----------------+------------------+-------------------+----------------+--------------+----------------+-----------------------+-----------------------+------------------+---------------------+---------------------+------------------+--------------------+--------------------+----------------+-------------------------------+------------------------+-------------------+-------------------+--------------+------------------+--------------+----------------+----------------+-----------------+-------------------+---------------------+----------------+--------------+-----------------------------+-------------------------+------------+---------------+---------+-----------+-----------+-------------------+----------------------+----------------------+--------------------------+----------------------+---------------------+---------------------+ 
1 row in set (0.00 sec) 

it show your password next to your admin username as highlited in red