Burton,
Thanks for your reply.
Are there any Debug flags that I can activate that would give us some
insight as to what is causing the problems?
JRD
On Fri, 28 Jun 2002, Burton Strauss wrote:
> Actually one idea:
>
> INSERT INTO TCPsessions (Client, Server,
> ClientPort, ServerPort, DataSent, DataRcvd, FirstSeen, LastSeen)
> VALUES ('10.10.80.83', '10.10.1.181', '1248', '80', '0',
> '1078198272', '(null)', '(null)')
>
> Check the data types in the table - '1078198272' might be too large (32bit ints??)
>
> Otherwise, not a clue... I'm guessing that the multi-threaded nature of a DBMS will
>make a MinGW port unlikely!
>
> But, now you know why test pilots sit in ejection seats...
>
> ------Burton
>
>
> ---------- Original Message ----------------------------------
> From: Juan Ramon Duarte <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Fri, 28 Jun 2002 11:46:05 +0100 (BST)
>
> >
> >Hi,
> >
> >I've managed to include mySQL support into a Windows compile of NTop.
> >But I have two problems:
> >
> >1. It crashes even more frequently (sometimes within 5 seconds of
> > starting) than without database support.
> > This is not very consistent but many times it crashes just after
> > this line in the console:
> >
> >
> > 28/Jun/2002 11:22:33 INSERT INTO TCPsessions (Client, Server,
> > ClientPort, ServerPort, DataSent, DataRcvd, FirstSeen, LastSeen)
> > VALUES ('10.10.80.83', '10.10.1.181', '1248', '80', '0',
> > '1078198272', '(null)', '(null)')
> >
> >
> >I can see that the Access database is being populated. All tables
> >except 'TCPSessions' now contain data. This seems consistent with
> >NTop crashing every time it tries to insert into TCPSessions.
> >
> >
> >I have only seen one error in the mySQLServer.pl console:
> >
> > INSERT INTO TCPsessions (Client, Server, ClientPort, ServerPort,
> > DataSent, DataRcvd, FirstSeen, LastSeen) VALUES ('10.10.80.83',
> > '10.10.1.181', '1248', '80', '0', '1078198272', '(null)', '(null)')
> > DBD::ODBC::db do failed: [Microsoft][ODBC Microsoft Access Driver]
> > Data type mismatch in criteria expression. (SQL-22005)(DBD:
> > st_execute/SQLExecute err=-1) at mysqlserver.pl line 61.
> >
> >Again, consistent in being related to 'TCPSessions'.
> >
> >
> >2. I would like to compile NTop using MinGW but haven't been able
> >for lack of the mysql libraries.
> >The closest I've come is by using the 'libmysqlclient MinGW port'
> >found at http://www.johnydog.cz/projects.php
> >
> >Any pointers?
> >
> >
> >
> >My current configuration is:
> >
> >- Win 2000
> >
> >- NTop compiled with VC++ 6.0
> >
> >- mySQL support added through compiling against include files
> > and the DLL provided in the mysql++ API package (downloaded
> > from www.mysql.com)
> >
> >- mySQLSever.pl, modified to connect via ODBC
> >
> >- ntop -> mySQLServer.pl -> ODBC -> ntop.mdb
> >
> >
> >Regards,
> >
> >JRD
> >
> >_______________________________________________
> >Ntop-dev mailing list
> >[EMAIL PROTECTED]
> >http://lists.ntop.org/mailman/listinfo/ntop-dev
> >
>
>
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
> http://www.doteasy.com
> _______________________________________________
> Ntop-dev mailing list
> [EMAIL PROTECTED]
> http://lists.ntop.org/mailman/listinfo/ntop-dev
>
_______________________________________________
Ntop-dev mailing list
[EMAIL PROTECTED]
http://lists.ntop.org/mailman/listinfo/ntop-dev
