Context Navigation

← Previous Ticket
Next Ticket →

Modify ↓

Ticket #2870 (closed defect: fixed)

Opened 2 years ago

Last modified 2 years ago

PgDBEngine: ERROR: syntax error at or near "-"

Reported by:	didier@…	Owned by:	jamor@…
Milestone:	2.0.X	Component:	base
Severity:	normal	Keywords:
Cc:

Description

Hi,

Looking my logs in /var/log/ebox/ebox.log, I've found a couple of this kind of error:

ERROR> PgDBEngine.pm:440 EBox::PgDBEngine::do - Error doing statement: UPDATE mailfilter_smtp_traffic_hourly SET mta-blocked = mta-blocked + 1 WHERE (date = '2011-05-03 20:00:00') , ERROR:  syntax error at or near "-"
LINE 1: UPDATE mailfilter_smtp_traffic_hourly SET mta-blocked = mta-...
                                                     ^

I've tried to reinstall ebox-mailfilter, but that did not solve my problem.

Attachments

Change History

comment:1 Changed 2 years ago by jamor@…

Owner changed from jacalvo@… to jamor@…
Status changed from new to assigned

Thanks for you bug report Didier. However to reproduce it I would need the contents of your mailfilter_smtp database table. to be able to debug this problem.

To get the table contents execute this command as superuser:

su postgres -c'pg_dump -t mailfilter_smtp --clean -f /tmp/dump.sql eboxlogs '

Then mail me the /tm/dump.sql file to jamor at zentyal.com

Thanks

comment:2 Changed 2 years ago by jacalvo@…

Status changed from assigned to closed
Resolution set to worksforme

Please reopen if you can provide the requested information.

comment:3 Changed 2 years ago by didier@…

Status changed from closed to reopened
Resolution worksforme deleted

Hi,

It's seem that you did not receive my email...

So here are the requested logs without sensitive data:

> pg_dump -t mailfilter_smtp --clean -f /tmp/dump.sql

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
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;

DROP INDEX public.mailfilter_smtp_timestamp_i;
DROP TABLE public.mailfilter_smtp;
SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: mailfilter_smtp; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mailfilter_smtp (
    "timestamp" timestamp without time zone NOT NULL,
    event character varying(255) NOT NULL,
    action character varying(255) NOT NULL,
    from_address character varying(320) NOT NULL,
    to_address character varying(320) NOT NULL,
    spam_hits double precision
);


ALTER TABLE public.mailfilter_smtp OWNER TO postgres;

--
-- Data for Name: mailfilter_smtp; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY mailfilter_smtp ("timestamp", event, action, from_address, to_address, spam_hits) FROM stdin;
[...]

--
-- Name: mailfilter_smtp_timestamp_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX mailfilter_smtp_timestamp_i ON mailfilter_smtp USING btree ("timestamp");


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

REVOKE ALL ON TABLE mailfilter_smtp FROM PUBLIC;
REVOKE ALL ON TABLE mailfilter_smtp FROM postgres;
GRANT ALL ON TABLE mailfilter_smtp TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mailfilter_smtp TO ebox;


--
-- PostgreSQL database dump complete
--

> pg_dump --schema-only --clean -f /tmp/schema-only.sql eboxlogs

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
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;

DROP INDEX public.sysinfo_disk_usage_timestamp_i;
DROP INDEX public.samba_virus_timestamp_i;
DROP INDEX public.samba_quarantine_timestamp_i;
DROP INDEX public.samba_access_timestamp_i;
DROP INDEX public.printers_usage_report_job_i;
DROP INDEX public.printers_pages_job_i;
DROP INDEX public.printers_jobs_timestamp_i;
DROP INDEX public.printers_jobs_report_date_i;
DROP INDEX public.openvpn_timestamp_i;
DROP INDEX public.mailfilter_smtp_traffic_weekly_date_i;
DROP INDEX public.mailfilter_smtp_traffic_monthly_date_i;
DROP INDEX public.mailfilter_smtp_traffic_hourly_date_i;
DROP INDEX public.mailfilter_smtp_traffic_daily_date_i;
DROP INDEX public.mailfilter_smtp_timestamp_i;
DROP INDEX public.mailfilter_pop_traffic_weekly_date_i;
DROP INDEX public.mailfilter_pop_traffic_monthly_date_i;
DROP INDEX public.mailfilter_pop_traffic_hourly_date_i;
DROP INDEX public.mailfilter_pop_traffic_daily_date_i;
DROP INDEX public.mailfilter_pop_timestamp_i;
DROP INDEX public.mail_message_timestamp_i;
DROP INDEX public.leases_timestamp_i;
DROP INDEX public.ids_timestamp_i;
DROP INDEX public.ids_alert_weekly_date_i;
DROP INDEX public.ids_alert_monthly_date_i;
DROP INDEX public.ids_alert_hourly_date_i;
DROP INDEX public.ids_alert_daily_date_i;
DROP INDEX public.firewall_timestamp_i;
DROP INDEX public.firewall_packet_traffic_weekly_date_i;
DROP INDEX public.firewall_packet_traffic_monthly_date_i;
DROP INDEX public.firewall_packet_traffic_hourly_date_i;
DROP INDEX public.firewall_packet_traffic_daily_date_i;
DROP INDEX public.ebackup_storage_usage_timestamp_i;
DROP INDEX public.ebackup_stats_timestamp_i;
DROP INDEX public.backup_slices_i;
ALTER TABLE public.events ALTER COLUMN id DROP DEFAULT;
DROP TABLE public.sysinfo_disk_usage_report;
DROP TABLE public.sysinfo_disk_usage;
DROP TABLE public.samba_virus_share_report;
DROP TABLE public.samba_virus_report;
DROP TABLE public.samba_virus;
DROP TABLE public.samba_quarantine;
DROP TABLE public.samba_disk_usage_report;
DROP TABLE public.samba_disk_usage;
DROP TABLE public.samba_access_report;
DROP TABLE public.samba_access;
DROP TABLE public.report_consolidation;
DROP TABLE public.printers_usage_report;
DROP TABLE public.printers_pages;
DROP TABLE public.printers_jobs_report;
DROP TABLE public.printers_jobs_by_user_report;
DROP TABLE public.printers_jobs;
DROP TABLE public.openvpn_report;
DROP TABLE public.openvpn;
DROP TABLE public.mailfilter_smtp_traffic_weekly;
DROP TABLE public.mailfilter_smtp_traffic_monthly;
DROP TABLE public.mailfilter_smtp_traffic_hourly;
DROP TABLE public.mailfilter_smtp_traffic_daily;
DROP TABLE public.mailfilter_smtp_report;
DROP TABLE public.mailfilter_smtp;
DROP TABLE public.mailfilter_pop_traffic_weekly;
DROP TABLE public.mailfilter_pop_traffic_monthly;
DROP TABLE public.mailfilter_pop_traffic_hourly;
DROP TABLE public.mailfilter_pop_traffic_daily;
DROP TABLE public.mailfilter_pop_report;
DROP TABLE public.mailfilter_pop;
DROP TABLE public.mail_traffic_weekly;
DROP TABLE public.mail_traffic_monthly;
DROP TABLE public.mail_traffic_hourly;
DROP TABLE public.mail_traffic_daily;
DROP TABLE public.mail_message_traffic_weekly;
DROP TABLE public.mail_message_traffic_monthly;
DROP TABLE public.mail_message_traffic_hourly;
DROP TABLE public.mail_message_traffic_daily;
DROP TABLE public.mail_message_report;
DROP TABLE public.mail_message;
DROP TABLE public.leases;
DROP TABLE public.ids_report;
DROP TABLE public.ids_event;
DROP TABLE public.ids_alert_weekly;
DROP TABLE public.ids_alert_monthly;
DROP TABLE public.ids_alert_hourly;
DROP TABLE public.ids_alert_daily;
DROP TABLE public.firewall_report;
DROP TABLE public.firewall_packet_traffic_weekly;
DROP TABLE public.firewall_packet_traffic_monthly;
DROP TABLE public.firewall_packet_traffic_hourly;
DROP TABLE public.firewall_packet_traffic_daily;
DROP TABLE public.firewall;
DROP TABLE public.events_report;
DROP SEQUENCE public.events_id_seq;
DROP TABLE public.events_accummulated_weekly;
DROP TABLE public.events_accummulated_monthly;
DROP TABLE public.events_accummulated_hourly;
DROP TABLE public.events_accummulated_daily;
DROP TABLE public.events;
DROP TABLE public.ebackup_storage_usage_report;
DROP TABLE public.ebackup_storage_usage;
DROP TABLE public.ebackup_stats;
DROP TABLE public.consolidation;
DROP TABLE public.backup_slices;
DROP TABLE public.admin;
DROP TYPE public.b_type;
DROP SCHEMA public;
--
-- Name: public; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA public;


