[Database-devel] Issue with nessus sql in 2.2.4

Javier,

I added your latest db patch to nessus 2.2.4 which compiled fine.

Whenever I start nessusd the first nessus scan seems to hang. In the db 
I get a single entry for a new session indicating that the scan started 
but with a NULL endtime (which is ok at this stage ;)

The nessus client doesn't even show any indicator of portscan or check.

In this stage nessus.messages states:
Sat Jul  2 19:04:31 2005][6857] nessusd 2.2.4. started
[Sat Jul  2 19:05:35 2005][6857] connection from 127.0.0.1
[Sat Jul  2 19:05:35 2005][6865] Client requested protocol version 12.
[Sat Jul  2 19:05:35 2005][6865] successful login of root from 127.0.0.1
[Sat Jul  2 19:06:09 2005][6865] Redirecting debugging output to 
/var/nessus/logs/nessusd.dump
[Sat Jul  2 19:07:04 2005][6865] MYSQL : connected to DB host: localhost
[Sat Jul  2 19:07:04 2005][6865] Error ! max_hosts = 0 -- check 
/etc/nessus/nessusd.conf
[Sat Jul  2 19:07:04 2005][6865] user root starts a new scan. Target(s) 
: 192.168.2.1, with max_hosts = 5 and max_checks = 10
[Sat Jul  2 19:07:04 2005][6865] user root : testing 192.168.2.1 
(192.168.2.1) [6868]
[Sat Jul  2 19:07:04 2005][6868] SQL : find by name: "router"

Nothing more.
Then when I kill the according nessusd process the session table is 
updated and some additional entries in nessusd.messages are logged:
[Sat Jul  2 19:16:44 2005][6865] user root : test complete
[Sat Jul  2 19:16:44 2005][6865] DATABASE: closed DB connection
[Sat Jul  2 19:16:44 2005][6865] user root : Kept alive connection

Further scans are no longer logged to the db, and nessusd.messages states:
[Sat Jul  2 19:18:21 2005][6920] DATABASE: can't add host, no DB connection

Nothing's written to the db but from now the scan is run (showing 
indicators for portscan and checks as expected).

My setup is:
Fedora Core 3
mysql-3.23.58-16.FC3.1
kernel 2.6.11-1.14_FC3smp on a P4 with HT enabled

Any idea?

Thanks,
Sandro
-- 
"Linux is like a wigwam: no windows, no gates ... apache inside!"

http://www.lug-burghausen.org/
_______________________________________________
Nessus-devel mailing list
[email protected]
http://mail.nessus.org/mailman/listinfo/nessus-devel