Server statistics problem

[janezek]

so i change all the programs to use EXT IP, so zimbra is working, sort of...
Server Statistic is not showing data:

zmloggerctl status; echo $?; ps ax | grep zmlogger

0
3691 ? S 0:35 /usr/bin/perl /opt/zimbra/libexec/zmlogger
3802 ? S 0:00 zmlogger: zmrrdfetch: server
30775 pts/3 S+ 0:00 grep zmlogger

/opt/zimbra/libexec/zmrrdfetch -f zmmtastats

no structure found for zmmtastats at /opt/zimbra/libexec/zmrrdfetch line 239.

/opt/zimbra/libexec/zmrrdfetch -c -f zmmtastats

no structure found for zmmtastats at /opt/zimbra/libexec/zmrrdfetch line 239.

grep -w MTA /var/log/zimbra-stats.log

*NOTHING*

tail /var/log/zimbra-stats.log

Jun 1 10:35:30 tovarnaidej zimbramon[8572]: 8572:info: :::A2E4338A-6D58-11DF-8EAA-2E8E4BDB286D::, Com_stmt_close, Com_stmt_execute, Com_stmt_fetch, Com_stmt_prepare, Com_stmt_reset, Com_stmt_send_long_data, Com_truncate, Com_unlock_tables, Com_update, Com_update_multi, Com_xa_commit, Com_xa_end, Com_xa_prepare, Com_xa_recover, Com_xa_rollback, Com_xa_start, Compression, Connections, Created_tmp_disk_tables, Created_tmp_files, Created_tmp_tables, Delayed_errors, Delayed_insert_threads, Delayed_writes, Flush_commands, Handler_commit, Handler_delete, Handler_discover, Handler_prepare, Handler_read_first, Handler_read_key, Handler_read_next, Handler_read_prev, Handler_read_rnd, Handler_read_rnd_next, Handler_rollback, Handler_savepoint, Handler_savepoint_rollback, Handler_update, Handler_write, Innodb_buffer_pool_pages_data, Innodb_buffer_pool_pages_dirty, Innodb_buffer_pool_pages_flush:::A2E43768-6D58-11DF-8EAA-2E8E4BDB286D:::
Jun 1 10:35:30 tovarnaidej zimbramon[8572]: 8572:info: :::A2E43768-6D58-11DF-8EAA-2E8E4BDB286D:::ed, Innodb_buffer_pool_pages_free, Innodb_buffer_pool_pages_misc, Innodb_buffer_pool_pages_total, Innodb_buffer_pool_read_ahead_rnd, Innodb_buffer_pool_read_ahead_seq, Innodb_buffer_pool_read_requests, Innodb_buffer_pool_reads, Innodb_buffer_pool_wait_free, Innodb_buffer_pool_write_requests, Innodb_data_fsyncs, Innodb_data_pending_fsyncs, Innodb_data_pending_reads, Innodb_data_pending_writes, Innodb_data_read, Innodb_data_reads, Innodb_data_writes, Innodb_data_written, Innodb_dblwr_pages_written, Innodb_dblwr_writes, Innodb_log_waits, Innodb_log_write_requests, Innodb_log_writes, Innodb_os_log_fsyncs, Innodb_os_log_pending_fsyncs, Innodb_os_log_pending_writes, Innodb_os_log_written, Innodb_page_size, Innodb_pages_created, Innodb_pages_read, Innodb_pages_written, Innodb_row_lock_current_wai:::A2E43B1E-6D58-11DF-8EAA-2E8E4BDB286D:::
Jun 1 10:35:30 tovarnaidej zimbramon[8572]: 8572:info: :::A2E43B1E-6D58-11DF-8EAA-2E8E4BDB286D:::ts, Innodb_row_lock_time, Innodb_row_lock_time_avg, Innodb_row_lock_time_max, Innodb_row_lock_waits, Innodb_rows_deleted, Innodb_rows_inserted, Innodb_rows_read, Innodb_rows_updated, Key_blocks_not_flushed, Key_blocks_unused, Key_blocks_used, Key_read_requests, Key_reads, Key_write_requests, Key_writes, Last_query_cost, Max_used_connections, Not_flushed_delayed_rows, Open_files, Open_streams, Open_tables, Opened_tables, Prepared_stmt_count, Qcache_free_blocks, Qcache_free_memory, Qcache_hits, Qcache_inserts, Qcache_lowmem_prunes, Qcache_not_cached, Qcache_queries_in_cache, Qcache_total_blocks, Queries, Questions, Rpl_status, Select_full_join, Select_full_range_join, Select_range, Select_range_check, Select_scan, Slave_open_temp_tables, Slave_retried_transactions, Slave_running, Slow_launch:::A2E43ED4-6D58-11DF-8EAA-2E8E4BDB286D:::
Jun 1 10:35:30 tovarnaidej zimbramon[8572]: 8572:info: :::A2E43ED4-6D58-11DF-8EAA-2E8E4BDB286D:::_threads, Slow_queries, Sort_merge_passes, Sort_range, Sort_rows, Sort_scan, Ssl_accept_renegotiates, Ssl_accepts, Ssl_callback_cache_hits, Ssl_cipher, Ssl_cipher_list, Ssl_client_connects, Ssl_connect_renegotiates, Ssl_ctx_verify_depth, Ssl_ctx_verify_mode, Ssl_default_timeout, Ssl_finished_accepts, Ssl_finished_connects, Ssl_session_cache_hits, Ssl_session_cache_misses, Ssl_session_cache_mode, Ssl_session_cache_overflows, Ssl_session_cache_size, Ssl_session_cache_timeouts, Ssl_sessions_reused, Ssl_used_session_cache_entries, Ssl_verify_depth, Ssl_verify_mode, Ssl_version, Table_locks_immediate, Table_locks_waited, Tc_log_max_pages_used, Tc_log_page_size, Tc_log_page_waits, Threads_cached, Threads_connected, Threads_created, Threads_running, Uptime:: 06/01/2010 10:35:30,1,0,0,0,870875,102:::A2E44280-6D58-11DF-8EAA-2E8E4BDB286D:::
Jun 1 10:35:30 tovarnaidej zimbramon[8572]: :::A2E44280-6D58-11DF-8EAA-2E8E4BDB286D:::34771,2,0,0,0,0,0,0,0,0,0,0,1102,0, 0,0,0,0,0,550,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1697,0,2284,5099,0 ,0,0,2,0,0,0,0,0,0,0,579,0,0,0,0,0,0,0,0,0,0,1620, 0,0,0,2,0,0,0,0,0,0,0,0,0,0,0,556,0,0,0,0,0,0,0,OF F,1623,0,5,1164,0,0,0,1,2208,0,0,0,16,5538,593,0,0 ,289351,6,0,0,0,288150,129,0,1727,98494,1,98624,1, 0,178427,78,0,2941,2797,0,0,0,4296704,102,3399,572 90240,1727,562,0,258,563,1117,0,0,416256,16384,0,1 29,1727,0,0,0,0,0,0,0,1710,556,0,7245,0,0,0,0,0,0. 000000,3,0,33,0,26,32,0,0,0,0,0,0,0,0,0,14650,1465 0,NULL,0,0,0,0,1169,0,0,OFF,0,5,0,0,0,0,0,0,0,,,0, 0,0,0,0,0,0,0,0,NONE,0,0,0,0,0,0,0,,2792,0,0,0,0,1 ,2,3,1,34807
Jun 1 10:35:30 tovarnaidej zimbramon[8556]: 8556:info: zmstat proc.csv: timestamp, system, user, sys, idle, iowait, mailbox, mailbox-total-cpu, mailbox-utime, mailbox-stime, mailbox-totalMB, mailbox-rssMB, mailbox-sharedMB, mailbox-process-count, mysql, mysql-total-cpu, mysql-utime, mysql-stime, mysql-totalMB, mysql-rssMB, mysql-sharedMB, mysql-process-count, convertd, convertd-total-cpu, convertd-utime, convertd-stime, convertd-totalMB, convertd-rssMB, convertd-sharedMB, convertd-process-count, ldap, ldap-total-cpu, ldap-utime, ldap-stime, ldap-totalMB, ldap-rssMB, ldap-sharedMB, ldap-process-count, postfix, postfix-total-cpu, postfix-utime, postfix-stime, postfix-totalMB, postfix-rssMB, postfix-sharedMB, postfix-process-count, amavis, amavis-total-cpu, amavis-utime, amavis-stime, amavis-totalMB, amavis-rssMB, amavis-sharedMB, amavis-process-:::A34896E0-6D58-11DF-8C8A-1E8E4BDB286D:::
Jun 1 10:35:30 tovarnaidej zimbramon[8556]: :::A34896E0-6D58-11DF-8C8A-1E8E4BDB286D:::count, clam, clam-total-cpu, clam-utime, clam-stime, clam-totalMB, clam-rssMB, clam-sharedMB, clam-process-count:: 06/01/2010 10:35:30, system, 7.5, 1.3, 87.7, 3.5, mailbox, 0.0, 0.0, 0.0, 1833.4, 393.2, 6.9, 1, mysql, 0.0, 0.0, 0.0, 1775.0, 153.1, 3.2, 1, convertd, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, ldap, 0.0, 0.0, 0.0, 175.2, 29.6, 2.2, 1, postfix, 0.0, 0.0, 0.0, 7.5, 1.7, 1.3, 3, amavis, 0.0, 0.0, 0.0, 58.5, 47.8, 0.9, 11, clam, 0.0, 0.0, 0.0, 104.5, 94.6, 0.7, 2
Jun 1 10:35:30 tovarnaidej zimbramon[8976]: 8976:info: zmstat fd.csv: timestamp, fd_count, mailboxd_fd_count:: 06/01/2010 10:35:30, 5440, 147
Jun 1 10:35:32 tovarnaidej zimbramon[8558]: 8558:info: zmstat cpu.csv: timestamp, cpu:user, cpu:nice, cpu:sys, cpu:idle, cpu:iowait, cpu:irq, cpu:softirq, cpu0:user, cpu0:nice, cpu0:sys, cpu0:idle, cpu0:iowait, cpu0:irq, cpu0:softirq, cpu1:user, cpu1:nice, cpu1:sys, cpu1:idle, cpu1:iowait, cpu1:irq, cpu1:softirq, cpu2:user, cpu2:nice, cpu2:sys, cpu2:idle, cpu2:iowait, cpu2:irq, cpu2:softirq, cpu3:user, cpu3:nice, cpu3:sys, cpu3:idle, cpu3:iowait, cpu3:irq, cpu3:softirq, cpu4:user, cpu4:nice, cpu4:sys, cpu4:idle, cpu4:iowait, cpu4:irq, cpu4:softirq, cpu5:user, cpu5:nice, cpu5:sys, cpu5:idle, cpu5:iowait, cpu5:irq, cpu5:softirq, cpu6:user, cpu6:nice, cpu6:sys, cpu6:idle, cpu6:iowait, cpu6:irq, cpu6:softirq, cpu7:user, cpu7:nice, cpu7:sys, cpu7:idle, cpu7:iowait, cpu7:irq, cpu7:softirq:: 06/01/2010 10:35:32, 6.8, 0.0, 1.2, 88.1, 3.5, 0.3, 0.1, 11:::A4272B94-6D58-11DF-AFE4-208E4BDB286D:::
Jun 1 10:35:32 tovarnaidej zimbramon[8558]: :::A4272B94-6D58-11DF-AFE4-208E4BDB286D:::.1, 0.0, 1.3, 69.4, 14.8, 2.3, 1.1, 4.1, 0.0, 0.8, 94.5, 0.6, 0.0, 0.0, 3.0, 0.0, 0.3, 96.3, 0.3, 0.0, 0.0, 1.1, 0.0, 0.3, 98.5, 0.1, 0.0, 0.0, 8.3, 0.0, 1.7, 78.6, 11.4, 0.0, 0.1, 16.9, 0.0, 2.4, 80.6, 0.1, 0.0, 0.0, 4.3, 0.0, 1.2, 94.4, 0.1, 0.0, 0.0, 5.5, 0.0, 1.4, 92.9, 0.2, 0.0, 0.0

