how to change password of administrator in gui

[vici_king]

Hi,

i am very new vicidial and some one have changed my administrator password of my gui can one please help out to change

[Op3r]

read the stickies.

Then you will know that you need to read the manual too.

Thanks

[boybawang]

You log in to your server via ssh, then type in mysql and on the mysql console which will look like this:

mysql> use asterisk;
mysql> select * from vicidial_users;

You will see a list of vicidial users and their corresponding passwords

[vici_king]

after entering into mysql what i am getting after hitting use asterisk; is DATABASE CHANGED but i couldnt find any vicidial-users

[boybawang]

its vicidial_users

[boybawang]

use this query to display usernames and passwords:

select user,pass from vicidial_users;

[boybawang]

to display the username and password only of the default admin user use this query:

select user,pass from vicidial_users where user='6666';

[vici_king]

after running this query i got Empty set(0.00 sec)

[vici_king]

Hey Thank you so much i got it

[boybawang]

Np

[hunter2009]

Hi boybawang"

I am fresher for the techinal support when am logged in the admin page am getting the error ....MySQL connect ERROR: Access denied for user 'cron'@'localhost' (using password: YES)

I dont have vicidial admin password and mysql cron pass we forgot that
now we have only server root password can u support for this how to trouble shoot this

[williamconley]

do you also have the mysql root password?

if so:

mysql -u root -p

[hunter2009]

williamconley

I dont have mysql root password i have only server passwrd

[williamconley]

in that case, we could "crack" your mysql password (or actually just reset it, if you have the root password for the machine) and then you'd be good, but that's not something i'll be posting how to do here. LOL

is this machine "Operational" or is it still being set up for use?

[Pynk Global]

Really confused now. downloaded and installed 3.1.14 and exactly the same.
Seems to be no passwords in select user,pass from vicidial_users; Getting empty set
see below.

green2012:~ # mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 15850
Server version: 5.1.57-log SUSE MySQL RPM

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use asterisk
Database changed
mysql> select * from vicidial_users;
Empty set (0.00 sec)

mysql> use asterisk;
Database changed
mysql> select * from vicidial_users;
Empty set (0.00 sec)

mysql> select user,pass from vicidial_users;
Empty set (0.00 sec)

mysql> select user,pass from vicidial_users where user='6666';
Empty set (0.00 sec)

[williamconley]

either you deleted your admin user instead of changing the password, or someone else deleted the users table, or you never had anything in it at all.

If you never had anything in it at all, it would be because your installation failed. In this case, it is best to start over and reinstall (as there are likely other problems, and it can take a long time to sort them out, a lot longer than a quick reinstall).

If you deleted your admin user, that would not explain the rest of them being missing.

If someone else deleted your users table ... you have a security issue and will need to resolve that and then reinstall to be sure you have a clean system.

What I am getting at here: If you fear the reinstall, you'll have a miserable time with Vicidial ... but if you reinstall several times and get used to it, you will find that building the Vicidial Server gets easier each time and there will then be nothing to fear. Then you can work on Reading the Manual while making money with Vicidial.

If you do not observe any errors in the vicidial.log resulting from a problem during installation ... you'll need to check the .sql file used during installation for your version (in /usr/src/astguiclient/VERSION) and work backwards from the last command to find which command DID work ... then you may be able to find which command failed and manually execute them from there to the end.

Or try GoAutoDial or 3.1.15 ...

And watch for errors during the install!

Happy Hunting!

[sharath]

Hi am using vicidial 2.2.1 unfortunately i deleted admin user name(6666) and password(1234) now i am not able to login has administrator in vicidial admin page so how to create same username and password....? please help on this...

[DomeDan]

You should have created a new thread about your problem.
use mysql to create the user again,
this is the query that the installer uses to create user 6666:

Code: Select all

INSERT INTO vicidial_users (user,pass,full_name,user_level,user_group,load_leads,campaign_detail,ast_admin_access,modify_users) values('6666','1234','Admin','9','ADMIN','1','1','1','1');

[switch2voip]

Thanks it worked

[siva9997]

HI. how to change the vicidial root password. i forgot the root password now i cant be able to login to it. can you guys help me to change or retrieve the root password

[striker]

check the below link for resetting the root password in linux

http://java.dzone.com/articles/reset-ro ... -centosred