- Community Home
- >
- Networking
- >
- Legacy
- >
- Switches, Hubs, Modems
- >
- PCM+ 3.00.106 database problem
-
-
Categories
- Topics
- Hybrid IT with Cloud
- Mobile & IoT
- IT for Data & Analytics
- Transformation
- Strategy and Technology
- Products
- Cloud
- Integrated Systems
- Networking
- Servers and Operating Systems
- Services
- Storage
- Company
- Events
- Partner Solutions and Certifications
- Welcome
- Welcome
- Announcements
- Tips and Tricks
- Feedback
-
Blogs
- Alliances
- Around the Storage Block
- Behind the scenes @ Labs
- Converged Data Center Infrastructure
- Digital Transformation
- Grounded in the Cloud
- HPE Careers
- HPE Storage Tech Insiders
- Infrastructure Insights
- Inspiring Progress
- Internet of Things (IoT)
- My Learning Certification
- Networking
- OEM Solutions
- Servers: The Right Compute
- Telecom IQ
- Transforming IT
-
Quick Links
- Community
- Getting Started
- FAQ
- Ranking Overview
- Rules of Participation
- Contact
- Email us
- Tell us what you think
- Information Libraries
- Integrated Systems
- Networking
- Servers
- Storage
- Other HPE Sites
- Support Center
- Enterprise.nxt
- Marketplace
- Aruba Airheads Community
-
Categories
-
Forums
-
Blogs
-
InformationEnglish
PCM+ 3.00.106 database problem
SOLVED- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-16-2009 03:37 AM
12-16-2009 03:37 AM
PCM after login sends this alert:
12/16/2009 12:10:24 - ProCurve Manager is no longer receiving events or traps.
....
SQL Exception
Table '.\netmgmt\networkevent' is marked as crashed and last (automatic?) repair failed
How could I repair the table?
PCM doesn't work very well now!
Thanks
Massimo Poletti
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-16-2009 08:05 AM
12-16-2009 08:05 AM
Re: PCM+ 3.00.106 database problem
Re: PCM+ 3.00.106 database problem
using mysqlcheck (see http://forums13.itrc.hp.com/service/forums/questionanswer.do?admit=109447627+1260976766746+28353475&threadId=1282351)
I'm able to check:
netmgmt.networkevent
warning : Table is marked as crashed and last repair failed
error : Found 1683 keys of 1682
error : Corrupt
but not to repair (-r switch):
Repairing tables
C:\Program Files\Hewlett-Packard\PNM\server\mysql\bin\mysqlcheck.exe: Got error:
1142: INSERT command denied to user 'mpoletti'@'localhost' for table 'networkev
ent' when executing 'REPAIR TABLE ... '
Suggestions?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-16-2009 03:46 PM
12-16-2009 03:46 PM
Re: PCM+ 3.00.106 database problem
Re: PCM+ 3.00.106 database problem
You can try the following steps to see if they work. I can't guarantee success but I acquired these from some of the PCM engineers that have worked with similar issues before.
** Back up the event tables shown in the Message Notification. For example if the table name in the popup dialog refers to NetworkEvent table, then back up all SERVER_INSTALL_DIR/mysql/data/netmgmt/NetworkEvent.* files (where SERVER_INSTALL_DIR is the server subdirectory wherever you've installed PCM).
** Open a DOS shell by click Start->Run and enter 'cmd'.
** In the DOS shell, cd to SERVER_INSTALL_DIR/mysql/bin.
** Enter "mysql -u Administrator -password=PASSWORD -P 3908 netmgmt" (where PASSWORD is the password for your mySQL Administrator account, set up during your PCM installation).
** Enter "check table TABLENAME" (where TABLENAME is the table backed up earlier; NetworkEvent, SyslogEvent or IdmEvent).
** Wait for the check command to finish. If it returns OK then the problem is fixed.
** If the check command fails see if SERVER_INSTALL_DIR/mysql/data/netmgmt/TABLENAME.MYD exists. If not copy SERVER_INSTALL_DIR/mysql/data/netmgmt/TABLENAME.TMD to SERVER_INSTALL_DIR/mysql/data/netmgmt/TABLENAME.MYD.
** Rerun "check table TABLENAME" and it should return OK in the Status column.
** If this fails then check again to make sure TABLENAME.MYD exists (as above), then run "repair table TABLENAME" again.
---
Note:
** Depending on the severity of the table corruption, sometimes one needs to execute "repair table TABLENAME" more than once. Run "check table TABLENAME" to get more details on the table status after each repair statement.
** If the problem still exists after few runs of "repair table TABLENAME" try the following special repair statement using flag use_frm: "repair table TABLENAME use_frm"
** If the table is still not fixed you may need to stop and restart the PCM Data Store service (the mySQL server) and repeat the steps above.
Note that this situation can be caused by antivirus software checking the mySQL directory of the PCM server; you should disable such checking if it's enabled (the virus checked locks the files that mySQL is using and this causes the issue).
Good luck! I hope this works for you.
SVB
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-18-2009 07:47 AM
12-18-2009 07:47 AM
Re: PCM+ 3.00.106 database problem
Re: PCM+ 3.00.106 database problem
Using the password of PCM+ user "Administrator" i cannot enter in mysql.
Is the PCM+ Administrator the same as mysql Administrator?
If not I have a lost password problem...
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-22-2009 02:52 AM
12-22-2009 02:52 AM
Re: PCM+ 3.00.106 database problem
Re: PCM+ 3.00.106 database problem
May I take an empty networkevent table from a fresh install of a unregistered PCM+ instead of the crashed one?
Could it works?
Thanks
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-04-2010 02:10 PM
01-04-2010 02:10 PM
SolutionSorry I didn't reply earlier - our company was shut down for two weeks over the holidays. The database password is a derivative of your PCM password. If you email me directly I will tell you how to derive the database password, as I don't want to post this information publicly. My email address is steve.britt@hp.com.
Regards,
SVB
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-08-2010 05:37 AM
01-08-2010 05:37 AM
Re: PCM+ 3.00.106 database problem
Re: PCM+ 3.00.106 database problem
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
02-22-2010 03:25 AM
02-22-2010 03:25 AM
Re: PCM+ 3.00.106 database problem
Re: PCM+ 3.00.106 database problem
We also get this error on our PNM installation. And i tried to login and do a repair but it wont accept my username or password.
Steve Britt or Massimo Poletti can you please email me how to derive the database password?!
Regards Markus Jidevåg Lysekils kommun Sweden
markus.jidevag@lysekil.se
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
02-23-2010 12:03 AM
02-23-2010 12:03 AM
Re: PCM+ 3.00.106 database problem
Re: PCM+ 3.00.106 database problem
I suppose Steve can help you.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
02-23-2010 10:24 AM
02-23-2010 10:24 AM
Re: PCM+ 3.00.106 database problem
Re: PCM+ 3.00.106 database problem
I responded directly to Markus.
Regards,
SVB
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-07-2010 11:02 PM
06-07-2010 11:02 PM
Re: PCM+ 3.00.106 database problem
Re: PCM+ 3.00.106 database problem
Could you please inform me how to get the administrator password ?
Kind regards
Lars Jacobsen
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-08-2010 10:36 AM
06-08-2010 10:36 AM
Re: PCM+ 3.00.106 database problem
Re: PCM+ 3.00.106 database problem
Please email me directly at steve.britt@hp.com and I will respond directly with the requested information.
Regards,
SVB
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-11-2010 12:04 AM
06-11-2010 12:04 AM
Re: PCM+ 3.00.106 database problem
Re: PCM+ 3.00.106 database problem
12 points from the Danish Jury :-)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-21-2010 05:04 AM
10-21-2010 05:04 AM
Re: PCM+ 3.00.106 database problem
Re: PCM+ 3.00.106 database problem
In case of corrupt PCM database it's best to contact your local support. Either submit a web case through My Networking portal (http://my.procurve.com/) or call your local support center. Telephone numbers:
United States: 1-866-MY-PROCURVE (866-697-7628)
Canada: 1-800-HP-INVENT (1-800-474-6836)
(When prompted for the complete product name, just say "ProCurve.")
EMEA: http://h40060.www4.hp.com/procurve/support_direct.html
AsiaPacific: http://h10144.www1.hp.com/asiapacific-support/
HTH,
Arimo Laine
HPN GCC Support Engineer
HTH,
Arimo
HPE Networking Engineer
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-26-2011 11:50 AM
08-26-2011 11:50 AM
Re: PCM+ 3.00.106 database problem
Re: PCM+ 3.00.106 database problem
I have the same problem. And I contacted support. My case has been open for over 2 weeks now. My drive is filling up with all those temp event files.
I'm more than able to do the fix as described but as with others do not know how to derive the password. Steve?
Neil
Hewlett Packard Enterprise International
- Communities
- HPE Blogs and Forum
© Copyright 2018 Hewlett Packard Enterprise Development LP