Removing Call Recordings for a CLI

[Andy_N]

Hi Everyone ,

I hope this message finds you all well ,

Please assit with the vicidial manually removing a specific CLI, leaving no trace for previous contact attempts.

How to go about it please help it's urgent.

Your assistance would highly be appreciated.

Warm Regards
Andy

[carpenox]

Seems rather suspicious asking to get rid of traces of call, like you're trying to get out of trouble for calling someone you shouldn't. This may not be the case, but it is definitely sketchy. With that being said, you could delete the record from mysql and the asterisk logs, however, your voip carrier will still have the records and thats where they tend to go for any tracebacks, so it would be useless to try to delete evidence of a call.

[Andy_N]

Affairmative,

Thank you so much for your response.

I'm asking because there is an internal sabotage, and I wanted to traceback on it. Thanks again @carpenox

Kind Regards
Andy

[williamconley]

To find ALL traces of a call:

For log files on disk, you can use "grep". This would be in the /var/log/asterisk folder and the /var/log/astguiclient folder. Note that some of these files may be compressed and require zgrep to search them without having to decompress everything.

Code: Select all

cd /var/log/asterisk; grep 8885551212 * -Rn

For database files, I've found that performing a data dump to a non-compressed sql file and then using "grep" on the mysqldump file is comprehensive. There is a command in mysqldump to force "one record per line" so you don't have a match on a line with 5000 records in it, which is ... awkward to work with.

For CDR logs ... they are (depending on configuration) either in /var/log/asterisk/ sub folders (which would be greppable as they are file-based logs if present) or in a table which may be in a different database, so you would just dump all the databases that may have call data.

Then there's the SQLITE database, I've not had to search one of those for a while but "back in the day" I did find that there were records in there that nobody thought to erase (and that was very handy). Mostly the SQLITE Database is disabled in vicidial installs these days (it'll fill the HD if the server runs for too long, and even slow down asterisk loading after a couple years with a lot of calls). SQLite db is usually in /var/log/asterisk or /var/lib/asterisk and may be cdr.db or sqlite.db. If present and not tiny, there are tools to dump that data to disk as well and/or search the DB.

[Andy_N]

That was very helpful @williamconley thank you so much.

Warm Regards
Andy

[williamconley]

Happy Hunting.