ALTER SCHEMA public OWNER TO postgres;

--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'standard public schema';


SET search_path = public, pg_catalog;

--
-- Name: b_type; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE b_type AS ENUM (
    'full',
    'incremental'
);


ALTER TYPE public.b_type OWNER TO postgres;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: admin; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE admin (
    "timestamp" timestamp without time zone,
    source character varying(20),
    module character varying(40),
    action character varying(40),
    params character varying(200),
    committed boolean
);


ALTER TABLE public.admin OWNER TO postgres;

--
-- Name: backup_slices; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE backup_slices (
    tablename character varying(40) NOT NULL,
    id bigint NOT NULL,
    begints timestamp without time zone NOT NULL,
    endts timestamp without time zone NOT NULL,
    archived boolean DEFAULT false,
    timeline integer NOT NULL
);


ALTER TABLE public.backup_slices OWNER TO postgres;

--
-- Name: consolidation; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE consolidation (
    consolidatedtable character varying(40) NOT NULL,
    lastdate timestamp without time zone NOT NULL
);


ALTER TABLE public.consolidation OWNER TO postgres;

--
-- Name: ebackup_stats; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE ebackup_stats (
    "timestamp" timestamp without time zone,
    elapsed bigint,
    files_num integer,
    new_files_num integer,
    del_files_num integer,
    changed_files_num integer,
    size bigint,
    errors integer,
    type b_type
);


ALTER TABLE public.ebackup_stats OWNER TO postgres;

--
-- Name: ebackup_storage_usage; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE ebackup_storage_usage (
    "timestamp" timestamp without time zone,
    used bigint,
    available bigint
);


ALTER TABLE public.ebackup_storage_usage OWNER TO postgres;

--
-- Name: ebackup_storage_usage_report; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE ebackup_storage_usage_report (
    date date,
    used bigint,
    available bigint
);


ALTER TABLE public.ebackup_storage_usage_report OWNER TO postgres;

--
-- Name: events; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE events (
    id integer NOT NULL,
    "timestamp" timestamp without time zone,
    lasttimestamp timestamp without time zone,
    nrepeated integer DEFAULT 1,
    level character varying(6),
    source character varying(256),
    message character varying(256)
);


ALTER TABLE public.events OWNER TO postgres;

--
-- Name: events_accummulated_daily; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE events_accummulated_daily (
    date timestamp without time zone NOT NULL,
    source character varying(256),
    info integer DEFAULT 0,
    warn integer DEFAULT 0,
    error integer DEFAULT 0,
    fatal integer DEFAULT 0
);


ALTER TABLE public.events_accummulated_daily OWNER TO postgres;

--
-- Name: events_accummulated_hourly; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE events_accummulated_hourly (
    date timestamp without time zone NOT NULL,
    source character varying(256),
    info integer DEFAULT 0,
    warn integer DEFAULT 0,
    error integer DEFAULT 0,
    fatal integer DEFAULT 0
);


ALTER TABLE public.events_accummulated_hourly OWNER TO postgres;

--
-- Name: events_accummulated_monthly; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE events_accummulated_monthly (
    date timestamp without time zone NOT NULL,
    source character varying(256),
    info integer DEFAULT 0,
    warn integer DEFAULT 0,
    error integer DEFAULT 0,
    fatal integer DEFAULT 0
);


ALTER TABLE public.events_accummulated_monthly OWNER TO postgres;

--
-- Name: events_accummulated_weekly; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE events_accummulated_weekly (
    date timestamp without time zone NOT NULL,
    source character varying(256),
    info integer DEFAULT 0,
    warn integer DEFAULT 0,
    error integer DEFAULT 0,
    fatal integer DEFAULT 0
);


ALTER TABLE public.events_accummulated_weekly OWNER TO postgres;

--
-- Name: events_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER TABLE public.events_id_seq OWNER TO postgres;

--
-- Name: events_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE events_id_seq OWNED BY events.id;


--
-- Name: events_report; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE events_report (
    date date,
    level character varying(6),
    source character varying(256),
    nevents integer DEFAULT 0
);


ALTER TABLE public.events_report OWNER TO postgres;

--
-- Name: firewall; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE firewall (
    fw_in character varying(16),
    fw_out character varying(16),
    fw_src inet,
    fw_dst inet,
    fw_proto character varying(16),
    fw_spt integer,
    fw_dpt integer,
    event character varying(16),
    "timestamp" timestamp without time zone
);


ALTER TABLE public.firewall OWNER TO postgres;

--
-- Name: firewall_packet_traffic_daily; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE firewall_packet_traffic_daily (
    date timestamp without time zone NOT NULL,
    drop bigint DEFAULT 0
);


ALTER TABLE public.firewall_packet_traffic_daily OWNER TO postgres;

--
-- Name: firewall_packet_traffic_hourly; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE firewall_packet_traffic_hourly (
    date timestamp without time zone NOT NULL,
    drop bigint DEFAULT 0
);


ALTER TABLE public.firewall_packet_traffic_hourly OWNER TO postgres;

--
-- Name: firewall_packet_traffic_monthly; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE firewall_packet_traffic_monthly (
    date timestamp without time zone NOT NULL,
    drop bigint DEFAULT 0
);


ALTER TABLE public.firewall_packet_traffic_monthly OWNER TO postgres;

--
-- Name: firewall_packet_traffic_weekly; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE firewall_packet_traffic_weekly (
    date timestamp without time zone NOT NULL,
    drop bigint DEFAULT 0
);


ALTER TABLE public.firewall_packet_traffic_weekly OWNER TO postgres;

--
-- Name: firewall_report; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE firewall_report (
    date date,
    event character varying(16),
    source inet,
    proto character varying(16),
    dport integer,
    packets bigint
);


ALTER TABLE public.firewall_report OWNER TO postgres;

--
-- Name: ids_alert_daily; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE ids_alert_daily (
    date timestamp without time zone NOT NULL,
    alert bigint DEFAULT 0
);


ALTER TABLE public.ids_alert_daily OWNER TO postgres;

--
-- Name: ids_alert_hourly; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE ids_alert_hourly (
    date timestamp without time zone NOT NULL,
    alert bigint DEFAULT 0
);


ALTER TABLE public.ids_alert_hourly OWNER TO postgres;

--
-- Name: ids_alert_monthly; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE ids_alert_monthly (
    date timestamp without time zone NOT NULL,
    alert bigint DEFAULT 0
);


ALTER TABLE public.ids_alert_monthly OWNER TO postgres;

--
-- Name: ids_alert_weekly; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE ids_alert_weekly (
    date timestamp without time zone NOT NULL,
    alert bigint DEFAULT 0
);


ALTER TABLE public.ids_alert_weekly OWNER TO postgres;

--
-- Name: ids_event; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE ids_event (
    priority integer,
    description character varying(128),
    source character varying(32),
    dest character varying(32),
    protocol character varying(16),
    "timestamp" timestamp without time zone,
    event character varying(8)
);


ALTER TABLE public.ids_event OWNER TO postgres;

--
-- Name: ids_report; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE ids_report (
    date date,
    source character varying(32),
    priority1 bigint DEFAULT 0,
    priority2 bigint DEFAULT 0,
    priority3 bigint DEFAULT 0,
    priority4 bigint DEFAULT 0,
    priority5 bigint DEFAULT 0
);


ALTER TABLE public.ids_report OWNER TO postgres;

--
-- Name: leases; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE leases (
    interface character(16),
    mac macaddr,
    ip inet,
    "timestamp" timestamp without time zone,
    event character varying(255)
);


ALTER TABLE public.leases OWNER TO postgres;

--
-- Name: mail_message; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mail_message (
    "timestamp" timestamp without time zone NOT NULL,
    qid character varying(50),
    message_id character varying(340),
    client_host_ip inet NOT NULL,
    client_host_name character varying(255) NOT NULL,
    from_address character varying(320),
    to_address character varying(320),
    message_size bigint,
    relay character varying(320),
    message_type character varying(10) NOT NULL,
    status character varying(25),
    message text,
    event character varying(255) NOT NULL
);


ALTER TABLE public.mail_message OWNER TO postgres;

--
-- Name: mail_message_report; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mail_message_report (
    date date,
    client_host_ip character varying(16),
    user_from character varying(255),
    domain_from character varying(255),
    user_to character varying(255),
    domain_to character varying(255),
    event character varying(255),
    message_type character varying(10),
    status character varying(25),
    bytes bigint,
    messages integer
);


ALTER TABLE public.mail_message_report OWNER TO postgres;

--
-- Name: mail_message_traffic_daily; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mail_message_traffic_daily (
    date timestamp without time zone NOT NULL,
    vdomain character varying(300),
    sent bigint DEFAULT 0,
    received bigint DEFAULT 0,
    rejected bigint DEFAULT 0
);


ALTER TABLE public.mail_message_traffic_daily OWNER TO postgres;

--
-- Name: mail_message_traffic_hourly; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mail_message_traffic_hourly (
    date timestamp without time zone NOT NULL,
    vdomain character varying(300),
    sent bigint DEFAULT 0,
    received bigint DEFAULT 0,
    rejected bigint DEFAULT 0
);


ALTER TABLE public.mail_message_traffic_hourly OWNER TO postgres;

--
-- Name: mail_message_traffic_monthly; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mail_message_traffic_monthly (
    date timestamp without time zone NOT NULL,
    vdomain character varying(300),
    sent bigint DEFAULT 0,
    received bigint DEFAULT 0,
    rejected bigint DEFAULT 0
);


ALTER TABLE public.mail_message_traffic_monthly OWNER TO postgres;

--
-- Name: mail_message_traffic_weekly; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mail_message_traffic_weekly (
    date timestamp without time zone NOT NULL,
    vdomain character varying(300),
    sent bigint DEFAULT 0,
    received bigint DEFAULT 0,
    rejected bigint DEFAULT 0
);


ALTER TABLE public.mail_message_traffic_weekly OWNER TO postgres;

--
-- Name: mail_traffic_daily; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mail_traffic_daily (
    date timestamp without time zone NOT NULL,
    vdomain character varying(300),
    sent bigint DEFAULT 0,
    received bigint DEFAULT 0,
    rejected bigint DEFAULT 0
);


ALTER TABLE public.mail_traffic_daily OWNER TO postgres;

--
-- Name: mail_traffic_hourly; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mail_traffic_hourly (
    date timestamp without time zone NOT NULL,
    vdomain character varying(300),
    sent bigint DEFAULT 0,
    received bigint DEFAULT 0,
    rejected bigint DEFAULT 0
);


ALTER TABLE public.mail_traffic_hourly OWNER TO postgres;

--
-- Name: mail_traffic_monthly; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mail_traffic_monthly (
    date timestamp without time zone NOT NULL,
    vdomain character varying(300),
    sent bigint DEFAULT 0,
    received bigint DEFAULT 0,
    rejected bigint DEFAULT 0
);


ALTER TABLE public.mail_traffic_monthly OWNER TO postgres;

--
-- Name: mail_traffic_weekly; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mail_traffic_weekly (
    date timestamp without time zone NOT NULL,
    vdomain character varying(300),
    sent bigint DEFAULT 0,
    received bigint DEFAULT 0,
    rejected bigint DEFAULT 0
);


ALTER TABLE public.mail_traffic_weekly OWNER TO postgres;

--
-- Name: mailfilter_pop; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mailfilter_pop (
    "timestamp" timestamp without time zone NOT NULL,
    address character varying(320),
    clientconn character varying(50) NOT NULL,
    event character varying(255) NOT NULL,
    mails bigint DEFAULT 0,
    clean bigint DEFAULT 0,
    spam bigint DEFAULT 0,
    virus bigint DEFAULT 0
);


ALTER TABLE public.mailfilter_pop OWNER TO postgres;

--
-- Name: mailfilter_pop_report; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mailfilter_pop_report (
    date date NOT NULL,
    event character varying(255) NOT NULL,
    address character varying(320),
    clientconn character varying(50) NOT NULL,
    clean bigint DEFAULT 0,
    spam bigint DEFAULT 0,
    virus bigint DEFAULT 0
);


ALTER TABLE public.mailfilter_pop_report OWNER TO postgres;

--
-- Name: mailfilter_pop_traffic_daily; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mailfilter_pop_traffic_daily (
    date timestamp without time zone NOT NULL,
    mails bigint DEFAULT 0,
    clean bigint DEFAULT 0,
    spam bigint DEFAULT 0,
    virus bigint DEFAULT 0
);


ALTER TABLE public.mailfilter_pop_traffic_daily OWNER TO postgres;

--
-- Name: mailfilter_pop_traffic_hourly; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mailfilter_pop_traffic_hourly (
    date timestamp without time zone NOT NULL,
    mails bigint DEFAULT 0,
    clean bigint DEFAULT 0,
    spam bigint DEFAULT 0,
    virus bigint DEFAULT 0
);


ALTER TABLE public.mailfilter_pop_traffic_hourly OWNER TO postgres;

--
-- Name: mailfilter_pop_traffic_monthly; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mailfilter_pop_traffic_monthly (
    date timestamp without time zone NOT NULL,
    mails bigint DEFAULT 0,
    clean bigint DEFAULT 0,
    spam bigint DEFAULT 0,
    virus bigint DEFAULT 0
);


ALTER TABLE public.mailfilter_pop_traffic_monthly OWNER TO postgres;

--
-- Name: mailfilter_pop_traffic_weekly; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mailfilter_pop_traffic_weekly (
    date timestamp without time zone NOT NULL,
    mails bigint DEFAULT 0,
    clean bigint DEFAULT 0,
    spam bigint DEFAULT 0,
    virus bigint DEFAULT 0
);


ALTER TABLE public.mailfilter_pop_traffic_weekly OWNER TO postgres;

--
-- Name: mailfilter_smtp; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mailfilter_smtp (
    "timestamp" timestamp without time zone NOT NULL,
    event character varying(255) NOT NULL,
    action character varying(255) NOT NULL,
    from_address character varying(320) NOT NULL,
    to_address character varying(320) NOT NULL,
    spam_hits double precision
);


ALTER TABLE public.mailfilter_smtp OWNER TO postgres;

--
-- Name: mailfilter_smtp_report; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mailfilter_smtp_report (
    date date NOT NULL,
    event character varying(255) NOT NULL,
    action character varying(255) NOT NULL,
    from_domain character varying(320) NOT NULL,
    to_domain character varying(320) NOT NULL,
    messages bigint NOT NULL
);


ALTER TABLE public.mailfilter_smtp_report OWNER TO postgres;

--
-- Name: mailfilter_smtp_traffic_daily; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mailfilter_smtp_traffic_daily (
    date timestamp without time zone NOT NULL,
    clean bigint DEFAULT 0,
    spam bigint DEFAULT 0,
    banned bigint DEFAULT 0,
    infected bigint DEFAULT 0,
    bad_header bigint DEFAULT 0,
    blacklisted bigint DEFAULT 0
);


ALTER TABLE public.mailfilter_smtp_traffic_daily OWNER TO postgres;

--
-- Name: mailfilter_smtp_traffic_hourly; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mailfilter_smtp_traffic_hourly (
    date timestamp without time zone NOT NULL,
    clean bigint DEFAULT 0,
    spam bigint DEFAULT 0,
    banned bigint DEFAULT 0,
    infected bigint DEFAULT 0,
    bad_header bigint DEFAULT 0,
    blacklisted bigint DEFAULT 0
);


ALTER TABLE public.mailfilter_smtp_traffic_hourly OWNER TO postgres;

--
-- Name: mailfilter_smtp_traffic_monthly; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mailfilter_smtp_traffic_monthly (
    date timestamp without time zone NOT NULL,
    clean bigint DEFAULT 0,
    spam bigint DEFAULT 0,
    banned bigint DEFAULT 0,
    infected bigint DEFAULT 0,
    bad_header bigint DEFAULT 0,
    blacklisted bigint DEFAULT 0
);


ALTER TABLE public.mailfilter_smtp_traffic_monthly OWNER TO postgres;

--
-- Name: mailfilter_smtp_traffic_weekly; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mailfilter_smtp_traffic_weekly (
    date timestamp without time zone NOT NULL,
    clean bigint DEFAULT 0,
    spam bigint DEFAULT 0,
    banned bigint DEFAULT 0,
    infected bigint DEFAULT 0,
    bad_header bigint DEFAULT 0,
    blacklisted bigint DEFAULT 0
);


ALTER TABLE public.mailfilter_smtp_traffic_weekly OWNER TO postgres;

--
-- Name: openvpn; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE openvpn (
    "timestamp" timestamp without time zone,
    event character varying(60) NOT NULL,
    daemon_name character varying(20),
    daemon_type character varying(10),
    from_ip inet,
    from_cert character varying(100)
);


ALTER TABLE public.openvpn OWNER TO postgres;

--
-- Name: openvpn_report; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE openvpn_report (
    date date,
    daemon_name character varying(20),
    daemon_type character varying(10),
    ip inet,
    certificate character varying(100),
    connections integer
);


ALTER TABLE public.openvpn_report OWNER TO postgres;

--
-- Name: printers_jobs; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE printers_jobs (
    "timestamp" timestamp without time zone,
    job integer,
    printer character varying(255),
    username character varying(255),
    event character varying(20)
);


ALTER TABLE public.printers_jobs OWNER TO postgres;

--
-- Name: printers_jobs_by_user_report; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE printers_jobs_by_user_report (
    username character varying(255),
    date date,
    event character varying(20),
    njobs integer
);


ALTER TABLE public.printers_jobs_by_user_report OWNER TO postgres;

--
-- Name: printers_jobs_report; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE printers_jobs_report (
    printer character varying(255),
    date date,
    event character varying(20),
    njobs integer
);


ALTER TABLE public.printers_jobs_report OWNER TO postgres;

--
-- Name: printers_pages; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE printers_pages (
    "timestamp" timestamp without time zone,
    job integer,
    printer character varying(255),
    pages integer
);


ALTER TABLE public.printers_pages OWNER TO postgres;

--
-- Name: printers_usage_report; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE printers_usage_report (
    date date,
    printer character varying(255),
    pages integer,
    users integer
);


ALTER TABLE public.printers_usage_report OWNER TO postgres;

--
-- Name: report_consolidation; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE report_consolidation (
    report_table character varying(40) NOT NULL,
    last_date timestamp without time zone NOT NULL
);


ALTER TABLE public.report_consolidation OWNER TO postgres;

--
-- Name: samba_access; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE samba_access (
    client inet,
    username character varying(24),
    resource character varying(240),
    event character varying(16),
    "timestamp" timestamp without time zone
);


ALTER TABLE public.samba_access OWNER TO postgres;

--
-- Name: samba_access_report; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE samba_access_report (
    date date,
    username character varying(24),
    operations bigint
);


ALTER TABLE public.samba_access_report OWNER TO postgres;

--
-- Name: samba_disk_usage; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE samba_disk_usage (
    "timestamp" timestamp without time zone NOT NULL,
    share character varying(24) NOT NULL,
    type character varying(10) NOT NULL,
    size integer DEFAULT 0
);


ALTER TABLE public.samba_disk_usage OWNER TO postgres;

--
-- Name: samba_disk_usage_report; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE samba_disk_usage_report (
    date date NOT NULL,
    share character varying(24) NOT NULL,
    type character varying(10) NOT NULL,
    size integer DEFAULT 0
);


ALTER TABLE public.samba_disk_usage_report OWNER TO postgres;

--
-- Name: samba_quarantine; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE samba_quarantine (
    filename character varying(120),
    qfilename character varying(120),
    event character varying(16),
    "timestamp" timestamp without time zone
);


ALTER TABLE public.samba_quarantine OWNER TO postgres;

--
-- Name: samba_virus; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE samba_virus (
    client inet,
    virus character varying(120),
    filename character varying(120),
    event character varying(16),
    "timestamp" timestamp without time zone
);


ALTER TABLE public.samba_virus OWNER TO postgres;

--
-- Name: samba_virus_report; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE samba_virus_report (
    date date,
    client inet,
    virus bigint
);


ALTER TABLE public.samba_virus_report OWNER TO postgres;

--
-- Name: samba_virus_share_report; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE samba_virus_share_report (
    date date,
    share character varying(24) NOT NULL,
    virus bigint
);


ALTER TABLE public.samba_virus_share_report OWNER TO postgres;

--
-- Name: sysinfo_disk_usage; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE sysinfo_disk_usage (
    "timestamp" timestamp without time zone,
    mountpoint character varying(80),
    used bigint,
    free bigint
);


ALTER TABLE public.sysinfo_disk_usage OWNER TO postgres;

--
-- Name: sysinfo_disk_usage_report; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE sysinfo_disk_usage_report (
    date date,
    mountpoint character varying(80),
    used bigint,
    free bigint
);


ALTER TABLE public.sysinfo_disk_usage_report OWNER TO postgres;

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

ALTER TABLE events ALTER COLUMN id SET DEFAULT nextval('events_id_seq'::regclass);


--
-- Name: backup_slices_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE UNIQUE INDEX backup_slices_i ON backup_slices USING btree (id, tablename, timeline);


--
-- Name: ebackup_stats_timestamp_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX ebackup_stats_timestamp_i ON ebackup_stats USING btree ("timestamp");


--
-- Name: ebackup_storage_usage_timestamp_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX ebackup_storage_usage_timestamp_i ON ebackup_storage_usage USING btree ("timestamp");


--
-- Name: firewall_packet_traffic_daily_date_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX firewall_packet_traffic_daily_date_i ON firewall_packet_traffic_daily USING btree (date);


--
-- Name: firewall_packet_traffic_hourly_date_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX firewall_packet_traffic_hourly_date_i ON firewall_packet_traffic_hourly USING btree (date);


--
-- Name: firewall_packet_traffic_monthly_date_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX firewall_packet_traffic_monthly_date_i ON firewall_packet_traffic_monthly USING btree (date);


--
-- Name: firewall_packet_traffic_weekly_date_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX firewall_packet_traffic_weekly_date_i ON firewall_packet_traffic_weekly USING btree (date);


--
-- Name: firewall_timestamp_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX firewall_timestamp_i ON firewall USING btree ("timestamp");


--
-- Name: ids_alert_daily_date_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX ids_alert_daily_date_i ON ids_alert_daily USING btree (date);


--
-- Name: ids_alert_hourly_date_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX ids_alert_hourly_date_i ON ids_alert_hourly USING btree (date);


--
-- Name: ids_alert_monthly_date_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX ids_alert_monthly_date_i ON ids_alert_monthly USING btree (date);


--
-- Name: ids_alert_weekly_date_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX ids_alert_weekly_date_i ON ids_alert_weekly USING btree (date);


--
-- Name: ids_timestamp_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX ids_timestamp_i ON ids_event USING btree ("timestamp");


--
-- Name: leases_timestamp_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX leases_timestamp_i ON leases USING btree ("timestamp");


--
-- Name: mail_message_timestamp_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX mail_message_timestamp_i ON mail_message USING btree ("timestamp");


--
-- Name: mailfilter_pop_timestamp_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX mailfilter_pop_timestamp_i ON mailfilter_pop USING btree ("timestamp");


--
-- Name: mailfilter_pop_traffic_daily_date_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX mailfilter_pop_traffic_daily_date_i ON mailfilter_pop_traffic_daily USING btree (date);


--
-- Name: mailfilter_pop_traffic_hourly_date_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX mailfilter_pop_traffic_hourly_date_i ON mailfilter_pop_traffic_hourly USING btree (date);


--
-- Name: mailfilter_pop_traffic_monthly_date_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX mailfilter_pop_traffic_monthly_date_i ON mailfilter_pop_traffic_monthly USING btree (date);


--
-- Name: mailfilter_pop_traffic_weekly_date_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX mailfilter_pop_traffic_weekly_date_i ON mailfilter_pop_traffic_weekly USING btree (date);


--
-- Name: mailfilter_smtp_timestamp_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX mailfilter_smtp_timestamp_i ON mailfilter_smtp USING btree ("timestamp");


--
-- Name: mailfilter_smtp_traffic_daily_date_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX mailfilter_smtp_traffic_daily_date_i ON mailfilter_smtp_traffic_daily USING btree (date);


--
-- Name: mailfilter_smtp_traffic_hourly_date_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX mailfilter_smtp_traffic_hourly_date_i ON mailfilter_smtp_traffic_hourly USING btree (date);


--
-- Name: mailfilter_smtp_traffic_monthly_date_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX mailfilter_smtp_traffic_monthly_date_i ON mailfilter_smtp_traffic_monthly USING btree (date);


--
-- Name: mailfilter_smtp_traffic_weekly_date_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX mailfilter_smtp_traffic_weekly_date_i ON mailfilter_smtp_traffic_weekly USING btree (date);


--
-- Name: openvpn_timestamp_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX openvpn_timestamp_i ON openvpn USING btree ("timestamp");


--
-- Name: printers_jobs_report_date_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX printers_jobs_report_date_i ON printers_jobs_report USING btree (date);


--
-- Name: printers_jobs_timestamp_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX printers_jobs_timestamp_i ON printers_jobs USING btree ("timestamp");


--
-- Name: printers_pages_job_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX printers_pages_job_i ON printers_pages USING btree ("timestamp");


--
-- Name: printers_usage_report_job_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX printers_usage_report_job_i ON printers_usage_report USING btree (date);


--
-- Name: samba_access_timestamp_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX samba_access_timestamp_i ON samba_access USING btree ("timestamp");


--
-- Name: samba_quarantine_timestamp_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX samba_quarantine_timestamp_i ON samba_quarantine USING btree ("timestamp");


--
-- Name: samba_virus_timestamp_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX samba_virus_timestamp_i ON samba_virus USING btree ("timestamp");


--
-- Name: sysinfo_disk_usage_timestamp_i; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX sysinfo_disk_usage_timestamp_i ON sysinfo_disk_usage USING btree ("timestamp");


--
-- 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;


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

REVOKE ALL ON TABLE admin FROM PUBLIC;
REVOKE ALL ON TABLE admin FROM postgres;
GRANT ALL ON TABLE admin TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE admin TO ebox;


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

REVOKE ALL ON TABLE backup_slices FROM PUBLIC;
REVOKE ALL ON TABLE backup_slices FROM postgres;
GRANT ALL ON TABLE backup_slices TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE backup_slices TO ebox;


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

REVOKE ALL ON TABLE consolidation FROM PUBLIC;
REVOKE ALL ON TABLE consolidation FROM postgres;
GRANT ALL ON TABLE consolidation TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE consolidation TO ebox;


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

REVOKE ALL ON TABLE ebackup_stats FROM PUBLIC;
REVOKE ALL ON TABLE ebackup_stats FROM postgres;
GRANT ALL ON TABLE ebackup_stats TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE ebackup_stats TO ebox;


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

REVOKE ALL ON TABLE ebackup_storage_usage FROM PUBLIC;
REVOKE ALL ON TABLE ebackup_storage_usage FROM postgres;
GRANT ALL ON TABLE ebackup_storage_usage TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE ebackup_storage_usage TO ebox;


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

REVOKE ALL ON TABLE ebackup_storage_usage_report FROM PUBLIC;
REVOKE ALL ON TABLE ebackup_storage_usage_report FROM postgres;
GRANT ALL ON TABLE ebackup_storage_usage_report TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE ebackup_storage_usage_report TO ebox;


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

REVOKE ALL ON TABLE events FROM PUBLIC;
REVOKE ALL ON TABLE events FROM postgres;
GRANT ALL ON TABLE events TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE events TO ebox;


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

REVOKE ALL ON TABLE events_accummulated_daily FROM PUBLIC;
REVOKE ALL ON TABLE events_accummulated_daily FROM postgres;
GRANT ALL ON TABLE events_accummulated_daily TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE events_accummulated_daily TO ebox;


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

REVOKE ALL ON TABLE events_accummulated_hourly FROM PUBLIC;
REVOKE ALL ON TABLE events_accummulated_hourly FROM postgres;
GRANT ALL ON TABLE events_accummulated_hourly TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE events_accummulated_hourly TO ebox;


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

REVOKE ALL ON TABLE events_accummulated_monthly FROM PUBLIC;
REVOKE ALL ON TABLE events_accummulated_monthly FROM postgres;
GRANT ALL ON TABLE events_accummulated_monthly TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE events_accummulated_monthly TO ebox;


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

REVOKE ALL ON TABLE events_accummulated_weekly FROM PUBLIC;
REVOKE ALL ON TABLE events_accummulated_weekly FROM postgres;
GRANT ALL ON TABLE events_accummulated_weekly TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE events_accummulated_weekly TO ebox;


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

REVOKE ALL ON SEQUENCE events_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE events_id_seq FROM postgres;
GRANT ALL ON SEQUENCE events_id_seq TO postgres;
GRANT ALL ON SEQUENCE events_id_seq TO ebox;


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

REVOKE ALL ON TABLE events_report FROM PUBLIC;
REVOKE ALL ON TABLE events_report FROM postgres;
GRANT ALL ON TABLE events_report TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE events_report TO ebox;


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

REVOKE ALL ON TABLE firewall FROM PUBLIC;
REVOKE ALL ON TABLE firewall FROM postgres;
GRANT ALL ON TABLE firewall TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE firewall TO ebox;


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

REVOKE ALL ON TABLE firewall_packet_traffic_daily FROM PUBLIC;
REVOKE ALL ON TABLE firewall_packet_traffic_daily FROM postgres;
GRANT ALL ON TABLE firewall_packet_traffic_daily TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE firewall_packet_traffic_daily TO ebox;


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

REVOKE ALL ON TABLE firewall_packet_traffic_hourly FROM PUBLIC;
REVOKE ALL ON TABLE firewall_packet_traffic_hourly FROM postgres;
GRANT ALL ON TABLE firewall_packet_traffic_hourly TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE firewall_packet_traffic_hourly TO ebox;


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

REVOKE ALL ON TABLE firewall_packet_traffic_monthly FROM PUBLIC;
REVOKE ALL ON TABLE firewall_packet_traffic_monthly FROM postgres;
GRANT ALL ON TABLE firewall_packet_traffic_monthly TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE firewall_packet_traffic_monthly TO ebox;


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

REVOKE ALL ON TABLE firewall_packet_traffic_weekly FROM PUBLIC;
REVOKE ALL ON TABLE firewall_packet_traffic_weekly FROM postgres;
GRANT ALL ON TABLE firewall_packet_traffic_weekly TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE firewall_packet_traffic_weekly TO ebox;


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

REVOKE ALL ON TABLE firewall_report FROM PUBLIC;
REVOKE ALL ON TABLE firewall_report FROM postgres;
GRANT ALL ON TABLE firewall_report TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE firewall_report TO ebox;


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

REVOKE ALL ON TABLE ids_alert_daily FROM PUBLIC;
REVOKE ALL ON TABLE ids_alert_daily FROM postgres;
GRANT ALL ON TABLE ids_alert_daily TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE ids_alert_daily TO ebox;


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

REVOKE ALL ON TABLE ids_alert_hourly FROM PUBLIC;
REVOKE ALL ON TABLE ids_alert_hourly FROM postgres;
GRANT ALL ON TABLE ids_alert_hourly TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE ids_alert_hourly TO ebox;


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

REVOKE ALL ON TABLE ids_alert_monthly FROM PUBLIC;
REVOKE ALL ON TABLE ids_alert_monthly FROM postgres;
GRANT ALL ON TABLE ids_alert_monthly TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE ids_alert_monthly TO ebox;


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

