Solved

WebTrends Enterprise 7.5 scheduler error

Posted on 2009-04-13
5
754 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 26

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 26

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 26

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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Uploading files to the web server has become common part of almost any kind of web application. People use different technologies to solve this, but regardless of the technology used, it is always useful to have some kind of progress indicator shown…
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…
The viewer will learn how to count occurrences of each item in an array.

760 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now