[Obm] MiniG access not allowed

Sun Dec 12 14:09:31 CET 2010

Bonjour,

Le Sun, Dec 12, 2010 at 11:10:19AM +0100, Tony Galmiche écrivait:
> Mais quand je veux accéder au webmail avec n'importe quel utilisateur, 
> j'ai ce message :
> -> MiniG access not allowed.
> 
> Dans /var/log/minig/minig-backend.log, j'ai  :
> -> 2010-12-12 11:05:02,721 JDBCCacheTemplate ERROR - Unexpected 
> rollback: ERREUR: la colonne « can_create_subfolder » de la relation « 
> minig_subscribed_folders » n'existe pas

Il me semble avoir rencontré ce problème (parmis tant d'autres!) et
l'avoir corrigé avec le schéma de la base SGBD ci-joint.

-- 

------------------------------------------------------------------------------
Vishaal Golam - Centre de Ressources Informatiques
Université Paris-Est - Marne-la-Vallée
Cité Descartes - 5,bld Descartes-Champs-sur-Marne-77454 Marne-la-Vallée Cedex2
Tél : +33 (0)1 60 95 74 55  Fax : 74 60  E-mail :Vishaal.Golam(at)univ-mlv.fr
-------------------------------------------------------------------------------
-------------- next part --------------
--
-- PostgreSQL database dump
--

SET client_encoding = 'LATIN9';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: minig_available_folders; Type: TABLE; Schema: public; Owner: minigadm; Tablespace: 
--

CREATE TABLE minig_available_folders (
    id integer NOT NULL,
    name text NOT NULL,
    display_name text NOT NULL,
    subscribed boolean NOT NULL,
    shared boolean NOT NULL,
    minig_cache integer,
    can_create_subfolder boolean NOT NULL
);

ALTER TABLE public.minig_available_folders OWNER TO minigadm;

--
-- Name: minig_available_folders_id_seq; Type: SEQUENCE; Schema: public; Owner: minigadm
--

CREATE SEQUENCE minig_available_folders_id_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;

ALTER TABLE public.minig_available_folders_id_seq OWNER TO minigadm;

--
-- Name: minig_available_folders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: minigadm
--

ALTER SEQUENCE minig_available_folders_id_seq OWNED BY minig_available_folders.id;

--
-- Name: minig_cache; Type: TABLE; Schema: public; Owner: minigadm; Tablespace: 
--

CREATE TABLE minig_cache (
    id integer NOT NULL,
    user_id character varying(255) NOT NULL
);

ALTER TABLE public.minig_cache OWNER TO minigadm;

--
-- Name: minig_cache_id_seq; Type: SEQUENCE; Schema: public; Owner: minigadm
--

CREATE SEQUENCE minig_cache_id_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;

ALTER TABLE public.minig_cache_id_seq OWNER TO minigadm;

--
-- Name: minig_cache_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: minigadm
--

ALTER SEQUENCE minig_cache_id_seq OWNED BY minig_cache.id;

--
-- Name: minig_filters; Type: TABLE; Schema: public; Owner: minigadm; Tablespace: 
--

CREATE TABLE minig_filters (
    id integer NOT NULL,
    criteria text NOT NULL,
    star boolean NOT NULL,
    mark_read boolean NOT NULL,
    delete_it boolean NOT NULL,
    forward character varying(255),
    deliver character varying(255),
    minig_cache integer
);

ALTER TABLE public.minig_filters OWNER TO minigadm;

--
-- Name: minig_filters_id_seq; Type: SEQUENCE; Schema: public; Owner: minigadm
--

CREATE SEQUENCE minig_filters_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;

ALTER TABLE public.minig_filters_id_seq OWNER TO minigadm;

--
-- Name: minig_filters_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: minigadm
--

ALTER SEQUENCE minig_filters_id_seq OWNED BY minig_filters.id;

--
-- Name: minig_signature; Type: TABLE; Schema: public; Owner: minigadm; Tablespace: 
--

CREATE TABLE minig_signature (
    email character varying(255) NOT NULL,
    signature text NOT NULL,
    minig_cache integer
);

ALTER TABLE public.minig_signature OWNER TO minigadm;

--
-- Name: minig_subscribed_folders; Type: TABLE; Schema: public; Owner: minigadm; Tablespace: 
--

CREATE TABLE minig_subscribed_folders (
    id integer NOT NULL,
    name text NOT NULL,
    display_name text NOT NULL,
    shared boolean NOT NULL,
    minig_cache integer,
    can_create_subfolder boolean NOT NULL
);

ALTER TABLE public.minig_subscribed_folders OWNER TO minigadm;

--
-- Name: minig_subscribed_folders_id_seq; Type: SEQUENCE; Schema: public; Owner: minigadm
--

CREATE SEQUENCE minig_subscribed_folders_id_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;

ALTER TABLE public.minig_subscribed_folders_id_seq OWNER TO minigadm;

--
-- Name: minig_subscribed_folders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: minigadm
--

ALTER SEQUENCE minig_subscribed_folders_id_seq OWNED BY minig_subscribed_folders.id;

--
-- Name: minig_uids; Type: TABLE; Schema: public; Owner: minigadm; Tablespace: 
--

CREATE TABLE minig_uids (
    folder_id integer,
    uid integer NOT NULL,
    minig_cache integer
);

ALTER TABLE public.minig_uids OWNER TO minigadm;

--
-- Name: notification; Type: TABLE; Schema: public; Owner: minigadm; Tablespace: 
--

CREATE TABLE notification (
    status integer NOT NULL,
    mid integer NOT NULL,
    minig_cache integer
);

ALTER TABLE public.notification OWNER TO minigadm;

--
-- Name: id; Type: DEFAULT; Schema: public; Owner: minigadm
--

ALTER TABLE minig_available_folders ALTER COLUMN id SET DEFAULT nextval('minig_available_folders_id_seq'::regclass);

--
-- Name: id; Type: DEFAULT; Schema: public; Owner: minigadm
--

ALTER TABLE minig_cache ALTER COLUMN id SET DEFAULT nextval('minig_cache_id_seq'::regclass);

--
-- Name: id; Type: DEFAULT; Schema: public; Owner: minigadm
--

ALTER TABLE minig_filters ALTER COLUMN id SET DEFAULT nextval('minig_filters_id_seq'::regclass);

--
-- Name: id; Type: DEFAULT; Schema: public; Owner: minigadm
--

ALTER TABLE minig_subscribed_folders ALTER COLUMN id SET DEFAULT nextval('minig_subscribed_folders_id_seq'::regclass);

--
-- Name: minig_available_folders_pkey; Type: CONSTRAINT; Schema: public; Owner: minigadm; Tablespace: 
--

ALTER TABLE ONLY minig_available_folders
    ADD CONSTRAINT minig_available_folders_pkey PRIMARY KEY (id);

--
-- Name: minig_cache_pkey; Type: CONSTRAINT; Schema: public; Owner: minigadm; Tablespace: 
--

ALTER TABLE ONLY minig_cache
    ADD CONSTRAINT minig_cache_pkey PRIMARY KEY (id);

--
-- Name: minig_filters_pkey; Type: CONSTRAINT; Schema: public; Owner: minigadm; Tablespace: 
--

ALTER TABLE ONLY minig_filters
    ADD CONSTRAINT minig_filters_pkey PRIMARY KEY (id);

--
-- Name: minig_subscribed_folders_pkey; Type: CONSTRAINT; Schema: public; Owner: minigadm; Tablespace: 
--

ALTER TABLE ONLY minig_subscribed_folders
    ADD CONSTRAINT minig_subscribed_folders_pkey PRIMARY KEY (id);

--
-- Name: signature_pk; Type: CONSTRAINT; Schema: public; Owner: minigadm; Tablespace: 
--

ALTER TABLE ONLY minig_signature
    ADD CONSTRAINT signature_pk PRIMARY KEY (email);

--
-- Name: idx_available_folders_cache; Type: INDEX; Schema: public; Owner: minigadm; Tablespace: 
--

CREATE INDEX idx_available_folders_cache ON minig_available_folders USING btree (minig_cache);

--
-- Name: idx_cache_user_id; Type: INDEX; Schema: public; Owner: minigadm; Tablespace: 
--

CREATE INDEX idx_cache_user_id ON minig_cache USING btree (user_id);

--
-- Name: idx_notification; Type: INDEX; Schema: public; Owner: minigadm; Tablespace: 
--

CREATE UNIQUE INDEX idx_notification ON notification USING btree (mid, minig_cache);

--
-- Name: idx_subscribed_folders_cache; Type: INDEX; Schema: public; Owner: minigadm; Tablespace: 
--

CREATE INDEX idx_subscribed_folders_cache ON minig_subscribed_folders USING btree (minig_cache);

--
-- Name: idx_uids_cache; Type: INDEX; Schema: public; Owner: minigadm; Tablespace: 
--

CREATE INDEX idx_uids_cache ON minig_uids USING btree (minig_cache);

--
-- Name: idx_uids_folder_id; Type: INDEX; Schema: public; Owner: minigadm; Tablespace: 
--

CREATE INDEX idx_uids_folder_id ON minig_uids USING btree (folder_id);

--
-- Name: minig_available_folders_minig_cache_fkey; Type: FK CONSTRAINT; Schema: public; Owner: minigadm
--

ALTER TABLE ONLY minig_available_folders
    ADD CONSTRAINT minig_available_folders_minig_cache_fkey FOREIGN KEY (minig_cache) REFERENCES minig_cache(id) ON DELETE CASCADE;

--
-- Name: minig_filters_minig_cache_fkey; Type: FK CONSTRAINT; Schema: public; Owner: minigadm
--

ALTER TABLE ONLY minig_filters
    ADD CONSTRAINT minig_filters_minig_cache_fkey FOREIGN KEY (minig_cache) REFERENCES minig_cache(id) ON DELETE CASCADE;

--
-- Name: minig_signature_minig_cache_fkey; Type: FK CONSTRAINT; Schema: public; Owner: minigadm
--

ALTER TABLE ONLY minig_signature
    ADD CONSTRAINT minig_signature_minig_cache_fkey FOREIGN KEY (minig_cache) REFERENCES minig_cache(id) ON DELETE CASCADE;

--
-- Name: minig_subscribed_folders_minig_cache_fkey; Type: FK CONSTRAINT; Schema: public; Owner: minigadm
--

ALTER TABLE ONLY minig_subscribed_folders
    ADD CONSTRAINT minig_subscribed_folders_minig_cache_fkey FOREIGN KEY (minig_cache) REFERENCES minig_cache(id) ON DELETE CASCADE;

--
-- Name: minig_uids_folder_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: minigadm
--

ALTER TABLE ONLY minig_uids
    ADD CONSTRAINT minig_uids_folder_id_fkey FOREIGN KEY (folder_id) REFERENCES minig_subscribed_folders(id) ON DELETE CASCADE;

--
-- Name: minig_uids_minig_cache_fkey; Type: FK CONSTRAINT; Schema: public; Owner: minigadm
--

ALTER TABLE ONLY minig_uids
    ADD CONSTRAINT minig_uids_minig_cache_fkey FOREIGN KEY (minig_cache) REFERENCES minig_cache(id) ON DELETE CASCADE;

--
-- Name: notification_minig_cache_fkey; Type: FK CONSTRAINT; Schema: public; Owner: minigadm
--

ALTER TABLE ONLY notification
    ADD CONSTRAINT notification_minig_cache_fkey FOREIGN KEY (minig_cache) REFERENCES minig_cache(id) ON DELETE CASCADE;

--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;

--
-- PostgreSQL database dump complete
--