GOautodial Open Source Omni-channel Contact Center Suite

Login as root via console or SSH to your GoAutoDial server.

Enter the following commands:

[root@go ~] mysql -pvicidialnow asterisk

mysql> select * from vicidial_users where user="Admin";

You'll see something like the following below:

--------------+-------------+-----------+------------+------------+-------------+------------+--------------+--------------------+--------------+------------------+-----------------+----------------------+------------+-----------------+------------------+-------------------+----------------+--------------+----------------+-----------------------+-----------------------+------------------+---------------------+---------------------+------------------+--------------------+--------------------+----------------+-------------------------------+------------------------+-------------------+-------------------+--------------+------------------+--------------+----------------+----------------+-----------------+-------------------+---------------------+----------------+--------------+-----------------------------+-------------------------+------------+---------------+---------+-----------+-----------+-------------------+----------------------+----------------------+--------------------------+----------------------+---------------------+---------------------+--------+---------------+----------------+----------------------------------+------------------------------------+---------------------+----------------+-----------------+-------+-----------+-----------+--------------+--------------------------+------------+------------+--------------+-------------+-------------+--------------+------------------------------+----------------+----------------------+--------------------------+----------------------+-----------------------+----------------------------+ | 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 | active | alert_enabled | download_lists | agent_shift_enforcement_override | manager_shift_enforcement_override | shift_override_flag | export_reports | delete_from_dnc | email | user_code | territory | allow_alerts | agent_choose_territories | custom_one | custom_two | custom_three | custom_four | custom_five | voicemail_id | agent_call_log_view_override | callcard_admin | agent_choose_blended | realtime_block_user_info | custom_fields_modify | force_change_password | agent_lead_search_override |
--------------+-------------+-----------+------------+------------+-------------+------------+--------------+--------------------+--------------+------------------+-----------------+----------------------+------------+-----------------+------------------+-------------------+----------------+--------------+----------------+-----------------------+-----------------------+------------------+---------------------+---------------------+------------------+--------------------+--------------------+----------------+-------------------------------+------------------------+-------------------+-------------------+--------------+------------------+--------------+----------------+----------------+-----------------+-------------------+---------------------+----------------+--------------+-----------------------------+-------------------------+------------+---------------+---------+-----------+-----------+-------------------+----------------------+----------------------+--------------------------+----------------------+---------------------+---------------------+--------+---------------+----------------+----------------------------------+------------------------------------+---------------------+----------------+-----------------+-------+-----------+-----------+--------------+--------------------------+------------+------------+--------------+-------------+-------------+--------------+------------------------------+----------------+----------------------+--------------------------+----------------------+-----------------------+----------------------------+ | 3 | admin | vicidialnow | Admin | 9 | ADMIN | | | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1

but this command is not working. i have attached snapshot.please help me out.

Please see the commands above. You didn't run the command inside mysql command prompt.

Sir Can you please specify the command in details.
please help me out. i also run the command in mysql command prompt.

i am getting dot dot like ...............................

NEXUS CORPORATION wrote:
if i typed
mysql> select * from vicidial_users where user="Admin";
then I get record with admin password, in which i mentioned password i.e. 1234567
and when i provide the right information to login, it fails ,
please guide why is this happening so

Hi,

Please try the following:

Select user,pass,user_level from vicidial_users where user_level='9';

Thanks