PBXes - Print: Three Reasons

PBXes (http://www1.pbxes.com/forum/index.php)
- English (http://www1.pbxes.com/forum/board.php?boardid=16)
-- Miscellaneous (http://www1.pbxes.com/forum/board.php?boardid=19)
--- Three Reasons (http://www1.pbxes.com/forum/threadid.php?threadid=800)

Posted by mightyhero on 20.08.2006 at 08:47:

Lost Extension

I accidentally deleted an extension. When I tried to recreate it, I received an error that the extension already exists and indeed it again shows up in my extensions list. However, I cannot modify the extension. If I delete it again and try to recreate it, I get the same "cannot insert into sip table" error. Unfortunately, I had an incoming route pointed to this extension and now whenever a call comes in from on that DID, it attempts to ring this missing extension -- unsuccessfully since it doesn't really exist.

I hope that all makes sense and that you can help. The extension in question is 8005991812. Thanks.

Posted by i-p-tel on 20.08.2006 at 19:33:

RE: Lost Extension

Your extension number is too long. Generally extension numbers should be 2 to 4 digits. Delete this extension, create a new one and change your incoming route to point to the new one.

Posted by mightyhero on 15.09.2006 at 08:31:

Might be a database problem

The actual error I receive is a failed INSERT statement ... database is reporting that a duplicate entry exists ... any change the offending record could be deleted/purged?

Posted by skynetbbs on 15.09.2006 at 15:20:

RE: Might be a database problem

extension can only be 6 numbers big...
the error you got is correct regarding "insert"-problem... but the "dupe" sounds not correct...

@ip-tel:
wasn't it possible to use classic number to have a "normal number" be targetting a sip://<accountname>-<short ext>@pbxes.org ?

so if one wants to use a DID internally...they could...the call would go via classic number->sip conversion to the shorter version?

Posted by mightyhero on 15.09.2006 at 15:27:

Three Reasons

I have three reasons for believing this problem has nothing to do with the length of the extension.

First, I have successfully used this configuration on other Asterisk installations.

Second, this extension DID work the first time I created. The problem developed when I deleted the extension and tried to recreate it.

Three, the error message specifically indicates the extension already exists in the SIP table, so it stands to reason the extension did not get correctly deleted from the database when I previously removed it.