What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
300.000 administrators have chosen PRTG to monitor their network. 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

Your Vote:

Up

Down

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 by  Brian Goh (0) 1



6 Replies

Votes:

0

Your Vote:

Up

Down

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

Your Vote:

Up

Down

mySQL version: 5.5.16
PRTG version: PRTG Network Monitor 8.4.2.2381

Created on Oct 15, 2012 2:17:18 AM by  Brian Goh (0) 1

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



Votes:

0

Your Vote:

Up

Down

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

Your Vote:

Up

Down

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 by  Brian Goh (0) 1



Votes:

0

Your Vote:

Up

Down

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

Your Vote:

Up

Down

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

Created on Oct 20, 2012 5:55:20 AM by  Brian Goh (0) 1



Please log in or register to enter your reply.


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.