Piotras' blog: Archive

midgard-project.org update

Posted on 2006-10-06 19:01:07 UTC.

Today I updated Midgard setup on the host which serves www.midgard-project.org website. Unfortunatelly I couldn't use datagard as remotes database server doesn't allow login in as database administrator, so update has been made step by step manually.
A good news is the fact that debian packages was used to update Midgard environment.

If you need to update remote database and can not use datagard , try this script:

Database update

#! /bin/sh

. /usr/share/midgard/datagard/datagard.conf

# Set default initial values

_DATABASE_NAME="midgard"

_DATABASE_HOST="127.0.0.1"

_MGD_DB_USER="midgard"

_MGD_DB_PASS="midgard"

_SG_USER="admin"

_SG_PASS="password"



mgd_set_config_data MGD_DB_ACTION Update

mgd_set_config_data MYSQL_ADMIN_USER root

mgd_set_config_data MYSQL_ADMIN_PASS ""

mgd_set_config_data MGD_DB_HOST $_DATABASE_HOST

mgd_set_config_data MGD_DB_USER_NAME $_MGD_DB_USER

mgd_set_config_data MGD_DB_USER_PASS $_MGD_DB_PASS

mgd_set_config_data MGD_DB_NAME $_DATABASE_NAME

mgd_set_config_data MGD_SG_USER_NAME $_SG_USER

mgd_set_config_data MGD_SG_USER_PASS $_SG_PASS

mgd_set_config_data MGD_UPDATE_DB $_DATABASE_NAME

mgd_set_config_data MGD_DB_CONNECT_HOST $_DATABASE_HOST



mysqlcmd="mysql  --host=$_DATABASE_HOST --user=$_MGD_DB_USER --password=$_MGD_DB_PASS"



mgd_update_db

mgd_update_db_for_utf

This is of course example , and you might want to tweak it for particular needs.

A few nice features I discovered (oops , I wrote it :) after updating midgard:

• All SQL errors are reported to apache error log file whithout any need to change apache log level and without any need to reboot. Took me long while to find apache main error log , but at last I was nicely surprised.

• Schema validation is much much more better than this one wich exists in 1.7 branch.

Starting apache 1.3 web server...midgard-core (pid:30299):(WARNING):
Wrong node name 'propetty' 
in '/usr/share/midgard/schema/org_openpsa_core.xml' on line 137

B&W

Posted on 2006-10-10 22:28:18 UTC.

It's not actually Black and White. It's almost black with some minimal amount of white ( or grey ).

Anyway , I like it :)

Does anyone from Midgard community has something with colours?

Set of scripts

Posted on 2006-10-18 16:48:22 UTC.

While googling yestarday, I found few old entries about Midgard on Polish mailing lists. A few of them:

• Midgard is only set of scripts
• Midgard is distributed only as selected distros' binaries

Isn't it funny? :)

I am looking forward for multilanged MidCOM so I think some Midgard documentation or concpets could be easily translated to Polish then.

Another interesting thing is the fact that I almost finished new parameter method for Midgard objects.
A new one is ( tries to be ) much clever then legacy one and uses parameters' cache based on midgard_collector.

Simply it means that first call for some parameter in some domain , forces core to cache all domain parameters, so later call to the same parameter or another one in the same domain is "as slow as" :

$value = $arry['key']

No database selects.

This implementation will be introduced in Midgard since 1.8.1.

And something for high-tech fans: Midgard 1.9 is going to be released soon!

Midgard 1.9 work just started

Posted on 2006-10-24 19:23:45 UTC.

Bergie just mentioned about Midgard 1.8 and first cleanup commit.
As a result of today's work we have partially legacy free and compilable Midgard framework. Partially means that I am not so crazy to remove everything at once, as 1.9 release might use some legacy code or solutions to provide smooth CVS and alpha releases installations.
There is no repligard, no Aegir, no Spider. No legacy API in midgard-php extension. No Apache1 module.

Next few days I will implement ligbda support , so 1.9.0alpha1 release is almost here.

I realized today, how much work is still left to get fully Midgard2...

And quoting Arttu:

Midgard is an IT project so we can expect delays. Seven years sounds rather long, but Rome wasn't built in a day and conquerring the world is even more difficult.

During last two years we made almost 20 releases. And we brought Midgard to desktop. We just made very unique and powerfull CMS/Framework system. We even can not compare Midgard with other CMS'es. Simply , they can not be used in Apache and desktop environment.
Maybe Midgard2 is postponed seven years. But last two years really count!

Midgard 1.8 - PEAR issues on debian stable

Posted on 2006-10-27 12:21:18 UTC.

There is an issue with PEAR on debian stable. So Installing Midgard 1.8 is a bit difficult. As a workaround I found this solution a good start to install all PEAR packages.

# Upgrade PEAR on debian stable

pear upgrade Archive_Tar

pear upgrade pear-1.3.3 && pear upgrade pear



# Discover channels



pear channel-discover pear.midcom-project.org

pear channel-discover pearified.com





pear install pearified/Role_Web
pear install midcom/Role_Mgdschema

#Debian related stuff 
pear config-set mgdschema_dir /usr/share/midgard/schema
pear install midcom/Role_Midgardsql
pear config-set midgardsql_dir /usr/share/midgard/sql/update
pear install midcom/Role_Midgardelement 

# By default this is midgard, but you might want to change it
pear config-set midgard_config_file /etc/midgard/conf.d/midgard




# Install packages
pear install pearified/JavaScript_Prototype

pear install Mail_Mime

pear install midcom/midcom_helper_datamanager2

pear install -f midcom/org_openpsa_httplib

pear install -f midcom/net_nemein_calendar

pear install -f midcom/midcom_helper_imagepopup

pear install -f midcom/midcom_helper_search

pear install -f midcom/de_linkm_sitemap

pear install -f midcom/midgard_admin_sitewizard

pear install -f midcom/net_nehmer_static

pear install -f midcom/fi_protie_navigation

pear install -f midcom/Javascript_protoToolkit

pear install -f midcom/midcom_helper_datamanager

pear install -f midcom/midcom_admin_content

pear install -f midcom/no_bergfald_rcs

pear install -f midcom/org_routamc_photostream

pear install -f midcom/org_routamc_gallery

pear install midcom/net_nehmer_blog

After running all these commands I suggest to re run datagard and select PEAR again from menu. Sitewizard will be set correctly then , even if PEAR packages will fail to install from datagard menu.

Updated: I removed pear install -f midcom/net.siriux.photos

Updated:

• Removed pear install -f midcom/midcom_helper_toolbar
• Added debian related instructions

Updated (16.11.2006): Discover channels before installing packages.
( Excellent point from Sentrum2 , #midgard :)

Midgard and PostgreSQL, first issues

Posted on 2006-10-28 20:56:18 UTC.

Just had to copy it here. Instead of screenshot.

This is well know play. Find three words which doesn't exist in Midgard documentation.

Schema (pid:7822):(m): Type midgard_language
midgard-core (pid:7822):(WARNING): Midgard connection error: ERROR: syntax error at or near "SET" at character 30, No:(-1), src:gda-postgres

SQL: Not available
midgard-core (pid:7822):(debug): query = INSERT INTO midgard_language SET locale='', code='', description='', name='_schema_test_create-1392903333', native='', guid='64f93ec466ab11dba55db529ad5a9fa89fa8',sitegroup=0,metadata_creator='', metadata_created='2006-10-28 17:40:25+0000', metadata_revised='2006-10-28 17:40:25+0000', metadata_revision=0, metadata_revisor='', metadata_size=115 ,metadata_locker='' ,metadata_locked='' ,metadata_approver='' ,metadata_approved='' ,metadata_authors='' ,metadata_owner='' ,metadata_schedule_start='' ,metadata_schedule_end='' ,metadata_hidden=0 ,metadata_nav_noentry=0 ,metadata_published='2006-10-28 17:40:25+0000'

** (MIDGARD:7822): CRITICAL **: gda_postgres_provider_get_last_insert_id: assertion `GDA_IS_POSTGRES_RECORDSET (recset)' failed