How to capture the whole SQL Insert in the Mysql CDR

Asterisk Asterisk Support
1

I am with a error in the CDR modules is not entering data in cdr table.

How can I capture the whole INSERT to check by myself in the mysql database.

I tried enable the cdr debug on and nothing, core debug and verbose 10, and nothing…

I need the data with the information, not only the “?”

image
image.png1878×154 12.4 KB

2

I’d recommend looking at how to enable logging through the ODBC connector, I believe unixodbc supports logging.

3

DiD you check the DB integrity, if table it is not corrupted?

4

The problem was a trigger that is called when one row is inserted in CDR table, but the problem is that almost impossible discover what is the problem without the whole line…

I need to solve by attempt and error. Will be very better if I have the Insert line.

5

Hi johnkiniston,
I tried to enable the trace feature in unixodbc but didn’t work in my server.

I made it…
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-trace-unix.html

6

You might need to debug selinux and filesystem permissions for the log file depending on where you put it.

7

I have it… I put the log output in /var/log

8

Hi, someone with a different idea?

Thanks

9

First, I’d make sure that each field exists in the database (and is spelled correctly). I replicate my databases, but you could turn on the binlog in MySQL. If the insert is failing at the DB, you could see it in the binary log. You could also run “SHOW PROCESSLIST” at the MySQL CLI and keep refreshing (up arrow, Enter) while you end a call. You might catch it.

1 Like