Zhang Huangbin avatar Zhang Huangbin committed e8716e0

New SQL table: deleted_mailboxes. Used to store maildir path of deleted mail user, used in iRedAdmin-Pro.
Package updates:
+ Roundcube webmail -> 0.9.2
+ phpMyAdmin -> 4.0.4
+ iRedAPD -> 1.4.1
+ iRedAdmin -> 0.2.2

Comments (0)

Files changed (12)

iRedMail/ChangeLog

           Thanks Hoang Tuan Viet <vietht _at_ vccloud.vn> for the report.
 
     * Package update:
+        + Roundcube webmail -> 0.9.2
+        + phpMyAdmin -> 4.0.4
+        + iRedAdmin -> 0.2.2
+        + iRedAPD -> 1.4.1
         + phpPgAdmin -> 5.1
-        + phpMyAdmin -> 4.0.2
-        + Roundcube webmail -> 0.9.1
 
 iRedMail-0.8.4:
     * Enable Dovecot Master User by default, but no pre-defined account.

iRedMail/conf/iredadmin

 # along with iRedMail.  If not, see <http://www.gnu.org/licenses/>.
 #---------------------------------------------------------------------
 
-export IREDADMIN_VERSION='0.2.1'
+export IREDADMIN_VERSION='0.2.2'
 export IREDADMIN_TARBALL="iRedAdmin-${IREDADMIN_VERSION}.tar.bz2"
 export IREDADMIN_HTTPD_ROOT="${HTTPD_SERVERROOT}/iRedAdmin-${IREDADMIN_VERSION}"
 export IREDADMIN_HTTPD_ROOT_SYMBOL_LINK="${HTTPD_SERVERROOT}/iredadmin"

iRedMail/conf/iredapd

 
 export USE_IREDAPD='YES'
 
-export IREDAPD_VERSION='1.4.0'
+export IREDAPD_VERSION='1.4.1'
 export IREDAPD_DAEMON_USER='iredapd'
 export IREDAPD_DAEMON_GROUP='iredapd'
 export IREDAPD_HOME_DIR='/home/iredapd'

iRedMail/conf/phpmyadmin

 # along with iRedMail.  If not, see <http://www.gnu.org/licenses/>.
 #---------------------------------------------------------------------
 
-export PHPMYADMIN_VERSION='4.0.2-all-languages'
+export PHPMYADMIN_VERSION='4.0.4-all-languages'
 export PHPMYADMIN_TARBALL="phpMyAdmin-${PHPMYADMIN_VERSION}.tar.bz2"
 
 # Install phpMyAdmin with source tarball.

iRedMail/conf/roundcube

 # ---------------------------------------
 # RoundcubeMail. http://roundcube.net
 # ---------------------------------------
-export RCM_VERSION='0.9.1'
+export RCM_VERSION='0.9.2'
 export RCM_TARBALL="roundcubemail-${RCM_VERSION}.tar.gz"
 export RCM_USE_SOURCE='YES'
 

iRedMail/functions/postgresql.sh

 -- Set correct privilege for ROLE: vmail
 GRANT SELECT ON admin,alias,alias_domain,domain,domain_admins,mailbox,mailbox,recipient_bcc_domain,recipient_bcc_user,sender_bcc_domain,sender_bcc_user TO ${VMAIL_DB_BIND_USER};
 GRANT SELECT,UPDATE,INSERT,DELETE ON used_quota TO ${VMAIL_DB_BIND_USER};
--- GRANT SELECT,UPDATE,INSERT,DELETE ON share_folder TO ${VMAIL_DB_BIND_USER};
 
 -- Set correct privilege for ROLE: vmailadmin
-GRANT SELECT,UPDATE,INSERT,DELETE ON admin,alias,alias_domain,domain,domain_admins,mailbox,mailbox,recipient_bcc_domain,recipient_bcc_user,sender_bcc_domain,sender_bcc_user,share_folder,used_quota TO ${VMAIL_DB_ADMIN_USER};
+GRANT SELECT,UPDATE,INSERT,DELETE ON admin,alias,alias_domain,domain,domain_admins,mailbox,mailbox,recipient_bcc_domain,recipient_bcc_user,sender_bcc_domain,sender_bcc_user,share_folder,anyone_shares,used_quota TO ${VMAIL_DB_ADMIN_USER};
+GRANT SELECT,UPDATE,INSERT,DELETE ON deleted_mailboxes,deleted_mailboxes_id_seq TO ${VMAIL_DB_ADMIN_USER};
 
 -- Add first mail domain
 INSERT INTO domain (domain,transport,created) VALUES ('${FIRST_DOMAIN}', '${TRANSPORT}', NOW());

iRedMail/pkgs/MD5.debian.squeeze

-11d83453204da2a4dec1844a005edd20  misc/iRedAdmin-0.2.1.tar.bz2
-3465596f0b143469833f86dfc790b270  misc/roundcubemail-0.9.1.tar.gz
-db8a2de072da80b972f55fac36270349  misc/iRedAPD-1.4.0.tar.bz2
+2f1d6d4f900af59920378c0d2a5af695  misc/iRedAdmin-0.2.2.tar.bz2
+e60d5fc120517062ea388c47739742b3  misc/roundcubemail-0.9.2.tar.gz
+ad2d5142a46dadf87e9d96d3a8279adc  misc/iRedAPD-1.4.1.tar.bz2
 ad8f05cef0c443d9ce2940bf36319c24  misc/phpPgAdmin-5.1.tar.bz2

