Project

General

Profile

Lost root and mysql and Gui password

Added by V J about 12 years ago

Hi we are using goautodial-ce-2.0 from last 1 year or so. One fo my staff who use to maintain the server and vcdial suddenly died in an accident. Now we do not have root password, mysql password, also in GUI we only have agents passwords/ non agent api password.

The system is working absolutely fine, but we are handicapped as we can make changes in campaigns as required.
We wish to retrive the admin password to manage campaigns and other settings in vcdial.

I have physical access to the server. Have root and phpmyadmin login screens but no passwords or the method to reset them.

Please guide us what are the possibilities. I understand we can redo the entire work but that would mean a new server as we can disturb the current one as it is Live and time. Hence this would be the last resort.


Replies (6)

RE: Lost root and mysql and Gui password - Added by V J about 12 years ago

Correction

"we can not make any changes in campaigns as required."

RE: Lost root and mysql and Gui password - Added by striker 247 about 12 years ago

1. if it is goautodial ce.20 check with the default passwords.
root -- vicidialnow
admin -- vicidialnow or goautodial
if both doesnt work follow the below steps
1. first you need to change the root password
Just restart your machine and follow the steps:
1. At the boot(grub) menu select the linux kernel
2. then press e
3. Go to the end of the line
4. add 1 or S or Single at the end of the line
5. press enter
6. press b on the line to boot from that line
7. Now the root prompt will come
8. run the command 'passwd' and it will ask you to change your password for root
And thats all .

2. Once you have changed the root password restart the system and login as root and run the following command to get the admin password of the goautodial gui

1. type mysql -p
password : vicidialnow
if above doesnt work use mysql -u cron -p
password: 1234
2. type: use asterisk
3. type: select * from vicidial_users where user="Admin"; ( change the user=Admin to your admin loginname if you know) or run the below command
select * from vicidial_users;

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

RE: Lost root and mysql and Gui password - Added by V J almost 12 years ago

thanx for advise.

I am stuck

after following the steps from 1 to 6 it does not boot. it stucks with last like as
Kernel Panic - Not syncing attempt to kill inist!

kindly guide where i might be going wrong.

RE: Lost root and mysql and Gui password - Added by V J almost 12 years ago

V J wrote:

thanx for advise.

I am stuck

after following the steps from 1 to 6 it does not boot. it stucks with last like as
Kernel Panic - Not syncing attempt to kill inist!

kindly guide where i might be going wrong.

photo.JPG (665 KB) photo.JPG this is wehre i added select
photo__1_.JPG (778 KB) photo__1_.JPG where i got the error

RE: Lost root and mysql and Gui password - Added by V J almost 12 years ago

Go it thanx.

was missing the space in between.

RE: Lost root and mysql and Gui password - Added by naveed sami almost 12 years ago

Hi,

I Also Get The Same Error. Kernel Panic - Not syncing attempt to kill inist!

Kindly Help Me

    (1-6/6)
    Go to top