REVOKE ALL ON TABLE ids_alert_weekly FROM PUBLIC;
REVOKE ALL ON TABLE ids_alert_weekly FROM postgres;
GRANT ALL ON TABLE ids_alert_weekly TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE ids_alert_weekly TO ebox;


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

REVOKE ALL ON TABLE ids_event FROM PUBLIC;
REVOKE ALL ON TABLE ids_event FROM postgres;
GRANT ALL ON TABLE ids_event TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE ids_event TO ebox;


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

REVOKE ALL ON TABLE ids_report FROM PUBLIC;
REVOKE ALL ON TABLE ids_report FROM postgres;
GRANT ALL ON TABLE ids_report TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE ids_report TO ebox;


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

REVOKE ALL ON TABLE leases FROM PUBLIC;
REVOKE ALL ON TABLE leases FROM postgres;
GRANT ALL ON TABLE leases TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE leases TO ebox;


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

REVOKE ALL ON TABLE mail_message FROM PUBLIC;
REVOKE ALL ON TABLE mail_message FROM postgres;
GRANT ALL ON TABLE mail_message TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mail_message TO ebox;


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

REVOKE ALL ON TABLE mail_message_report FROM PUBLIC;
REVOKE ALL ON TABLE mail_message_report FROM postgres;
GRANT ALL ON TABLE mail_message_report TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mail_message_report TO ebox;


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

REVOKE ALL ON TABLE mail_message_traffic_daily FROM PUBLIC;
REVOKE ALL ON TABLE mail_message_traffic_daily FROM postgres;
GRANT ALL ON TABLE mail_message_traffic_daily TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mail_message_traffic_daily TO ebox;


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

REVOKE ALL ON TABLE mail_message_traffic_hourly FROM PUBLIC;
REVOKE ALL ON TABLE mail_message_traffic_hourly FROM postgres;
GRANT ALL ON TABLE mail_message_traffic_hourly TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mail_message_traffic_hourly TO ebox;


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

REVOKE ALL ON TABLE mail_message_traffic_monthly FROM PUBLIC;
REVOKE ALL ON TABLE mail_message_traffic_monthly FROM postgres;
GRANT ALL ON TABLE mail_message_traffic_monthly TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mail_message_traffic_monthly TO ebox;


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

REVOKE ALL ON TABLE mail_message_traffic_weekly FROM PUBLIC;
REVOKE ALL ON TABLE mail_message_traffic_weekly FROM postgres;
GRANT ALL ON TABLE mail_message_traffic_weekly TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mail_message_traffic_weekly TO ebox;


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

REVOKE ALL ON TABLE mail_traffic_daily FROM PUBLIC;
REVOKE ALL ON TABLE mail_traffic_daily FROM postgres;
GRANT ALL ON TABLE mail_traffic_daily TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mail_traffic_daily TO ebox;


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

REVOKE ALL ON TABLE mail_traffic_hourly FROM PUBLIC;
REVOKE ALL ON TABLE mail_traffic_hourly FROM postgres;
GRANT ALL ON TABLE mail_traffic_hourly TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mail_traffic_hourly TO ebox;


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

REVOKE ALL ON TABLE mail_traffic_monthly FROM PUBLIC;
REVOKE ALL ON TABLE mail_traffic_monthly FROM postgres;
GRANT ALL ON TABLE mail_traffic_monthly TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mail_traffic_monthly TO ebox;


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

REVOKE ALL ON TABLE mail_traffic_weekly FROM PUBLIC;
REVOKE ALL ON TABLE mail_traffic_weekly FROM postgres;
GRANT ALL ON TABLE mail_traffic_weekly TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mail_traffic_weekly TO ebox;


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

REVOKE ALL ON TABLE mailfilter_pop FROM PUBLIC;
REVOKE ALL ON TABLE mailfilter_pop FROM postgres;
GRANT ALL ON TABLE mailfilter_pop TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mailfilter_pop TO ebox;


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

REVOKE ALL ON TABLE mailfilter_pop_report FROM PUBLIC;
REVOKE ALL ON TABLE mailfilter_pop_report FROM postgres;
GRANT ALL ON TABLE mailfilter_pop_report TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mailfilter_pop_report TO ebox;


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

REVOKE ALL ON TABLE mailfilter_pop_traffic_daily FROM PUBLIC;
REVOKE ALL ON TABLE mailfilter_pop_traffic_daily FROM postgres;
GRANT ALL ON TABLE mailfilter_pop_traffic_daily TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mailfilter_pop_traffic_daily TO ebox;


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

REVOKE ALL ON TABLE mailfilter_pop_traffic_hourly FROM PUBLIC;
REVOKE ALL ON TABLE mailfilter_pop_traffic_hourly FROM postgres;
GRANT ALL ON TABLE mailfilter_pop_traffic_hourly TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mailfilter_pop_traffic_hourly TO ebox;


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

REVOKE ALL ON TABLE mailfilter_pop_traffic_monthly FROM PUBLIC;
REVOKE ALL ON TABLE mailfilter_pop_traffic_monthly FROM postgres;
GRANT ALL ON TABLE mailfilter_pop_traffic_monthly TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mailfilter_pop_traffic_monthly TO ebox;


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

REVOKE ALL ON TABLE mailfilter_pop_traffic_weekly FROM PUBLIC;
REVOKE ALL ON TABLE mailfilter_pop_traffic_weekly FROM postgres;
GRANT ALL ON TABLE mailfilter_pop_traffic_weekly TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mailfilter_pop_traffic_weekly TO ebox;


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

REVOKE ALL ON TABLE mailfilter_smtp FROM PUBLIC;
REVOKE ALL ON TABLE mailfilter_smtp FROM postgres;
GRANT ALL ON TABLE mailfilter_smtp TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mailfilter_smtp TO ebox;


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

REVOKE ALL ON TABLE mailfilter_smtp_report FROM PUBLIC;
REVOKE ALL ON TABLE mailfilter_smtp_report FROM postgres;
GRANT ALL ON TABLE mailfilter_smtp_report TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mailfilter_smtp_report TO ebox;


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

REVOKE ALL ON TABLE mailfilter_smtp_traffic_daily FROM PUBLIC;
REVOKE ALL ON TABLE mailfilter_smtp_traffic_daily FROM postgres;
GRANT ALL ON TABLE mailfilter_smtp_traffic_daily TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mailfilter_smtp_traffic_daily TO ebox;


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

REVOKE ALL ON TABLE mailfilter_smtp_traffic_hourly FROM PUBLIC;
REVOKE ALL ON TABLE mailfilter_smtp_traffic_hourly FROM postgres;
GRANT ALL ON TABLE mailfilter_smtp_traffic_hourly TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mailfilter_smtp_traffic_hourly TO ebox;


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

