From owner-freebsd-isp@FreeBSD.ORG Fri Jul 14 15:10:31 2006 Return-Path: X-Original-To: freebsd-isp@freebsd.org Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 8743616A516 for ; Fri, 14 Jul 2006 15:10:31 +0000 (UTC) (envelope-from martin.miedema@gmail.com) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.188]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7DC9743D55 for ; Fri, 14 Jul 2006 15:10:27 +0000 (GMT) (envelope-from martin.miedema@gmail.com) Received: by nf-out-0910.google.com with SMTP id y25so211209nfb for ; Fri, 14 Jul 2006 08:10:26 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=WtiwNonalOS61lRIl3eUvUE172zY4SRjmHEmIpW5f+Nc5agPZy83axN5isZk7yNZ/HSmymSmBsyoYN5Ac5VwgYJxKCcJY2hnmrJu3ZDKbTLG7DWt7/TqSW2+ui0to8mWpAqf7hRJiaND/5NqZQ4iUuLTooc4bc8qnrlVT9VOaYs= Received: by 10.49.21.8 with SMTP id y8mr2068623nfi; Fri, 14 Jul 2006 08:10:24 -0700 (PDT) Received: from ?10.137.41.178? ( [193.95.172.210]) by mx.gmail.com with ESMTP id v20sm74868nfc.2006.07.14.08.10.23; Fri, 14 Jul 2006 08:10:24 -0700 (PDT) Message-ID: <44B7B456.3000301@gmail.com> Date: Fri, 14 Jul 2006 16:12:22 +0100 From: Martin Miedema User-Agent: Thunderbird 1.5.0.2 (Windows/20060308) MIME-Version: 1.0 To: Jorge Evangelista References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-isp@freebsd.org Subject: Re: Bandwith Manager with Mysql X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 14 Jul 2006 15:10:31 -0000 Jorge Evangelista wrote: > Hi guys, I am installing Bandwith Manager of Emerging Technologies, I > have installed apache, php-mysql, and mysql, it because BW is manage > with Web Interface, but I have been having errors when Bandwitdh > Manager try to connect with database. > There are some logs. > > 07/10/06 10:55:30: Cannot Open MySQL Database. Error: Client does not > support authentication protocol requested by server; consider > upgrading MySQL client > 07/10/06 10:56:00: Cannot Open MySQL Database. Error: Client does not > support authentication protocol requested by server; consider > upgrading MySQL client > 07/10/06 10:56:00: Can't Get Statistics for flor2 > 07/10/06 10:56:00: Can't Get Statistics for SinglePC > 07/10/06 10:56:00: Can't Get Statistics for singlepc > 07/10/06 10:56:30: Cannot Open MySQL Database. Error: Client does not > support authentication protocol requested by server; consider > upgrading MySQL client > 07/10/06 10:57:00: Cannot Open MySQL Database. Error: Client does not > support authentication protocol requested by server; consider > upgrading MySQL client > 07/10/06 10:57:30: Cannot Open MySQL Database. Error: Client does not > support authentication protocol requested by server; consider > upgrading MySQL client > > > Which version of MySQL are you using? The way MySQL hashes password has changes since MySQL 4.1. If you use PHPmyAdmin, you can select to store the password using the old hashing method, that should solve your problem. There is also a way to do this using MySQL directly. Some google-ing should help you out there.