Results 1 to 9 of 9

Thread: New Install - empty mboxgroup1 database, can't open zimbraAdmin page

  1. #1
    Centurion's Avatar
    Centurion is offline Active Member
    Join Date
    Apr 2007
    Location
    NSW, Australia
    Posts
    38
    Rep Power
    7

    Default New Install - empty mboxgroup1 database, can't open zimbraAdmin page

    Sorry for the long title, but it's been a long day. I am trying to install the OSS version of Zimbra on a fresh CentOS-4.4 server to evaluate the suitability of Zimbra. The installer goes fine, with no obvious errors, however, after the installation is complete, the mboxgroup1 database is totally empty:

    Code:
    mysql> show databases;
    +--------------------+
    | Database           |
    +--------------------+
    | information_schema |
    | mboxgroup1         |
    | mysql              |
    | test               |
    | zimbra             |
    +--------------------+
    5 rows in set (0.00 sec)
    
    mysql> use mboxgroup1;
    Database changed
    mysql> show tables;
    Empty set (0.00 sec)
    This seems to be the root of the problem that is causing the zimbraAdmin page to fail to load. The login screen appears, I can enter the admin@our.domain user with correct password, but the login just hangs with "Loading...". If I enter the incorrect password, it returns with an "Authentication Failed" message. So it appears authentication is working.

    The the /opt/zimbra/log/mailbox.log reports:
    Code:
    2007-04-27 15:55:58,203 INFO  [http-7071-Processor49] [ua=ZimbraWebClient - FF2.0 (Linux)/undefined;ip=10.10.10.74;] cache - Initializing folder and tag caches for mailbox 1
    2007-04-27 15:55:58,205 WARN  [http-7071-Processor49] [ua=ZimbraWebClient - FF2.0 (Linux)/undefined;ip=10.10.10.74;] session - failed to create session
    com.zimbra.common.service.ServiceException: system failure: fetching folder data for mailbox 1
            at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:175)
    ...
    stacktrace continues
    ...
    
    Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'mboxgroup1.mail_item' doesn't exist
    
    Query being executed when exception was thrown:
    
    SELECT mi.id, mi.type, mi.parent_id, mi.folder_id, mi.index_id, mi.imap_id, mi.date, mi.size, mi.volume_id, mi.blob_digest, mi.unread, mi.flags, mi.tags, mi.subject, mi.name, mi.m
    etadata, mi.mod_metadata, mi.change_date, mi.mod_content FROM mboxgroup1.mail_item mi WHERE mailbox_id = 1 AND type IN (1,2,13,3)
    ...
    stack trace continues
    ...
    Any idea where things have gone awry? The server is a slightly "minimalistic" install (we build up as a rule, rather than installing everything and working backwards) although all the installation requirements as set out in the various installation guides have been met. Hardware is almost double the specifications set out for a single-server setup. I've doubled the innodb_buffer_pool to 1GB and removed all references to "UTF8" in /etc/sysconfig/i18n (both of which seem to have resolved this problem in other threads).

  2. #2
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    Try to uninstall, then do a clean install. If it goes wrong, post your log file so that we can see what it kicks out when it creates the table.

  3. #3
    Centurion's Avatar
    Centurion is offline Active Member
    Join Date
    Apr 2007
    Location
    NSW, Australia
    Posts
    38
    Rep Power
    7

    Default

    Thanks for your prompt reply - this bodes well for future commercial undertakings with Zimbra

    As requested, we carried out a full uninstall (including manually removing /opt/zimbra). Rebooted and restarted the installation. The install logs and some information about the system are included (see attached).

    Please note, our standard installation (kickstart) scripts create a 512MB /tmp partition which requires us to "fudge" the install; we simply unmounted the /tmp partition.This meant the /tmp directory became part of / (sda2) and thus had over 6GB for the install.After the installation we copied out the logs, rebooted and remounted /tmp.

    Also, I've added a "txt" extension to the logs to make sure they get around the limits for attachments.
    Attached Files Attached Files

  4. #4
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    Wow. You've got a lot of tmp errors in there. For example:
    * Loading schema /opt/zimbra/db/loggerdb.sql
    /opt/zimbra/libexec/zmloggerinit: line 79: /tmp/logger.sql.9612: No such file or directory
    /opt/zimbra/libexec/zmloggerinit: line 86: /tmp/logger.sql.9612: No such file or directory

    Can't import the sql file for the logger, cause it's not there.

    What ever the problem is, I'm willing to bet money it's because of your tmp setup. Is there any way you can allocate more space for that without "fudging" it?

    That's the problem.

  5. #5
    Centurion's Avatar
    Centurion is offline Active Member
    Join Date
    Apr 2007
    Location
    NSW, Australia
    Posts
    38
    Rep Power
    7

    Default

    Some more infomation - I've attached the mailbox.log which includes the first time the system was started (post-install and prior to reboot), followed by the logs after the reboot. The server was rebooted around 8:58am. There seems to be a LOT of database errors immediately after installation, which aren't present after the reboot. Did everything get initialised properly?

    The log also includes two login attempts as "admin@..." but each time creates a different error, although the second error is repeated on subsequent logins (so I didn't include those - the error is the same as my original post).

    So long story short - so far, same problem
    Attached Files Attached Files

  6. #6
    Centurion's Avatar
    Centurion is offline Active Member
    Join Date
    Apr 2007
    Location
    NSW, Australia
    Posts
    38
    Rep Power
    7

    Default

    As for allocating more space to /tmp....erm, not without a rebuild Our test machines don't have SAN storage and unless required don't use LVM etc. So dynamically adding space is out of the question. The server is only a test machine, and a rebuild doesn't take long, but it does require me to be in front of the box (no remote "lights-out" management on test boxes either).

    I can't see how a dedicated /tmp partition is any different to a shared partition (ie, part of "/"). But I'm willing to go down the rebuild road if it will rule out possible errors.

    For what it's worth, the installation is carried out in a root shell invoked with sudo: "sudo -H -s" - ie, load a root shell, and root's home environment. Should we be using "su -" or a direct root login?

    A rebuild will have to wait to Monday as I'm not going to work on the weekend for a test system I was hoping this was a remotely-fixable problem. C'est la vie.

  7. #7
    Klug's Avatar
    Klug is offline Moderator
    Join Date
    Mar 2006
    Location
    Beaucaire, France
    Posts
    2,292
    Rep Power
    13

    Default

    Quote Originally Posted by Centurion View Post
    I can't see how a dedicated /tmp partition is any different to a shared partition (ie, part of "/"). But I'm willing to go down the rebuild road if it will rule out possible errors.
    It's not different, as long as it's correctly "mounted".

    Just to be sure you /tmp is usable, maybe you should try to copy the ZCS install archive in it, untar the archive in it and launch it from there. This would help in checking /tmp is writable, has space in it, etc.

    Quote Originally Posted by Centurion View Post
    For what it's worth, the installation is carried out in a root shell invoked with sudo: "sudo -H -s" - ie, load a root shell, and root's home environment. Should we be using "su -" or a direct root login?
    I'm sure it works with "su -" or direct root login, maybe sudo is the problem (concerning /tmp access and writability).

    Quote Originally Posted by Centurion View Post
    I'm not going to work on the weekend for a test system
    You lazy

    Quote Originally Posted by Centurion View Post
    C'est la vie.
    Bah oui 8)

  8. #8
    dijichi2 is offline OpenSource Builder & Moderator
    Join Date
    Oct 2005
    Posts
    1,176
    Rep Power
    11

    Default

    You could try fudging from the other end, it works much better in my experience.

    Before you run the installer, edit util/utilfunc.sh, search for /tmp and change '-lt 1' to '-lt 0'. The disk space check is relatively new in the installer (checks /opt for 5gc free, I have to disable that too). /tmp varies from platform to platform, sometimes it's part of root partition, sometimes seperate disk mount, sometimes a pseudo function of VM.

  9. #9
    Centurion's Avatar
    Centurion is offline Active Member
    Join Date
    Apr 2007
    Location
    NSW, Australia
    Posts
    38
    Rep Power
    7

    Default Fixed :)

    Rebuilt the machine with a 1.5GB /tmp partition and carried out the installation using "su -". The install went through without a hitch and we are currently evaluating as I type.

    Thanks to all who assisted with this over the weekend.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 23
    Last Post: 01-24-2013, 03:44 PM
  2. Error message in Server status
    By Max Ma in forum Installation
    Replies: 20
    Last Post: 04-19-2007, 08:55 AM
  3. The mailbox and mta dies in FC4 GA version
    By meikka in forum Installation
    Replies: 72
    Last Post: 03-16-2006, 05:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •