[netmagis] Re: upgrade netmagis 2.0 to 2.1 and 2.2
- From: Pierre Labanowski <pierre.labanowski@xxxxxxxxx>
- To: netmagis@xxxxxxxxxxxxx
- Date: Sat, 18 Jan 2014 15:34:39 +0100
Hello,
My problem with apache is that i've the error "p_l2only", i have changed
the owner on this table for the owner "nm"
with this command :
---------------
/alter table topo.p_l2only owner to nm;/
---------------
I've changed another owner for this table :
---------------
/dns.view//
//dns.p_view//
//topo.p_l2only//
//topo.confcmd//
//topo.dotattr//
//topo.link//
//
//topo.seq_link//
//topo.seq_confcmd//
//dns.seq_view/
---------------
I don't have the error on "p_l2only" ... Now netmagis index works fine.
But, i have a new error on script "edit" :
---------------
/webapp/edit: ERREUR: la fonction dns.check_ip_cor(unknown, integer)
n'existe pas//
//LINE 1: SELECT dns.check_ip_cor ('164.81.32.198', 4) AS ok//
// ^//
//HINT: Aucune fonction ne correspond au nom donn� et aux types
d'arguments.//
//Vous devez ajouter des conversions explicites de type.//
//
// while executing//
//"pg_select $dbfd $sql tab {//
// set r [string equal $tab(ok) "t"]//
// }"//
// (procedure "check-authorized-ip" line 4)//
// invoked from within//
//"check-authorized-ip $dbfd $idcor $addr"//
// invoked from within//
//"catch $script msg"/
-------------------
and script "add"
-------------------
/Erreur dans le CIDR '164.81.32.0/21' : SELECT * FROM dns.mark_cidr
('164.81.32.0/21', 16384, 1) : ERREUR: la fonction
dns.mark_cidr(unknown, integer, integer) n'existe pas
LINE 1: SELECT * FROM dns.mark_cidr ('164.81.32.0/21', 16384, 1)
^
HINT: Aucune fonction ne correspond au nom donné et aux types d'arguments.
Vous devez ajouter des conversions explicites de type.//
//
//webapp/add: ERREUR: la fonction dns.ipranges(unknown, integer,
integer) n'existe pas//
//LINE 2: FROM dns.ipranges ('10.40.1.0/24', 65536, 1)//
// ^//
//HINT: Aucune fonction ne correspond au nom donn� et aux types
d'arguments.//
//Vous devez ajouter des conversions explicites de type.//
//
// while executing//
//"pg_select $dbfd $sql tab {//
// lappend lranges [list $tab(a) $tab(n)]//
// }"//
// invoked from within//
//"catch $script msg"/
-------------------
if you have any idea ? i'm seeking a solution!
Regards,
Pierre Labanowski
Le 17/01/2014 19:30, pierre Labanowski a écrit :
> 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:
