What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general.

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags


View all Tags

Could not connect to database: Database Server Error: #08S01Bad handshake

Votes:

0

PRTG couldn't trace MySQL Data using SQL-Expression which from Linux OS (Centos). Hook up to Windows based MySQL, PRTG is able to track MySQL but not in any Linux platform. However, PRTG is able to track SNMP traffic without an issue.

I have swapped different MySQL at different Linux Platform, but no luck. Is there a limitation on PRTG?

mysql prtg snmp

Created on Oct 11, 2012 8:58:59 AM



6 Replies

Votes:

0

Hi,
what mySQL version are you running on the Linux Systems and what precise PRTG version are you using?
Best regards

Created on Oct 11, 2012 9:01:46 AM by Konstantin Wolff [Paessler Support]

Last change on Oct 11, 2012 4:27:45 PM by Konstantin Wolff [Paessler Support]



Votes:

0

mySQL version: 5.5.16
PRTG version: PRTG Network Monitor 8.4.2.2381

Created on Oct 15, 2012 2:17:18 AM

Last change on Oct 15, 2012 6:37:23 AM by Konstantin Wolff [Paessler Support]



Votes:

0

Hi,
I'm afraid it is not possible to monitor MySQL versions bigger than 5.1 with this version of PRTG. MySQL changed the authentication algorithm and therefore we changed PRTG version 9 to fit the new requirements.
So you will have to update your PRTG to monitor MySQL in the version you are using.
Best regards

Created on Oct 15, 2012 6:37:44 AM by Konstantin Wolff [Paessler Support]



Votes:

0

Hi, Thanks for replying. Hm... sound strange because PRTGv8 is able to trace MySQL v 5.5 (windows based)

Created on Oct 17, 2012 6:05:55 AM



Votes:

0

Hi,
the issue is filed also as bug in MySQL. Whereas from the discussion it is not clear whether the issue really originates from a bug or from a change in the authentication resp. creation of password hashes.
As PRTG 8 uses old dlls (equal to pre 4.1 clients) to access MySQL and it is working on windows the OLD_PASSWORDS variable might be set in the config of the same.
Best regards

Created on Oct 17, 2012 6:52:03 AM by Konstantin Wolff [Paessler Support]



Votes:

0

It's confirm working after upgrading to PRTG v9. Thanks.

Created on Oct 20, 2012 5:55:20 AM




Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.