[netmagis] Re: upgrade netmagis 2.0 to 2.1 and 2.2
- From: pierre Labanowski <pierre.labanowski@xxxxxxxxx>
- To: netmagis@xxxxxxxxxxxxx
- Date: Wed, 22 Jan 2014 11:38:15 +0100
Hi,
sorry for flooding on the mailing list. I solved my problems.
I just run the script sql on sql22 directory. And i changed the owner of
some table.
Netmagis works fine.
Regards,
Le 18/01/2014 15:34, Pierre Labanowski a écrit :
> 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:
