Re: [Gnumed-devel] Install-error on Mandriva 2007.1

[Karsten Hilbert]

Hello Michael,

> I'd try to install gnumed server and client on MDV 2007.1.
Nice, thanks, we'll try to help out with problems.

> All dependences should be right by install "gnumed-task" (a meta-paket
> that bild doktor5000 from www.mandrivauser.de for me).
Very nice ! doktor5000 is welcome to join our mailing list
and both of you are welcome to document your progress on our
wiki (http://wiki.gnumed.de). Is the "gnumed-task" package
available somewhere so we can link to it for other Mandriva
users ?

This is how the open source community works, thanks. Keep on
and we'll help where needed.

> A search on gnumed-devel for "Cannot bootstrap bundles" give no results.
Google has four :-)  none of which is really helpful.

Anyway, the message is just a general "I was unable to to
what was expected of me" thing.

> this ist the redo-v2.log
Good. This helps.

> (/home/letzter/GnuMed/GNUmed-5/Gnumed/pycommon/gmPG2.py:address@hidden):
>  PostgreSQL version (numeric): 8.2
...
> (/home/letzter/GnuMed/GNUmed-5/Gnumed/pycommon/gmPG2.py:address@hidden):
>  PostgreSQL version (string): "PostgreSQL 8.2.3 on i586-mandriva-linux-gnu, 
> compiled by GCC i586-mandriva-linux-gnu-gcc (GCC) 4.1.2 20070115 (prerelease) 
> (4.1.2-0.20070115.1mdv2007.1)"
This should be fine.

> 2007-04-24 17:21:40  [INFO]   (./bootstrap_gm_db_system.py:address@hidden):  
> trying DB connection to gnumed_v2 on localhost as postgres
...
> 2007-04-24 17:21:40  [INFO]   (./bootstrap_gm_db_system.py:address@hidden):  
> successfully connected
Good.

> 2007-04-24 17:21:40  [DATA] 
> (/home/letzter/GnuMed/GNUmed-5/Gnumed/pycommon/gmPsql.py:address@hidden): 
> create language 'plpgsql'
Trying to set up a procedural language. The command is taken
from the PG documentation and is supposed to work on PG 8.2,
too. I just double-checked.

> 2007-04-24 17:21:40  [DATA]
> (/home/letzter/GnuMed/GNUmed-5/Gnumed/pycommon/gmPsql.py:address@hidden):
> ../sql/gmCreateProceduralLanguages.sql:20:  konnte nicht auf Datei 
> ??$libdir/plpgsql?? zugreifen: Datei oder Verzeichnis nicht gefunden
Aha, aha. Maybe in Mandriva one needs to install one more
package containing the procedural language plpgsql ?

A quick search on Google reveals:

        postgresql-plpgsql-8.0.9-0.1.20060mdk.i586.rpm

Please double-check whether "gnumed-task" installs the
appropriate postgresql-plpgsql-8.2.*.rpm and ask doktor5000
to include it.

> 2007-04-24 17:21:40  [DATA]
> (/home/letzter/GnuMed/GNUmed-5/Gnumed/pycommon/gmPsql.py:address@hidden):
> SELECT CASE
>       WHEN (SELECT COUNT(oid) > 0 FROM pg_language WHERE lanname = 'plpgsql')
> THEN
>               true
>       ELSE
>               (SELECT make_plpgsql())
>     END
> 
> 2007-04-24 17:21:40  [DATA]
> (/home/letzter/GnuMed/GNUmed-5/Gnumed/pycommon/gmPsql.py:address@hidden):
> ../sql/gmCreateProceduralLanguages.sql:42:  konnte nicht auf Datei
> ??plpgsql?? zugreifen: Datei oder Verzeichnis nicht gefundenCONTEXT:
> SQL-Funktion ??make_plpgsql?? Anweisung 1
Same here. We are trying several ways of loading the
language for maximum fault tolerance but both fail with the
same error - indicative of a missing package.

> 2007-04-24 17:21:40  [DATA]
> (/home/letzter/GnuMed/GNUmed-5/Gnumed/pycommon/gmPsql.py:address@hidden):
> create or replace function gm_create_user(name, text)
>       returns boolean
>       language 'plpgsql'
>       security definer
>       as '
> DECLARE
>       _username alias for $1;
>       _password alias for $2;
>       _database text;
>       _query text;
> BEGIN
>       perform 1 from pg_user where usename = _username;
>       if not FOUND then
>               _query := ''create user '' || quote_ident(_username)
>                                       || '' with password '' || 
> quote_literal(_password)
>                                       || '';'';
>               execute _query;
>               perform 1 from pg_user where usename = _username;
>               if not FOUND then
>                       raise exception ''cannot create user [%]'', _username;
>                       return false;
>               end if;
>       end if;
>       _query := ''alter group "gm-logins" add user '' ||
> quote_ident(_username) || '';'';
>       execute _query;
>       _query := ''alter group "gm-doctors" add user '' ||
> quote_ident(_username) || '';'';
>       execute _query;
>       _query := ''alter group "gm-public" add user '' ||
> quote_ident(_username) || '';'';
>       execute _query;
>       -- satisfy "database = samegroup" in pg_hba.conf
>       select into _database current_database();
>       _query := ''alter group '' || quote_ident(_database) || '' add user ''
> || quote_ident(_username) || '';'';
>       execute _query;
>       return true;
> END;'
> 2007-04-24 17:21:40  [ERROR]
> (/home/letzter/GnuMed/GNUmed-5/Gnumed/pycommon/gmPsql.py:address@hidden):
> ../sql/gmCreateUserFunction.sql:49:  Sprache ??plpgsql?? existiert
> nichtHINT:  Sie m??ssen CREATE LANGUAGE verwenden, um die Sprache in die
> Datenbank zu laden.
Then of course, subsequent use of the language will fail ...

> (./bootstrap_gm_db_system.py:address@hidden):  Cannot bootstrap bundle 
> [config].
Which leads to the error message you reported.

> any hint what wrong?
Hope that helps.

Detailed logs sure are a nice thing :-)


Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346