Bug in options parsing in MySQL-4.1 with latest bk pull

Hi,

How-to-repeat :

With latest bk pull :

mysql -uroot -p
<2:22:09
Enter password:
ERROR 1045: Access denied for user: '@localhost' (Using password: NO)

Same thing for mysqladmin and other tools.

Regards,
Jocelyn


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13548@lists.mysql.com
To unsubscribe, e-mail

Re: Bug in options parsing in MySQL-4.1 with latest bk pull

Jocelyn Fournier writes:
> Hi,
>
> How-to-repeat :
>
> With latest bk pull :
>
> mysql -uroot -p
> <2:22:09
> Enter password:
> ERROR 1045: Access denied for user: '@localhost' (Using password: NO)
>
> Same thing for mysqladmin and other tools.
>
> Regards,
> Jocelyn
>
>

Just tried it and it worked for me:

[/mnt/work/mysql-4.1]$ ./client/mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.0-alpha-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>


--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13551@lists.mysql.com
To unsubscribe, e-mail

Re: Bug in options parsing in MySQL-4.1 with latest bk pull

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

Sinisa Milivojevic wrote:
> Jocelyn Fournier writes:
>
>>Hi,
>>
>>How-to-repeat :
>>
>>With latest bk pull :
>>
>>mysql -uroot -p
>><2:22:09
>>Enter password:
>>ERROR 1045: Access denied for user: '@localhost' (Using password: NO)
>>
>>Same thing for mysqladmin and other tools.
>>
>>Regards,
>> Jocelyn
>>
>>
>
>
> Just tried it and it worked for me:
>
> [/mnt/work/mysql-4.1]$ ./client/mysql -uroot -p
> Enter password:
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 1 to server version: 4.1.0-alpha-debug
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql>
>
>

Earlier this week I was experiencing the same problem with a bk-pull
from over the weekend. I pulled yesterday and the problem went away.

-Mark

- --
MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/

For technical support contracts, visit https://order.mysql.com/?ref=mmma

__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+Ls6+tvXNTca6JD8RAtCaAKC3ZGqNerkmPu9eImhhs7PvTvzW2QCe Mw7Y
CyrAolWWuOq1i0e2RmHC4UY=
=CshP
-----END PGP SIGNATURE-----


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13552@lists.mysql.com
To unsubscribe, e-mail

Re: Bug in options parsing in MySQL-4.1 with latest bk pull

Jocelyn Fournier writes:
> Hi,
>
> Thanks for the info !
> But I still have the same problem today (perhaps I have to restart the
> server to be able to connect ?).
>
> Regards,
> Jocelyn

HI!

It is possible that some of the pushes that have not made it to the
public repository have fixed a problem.


--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13555@lists.mysql.com
To unsubscribe, e-mail

Re: Bug in options parsing in MySQL-4.1 with latest bk pull

Hi,

Thanks for the info !
But I still have the same problem today (perhaps I have to restart the
server to be able to connect ?).

Regards,
Jocelyn
----- Original Message -----
From: "Mark Matthews"
To:
Cc: ;
Sent: Wednesday, January 22, 2003 5:02 PM
Subject: Re: Bug in options parsing in MySQL-4.1 with latest bk pull


> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Sinisa Milivojevic wrote:
> > Jocelyn Fournier writes:
> >
> >>Hi,
> >>
> >>How-to-repeat :
> >>
> >>With latest bk pull :
> >>
> >>mysql -uroot -p
> >><2:22:09
> >>Enter password:
> >>ERROR 1045: Access denied for user: '@localhost' (Using password: NO)
> >>
> >>Same thing for mysqladmin and other tools.
> >>
> >>Regards,
> >> Jocelyn
> >>
> >>
> >
> >
> > Just tried it and it worked for me:
> >
> > [/mnt/work/mysql-4.1]$ ./client/mysql -uroot -p
> > Enter password:
> > Welcome to the MySQL monitor. Commands end with ; or \g.
> > Your MySQL connection id is 1 to server version: 4.1.0-alpha-debug
> >
> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> >
> > mysql>
> >
> >
>
> Earlier this week I was experiencing the same problem with a bk-pull
> from over the weekend. I pulled yesterday and the problem went away.
>
> -Mark
>
> - --
> MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/
>
> For technical support contracts, visit https://order.mysql.com/?ref=mmma
>
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mark Matthews
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
> /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
> <___/ www.mysql.com
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.1.90 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQE+Ls6+tvXNTca6JD8RAtCaAKC3ZGqNerkmPu9eImhhs7PvTvzW2QCe Mw7Y
> CyrAolWWuOq1i0e2RmHC4UY=
> =CshP
> -----END PGP SIGNATURE-----
>
>


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13554@lists.mysql.com
To unsubscribe, e-mail

