MySQL 4.1.1 Aplha server

Hello all,

I just installed MySql server.

From localhost I can connect with user root (with PASS) and a user Bert
(with PASS).

I added a line that user bert may access from 'any host (%)'.

When trying to connect from local host. I can access.
From any remote location without a PASS I get "access for user".
With pass I get "ERROR 1043: Bad handshake".

I did restart the server (Linux Red-Hat), but also after that no success.

What can be the problem ??

Bert


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: MySQL 4.1.1 Aplha server

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello,

Bert Zefat wrote:
> Hello all,
>
> I just installed MySql server.
>
> From localhost I can connect with user root (with PASS) and a user Bert
> (with PASS).
>
> I added a line that user bert may access from 'any host (%)'.
>
> When trying to connect from local host. I can access.
> From any remote location without a PASS I get "access for user".
> With pass I get "ERROR 1043: Bad handshake".
>
> I did restart the server (Linux Red-Hat), but also after that no success.
>
> What can be the problem ??

Just make sure the client which you use to connect is also 4.1.1
If they are please provide repeatable test case including GRANT commands you
use, MySQL releases on server and client and how they are installed - from RPM,
binary tarball or source.

> Bert




- --
Want to swim with the dolphins? (April 14-16, 2004)
http://www.mysql.com/uc2004/

For technical support contracts, visit https://order.mysql.com/?ref=msal
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
<___/ www.mysql.com


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFAB7KneehWBZ4HcYkRAkhQAKCS996A+YkUjo2nKiztNsbDxUj62ACf bppE
odR+zZgmXJloZfsL30u6zPo=
=awi7
-----END PGP SIGNATURE-----


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: MySQL 4.1.1 Aplha server

Hello Alexander,

I'm using YourSQL or ProSQL (Mac) to connect to this server. I have
successfully installed 4.1.0 Server on Mac OS X. These clients can connect
to that server without any problem.

I installed on RedHat (I believe) version 7.3 the RPM (rpm -I mysql...).
Both Server and client. Downloaded yesterday from your server.

GRANT ALL permissins to bert@'%' with GRANT OPTION. As described in your
manual and did a flush privileges after all alterations.

All commands gave succes.

Thanks in advance.

Bert


On 1/16/04 10:45 AM, "Alexander Keremidarski" wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hello,
>
> Bert Zefat wrote:
>> Hello all,
>>
>> I just installed MySql server.
>>
>> From localhost I can connect with user root (with PASS) and a user Bert
>> (with PASS).
>>
>> I added a line that user bert may access from 'any host (%)'.
>>
>> When trying to connect from local host. I can access.
>> From any remote location without a PASS I get "access for user".
>> With pass I get "ERROR 1043: Bad handshake".
>>
>> I did restart the server (Linux Red-Hat), but also after that no success.
>>
>> What can be the problem ??
>
> Just make sure the client which you use to connect is also 4.1.1
> If they are please provide repeatable test case including GRANT commands you
> use, MySQL releases on server and client and how they are installed - from
> RPM,
> binary tarball or source.
>
>> Bert
>
>
>
>
> - --
> Want to swim with the dolphins? (April 14-16, 2004)
> http://www.mysql.com/uc2004/
>
> For technical support contracts, visit https://order.mysql.com/?ref=msal
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
> /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
> <___/ www.mysql.com
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.1 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFAB7KneehWBZ4HcYkRAkhQAKCS996A+YkUjo2nKiztNsbDxUj62ACf bppE
> odR+zZgmXJloZfsL30u6zPo=
> =awi7
> -----END PGP SIGNATURE-----
>

---
Bert Zefat
Software Developer
mailto:bzefat@pagecomposer.com
mailto:support@pagecomposer.com
--------------------------------------------
Bell Microproducts Solutions B.V.
Nautilusstraat 5 A
7821 AG EMMEN
The Netherlands

Tel: +31 591 651160 (Direct)
Fax: +31 591 651185

mailto:info@pagecomposer.com
http://www.pagecomposer.com
ftp://ftp.pagecomposer.com

Bell Microproducts Solutions Europe B.V. is a Bell Microproducts company.

http://www.bellmicro.nl

This message is intended only for the use of the person(s)
(\"the intended recipient(s)\") to whom it is addressed.
It may contain information which is privileged and confidential
within the meaning of applicable law. If you are not the
intended recipient, please contact the sender as soon as
possible. The views expressed in this communication may not
necessarily be the views held by Bell Microproducts Solutions B.V.


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: MySQL 4.1.1 Aplha server

Bert Zefat writes:
> Hello Alexander,
>
> I'm using YourSQL or ProSQL (Mac) to connect to this server. I have
> successfully installed 4.1.0 Server on Mac OS X. These clients can connect
> to that server without any problem.
>
> I installed on RedHat (I believe) version 7.3 the RPM (rpm -I mysql...).
> Both Server and client. Downloaded yesterday from your server.
>
> GRANT ALL permissins to bert@'%' with GRANT OPTION. As described in your
> manual and did a flush privileges after all alterations.
>
> All commands gave succes.
>
> Thanks in advance.
>
> Bert

The error you are getting is either:

* network or TCP/IP problems
* your client program is not using API compatible with MySQL 4.1

--

Sincerely,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus

Want to swim with the dolphins? (April 14-16, 2004)
http://www.mysql.com/uc2004/


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: MySQL 4.1.1 Aplha server

Hi!

On Jan 16, Bert Zefat wrote:
> Hello Alexander,
>
> I'm using YourSQL or ProSQL (Mac) to connect to this server. I have
> successfully installed 4.1.0 Server on Mac OS X. These clients can connect
> to that server without any problem.

Ok, so your client library is 4.1.0.

> I installed on RedHat (I believe) version 7.3 the RPM (rpm -I mysql...).
> Both Server and client. Downloaded yesterday from your server.

I assume it was 4.1.1 then.

> GRANT ALL permissins to bert@'%' with GRANT OPTION. As described in your
> manual and did a flush privileges after all alterations.

Ok, what does not work is connecting from 4.1.0 client to 4.1.1 server
(or 4.1.1 client to 4.1.0 server).

The client-server protocol in 4.1.0 contained a design flaw and we
decided not to support it in 4.1.1. Thus both a server and a client
should be of 4.1.0 version (that's why you can connect from Mac
to a server on Mac) or both should be of 4.1.1 (that's why you can
connect from Linux client to Linux server).

You have to upgrade your MySQL distribution on Mac.

Regards,
Sergei

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: MySQL 4.1.1 Aplha server

Hello Sergei,

The clients I use are not the MySql Client, but third party clients..

I do use all these clients from Mac OS X (10.3.2) YourSQL, ProSQL or
dbReport (to generate reports).

These clients should not be affected by these version differences.

I prefer NOT to update the Mac Environment at the moment as I am trying to
develop a program for database management for it and it is setup as I want
it now.

Is it posible to download the 4.1.0-Alpha-Standard (rpm) for Linux (i386) so
I can "mirror" the setup so I can develop at an other site as well with the
same data?

I hope you can help me with this issue.

Best regards,

Bert Zefat

On 1/17/04 6:59 PM, "Sergei Golubchik" wrote:

> Hi!
>
> On Jan 16, Bert Zefat wrote:
>> Hello Alexander,
>>
>> I'm using YourSQL or ProSQL (Mac) to connect to this server. I have
>> successfully installed 4.1.0 Server on Mac OS X. These clients can connect
>> to that server without any problem.
>
> Ok, so your client library is 4.1.0.
>
>> I installed on RedHat (I believe) version 7.3 the RPM (rpm -I mysql...).
>> Both Server and client. Downloaded yesterday from your server.
>
> I assume it was 4.1.1 then.
>
>> GRANT ALL permissins to bert@'%' with GRANT OPTION. As described in your
>> manual and did a flush privileges after all alterations.
>
> Ok, what does not work is connecting from 4.1.0 client to 4.1.1 server
> (or 4.1.1 client to 4.1.0 server).
>
> The client-server protocol in 4.1.0 contained a design flaw and we
> decided not to support it in 4.1.1. Thus both a server and a client
> should be of 4.1.0 version (that's why you can connect from Mac
> to a server on Mac) or both should be of 4.1.1 (that's why you can
> connect from Linux client to Linux server).
>
> You have to upgrade your MySQL distribution on Mac.
>
> Regards,
> Sergei

---
Bert Zefat
Software Developer
mailto:bzefat@pagecomposer.com
mailto:support@pagecomposer.com
--------------------------------------------
Bell Microproducts Solutions B.V.
Nautilusstraat 5 A
7821 AG EMMEN
The Netherlands

Tel: +31 591 651160 (Direct)
Fax: +31 591 651185

mailto:info@pagecomposer.com
http://www.pagecomposer.com
ftp://ftp.pagecomposer.com

Bell Microproducts Solutions Europe B.V. is a Bell Microproducts company.

http://www.bellmicro.nl

This message is intended only for the use of the person(s)
(\"the intended recipient(s)\") to whom it is addressed.
It may contain information which is privileged and confidential
within the meaning of applicable law. If you are not the
intended recipient, please contact the sender as soon as
possible. The views expressed in this communication may not
necessarily be the views held by Bell Microproducts Solutions B.V.


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: MySQL 4.1.1 Aplha server

Hi!

First: as this is not a bug, this list is NOT an apropriate place for
this thread anymore. Use mysql@lists.mysql.com.

On Jan 17, Bert Zefat wrote:
> Hello Sergei,
>
> The clients I use are not the MySql Client, but third party clients..

Yes, but they still are linked to MySQL client library.

> These clients should not be affected by these version differences.

They understand a certain version of MySQL client-server protocol.
So - they are affected.

> I prefer NOT to update the Mac Environment at the moment as I am trying to
> develop a program for database management for it and it is setup as I want
> it now.
>
> Is it posible to download the 4.1.0-Alpha-Standard (rpm) for Linux (i386) so
> I can "mirror" the setup so I can develop at an other site as well with the
> same data?

Yes, from our site, download section.

> > On Jan 16, Bert Zefat wrote:
> >> Hello Alexander,
> >>
> >> I'm using YourSQL or ProSQL (Mac) to connect to this server. I have
> >> successfully installed 4.1.0 Server on Mac OS X. These clients can connect
> >> to that server without any problem.
> >
> > Ok, so your client library is 4.1.0.
> >
> >> I installed on RedHat (I believe) version 7.3 the RPM (rpm -I mysql...).
> >> Both Server and client. Downloaded yesterday from your server.
> >
> > I assume it was 4.1.1 then.
> >
> >> GRANT ALL permissins to bert@'%' with GRANT OPTION. As described in your
> >> manual and did a flush privileges after all alterations.
> >
> > Ok, what does not work is connecting from 4.1.0 client to 4.1.1 server
> > (or 4.1.1 client to 4.1.0 server).
> >
> > The client-server protocol in 4.1.0 contained a design flaw and we
> > decided not to support it in 4.1.1. Thus both a server and a client
> > should be of 4.1.0 version (that's why you can connect from Mac
> > to a server on Mac) or both should be of 4.1.1 (that's why you can
> > connect from Linux client to Linux server).
> >
> > You have to upgrade your MySQL distribution on Mac.
> >
> > Regards,
> > Sergei
>
> ---
> Bert Zefat
> Software Developer
> mailto:bzefat@pagecomposer.com
> mailto:support@pagecomposer.com
> --------------------------------------------
> Bell Microproducts Solutions B.V.
> Nautilusstraat 5 A
> 7821 AG EMMEN
> The Netherlands
>
> Tel: +31 591 651160 (Direct)
> Fax: +31 591 651185
>
> mailto:info@pagecomposer.com
> http://www.pagecomposer.com
> ftp://ftp.pagecomposer.com
>
> Bell Microproducts Solutions Europe B.V. is a Bell Microproducts company.
>
> http://www.bellmicro.nl
>
> This message is intended only for the use of the person(s)
> (\"the intended recipient(s)\") to whom it is addressed.
> It may contain information which is privileged and confidential
> within the meaning of applicable law. If you are not the
> intended recipient, please contact the sender as soon as
> possible. The views expressed in this communication may not
> necessarily be the views held by Bell Microproducts Solutions B.V.
Regards,
Sergei

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: MySQL 4.1.1 Aplha server

Hello Bert,

Bert Zefat wrote:
> Hello Sergei,


> I prefer NOT to update the Mac Environment at the moment as I am trying to
> develop a program for database management for it and it is setup as I want
> it now.
>
> Is it posible to download the 4.1.0-Alpha-Standard (rpm) for Linux (i386) so
> I can "mirror" the setup so I can develop at an other site as well with the
> same data?

Please note that 4.1.0 is being outdated and we are not going to support it in
any way.
This has always been MySQL AB policy - we only make changes and bug fixes in
latest minor release. In addition 4.1.0 is first Alpha release. According to our
release policy release in Alpha stage is subject of several modifications,
adding new features and changing exisiting ones.

If you face any problem with 4.1.0 the first and only advice we will give you
will be to upgrade to most recent 4.1.x release.

> I hope you can help me with this issue.
>
> Best regards,
>
> Bert Zefat

Best regards

--
Want to swim with the dolphins? (April 14-16, 2004)
http://www.mysql.com/uc2004/

For technical support contracts, visit https://order.mysql.com/?ref=msal
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
<___/ www.mysql.com




--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: MySQL 4.1.1 Aplha server

Hello Bert,

Bert Zefat wrote:
> Hello Alexander ,

> I'd love to download the 4.1.0 for Linux if that is possible. That should
> solve all my current problems.
>
> Could you please provide me with the 4.1.0 installer (rpm). As the 4.1.0
> works perfect for me ??

Just go to our website download section, find closest FTP mmirror to you and
under MySQL-4.1 directory you will find 4.1.0 RPMs

http://www.mysql.com/downloads/mirrors.html

For me for example it is ftp://mysql.online.bg
ftp://mysql.online.bg/mysql/Downloads/MySQL-4.1

However I would repeat Sergei's note one more time:

> First: as this is not a bug, this list is NOT an apropriate place for
> this thread anymore. Use mysql@lists.mysql.com.



Best regards

--
Want to swim with the dolphins? (April 14-16, 2004)
http://www.mysql.com/uc2004/

For technical support contracts, visit https://order.mysql.com/?ref=msal
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
<___/ www.mysql.com




--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org