Bug #37168 Missing variable - skip_name_resolve

Submitted: 3 Jun 2008 18:47 Modified: 18 Jun 2010 1:52
Reporter: Jason Frisvold Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:5.0.51a, 5.0.60 OS:Linux (CentOS 5.1)
Assigned to: Georgi Kodinov CPU Architecture:Any

[3 Jun 2008 18:47] Jason Frisvold
Description:
The variable skip_name_resolve does not show up in the list of variables within MySQL.  Unable to verify that this option is working.  I do have this option set in my /etc/my.cnf file.

How to repeat:
[friz@jake ~]$ mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3948
Server version: 5.0.51a-community MySQL Community Edition (GPL)

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

mysql> show variables like "%skip%";
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| skip_external_locking | ON    | 
| skip_networking       | OFF   | 
| skip_show_database    | OFF   | 
| slave_skip_errors     | OFF   | 
+-----------------------+-------+
4 rows in set (0.00 sec)

mysql> show global variables like "%skip%";
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| skip_external_locking | ON    | 
| skip_networking       | OFF   | 
| skip_show_database    | OFF   | 
| slave_skip_errors     | OFF   | 
+-----------------------+-------+
4 rows in set (0.00 sec)

Suggested fix:
Add variable to variable list, allowing the user to determine the current status of this option.
[3 Jun 2008 19:28] Valeriy Kravchuk
Current properly of skip_name_resolved is properly described at http://dev.mysql.com/doc/refman/5.0/en/privileges-options.html. So I consider this as a reasonable feature request.
[25 Jul 2008 13:56] Baron Schwartz
It's missing in 5.1 too.
[2 Oct 2008 21:17] Konstantin Osipov
Dear triage,
missing variables for server options are not feature requests.
We have resolved to fix this inconsistency.
[6 Oct 2008 20:31] Omer Barnir
Kostja: Given the above doc link and the fact that there are other documented variables that are not available in the show command, why do you see this one as a bug and not as a feature request? If you are suggesting that all variables should be included in the show command (for consistency), it is not a bad idea, but ut us a feature request).

Please clarify,

Thanks
[31 Mar 2010 13:13] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/104713

3436 Georgi Kodinov	2010-03-31
      Bug #37168: Missing variable - skip_name_resolve
      
      Added a read-only global boolean variable skip_name_resolve.
[6 Apr 2010 8:01] Bugs System
Pushed into 5.1.46 (revid:sergey.glukhov@sun.com-20100405111026-7kz1p8qlzglqgfmu) (version source revid:joro@sun.com-20100331131237-ts0pnjw9h4vlxnge) (merge vers: 5.1.46) (pib:16)
[21 Apr 2010 23:34] Paul DuBois
Noted in 5.1.46 changelog.

There is a new system variable, skip_name_resolve, that is set from
the value of the --skip-name-resolve server option. This provides a
way to determine at runtime whether the server uses name resolution 
for client connections.  

Setting report to Need Merge pending push into Celosia.
[28 May 2010 5:59] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100524190136-egaq7e8zgkwb9aqi) (version source revid:alik@sun.com-20100422150750-vp0n37kp9ywq5ghf) (pib:16)
[28 May 2010 6:27] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100524190941-nuudpx60if25wsvx) (version source revid:alik@sun.com-20100422150658-fkhgnwwkyugtxrmu) (merge vers: 6.0.14-alpha) (pib:16)
[28 May 2010 6:55] Bugs System
Pushed into 5.5.5-m3 (revid:alik@sun.com-20100524185725-c8k5q7v60i5nix3t) (version source revid:alexey.kopytov@sun.com-20100403173551-52r97erqowlqwkon) (merge vers: 5.5.4-m3) (pib:16)
[29 May 2010 2:38] Paul DuBois
Noted in 5.5.5, 6.0.14 changelogs.
[17 Jun 2010 12:01] Bugs System
Pushed into 5.1.47-ndb-7.0.16 (revid:martin.skold@mysql.com-20100617114014-bva0dy24yyd67697) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[17 Jun 2010 12:43] Bugs System
Pushed into 5.1.47-ndb-6.2.19 (revid:martin.skold@mysql.com-20100617115448-idrbic6gbki37h1c) (version source revid:martin.skold@mysql.com-20100609211156-tsac5qhw951miwtt) (merge vers: 5.1.46-ndb-6.2.19) (pib:16)
[17 Jun 2010 13:29] Bugs System
Pushed into 5.1.47-ndb-6.3.35 (revid:martin.skold@mysql.com-20100617114611-61aqbb52j752y116) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.072 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.