mailbox services stopped after hostname change and reboot

[Dimitri]

I have no idea what happend but in mysql_error log i get lots of errors like this:

090113 11:06:03  mysqld started
InnoDB: Error: log file ./ib_logfile1 is of different size 0 0 bytes
InnoDB: than specified in the .cnf file 0 104857600 bytes!
090113 11:06:03 [Note] /opt/zimbra/mysql/libexec/mysqld: ready for connections.
Version: '5.0.51a-log'  socket: '/opt/zimbra/db/mysql.sock'  port: 7306  Source distribution
090113 11:06:04 [ERROR] /opt/zimbra/mysql/libexec/mysqld: Incorrect information in file: './mboxgroup1/appointment.frm'
090113 11:06:04 [ERROR] /opt/zimbra/mysql/libexec/mysqld: Incorrect information in file: './mboxgroup1/appointment.frm'
090113 11:06:04 [ERROR] /opt/zimbra/mysql/libexec/mysqld: Incorrect information in file: './mboxgroup1/imap_folder.frm'
090113 11:06:04 [ERROR] /opt/zimbra/mysql/libexec/mysqld: Incorrect information in file: './mboxgroup1/imap_folder.frm'
090113 11:06:04 [ERROR] /opt/zimbra/mysql/libexec/mysqld: Incorrect information in file: './mboxgroup1/imap_message.frm'
090113 11:06:04 [ERROR] /opt/zimbra/mysql/libexec/mysqld: Incorrect information in file: './mboxgroup1/imap_message.frm'
090113 11:06:04 [ERROR] /opt/zimbra/mysql/libexec/mysqld: Incorrect information in file: './mboxgroup1/mail_item.frm'
090113 11:06:04 [ERROR] /opt/zimbra/mysql/libexec/mysqld: Incorrect information in file: './mboxgroup1/mail_item.frm'
090113 11:06:04 [ERROR] /opt/zimbra/mysql/libexec/mysqld: Incorrect information in file: './mboxgroup1/open_conversation.frm'
090113 11:06:04 [ERROR] /opt/zimbra/mysql/libexec/mysqld: Incorrect information in file: './mboxgroup1/open_conversation.frm'
090113 11:06:04 [ERROR] /opt/zimbra/mysql/libexec/mysqld: Incorrect information in file: './mboxgroup1/pop3_message.frm'
090113 11:06:04 [ERROR] /opt/zimbra/mysql/libexec/mysqld: Incorrect information in file: './mboxgroup1/pop3_message.frm'
090113 11:06:04 [ERROR] /opt/zimbra/mysql/libexec/mysqld: Incorrect information in file: './mboxgroup1/revision.frm'
090113 11:06:04 [ERROR] /opt/zimbra/mysql/libexec/mysqld: Incorrect information in file: './mboxgroup1/revision.frm'
090113 11:06:04 [ERROR] /opt/zimbra/mysql/libexec/mysqld: Incorrect information in file: './mboxgroup1/tombstone.frm'
090113 11:06:04 [ERROR] /opt/zimbra/mysql/libexec/mysqld: Incorrect information in file: './mboxgroup1/tombstone.frm'
090113 11:06:04 [ERROR] /opt/zimbra/mysql/libexec/mysqld: Incorrect information in file: './mboxgroup10/appointment.frm'
090113 11:06:04 [ERROR] /opt/zimbra/mysql/libexec/mysqld: Incorrect information in file: './mboxgroup10/appointment.frm'
090113 11:06:04 [ERROR] /opt/zimbra/mysql/libexec/mysqld: Incorrect information in file: './mboxgroup10/imap_folder.frm'
090113 11:06:04 [ERROR] /opt/zimbra/mysql/libexec/mysqld: Incorrect information in file: './mboxgroup10/imap_folder.frm'
090113 11:06:04 [ERROR] /opt/zimbra/mysql/libexec/mysqld: Incorrect information in file: './mboxgroup10/imap_message.frm'
090113 11:06:04 [ERROR] /opt/zimbra/mysql/libexec/mysqld: Incorrect information in file: './mboxgroup10/imap_message.frm'

lots more that what I posted here
is there a way to fix the database?
I have no options anymore.

I tryed upgrading that failed and now when I want to rerun setup i get this:

root@zimbra /opt/zimbra/libexec # ./zmsetup.pl
Operations logged to /tmp/zmsetup.01132009-114715.log
Starting ldap...done.
Setting defaults...done.
Upgrading from 5.0.8_GA_2462 to 5.0.11_GA_2695
Stopping zimbra services
Verifying /opt/zimbra/conf/my.cnf
Starting mysql
ERROR 1033 (HY000) at line 1: Incorrect information in file: './zimbra/config.frm'
Tue Jan 13 11:47:59 2009: Error while running '/opt/zimbra/bin/mysql --user=zimbra --password=_Zgek_uOh_XNup7U6pJ7oFZHb3dEQxyz --database=zimbra --batch --skip-column-names'.

[uxbod]

I posted the link in one of my previous threads but here it is again Mysql Crash Recovery - Zimbra :: Wiki

[Dimitri]

Originally Posted by uxbod

I posted the link in one of my previous threads but here it is again Mysql Crash Recovery - Zimbra :: Wiki

yes I have seen that but I have no logfile described in the post.

I think i want to reinstall the whole lot, I am reading this:
Important': The ZCS version you install on the new server must be the same version' as installed on the old server. The server can have a different operating system.

does that mean that I need to use the same release? i mean if i would go and install/upgrade to ubuntu 8 than how can the version of zimbra be the same?

Dimitri

[uxbod]

You may have no logfile but from the error message produced it looks like your MySQL instance is corrupt.

[Dimitri]

ok I tryed the mysql restore stuff but also lots of errors:

root@zimbra ~ # /opt/zimbra/mysql/bin/mysql -NB -e "show databases" | grep mbox > /tmp/mysql.db.list
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

and this one also:

zimbra@zimbra:~/mysql$ /opt/zimbra/mysql/bin/mysqldump zimbra -S /opt/zimbra/db/mysql.sock -u root --password=''HYzKBaeKBfKWgnugNcY4KkPlDKDNyXyz'' > /tmp/mysql.sql/zimbra.sql
mysqldump: Got error: 1033: Incorrect information in file: './zimbra/config.frm' when using LOCK TABLES

I think that this instalation is doomed

[uxbod]

Did you do the

mysql.server start

as per the wiki ?

[Dimitri]

Originally Posted by uxbod

Did you do the

mysql.server start

as per the wiki ?

Yes I did do this

would be so much easyer if i knew more about zimbra engine or if somone would login that know how to fix this.

if I can not get this to run today I will reinstall I think, its a shame because I now do not know what caused this all

[Bill Brock]

I may be mistaken but from your post in response to your dig command it appears that your FQDN of your server and your primary domain are the same name.

[Dimitri]

Originally Posted by Bill Brock

I may be mistaken but from your post in response to your dig command it appears that your FQDN of your server and your primary domain are the same name.

What do you mean by that?
I do not realy understand this

I have a domain calles 1-vision that is running on a server somwhere
in dns I added zimbra.1-vision.nl as an a record that points to my network at work (zimbra is on on a server in that network using split dns)

so I think that the hostname of that server needed to be zimbra.1-vision.nl.
or is that not the way to do this?

Dimitri

[Bill Brock]

Yes your theory is correct. I seem to get a different response when I dig using any on my system. I double check my results.