Re: Bug in options parsing in MySQL-4.1 with latest bk pull

On Wed, Jan 22, 2003 at 09:17:00PM +0200, Sinisa Milivojevic wrote:
> Jocelyn Fournier writes:
> > Hi,
> >
> > Thanks for the info !
> > But I still have the same problem today (perhaps I have to restart the
> > server to be able to connect ?).
> >
> > Regards,
> > Jocelyn
>
> HI!
>
> It is possible that some of the pushes that have not made it to the
> public repository have fixed a problem.

I thought the bkbits repository was on a 1-hour delay now instead of
the old 24-hour delay on work.mysql.com. Is that not true?

Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
| http://jeremy.zawodny.com/

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13556@lists.mysql.com
To unsubscribe, e-mail

Re: Bug in options parsing in MySQL-4.1 with latest bk pull

Perhaps the fix has not been pushed yet ? (since the latest changeset
through bk pull is the 1.1425)

Jocelyn
----- Original Message -----
From: "Jeremy Zawodny"
To: "Sinisa Milivojevic"
Cc: ; ;
Sent: Wednesday, January 22, 2003 11:53 PM
Subject: Re: Bug in options parsing in MySQL-4.1 with latest bk pull


> On Wed, Jan 22, 2003 at 09:17:00PM +0200, Sinisa Milivojevic wrote:
> > Jocelyn Fournier writes:
> > > Hi,
> > >
> > > Thanks for the info !
> > > But I still have the same problem today (perhaps I have to restart the
> > > server to be able to connect ?).
> > >
> > > Regards,
> > > Jocelyn
> >
> > HI!
> >
> > It is possible that some of the pushes that have not made it to the
> > public repository have fixed a problem.
>
> I thought the bkbits repository was on a 1-hour delay now instead of
> the old 24-hour delay on work.mysql.com. Is that not true?
>
> Jeremy
> --
> Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
> | http://jeremy.zawodny.com/
>


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13557@lists.mysql.com
To unsubscribe, e-mail

Re: Bug in options parsing in MySQL-4.1 with latest bk pull

On 1/22/03 6:53 PM, Jeremy Zawodny wrote:

> On Wed, Jan 22, 2003 at 09:17:00PM +0200, Sinisa Milivojevic wrote:
>> Jocelyn Fournier writes:
>>> Hi,
>>>
>>> Thanks for the info !
>>> But I still have the same problem today (perhaps I have to restart the
>>> server to be able to connect ?).
>>>
>>> Regards,
>>> Jocelyn
>>
>> HI!
>>
>> It is possible that some of the pushes that have not made it to the
>> public repository have fixed a problem.
>
> I thought the bkbits repository was on a 1-hour delay now instead of
> the old 24-hour delay on work.mysql.com. Is that not true?

Yes, 1-hour delay is true. And I have just run the update script manually to
make sure, there was nothing to push.


Matt

--
MySQL 2003 Users Conference, http://www.mysql.com/events/uc2003/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Matt Wagner
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Director of Product Development
/_/ /_/\_, /___/\___\_\___/ Apple Valley, Minnesota USA
<___/ www.mysql.com Office: +1 952 953 3586


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13558@lists.mysql.com
To unsubscribe, e-mail

Re: Bug in options parsing in MySQL-4.1 with latest bk pull

Hi,

After more inverstigation, I noticed the following problem :

I wasn't able to connect to the server using latest mysql client from bk
tree and an older mysqld server.
If I use the server provided with the latest bk tree, I'm able to connect.
*However* I'm not able to access to the new server using PHP scripts (even
after a compilation of php against the lib of the latest bk tree).
It displays :

Warning: mysql_connect() [function.mysql-connect]: Access denied for user:
'ql@localhost' (Using password: YES) in /tmp/sqlforum/connexion.php3 on line
2

The user should be 'mysql', not 'ql' .

If I put back the 'old' server php works fine, but mysql, mysqladmin, etc
fails.

Has something been changed recently in the protocol which could explain this
behaviour ??

Thanks and regards,
Jocelyn


----- Original Message -----
From: "Matt Wagner"
To: "Jeremy Zawodny" ; "Sinisa Milivojevic"

Cc: ; ;
Sent: Thursday, January 23, 2003 4:46 AM
Subject: Re: Bug in options parsing in MySQL-4.1 with latest bk pull


> On 1/22/03 6:53 PM, Jeremy Zawodny wrote:
>
> > On Wed, Jan 22, 2003 at 09:17:00PM +0200, Sinisa Milivojevic wrote:
> >> Jocelyn Fournier writes:
> >>> Hi,
> >>>
> >>> Thanks for the info !
> >>> But I still have the same problem today (perhaps I have to restart the
> >>> server to be able to connect ?).
> >>>
> >>> Regards,
> >>> Jocelyn
> >>
> >> HI!
> >>
> >> It is possible that some of the pushes that have not made it to the
> >> public repository have fixed a problem.
> >
> > I thought the bkbits repository was on a 1-hour delay now instead of
> > the old 24-hour delay on work.mysql.com. Is that not true?
>
> Yes, 1-hour delay is true. And I have just run the update script manually
to
> make sure, there was nothing to push.
>
>
> Matt
>
> --
> MySQL 2003 Users Conference, http://www.mysql.com/events/uc2003/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Matt Wagner
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Director of Product Development
> /_/ /_/\_, /___/\___\_\___/ Apple Valley, Minnesota USA
> <___/ www.mysql.com Office: +1 952 953 3586
>
>


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13567@lists.mysql.com
To unsubscribe, e-mail

Re: Bug in options parsing in MySQL-4.1 with latest bk pull

On Thu, 2003-01-23 at 16:54, Jocelyn Fournier wrote:
> Hi,

Hi !!!

>
> After more inverstigation, I noticed the following problem :
>
> I wasn't able to connect to the server using latest mysql client from bk
> tree and an older mysqld server.
> If I use the server provided with the latest bk tree, I'm able to connect.
> *However* I'm not able to access to the new server using PHP scripts (even
> after a compilation of php against the lib of the latest bk tree).
> It displays :
>
> Warning: mysql_connect() [function.mysql-connect]: Access denied for user:
> 'ql@localhost' (Using password: YES) in /tmp/sqlforum/connexion.php3 on line
> 2
>
> The user should be 'mysql', not 'ql' .
>
> If I put back the 'old' server php works fine, but mysql, mysqladmin, etc
> fails.
>
> Has something been changed recently in the protocol which could explain this
> behaviour ??

I just cross checked the 4.1<->3.23 and 3.23<->4.1 clients<->server
connection, and it just goes through fine.

Here is a simple case from 4.1 client to 3.23 server.

[venu@myvenu libmysql]$ ldd ../client/.libs/mysql
libncurses.so.5 => /usr/lib/libncurses.so.5 (0x40014000)
libmysqlclient.so.14 =>
/home/venu/work/sql/dev-4.1/libmysql/.libs/libmysqlclient.so .14
(0x40053000)
libz.so.1 => /usr/lib/libz.so.1 (0x4016a000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x40178000)
libnsl.so.1 => /lib/libnsl.so.1 (0x401a5000)
libm.so.6 => /lib/i686/libm.so.6 (0x401ba000)
libc.so.6 => /lib/i686/libc.so.6 (0x42000000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)

[venu@myvenu libmysql]$ ../client/.libs/mysql -uvenu
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.55

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> exit
Bye
[venu@myvenu libmysql]$ ../client/.libs/mysql -umysql
ERROR 1045: Access denied for user: 'mysql@localhost' (Using password:
YES)

And similarly it worked fine with 4.0 tree.

Thanks


