Re: [Database-devel] Problem with nessus_sql 2.2.3

the Moonspeller wrote:

> 
> When looking into nessusd.messages...
> 

(...)
> [Sun Jun  5 12:36:37 2005][3272] SQL : find by name: "onyxium-gif"
> [Sun Jun  5 12:36:37 2005][3272] MYSQL: SELECT hostid FROM host WHERE 
> name="onyxium-gif" : Lost connection to MySQL server during query : 
> can't select row
> [Sun Jun  5 12:36:37 2005][3272] MATCHED HOSTID: [-1]
> 

Ummm... seems to be a problem when retrieving information from the 
database. Can you please provide the result of running the SQL query 
above: 'SELECT hostid FROM host WHERE name="onyxium-gif"'

Also, it might be worth checking how the database has been changed 
since the scan started. Has the 'session' table been modified?

The scan bails out because it lose a connection to the MySQL server, 
the database code currently does not attempt to reconnect in this 
event and that causes the abrupt en of the scan.

If some of the tables were filled in but the code failed in this 
change it might be due to connection timeout in the MySQL database. 
The Nessus-SQL code does not explicitly set a timeout so you should be 
able to handle this through MySQL's configuration file.

Regards

Javier

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