mysqld "skip-show-database" argument after "port=" argument nullifies the latter

Description:
If a "skip-show-database" argument is processed by mysqld *after* a
"port=[number]" argument, mysqld will listen to port 3306 regardless.

It does not matter whether the arguments are specified in a my.[ini|cnf]
file or on the command line (or one of each, with other arguments in between
or not). If the command mysqld --print-defaults shows a "skip-show-database"
directive after a "port=" directive, the latter directive will be ignored.

Specifying "skip-show-database" *before* "port=" has no ill effect.

EXAMPLES:
mysqld --port=3399 --skip-show-database --standalone
-> runs on port 3306
mysqld --skip-show-database --port=3399 --standalone
-> runs on port 3399
mysqld --port=3399 --skip-show-database --port=3301 --standalone
-> runs on port 3301

This behavior holds for all mysqld variants I tested: mysqld, mysqld-nt,
mysqld-max-nt. Note: I downloaded the binary 3.23.52 distro from the MySQL
AB web site.
This took me *hours* to track down. It is a very subtle flaw.

How-To-Repeat:
Specify a "skip-show-database" argument to mysqld *after* a "port=[number]"
argument.

Fix:
Specify a "skip-show-database" argument to mysqld *before* a "port=[number]"
argument.

Synopsis: mysqld "skip-show-database" argument after "port=" argument
nullifies the latter.
Submitter-Id:
Originator: Zach Pincus
Organization: Stanford Program in Biomedical Informatics
MySQL support: none
Severity: non-critical
Priority: medium (it's VERY non-obvious how to work around this!)
Category: mysqld
Class: sw-bug
Release: mysql-3.23.52
Executable: mysqld, mysql-nt, mysqld-max-nt (others not tested)
Environment: Gateway PIII model GP7-500, 384 MB RAM.
System: NT 4.0 SP6a
Compiler: I downloaded a binary distro.
Architecture: i386


------------------------------------------------------------ ---------
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-thread12668@lists.mysql.com
To unsubscribe, e-mail

Re: mysqld "skip-show-database" argument after "port=" argument nullifies the la

At 20:26 7/10/2002 -0700, Zach Pincus wrote:
Hi,

>Description:
>If a "skip-show-database" argument is processed by mysqld *after* a
>"port=3D[number]" argument, mysqld will listen to port 3306 regardless.
>
>It does not matter whether the arguments are specified in a my.[ini|cnf]
>file or on the command line (or one of each, with other arguments in=
between
>or not). If the command mysqld --print-defaults shows a=
"skip-show-database"
>directive after a "port=3D" directive, the latter directive will be=
ignored.
>
>Specifying "skip-show-database" *before* "port=3D" has no ill effect.
>
>EXAMPLES:
>mysqld --port=3D3399 --skip-show-database --standalone
> -> runs on port 3306

Thanks for the bug report, I was be able to repeat that behavior.

>mysqld --skip-show-database --port=3D3399 --standalone
> -> runs on port 3399
>mysqld --port=3D3399 --skip-show-database --port=3D3301 --standalone
> -> runs on port 3301
>
>This behavior holds for all mysqld variants I tested: mysqld, mysqld-nt,
>mysqld-max-nt. Note: I downloaded the binary 3.23.52 distro from the MySQL
>AB web site.
>This took me *hours* to track down. It is a very subtle flaw.
>
>How-To-Repeat:
>Specify a "skip-show-database" argument to mysqld *after* a "port=3D[number=
]"
>argument.
>
>Fix:
>Specify a "skip-show-database" argument to mysqld *before* a=
"port=3D[number]"
>argument.
>
>Synopsis: mysqld "skip-show-database" argument after "port=3D" argument
>nullifies the latter.
>Submitter-Id:
>Originator: Zach Pincus
>Organization: Stanford Program in Biomedical Informatics
>MySQL support: none
>Severity: non-critical
>Priority: medium (it's VERY non-obvious how to work around this!)
>Category: mysqld
>Class: sw-bug
>Release: mysql-3.23.52
>Executable: mysqld, mysql-nt, mysqld-max-nt (others not tested)
>Environment: Gateway PIII model GP7-500, 384 MB RAM.
>System: NT 4.0 SP6a
>Compiler: I downloaded a binary distro.
>Architecture: i386

--=20
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Miguel Angel Sol=F3rzano
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ S=E3o Paulo - Brazil
<___/ www.mysql.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-thread12669@lists.mysql.com
To unsubscribe, e-mail

mysqld "skip-show-database" argument after "port=" argument nullifies the latter

Hi!

>>>>> "Zach" == Zach Pincus writes:

Zach> Description:
Zach> If a "skip-show-database" argument is processed by mysqld *after* a
Zach> "port=[number]" argument, mysqld will listen to port 3306 regardless.

Zach> It does not matter whether the arguments are specified in a my.[ini|cnf]
Zach> file or on the command line (or one of each, with other arguments in between
Zach> or not). If the command mysqld --print-defaults shows a "skip-show-database"
Zach> directive after a "port=" directive, the latter directive will be ignored.



Zach> How-To-Repeat:
Zach> Specify a "skip-show-database" argument to mysqld *after* a "port=[number]"
Zach> argument.

I have now fixed this in the 3.23 source (will be in the next MySQL
release); Thanks for the bug report.

Regards,
Monty

--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Michael Widenius
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland
<___/ www.mysql.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-thread12670@lists.mysql.com
To unsubscribe, e-mail