Websense Explorer Debug Mode to diagnose database connection issues

Error: Unable to get into “Database Administration.” Trying to access enterprise explorer or database admin gives the message "Couldn’t connect to database".

Diagnostics: To reproduce the error, then in the address bar add "&gubed=1"

This puts Explorer into Debug Mode.

Likely issues and solutions: 

  1. A partition isn’t able to be accessed (such as wslogdb63_2) likely caused by permissions.  Check to see if the database referenced in there is owned by the windows user, or if it is owned by something else.  The easiest thing to do is to give the Windows user sysadmin role in SQL so it can access all the databases.  Otherwise, you will need to give that user access and/or db owner each new database that Websense ETL job makes when it reaches the rollover period.
  2. Explorer and database administrator probably can’t connect to database since IIS or Apache HTTPD server isn’t running with that Windows trusted account you’re using (assuming you’re using a Windows trusted account for SQL access).

Outcome: Although this steps above may allow you to enter “Database Administration,” when you next try access “Websense Enterprise Explorer,” you may receive the following error…

Can’t call method "EOF" on an undefined value at /PerlApp/dbi_wrapper.pm

Possible solution…

  1. reproduce the error, then in the address bar add "&gubed=1"
  2. This puts Explorer into Debug Mode.
  3. What’s likely happening is that a partition isn’t able to be accessed (such as wslogdb63_2) likely caused by permissions.
  4. Check to see if the database referenced in there is owned by the windows user, or if it is owned by something else.  The easiest thing to do is to give the Windows user sysadmin role in SQL so it can access all the databases.  Otherwise, you will need to give that user access and/or db owner each new database that Websense ETL job makes when it reaches the rollover period.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: