SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Database connection problem

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Database connection problem
Author Message
pkuoh



Joined: 03 Oct 2008
Posts: 10

Post Database connection problem Reply with quote
Hi,

I was trying to add a new database server profile to repository (from DB audit console), and encountered the below problem:

"Alert Center Error: Unable to add audit log archiving job... the database connection is not configure yet...."
Can you help, or provide me a documentation on such setup.

Thanks!
Tue Oct 14, 2008 9:45 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
Hi,

You should be getting some other error or warning message before this error. What is that? Please describe step-by-step what you are doing and what you are getting, so that I can pinpoint where things are going wrong.
Tue Oct 14, 2008 10:19 am View user's profile Send private message
pkuoh



Joined: 03 Oct 2008
Posts: 10

Post Reply with quote
Can you provide me an email address that I can send the detail step. I have problem uploading any file to this website (block from my company).
Tue Oct 14, 2008 10:23 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
Please email them to our support email. You can find the link in the Help/About menu
Tue Oct 14, 2008 10:31 am View user's profile Send private message
pkuoh



Joined: 03 Oct 2008
Posts: 10

Post Reply with quote
Sent. File name is Steps.mac, it records the steps I perform and the error I got.
Tue Oct 14, 2008 10:43 am View user's profile Send private message
pkuoh



Joined: 03 Oct 2008
Posts: 10

Post Reply with quote
Hi,

After gettting help from your support Dmitriy Evinshteyn, I am able to setup the repository. However the periodic "Audit Log Archiving Job" that run on the 24x7 Scheduler failed with the below error (ERROR: Unable to connect to Alert Center. null).

Please help.

=========================================
Connecting to Alert Center...

******************************************************
* Copyright (C) 2000-2007 SoftTree Technologies, Inc.*
******************************************************
* 24x7 Scheduler Java API v4.1. *
******************************************************
* Unauthorized use or distribution of this program *
* may result in severe civil and criminal penalties, *
* and will be prosecuted to the maximum extent *
* possible under the law. *
******************************************************

ERROR: Unable to connect to Alert Center. null
Tue Oct 21, 2008 5:01 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
Is the "localhost" setup correctly on your server? The "Audit Log Archiving Job" is trying to connect to the Alert Center server on localhost, port 1097 and failing. There could be 4 possible reasons for this error:

1. The "localhost" cannot be resolved properly and that should be fixed on the system level. You can verify that by pinging it from the command line "ping localhost"

2. Alert Center is not listening for connections. This would be very unusual but can happen if the default settings have been somehow modified

3. Wrong Java version is used for running the Alert Center and/or visible to the job. The Job is started using "java" command in the command line without specific path. Java versions are incompatible and in case wrong version is used various anomalies can occur.

4. And finally user authentication fails. You can check this in the schedule.log file. Look for "User authentication failed" or similar messages.
Tue Oct 21, 2008 5:13 pm View user's profile Send private message
pkuoh



Joined: 03 Oct 2008
Posts: 10

Post Reply with quote
Hi,

I think it may be the user authorization problem. I took your advice and check the scheduler.log file, and found the below:

----------------------------------------------------------------------------------------------------------------------------------------------
10/21/2008 07:00:02 PM 2 null null 24x7 Scheduler User [DB Audit ALERT JOB #8] connected from 127.0.0.1
10/21/2008 07:00:02 PM 3 null null 24x7 Scheduler Authorization for user [DB Audit ALERT JOB #8] has failed
10/21/2008 07:01:07 PM 2 null null 24x7 Scheduler User DB Audit connected from 167.170.120.20
10/21/2008 07:02:56 PM 2 null null 24x7 Scheduler User DB Audit disconnected
10/21/2008 08:00:01 PM 2 null null 24x7 Scheduler User [DB Audit ALERT JOB #8] connected from 127.0.0.1
10/21/2008 08:00:02 PM 3 null null 24x7 Scheduler Authorization for user [DB Audit ALERT JOB #8] has failed
10/21/2008 08:53:01 PM 2 null null 24x7 Scheduler User [DB Audit ALERT JOB #8] connected from 127.0.0.1
10/21/2008 08:53:02 PM 3 null null 24x7 Scheduler Authorization for user [DB Audit ALERT JOB #8] has failed
----------------------------------------------------------------------------------------------------------------------------------------------
Wed Oct 22, 2008 9:12 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
Hi,

On which system type are you running the Alert Center?
Wed Oct 22, 2008 9:50 am View user's profile Send private message
pkuoh



Joined: 03 Oct 2008
Posts: 10

Post Reply with quote
AIX Unix.
Wed Oct 22, 2008 9:52 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
This is may take a little wait to figure out. I'll get back to you as soon as I have something for you.
Wed Oct 22, 2008 11:08 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.