Your browser (Internet Explorer 6) is out of date. It has known security flaws and may not display all features of this and other websites. Learn how to update your browser.
X
Post

VICIDIAL Tips and Tricks: Lost the manager’s password

Ok so you have lost your Web Admin manager’s password and you can’t login to the VICIDIAL web admin anymore. Don’t fret here’s how.

Login to your mysql database.

mysql -ucron -p1234 asterisk

Once in, you search for it like this

mysql> select * from vicidial_users where user='admin';

It will output this
+---------+-------+-------------+-----------+------------+------------+-------------+------------+--------------+--------------------+--------------+------------------+-----------------+----------------------+------------+-----------------+------------------+-------------------+----------------+--------------+----------------+-----------------------+-----------------------+------------------+---------------------+---------------------+------------------+--------------------+--------------------+----------------+-------------------------------+------------------------+-------------------+-------------------+--------------+------------------+--------------+----------------+----------------+-----------------+-------------------+---------------------+----------------+--------------+-----------------------------+-------------------------+------------+---------------+---------+-----------+-----------+-------------------+----------------------+----------------------+--------------------------+----------------------+---------------------+---------------------+
| user_id | user | pass | full_name | user_level | user_group | phone_login | phone_pass | delete_users | delete_user_groups | delete_lists | delete_campaigns | delete_ingroups | delete_remote_agents | load_leads | campaign_detail | ast_admin_access | ast_delete_phones | delete_scripts | modify_leads | hotkeys_active | change_agent_campaign | agent_choose_ingroups | closer_campaigns | scheduled_callbacks | agentonly_callbacks | agentcall_manual | vicidial_recording | vicidial_transfers | delete_filters | alter_agent_interface_options | closer_default_blended | delete_call_times | modify_call_times | modify_users | modify_campaigns | modify_lists | modify_scripts | modify_filters | modify_ingroups | modify_usergroups | modify_remoteagents | modify_servers | view_reports | vicidial_recording_override | alter_custdata_override | qc_enabled | qc_user_level | qc_pass | qc_finish | qc_commit | add_timeclock_log | modify_timeclock_log | delete_timeclock_log | alter_custphone_override | vdc_agent_api_access | modify_inbound_dids | delete_inbound_dids |
+---------+-------+-------------+-----------+------------+------------+-------------+------------+--------------+--------------------+--------------+------------------+-----------------+----------------------+------------+-----------------+------------------+-------------------+----------------+--------------+----------------+-----------------------+-----------------------+------------------+---------------------+---------------------+------------------+--------------------+--------------------+----------------+-------------------------------+------------------------+-------------------+-------------------+--------------+------------------+--------------+----------------+----------------+-----------------+-------------------+---------------------+----------------+--------------+-----------------------------+-------------------------+------------+---------------+---------+-----------+-----------+-------------------+----------------------+----------------------+--------------------------+----------------------+---------------------+---------------------+
| 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)

There you go!

Enjoy.

Share and Enjoy:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • email
  • Fark
  • LinkedIn
  • Live
  • MSN Reporter
  • MySpace
  • RSS
  • Slashdot
  • StumbleUpon
  • Technorati
  • Yahoo! Bookmarks
  • Yahoo! Buzz

Leave a comment  

name*

email*

website

Submit comment

CommentLuv badge

Switch to our mobile site