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

Thread: zmsetup.pl on Mac OS X Unhappy

  1. #1
    segleaur is offline Active Member
    Join Date
    Sep 2005
    Location
    Somewhere south of the border at this point... nice and sunny
    Posts
    47
    Rep Power
    9

    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
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    Are you switching to bash root?

  3. #3
    segleaur is offline Active Member
    Join Date
    Sep 2005
    Location
    Somewhere south of the border at this point... nice and sunny
    Posts
    47
    Rep Power
    9

    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
    jholder's Avatar
    jholder is offline Former Zimbran
    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
    segleaur is offline Active Member
    Join Date
    Sep 2005
    Location
    Somewhere south of the border at this point... nice and sunny
    Posts
    47
    Rep Power
    9

    Default

    No joy, J. Same error sequence.
    cheers,

    rodolfo

  6. #6
    jholder's Avatar
    jholder is offline Former Zimbran
    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
    segleaur is offline Active Member
    Join Date
    Sep 2005
    Location
    Somewhere south of the border at this point... nice and sunny
    Posts
    47
    Rep Power
    9

    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
    jholder's Avatar
    jholder is offline Former Zimbran
    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
    segleaur is offline Active Member
    Join Date
    Sep 2005
    Location
    Somewhere south of the border at this point... nice and sunny
    Posts
    47
    Rep Power
    9

    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
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    Did you just tar up /opt/zimbra?

Page 1 of 3 123 LastLast

Thread Information

Users Browsing this Thread

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

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, 12:14 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
  •