Where is external IP address stored in msql database on FreePBX 13?


(Avayax) #1

Does anybody know where the external IP address value is stored in mysql database on FreePBX 13 (HA) systems?


(TheJames) #2

The short answer is it depends…


(Avayax) #3

Thanks.
The one reference to a mysql table that I can find in the code was "SELECT * from sipsettings where keyword=‘externip_val’, _, but in my case that value is empty:

image

Not sure what I missed.


#4

Maybe the “detect network settings” button on the sipsettings page ?


(Avayax) #5

Yes, but what I am looking for is where the value that’s set by pressing the detect network settings button is stored in the MySQL database.
On Freepbx 14 and 15 it’s in the table kvstore_Sipsettings, but not on 13.
There is a table sipsettings which has a externip_val field, bit it’s empty in my case, even though on the GUI I have an external IP address configured.
So it must be stored somewhere else.

What I want to do is implement a script that rewrites a the external IP address into the database when the IP changes, like that one:


#6

If you are using NAT then that box will reflect in it’s pop-up help

This address will be provided to clients if NAT is enabled and detected

If you need to overide a detected static ip you can set it there .


(system) closed #7

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.