ArmedAndClueless
MIS
I've been using the perfmon tool on Server 2k3, to keep an eye on things. After getting around 20 of those .blg files, however, things start getting a bit nasty. I decided to try to move to SQL logging as a cleaner method. However, I hit a brick wall. After making a new database called perfmon, creating the necessary System DSN info, configuring the logging, and starting it, it blows up and says that it is unable to start logging. I have both MyODBC 3.51.12 and 5.00.09 beta connectors installed. When I use 3.51, I get these two events:
Event Type: Warning
Event Source: SysmonLog
Event Category: None
Event ID: 2004
Date: 11/23/2006
Time: 10:30:31 PM
User: N/A
Computer: SHATTERED-APP01
Description:
The service was unable to open the log file SQL
erfmon!System_000001 for log System and will be stopped. Check the log folder for existence, spelling, permissions, and ensure that no other logs or applications are writing to this log file. You can reenter the log file name using the configuration program. This log will not be started. The error returned is: The returned data is valid.
.
Event Type: Error
Event Source: PDH
Event Category: None
Event ID: 3041
Date: 11/23/2006
Time: 10:30:31 PM
User: N/A
Computer: SHATTERED-APP01
Description:
The description for Event ID ( 3041 ) in Source ( PDH ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: [MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: NO).
Data:
0000: 15 04 ..
On the 5.00.09 connector, I get these:
Event Type: Warning
Event Source: SysmonLog
Event Category: None
Event ID: 2004
Date: 11/24/2006
Time: 3:17:59 PM
User: N/A
Computer: SHATTERED-APP01
Description:
The service was unable to open the log file SQLerfmon!perfmon_000015 for log System and will be stopped. Check the log folder for existence, spelling, permissions, and ensure that no other logs or applications are writing to this log file. You can reenter the log file name using the configuration program. This log will not be started. The error returned is: The returned data is valid.
.
For more information, see Help and Support Center at Data:
0000: 00 00 00 00 ....
Event Type: Error
Event Source: PDH
Event Category: None
Event ID: 3041
Date: 11/24/2006
Time: 3:17:59 PM
User: N/A
Computer: SHATTERED-APP01
Description:
The description for Event ID ( 3041 ) in Source ( PDH ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: .
Data:
0000: 00 00 ..
I've been beating my brains out on this one. I'm not sure if the two connectors are having the same issue. Any ideas?
Event Type: Warning
Event Source: SysmonLog
Event Category: None
Event ID: 2004
Date: 11/23/2006
Time: 10:30:31 PM
User: N/A
Computer: SHATTERED-APP01
Description:
The service was unable to open the log file SQL
erfmon!System_000001 for log System and will be stopped. Check the log folder for existence, spelling, permissions, and ensure that no other logs or applications are writing to this log file. You can reenter the log file name using the configuration program. This log will not be started. The error returned is: The returned data is valid..
Event Type: Error
Event Source: PDH
Event Category: None
Event ID: 3041
Date: 11/23/2006
Time: 10:30:31 PM
User: N/A
Computer: SHATTERED-APP01
Description:
The description for Event ID ( 3041 ) in Source ( PDH ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: [MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: NO).
Data:
0000: 15 04 ..
On the 5.00.09 connector, I get these:
Event Type: Warning
Event Source: SysmonLog
Event Category: None
Event ID: 2004
Date: 11/24/2006
Time: 3:17:59 PM
User: N/A
Computer: SHATTERED-APP01
Description:
The service was unable to open the log file SQL
erfmon!perfmon_000015 for log System and will be stopped. Check the log folder for existence, spelling, permissions, and ensure that no other logs or applications are writing to this log file. You can reenter the log file name using the configuration program. This log will not be started. The error returned is: The returned data is valid..
For more information, see Help and Support Center at Data:
0000: 00 00 00 00 ....
Event Type: Error
Event Source: PDH
Event Category: None
Event ID: 3041
Date: 11/24/2006
Time: 3:17:59 PM
User: N/A
Computer: SHATTERED-APP01
Description:
The description for Event ID ( 3041 ) in Source ( PDH ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: .
Data:
0000: 00 00 ..
I've been beating my brains out on this one. I'm not sure if the two connectors are having the same issue. Any ideas?