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:\
penfiles-cur=2048:\
penfiles-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