How to change Advanced Settings from the command line

Finally got back to messing with this. I don’t think changing the values in the files will work. A couple years back there was a blog post from Phillipe about how everything is getting moved into the MySQL database so changing files does not help. I printed out the entire freepbx_settings table and found all the Advanced Settings variables but I guess I don’t know what I’m doing with SQL.

I tried

UPDATE freepbx_settings SET value = ‘kjasfd98df4’ WHERE keyword = ‘AMPMGRPASS’;

which gives no errors initially and looking in Advanced Settings shows the new password but then a bunch of the modules become unavailable and clicking Apply Changes (or doing amportal a r in putty) gives me an error. Restarting the system or just restarting asterisk does nothing. The only way to fix it is to reset the password to default.

So there’s something that I’m missing here, like some other command that needs to be run after changing the table value to allow asterisk to connect to the database.