Edit/remove outbound routes

[Mercury1 (Mercury)]

I am relatively new to FreePBX.

I created a number of outbound routes for an earlier, now removed trunk, which I now realize are clashing with each other making the new trunk unusable.

After I created a new trunk, under SIP setting it says in use by “6 routes." I did not assign any outbound routes to the new trunk. If I go to Connectivity>Outbound Routes page. It show zero (0) outbound routes, so I cannot delete or edit any of them.

If I attempt to access MySQL directly using the instruction I read on this forum I am get an error message and cannot access them.

fwconsole m

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 503149

Server version: 10.1.23-MariaDB-9+deb9u1 Raspbian 9.0

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MariaDB [asterisk]> mysql select * from outbound_routes;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘mysql select * from outbound_routes’ at line 1

MariaDB [asterisk]>

QUESTIONS:

1. How can I quickly delete all these outbound routes? AND/OR

2. How can I get these outbound routes to show up on the FreePBX OUTBOUND ROUTES PAGE SO I can directly edit/delete them.

I am using late versions of Asterisk and FreePBX.

Many thanks!

[lgaetz (Lorne Gaetz)]

@Mercury1

MariaDB [asterisk]> mysql select * from outbound_routes;

The command is:

select * from outbound_routes;