SOLVED: MySQL 4.1.7 / OpenBSD 3.6-current AGAIN (errno 9) error! Help plz! :)

[Dennis Nasarov <pheonix@sysattack.com>]

Hello folks!

Thanks all who reply my post with some ideas but all them were wrong
:) Probles is the /etc/rc reads /etc/login.conf only on boot(i'm lame
eh?) so any limits i set in login.conf for mysql user class were not
applied to currently running box.. After (sic!) reboot - ALL WORKS
EXCELLENT AND WITHOUY ANY ERRORS! So for anyone who have trouble with
MySQL 4.1.7 and (errno: 9) setup your box like this

/etc/login.conf

#
# MySQL daemon
#
mysql:\
        :datasize=infinity:\
        :maxproc=infinity:\
        :openfiles-cur=infinity:\
        :openfiles-max=infinity:\
        :stacksize-cur=8M:\
        :localcipher=blowfish,8:\
        :tc=default:

reboot box and if fails again increase kern.maxfiles

sysctl -w kern.maxfiles=13666

All should works fine ;)
Hope it helps.

P.S. OpenBSD 3.6-current / MySQL 4.1.7 (Source distribution)
-- 
Dennis Nasarov
Network Security Analyst
SoanInvest Co. Ltd
http://pheonix.sysattack.com/cv/
* Looking for a Job *