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

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.

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

Piotras pointed out that the errors I was getting was due to open files issue with OpenBSD and MySQL. Piotras pointed me to an OpenBSD notes on mysql.com. I had no idea this error was pointing to an open files issue which apprently can affect all versions of OpenBSD. I read the notes and applied the changes to the /etc/login.conf file based on the comments submitted by name withheld. I added the following lines to my /etc/login.conf file.

Add the following 9 lines to your /etc/login.conf file
# Setting used by MySQL daemon
mysql:\
:datasize=infinity:\
:maxproc=infinity:\
:openfiles-cur=2048:\
:openfiles-max=8192:\
:stacksize-cur=8M:\
:localcipher=blowfish,8:\
:tc=default:

Now it looks like I’ve gotten most of the errors I received from datagard at instillation of the database. However I’m still getting one error as shown below. Any ideas on this one? I think if I fixed this last error things would be working again. If anyone knows what the error means and/or how to solve it let me know, thanks.

Datagard database installation error
Trying to create mysql database and blobs dir.
wait….

Updating database: multilang
repligard-Message: Reading config file /usr/local/midgard-1.6.3/etc/midgard/repligard.conf
repligard-Message: Importing /usr/local/midgard-1.6.3/share/midgard/languages.xml
repligard-Message: Reading config file /usr/local/midgard-1.6.3/etc/midgard/repligard.conf
repligard-Message: Making missing GUIDs…
repligard-Message: Reading config file /usr/local/midgard-1.6.3/etc/midgard/repligard.conf
repligard-Message: Making missing GUIDs…
Updating database: fixing cache
Updating database: version control
Updating database: quota support

Trying to create mysql database and blobs dir.
wait….

Trying to make xml update….

repligard-Message: Reading config file /usr/local/midgard-1.6.3/etc/midgard/repligard.conf
repligard-Message: Importing /usr/local/midgard-1.6.3/share/midgard/admin_user.xml

REPLIGARD/READ-CRITICAL **: Failed to allocate delayed resource f6b665f1984503790ed91f39b11b5392 as a link uid for member (Table ‘tmpxmlupdate.quota’ doesn’t exist).

Can not import admin user

At this point I’ve given up on Midgard v1.7rc1 as I’ve gotten no where to get it functional. Since I ran out of ideas on how to resolve the problem I decided to install Midgard v1.6.3. The installation of the Midgard modules went successful until I got to the last step of install the MySQL Midgard database using datagard. Here is the below errors I received. If anyone can help me out that would be much appreciated. I’ll willing to pay for consulting service to resolve these problems.

Datagard Install Database Errors

