Page 1 of 1

Logfile of all mysql Queries executed from vdc_db_query.php

PostPosted: Mon Nov 25, 2013 8:56 pm
by phil_discount
Hi guys,
is it possible to log each mysql Query executed from files like vdc_db_query.php?
Regards
Philip

Re: Logfile of all mysql Queries executed from vdc_db_query.

PostPosted: Mon Nov 25, 2013 10:32 pm
by mflorell
Yes, just set the $mel=2; toward the top of that file. Hope you have enough drive space to handle it :)

Re: Logfile of all mysql Queries executed from vdc_db_query.

PostPosted: Tue Nov 26, 2013 4:25 am
by phil_discount
i put just one user to the new webserver to find a problem.
sometimes i get two entries in vicidial_agent_log for the call after a personal callback, very strange.
after this situation, dispo_sec is completely wrong.

i have to find the problem.

Re: Logfile of all mysql Queries executed from vdc_db_query.

PostPosted: Sat Nov 30, 2013 9:35 pm
by williamconley
You can also set this at the mysql level to capture all queries generated (period).

However, you said the problem happens after a "personal callback" which is a generalized statement. Describe (precisely) how this call proceeds (button for button) and the carrier dialplan(s) that it uses to execute. Perhaps we can find your problem. 8-)

Re: Logfile of all mysql Queries executed from vdc_db_query.

PostPosted: Wed Dec 04, 2013 11:19 am
by phil_discount
thanks for help, i found the error, was a very old modification of myself :-)