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
