Zimbra offers Open Source email server software and shared calendar for Linux and the Mac
Go Back   Zimbra :: Forums > Zimbra Collaboration Suite > Administrators

Welcome to the Zimbra :: Forums!
Welcome, if you would like to post a comment please register. We also encourage you to explore all things Zimbra with our team and members of the community.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #31 (permalink)  
Old 04-17-2008, 03:16 AM
Zimbra Consultant & Moderator
 
Posts: 20,312
Default

Is everybody happy? All the logging/graphs working OK now?
__________________
Regards


Bill
Reply With Quote
  #32 (permalink)  
Old 04-17-2008, 08:20 AM
New Member
 
Posts: 3
Default

Nope...still no graphs on mine. All tables are ok and I do not get any errors in logprocess.out. Arrrghhh.....

Here is my logprocess.out:-
Pruning service/server entries older then 2008-04-17 23:00:02
mailit maps to mailit.xanadu.com.my
Processing mta entries from 0
Found 2 messages
Inserted 2 rows
Saving ID 0
Deleting processed postfix logs from raw_logs...Done
Processing clamd entries from 0
Found 0 entries
Deleting processed clamd logs from raw_logs...Done
Processing amavis entries from 154594
Found 4 entries
FAILED 154951: (22316-01) Blocked SPAM, [179.166.157.104] <erkim-ilac@stilcephe.net> -> <brianw@pkfmalaysia.com>, Message-ID: <480774C1.8010504@accmail.com>,
mail_id: ZkyoJ1YSVZQF, Hits: 17.945, size: 1064, 4657 ms
Saving ID 154954
Deleting processed amavis logs from raw_logs...Done
Processing sendmail entries from 0
Found 0 entries
Deleting processed sendmail logs from raw_logs...Done
Processing zimbramon entries from 154837
Found 2 entries
Saving ID 154977
Deleting processed zimbramon logs from raw_logs...Done
Aggregating hour mta from 2008-04-17 22:00:00 to 2008-04-17 23:00:00
Aggregating day mta from 2008-04-16 00:00:00 to 2008-04-17 00:00:00
Aggregating hour amavis from 2008-04-17 22:00:00 to 2008-04-17 23:00:00
Aggregating day amavis from 2008-04-16 00:00:00 to 2008-04-17 00:00:00
Aggregating hour disk from 2008-04-17 22:00:00 to 2008-04-17 23:00:00
Aggregating day disk from 2008-04-16 00:00:00 to 2008-04-17 00:00:00
Retaining 31 days worth of raw logs based on zimbraLogRawLifetime config.
Retaining 730 days worth of summary logs based on zimbraLogSummaryLifetime config.
Pruning raw mta logs from 2008-03-17 00:00:00
Pruning raw amavis logs from 2008-03-17 00:00:00
Pruning raw disk logs from 2008-03-17 00:00:00
Pruning summary mta logs from 2006-04-18 00:00:00
Pruning summary amavis logs from 2006-04-18 00:00:00
Pruning summary disk logs from 2006-04-18 00:00:00
Pruning other raw logs from 2008-03-17 00:00:00
Optimizing mta tables
Optimizing raw amavis tables
Optimizing raw disk logs table
Optimizing summary mta logs table
Optimizing summary amavis logs table
Optimizing summary disk logs table
Optimizing other raw logs table
Reply With Quote
  #33 (permalink)  
Old 04-17-2008, 08:35 AM
Zimbra Consultant & Moderator
 
Posts: 20,312
Default

Quote:
Originally Posted by patcsy88 View Post
Nope...still no graphs on mine. All tables are ok and I do not get any errors in logprocess.out. Arrrghhh...
Please follow the Troubleshooting steps in the link above and post back with details about what you find.
__________________
Regards


Bill
Reply With Quote
  #34 (permalink)  
Old 04-17-2008, 09:16 AM
Member
 
Posts: 11
Default

Repairing the mta Table fixed my issue and I now have statis in the Admin Console.
Reply With Quote
  #35 (permalink)  
Old 04-17-2008, 11:10 AM
Member
 
Posts: 11
Default

Still no graphs here either.

When I first started working on this I had a crashed table, but I repaired that before I even made my post in this thread. At that point I restarted logger and zmstats.

I have no errors in the mysql hostname.err file since fixing the table, and zmcontrol status shows everything is running.

This is a single node setup.

I followed everything on the logger troubleshooting wiki page, and running zmlogprocess and zmgengraphs run fine with no errors.

There is MTA activity, but in the zimbra log the one thing I don't see is any log matches for STATUS or DISK in /var/log/zimbra.log. I do see matches for QUEUE, but these all seem to postfix output lines that are actually matching NOQUEUE.

iostat is installed:
Code:
zimbra@hostname:~/zmstat$ iostat
Linux 2.6.15-28-386 (krusty)    04/17/2008

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
          69.50    0.00    2.49    0.28    0.00   27.72

