- Community Home
- >
- Networking
- >
- Legacy
- >
- Switches, Hubs, Modems
- >
- PCM - No longer receiving events or traps
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- 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
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-17-2010 07:07 AM
тАО06-17-2010 07:07 AM
I have just started receiving the above error message from PCM+ 3.1.
I have followed the instruction about switching off AV as a possible cause, but it hasn't resolved the issue.
------------------------------------------
SQL Exception
Table '.\netmgmt\networkevent' is marked as crashed and last (automatic?) repair failed
-------------------------------------------
How do i go about repairing a possible faulty sql table?
cheers
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-17-2010 06:38 PM
тАО06-17-2010 06:38 PM
Re: PCM - No longer receiving events or traps
Try this:
** 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).
NOTE:--- The DB password is a derivative of the PCM Adminstrative password. To get the database administrator password, you would need to mail the PCM Administrator password to (javy@hp.com) or steve.britt@hp.com).
HTH
Javed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-18-2010 12:28 AM
тАО06-18-2010 12:28 AM
Re: PCM - No longer receiving events or traps
I can't connect to the DB and I don't remember setting a password for mysql during the install of PCM, so I'm guessing it's a default one???? I tried using the admin password for PCM.
The error i get when running the command is :-
---------------------------------------
c:\>mysql -u administrator -password=
---------------------------------------
ERROR 1045 <28000>: Access denied for user 'administrator'@'localhost'
Can i email you or steve for the DB password?
regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-18-2010 02:08 AM
тАО06-18-2010 02:08 AM
Re: PCM - No longer receiving events or traps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-19-2010 12:49 AM
тАО06-19-2010 12:49 AM
Re: PCM - No longer receiving events or traps
can you try this version of the command to login to mysql:
C:\PCM\server\mysql\bin> mysql -uAdministrator -padmin -P3908 netmgmt
(assuming the default password 'admin')
if the DB password is something else, then you can mail your PCM password to javy@hp.com & steve.britt@hp.com
HTH!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-21-2010 02:56 AM
тАО06-21-2010 02:56 AM
Re: PCM - No longer receiving events or traps
I tried the command you suggested, but it didn't work either. I got this error message: -
------------------------------------
C:\>mysql -uAdministrator -padmin-P3908 netmgmt
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
-------------------------------------
I iwll email you my administrator password and hopefully this will fix it.
Cheers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-21-2010 06:13 AM
тАО06-21-2010 06:13 AM
Solution"ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)"
is because the MySql service(HP ProCurve Datastore) has not been started. Can you start that and try?
Will check and reply to your mail shortly
HTH
Javed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-21-2010 07:23 AM
тАО06-21-2010 07:23 AM
Re: PCM - No longer receiving events or traps
That has worked. I can now connected to the DB. I will run the suggested fix for that table.
thx again for all your help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-30-2010 02:15 AM
тАО09-30-2010 02:15 AM