Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

Installation Postifixadmin to Previously Zpanel (Cpanel)

2013-04-28
2013-04-28
  • Harris Marfel
    Harris Marfel
    2013-04-28

    Hello,

    I have a question, is postfixadmin can install with previously zpanel?
    the Zpanel already have virtual mail with integrate database with name zpanel_postfix.

    i have assumption postfixadmin using same database structure with zpanel_postfix, but i still not sure until i got information from here.

    Bellow the structure for zpanel_postfix :
    /
    Navicat MySQL Data Transfer


    Source Server : PWTWILIGHT(PUBLIC)
    Source Server Version : 50167
    Source Host : 172.16.0.1:3306
    Source Database : zpanel_postfix


    Target Server Type : MYSQL
    Target Server Version : 50167
    File Encoding : 65001


    Date: 2013-04-29 00:44:25

    /

    SET FOREIGN_KEY_CHECKS=0;

    -- ----------------------------
    -- Table structure for admin
    -- ----------------------------
    DROP TABLE IF EXISTS admin;
    CREATE TABLE admin (
    username varchar(255) NOT NULL,
    password varchar(255) NOT NULL,
    created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    modified datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    active tinyint(1) NOT NULL DEFAULT '1',
    PRIMARY KEY (username)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Admins';

    -- ----------------------------
    -- Records of admin
    -- ----------------------------

    -- ----------------------------
    -- Table structure for alias
    -- ----------------------------
    DROP TABLE IF EXISTS alias;
    CREATE TABLE alias (
    address varchar(255) NOT NULL,
    goto text NOT NULL,
    domain varchar(255) NOT NULL,
    created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    modified datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    active tinyint(1) NOT NULL DEFAULT '1',
    PRIMARY KEY (address),
    KEY domain (domain)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Aliases';

    -- ----------------------------
    -- Records of alias
    -- ----------------------------

    -- ----------------------------
    -- Table structure for alias_domain
    -- ----------------------------
    DROP TABLE IF EXISTS alias_domain;
    CREATE TABLE alias_domain (
    alias_domain varchar(255) NOT NULL,
    target_domain varchar(255) NOT NULL,
    created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    modified datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    active tinyint(1) NOT NULL DEFAULT '1',
    PRIMARY KEY (alias_domain),
    KEY active (active),
    KEY target_domain (target_domain)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Domain Aliases';

    -- ----------------------------
    -- Records of alias_domain
    -- ----------------------------

    -- ----------------------------
    -- Table structure for config
    -- ----------------------------
    DROP TABLE IF EXISTS config;
    CREATE TABLE config (
    id int(11) NOT NULL AUTO_INCREMENT,
    name varchar(20) NOT NULL DEFAULT '',
    value varchar(20) NOT NULL DEFAULT '',
    PRIMARY KEY (id),
    UNIQUE KEY name (name)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='PostfixAdmin settings';

    -- ----------------------------
    -- Records of config
    -- ----------------------------

    -- ----------------------------
    -- Table structure for domain
    -- ----------------------------
    DROP TABLE IF EXISTS domain;
    CREATE TABLE domain (
    domain varchar(255) NOT NULL,
    description varchar(255) CHARACTER SET utf8 NOT NULL,
    aliases int(10) NOT NULL DEFAULT '0',
    mailboxes int(10) NOT NULL DEFAULT '0',
    maxquota bigint(20) NOT NULL DEFAULT '0',
    quota bigint(20) NOT NULL DEFAULT '0',
    transport varchar(255) NOT NULL,
    backupmx tinyint(1) NOT NULL DEFAULT '0',
    created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    modified datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    active tinyint(1) NOT NULL DEFAULT '1',
    PRIMARY KEY (domain)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Domains';

    -- ----------------------------
    -- Records of domain
    -- ----------------------------

    -- ----------------------------
    -- Table structure for domain_admins
    -- ----------------------------
    DROP TABLE IF EXISTS domain_admins;
    CREATE TABLE domain_admins (
    username varchar(255) NOT NULL,
    domain varchar(255) NOT NULL,
    created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    active tinyint(1) NOT NULL DEFAULT '1',
    KEY username (username)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Domain Admins';

    -- ----------------------------
    -- Records of domain_admins
    -- ----------------------------

    -- ----------------------------
    -- Table structure for fetchmail
    -- ----------------------------
    DROP TABLE IF EXISTS fetchmail;
    CREATE TABLE fetchmail (
    id int(11) unsigned NOT NULL AUTO_INCREMENT,
    mailbox varchar(255) NOT NULL,
    src_server varchar(255) NOT NULL,
    src_auth enum('password','kerberos_v5','kerberos','kerberos_v4','gssapi','cram-md5','otp','ntlm','msn','ssh','any') DEFAULT NULL,
    src_user varchar(255) NOT NULL,
    src_password varchar(255) NOT NULL,
    src_folder varchar(255) NOT NULL,
    poll_time int(11) unsigned NOT NULL DEFAULT '10',
    fetchall tinyint(1) unsigned NOT NULL DEFAULT '0',
    keep tinyint(1) unsigned NOT NULL DEFAULT '0',
    protocol enum('POP3','IMAP','POP2','ETRN','AUTO') DEFAULT NULL,
    usessl tinyint(1) unsigned NOT NULL DEFAULT '0',
    extra_options text,
    returned_text text,
    mda varchar(255) NOT NULL,
    date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (id)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    -- ----------------------------
    -- Records of fetchmail
    -- ----------------------------

    -- ----------------------------
    -- Table structure for log
    -- ----------------------------
    DROP TABLE IF EXISTS log;
    CREATE TABLE log (
    timestamp datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    username varchar(255) NOT NULL,
    domain varchar(255) NOT NULL,
    action varchar(255) NOT NULL,
    data text NOT NULL,
    KEY timestamp (timestamp)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Log';

    -- ----------------------------
    -- Records of log
    -- ----------------------------

    -- ----------------------------
    -- Table structure for mailbox
    -- ----------------------------
    DROP TABLE IF EXISTS mailbox;
    CREATE TABLE mailbox (
    username varchar(255) NOT NULL,
    password varchar(255) NOT NULL,
    name varchar(255) CHARACTER SET utf8 NOT NULL,
    maildir varchar(255) NOT NULL,
    quota bigint(20) NOT NULL DEFAULT '0',
    local_part varchar(255) NOT NULL,
    domain varchar(255) NOT NULL,
    created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    modified datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    active tinyint(1) NOT NULL DEFAULT '1',
    PRIMARY KEY (username),
    KEY domain (domain)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Mailboxes';

    -- ----------------------------
    -- Records of mailbox
    -- ----------------------------

    -- ----------------------------
    -- Table structure for quota
    -- ----------------------------
    DROP TABLE IF EXISTS quota;
    CREATE TABLE quota (
    username varchar(255) NOT NULL,
    path varchar(100) NOT NULL,
    current bigint(20) DEFAULT NULL,
    PRIMARY KEY (username,path)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    -- ----------------------------
    -- Records of quota
    -- ----------------------------

    -- ----------------------------
    -- Table structure for quota2
    -- ----------------------------
    DROP TABLE IF EXISTS quota2;
    CREATE TABLE quota2 (
    username varchar(100) NOT NULL,
    bytes bigint(20) NOT NULL DEFAULT '0',
    messages int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (username)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    -- ----------------------------
    -- Records of quota2
    -- ----------------------------

    -- ----------------------------
    -- Table structure for vacation
    -- ----------------------------
    DROP TABLE IF EXISTS vacation;
    CREATE TABLE vacation (
    email varchar(255) NOT NULL,
    subject varchar(255) CHARACTER SET utf8 NOT NULL,
    body text CHARACTER SET utf8 NOT NULL,
    cache text NOT NULL,
    domain varchar(255) NOT NULL,
    created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    active tinyint(1) NOT NULL DEFAULT '1',
    PRIMARY KEY (email),
    KEY email (email)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Vacation';

    -- ----------------------------
    -- Records of vacation
    -- ----------------------------

    -- ----------------------------
    -- Table structure for vacation_notification
    -- ----------------------------
    DROP TABLE IF EXISTS vacation_notification;
    CREATE TABLE vacation_notification (
    on_vacation varchar(255) CHARACTER SET latin1 NOT NULL,
    notified varchar(255) CHARACTER SET latin1 NOT NULL,
    notified_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (on_vacation,notified),
    CONSTRAINT vacation_notification_pkey FOREIGN KEY (on_vacation) REFERENCES vacation (email) ON DELETE CASCADE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Postfix Admin - Virtual Vacation Notifications';

    -- ----------------------------
    -- Records of vacation_notification
    -- ----------------------------

    Thanks