Trying to create mysql database and blobs dir.
wait….
chmod: /usr/local/midgard-1.6.3/etc/midgard/repligard.conf: No such file or directory
mv: /usr/local/midgard-1.6.3/etc/midgard/repligard.conf: No such file or directory
Updating database: multilang
repligard-Message: Reading config file /usr/local/midgard-1.6.3/etc/midgard/repligard.conf
repligard-Message: Importing /usr/local/midgard-1.6.3/share/midgard/languages.xml
repligard-Message: Reading config file /usr/local/midgard-1.6.3/etc/midgard/repligard.conf
repligard-Message: Making missing GUIDs…
repligard-Message: Reading config file /usr/local/midgard-1.6.3/etc/midgard/repligard.conf
repligard-Message: Making missing GUIDs…
Updating database: fixing cache
Updating database: version control
Updating database: quota support
Trying to create mysql database and blobs dir.
wait….
Trying to make xml update….
repligard-Message: Reading config file /usr/local/midgard-1.6.3/etc/midgard/repligard.conf
repligard-Message: Importing /usr/local/midgard-1.6.3/share/midgard/admin_user.xml
repligard-Message: Reading config file /usr/local/midgard-1.6.3/etc/midgard/repligard.conf
repligard-Message: Importing /usr/local/midgard-1.6.3/share/midgard/data/AegirAddOn_FileSync.xml.gz
Updating database: multilang
repligard-Message: Reading config file /usr/local/midgard-1.6.3/etc/midgard/repligard.conf
repligard-Message: Importing /usr/local/midgard-1.6.3/share/midgard/languages.xml
repligard-Message: Reading config file /usr/local/midgard-1.6.3/etc/midgard/repligard.conf
repligard-Message: Making missing GUIDs…
repligard-Message: Reading config file /usr/local/midgard-1.6.3/etc/midgard/repligard.conf
repligard-Message: Making missing GUIDs…
Updating database: fixing cache
ERROR 1 at line 2: Can’t create/write to file ‘./tmpxmlupdate/#sql-5aa7_236.MYD’ (Errcode: 9)
Updating database: version control
ERROR 1 at line 1: Can’t create/write to file ‘./tmpxmlupdate/#sql-5aa7_238.MYD’ (Errcode: 9)
Couldn’t update repligard table!
Please, follow SQL statements in /usr/local/midgard-1.6.3/share/midgard/repligard.sql, and try to update this table manually.
Updating database: quota support
ERROR 1 at line 1: Can’t create/write to file ‘./tmpxmlupdate/quota.MYD’ (Errcode: 9)
Couldn’t create and update quota table! Please, follow SQL statements in /usr/local/midgard-1.6.3/share/midgard/quota.sql, and try to update this table manually.
repligard-Message: Reading config file /usr/local/midgard-1.6.3/etc/midgard/repligard.conf
repligard-Message: Exporting to /usr/local/midgard-1.6.3/share/midgard/data/AegirAddOn_FileSync_multilang.xml.gz
repligard-Message: Reading config file /usr/local/midgard-1.6.3/etc/midgard/repligard.conf
repligard-Message: Importing /usr/local/midgard-1.6.3/share/midgard/admin_user.xml
repligard-Message: Reading config file /usr/local/midgard-1.6.3/etc/midgard/repligard.conf
repligard-Message: Importing /tmp/tmp.dPuiL14768
Trying to create mysql database and blobs dir.
wait….
Trying to make xml update….
repligard-Message: Reading config file /usr/local/midgard-1.6.3/etc/midgard/repligard.conf
repligard-Message: Importing /usr/local/midgard-1.6.3/share/midgard/admin_user.xml
REPLIGARD/READ-CRITICAL **: Failed to allocate delayed resource f6b665f1984503790ed91f39b11b5392 as a link uid for member (Table ‘tmpxmlupdate.quota’ doesn’t exist).
Can not import admin user

I had to re-do my server. Once the server was re-done I started putting Midgard back on but experienced issues with datagard. This is in regards to Midgard 1.7rc1. Below is the errors I keep getting to complete the installation of Midgard by install the database. I’ve found one error in my apache log but haven’t found a solution. I’ve logged everything from configuration to installation of Midgard in files using script. Let me know who can help. I’m willing to pay for consulting service to resolve this problem.

Datagard Error

grep: /usr/local/midgard-1.7rc1/var/log/datagard.log: No such file or directory
mv: rename /tmp/datagard.log to /usr/local/midgard-1.7rc1/var/log/: No such file or directory

Trying to create mysql database and blobs dir.
wait….

Updating database: multilang
repligard-Message: Reading config file /usr/local/midgard-1.7rc1/etc/midgard/repligard.conf
repligard-Message: Importing /usr/local/midgard-1.7rc1/share/midgard/languages.xml
repligard in free(): error: modified (chunk-) pointer
/usr/local/midgard-1.7rc1/share/midgard/datagard/lib.postinst: line 604: 859 Abort trap (core dumped) $MGD_USR_PATH/bin/repligard -c $MGD_CONFIG_PATH/repligard.conf -i $MGD_SHARE_PATH/languages.xml

Can not import languages.xml

Apache 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

I came across this amazing photographer Maciej Pokora. Which turns out, his the brother of Piotr Pokora whom I deal with on the Midgard Project. I would recommend to check out Maciej Pokora photographs at ALTphotos.com. My favorite ones are Silence… and the one untitled of Piotr and his daughter. I would love to have a photograph of my daughter and I like that. I can’t describe it any better then there amazing photographs.