Roundcube Community Forum

 

MailStation plugin cannot be used in 1.0.1

Started by ekekakos, July 04, 2014, 05:04:41 AM

Previous topic - Next topic

ekekakos

I have a Syno with roundcube 0.95. I managed to upgrade to 1.0.1 but I want to use the mailstation plugin in order to retrieve the emails from other pop3 accounts and I am getting the following error during the save in this plugin AN ERROR OCCURRED WHILE SAVING.
I am using mysql db and in the plugin there is a SQL directory with a file which creates the tables that needed but in postgres sql.


-- MailStation initial database structure

-- Table "popinfo"
-- Name: popinfo; Type: TABLE; Schema: public; Owner: postgres
--
BEGIN;
CREATE TABLE popinfo (
    identity_id integer PRIMARY KEY,
    changed timestamp with time zone DEFAULT now() NOT NULL,
    ext integer DEFAULT 0 NOT NULL,
    extusername varchar(128),
    extpd varchar(128),
    popserver varchar(128),
    popport integer DEFAULT 110 NOT NULL,
    ifssl integer DEFAULT 0 NOT NULL,
    select_folder varchar(128) DEFAULT 'INBOX',
    remove_mail integer DEFAULT 0 NOT NULL,
    select_smtp integer
);

--
-- Sequence "smtp_ids"
-- Name: smtp_ids; Type: SEQUENCE; Schema: public; Owner: postgres
--

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

--
-- Table "smtp"
-- Name: smtp; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE smtp (
    smtp_id integer DEFAULT nextval('smtp_ids'::text) PRIMARY KEY,
    user_id integer NOT NULL
   REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
    changed timestamp with time zone DEFAULT now() NOT NULL,
    del smallint DEFAULT 0 NOT NULL,
    smtpdesc varchar(128) ,
    smtpserver varchar(128) NOT NULL,
    smtpport integer NOT NULL,
    smtpuser varchar(128) NOT NULL,
    smtppass varchar(128) NOT NULL,
    iftls integer DEFAULT 0 NOT NULL,
    ifdefault integer DEFAULT 0 NOT NULL

);

CREATE INDEX smtp_user_id_idx ON smtp (user_id, del);

--
-- Sequence "account_type_ids"
-- Name: account_type_ids; Type: SEQUENCE; Schema: public; Owner: postgres
--

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

--
-- Table "users_type"
-- Name: users_type; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE users_type (
    users_type_id integer DEFAULT nextval('users_type_ids'::text) PRIMARY KEY,
    user_id integer NOT NULL
   REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
    account_type varchar(128) DEFAULT 'local' NOT NULL,
    domain_name varchar(512) DEFAULT '' NOT NULL

);

CREATE INDEX users_type_user_id_idx ON users_type (users_type_id, account_type, domain_name);
END;


Can someone change this to mysql?
Or do you now any other plugin for roundcube which can be used in order to getnmails from other POP3 accounts?

Thanks in advance