REVOKE ALL ON TABLE mailfilter_smtp_traffic_monthly FROM PUBLIC;
REVOKE ALL ON TABLE mailfilter_smtp_traffic_monthly FROM postgres;
GRANT ALL ON TABLE mailfilter_smtp_traffic_monthly TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mailfilter_smtp_traffic_monthly TO ebox;


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

REVOKE ALL ON TABLE mailfilter_smtp_traffic_weekly FROM PUBLIC;
REVOKE ALL ON TABLE mailfilter_smtp_traffic_weekly FROM postgres;
GRANT ALL ON TABLE mailfilter_smtp_traffic_weekly TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mailfilter_smtp_traffic_weekly TO ebox;


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

REVOKE ALL ON TABLE openvpn FROM PUBLIC;
REVOKE ALL ON TABLE openvpn FROM postgres;
GRANT ALL ON TABLE openvpn TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE openvpn TO ebox;


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

REVOKE ALL ON TABLE openvpn_report FROM PUBLIC;
REVOKE ALL ON TABLE openvpn_report FROM postgres;
GRANT ALL ON TABLE openvpn_report TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE openvpn_report TO ebox;


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

REVOKE ALL ON TABLE printers_jobs FROM PUBLIC;
REVOKE ALL ON TABLE printers_jobs FROM postgres;
GRANT ALL ON TABLE printers_jobs TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE printers_jobs TO ebox;


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

REVOKE ALL ON TABLE printers_jobs_by_user_report FROM PUBLIC;
REVOKE ALL ON TABLE printers_jobs_by_user_report FROM postgres;
GRANT ALL ON TABLE printers_jobs_by_user_report TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE printers_jobs_by_user_report TO ebox;


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

REVOKE ALL ON TABLE printers_jobs_report FROM PUBLIC;
REVOKE ALL ON TABLE printers_jobs_report FROM postgres;
GRANT ALL ON TABLE printers_jobs_report TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE printers_jobs_report TO ebox;


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

REVOKE ALL ON TABLE printers_pages FROM PUBLIC;
REVOKE ALL ON TABLE printers_pages FROM postgres;
GRANT ALL ON TABLE printers_pages TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE printers_pages TO ebox;


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

REVOKE ALL ON TABLE printers_usage_report FROM PUBLIC;
REVOKE ALL ON TABLE printers_usage_report FROM postgres;
GRANT ALL ON TABLE printers_usage_report TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE printers_usage_report TO ebox;


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

REVOKE ALL ON TABLE report_consolidation FROM PUBLIC;
REVOKE ALL ON TABLE report_consolidation FROM postgres;
GRANT ALL ON TABLE report_consolidation TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE report_consolidation TO ebox;


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

REVOKE ALL ON TABLE samba_access FROM PUBLIC;
REVOKE ALL ON TABLE samba_access FROM postgres;
GRANT ALL ON TABLE samba_access TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE samba_access TO ebox;


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

REVOKE ALL ON TABLE samba_access_report FROM PUBLIC;
REVOKE ALL ON TABLE samba_access_report FROM postgres;
GRANT ALL ON TABLE samba_access_report TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE samba_access_report TO ebox;


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

REVOKE ALL ON TABLE samba_disk_usage FROM PUBLIC;
REVOKE ALL ON TABLE samba_disk_usage FROM postgres;
GRANT ALL ON TABLE samba_disk_usage TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE samba_disk_usage TO ebox;


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

REVOKE ALL ON TABLE samba_disk_usage_report FROM PUBLIC;
REVOKE ALL ON TABLE samba_disk_usage_report FROM postgres;
GRANT ALL ON TABLE samba_disk_usage_report TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE samba_disk_usage_report TO ebox;


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

REVOKE ALL ON TABLE samba_quarantine FROM PUBLIC;
REVOKE ALL ON TABLE samba_quarantine FROM postgres;
GRANT ALL ON TABLE samba_quarantine TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE samba_quarantine TO ebox;


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

REVOKE ALL ON TABLE samba_virus FROM PUBLIC;
REVOKE ALL ON TABLE samba_virus FROM postgres;
GRANT ALL ON TABLE samba_virus TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE samba_virus TO ebox;


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

REVOKE ALL ON TABLE samba_virus_report FROM PUBLIC;
REVOKE ALL ON TABLE samba_virus_report FROM postgres;
GRANT ALL ON TABLE samba_virus_report TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE samba_virus_report TO ebox;


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

REVOKE ALL ON TABLE samba_virus_share_report FROM PUBLIC;
REVOKE ALL ON TABLE samba_virus_share_report FROM postgres;
GRANT ALL ON TABLE samba_virus_share_report TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE samba_virus_share_report TO ebox;


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

REVOKE ALL ON TABLE sysinfo_disk_usage FROM PUBLIC;
REVOKE ALL ON TABLE sysinfo_disk_usage FROM postgres;
GRANT ALL ON TABLE sysinfo_disk_usage TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sysinfo_disk_usage TO ebox;


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

REVOKE ALL ON TABLE sysinfo_disk_usage_report FROM PUBLIC;
REVOKE ALL ON TABLE sysinfo_disk_usage_report FROM postgres;
GRANT ALL ON TABLE sysinfo_disk_usage_report TO postgres;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sysinfo_disk_usage_report TO ebox;


--
-- PostgreSQL database dump complete
--

Regards,

comment:4 Changed 2 years ago by jacalvo@…

Milestone set to 2.0.X

comment:5 Changed 2 years ago by jamor@…

Status changed from reopened to closed
Resolution set to fixed

(In [21332]) BP: Manage MTA-BLOCKED event in the logs closes #2870

comment:6 Changed 2 years ago by jamor@…

(In [21333]) code typo fix refs #2870

comment:7 Changed 2 years ago by jamor@…

(In [21334]) Backport from 2.1 . Manage MTA-BLOCKED event in the logs refs #2870

comment:8 Changed 2 years ago by jamor@…

Didier,

thanks a lot for the dump. It was very useful.

The fix is committed to the repository and it will be released in the next release. However if you want to hotfix your server:

1) Download the file http://trac.zentyal.org/export/21334/branches/jag/2.0-misc/client/mailfilter/src/EBox/MailFilter.pm 2) Use it to replace the old version at /usr/share/perl5/EBox/MailFilter.pm

The code that raised the error is run each hour. If you want you can force its execution running manually /etc/cron.hourly/90ebox-manage-logs

Cheers,

Javier

comment:9 Changed 2 years ago by didier@…

Tested and found OK ;-) Many thanks.

View ↑

Add a comment

You may use WikiFormatting here.

Modify Ticket

Change Properties

Summary:
Type:	Milestone:
Component:	Severity:
Keywords:	Add/Remove from Cc:	<Author field>

Action

leave as closed

reopen The resolution will be deleted. Next status will be 'reopened'

Author

Your email or username:

E-mail address and user name can be saved in the Preferences.

Attachments ↑

Note: See TracTickets for help on using tickets.

Download in other formats: