DbMonitor 3 Strange behaviour

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Thomas J.
Posts: 95
Joined: Mon 21 Nov 2005 12:16
Location: Germany

Post by Thomas J. » Tue 09 Mar 2010 15:24

Hello Dimon,

any progress regarding no logging?

Thanks
Thomas

Thomas J.
Posts: 95
Joined: Mon 21 Nov 2005 12:16
Location: Germany

Post by Thomas J. » Thu 18 Mar 2010 10:43

Hello Support,

is anyone able to give me a simple answer?
The hint from Dimn is not working and I cannot still see some logging information. The DbMonitor V2 is not working anymore with the new version. Can you commit this or this another problem?
Did you download my sample code which I sent you few weeks ago?
Could you reproduce the problem?
Are you working on the problem?
What kind of information you need to help me?

Thanks Thomas

Challenger
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Fri 19 Mar 2010 12:21

Sorry for the delay. We have tried your samlpe but were unable to reproduce the problem. It is very strange that statements in dbMonitor appear in a different sequence then they are executed. We send one packet before executing query and the second just after it. So this situation should be impossible (but unfortunately it is showed in your video)
Can you sniffer the interaction beetween your application and dbMonitor (by default dbMonitor uses the 1000 port). You can use the NetView tool or something similar.
Last edited by Challenger on Mon 19 Apr 2010 07:29, edited 1 time in total.

Thomas J.
Posts: 95
Joined: Mon 21 Nov 2005 12:16
Location: Germany

Post by Thomas J. » Fri 16 Apr 2010 11:23

I downloaded the NetView, but how to process now?
I never used such tool?

Thanks
Thomas

FYI
Also the new version of your product is not working regarding DbMonitor.
I use a Windows 7 64-Bit

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 16 Apr 2010 12:37

To set up the NetView tool perform the following steps:
1. Start the NetView application.
2. Open the Tools->NetProxy menu.
3. On the "Incoming sessions setup" tab set Local [IP:port] to Default:1001.
4. On the "Outgoing sessions setup" tab set Address to "localhost" and Remote port to 1000.
5. On the "Logging" tab set the path to the Log file.
6. Go to the "Proxy control" tab and choose the "TCP port mapping" as a Proxy mode. And after this press the Start button.

After that start dbMonitor and your application. Wait for the query in your application is executed and make sure that it was completed. After that check the log file created by NetView. Check that one packet was sent before query execution and the other was sent after execution.

Thomas J.
Posts: 95
Joined: Mon 21 Nov 2005 12:16
Location: Germany

Post by Thomas J. » Fri 16 Apr 2010 12:50

Sorry but I don't have
Tools->NetProxy

where do you downloaded the version?

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 16 Apr 2010 12:58


Thomas J.
Posts: 95
Joined: Mon 21 Nov 2005 12:16
Location: Germany

Post by Thomas J. » Fri 16 Apr 2010 13:23

The only line which is written is
[START|Default:1001|TCP port mapping|OK]

but the log of the DbMonitor is full with lines.

for the config check
http://www.cratemaker.de/Download/NetView.avi

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 16 Apr 2010 13:47

Set the MySQLMonitor.DBMonitorOptions.Port property to 1001.

Thomas J.
Posts: 95
Joined: Mon 21 Nov 2005 12:16
Location: Germany

Post by Thomas J. » Fri 16 Apr 2010 13:53

[CLIENT|127.0.0.1|ACCEPTED|0]
[PEER|127.0.0.1|OK]
[0|DISCONNECT|RECV_FROM_SERVER|10054]
[0|DISCONNECT|SEND_TO_SERVER|10054]
[SESSION_CLOSED|0]

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 16 Apr 2010 14:12

Please set Level to "+Transfer data" on the "Logging" tab.

Thomas J.
Posts: 95
Joined: Mon 21 Nov 2005 12:16
Location: Germany

Post by Thomas J. » Fri 16 Apr 2010 14:23

