Change hostname and server statistics stopped

[rajeshkodali]

Hi,

I have used the wiki ZmSetServerName - Zimbra :: Wiki I have changed the hostname of the server and now I have a problem with server statistics. I have checked the forums and used the following commnads:

# logmysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1467
Server version: 5.0.51a-log Source distribution

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

mysql> use 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

Database changed
mysql> select distinct(host) from mta_aggregate;
+-------------------+
| host |
+-------------------+
| Old host name |
+-------------------+
1 row in set (0.00 sec)

If I change the entry in DB will it start working or is there any way that I should change the hostname to newer one?

[uxbod]

Has the logger process been restarted ?

su - zimbra
zmcontrol -v
zmcontrol status

[rajeshkodali]

zimbra@mymail:~$ zmcontrol -v


Release 5.0.7_GA_2444.DEBIAN4.0 DEBIAN4.0 FOSS edition

Host mymail.xxxxxxxx.com
antispam Running
antivirus Running
imapproxy Running
ldap Running
logger Running
mailbox Running
mta Running
snmp Running
spell Running
stats Running

[uxbod]

I presume you have updated /etc/hosts and rebooted your server ?

[premoddev]

Hi,

status showing the stat service is running, so what the problem you are experiencing?

Also can you please run the following command to check you have changed in all the files with new hostname.

$ grep old.host.name /opt/zimbra/conf/*

$ zmlocalconfig | grep old.host.name


if swatchrc is not updated your stat service will not work.

#!Premod

[rajeshkodali]

The issue is in server stats in Admin . Check the attached. I have checked all files in conf and zmlocalconfig but there is no old hostname

[uxbod]

What happens if you run /opt/zimbra/libexec/zmgengraphs manually ? As you have changed the hostname you may need to wait 24 hours for the graphs to update aswell.

[phoenix]

Originally Posted by rajeshkodali

The issue is in server stats in Admin . Check the attached. I have checked all files in conf and zmlocalconfig but there is no old hostname

As it's been more than 24hrs, how about some follow-up on whether this problem is resolved or not?

[rajeshkodali]

Hi,

The problem is not solved. I was bit busy with something else. Is there any thing that we need to do in db ?

[uxbod]

Did you try running zmgengraphs manually and if so what was the output ? Is the DB actually updating with new information ? Have you checked your logfiles aswell for any error messages ?