Command to purge caller ID cache?

[dan_ce (D E)]

Does anyone know this command? Many thanks.

[AdFun7911]

You mean the cache of the Caller ID Lookup? Why don’t you just disable the cache if it causes problems?

[dan_ce (D E)]

It doesn’t cause problems but if I add a number to the phone book I want superfecta to use that name rather than the cached result.

[lgaetz (Lorne Gaetz)]

@dan_ce

if I add a number to the phone book I want superfecta to use that name rather than the cached result.

You can order your superfecta lookup resources with phone book ahead of cache. You can also control how many days a cnam stays in superfecta cache, so if you set retention time to 0 and do a lookup id should purge all cached records. Then you can set it back to whatever you want. If you’re comfortable with mysql, you could empty the table manually:

[root]# fwconsole m
MariaDB [asterisk]> show tables like "%superfecta%";
+-----------------------------------+
| Tables_in_asterisk (%superfecta%) |
+-----------------------------------+
| superfecta_mf                     |
| superfecta_mf_child               |
| superfecta_to_incoming            |
| superfectacache                   |
| superfectaconfig                  |
+-----------------------------------+
5 rows in set (0.00 sec)

MariaDB [asterisk]> select * from superfectacache;
+-------------+--------------+---------------------+
| number      | callerid     | dateentered         |
+-------------+--------------+---------------------+
| 1920xxxxxxx | SANGOMA TECH | 2021-07-31 12:41:39 |
+-------------+--------------+---------------------+
1 row in set (0.00 sec)

MariaDB [asterisk]> truncate superfectacache;
Query OK, 0 rows affected (0.01 sec)

MariaDB [asterisk]> select * from superfectacache;
Empty set (0.00 sec)

[dan_ce (D E)]

Thanks Lorne. This was the command I’d seen and used before. Just couldn’t find the previous post anywhere! Maybe it was given in a DM, now I think on it. Thank you!