provided by Star2Billing S.L.

Hello everybody
I have a situation here and hope you can help me,
i have changed the user and pass to login in A2B 1.4
now iam tryin to enter but for any reason its not allowing me to login
there is a way to reset the password for admin in A2B 1.4?

I'll appriciate any advise.
thank you
Best

Have you tried searching in this forum on the terms

reset root password

Joe

yes i did and i could not find any useful info regarding this.
i see the info from mysql choosing mya2billing database

SELECT * FROM ui_authen;

but the password is encrypted
i remember the password but for some reason it is not allowing me to login
oh when i changed the password i changed the user as well, that have to see in this situation? i mean if the system use just root or something like that?

thank you for your help
Best

The 3rd hit on that search string gave me.

viewtopic.php?p=21225#21225

post number 5 from Stavros gives you the encrypted string to reset the password to "changepassword"

Hello everybody
Thank you so much Joe, but when i click on the link from stavros post 5 it shows me the installation procces that you did whitch is great.
could you please send me the direct link for the reset proccess.

I appriciate your help
Thanks
best

oops I succesfully changed the password from mysql, but as i mention before that i have changed the user as well, it doesn't work with that user.
I need to change back the user to root, i aprreciate your help.
thanks so much
best.

Hello guys i have succesfully change the password of my root user for the GUI with this thank to Joe.

assuming the db is a2billing
UPDATE cc_ui_authen set pwd_encoded=PASSWORD('YOUR NEW PASSWORD') where login='admin';
that should change the password for admin if admin exist

but before this happen I changed the user root to another user, I just replaced it
now i can not login because i think iam not using root user.

i used the new user and the correct password and i can not login so that means that i need to change back the root user. but i do not know how to reset that root user.

could some body help me out please

Thank you
Best

Once you have access to the GUI, you should be able to add another user via the GUI without issue.

Joe

Hello Joe thank you
The issue is i can not login to the GUI yet iam using another user witch replaced the root one
do you understand what iam saying?
i mean I need reset the user as well to get back the user root.
could you help me out to get back the root user please
for some reason i can not login with my user (user isnot root i replaced it) and pass.

Thank you Joe.
Best

Hello guys
could some one help me please, this is my info from mysql and i do not know what iam doing wrong
but i can not loging to the GUI i have change root pass several times and no one get works.
i was trying to create root and admin user as well and it says that is duplicated on key 2 which not appear in this info.
thanks in advance.


mysql> SELECT * FROM cc_ui_authen;
+--------+----------+-------------------------------------------+---------+----------+-------------+----------------+-----------+---------+-------+-----------+------+---------------------+----------------------+---------+---------+
| userid | login | pwd_encoded | groupid | perms | confaddcust | name | direction | zipcode | state | phone | fax | datecreation | email | country | city |
+--------+----------+-------------------------------------------+---------+----------+-------------+----------------+-----------+---------+-------+-----------+------+---------------------+----------------------+---------+---------+
| 1 | root | A9B1B24D0558F30A454C2D3 | 0 | 5249 | NULL | | | | | | | 2005-02-26 20:33:27 | | | |
| 3 | viachica | *2470C0C06DEE42FD1618BB | 1 | 18795 | NULL | | | | | | | 2009-12-23 20:55:28 | | | |
+--------+----------+-------------------------------------------+---------+----------+-------------+----------------+-----------+---------+-------+-----------+------+---------------------+----------------------+---------+---------+
2 rows in set (0.00 sec)

mysql> UPDATE cc_ui_authen set login='admin';
ERROR 1062 (23000): Duplicate entry 'admin' for key 2
mysql> UPDATE cc_ui_authen set login='root';
ERROR 1062 (23000): Duplicate entry 'root' for key 2