Hi James, I recently went through a simliar process of trying to up my settings to support an active MySQL database.
First, is your cron job being run by root? If yes, can try typing this while logged in as root: # ulimit -a This will give you an idea of what access you have to open files. This goes beyond the /file-max setting, as it is the users ceiling you will reach first. I am not sure echoing the ram amount into there is the right technique, but I just left mine blank either way. My system would not let me do this, but you could try: # ulimit -n unlimited If you get an error there which means you have to manually specify number, you can see what the ceiling limits in your system are by typing: # sysctl -a Look for the open file number listed there and use that as a guide to how high you can set your ulimit for root. You can append the ulimit update amount in your rc.local file to make sure it sticks after a reboot. You can do this with PAM too, but I am not versed in that yet. This will work for any user with a bash account. Please keep in mind - This is newbie advice. The fact that I am responsible for a server is a direct reflection of lack of budget :-) Mitchell On 10/1/02 11:54 AM, "James Deck" <[EMAIL PROTECTED]> wrote: > Hi there, > > I have a central database server that collects data using a nightly cron > job from a whole bunch of smaller database servers by importing DBF files > the smaller database servers export. My problem is that every time I run > the cron script it dies near the end of the script saying there are too > many open files. Whenever I have had this problem in the past, I have > echoed 64*RAM in MB to /proc/sys/fs/file-max. That doesn't seem to be > working this time though... I have looked on the web, and can't seem to > find anything more :-S. > > Error message looks like: > > DBD::XBase::st execute failed: Table AXL9 not found: Error opening file > /tmp/csr/core/data-core/AXL9.DBF: Too many open files > > My question is, is there anything else I need to do to increase the > maximum number of file handles? > > Thanks, > james > > -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe https://listman.redhat.com/mailman/listinfo/redhat-list