Device:            tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
hdc              14.43        44.37       332.48    4557575   34147984
hdd               0.00         0.01         0.00       1066          0
Also, when I connect manually to the logger SQL database, the service_status table seems to be empty:

Code:
zimbra@hostname:/var/log$ logmysql zimbra_logger
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 19
Server version: 5.0.45-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select * from service_status;
Empty set (0.00 sec)
I do see rows for todays date in the raw_logs table.

Also, I can't find a logprocess.out anywhere on the system:

Code:
root@hostname:/var/log# ls /tmp
hsperfdata_root  hsperfdata_zimbra  ssh-twyHe18451  zimbra
and:

Code:
root@hostname:/var/log# find / -name logprocess.out
root@hostname:/var/log#
But everything says logger is running:

Code:
zimbra@hostname:/var/log$ zmcontrol status
Host hostname
        antispam                Running
        antivirus               Running
        ldap                    Running
        logger                  Running
        mailbox                 Running
        mta                     Running
        snmp                    Running
        spell                   Running
        stats                   Running
And I only see one copy of logswatch running:
Code:
zimbra@hostname:/var/log$ ps aux | grep logswatch
zimbra   32043  0.0  0.0   5544  1516 ?        S    06:24   0:00 /usr/bin/perl /opt/zimbra/libexec/logswatch --config-file=/opt/zimbra/conf/logswatchrc --use-cpan-file-tail --script-dir=/tmp -t /var/log/zimbra.log
zimbra   31763  0.0  0.0   1628   544 pts/1    R+   13:58   0:00 grep logswatch
Lastly, looking back at my zmstat.out file I see the following error that has showed up twice since I last restarted the loggers:

[code]
zimbra@hostname:~/zmstat$ tail -n 5 /opt/zimbra/zmstat/zmstat.out
Warning: Not possible to monitor process stats
Warning: Not possible to monitor process stats
Warning: Not possible to monitor process stats
04/16/2008 16:59:30: ERROR: No such process: '31689'
04/17/2008 13:26:30: ERROR: No such process: '18470'
[code]

Thanks and please let me know what other details I can post,

-Scott
Reply With Quote
  #36 (permalink)  
Old 04-17-2008, 11:22 AM
Zimbra Consultant & Moderator
 
Posts: 20,312
Default

Quote:
Originally Posted by sberkman View Post
Thanks and please let me know what other details I can post,
I'd really like to leave this problem until we resolve your other thread, if that's OK. I think both of these problems may be connected.
__________________
Regards


Bill
Reply With Quote
  #37 (permalink)  
Old 04-17-2008, 01:27 PM
Active Member
 
Posts: 32
Default

I have the exact same problem as Scott.... Any help would be great this problem has been annoying me for months now....
Reply With Quote
  #38 (permalink)  
Old 04-17-2008, 01:51 PM
New Member
 
Posts: 3
Default

I think I've got a completely different issue. logprocess.out has no errors.

My tables all check fine, but the mta and mta_aggregate tables are both empty. I see some old threads with that same issue but none of them were ever resolved.

Is there any way to get verbose output from the zmlogprocess script? My guess is that's where it's failing.
Reply With Quote
  #39 (permalink)  
Old 04-17-2008, 07:21 PM
Starter Member
 
Posts: 2
Default

hi,

I'm experiencing the same thing.
Everything seems to be running but no graphs and daily reports.
Running zmlogprocess and zmgengraphs doesn't give me any errors.




check table raw_logs;
Code:
+------------------------+-------+----------+----------+
| Table                  | Op    | Msg_type | Msg_text |
+------------------------+-------+----------+----------+
| zimbra_logger.raw_logs | check | status   | OK       | 
+------------------------+-------+----------+----------+
1 row in set (0.02 sec)
in zmstat.out
Code:
Warning:Not possible to monitor process stats
Warning: Not possible to monitor process stats
Warning: Not possible to monitor process stats
Warning: Not possible to monitor process stats
04/17/2008 12:27:30: ERROR: No such process: '7480'

/opt/zimbra/logger/db/data/<hostname>.err
Code:
080413 23:03:43  mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
080413 23:03:43  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080413 23:03:43  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
080413 23:03:43  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
080413 23:03:44  InnoDB: Started; log sequence number 0 0
080413 23:03:44 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: ready for connections.
Version: '5.0.45-log'  socket: '/opt/zimbra/logger/db/mysql.sock'  port: 7307  Source distribution
A mysqld process already exists at  Sun Apr 13 23:04:34 MYT 2008
080413 23:04:43 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Normal shutdown

080413 23:04:43  InnoDB: Starting shutdown...
080413 23:04:46  InnoDB: Shutdown completed; log sequence number 0 43655
080413 23:04:46 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Shutdown complete

080413 23:04:46  mysqld ended

080413 23:04:49  mysqld started
080413 23:04:49  InnoDB: Started; log sequence number 0 43655
080413 23:04:49 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: ready for connections.
Version: '5.0.45-log'  socket: '/opt/zimbra/logger/db/mysql.sock'  port: 7307  Source distribution
080413 23:06:55 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Normal shutdown