zmsoap -z GetLoggerStatsRequest stats/@name=zmmtastats | head -20

GetLoggerStatsResponse xmlns="urn:zimbraAdmin"/

zmsoap -z GetLoggerStatsRequest stats/@name=zmmtastats @limit=1 | head -50

GetLoggerStatsResponse xmlns="urn:zimbraAdmin"/

log from zmlogswatch.out

no structure found for zmmtastats at /opt/zimbra/libexec/zmrrdfetch line 239.
no structure found for zmmtastats at /opt/zimbra/libexec/zmrrdfetch line 239.
Tue Jun 1 10:32:30 2010: Spawned: 26048 -- Connected from 91.185.208.25:42480
Tue Jun 1 10:32:30 2010: Spawned: 26050 -- Connected from 91.185.208.25:42481
Tue Jun 1 10:32:30 2010: Spawned: 26052 -- Connected from 91.185.208.25:42482
Tue Jun 1 10:32:30 2010: Spawned: 26054 -- Connected from 91.185.208.25:42483
no structure found for zmmtastats at /opt/zimbra/libexec/zmrrdfetch line 239.
no structure found for zmmtastats at /opt/zimbra/libexec/zmrrdfetch line 239.
no structure found for zmmtastats at /opt/zimbra/libexec/zmrrdfetch line 239.
no structure found for zmmtastats at /opt/zimbra/libexec/zmrrdfetch line 239.
Tue Jun 1 10:36:20 2010: Spawned: 2357 -- Connected from 91.185.208.25:58130
no structure found for zmmtastats at /opt/zimbra/libexec/zmrrdfetch line 239.
Tue Jun 1 10:36:25 2010: Spawned: 3047 -- Connected from 91.185.208.25:58152
no structure found for zmmtastats at /opt/zimbra/libexec/zmrrdfetch line 239.

zmloggerhostmap

Zimbra Logger Service Hostname Map

--------------------- ---------------------
DNS Hostname Zimbra Hostname
--------------------- ---------------------
tovarnaidej tovarnaidej

if i login to admin web, and want to see charts, i get this in zmlogswatch.out

Tue Jun 1 00:57:53 2010: Spawned: 12618 -- Connected from 91.185.208.25:35915
Tue Jun 1 00:57:53 2010: Spawned: 12619 -- Connected from 91.185.208.25:35916
Tue Jun 1 00:57:53 2010: Spawned: 12620 -- Connected from 91.185.208.25:35917
tovarnaidej.eu not found
tovarnaidej.eu not found
tovarnaidej.eu not found

so i manualy connecto to sqlite database and rename tovarnaidej to tovarnaidej.eu, but after zimbra restart it created another:

zmloggerhostmap

Zimbra Logger Service Hostname Map

--------------------- ---------------------
DNS Hostname Zimbra Hostname
--------------------- ---------------------
tovarnaidej tovarnaidej
tovarnaidej.eu tovarnaidej

so it must be some kind of configuration problem, but where to find this conf setting?

Kristijan