Astdb issue

thesir · January 4, 2014, 5:41am

Hey,

Currently I am having an issue with with astdb showing a lot of entries with:

192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d&381

this includes multiple
/SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 /SIP/Registry/200 54 results found. : 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d
: 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d

/AMPUSER/381/device : 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d&381
/AMPUSER/381/device : 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d&381
/AMPUSER/206/device : 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d&381
/AMPUSER/206/device : 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d&381

I am unable to delete these entries through del command using the syntax “database del SIP/Registry 200”… any sort of help with be appreciated. I also used deltree command but of no use.

dicko · January 4, 2014, 6:09pm

I don’t think this is an “astdb” issue, these are log file entries (of which my guess is you have duplicate entries in your /etc/asterisk/logger* ).

You have two devices 381 and 206 that basically claim to be the same thing and that a sip device in another network. How and why did you do that?

Maybe post the issue of:-

database show AMPUSER/381
and
database show AMPUSER/206

. . .

thesir · January 6, 2014, 5:50am

the results are

/AMPUSER/381/cidname : 381
/AMPUSER/381/cidnum : 381
/AMPUSER/381/device : 381
/AMPUSER/381/device : 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d&381
/AMPUSER/381/device : 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d&381
/AMPUSER/381/language :
/AMPUSER/381/language : en
/AMPUSER/381/noanswer :
/AMPUSER/381/outboundcid : 4238101112
/AMPUSER/381/password :
/AMPUSER/381/recording : out=Always|in=Always
/AMPUSER/381/ringtimer : 0
/AMPUSER/381/voicemail : novm
13 results found.

/AMPUSER/206/cidname : 206
/AMPUSER/206/cidname : 206
/AMPUSER/206/cidnum : 206
/AMPUSER/206/cidnum : 206
/AMPUSER/206/device : 206
/AMPUSER/206/device : 192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d&206
/AMPUSER/206/language :
/AMPUSER/206/noanswer :
/AMPUSER/206/outboundcid :
/AMPUSER/206/password :
/AMPUSER/206/recording : out=Always|in=Always
/AMPUSER/206/recording : out=Always|in=Always
/AMPUSER/206/ringtimer : 0
/AMPUSER/206/ringtimer : 0
/AMPUSER/206/voicemail : novm
/AMPUSER/206/voicemail : novm
16 results found.

now if i delete using “database deltree ampuser/381” and make new extension I still get the same problem in extension and the probelm is…

that the following value shows in my “CID Num Alias” and “Language Code” for a total of 4-5 extensions.

“192.168.3.30:62099:120:200:sip:[email protected]:62099;rinstance=1eeea8bb40f2166d&206”

and if i save the extension after deleting these values… these values came back right away even before pressing “apply configuration save”.

I am switching from traditional PBX and i have to use these extensions so changing/making new extension is not a solution for me