The problem I was having was with open files on OpenBSD with MySQL I
thought at the time that adding the lines to the /etc/login.conf would
resolve my problem. However I discovered that this did not resolve the
problem. Why I don't know unfortunately. The good news is the problem
has been resolved. To resolve the errors of "Can't create/write to file"
and "Errcode: 9" you have to start MySQL like so "mysqld_safe
--open-files-limit=2048 &". This will increase the amount of files MySQL
can open therefore eliminating the errors. On a side note I did have to
make some changes on permissions as shown below so Midgard could
function which again were pointed out by Piotras. Thanks Piotras for the
helping once again :-). Your paths may vary as I installed Midgard CMS
with a prefix path of /usr/local/midgard-1.6.3 to keep all the files
centralized as possible.

# chmod -R 775 /usr/local/midgard-1.6.3/var/cache
# chown -R www:www /usr/local/midgard-1.6.3/var/cache
# chmod 551 /usr/local/midgard-1.6.3/var/lib/midgard/vhosts

If you care to read further on this subject of "mysql openfiles on
openbsd" try the following links.

http://dev.mysql.com/doc/mysql/en/openbsd-2-8.html
http://www.monkey.org/openbsd/archive/misc/0502/msg01000.html

You can also use a search engine such as Google.com and search for
with/out quotes "mysql openfiles openbsd".

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to