Bug #1401
closed
Admin user password
100%
Description
well just install Goautodial 3.0 64bit, after installing and configuring, had change may admin pannel password. and now unable to login back following are the msg i am getting.
mysql> select * from vicidial_users where user="Admin";--------------+----------+-----------+------------+------------+-------------+------------+--------------+--------------------+--------------+------------------+-----------------+----------------------+------------+-----------------+------------------+-------------------+----------------+--------------+----------------+-----------------------+-----------------------+------------------+---------------------+---------------------+------------------+--------------------+--------------------+----------------+-------------------------------+------------------------+-------------------+-------------------+--------------+------------------+--------------+----------------+----------------+-----------------+-------------------+---------------------+----------------+--------------+-----------------------------+-------------------------+------------+---------------+---------+-----------+-----------+-------------------+----------------------+----------------------+--------------------------+----------------------+---------------------+---------------------+--------+---------------+----------------+----------------------------------+------------------------------------+---------------------+----------------+-----------------+-------+-----------+-----------+--------------+--------------------------+------------+------------+--------------+-------------+-------------+--------------+------------------------------+----------------+----------------------+--------------------------+----------------------+-----------------------+----------------------------+---------------+---------------+-----------------+---------------+-----------------+------------------+-------------------+------------+------------+-----------------------+-----------------+------------------------+----------------------+-----------------------+
| 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 | modify_shifts | modify_phones | modify_carriers | modify_labels | modify_statuses | modify_voicemail | modify_audiostore | modify_moh | modify_tts | preset_contact_search | modify_contacts | modify_same_user_level | admin_hide_lead_data | admin_hide_phone_data |--------------+----------+-----------+------------+------------+-------------+------------+--------------+--------------------+--------------+------------------+-----------------+----------------------+------------+-----------------+------------------+-------------------+----------------+--------------+----------------+-----------------------+-----------------------+------------------+---------------------+---------------------+------------------+--------------------+--------------------+----------------+-------------------------------+------------------------+-------------------+-------------------+--------------+------------------+--------------+----------------+----------------+-----------------+-------------------+---------------------+----------------+--------------+-----------------------------+-------------------------+------------+---------------+---------+-----------+-----------+-------------------+----------------------+----------------------+--------------------------+----------------------+---------------------+---------------------+--------+---------------+----------------+----------------------------------+------------------------------------+---------------------+----------------+-----------------+-------+-----------+-----------+--------------+--------------------------+------------+------------+--------------+-------------+-------------+--------------+------------------------------+----------------+----------------------+--------------------------+----------------------+-----------------------+----------------------------+---------------+---------------+-----------------+---------------+-----------------+------------------+-------------------+------------+------------+-----------------------+-----------------+------------------------+----------------------+-----------------------+
| 3 | admin | aliali99 | Admin | 1 | ADMIN | | | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | DISABLED | NOT_ACTIVE | | 0 | | | | 1 | 1 | 1 | NOT_ACTIVE | 1 | 1 | 1 | Y | 0 | 1 | DISABLED | 1 | 0 | 1 | 1 | | | | 0 | | | | | | | | DISABLED | 1 | 1 | 1 | 1 | N | NOT_ACTIVE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NOT_ACTIVE | 0 | 1 | 0 | 0 |--------------+----------+-----------+------------+------------+-------------+------------+--------------+--------------------+--------------+------------------+-----------------+----------------------+------------+-----------------+------------------+-------------------+----------------+--------------+----------------+-----------------------+-----------------------+------------------+---------------------+---------------------+------------------+--------------------+--------------------+----------------+-------------------------------+------------------------+-------------------+-------------------+--------------+------------------+--------------+----------------+----------------+-----------------+-------------------+---------------------+----------------+--------------+-----------------------------+-------------------------+------------+---------------+---------+-----------+-----------+-------------------+----------------------+----------------------+--------------------------+----------------------+---------------------+---------------------+--------+---------------+----------------+----------------------------------+------------------------------------+---------------------+----------------+-----------------+-------+-----------+-----------+--------------+--------------------------+------------+------------+--------------+-------------+-------------+--------------+------------------------------+----------------+----------------------+--------------------------+----------------------+-----------------------+----------------------------+---------------+---------------+-----------------+---------------+-----------------+------------------+-------------------+------------+------------+-----------------------+-----------------+------------------------+----------------------+-----------------------+
1 row in set (0.00 sec)
Files
Updated by fred flint over 9 years ago
I also had this problem. The GUI resets the admin user level to 1 when you change admin password. You cannot change that level back to a 9 or anything else from the GUI. It just always goes to 1.
I had to manually change it directly in the database to a 9 and then I got back in. It's located in "asterisk" database and "vicidial_users" table.
Updated by fred flint over 9 years ago
I installed Goautodial v3.3 so it's a problem there as well.
Updated by Demian Biscocho over 9 years ago
- % Done changed from 100 to 0
Can you exactly describe the steps you were doing? Is this a clean install of CE 3.3? What's the GOadmin version?
We can't recreate this bug. We have changed the admin passwords numerous times and the user level is still 9. The only way the user level is going to be 1 is if the User Group settings is set to VICIDIAL AGENTS.
Updated by Demian Biscocho over 9 years ago
- Status changed from New to In Progress
- Assignee changed from bilal ali to Demian Biscocho
Updated by fred flint over 9 years ago
This is a brand new install from scratch using these instructions.
http://goautodial.org/projects/goautodialce/wiki/64bit
Updated by fred flint over 9 years ago
Not sure if it's relevant but we also ran the Mysql securing script that was suggested during the install for production.
Updated by Demian Biscocho over 9 years ago
Can you post the MySQL securing script that you ran? Were you connecting to your GOautodial server via LAN or WAN?
Updated by fred flint over 9 years ago
We are running it on a hosted VPS but that should not be relevant.
The script is suggested by a goautodial prompt. Is goautodial not familiar with their own recommendations? You should not get distracted by that because I don't see how securing MySQL could cause this to happen.
/usr/bin/mysql_secure_installation
I am not the only one with this problem assuming the OP problem is the same.
See attached file or just look in your own centos install
/usr/bin/mysql_secure_installation
Updated by Demian Biscocho over 9 years ago
We are trying to replicate the bug by verifying the process you did to create it. Please don't ask us if we are familiar or not with our own recommendations. This doesn't help in resolving bugs.
This script does nothing to make the Admin user level to 1:
/usr/bin/mysql_secure_installation
Running it on a hosted VPS or accessing the server via the internet can be relevant. Specially if there are delays or disruptions communicating (web browser) to the GOautodial server.
Updated by Andy Colos over 9 years ago
I have the same issue.
vanilla install 3.3 - first thing, reset admin password.
Admin privileges are then reset to 1.
Admin can no longer log in if you log out.
Updated by Demian Biscocho over 9 years ago
Forum topic:
Updated by fred flint over 9 years ago
I think I found the solution.
/var/www/html/js/go_user/go_user_ce.js
Around line #325
Swap the position of
if($currId.indexOf('modify_same_user_level') !== -1){
$(this).attr("id","modify_same_user_level-"+$user);
$(this).attr("name","modify_same_user_level-"+$user);
}
and
if($currId.indexOf('user_level') !== -1){
$(this).attr("id","user_level-"+$user);
$(this).attr("name","user_level-"+$user);
}
So that 'user_level' comes before 'modify_same_user_level'
Updated by Chris Lomuntad over 9 years ago
Hi fred flint,
Have you tested the solution you've said? Does the problem solved?
Cheers,
Chris
Updated by fred flint over 9 years ago
Chris Lomuntad wrote:
Hi fred flint,
Have you tested the solution you've said? Does the problem solved?
Cheers,
Chris
Yes
Updated by Chris Lomuntad over 9 years ago
- Status changed from In Progress to Resolved
Hi,
The fix that fred flint found was already added on our GIThub repository. Kindly update your server if you still encounter some problems with changing admin user's password.
Cheers,
Chris
Updated by Jerico James Milo over 9 years ago
- Status changed from Resolved to Closed
- % Done changed from 0 to 100
Updated by edo modo about 6 years ago
Edmodo | Product Reviews | EdSurge
Edmodo is a social network for students, teachers, parents, and schools. It can be used to share assignments and grades, host discussions and post videos, schedule appointments, and create and take polls. It was created by two school district IT professionals who knew that schools typically blocked social networking sites.
edmodo