1 (edited by labasus 2016-06-01 13:28:27)

Topic: IredAdmin-Pro Mail/Quarantine searching issues?

==== Required information ====
- iRedMail version (check /etc/iredmail-release): Latest
- Linux/BSD distribution name and version: Ubuntu 14
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):  LDAP
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? Yes
====

IredadminPro Mails Sent/Receive aka activities shows with some issues:
1) Default Receive/Sent screen shows no emails with "No outgoing mails" -  it can OK, but below I can seen pages from 1..516
Clicking on pages has no result - always gives No mails

2) Search activities - as I can see (understand) must have easy logic like
Receive - All emails were received
Send - All emails were sent
Quarantine - both of receive/sent can be where.

Example: I have receive email from test@external-domain.tld to mine info@my-domain.tld. So this email mu st be in Receive log?
Search by external-domain.tld result by Receive - shows my empty result. Looks strange?
Search by external-domain.tld result by Send - shows this email in result page. Looks more strange?


3) Search in Quarantine has the same in p.2 described issues

Note: Where is no detail instruction of any IredAdmin-Pro tool, some features and option of them easy to understand, but where are some must be described in details online or even in PDF format for offline learning.

----

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

2

Re: IredAdmin-Pro Mail/Quarantine searching issues?

labasus wrote:

1) Default Receive/Sent screen shows no emails with "No outgoing mails" -  it can OK, but below I can seen pages from 1..516
Clicking on pages has no result - always gives No mails

Which version of iRedMail and iRedAdmin-Pro are you running?

Also, please show us output of command below:

grep -2 '@storage_sql_dsn' /etc/amavis/conf.d/*

Remove the password string in output before pasting here.

3

Re: IredAdmin-Pro Mail/Quarantine searching issues?

iRedMail     v0.9.5-1
iRedAdmin-Pro v2.6.0 (LDAP) 4

/etc/amavis/conf.d/50-user-# Where to store quarantined mail message:
/etc/amavis/conf.d/50-user-#   - 'local:spam-%i-%m', quarantine mail on local file system.
/etc/amavis/conf.d/50-user:#   - 'sql:', quarantine mail in SQL server specified in @storage_sql_dsn.
/etc/amavis/conf.d/50-user-#   - undef, do not quarantine mail.
/etc/amavis/conf.d/50-user-
--
/etc/amavis/conf.d/50-user-# ------------ End Disclaimer Setting ---------------
/etc/amavis/conf.d/50-user-# Reporting and quarantining.
/etc/amavis/conf.d/50-user:@storage_sql_dsn = (
/etc/amavis/conf.d/50-user-    ['DBI:mysql:database=amavisd;host=127.0.0.1;port=3306', 'amavisd', 'pass'],
/etc/amavis/conf.d/50-user-);
/etc/amavis/conf.d/50-user-
/etc/amavis/conf.d/50-user-# Lookup for per-recipient, per-domain and global policy.
/etc/amavis/conf.d/50-user:@lookup_sql_dsn = @storage_sql_dsn;
/etc/amavis/conf.d/50-user-# Don't send email with subject "UNCHECKED contents in mail FROM xxx".
/etc/amavis/conf.d/50-user-delete $admin_maps_by_ccat{&CC_UNCHECKED};

4

Re: IredAdmin-Pro Mail/Quarantine searching issues?

I cannot reproduce this issue on my server.

*) Please verify the SQL username and password used in @storage_sql_dsn setting.
*) Is this a fresh iRedMail installation, or upgraded from an old iRedMail release?
*) If it's upgraded from an old iRedMail release, did old iRedAdmin-Pro work?
*) Did you see any error in Apache (ssl) error log file?

5 (edited by labasus 2016-06-02 11:32:00)

Re: IredAdmin-Pro Mail/Quarantine searching issues?

*) @storage_sql_dsn is OK
*) iRedMail was upgraded from 0.9.4
   iRedAdmin-Pro was upgraded from 2.5.0
*) Ok works fine except searching
*) Apache has no errors.

I can't say what searching by Receive/Sent domains or emails does not work at all, it works some how ... but I think it goes in wrong direction hmm

6

Re: IredAdmin-Pro Mail/Quarantine searching issues?

Anything else I can do for troubleshooting?

7

Re: IredAdmin-Pro Mail/Quarantine searching issues?

i cannot reproduce the issue, is it possible to let me login to your server for further debug? Please contact me: zhb _at_ iredmail.org.