Mailbox and logger not starting - SLES9 M3 Beta436

[marcmac]

Probably should blow away whatever half-created db is there.

rm -rf /opt/zimbra/db/data/* (retaining the directrory)
then run the sql init step

[DanielP]

Sorry, seems to be same story.

zimbra@mail:~> rm -rf db/data/*
zimbra@mail:~> /opt/zimbra/libexec/zmmyinit
* Creating required directories
* Generating mysql config /opt/zimbra/conf/my.cnf
* Creating database in /opt/zimbra/db/data
* Starting mysql server
* Loading schema /opt/zimbra/db/db.sql
ERROR 2013 (HY000): Lost connection to MySQL server during query
* Loading version from /opt/zimbra/db/versions-init.sql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)
* Setting random passwd for mysql root user in zimbra localconfig
* Setting random passwd for mysql zimbra user in zimbra localconfig
* Changing mysql root user password
/opt/zimbra/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/opt/zimbra/db/mysql.sock' exists!
* Changing mysql zimbra user password
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)
**** PASSWORD CHANGE FAILED

I also looked around a bit, and it seems like the vars that should? be set in mysql.server (such as zmsetvars mysql_directory mysql_pidfile mysql_mycnf
) does not seem to be set.

cd /opt/zimbra/bin and running source `dirname $0`/zmshutil || exit 1
echo $mysql_directory shows nothing.
(is it supposed to?)

could it be any prerequsite before installing that is wrong, causing this? Is there anything changed that needs additional libraries not specified in the quickstart.(as said before, this machine ran and older beta just fine)

/Daniel

[marcmac]

anything in /opt/zimbra/log/mysqld.log?

[DanielP]

060112 20:46:33 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
060112 20:46:33 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
060112 20:46:33 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 100 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100
060112 20:46:36 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 100 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100
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
060112 20:46:39 InnoDB: Started; log sequence number 0 0
060112 20:46:39 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
060112 20:46:39 mysqld ended

[marcmac]

What kind of hardware are you on? How much ram, how much disk?
ls -ld /opt/zimbra /opt/zimbra/db /opt/zimbra/db/data

[DanielP]

ls -ld /opt/zimbra /opt/zimbra/db /opt/zimbra/db/data
drwxr-xr-x 35 root root 1464 Jan 12 19:19 /opt/zimbra
drwxr-xr-x 3 zimbra zimbra 272 Jan 12 20:46 /opt/zimbra/db
drwxr-xr-x 4 zimbra zimbra 248 Jan 12 20:46 /opt/zimbra/db/data

The hardware is:

Dual Athlon MP 2000+
cat /proc/cpuinfo |grep MHz
cpu MHz : 1659.282
cpu MHz : 1659.282

1GB RAM
/opt is 30GB (800MB used)
/ is 10GB

cat /etc/SuSE-release
SUSE LINUX Enterprise Server 9 (i586)
VERSION = 9
PATCHLEVEL = 3


/Daniel

[marcmac]

Anything in /var/log/messages?

Is this server completely up to date?

[DanielP]

/var/log/messages

Lots of this:

Jan 12 21:50:01 mail /USR/SBIN/CRON[14421]: (zimbra) CMD (/opt/zimbra/bin/zmqueuelog)
Jan 12 21:50:01 mail /USR/SBIN/CRON[14422]: (zimbra) CMD (/opt/zimbra/bin/zmlogprocess > /tmp/logprocess.out 2>&1)
Jan 12 21:50:01 mail /USR/SBIN/CRON[14425]: (zimbra) CMD (/opt/zimbra/bin/zmstatuslog)
Jan 12 21:50:01 mail /USR/SBIN/CRON[14424]: (zimbra) CMD (/opt/zimbra/bin/zmdisklog)
Jan 12 21:50:02 mail zimbramon[14421]: 14421:info: 2006-01-12 21:50:02, QUEUE: 0 0
Jan 12 21:50:04 mail zimbramon[14425]: 14425:info: 2006-01-12 21:50:02, STATUS: mail.intern.x.se: antispam: Running
Jan 12 21:50:04 mail zimbramon[14425]: 14425:info: 2006-01-12 21:50:02, STATUS: mail.intern.x.se: antivirus: Running
Jan 12 21:50:04 mail zimbramon[14425]: 14425:info: 2006-01-12 21:50:02, STATUS: mail.intern.x.se: ldap: Running
Jan 12 21:50:04 mail zimbramon[14425]: 14425:info: 2006-01-12 21:50:02, STATUS: mail.intern.x.se: logger: Stopped
Jan 12 21:50:04 mail zimbramon[14425]: 14425:info: 2006-01-12 21:50:02, STATUS: mail.intern.x.se: mailbox: Stopped
Jan 12 21:50:04 mail zimbramon[14425]: 14425:info: 2006-01-12 21:50:02, STATUS: mail.intern.x.se: mta: Running
Jan 12 21:50:04 mail zimbramon[14425]: 14425:info: 2006-01-12 21:50:02, STATUS: mail.intern.x.se: spell: Running

yes, this machine is online updated this morning, so it should be ok.

However, i just found this:
mail: /etc/init.d/fetchmail restart
/etc/fetchmailrc not existing

Any ideas, im getting out of them

/daniel

[marcmac]

Ok, remove the db (rm db/data/*) and re-run the init this way:
bash -x /opt/zimbra/libexec/zmmyinit

Send me the output.

Also - SELinux isn't enabled on this box, is it?

[DanielP]

SE-linux is not enabled.

I have sent the output.

/D