Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

WebTrends Enterprise 7.5 scheduler error

Posted on 2009-04-13
5
Medium Priority
?
764 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 2000 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

Looking for a new Web Host?

Lunarpages' assortment of hosting products and solutions ensure a perfect fit for anyone looking to get their vision or products to market. Our award winning customer support and 30-day money back guarantee show the pride we take in being the industry's premier MSP.

Question has a verified solution.

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

Because your company can’t afford for you to make SEO mistakes, you’ll want to ensure you’re taking the right steps each and every time you post a new piece of content. This list of optimization do’s and don’ts can help you become an SEO wizard.
Color can increase conversions, create feelings of warmth or even incite people to get behind a cause. If you want your website to really impact site visitors, then it is vital to consider the impact color has on them.
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:
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Suggested Courses

721 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