080413 23:06:55  InnoDB: Starting shutdown...
080413 23:06:57  InnoDB: Shutdown completed; log sequence number 0 43655
080413 23:06:57 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Shutdown complete

080413 23:06:57  mysqld ended

080413 23:07:21  mysqld started
080413 23:07:21  InnoDB: Started; log sequence number 0 43655
080413 23:07:21 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: ready for connections.
Version: '5.0.45-log'  socket: '/opt/zimbra/logger/db/mysql.sock'  port: 7307  Source distribution
080414  3:00:17 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Normal shutdown

080414  3:00:17  InnoDB: Starting shutdown...
080414  3:00:19  InnoDB: Shutdown completed; log sequence number 0 43655
080414  3:00:19 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Shutdown complete

080414 03:00:19  mysqld ended

080417 11:11:48  mysqld started
080417 11:11:49  InnoDB: Started; log sequence number 0 43655
080417 11:11:49 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: ready for connections.
Version: '5.0.45-log'  socket: '/opt/zimbra/logger/db/mysql.sock'  port: 7307  Source distribution
080417 11:14:20 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Normal shutdown

080417 11:14:20  InnoDB: Starting shutdown...
080417 11:14:22  InnoDB: Shutdown completed; log sequence number 0 43655
080417 11:14:22 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Shutdown complete

080417 11:14:22  mysqld ended

080417 11:15:59  mysqld started
080417 11:16:00  InnoDB: Started; log sequence number 0 43655
080417 11:16:00 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: ready for connections.
Version: '5.0.45-log'  socket: '/opt/zimbra/logger/db/mysql.sock'  port: 7307  Source distribution
080417 11:32:25 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Normal shutdown

080417 11:32:25  InnoDB: Starting shutdown...
080417 11:32:28  InnoDB: Shutdown completed; log sequence number 0 43655
080417 11:32:28 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Shutdown complete

080417 11:32:28  mysqld ended

080417 11:38:28  mysqld started
080417 11:38:30  InnoDB: Started; log sequence number 0 43655
080417 11:38:30 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: ready for connections.
Version: '5.0.45-log'  socket: '/opt/zimbra/logger/db/mysql.sock'  port: 7307  Source distribution
ps aux | grep logswatch
(Seems to have 2 processes?) could the multiple processes be the cause?

Code:
zimbra    6432  0.0  0.5   5704  2872 ?        S    Apr17   0:00 /usr/bin/perl /opt/zimbra/libexec/logswatch --config-file=/opt/zimbra/conf/logswatchrc --use-cpan-file-tail --script-dir=/tmp -t /var/log/zimbra.log
zimbra    4819  0.0  0.7   5556  3904 ?        S    06:25   0:00 /usr/bin/perl /opt/zimbra/libexec/logswatch --config-file=/opt/zimbra/conf/logswatchrc --use-cpan-file-tail --script-dir=/tmp -t /var/log/zimbra.log
root     23037  0.0  0.1   2884   820 pts/1    S+   10:34   0:00 grep logswatch
zmdailyreport
Code:
Generating report
        From 2008-04-17 00:00:00 to 2008-04-18 00:00:00

No messages found






Running ZCS FOSS 5.0.4 on Ubuntu 6.06 LTS x86.

Last edited by tricolor; 04-17-2008 at 07:51 PM..
Reply With Quote
  #40 (permalink)  
Old 04-18-2008, 12:25 AM
Active Member
 
Posts: 31
Default

I do get errors in this file:
/opt/zimbra/logger/db/data/<hostname>.err

Quote:
080417 17:09:01 mysqld started
080417 17:09:01 InnoDB: Started; log sequence number 0 43655
080417 17:09:01 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: ready for connections.
Version: '5.0.45-log' socket: '/opt/zimbra/logger/db/mysql.sock' port: 7307 Source distribution
080417 22:38:37 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 0:50:38 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 1:09:50 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 1:22:13 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 1:39:02 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 1:49:21 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 1:59:29 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 2:09:15 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 2:22:27 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 2:39:31 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 2:49:26 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 2:59:29 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 3:10:00 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 3:19:58 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 3:30:14 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 3:49:22 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 4:00:40 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 4:20:38 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 4:40:06 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 5:00:07 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 5:19:14 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 5:29:16 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 5:40:12 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 5:59:22 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 6:09:24 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 6:19:30 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 6:29:37 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 6:39:52 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 6:49:43 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 6:59:40 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 7:10:16 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 7:29:17 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 7:39:59 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 7:51:36 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 8:10:51 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 8:30:52 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 8:51:57 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
080418 9:12:22 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Sort aborted
I did recover all mysql tables, 'mta' was damaged so I recovered it. But no graphs yet.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads

Why Join?

Registering let's you ask questions, makes it easier to search, displays any files attached to posts, and notifies you about replies.

blog.zimbra.com




 

SEO by vBSEO ©2011, Crawlability, Inc.