Solved

WebTrends Enterprise 7.5 scheduler error

Posted on 2009-04-13
5
761 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

Question has a verified solution.

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

Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
Although a lot of people devote their energy toward marketing for specific industries, there are some basic principles that can be applied to any sector imaginable. We’ll look at four steps to take and examine how those steps were put into action fo…
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

734 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