Adding or updating users in the optional MySQL Database

Last updated 2022.02.16

In order to facilitate auto-registration, a user's extension and passcode must be stored in the optional database. Additionally, the database enables saving of chat, history, and shortcuts between sessions. All that is needed to add a user to the database is the extension and passcode pair.

To add a user whose extension and passcode are '1000', assuming the database is called "sipml5_web", you use the following command:

INSERT INTO sipml5_web.extensions(extension, passcode) VALUES(1000, 1000);

If you are updating a passcode, the following code will work:

UPDATE sipml5_web.extensions SET passcode=1000 WHERE extension=1000;