>
> Thanks and regards,
> Jocelyn
>
>
> ----- Original Message -----
> From: "Matt Wagner"
> To: "Jeremy Zawodny" ; "Sinisa Milivojevic"
>
> Cc: ; ;
> Sent: Thursday, January 23, 2003 4:46 AM
> Subject: Re: Bug in options parsing in MySQL-4.1 with latest bk pull
>
>
> > On 1/22/03 6:53 PM, Jeremy Zawodny wrote:
> >
> > > On Wed, Jan 22, 2003 at 09:17:00PM +0200, Sinisa Milivojevic wrote:
> > >> Jocelyn Fournier writes:
> > >>> Hi,
> > >>>
> > >>> Thanks for the info !
> > >>> But I still have the same problem today (perhaps I have to restart the
> > >>> server to be able to connect ?).
> > >>>
> > >>> Regards,
> > >>> Jocelyn
> > >>
> > >> HI!
> > >>
> > >> It is possible that some of the pushes that have not made it to the
> > >> public repository have fixed a problem.
> > >
> > > I thought the bkbits repository was on a 1-hour delay now instead of
> > > the old 24-hour delay on work.mysql.com. Is that not true?
> >
> > Yes, 1-hour delay is true. And I have just run the update script manually
> to
> > make sure, there was nothing to push.
> >
> >
> > Matt
> >
> > --
> > MySQL 2003 Users Conference, http://www.mysql.com/events/uc2003/
> > __ ___ ___ ____ __
> > / |/ /_ __/ __/ __ \/ / Mr. Matt Wagner
> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Director of Product Development
> > /_/ /_/\_, /___/\___\_\___/ Apple Valley, Minnesota USA
> > <___/ www.mysql.com Office: +1 952 953 3586
> >
> >
>
>
> ------------------------------------------------------------ ---------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail bugs-thread13567@lists.mysql.com
> To unsubscribe, e-mail
--
Regards, Venu
For technical support contracts, go to https://order.mysql.com
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306, USA
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13570@lists.mysql.com
To unsubscribe, e-mail

Re: Bug in options parsing in MySQL-4.1 with latest bk pull

Jocelyn Fournier writes:
> Hi,
>
> After more inverstigation, I noticed the following problem :
>
> I wasn't able to connect to the server using latest mysql client from bk
> tree and an older mysqld server.
> If I use the server provided with the latest bk tree, I'm able to connect.
> *However* I'm not able to access to the new server using PHP scripts (even
> after a compilation of php against the lib of the latest bk tree).
> It displays :
>
> Warning: mysql_connect() [function.mysql-connect]: Access denied for user:
> 'ql@localhost' (Using password: YES) in /tmp/sqlforum/connexion.php3 on line
> 2
>
> The user should be 'mysql', not 'ql' .
>
> If I put back the 'old' server php works fine, but mysql, mysqladmin, etc
> fails.
>
> Has something been changed recently in the protocol which could explain this
> behaviour ??
>
> Thanks and regards,
> Jocelyn

Hi!

Just like Venu, I was not able to repeat the problem.

Do note however, that tables created with 4.1 are not readable by
3.23. This includes privilege tables too. This could sometimes lead to
problems.

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13573@lists.mysql.com
To unsubscribe, e-mail

Re: Bug in options parsing in MySQL-4.1 with latest bk pull

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

Sinisa Milivojevic wrote:
> Jocelyn Fournier writes:
>
>>Hi,
>>
>>After more inverstigation, I noticed the following problem :
>>
>>I wasn't able to connect to the server using latest mysql client from bk
>>tree and an older mysqld server.
>>If I use the server provided with the latest bk tree, I'm able to connect.
>>*However* I'm not able to access to the new server using PHP scripts (even
>>after a compilation of php against the lib of the latest bk tree).
>>It displays :


Like I said before, I did see the _exact_ same behavior that Jocelyn
saw. The server was chopping off the first few characters of the
username when authenticating.

My guess is this came about when Monty changed the protocol in 4.1 to
send longer values for CLIENT_PARAM and max_allowed_packet for the
client...Which would be long enough to overwrite the space for the first
part of the username, because the username follows these two values in
the authentication reply packet. This would only happen though, if you
had an older 4.1 client library talking to a newer 4.1 server binary.

I don't think you will be able to reproduce it unless you happened to
have pulled at the exact same time as Jocelyn or I, and had compiled in
the same way.

Jocelyn, you might double check that your 4.1 client library is
_exactly_ in sync with your 4.1 server binary.

-Mark
- --
MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/

For technical support contracts, visit https://order.mysql.com/?ref=mmma

__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+MUTftvXNTca6JD8RAsooAJ4rxWtK40R9nrACpy0Yvor60ZSyegCc DRHp
TE61Hmm8Ci9fyHgDLTuS3oA=
=7ThI
-----END PGP SIGNATURE-----


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13576@lists.mysql.com
To unsubscribe, e-mail