Baldwin Okello - 2021-04-13

I am in the process of testing the intergration of Radiusdesk (201&) with our billing system (very very old system so we had to revert to rd 2017). we need to be able to create and update permanent users with corresponding passwords in the mysql permanent_users table. The challenges we are facing are two;

  • Knowing which password function to use for the password field such that if its updated from the mysql db, the new password will be reflected in the front end. Comparing the password result in the database created from the front end with that created directly by inserting into the mysql table are different. We have tried with the password (), old_password (), Sha1 () , functions.
  • The front end GUI doesnt update or show the new password even after using the same password.

The specific requirement is simply to be able to create permanent users and passwords directly into the rd database (permanent_users table). We have to do it this way due to the nature of the billing system.

I have attached a snapshot of the database with two users baldwin@nano and albert@nano with the same password. baldwin@nano password was created from the front end where as albert@nano password field has been updated with that of baldwin@nano in the database, however the one for albert@nano does not update from the front end even after refreshing

Any assistance will be highly appreciated.

 
Thumbnail
Screenshot 2021-04-13 at 20.16.13.png