iRedMail/pkgs/MD5.misc

-11d83453204da2a4dec1844a005edd20  misc/iRedAdmin-0.2.1.tar.bz2
-3465596f0b143469833f86dfc790b270  misc/roundcubemail-0.9.1.tar.gz
+2f1d6d4f900af59920378c0d2a5af695  misc/iRedAdmin-0.2.2.tar.bz2
+e60d5fc120517062ea388c47739742b3  misc/roundcubemail-0.9.2.tar.gz
 59a49054039ceb852c2da377d8742360  misc/phpldapadmin-1.2.3.tgz
-6d49ed2cdf6a076f273b0c68bc46d6bb  misc/phpMyAdmin-4.0.2-all-languages.tar.bz2
-db8a2de072da80b972f55fac36270349  misc/iRedAPD-1.4.0.tar.bz2
+f5a64a7ffc22d54ae7df657b62662252  misc/phpMyAdmin-4.0.4-all-languages.tar.bz2
+ad2d5142a46dadf87e9d96d3a8279adc  misc/iRedAPD-1.4.1.tar.bz2
 ad8f05cef0c443d9ce2940bf36319c24  misc/phpPgAdmin-5.1.tar.bz2

iRedMail/pkgs/MD5.openbsd

-11d83453204da2a4dec1844a005edd20  misc/iRedAdmin-0.2.1.tar.bz2
-db8a2de072da80b972f55fac36270349  misc/iRedAPD-1.4.0.tar.bz2
+2f1d6d4f900af59920378c0d2a5af695  misc/iRedAdmin-0.2.2.tar.bz2
+ad2d5142a46dadf87e9d96d3a8279adc  misc/iRedAPD-1.4.1.tar.bz2

iRedMail/pkgs/SHASUM.freebsd.misc

-2b03423e45b2c1a88496e8b6d77d8f8d31949be3  misc/iRedAdmin-0.2.1.tar.bz2
-d5d189a12357571e3b1d2bb59e3964872faddefb  misc/iRedAPD-1.4.0.tar.bz2
+f6a810b5683825265517735e69e18d6522dcf4be  misc/iRedAdmin-0.2.2.tar.bz2
+20c84e7810b8eecce57cc33b5352935f3ecb2038  misc/iRedAPD-1.4.1.tar.bz2

iRedMail/samples/iredmail.mysql

     INDEX (active)
 ) ENGINE=MyISAM;
 
+-- Used to store basic info of deleted mailboxes.
+CREATE TABLE IF NOT EXISTS `deleted_mailboxes` (
+    `id` BIGINT(20) UNSIGNED AUTO_INCREMENT,
+    `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    -- Email address of deleted user
+    `username` VARCHAR(255) NOT NULL DEFAULT '',
+    -- Domain part of user email address
+    domain VARCHAR(255) NOT NULL DEFAULT '',
+    -- Absolute path of user's mailbox
+    `maildir` TEXT NOT NULL DEFAULT '',
+    -- Which domain admin deleted this user
+    `admin` VARCHAR(255) NOT NULL DEFAULT '',
+    KEY id (id),
+    INDEX (timestamp),
+    INDEX (username),
+    INDEX (domain),
+    INDEX (admin)
+) ENGINE=MyISAM;
+
 #
 # IMAP shared folders. User 'from_user' shares folders to user 'to_user'.
 # WARNING: Works only with Dovecot 1.2+.

iRedMail/samples/iredmail.pgsql

 CREATE INDEX idx_recipient_bcc_user_expired ON recipient_bcc_user (expired);
 CREATE INDEX idx_recipient_bcc_user_active ON recipient_bcc_user (active);
 
+-- Used to store basic info of deleted mailboxes.
+CREATE TABLE deleted_mailboxes (
+    id SERIAL PRIMARY KEY,
+    timestamp TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    -- Email address of deleted user
+    username VARCHAR(255) NOT NULL DEFAULT '',
+    -- Domain part of user email address
+    domain VARCHAR(255) NOT NULL DEFAULT '',
+    -- Absolute path of user's mailbox
+    maildir TEXT NOT NULL DEFAULT '',
+    -- Which domain admin deleted this user
+    admin VARCHAR(255) NOT NULL DEFAULT ''
+);
+
+CREATE INDEX idx_deleted_mailboxes_timestamp ON deleted_mailboxes (timestamp);
+CREATE INDEX idx_deleted_mailboxes_username ON deleted_mailboxes (username);
+CREATE INDEX idx_deleted_mailboxes_domain ON deleted_mailboxes (domain);
+CREATE INDEX idx_deleted_mailboxes_admin ON deleted_mailboxes (admin);
+
 --
 -- IMAP shared folders. User 'from_user' shares folders to user 'to_user'.
 -- WARNING: Works only with Dovecot 1.2+.
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.