[INIT|OK]
[START|Default:1001|TCP port mapping|OK]
[CLIENT|127.0.0.1|ACCEPTED|0]
[PEER|127.0.0.1|OK]
[0|TRANSFER|127.0.0.1->166]
#####h#######MyDAC monitoring is started### S:\Cratemaker10\.\Cratemaker.exe###########h#######MyDAC monitoring is started### S:\Cratemaker10\.\Cratemaker.exe
[0|TRANSFER|127.0.0.1->4]
###
[0|TRANSFER|127.0.0.1->836]
########h###
##^SQL Execute: SELECT * FROM t_event_calendar
WHERE (n_status >= 0 AND d_start >= :startDate AND d_start = 0 AND n_erledigt = 0
:startDate(Date)=16.04.2010
:endDate(Date)=17.04.2010###ôC
éË`###TbTerminKalender######TMyQuerya™ð###MCModuleTerminkaender######
TMyConnection##SELECT * FROM t_event_calendar
WHERE (n_status >= 0 AND d_start >= :startDate AND d_start = 0 AND n_erledigt = 0 ###### startDate###Date#######
16.04.2010###endDate###Date#######
17.04.2010####
[0|TRANSFER|127.0.0.1->4]
###
[0|TRANSFER|127.0.0.1->470]
########h###
##^SQL Execute: SELECT * FROM t_event_calendar
WHERE (n_status >= 0 AND d_start >= :startDate AND d_start = 0 AND n_erledigt = 0
:startDate(Date)=16.04.2010
:endDate(Date)=17.04.2010###ôR############## startDate###Date#######
16.04.2010###endDate###Date#######
17.04.2010####
[0|TRANSFER|127.0.0.1->4]
[0|TRANSFER|127.0.0.1->20]
########h###
##Q
[0|TRANSFER|127.0.0.1->784]
SQL Execute: SELECT *
FROM t_event_calendar
WHERE ((n_internal_event_type = 100)
AND d_start >= :startDate
AND d_start = 100)
AND d_start >= :startDate
AND d_start 461]
###########h###
##QSQL Execute: SELECT *
FROM t_event_calendar
WHERE ((n_internal_event_type = 100)
AND d_start >= :startDate
AND d_start 4]
[0|TRANSFER|127.0.0.1->1460]
[0|TRANSFER|127.0.0.1->1852]
lungsart_id IS NULL, 0, 1) AS n_ispm,
IF (vnr.d_fertig IS NULL, 0, 1) AS n_fertig, vas.c_nr AS verp_nr, c.d_start, vz.d_datetime AS erstellt
FROM t_verpackung_zeiten vz, t_auftrag_posten_sonstige vas, t_auftrag a, t_verpackung_nr_list vnr LEFT JOIN t_event_calendar c ON vnr.c_abhollief_termin = c.c_id
WHERE vz.n_type_id = 0 AND vnr.n_status = 0
AND vas.n_typ_id = 1
AND vz.n_verp_id = vas.n_id AND vz.n_verp_sub_id = vas.n_auftrag_id AND vz.n_verp_typ_id=150
AND vz.n_verp_id = vnr.n_verp_id AND vz.n_verp_sub_id = vnr.n_verp_sub_id AND vz.n_verp_typ_id=vnr.n_verptyp_id AND vz.c_nr = vnr.c_nr
AND vas.n_auftrag_id = a.n_id
AND vnr.n_verrechnet = 0
GROUP BY 1,2,3,4,5,6,4,8,10,11,12,13

UNION


SELECT DISTINCT vz.n_verp_id, vz.n_verp_sub_id, vz.n_verp_typ_id, a.n_land_id,
-10 AS n_holzbehandlung_id, a.n_kunde_id, p.verp_auftrag_id, vz.c_nr_org, MAX(vz.n_type_id) AS n_type_id, p.verp_mattyp_id AS n_mattyp_id,
IF (p.verp_verpacken = 1, 1, IF (p.verp_seem, 1, 0)) AS verpacken,
0 AS n_ispm,
IF (vnr.d_fertig IS NULL, 0, 1) AS n_fertig, p.verp_nr AS verp_nr, c.d_start, vz.d_datetime AS erstellt
FROM t_verpackung_zeiten vz, t_packmittel_gebraucht_details p, t_auftrag a, t_verpackung_nr_list vnr LEFT JOIN t_event_calendar c ON vnr.c_abhollief_termin = c.c_id
WHERE vz.n_type_id = 0 AND vnr.n_status = 0
AND vz.n_verp_id = p.n_id AND vz.n_verp_sub_id = 0 AND vz.n_verp_typ_id=p.verp_typ
AND vz.n_verp_id = vnr.n_verp_id AND vz.n_verp_sub_id = vnr.n_verp_sub_id AND vz.n_verp_typ_id=vnr.n_verptyp_id AND vz.c_nr = vnr.c_nr
AND p.verp_auftrag_id = a.n_id
AND vnr.n_verrechnet = 0
GROUP BY 1,2,3,4,5,6,4,8,10,11,12,13
) p, t_firma f, t_auftrag a LEFT JOIN t_projekt pr ON a.n_projekt_id = pr.prj_id
WHERE a.n_id = p.n_auftrag_id
AND a.n_kunde_id = f.firmaKey
AND a.d_geloescht IS NULL

[0|DISCONNECT|RECV_FROM_SERVER|10054]
[0|TRANSFER|127.0.0.1->18314]
[0|DISCONNECT|SEND_TO_SERVER|10054]
[SESSION_CLOSED|0]

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Mon 19 Apr 2010 13:59

Please contact us by dmitryg*devart*com email, we'll send you a custom build.

Post Reply