Results 1 to 10 of 43

Thread: Daily mail report always reports "No messages found"

Hybrid View

  1. #1
    Join Date
    Apr 2006
    Location
    Switzerland
    Posts
    46
    Rep Power
    9

    Default Daily mail report always reports "No messages found"

    Every day I get a report mail which always looks like this:
    Generating report


    From 2006-06-10 00:00:00 to 2006-06-11 00:00:00

    No messages found
    But there are mails sent out and received. "zmcontrol status" reports the logger is running:
    logger Running
    The process list indicates the logger database is running:
    /opt/zimbra/logger/mysql/bin/mysqld --defaults-file=/opt/zimbra/conf/my.logger.cnf --basedir=/opt/zimbra/logger/mysql --datadir=/opt/zimbra/logger/db/data --pid-file=/opt/zimbra/logger/db/mysql.pid --skip-locking --port=7307 --socket=/opt/zimbra/logger/db/mysql.sock
    I could not find anything releated to the logger in the file "/opt/zimbra/log/zimbra.log", but the log file "/var/log/zimbra.log" indicates the logger is running, too:
    Jun 11 06:48:03 h880950 zimbramon[20789]: 20789:info: 2006-06-11 06:48:01, STATUS:
    I run the OSS Zimbra Version 3.1.2_GA_445.DEBIAN3.1 30.05.2006 on Debian Sarge.

    Any ideas what I can do to solve this problem and get correct daily mail reports?

    Thanks a lot
    McPringle

  2. #2
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

    I belive this may be fixed in the 3.1.2 release.

    Install it, and report back.

    John

  3. #3
    Join Date
    Apr 2006
    Location
    Switzerland
    Posts
    46
    Rep Power
    9

    Default

    Quote Originally Posted by wannabetenor
    I belive this may be fixed in the 3.1.2 release.

    I'm actually running 3.1.2. Maybe you mean todays new version 3.1.3? I'll install it soon and report here.

    Thanks
    McPringle

  4. #4
    Join Date
    Apr 2006
    Posts
    27
    Rep Power
    9

    Default

    McPringle,

    There may be a problem with your logger mysql password if you are experiencing these blank reports.

    From the command line:

    # su - zimbra
    # zmlogprocess

    What output do you get from the zmlogprocess command? Does it run normally and produce logs or do you receive a mysql permissions error?

    Regards,

    Andrew.

  5. #5
    Join Date
    Dec 2005
    Location
    Peterborough, UK
    Posts
    140
    Rep Power
    10

    Default

    I was getting the same issue running 3.1.2 to fix the issue I would have to restart thr zimbra services by running zmcontrol stop / start. No errors were coming up in the logs.

    I've just upgraded to 3.1.3 a few hours ago, so I'll wait and see what happens. Incidently I've just run zmlogprocess and it just returned blank.
    Last edited by FunkyPenguin; 06-14-2006 at 02:35 AM.

  6. #6
    Join Date
    Apr 2006
    Posts
    27
    Rep Power
    9

    Default

    We were receiving the errors across 3.1.2 on one of our upgrades and it was due to a mysql logger error as far as we could tell.

    Upon resetting the logger passwords in the grant tables and resetting the localconfig.xml we got our daily mail report working again.

    Let us know how you get on with 3.1.3

  7. #7
    Join Date
    May 2006
    Location
    England.
    Posts
    927
    Rep Power
    10

    Default

    Quote Originally Posted by ecactive
    McPringle,

    There may be a problem with your logger mysql password if you are experiencing these blank reports.

    From the command line:

    # su - zimbra
    # zmlogprocess

    What output do you get from the zmlogprocess command? Does it run normally and produce logs or do you receive a mysql permissions error?

    Regards,

    Andrew.
    Old thread, I know, but I'm still having problems with the daily report, and while trying to fix it I saw this comment, when I try zmlogprocess I do indeed get errors, so does anyone know how to fix it up?

    This is now running 4.0 rc1, the output is:
    Code:
    zimbra@zimbra:~/libexec> ./zmlogprocess
    zimbra maps to zimbra.domain.local
    zimbra maps to zimbra.domain.local
    zimbra maps to zimbra.domain.local
    zimbra maps to zimbra.domain.local
    zimbra maps to zimbra.domain.local
    zimbra maps to zimbra.domain.local
    zimbra maps to zimbra.domain.local
    zimbra maps to zimbra.domain.local
    Processing mta entries from 44444
    DBD::mysql::st execute failed: Can't open file: 'raw_logs.MYI' (errno: 145) at ./zmlogprocess line 989.
    Error executing select distinct(postfix_qid) from raw_logs where postfix_qid is not null and app like 'postfix%' and id > '44444' with
    Can't open file: 'raw_logs.MYI' (errno: 145)
    Can't open file: 'raw_logs.MYI' (errno: 145) at ./zmlogprocess line 990.
    
    Can't call method "fetchall_arrayref" on an undefined value at ./zmlogprocess line 744.

  8. #8
    Join Date
    May 2006
    Location
    England.
    Posts
    927
    Rep Power
    10

    Default

    I think I made it worse, I tried running zmloggerinit, thinking this may fix things, and this happened:
    Code:
    zimbra@zimbra:~/libexec> ./zmloggerinit
    * Creating required directories
    * Creating database in /opt/zimbra/logger/db/data
    * Starting logger_mysql server
    * Loading schema /opt/zimbra/db/loggerdb.sql
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
    * Setting random password for mysql root user in zimbra local config
    * Setting random password for mysql zimbra user in zimbra local config
    * Changing mysql root user password
    /opt/zimbra/logger/mysql/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: NO)'
    * Changing mysql zimbra user password
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    **** PASSWORD CHANGE FAILED
    So I reran zmlogprocess to see the effect and the output from that now looks like this:
    Code:
    zimbra@zimbra:~/libexec> ./zmlogprocess
    DBI connect('database=zimbra_logger;mysql_read_default_file=/opt/zimbra/conf/my.logger.cnf;mysql_socket=/opt/zimbra/logger/db/mysql.sock','zimbra',...) failed: Access denied for user 'zimbra'@'localhost' (using password: YES) at ./zmlogprocess line 63
    DB: Can't connect to dbi:mysql:database=zimbra_logger;mysql_read_default_file=/opt/zimbra/conf/my.logger.cnf;mysql_socket=/opt/zimbra/logger/db/mysql.sock: Access denied for user 'zimbra'@'localhost' (using password: YES)
    At this point, I'm gonna stop playing with it incase I break it more. The server is still up and seems to be working ok for mail etc, but I think there's something wrong under the surface. Help on this one would be greatly appreciated.

Similar Threads

  1. Problems with port 25
    By yogiman in forum Installation
    Replies: 57
    Last Post: 06-13-2011, 02:55 PM
  2. Replies: 7
    Last Post: 02-03-2011, 07:01 AM
  3. fresh install down may be due to tomcat
    By gon in forum Installation
    Replies: 10
    Last Post: 07-25-2007, 09:09 AM
  4. DynDNS and Zimbra
    By afterwego in forum Installation
    Replies: 30
    Last Post: 04-01-2007, 04:34 PM
  5. receiveing mail
    By maybethistime in forum Administrators
    Replies: 15
    Last Post: 12-09-2005, 04:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •