Cannot delete inbound route

[AndreyMasalov]

I can’t delete the two old inbound routes. They are shown in the screenshot.

When I click on the delete button, nothing happens. If you try to make changes, a new incoming route is created with these changes, but the old one remains unchanged.

Here is the information from the configuration file extensions_additional.conf:

exten => Termodver',1,Set(__DIRECTION=INBOUND)
exten => Termodver',n,Gosub(sub-record-check,s,1(in,${EXTEN},dontcare))
exten => Termodver',n,Gosub(app-blacklist-check,s,1())
exten => Termodver',n,Set(__FROM_DID=${EXTEN})
exten => Termodver',n,Set(CDR(did)=${FROM_DID})
exten => Termodver',n,ExecIf($[ "${CALLERID(name)}" = "" ] ?Set(CALLERID(name)=${CALLERID(num)}))
exten => Termodver',n,Set(__MOHCLASS=)
exten => Termodver',n,Set(__REVERSAL_REJECT=FALSE)
exten => Termodver',n,GotoIf($["${REVERSAL_REJECT}"!="TRUE"]?post-reverse-charge)
exten => Termodver',n,GotoIf($["${CHANNEL(reversecharge)}"="1"]?macro-hangupcall)
exten => Termodver',n(post-reverse-charge),Noop()
exten => Termodver',n,Set(__CALLINGNAMEPRES_SV=${CALLERID(name-pres)})
exten => Termodver',n,Set(__CALLINGNUMPRES_SV=${CALLERID(num-pres)})
exten => Termodver',n,Set(CALLERID(name-pres)=allowed_not_screened)
exten => Termodver',n,Set(CALLERID(num-pres)=allowed_not_screened)
exten => Termodver',n,Gosub(cidlookup,cidlookup_2,1())
exten => Termodver',n(did-cid-hook),Noop(CallerID Entry Point)
exten => Termodver',n,Set(__CRM_DIRECTION=INBOUND)
exten => Termodver',n,Set(__CRM_SOURCE=${CALLERID(num)})
exten => Termodver',n,Set(__CRM_LINKEDID=${CHANNEL(LINKEDID)})
exten => Termodver',n,ExecIf($["${CRM_DIRECTION}"="INBOUND"]?Set(CHANNEL(hangup_handler_push)=crm-hangup,s,1))
exten => Termodver',n(dest-ext),Goto(from-did-direct,1100,1)

exten => Termodver',n,Gosub(sub-record-check,s,1(in,${EXTEN},dontcare))

As you can see the name of the second inbound route is different.

Tell me, please, how to solve this problem?

[lgaetz (Lorne Gaetz)]

Special characters are messing things up. You will have to manually delete them using MySQL. Get a backup before starting, and then run

fwconsole m

from there you need to use mysql queries to identify and delete the offending route:

mysql> select * from outbound_routes;
+----------+------------------+------------+--------------------+----------+-----------------+--------------------+----------+---------------+------+
| route_id | name             | outcid     | outcid_mode        | password | emergency_route | intracompany_route | mohclass | time_group_id | dest |
+----------+------------------+------------+--------------------+----------+-----------------+--------------------+----------+---------------+------+
|        1 | E911-Leave-First |            |                    |          | YES             |                    | default  |          NULL |      |
|        2 | SIPStation-INT   | xxxxxx1934 | override_extension |          |                 |                    | default  |          NULL |      |
|        3 | SIPStation-Out   |            |                    |          |                 |                    | none     |          NULL |      |
|       10 | wrong number     |            |                    |          |                 |                    | default  |          NULL |      |
|       14 | fax account code |            |                    |          |                 |                    | default  |          NULL |      |
|       21 | peer             |            |                    |          |                 |                    | default  |          NULL |      |
+----------+------------------+------------+--------------------+----------+-----------------+--------------------+----------+---------------+------+
6 rows in set (0.00 sec)

mysql> delete from outbound_routes where route_id like "14";
Query OK, 1 row affected (0.00 sec)

mysql> select * from outbound_routes;
+----------+------------------+------------+--------------------+----------+-----------------+--------------------+----------+---------------+------+
| route_id | name             | outcid     | outcid_mode        | password | emergency_route | intracompany_route | mohclass | time_group_id | dest |
+----------+------------------+------------+--------------------+----------+-----------------+--------------------+----------+---------------+------+
|        1 | E911-Leave-First |            |                    |          | YES             |                    | default  |          NULL |      |
|        2 | SIPStation-INT   | xxxxxx1934 | override_extension |          |                 |                    | default  |          NULL |      |
|        3 | SIPStation-Out   |            |                    |          |                 |                    | none     |          NULL |      |
|       10 | wrong number     |            |                    |          |                 |                    | default  |          NULL |      |
|       21 | peer             |            |                    |          |                 |                    | default  |          NULL |      |
+----------+------------------+------------+--------------------+----------+-----------------+--------------------+----------+---------------+------+
5 rows in set (0.00 sec)

[AndreyMasalov]

Thank you, it works.