Using MySQL 4.1 With Nsure Audit

(Last modified: 23Dec2005)

This document (10096853) is provided subject to the disclaimer at the end of this document.

goal

fact

Novell Nsure Audit 1.0.3

symptom

Client does not support authentication protocol requested by server; consider upgrading MySQL client

Error returned when loading Lengine

Error: java.sql.SQLException: Base table or view not found message from server: "Table 'naudit.log' doesn't exist"

Nsure Audit MySQL: Client does not support authentication protocol requested by server; consider upgrading MySQL client 1251

Nsure Audit MySQL: USE: MySQL server has gone away 2006

Nsure Audit MySQL: The table "log" needs to be renamed. The attempt to rename it failed.

Nsure Audit: Could not initialize logging subsystem; aborting.

cause

The libraries used by Nsure Audit to connect to MySQL are from version 4.0. MySQL made the database more secure in version 4.1, by increasing the password hash from 16 bytes to 41 bytes. This changed made it so that older clients cannot connect to MySQL 4.1

fix

Working around this issue is very simple.

After setting up the auditusr account with the grant statements from the Nsure Audit documentation and setup TIDs, change the password using the following command:

SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass');

In common MySQL configurations for Nsure Audit, this would generally be something like

SET PASSWORD FOR 'auditusr'@'localhost' = OLD_PASSWORD('auditpwd');

OLD_PASSWORD tells MySQL 4.1 to create the password with the original 16 byte hash. The Nsure Audit logging server will be able to connect to MySQL 4.1 after making these changes.

note

Note the following from the MySQL site:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
upgrading MySQL client" occurs when the hashing-method for storing password used by the client differs from the one of the server. Typically it occurs when trying to connect to MySQL 4.1 or 5.x with a client compiled for 3.x or 4.

document

Document Title:	Using MySQL 4.1 With Nsure Audit
Document ID:	10096853
Solution ID:	NOVL101253
Creation Date:	04Mar2005
Modified Date:	23Dec2005
Novell Product Class:	Management Products

disclaimer

The Origin of this information may be internal or external to Novell. Novell makes all reasonable efforts to verify this information. However, the information provided in this document is for your information only. Novell makes no explicit or implied claims to the validity of this information.
Any trademarks referenced in this document are the property of their respective owners. Consult your product manuals for complete trademark information.