On Wed, 5 Jan 2005 13:08:36 +0100, Michael van Elst <[EMAIL PROTECTED]> wrote: > On Wed, Jan 05, 2005 at 12:25:30PM +0100, Dimitri Aivaliotis wrote: > > > Warning: setrlimit couldn't increase number of open files to more than > > 1024 (request: 5010) > > MySQL can only set a 'soft limit' for the number of open files that > must not be above the 'hard limit'. > > The 'hard limits' can be displayed with 'ulimit -Ha' and can be > changed only by root with e.g. 'ulimit -H -n 10000'.
Ah...thank you. > > To get larger 'hard limits' for ordinary users you may configure > these in /etc/security/limits.conf and tell PAM to use the > pam_limits.so module in /etc/pam.d/. > Ok. I've now got: * hard nofiles 10000 in /etc/security/limits.conf and pam_limits.so is already in /etc/pam.d/system-auth > There is another system wide limit for open files. You can > query it with 'cat /proc/sys/fs/file-max' and also change > it with something like 'echo 12345 >/proc/sys/fs/file-max'. > This must be larger than the 'hard limit' you want to set :) > This is already at 104856. su'ing to openpkg-r still doesn't indicate the higher hard limit. My /etc/pam.d/su file has: session required /lib/security/pam_stack.so service=system-auth and in system-auth: session required /lib/security/pam_limits.so A restart of MySQL indicates the same error. What am I missing here? - Dimitri ______________________________________________________________________ The OpenPKG Project www.openpkg.org User Communication List openpkg-users@openpkg.org