Binary Expressions

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.

I recently installed PHP 4.3.11 from source (due to configuration requirements) on to an OpenBSD i386 v3.7 server. The installation went perfectly as it has many times before, however I found out that the PEAR script was not installed (normally in /usr/local/bin). I discovered this when trying to install some pear packages doing “pear install packagename”. I get a returned error of “-bash: pear: command not found”. I tried locating the PEAR script using “find / -name pear” and “/usr/libexec/locate.updatedb” then “locate -i pear”. The result came up empty with no PEAR script in the returned results. I double checked the PEAR documents, PHP documents and ./configure all three places stated PEAR is installed by default unless a parameter is provided at configure with –without-pear. I’m still not aware as to why the PEAR script was not installed however with help by SmallOne of #midgard I was able to resolve the problem manually. Here’s how it was resolved at the shell prompt.

• # cp pear.sh /usr/local/bin/pear
• # chmod 755 /usr/local/bin/pear

If anyone knows how the PEAR script could not have been installed please let me know, thanks.

Hi everyone. I know there has been a few people waiting for me to post about this. I apologize for such a delay. I’ve been really busy at work and consulting work is crazy right now. I have one screen done and I wanted to do one more for this first theme. For now I’ll give it post and see what everyone has to say. I said I’ll make something and I will. The theme has the same look/feel as midgard-project.org, but I like it. It’s original and it works. I just wanted to achieve more with the orientation of the data presented. I have a better solution on I believe for the orientation of the data. I’ll try to do that soon. Anyways enough babble… here’s the mock up theme I’ve done.

Please send in your comments, suggestions or directions.

It’s been awhile since I was able to work on my project of taking an existing site and converting it over to Midgard CMS along with web site improvements. I was put on to other projects temporally. Now I’m back on working with Midgard CMS. I’ve completed updating Midgard CMS and MidCOM. I’ve started to document my upgrading experience in my Midgard CMS Installation Guide for OpenBSD. You should soon seen an updated release of this guide shortly. Starting next week I will continue my development and on going documentation. I’m going to document as much as possible.

In my spare time I’ve started working on user interface concept designs for Midgard Administrative Interface System (AIS). I’ve pretty much completed one concept design and I want to complete one more before I release anything. I’m creating these user interface concept designs in Photoshop CS so I will be posting the concepts in jpeg (800px x 600px) once I’m completed. The design concepts will be standard compliant using XHTML/CSS/WCAG and fluid to fit any video resolution or browser window size. Let’s see lots of feedback people, I want to get these UIs perfect.