Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 14 Jul 2006 16:12:22 +0100
From:      Martin Miedema <martin.miedema@gmail.com>
To:        Jorge Evangelista <netsecuredata@gmail.com>
Cc:        freebsd-isp@freebsd.org
Subject:   Re: Bandwith Manager with Mysql
Message-ID:  <44B7B456.3000301@gmail.com>
In-Reply-To: <de85c96f0607140750x23073707m5d250badc6c7ff74@mail.gmail.com>
References:  <de85c96f0607140750x23073707m5d250badc6c7ff74@mail.gmail.com>

next in thread | previous in thread | raw e-mail | index | archive | help
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.



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?44B7B456.3000301>