1 (edited by mr.cocco 2017-09-19 21:22:43)

Topic: Missing iredadmin.share_folder

==== Required information ====
- iRedMail version: 0.9.7 OPENLDAP edition
- Linux/BSD distribution name and version: CentOS Linux release 7.3.1611 (Core)
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): LDAP
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro?: Yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Dear all,
I have installed iredmail some months ago and all is working fine without using SOGo.
Today I'm going to use SOGo but sharing folder feature is not working. User B cannot see user A shared folder's.
This is a probably related error in dovecot.log:
Sep 19 15:08:55 hostname dovecot: dict(21483): Warning: mysql: Query failed, retrying: Table 'iredadmin.share_folder' doesn't exist
Sep 19 15:08:55 hostname dovecot: dict(21483): Error: dict sql iterate failed: Table 'iredadmin.share_folder' doesn't exist

Could someone please tell me how to create this table?

Thanks for your cooperation,
Cocco

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 (edited by mr.cocco 2017-09-19 22:58:22)

Re: Missing iredadmin.share_folder

Solved using the following sql statement on iredadmin DB:

CREATE TABLE IF NOT EXISTS share_folder (
    from_user VARCHAR(255) CHARACTER SET ascii NOT NULL,
    to_user VARCHAR(255) CHARACTER SET ascii NOT NULL,
    dummy CHAR(1),
    PRIMARY KEY (from_user, to_user),
    INDEX (from_user),
    INDEX (to_user)
);

Now it works.

mr.cocco wrote:

==== Required information ====
- iRedMail version: 0.9.7 OPENLDAP edition
- Linux/BSD distribution name and version: CentOS Linux release 7.3.1611 (Core)
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): LDAP
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro?: Yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Dear all,
I have installed iredmail some months ago and all is working fine without using SOGo.
Today I'm going to use SOGo but sharing folder feature is not working. User B cannot see user A shared folder's.
This is a probably related error in dovecot.log:
Sep 19 15:08:55 hostname dovecot: dict(21483): Warning: mysql: Query failed, retrying: Table 'iredadmin.share_folder' doesn't exist
Sep 19 15:08:55 hostname dovecot: dict(21483): Error: dict sql iterate failed: Table 'iredadmin.share_folder' doesn't exist

Could someone please tell me how to create this table?

Thanks for your cooperation,
Cocco

3

Re: Missing iredadmin.share_folder

Import SQL file here:
https://bitbucket.org/zhb/iredmail/src/ … folder.sql