SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Mysql - ODBC - Enable Audit problem

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Mysql - ODBC - Enable Audit problem
Author Message
alpha



Joined: 20 Aug 2008
Posts: 1
Country: Belgium

Post Mysql - ODBC - Enable Audit problem Reply with quote
I have installed the DB audit program but when I click on 'Enable Audit' I get the error:

Code:
DB Audit's procedures failed to start. Check server log...


In the server log I only get:

Code:
DB Audit: Error: Audit settings load failed


This doesn't make me much wiser.

The server is linux using mysql 5.0.51 (latest Ubuntu version) and I connect though mysql ODBC 5.1 on Vista Basic. The ODBC works. I copied the libraries to the correct location and in the server startup I get:

Code:
Aug 20 12:06:35 tom-desktop mysqld_safe[12291]: started
Aug 20 12:06:35 tom-desktop mysqld[12295]: 080820 12:06:35  InnoDB: Started; log sequence number 0 43675
Aug 20 12:06:35 tom-desktop DB Audit: Info: Audit library loaded.
Aug 20 12:06:35 tom-desktop DB Audit: Info: Audit initialization has started.
Aug 20 12:06:35 tom-desktop kernel: [ 8515.277782] audit(1219226795.255:8): type=1503 operation="inode_permission" requested_mask="::r" denied_mask="::r" name="/proc/12293/cmdline" pid=12305 profile="/usr/sbin/mysqld" namespace="default"
Aug 20 12:06:35 tom-desktop DB Audit: Warning: No option files loaded. Default settings will be used.
Aug 20 12:06:35 tom-desktop DB Audit: Debug: Connection: <init> start
Aug 20 12:06:35 tom-desktop DB Audit: Debug: Connector: <init> start
Aug 20 12:06:35 tom-desktop mysqld[12295]: 080820 12:06:35 [Note] /usr/sbin/mysqld: ready for connections.
Aug 20 12:06:35 tom-desktop mysqld[12295]: Version: '5.0.51a-3ubuntu5.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
Aug 20 12:06:35 tom-desktop DB Audit: Debug: Connector: <init> end
Aug 20 12:06:35 tom-desktop DB Audit: Debug: Connection: <init> end
Aug 20 12:06:35 tom-desktop DB Audit: Debug: Connection: connect start
Aug 20 12:06:35 tom-desktop DB Audit: Debug: Connector: connect start
Aug 20 12:06:35 tom-desktop DB Audit: Error: Access denied for user 'db_audit'@'localhost' (using password: YES)
Aug 20 12:06:35 tom-desktop DB Audit: Debug: Connector: connect end
Aug 20 12:06:35 tom-desktop DB Audit: Error: Can't connect to the server. Error:
Aug 20 12:06:35 tom-desktop DB Audit: Debug: Connection: connect end
Aug 20 12:06:36 tom-desktop /etc/mysql/debian-start[12334]: Upgrading MySQL tables if necessary.
Aug 20 12:06:36 tom-desktop /etc/mysql/debian-start[12344]: Looking for 'mysql' in: /usr/bin/mysql
Aug 20 12:06:36 tom-desktop /etc/mysql/debian-start[12344]: Looking for 'mysqlcheck' in: /usr/bin/mysqlcheck
Aug 20 12:06:36 tom-desktop /etc/mysql/debian-start[12344]: This installation of MySQL is already upgraded to 5.0.51a, use --force if you still need to run mysql_upgrade
Aug 20 12:06:36 tom-desktop /etc/mysql/debian-start[12349]: Checking for insecure root accounts.
Aug 20 12:06:36 tom-desktop /etc/mysql/debian-start[12353]: Checking for crashed MySQL tables.


So the libraries load ok. There is a password error, but I don't know what it should be? If I change it and connect with it on the localhost it works perfect.

I don't know where to look anymore... I have even set up a brand new windows XP with mysql server (5.0) and installed the audit on the same computer. This gave me exactly the same error. I have also tried the older ODBC (3.51), but also to no avail...

Anybody has a hint on where to look next?
Wed Aug 20, 2008 6:16 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
I think your are confusing several things. DB Audit console is just a management and reporting tool. It doesn't matter which connection you are using on your Windows system, ODBC or not ODBC - this is all irrelevant. The auditing is run in the server side and that's where you have a problem.

In order to help you, I need to know a little more about your environment.

Which exact version of MySQL is on the Linux box? Is that a 32-bit or 64-bit version?

Which user account is running MySQL instance?

Did you change default password or audit settings for db_audit user? Try resetting the db_audit user password to IAUDIT and restarting the MySQL instance. Please let us know if you still get the same error or you get a different error.
Wed Aug 20, 2008 9:25 am View user's profile Send private message
ideascreen



Joined: 05 Oct 2008
Posts: 1
Country: Malaysia

Post Reply with quote
I have been getting the same error message when enabling the sytem audit.
'DB Audit's procedures failed to start. Check server log...'

I'm using MySQL for Windows v5.0.51b on Windows Vista (32bit) and connect using mysql ODBC. I'm using root@localhost user to connect. I have copied the 3 dll libraries to mysql\bin folder.

When i start mysql, i got this error message

081005 15:12:01 1 Connect Access denied for user 'db_audit'@'localhost' (using password: YES)
C:\xampplite\mysql\bin\mysqld-nt.exe, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with:
TCP Port: 3306, Named Pipe: C:/xampplite/mysql/mysql.sock
Time Id Command Argument
081005 15:13:12 1 Connect Access denied for user 'db_audit'@'localhost' (using password: YES)

I have changed the db_audit user password to IAUDIT but with failure. I also try to change password under the authentication tab in the set system audit options, but it prompted for another error and shutdown mysql service.
'Unable to change authentication settings for the audit process!'

How should i proceed?
Sun Oct 05, 2008 3:21 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
1. Please reset the password back to IAUDIT
2. Ensure Access 'db_audit'@'localhost' account has connect privileges for the server - use this account with MySQL Query Browser to verify it can connect

Thant should do it.
Sun Oct 05, 2008 10:35 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.