1

Topic: Dashboard Stats Blank

==== Required information ====
- iRedMail version:  v1.9.2 (MySQL)
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):  MySQL
- Linux/BSD distribution name and version:   FreeBSD 10.1-RELEASE #0 r274401
- Related log if you're reporting an issue:
====

Dashboard stats all 0

Top 10 Senders & Recipients Blank

----

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

2

Re: Dashboard Stats Blank

*) Do you have '@storage_sql_dsn =' setting in Amavisd config file (/usr/local/etc/amavisd.conf)?
*) Do you have correct SQL username/password in iRedAdmin-Pro config file (/usr/local/www/iredadmin/settings.py)? Please be careful, do not add space in SQL username/password.

3

Re: Dashboard Stats Blank

@storage_sql_dsn = (
    ['DBI:mysql:database=amavisd;host=127.0.0.1;port=3306', 'amavisd', '###hashed pw###'],
);

password should be ok. Hasn't been changed since install and was working.

4

Re: Dashboard Stats Blank

Do you have correct SQL username/password in iRedAdmin-Pro config file (/usr/local/www/iredadmin/settings.py)? Please be careful, do not add space in SQL username/password.

Also, please verify the SQL username/password with MySQL command line tool to make sure it's correct.

5

Re: Dashboard Stats Blank

I've had to disable amavisd temporarily.

Having trouble with service restarting. Could be the cause of the whole problem.

fetch_modules: error loading required module MIME/Head.pm:
  Insecure dependency in eval while running with -T switch at /usr/local/lib/perl5/site_perl/Mail/Field.pm line 49.
  BEGIN failed--compilation aborted at /usr/local/lib/perl5/site_perl/MIME/Field/ContType.pm line 60.
  Compilation failed in require at /usr/local/lib/perl5/site_perl/MIME/Head.pm line 129.
  BEGIN failed--compilation aborted at /usr/local/lib/perl5/site_perl/MIME/Head.pm line 129.
  Compilation failed in require at /usr/local/sbin/amavisd line 209.
fetch_modules: error loading required module MIME/Entity.pm:
  Attempt to reload MIME/Head.pm aborted.
  Compilation failed in require at /usr/local/lib/perl5/site_perl/MIME/Entity.pm line 234.
  BEGIN failed--compilation aborted at /usr/local/lib/perl5/site_perl/MIME/Entity.pm line 234.
  Compilation failed in require at /usr/local/sbin/amavisd line 209.
fetch_modules: error loading required module MIME/Parser.pm:
  Attempt to reload MIME/Head.pm aborted.
  Compilation failed in require at /usr/local/lib/perl5/site_perl/MIME/Parser.pm line 141.
  BEGIN failed--compilation aborted at /usr/local/lib/perl5/site_perl/MIME/Parser.pm line 141.
  Compilation failed in require at /usr/local/sbin/amavisd line 209.
ERROR: MISSING REQUIRED BASIC MODULES:
  MIME::Head
  MIME::Entity
  MIME::Parser
BEGIN failed--compilation aborted at /usr/local/sbin/amavisd line 249.

6

Re: Dashboard Stats Blank

perl pkgs installed:

p5-Archive-Zip-1.38            Perl module to create, manipulate, read, and write Zip archive files
p5-Authen-SASL-2.16            Perl5 module for SASL authentication
p5-BerkeleyDB-0.54_1           Perl5 interface to the Berkeley DB package
p5-Cache-FastMmap-1.40         Uses an mmap'ed file to act as a shared memory interprocess cache
p5-Config-IniFiles-2.83        Perl5 module for reading .ini-style configuration files
p5-Convert-BinHex-1.123        Perl module to extract data from Macintosh BinHex files
p5-Convert-TNEF-0.18           Perl module to read TNEF files
p5-Convert-UUlib-1.40,1        Perl5 interface to the uulib library (a.k.a. uudeview/uuenview)
p5-Crypt-CBC-2.33              Perl5 interface to Cipher Block Chaining with DES and IDEA
p5-Crypt-DES-2.07              Perl5 interface to DES block cipher
p5-Crypt-OpenSSL-Bignum-0.04   OpenSSL's multiprecision integer arithmetic
p5-Crypt-OpenSSL-RSA-0.28      Perl5 module to RSA encode and decode strings using OpenSSL
p5-Crypt-OpenSSL-Random-0.06   Perl5 interface to the OpenSSL pseudo-random number generator
p5-DBD-SQLite-1.42             Provides access to SQLite3 databases through the DBI
p5-DBD-mysql-4.028             MySQL driver for the Perl5 Database Interface (DBI)
p5-DBI-1.631                   Perl5 Database Interface, required for DBD::* modules
p5-Digest-HMAC-1.03_1          Perl5 interface to HMAC Message-Digest Algorithms
p5-Digest-SHA1-2.13            Perl interface to the SHA-1 Algorithm
p5-Encode-Detect-1.01          Encode::Encoding subclass that detects the encoding of data
p5-ExtUtils-CBuilder-0.2802.12,1 Compile and link C code for Perl modules
p5-File-Copy-Recursive-0.38_1  Perl extension for recursively copying files and directories
p5-File-Tail-0.99.3_1          Perl Module to read the end of a file as it's appended to
p5-GSSAPI-0.28                 Perl extension providing access to the GSSAPIv2 library
p5-HTML-Parser-3.71            Perl5 module for parsing HTML documents
p5-HTML-Tagset-3.20            Some useful data table in parsing HTML
p5-HTTP-Date-6.02              Conversion routines for the HTTP protocol date formats
p5-IO-Multiplex-1.13           IO::Multiplex - Manage IO on many file handles
p5-IO-Socket-INET6-2.69        Perl module with object interface to AF_INET6 domain sockets
p5-IO-Socket-IP-0.32           Drop-in replacement for IO::Socket::INET supporting IPv4 and IPv6
p5-IO-Socket-SSL-1.998         Perl5 interface to SSL sockets
p5-IO-Tee-0.64_3               Multiplex output to multiple output handles
p5-IO-stringy-2.110_1          Perl5 module for using IO handles with non-file objects
p5-List-MoreUtils-0.33         Provide the stuff missing in List::Util
p5-Locale-gettext-1.05_3       Message handling functions
p5-Log-Log4perl-1.42           Log4j implementation for Perl
p5-MIME-Base64-3.14            Perl5 module for Base64 and Quoted-Printable encodings
p5-MIME-Tools-5.505_1,2        Set of perl5 modules for MIME
p5-Mail-DKIM-0.40              Perl5 module to process and/or create DKIM email
p5-Mail-IMAPClient-3.35_1      Perl5 module to talk to a IMAP4rev1 (RFC2060) server
p5-Mail-Tools-2.13_1           Perl5 modules for dealing with Internet e-mail messages
p5-Module-Build-0.4206         Build and install Perl modules
p5-Mozilla-CA-20130114         Perl extension for Mozilla CA cert bundle in PEM format
p5-Net-CIDR-0.17               Perl module to manipulate IPv4/IPv6 netblocks in CIDR notation
p5-Net-DNS-0.79                Perl5 interface to the DNS resolver, and dynamic updates
p5-Net-IP-1.26                 Perl extension for manipulating IPv4/IPv6 addresses
p5-Net-LibIDN-0.12_2           This module provides access to the libidn library
p5-Net-SNMP-6.0.1              Object oriented interface to SNMP
p5-Net-SSLeay-1.66             Perl5 interface to SSL
p5-Net-Server-2.008_1          Configurable base class for writing internet servers in Perl
p5-Net-XWhois-0.90_4           Whois Client Interface for Perl5
p5-NetAddr-IP-4.069_1          Perl module for working with IP addresses and blocks thereof
p5-Parse-RecDescent-1.967.009_2 Recursive descent parsing framework for Perl
p5-RRD-Simple-1.44_6           Simple interface to create and store data in RRD files
p5-Socket-2.015                Networking constants and support functions
p5-Socket6-0.25_1              IPv6 related part of the C socket.h defines and structure manipulators
p5-Term-ReadKey-2.32_1         Perl5 module for simple terminal control
p5-TimeDate-2.30_1,1           Perl5 module containing a better/faster date parser for absolute dates
p5-URI-1.64                    Perl5 interface to Uniform Resource Identifier (URI) references
p5-Unicode-String-2.09_1       These are experimental Perl5 modules to handle various Unicode issues
p5-Unix-Syslog-1.1_1           Perl5 interface to the UNIX syslog(3) calls
p5-XML-Parser-2.41_1           Perl extension interface to James Clark's XML parser, expat

7

Re: Dashboard Stats Blank

Since it seems p5-MIME-Tools is the offending port

I did: 
make deinstall
make clean
make install

Removed, cleaned and Installed successfully.

No change on starting amavisd

8

Re: Dashboard Stats Blank

I have no idea, sorry. please post to Amavisd mailing list instead:
http://www.ijs.si/software/amavisd/#support