Binary Expressions

It is with great disappointment to announce that I will no longer be able to provide commercial development support from my employer of Midgard CMS. I’ve been told to terminate all development with Midgard CMS. I will however not disappear in my involvement with Midgard CMS. I plan to accelerate my plans to develop Midgard CMS on a test server at home running OpenBSD v3.7 i386 and look at the possibility of development on my web hosting provider. What does this all mean? Well unfortunately this means I will not be able to provide development time like I did in the past of 5 days a week at roughly 8 hours a day. Around September I have the possibility to continue minimal development with Midgard. At that point or later on my employer will re-evaluate Midgard CMS and see again at using it as our CMS. As my employer knows and agrees that CMS is the future and is required for the web site. Unfortunately they need results now and a new site up to support there customers and representative network. How I will continue without CMS is uncertain at this time. It may not be the best direction but it will get the job done, providing results as they want.

Saying all that, I will be around. Please feel free to email or contact me via my web site. I thank everyone for your support and help.

I have Midgard 1.6.3 freshly installed and functioning 100%, at least to my knowledge. I’m able to load all the web pages and log into Aegir. I have no error messages being logged into the MidgardLog or the HTTPD error_log. However after I import my Midgard database I get blank or empty web pages rendering in the browser. I did not see any error messages being logged into my HTTPD error_log. I turned on HTTPD debug log level (ex. LogLevel debug) and then turned on my Midgard logs (ex. MidgardLog debug /var/www/logs/midgard.log). Now in my HTTPD error_log I have “[notice] child pid 265 exit signal Segmentation fault (11)” and “Midgard: Refreshing NTLM auth request for sitegroup 0. NTLM sitegroup: -1″. See the logs below for further details. The logs will show me attempting to go to /midgard/.

I get blank/empty pages when I try to go to /midgard/, /mole/ (but page is not empty contains “< ?xml version="1.0"?>” and /example/. Anyone have any ideas how to resolve these two errors?

Here’s how I imported my Midgard database of a previous install of Midgard 1.6.3.

• I logged into MySQL, executed the SQL command “drop database midgard;”.
• Executed another SQL command “create database midgard;”.
• Logged out of MySQL.
• Then I imported the data by executing the following at the shell prompt “mysql -u username -p midgard < midgard_db.sql".

After this I just opened up my browser and tried to load some web pages from that server.

Apache error_log
Processing config directory: /usr/local/midgard-1.6.3/etc/midgard/apache/vhosts/*
Processing config file: /usr/local/midgard-1.6.3/etc/midgard/apache/vhosts/scorpius.venmarces.com_80
[notice] Initializing etag from /var/www/logs/etag-state
[notice] Apache/1.3.29 (Unix) Midgard/1.6.3/Repository/MultiLang PHP/4.3.11 mod_ssl/2.8.16 OpenSSL/0.9.7d configured — resuming normal operations
[info] Server built: unknown
[notice] Accept mutex: sysvsem (Default: sysvsem)
[debug] midgard-apache1.c(1355): [client ip-here] midgard_translate_handler(UTF-8, http://scorpius.venmarces.com:80/midgard)
[debug] select_db.h(51): [client ip-here] Midgard: select_database opened database midgard
[debug] midgard-apache1.c(192): [client ip-here] Midgard: lang set to 0
[debug] select_db.h(33): [client ip-here] Midgard: select_database kept current database midgard
[debug] midgard-apache1.c(977): [client ip-here] Midgard: Refreshing NTLM auth request for sitegroup 0. NTLM sitegroup: -1
[notice] child pid 12983 exit signal Segmentation fault (11)

Midgard Log
midgard-lib:12983:debug:query=SELECT id,style,root,lang,info&1,Length(prefix),sitegroup FROM host WHERE name=’subdomain.domainname.com’ AND port in (0,80) AND ( (0 <> 0 AND prefix = ”) OR (0 = 0 AN
D prefix=Left(’/midgard’,Length(prefix)) AND IF(8>=Length(prefix),MID(’/midgard’,1+Length(prefix),1) IN (”,’/'),0)=1 ) ) AND online <> 0 ORDER BY prefix DESC, port DESC
midgard-lib:12983:debug:query=SELECT info&2 FROM page WHERE page.id=50
midgard-lib:12983:debug:query=SELECT style FROM page WHERE page.id=50

Zek and Luke went to a trucking company to apply for a “Team” truck driving job. The personnel manager decided, after talking to them both that they weren’t the sharpest knives in the drawer. He decides to interview them separately. He first interviews Zek. After 15 minutes he completes the interview. Zek barely passes. Next he interviews Luke. He begins by asking the usual transportation related questions. Luke also barely passes.

The personnel manager next interview them together. He presents them with this potential problem: Now Zek and Luke, lets say that you two are a driving team. One of you is driving the rig and the other is asleep in the back. You are going down this very steep hill with sixty thousand pounds of steel on the truck. All of a sudden your breaks go out and your speed is increasing. What would be the first thing you’d do ?

About a minute passes and there was no answer. Then, all of a sudden Luke spoke up.

“I know, I know, I know the first thing I’d do”. The personnel manager says “yes Luke, what is the first thing you’d do?” Luke says, “I’d wake Zek up.” The personnel manager replies, “WHAT ! “Why would wake Zek up ?”

Coos, says Luke, “He ain’t never seen no big accident before!”

Two blondes were driving along a road by a wheat field when they saw a blonde in the middle of the field rowing a row boat.

The driver blonde turned to her friend and said “You know - it’s blondes like that that give us a bad name!”

To this, the other blonde replies “I know it, and if I knew how to swim, I’d go out there and drown her.”

A blonde goes into a nearby store and asks a clerk if she can buy the TV in the corner.

The clerk looks at her and says that he doesn’t serve blondes, so she goes back home and dyes her hair black.

The next day she returns to the store and asks the same thing, and again, the clerk said he doesn’t serve blondes.

Frustrated, the blonde goes home and dyes her hair yet again, to a shade of red.

Sure that a clerk would sell her the TV this time, she returns and asks a different clerk this time.

To her astonishment, this clerk also says that she doesn’t serve blondes.

The blonde asks the clerk, “How in the world do you know I am a blonde?”

The clerk looks at her disgustedly and says,”That’s not a TV — it’s a microwave!”

This installation example for Unix/Linux installs dependency support for Midgard CMS. Make sure Expat, zlib (comes with OpenBSD) and iconv are installed before proceeding. I have added additional configuration for MySQL (so the correct MySQL libraries are used), Microsoft SQL Server, apxs, XML, exif, dba and mbstring. Refer to the PHP configurator for details (# ./configure –help).

# ./configure –with-mysql=/usr/local –with-mssql=/usr/local –with-apxs –with-xml –with-zlib-dir=/usr/lib –with-expat –with-config-file-path=/var/www/conf –with-iconv=/usr/local/bin/iconv -–with-exif –-with-dba –-with-mbstring
# make
# make install
# make clean
# cp php.ini-recommended /var/www/conf/php.ini

Review/edit /var/www/conf/php.ini (path may vary) file to match your requirements. To meet the requirements of Midgard CMS you will require to do the following.

Add extension=midgard.so into your php.ini file.
Add the extensions path to extension_dir. Type “php-config –extension-dir”. Place the returned path into your php.ini file.
Ensure the file_uploads=on.
Ensure the short_open_tag=on.

Midgard CMS will crash PHP CLI if its loaded in the global php.ini. Add PHP settings to your Apache HTTP Server configuration file /var/www/conf/httpd.conf (path may vary). Put the below PHP settings into your httpd.conf file. This may also go into your Midgard httpd.conf if you want. Make sure to restart your Apache HTTP Server so configuration changes take affect.

php_value extension midgard.so
php_value register_globals 1

If you are experiencing “segmentation fault” when trying to do a PEAR package install on a system using Midgard CMS, do the following.

• Comment out “extension=midgard.so” line in php.ini.
• Restart Apache HTTP Server.
• Re-run Pear package install (i.e. pear install Mail).
• Uncomment out “extension=midgard.so” line in php.ini.
• Restart Apache HTTP Server.

If you experience the following error that refers to mailtemplate or mailmime, this means you don’t have PEAR Mail or PEAR Mail_mime package installed. For example after you have downloaded the PEAR package to install PEAR Mail package type at the shell prompt without quotes “pear install Mail”.

Example of error messages
Warning: main(Mail.php): failed to open stream: No such file or directory in
/usr/share/pear/midcom/lib/midcom/helper/mailtemplate.php on line 17

Fatal error: main(): Failed opening required ‘Mail.php’
(include_path=’.:/usr/local/share/php/pear’) in
/usr/share/pear/midcom/lib/midcom/helper/mailtemplate.php on line 17

I was having some problems with my web site so I went off to check my Apache HTTPD error_log and found three warning messages logged.

Apache HTTPD error_log
/usr/sbin/httpd:/usr/lib/apache/modules/libphp4.so: /usr/local/lib/libmysqlclient.so.12.0 : WARNING: symbol(client_errors) size mismatch, relink your program
/usr/sbin/httpd:/usr/lib/apache/modules/libphp4.so: /usr/local/lib/libmysqlclient.so.12.0 : WARNING: symbol(default_directories) size mismatch, relink your program
/usr/sbin/httpd:/usr/lib/apache/modules/libphp4.so: /usr/local/lib/libmysqlclient.so.12.0 : WARNING: symbol(globerrs) size mismatch, relink your program

After some time of research and with no solution, I decided to mention the problem in Midgard IRC channel. With Piotras comment, I quote “TheWarden: php was compiled with different version of mysql libraries”. So with that said off I went to re-install PHP v4.3.11 but this time configure it with –with-mysql=/usr/local so the correct MySQL libraries would be used. If –with-mysql is not used PHP will use it’s own built in MySQL libraries. I double checked my Apache HTTPD error_log and now the warnings are no longer present.

Hey every one, I’m finally writing a blog about something other than jokes. About a week or two ago my big brother (The Warden) showed me a program that lets you browse the world in 3D any were that you want. But the down fall is that the graphics are not that great but its quite cool. Small towns and other non-major areas are not mapped very well if at all. You can find you house or street or even your favorite store. It also gives you direction from point a to point b. Google Earth can cure boredom by spending endless hours searching the globe.

Web Site: Google Earth

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”.