Hey guys,
I’m looking for a way to implement these nat parameters to a sip peer using Realtime :
Usally, using this in account (sip.conf) :
nat = yes
externip = 200.201.202.203
localnet=192.168.2.0/255.255.255.0
I didn’t have theses fields in my mysql structure except NAT :
CREATE TABLE
sippeers
(
id
int(11) NOT NULL,
id_user
int(11) NOT NULL,
name
varchar(40) NOT NULL,
ipaddr
varchar(45) DEFAULT NULL,
port
int(11) DEFAULT NULL,
regseconds
int(11) DEFAULT NULL,
defaultuser
varchar(40) NOT NULL,
fullcontact
varchar(80) DEFAULT NULL,
regserver
varchar(20) DEFAULT NULL,
useragent
varchar(64) DEFAULT NULL,
lastms
int(11) DEFAULT NULL,
host
varchar(40) DEFAULT NULL,
type
enum(‘friend’,‘user’,‘peer’) DEFAULT NULL,
context
varchar(40) DEFAULT NULL,
permit
varchar(95) DEFAULT NULL,
deny
varchar(95) DEFAULT NULL,
secret
varchar(40) DEFAULT NULL,
md5secret
varchar(40) DEFAULT NULL,
remotesecret
varchar(40) DEFAULT NULL,
transport
enum(‘udp’,‘tcp’,‘tls’,‘ws’,‘wss’,‘udp,tcp’,‘tcp,udp’) DEFAULT NULL,
dtmfmode
enum(‘rfc2833’,‘info’,‘shortinfo’,‘inband’,‘auto’) DEFAULT NULL,
directmedia
enum(‘yes’,‘no’,‘nonat’,‘update’) NOT NULL DEFAULT ‘yes’,
nat
varchar(29) DEFAULT NULL,
callgroup
varchar(40) DEFAULT NULL,
pickupgroup
varchar(40) DEFAULT NULL,
language
varchar(40) DEFAULT NULL,
disallow
varchar(200) DEFAULT NULL,
allow
varchar(200) DEFAULT NULL,
insecure
varchar(40) DEFAULT NULL,
trustrpid
enum(‘yes’,‘no’) DEFAULT NULL,
progressinband
enum(‘yes’,‘no’,‘never’) DEFAULT NULL,
promiscredir
enum(‘yes’,‘no’) DEFAULT NULL,
useclientcode
enum(‘yes’,‘no’) DEFAULT NULL,
accountcode
varchar(40) NOT NULL,
setvar
varchar(200) DEFAULT NULL,
callerid
varchar(40) NOT NULL,
amaflags
varchar(40) DEFAULT NULL,
callcounter
enum(‘yes’,‘no’) DEFAULT NULL,
busylevel
int(11) DEFAULT NULL,
allowoverlap
enum(‘yes’,‘no’) DEFAULT NULL,
allowsubscribe
enum(‘yes’,‘no’) DEFAULT NULL,
videosupport
enum(‘yes’,‘no’) DEFAULT NULL,
maxcallbitrate
int(11) DEFAULT NULL,
rfc2833compensate
enum(‘yes’,‘no’) DEFAULT NULL,
mailbox
varchar(40) DEFAULT NULL,
session-timers
enum(‘accept’,‘refuse’,‘originate’) DEFAULT NULL,
session-expires
int(11) DEFAULT NULL,
session-minse
int(11) DEFAULT NULL,
session-refresher
enum(‘uac’,‘uas’) DEFAULT NULL,
t38pt_usertpsource
varchar(40) DEFAULT NULL,
regexten
varchar(40) DEFAULT NULL,
fromdomain
varchar(40) DEFAULT NULL,
fromuser
varchar(40) DEFAULT NULL,
qualify
varchar(40) DEFAULT NULL,
defaultip
varchar(45) DEFAULT NULL,
rtptimeout
int(11) DEFAULT NULL,
rtpholdtimeout
int(11) DEFAULT NULL,
sendrpid
enum(‘yes’,‘no’) DEFAULT NULL,
outboundproxy
varchar(40) DEFAULT NULL,
callbackextension
varchar(40) DEFAULT NULL,
timert1
int(11) DEFAULT NULL,
timerb
int(11) DEFAULT NULL,
qualifyfreq
int(11) DEFAULT NULL,
constantssrc
enum(‘yes’,‘no’) DEFAULT NULL,
contactpermit
varchar(95) DEFAULT NULL,
contactdeny
varchar(95) DEFAULT NULL,
usereqphone
enum(‘yes’,‘no’) DEFAULT NULL,
textsupport
enum(‘yes’,‘no’) DEFAULT NULL,
faxdetect
enum(‘yes’,‘no’) DEFAULT NULL,
buggymwi
enum(‘yes’,‘no’) DEFAULT NULL,
auth
varchar(40) DEFAULT NULL,
fullname
varchar(40) DEFAULT NULL,
trunkname
varchar(40) DEFAULT NULL,
cid_number
varchar(40) DEFAULT NULL,
callingpres
enum(‘allowed_not_screened’,‘allowed_passed_screen’,‘allowed_failed_screen’,‘allowed’,‘prohib_not_screened’,‘prohib_passed_screen’,‘prohib_failed_screen’,‘prohib’) DEFAULT NULL,
mohinterpret
varchar(40) DEFAULT NULL,
mohsuggest
varchar(40) DEFAULT NULL,
parkinglot
varchar(40) DEFAULT NULL,
hasvoicemail
enum(‘yes’,‘no’) DEFAULT NULL,
subscribemwi
enum(‘yes’,‘no’) DEFAULT NULL,
vmexten
varchar(40) DEFAULT NULL,
autoframing
enum(‘yes’,‘no’) DEFAULT NULL,
rtpkeepalive
int(11) DEFAULT NULL,
call-limit
int(11) DEFAULT NULL,
g726nonstandard
enum(‘yes’,‘no’) DEFAULT NULL,
ignoresdpversion
enum(‘yes’,‘no’) DEFAULT NULL,
allowtransfer
enum(‘yes’,‘no’) DEFAULT NULL,
dynamic
enum(‘yes’,‘no’) DEFAULT ‘yes’,
path
varchar(256) DEFAULT NULL,
supportpath
enum(‘yes’,‘no’) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Many thanks for your help !