Graphs and Zimlets not displaying?

[nadia007]

I've installed the ubuntu version of Zimbra (dev team... thx) Everything installed wonderfully except for a couple of things. I can't seem to get the server statistics graphs to display. Seems that the image link are broken, it only displays the image missing icon where the graphs should be. Not sure what to do about that!

Second thing is I can't get the zimlets to work. I'd like to get the yahoo maps zimlets especially. I managed to list my zimlets and I get the following:

zimbra@mail:~/zimlets-extra$ zmzimletctl listZimlets
Installed Zimlet files on this host:
com_zimbra_date
com_zimbra_email
com_zimbra_phone
com_zimbra_photo
com_zimbra_url
com_zimbra_ymaps
Installed Zimlets in LDAP:
com_zimbra_date
com_zimbra_email
com_zimbra_phone
com_zimbra_photo
com_zimbra_url
com_zimbra_ymaps
Available Zimlets in COS:
default:
com_zimbra_date
com_zimbra_email
com_zimbra_phone
com_zimbra_photo
com_zimbra_url
com_zimbra_ymaps

But when I check my email that contain addresses the zimlet does not work like expected. Did I miss a step? Any suggestions would be appreciated!

[Klug]

Hello Nadia,

Originally Posted by nadia007

I'd like to get the yahoo maps zimlets especially.

It seems the YahooMap zimlet does not work outside of the USA (both because YahooMap is not available for each country and because the regexp is not able to catch out-USA addresses) : be sure to test it on an USA address.

[nadia007]

The addresses that I am using are all US addresses. Nevertheless the zimlet doesn't seem to be working!

[deltatau]

I experience the same problem, me too installing Zimbra 4.02 over Ubuntu Server 6:
the problem occurs also including images in documents, showing a broken link icon.
Is it missing any graphics library?
I use Firefox 1.5.0.7.
Best Regards
Danilo

[bobby]

check the logger db to see if the stats are being tracked

[nadia007]

bobby;

thx for the reply. Are you refering to the /var/log/zimbra.log? I don't see anything about statistics in there. Just the status of the zimbra services.

[deltatau]

Searching in logs I have found a couple of errors, about missing DBI and DBD::mysql, so I installed on Ubuntu server 6 the packages libdbi-perl and libdbd-mysql-perl and (after a reboot) the graphs for server statistics display, but disk quota shows no bars.

Regards
Danilo

[AranBenjO]

I'm not sure, but I think you need the files indicated in the tag include, for example ymaps.js, ymaps.css and so on ... if anybody solve the problem please post the solution ! 10x

[bobby]

nadia, the stats in the admin console come from data in the logger mysql db, which in turn is derived from the /var/log/zimbra.log. you can connect to the logger db and review some of the data like this:

su - zimbra
logmysql zimbra_logger
show tables;
select * from service_status;
select * from processing_history;
select * from mta_aggregate;
...

[jarbelix]

Originally Posted by bobby

nadia, the stats in the admin console come from data in the logger mysql db, which in turn is derived from the /var/log/zimbra.log. you can connect to the logger db and review some of the data like this:

su - zimbra
logmysql zimbra_logger
show tables;
select * from service_status;
select * from processing_history;
select * from mta_aggregate;
...

I have the same problem with graphics.

Se my tables:

mysql> show tables;
+-------------------------+
| Tables_in_zimbra_logger |
+-------------------------+
| amavis |
| amavis_aggregate |
| config |
| disk_aggregate |
| disk_status |
| mta |
| mta_aggregate |
| processing_history |
| raw_logs |
| service_status |
+-------------------------+
10 rows in set (0.00 sec)

mysql> select * from service_status;
+----------------+-----------+---------------------+--------+-------------+
| server | service | time | status | loghostname |
+----------------+-----------+---------------------+--------+-------------+
| ubuntu.prevnet | antispam | 2006-11-24 09:58:02 | 1 | ubuntu |
| ubuntu.prevnet | antivirus | 2006-11-24 09:58:02 | 1 | ubuntu |
| ubuntu.prevnet | ldap | 2006-11-24 09:58:02 | 1 | ubuntu |
| ubuntu.prevnet | logger | 2006-11-24 09:58:02 | 1 | ubuntu |
| ubuntu.prevnet | mailbox | 2006-11-24 09:58:02 | 1 | ubuntu |
| ubuntu.prevnet | mta | 2006-11-24 09:58:02 | 1 | ubuntu |
| ubuntu.prevnet | snmp | 2006-11-24 09:58:02 | 1 | ubuntu |
| ubuntu.prevnet | spell | 2006-11-24 09:58:02 | 1 | ubuntu |
+----------------+-----------+---------------------+--------+-------------+
8 rows in set (0.00 sec)

mysql> select * from processing_history;
+-----------+------+
| app | id |
+-----------+------+
| mta | 977 |
| clamd | 1856 |
| amavis | 1858 |
| zimbramon | 1860 |
+-----------+------+
4 rows in set (0.00 sec)

mysql> select * from mta_aggregate;
+---------------------+---------------------+----------------+--------+-----------+-----------+
| period_start | period_end | host | period | msg_count | msg_bytes |
+---------------------+---------------------+----------------+--------+-----------+-----------+
| 2006-11-24 01:00:00 | 2006-11-24 02:00:00 | ubuntu.prevnet | hour | 1 | 1310 |
| 2006-11-24 08:00:00 | 2006-11-24 09:00:00 | ubuntu.prevnet | hour | 2 | 4876 |
| 2006-11-24 09:00:00 | 2006-11-24 10:00:00 | ubuntu.prevnet | hour | 4 | 3862 |
+---------------------+---------------------+----------------+--------+-----------+-----------+
3 rows in set (0.00 sec)