Logfile of all mysql Queries executed from vdc_db_query.php

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Logfile of all mysql Queries executed from vdc_db_query.php

Postby phil_discount » Mon Nov 25, 2013 8:56 pm

Hi guys,
is it possible to log each mysql Query executed from files like vdc_db_query.php?
Regards
Philip
ViciBox Redux 3.0.5 | Vicidial 2.2.1-260 100527-2211 | Asterisk 1.4.27.1
9xVicidial 8-core 2.5GHz,4GB,SSD
4xWeb 4-core 2.5GHz,4GB,SSD
DB: 24-core-1.9GHz AMD,96GB,8xSSD Raid10
3xDBslave 4-core 2.5GHz,4GB,SSD (for SELECT: Reporting/LIVE)
400 seats
phil_discount
 
Posts: 468
Joined: Thu Jun 18, 2009 8:44 am
Location: Deutschland/Schweiz/Österreich

Re: Logfile of all mysql Queries executed from vdc_db_query.

Postby mflorell » Mon Nov 25, 2013 10:32 pm

Yes, just set the $mel=2; toward the top of that file. Hope you have enough drive space to handle it :)
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Logfile of all mysql Queries executed from vdc_db_query.

Postby phil_discount » Tue Nov 26, 2013 4:25 am

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.
ViciBox Redux 3.0.5 | Vicidial 2.2.1-260 100527-2211 | Asterisk 1.4.27.1
9xVicidial 8-core 2.5GHz,4GB,SSD
4xWeb 4-core 2.5GHz,4GB,SSD
DB: 24-core-1.9GHz AMD,96GB,8xSSD Raid10
3xDBslave 4-core 2.5GHz,4GB,SSD (for SELECT: Reporting/LIVE)
400 seats
phil_discount
 
Posts: 468
Joined: Thu Jun 18, 2009 8:44 am
Location: Deutschland/Schweiz/Österreich

Re: Logfile of all mysql Queries executed from vdc_db_query.

Postby williamconley » Sat Nov 30, 2013 9:35 pm

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-)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Logfile of all mysql Queries executed from vdc_db_query.

Postby phil_discount » Wed Dec 04, 2013 11:19 am

thanks for help, i found the error, was a very old modification of myself :-)
ViciBox Redux 3.0.5 | Vicidial 2.2.1-260 100527-2211 | Asterisk 1.4.27.1
9xVicidial 8-core 2.5GHz,4GB,SSD
4xWeb 4-core 2.5GHz,4GB,SSD
DB: 24-core-1.9GHz AMD,96GB,8xSSD Raid10
3xDBslave 4-core 2.5GHz,4GB,SSD (for SELECT: Reporting/LIVE)
400 seats
phil_discount
 
Posts: 468
Joined: Thu Jun 18, 2009 8:44 am
Location: Deutschland/Schweiz/Österreich


Return to Support

Who is online

Users browsing this forum: No registered users and 68 guests