Solved

WebTrends Enterprise 7.5 scheduler error

Posted on 2009-04-13
5
760 Views
Last Modified: 2013-12-07
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
Comment
Question by:usdm
  • 3
5 Comments
 
LVL 28

Expert Comment

by:Dan McFadden
ID: 24138058
I would read thru this forum post:  http://www.webmasterworld.com/forum39/3561.htm.
0
 

Author Comment

by:usdm
ID: 24138159
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
 
LVL 28

Expert Comment

by:Dan McFadden
ID: 24138293
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
 
LVL 28

Accepted Solution

by:
Dan McFadden earned 500 total points
ID: 24138454
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

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When it comes to write a Context Sensitive Help (an online help that is obtained from a specific point in state of software to provide help with that state) ,  first we need to make the file that contains all topics, which are given exclusive IDs. …
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question