pkg/48258: mysql-server startup files may try to set to high fd-limit in pkgsrc-startup-file

[Wolfgang.Stukenbrock%nagler-company.com@localhost]

>Number:         48258
>Category:       pkg
>Synopsis:       mysql-server startup files may try to set to high fd-limit in 
>pkgsrc-startup-file
>Confidential:   no
>Severity:       serious
>Priority:       high
>Responsible:    pkg-manager
>State:          open
>Class:          change-request
>Submitter-Id:   net
>Arrival-Date:   Wed Oct 02 11:00:00 +0000 2013
>Originator:     Dr. Wolfgang Stukenbrock
>Release:        pkgsrc-2013Q2, MAIN-CVS-branch
>Organization:
Dr. Nagler & Company GmbH
>Environment:
        
        
System: NetBSD test-s0 5.1.2 NetBSD 5.1.2 (NSW-WS) #3: Fri Dec 21 15:15:43 CET 
2012 wgstuken@test-s0:/usr/src/sys/arch/amd64/compile/NSW-WS amd64
Architecture: x86_64
Machine: amd64
>Description:
        On NetBSD during installation of mysql-server packages a rc-file from 
"files" directory is installed.
        This exapmple file is bad, because it tries to set the fd-limit to 4096 
unconditionaly.
        This fails on "normal" NetBSD systems that has a default limit of 3404.
>How-To-Repeat:
        setup a fresh system (e.g. amd64), log in and run "ulimit -Hn". It will 
report 3404.
        And so setting 4096 in the rc-file will (silently) fail and the server 
will stay at 128 fd's.
>Fix:
        Either just set the actual limit to the max with "ulimit -n `ulimit 
-Hn`" or
        introduce a more complex code that will determine the max between the 
value
        returned by "ulimit -Hn" and the hardcoded limit of 4096.
        By the way: what about a variable that may be tuned in /etc/rc.conf ???
        All four version of mysql-server packages in 2013Q2 are affected and 
need  correction.

>Unformatted: