I’m using Asterisk Realtime database. The following is the database structure. Am I missing any field?
±--------------------------±-------------±-----±----±--------------------------------------±---------------+
| Field | Type | Null | Key | Default | Extra |
±--------------------------±-------------±-----±----±--------------------------------------±---------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(80) | NO | UNI | NULL | |
| callerid | varchar(80) | YES | | NULL | |
| secret | varchar(80) | YES | | 1234 | |
| mailbox | varchar(50) | YES | | NULL | |
| accountcode | varchar(20) | YES | | NULL | |
| context | varchar(80) | YES | | from-sip | |
| amaflags | varchar(7) | YES | | NULL | |
| callgroup | varchar(10) | YES | | NULL | |
| canreinvite | char(3) | YES | | yes | |
| defaultip | varchar(15) | YES | | NULL | |
| dtmfmode | varchar(7) | YES | | rfc2833 | |
| fromuser | varchar(80) | YES | | NULL | |
| fromdomain | varchar(80) | YES | | NULL | |
| fullcontact | varchar(80) | YES | | NULL | |
| host | varchar(7) | NO | | dynamic | |
| insecure | varchar(4) | YES | | NULL | |
| language | char(2) | YES | | NULL | |
| md5secret | varchar(80) | YES | | NULL | |
| nat | varchar(20) | YES | | force_rport,comedia | |
| deny | varchar(95) | YES | | 0.0.0.0/0.0.0.0 | |
| permit | varchar(95) | YES | | 10.0.0.0/255.0.0.0 | |
| mask | varchar(95) | YES | | NULL | |
| pickupgroup | varchar(10) | YES | | NULL | |
| qualify | varchar(5) | NO | | no | |
| restrictcid | char(1) | YES | | NULL | |
| rtptimeout | char(3) | YES | | 0 | |
| rtpholdtimeout | char(3) | YES | | NULL | |
| type | varchar(6) | NO | | friend | |
| disallow | varchar(100) | YES | | all | |
| allow | varchar(100) | YES | | opus,ulaw,vp9,vp8,h264 | |
| musiconhold | varchar(100) | YES | | NULL | |
| regseconds | int(11) | NO | | 0 | |
| cancallforward | char(3) | YES | | yes | |
| useragent | char(255) | YES | | NULL | |
| regserver | varchar(100) | YES | | NULL | |
| transport | varchar(10) | YES | | wss | |
| ipaddr | varchar(16) | YES | | NULL | |
| lastms | varchar(30) | YES | | NULL | |
| port | varchar(16) | YES | | NULL | |
| avpf | varchar(3) | YES | | yes | |
| encryption | varchar(3) | YES | | yes | |
| icesupport | varchar(3) | YES | | yes | |
| rtcp_mux | varchar(3) | YES | | yes | |
| dtlsenable | varchar(3) | YES | | yes | |
| dtlsverify | varchar(16) | YES | | fingerprint | |
| dtlscertfile | varchar(30) | YES | | /home/etg/certs/asterisk.pem | |
| dtlscafile | varchar(40) | YES | | /home/etg/ca/BrowserPhone-Root-CA.crt | |
| dtlssetup | varchar(10) | YES | | actpass | |
| videosupport | varchar(3) | NO | | yes | |
| force_avpf | varchar(3) | NO | | yes | |
| subscribecontent | varchar(16) | NO | | subscriptions | |
| realm | varchar(16) | NO | | bp.erss.in | |
| srvlookup | varchar(3) | NO | | no | |
| mohsuggest | varchar(10) | NO | | default | |
| parkinglot | varchar(10) | NO | | default | |
| allowguest | varchar(3) | NO | | no | |
| alwaysauthreject | varchar(3) | NO | | yes | |
| maxcallbitrate | int(11) | NO | | 5120 | |
| ignoreregexpire | varchar(3) | NO | | no | |
| notifyhold | varchar(3) | NO | | yes | |
| notifyringing | varchar(3) | NO | | yes | |
| callcounter | varchar(3) | NO | | yes | |
| progressinband | varchar(5) | NO | | yes | |
| tos_sip | varchar(5) | NO | | af42 | |
| tos_audio | varchar(5) | NO | | ef | |
| cos_sip | int(11) | NO | | 3 | |
| cos_audio | int(11) | NO | | 5 | |
| rtpkeepalive | int(11) | NO | | 60 | |
| jbenable | varchar(5) | NO | | yes | |
| jbforce | varchar(5) | NO | | no | |
| jbmaxsize | int(11) | NO | | 200 | |
| jbresyncthreshold | int(11) | NO | | 1000 | |
| jbimpl | varchar(5) | NO | | fixed | |
| jblog | varchar(5) | NO | | no | |
| tcpenable | varchar(5) | NO | | no | |
| tlsenable | varchar(5) | NO | | no | |
| websocket_enabled | varchar(5) | NO | | yes | |
| force_avp | varchar(5) | NO | | yes | |
| directmedia | varchar(5) | NO | | no | |
| subscribecontext | varchar(16) | NO | | subscriptions | |
| defaultuser | varchar(160) | YES | | NULL | |
| rtcachefriends | varchar(5) | NO | | no | |
| rtp | varchar(5) | NO | | no | |
| allowsubscribe | varchar(5) | NO | | yes | |
| outofcall_message_context | varchar(16) | NO | | textmessages | |
| auth_message_requests | varchar(5) | NO | | no | |
| accept_outofcall_messages | varchar(5) | NO | | yes | |
±--------------------------±-------------±-----±----±--------------------------------------±---------------+
88 rows in set (0.017 sec)
sip.conf file:
[general]
callcounter=yes
rtcachefriends=no
udpbindaddr=0.0.0.0:5060
useragent=Asterisk BPX
realm=bp.erss.in
srvlookup=no
mohsuggest=default
parkinglot=default
allowguest=no
alwaysauthreject=yes
maxcallbitrate=5120
ignoreregexpire=no
notifyhold=yes
notifyringing=yes
callcounter=yes
progressinband=yes ; yes|no|never
tos_sip=af42
tos_audio=ef
cos_sip=3
cos_audio=5
rtptimeout=120
rtpkeepalive=60
jbenable=yes
jbforce=no
jbmaxsize=200
jbresyncthreshold=1000
jbimpl=fixed
jblog=no
tcpenable=no
tlsenable=no
websocket_enabled=yes
extensions.conf
[from-sip]
switch=>Realtime/from-sip@extensions