[netmagis] upgrade netmagis 2.0 to 2.1 and 2.2
- From: pierre Labanowski <pierre.labanowski@xxxxxxx>
- To: netmagis@xxxxxxxxxxxxx
- Date: Fri, 17 Jan 2014 19:30:48 +0100
Hello,
I'm upgrading my Database netmagis 2.0 to version 2.2. ( info:my
database has already migrated from 1.5 to 2.0)
- I think the upgrade of the database 2.0 to 2.1 is a success
- To upgrade from 2.1 to 2.2 I modify the file upgrade.sql (line 188 and
line 200). I don't have a table "global.seq_groupe" and
"global.seq_corresp" in my view global. but in my database this table is
on dns view. I found both the change in the upgrade file on 1.5 to 2.0.
my change :
ligne 188 : ALTER TABLE dns.seq_groupe RENAME TO seq_nmgroup ;
ligne 200 : ALTER TABLE dns.seq_corresp RENAME TO seq_nmuser ;
I don't know if this change to affect for more ...
I get an error at the end of script :
psql:upgrade.sql:428: %NMLIBDIR%/sql22/functions.sql : Aucun fichier ou
dossier de ce type
psql:upgrade.sql:429: %NMLIBDIR%/sql22/triggers.sql : Aucun fichier ou
dossier de ce type
It's this normal ?
select * from global.config where key = 'schemaversion';
key | value
---------------+-------
schemaversion | 22
- I also have another small problem with apache: "Internal Server Error"
===================================================
ERREUR: droit refus� pour la relation p_l2only
while executing
"pg_select $dbfd $sql tab {
lappend lvlan $tab(vlanid)
}"
(procedure "allowed-l2only" line 8)
invoked from within
"allowed-l2only $dbfd $tabuid(idgrp)"
(procedure "read-user" line 71)
invoked from within
"read-user $dbfd $login tabuid msg"
(procedure "init-common" line 103)
invoked from within
"init-common $selfns dbfd "cgi" $login "id" false tabuid"
(procedure "::netmagis::Snit_methodcgi-dispatch" line 66)
invoked from within
"d cgi-dispatch "dns" """
(file "/local/netmagis/www/netmagis/index" line 60)
===================================================
if you have an idea ?
Thx,
Pierre
note : vraiment désolé pour mon anglais. Vous pouvez me répondre en
français si besoin :p
Other related posts:
