• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 771
  • Last Modified:

WebTrends Enterprise 7.5 scheduler error

Hi All,

This one is going to be for you Webtrends folks out there:

We are running Webtrends Enterprise 7.5 and Webtrends Smart Data Collector on separate Windows 2003 servers.  Last week, we started getting errors when attempting to schedule profiles to run.  The error is:

Event ID: 100

WTMySQLService: Can't open file: 'wt_taskstatus.MYI'. (errno: 145)

Now, from what I have read, this is a MySQL issue and that running a repair command will fix this table.  My problem is that I am not sure what the database name, username, and password are.  I was not part of the initial installation and there was absolutely zero documentation provided from the last admin.  How do I go about retrieving the username and password for the database so that I can run the appropriate commands to repair the database table?

Thanks in advance,

Buc
0
usdm
Asked:
usdm
  • 3
1 Solution
 
Dan McFaddenSystems EngineerCommented:
I would read thru this forum post:  http://www.webmasterworld.com/forum39/3561.htm.
0
 
usdmAuthor Commented:
Thank you for the reply.  This article was the closest that I have found so far to addressing the problem.  Its a different table but the same error.  My problem is that I have no knowladge of what the MySQL admin and password are so that I can run the commands in the article.
0
 
Dan McFaddenSystems EngineerCommented:
I suggest that you call Webtrends if you have an active support contract.  Chances are that the username is typical... Administrator.  I had a similar issue in the early stages of deploying Webtrends, if I remember correctly, I may have had to reinstall.
0
 
Dan McFaddenSystems EngineerCommented:
I have never tried this before, but here is a link to reset a lost root (or in this case admin) password.  http://www.debianadmin.com/recover-mysql-database-root-password.html

mySQL on Windows guide; http://www.devside.net/guides/windows/mysql

I suggest the following process:
- backup webtrends and mySQL
- stop all Webtrends services
- stop mySQL services
- start mySQL in standalone mode without password
- run command to reset password
- shutdown mySQL in standalone
- start mySQL
- attempt to connect to the mySQL database with admin & new password
- if connection is works, you are back in business

Hope this helps.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now