mysql problem setting up SIP server on Solaris 10.

[Database Administrator]

I'm trying to set up a Session Initiation Protocol (SIP) server on Sun
SPARC running Solaris 10 as detailed on Sun's web site at

http://developers.sun.com/solaris/ar...is_as_sip.html

The server needs to connect to a mysql database, which I already had
installed (version 5.0.15). I know mysql works, as I use it for phpBB.

I know the root password for this. I'm no mysql expert and don't use it
much, but I can at least connect to the server

main-webserver /etc/sfw/ser # /usr/local/mysql/bin/mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13125 to server version: 5.0.15-max

Now to set up the SIP server on Solaris, the Sun web site indicates I
need to run the script /etc/sfw/ser/ser_mysql.sh, but this is not
working as I expect.

main-webserver /etc/sfw/ser # /etc/sfw/ser/ser_mysql.sh create
MySql password for root:
main-webserver /etc/sfw/ser # /etc/sfw/ser/ser_mysql.sh create
MySql password for root:
Domain (realm) for the default user 'admin': test.althorne.org

creating database ser ...
ERROR 1251: Client does not support authentication protocol requested by
server; consider upgrading MySQL client

A Google on this error message and I find a solution on the mysql
forums, but it is very Windoze specific.

Trying to use the default user (admin) rather than a test domain
(test.althorne.org) as suggested on the Sun site I get a different
problem, but I'm still none the wiser.

main-webserver /etc/sfw/ser # /etc/sfw/ser/ser_mysql.sh create
MySql password for root:
Domain (realm) for the default user 'admin':

HA1 calculation failed


I can't recall what databases or users are in the mysql database. Anyone
any clue as to what is going on?


--
Dave K MCSE.

MCSE = Minefield Consultant and Solitaire Expert.

Please note my email address changes periodically to avoid spam.
It is always of the form: month-year@domain. Hitting reply will work
for a couple of months only. Later set it manually.

[Database Administrator]

Dave (from the UK) wrote:
> ERROR 1251: Client does not support authentication protocol requested by
> server; consider upgrading MySQL client
>
> A Google on this error message and I find a solution on the mysql
> forums, but it is very Windoze specific.

This error is not Windows specific. It happens when using a MySQL 4.0
client, connecting to a MySQL 4.1 or later server.

For example, the PHP 4 distribution includes a precompiled MySQL 4.0
client, so it is frequent that we get this error when using a MySQL 4.1
or later server from PHP scripts. The same would happen anytime MySQL
4.0 client code is used to connect to a greater version MySQL server.

See here for more info, and the remedy:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html

Regards,
Bill K.

[Database Administrator]

Bill Karwin wrote:

> This error is not Windows specific. It happens when using a MySQL 4.0
> client, connecting to a MySQL 4.1 or later server.
>
> For example, the PHP 4 distribution includes a precompiled MySQL 4.0
> client, so it is frequent that we get this error when using a MySQL 4.1
> or later server from PHP scripts. The same would happen anytime MySQL
> 4.0 client code is used to connect to a greater version MySQL server.
>
> See here for more info, and the remedy:
> http://dev.mysql.com/doc/refman/5.0/en/old-client.html
>
> Regards,
> Bill K.

Thanks. After resetting the root password for the database to the old
type with:

mysql> SET PASSWORD FOR
-> 'root'@'localhost' = OLD_PASSWORD('foobar');
Query OK, 0 rows affected (0.05 sec)

I was then able to create the database for the user 'ser'. I still don't
have 'ser' working properly, but at least some progress.

--
Dave K MCSE.

MCSE = Minefield Consultant and Solitaire Expert.

Please note my email address changes periodically to avoid spam.
It is always of the form: month-year@domain. Hitting reply will work
for a couple of months only. Later set it manually.