Page 1 of 3 123 LastLast
Results 1 to 10 of 27

Thread: zmsetup.pl on Mac OS X Unhappy

  1. #1
    Join Date
    Sep 2005
    Location
    Somewhere south of the border at this point... nice and sunny
    Posts
    47
    Rep Power
    10

    Cool zmsetup.pl on Mac OS X Unhappy

    Hey guys, I've just gotten around to upgrading zimbra 4.0 to 4.5.4 for Mac OS X, due to a little too much work lately. Anyhow, the "easy install" went through without a problem, but when I run zmsetup.pl as root, of course, I zmsetup.pl spits out an error. It seems that this happens when the script tries to execute migrate20061101-IMFolder.pl. It tries to execute a SQL statement like:

    Code:
    INSERT INTO mboxgroup1.mail_item (
        mailbox_id, id, type, parent_id, folder_id, index_id, imap_id,
        date, size, volume_id, blob_digest,
        unread, flags, tags, sender,
        subject, metadata,
        mod_metadata, change_date, mod_content
    )
    SELECT
        id, 14, 1, 1, 1, null, null,
        1176313968, 0, null, null,
        0, 0, 0, null,
        'Chats', 'd1:ai1e4:unxti14e1:vi9e2:vti5ee',
        change_checkpoint, 1176313968, change_checkpoint
    FROM mailbox
    WHERE group_id = 1
    ON DUPLICATE KEY UPDATE subject = 'Chats';
    to which mySQL responds:

    Code:
    Cannot add or update a child row: a foreign key constraint fails (`mboxgroup1/mail_item`, CONSTRAINT `fk_mail_item_parent_id` FOREIGN KEY (`mailbox_id`, `parent_id`) REFERENCES `mail_item` (`mailbox_id`, `id`))
    And the script goes nuts, interpreting that error as a command:

    Code:
    sh: line 1: mboxgroup2/mail_item: No such file or directory
    sh: line 1: fk_mail_item_parent_id: command not found
    sh: line 1: mailbox_id: command not found
    sh: line 1: parent_id: command not found
    sh: line 1: mail_item: command not found
    sh: line 1: mailbox_id: command not found
    
    Died at /opt/zimbra/libexec/scripts/Migrate.pm line 365,  line 15.
    Script failed with code 2304:  - exiting
    UPGRADE FAILED - exiting
    Because, obviously, mboxgroup2/mail_item does not exist as a directory.

    So, my question is: is there a workaround for this or do I have to do a stepping upgrade from 4.0 to 4.5.x where x < 5?
    cheers,

    rodolfo

  2. #2
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    Are you switching to bash root?

  3. #3
    Join Date
    Sep 2005
    Location
    Somewhere south of the border at this point... nice and sunny
    Posts
    47
    Rep Power
    10

    Default

    Yup. Total sequence to log in to the term is:

    Code:
    x:~ admin$ su - root
    Password:
    x:~ root# cd /opt/zimbra
    If i need to be zimbra for a while, it's (as root)
    Code:
    x:/opt/zimbra root# su zimbra
    x:~ zimbra$
    Edit: By the way, I ran the zmsetup.pl again just to see what would happen, and the mboxgroup error is incremental, in the sense that the first time it ran, it was mboxgroup1, second run is mboxgroup2, and so forth. Didn't notice it the first time, sorry.
    Last edited by segleaur; 04-11-2007 at 12:02 PM. Reason: Updated Error Info
    cheers,

    rodolfo

  4. #4
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    Try sudo /bin/bash
    then /opt/zimbra/libexec
    ./zmsetup.pl

  5. #5
    Join Date
    Sep 2005
    Location
    Somewhere south of the border at this point... nice and sunny
    Posts
    47
    Rep Power
    10

    Default

    No joy, J. Same error sequence.
    cheers,

    rodolfo

  6. #6
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    My advice is to upgrade to the NE on the same version.
    Then run backup.
    And restore.

    jh
    Last edited by jholder; 04-11-2007 at 12:31 PM.

  7. #7
    Join Date
    Sep 2005
    Location
    Somewhere south of the border at this point... nice and sunny
    Posts
    47
    Rep Power
    10

    Default

    Any implications? 4.0 was OSS version, not NE. I'm guessing I could still run NE with it's functions disabled post trial-license? Or should I try upgrading from 4.0 to 4.5.1 and then to 4.5.4?
    cheers,

    rodolfo

  8. #8
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    Well, Brian is the expert on this, so I'm blowing hot air.
    I think there may be some db corruption, so if you can get your data out, and into a fresh install, that would be best.

    NE trial is a fully functional trial.

    john

  9. #9
    Join Date
    Sep 2005
    Location
    Somewhere south of the border at this point... nice and sunny
    Posts
    47
    Rep Power
    10

    Default

    OK, so I have these nice large tar files on drive (backup before upgrade) and several sitting around on DATs. Soooooo, if I were to do a fresh reinstall (i'm testing to see if a stepped upgrade works as we "speak"), what files do I have to worry about and how I do make sure the InnoDB files are intact? Note that the tar files are full backups of the entire environment offline - so I would have to recreate the 4.0 environ, dump, install 4.5.4 and import?
    cheers,

    rodolfo

  10. #10
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    Did you just tar up /opt/zimbra?

Similar Threads

  1. Zimbra with Open LDAP on MAC OS X
    By Andy in forum Installation
    Replies: 14
    Last Post: 09-17-2007, 09:25 PM
  2. Installed on Mac OS X client, host file question
    By McBurtnieks in forum Installation
    Replies: 1
    Last Post: 04-01-2007, 11:09 AM
  3. Mac OS X server setup
    By ericmiller74 in forum Installation
    Replies: 2
    Last Post: 10-16-2006, 11:29 AM
  4. Mac OS X + Zimbra + Apache 2
    By abetam in forum Installation
    Replies: 1
    Last Post: 10-06-2006, 10:16 PM
  5. Uninstall in Mac OS X?
    By avi4now in forum Installation
    Replies: 10
    Last Post: 01-09-2006, 11:14 AM

Posting Permissions

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