From owner-freebsd-isp@FreeBSD.ORG Fri Jul 14 16:41:25 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 8CA1D16A4DD for ; Fri, 14 Jul 2006 16:41:25 +0000 (UTC) (envelope-from drew@gothambus.com) Received: from mail.gothambus.com (trixie.gbcx.net [204.89.131.138]) by mx1.FreeBSD.org (Postfix) with SMTP id 1951743D66 for ; Fri, 14 Jul 2006 16:41:23 +0000 (GMT) (envelope-from drew@gothambus.com) Received: (qmail 30772 invoked by uid 1024); 14 Jul 2006 16:39:30 -0000 Received: from drew@gothambus.com by mail.gothambus.com by uid 89 with qmail-scanner-1.22-st-qms (spamassassin: 2.64. Clear:RC:1(216.168.140.18):. Processed in 0.037428 secs); 14 Jul 2006 16:39:30 -0000 X-Antivirus-MYDOMAIN-Mail-From: drew@gothambus.com via mail.gothambus.com X-Antivirus-MYDOMAIN: 1.22-st-qms (Clear:RC:1(216.168.140.18):. Processed in 0.037428 secs Process 30768) Received: from 3comvpn.nxgt.com (HELO ?192.168.1.174?) (216.168.140.18) by mail.gothambus.com with SMTP; 14 Jul 2006 16:39:30 -0000 Message-ID: <44B7C92B.6050904@gothambus.com> Date: Fri, 14 Jul 2006 12:41:15 -0400 From: Drew Linsalata User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: freebsd-isp@freebsd.org References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 16:41:25 -0000 Jorge Evangelista wrote: > 07/10/06 10:57:30: Cannot Open MySQL Database. Error: Client does not > support authentication protocol requested by server; consider > upgrading MySQL client You need to change the MySQL password format for the bwmgr user: Connect to your MySQL server: ----------------------------- mysql -h your.sql.host -u root -p Update the password: --------------------- use mysql SET password=OLD_PASSWORD('password') WHERE user='username'; flush privileges; That should get you in. The problem is that your MySQL is too new for the bandwidth manager package. -- Drew Linsalata The Gotham Bus Company, Inc. Dedicated Servers and Colocation Solutions Long Island, New York http://www.gothambus.com