Binary Expressions

As I discussed in my previous blog 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”.