How to reset A2billing password

torontob

Joined
May 18, 2008
Messages
219
Likes
0
Points
0
#1
What is the command to reset A2billing password
 

torontob

Joined
May 18, 2008
Messages
219
Likes
0
Points
0
#2
Anything guys?
 

bucasia

Joined
Feb 15, 2009
Messages
36
Likes
0
Points
0
#3
I'm not sure if there's a command but if you can't get into a2billing via the gui then you can change the password in mysql.

The default database is mya2billing. The default username/password is a2billinguser/a2billing

and the user/passwords are stored in a table called cc_ui_authen

Matt
 

torontob

Joined
May 18, 2008
Messages
219
Likes
0
Points
0
#4
So, I tried the following:

mysql -u a2billinguser -p
a2billing
use mya2billing

mysql> select cc_ui_authen;
ERROR 1054 (42S22): Unknown column 'cc_ui_authen' in 'field list'

And that turns out into an error. I am also stuck here. What do I do next to change values for password or how do I even pull up usernames and password in mysql? what is the command?

Thanks
 

dicko

Joined
Oct 24, 2008
Messages
4,099
Likes
0
Points
0
#5
after

use mya2billing

mysql> select * from cc_ui_authen ;

will work better. (you need to select the fields in this case all * from the table called cc_ui_authen in the current database (mya2billing))

start with http://dev.mysql.com/doc/refman/5.1/en/tutorial.html

it will tell you all you need within the first three chapters. (sometimes you gotta fish ;) )
 

elkabong

Joined
Apr 1, 2008
Messages
17
Likes
0
Points
0
#6
Here you go:

mysql mya2billing -u a2billinguser -p
password: a2billing

mysql> use mya2billing;
mysql> select * from cc_ui_authen;
mysql> UPDATE cc_ui_authen SET password = "newpassword" WHERE login = "admin";

To verify the change in the database just do:

mysql> select * from cc_ui_authen WHERE login = "admin";
mysql> quit
 

alben

Joined
Jan 20, 2010
Messages
28
Likes
0
Points
0
#7
Hello
Now a2billing password is changed, also a2billing login root/myroot needs to be changed.
what else needs to be changed and how, to be safe?
I already changed
SSH root
Freepbx admin/admin
Elastix admin/palosanto

thanks a lot
 

Members online

No members online now.

Latest posts

Forum statistics

Threads
30,915
Messages
130,920
Members
17,594
Latest member
knethardsolutions
Top