1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Mambo installation failure

Discussion in 'Plesk for Linux - 8.x and Older' started by Dmitry Frantsev, Apr 6, 2007.

  1. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    If you have problems with Mambo installation and similar to this error exists:
    ......................
    Warning: sappmng: /usr/local/psa/var/cgitory/Mambo-4.5.3-21/scripts/postinstall execution failed:
    install_prefix=mambo_hf
    ssl_target_directory=false
    dbname=mysql69d62b106cfe414a10447af662a
    dbuser=usrd99392d4567d
    dbpasswd=219144
    admin_login=admin
    admin_passwd=616847609789b5c3f4b97961acb2ebf9
    admin_email=admin@domain.tld
    site_name=mambo domain.tld
    theme=tdwsepiafixed
    ssl=http
    application_url=mambo_hf/administrator/
    vhost_path=/var/www/vhosts/domain.tld
    domain_name=domain.tld
    domain_display_name=domain.tldERROR 1071 (42000) at line 327: Specified key was too long; max key length is 1000 bytes
    unable to import sql data:

    /usr/bin/mysql --host="localhost" -u"usrd99392d4567d" -p"219144" "mysql69d62b106cfe414a10447af662a" </var/www/vhosts/domain.tld/httpdocs/mambo_hf/schema.sql.sql
    proc_close() failed: Empty error message from utility.
    ......................

    Then try to run script below:

    #!/bin/sh
    TMP_D=/tmp/mambo-fix
    PSA_D="`awk '/^PRODUCT_ROOT_D/{print $2}' /etc/psa/psa.conf`"
    MAMBO="$PSA_D/var/cgitory/Mambo-4.5.3-21/apps/httpdocs-files.tar"
    if [ -f "$MAMBO" -a ! -f "$MAMBO"~ ]
    then
    mv "$MAMBO" "$MAMBO"~
    mkdir -p "$TMP_D"
    tar -C "$TMP_D" -xf "$MAMBO"~
    sed -i -r 's~(UNIQUE KEY `.*section_value_value_aro`
    \(`section_value`)(,`value`)(\),)~\1(166)\2(166)\3~' "$TMP_D/schema.sql"
    tar -C "$TMP_D" -cf "$MAMBO" .
    rm -rf "$TMP_D"
    fi

    Save the script into, for example, mambo_fix.sh file. Give execution permission to it and run it.

    It should rebuild the package of the Mambo application so it could be installed (the script creates a backup copy of the source archive).

    The lenght of some fields for KEY statement was reduced (from 240 to 166) so the summary key length is less than 1000 bytes.

    As I know in next update for Mabo it will be corrected but as for now, try this solution if you meet similar problem. Hope it helps.
     
  2. hazzah

    hazzah Guest

    0
     
    Hi,

    Thanks for this, but I think the cutting and pasting (via html) has caused the script a few format problems. You can attach it as a txt file if you have a copy?

    regards, Pieter
    Budapest
     
  3. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    Unfortunately, as I know attachment doesn't work on this forum, so try to get necessary strings from my previous post. Issue can be caused by following string:

    sed -i -r 's~(UNIQUE KEY `.*section_value_value_aro`\(`section_value`)(,`value`)(\),)~\1(166)\2(166)\3~' "$TMP_D/schema.sql"

    Try to use this line in script as ONE line.
     
  4. halfelite

    halfelite Guest

    0
     
    I tried this fix and it did not work the script ran without error but mambo still gets key length error on install.
     
  5. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    Try to run script with following way and give me output of this:

    # sh -x mambo_fix.sh
     
  6. halfelite

    halfelite Guest

    0
     
    [root@www ~]# sh -x fix.sh
    + TMP_D=/tmp/mambo-fix
    ++ awk '/^PRODUCT_ROOT_D/{print $2}' /etc/psa/psa.conf
    + PSA_D=/usr/local/psa
    + MAMBO=/usr/local/psa/var/cgitory/Mambo-4.5.3-21/apps/httpdocs-files.tar
    + '[' -f /usr/local/psa/var/cgitory/Mambo-4.5.3-21/apps/httpdocs-files.tar -a '!' -f /usr/local/psa/var/cgitory/Mambo-4.5.3-21/apps/httpdocs-files.tar~ ']'
    [root@www ~]#
     
  7. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    Try to move /usr/local/psa/var/cgitory/Mambo-4.5.3-21/apps/httpdocs-files.tar~ file to some place and run the script one more time.
     
  8. andrewlopoztli

    andrewlopoztli Guest

    0
     
    I have same error

    I have same Mambo error, and follow procedure above but same error ocurrs.

    What can I do to solve this problem?
     
  9. Superman859

    Superman859 Guest

    0
     
    I'm also having the exact same problem.

    I've searched the web for a solution, but hardly anything comes up. This post was all I found.

    I tried it, and it still gives the same error.

    When I ran sh -x mambo_fix.sh, I had a lot more output than the post above. However, I'm not sure how to copy and paste from my terminal window - is it possible (I use Putty).

    But it still doesn't work - provides the same error every time.

    Has anyone found a solution to this? This is a big disappointment if I cannot get it to work.
     
  10. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    Guys, try to use following corrected script:

    #!/bin/sh
    TMP_D=/tmp/mambo-fix
    PSA_D="`awk '/^PRODUCT_ROOT_D/{print $2}' /etc/psa/psa.conf`"
    MAMBO="$PSA_D/var/cgitory/Mambo-4.5.3-21/apps/httpdocs-files.tar"
    if [ -f "$MAMBO" -a ! -f "$MAMBO"~ ]
    then
    mv "$MAMBO" "$MAMBO"~
    mkdir -p "$TMP_D"
    tar -C "$TMP_D" -xf "$MAMBO"~
    sed -i -r 's~(UNIQUE KEY `.*section_value_value_aro` *\(`section_value`)(,`value`)(\),)~\1(166)\2(166)\3~' "$TMP_D/schema.sql"
    tar -C "$TMP_D" -cf "$MAMBO" .
    rm -rf "$TMP_D"
    fi

    String which starts with 'sed' and ends with '$TMP_D/schema.sql"' should be one string in mambo_fix.sh file.

    Also make sure that saved file has correct UNIX format. If not, use 'dos2unix' utility which converts plain text files in DOS/MAC format to UNIX format.
    Let me know about the results.
     
  11. Superman859

    Superman859 Guest

    0
     
    Same results.

    I tried moving the tar~ file you mentioned earlier. After running the script immediately after that, it had some more output, although I didn't have it saved to a file (I really wish you could copy and paste from a terminal window - I dont know how anyways).

    However, when I tried to run the script again so I could save the new results and display them to you, it showed the original results (someone already posted them in a previous post). The tar~ file was back.

    Now, I'm not sure if it worked or not. I tried to install Mambo, and I didn't get the key too long error anymore. However, I got an error related to could not read configuration.php or something along those lines - I wish I saved that data as well.

    The Mambo folder that was created in httpdocs is empty - it used to have info in it but wouldn't let you log in to the admin panel. Now it's empty.
     
  12. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    If you didn't get the key too long error it seems fix worked, but in this case I can suggest you to remove Mambo installation from domain, make sure that Mambo folder also removed, reinstall Mambo package and try this operation with fix one more time. I hope it helps.
     
  13. Superman859

    Superman859 Guest

    0
     
    Alright - I just reinstalled it. The same thing happens. Here are the results.

    Also, the Mambo folder is empty every time. But it does seem like the key error no longer comes up. However, it may have created a new issue (although I'm not sure how - that or Mambo in the application vault just has a lot of problems)

    Warning: sappmng: /usr/local/psa/var/cgitory/Mambo-4.5.3-21/scripts/postinstall execution failed:
    install_prefix=Mambo
    ssl_target_directory=false
    dbname=mysqlea4f81c59b6d6853c0e39e362bf
    dbuser=usrbcfa366569f1
    dbpasswd=testtest
    admin_login=admin
    admin_passwd=05a671c66aefea124cc08b76ea6d30bb
    admin_email=test@example.com
    site_name=QM
    theme=waterandstone
    ssl=http
    application_url=Mambo/administrator/
    vhost_path=/var/www/vhosts/qualitymemberships.com
    domain_name=qualitymemberships.com
    domain_display_name=qualitymemberships.compostinstall: can't open file `/var/www/vhosts/qualitymemberships.com/httpdocs/Mambo/configuration.php` for reading
    couldn't change file /var/www/vhosts/qualitymemberships.com/httpdocs/Mambo/configuration.php
    proc_close() failed: Empty error message from utility.

    ------

    By the way, for anyone else who might try this: Here is how I got to this point (no key error).

    I used the last script file posted. I'm on Windows right now, so I saved it in notepad and uploaded it. I made sure that one portion he mentioned was on one line.

    I then had to move httpdoc-files.tar~ to another folder. Without moving it, it didn't seem to fix it. There were both httpdoc-files.tar and httpdoc-files.tar~ . I only moved httpdoc-files.tar~.

    Also, since I'm on Windows now and made the file on Windows, I usually run this command to get Windows edited scripts working for me.

    perl -i -pe's/\r$//;' mambo_fix.sh

    I ran sh -x mambo_fix.sh and some different output was on the screen. the tar~ file was back again - not sure why but it seems to be created if it's not already there.

    Tried to install Mambo at the point and got the results above.
     
  14. arazas

    arazas Guest

    0
     
    I tried and its worked on CENTSOS.

    [root@sml101 ~]# sh -x mambo_fix.sh
    + TMP_D=/tmp/mambo-fix
    ++ awk '/^PRODUCT_ROOT_D/{print $2}' /etc/psa/psa.conf
    + PSA_D=/usr/local/psa
    + MAMBO=/usr/local/psa/var/cgitory/Mambo-4.5.3-21/apps/httpdocs-files.tar
    + '[' -f /usr/local/psa/var/cgitory/Mambo-4.5.3-21/apps/httpdocs-files.tar -a '!' -f /usr/local/psa/var/cgitory/Mambo-4.5.3-21/apps/httpdocs-files.tar~ ']'
    + mv /usr/local/psa/var/cgitory/Mambo-4.5.3-21/apps/httpdocs-files.tar /usr/local/psa/var/cgitory/Mambo-4.5.3-21/apps/httpdocs-files.tar~
    + mkdir -p /tmp/mambo-fix
    + tar -C /tmp/mambo-fix -xf /usr/local/psa/var/cgitory/Mambo-4.5.3-21/apps/httpdocs-files.tar~
    + sed -i -r 's~(UNIQUE KEY `.*section_value_value_aro` *\(`section_value`)(,`value`)(\),)~\1(166)\2(166)\3~' /tmp/mambo-fix/schema.sql
    + tar -C /tmp/mambo-fix -cf /usr/local/psa/var/cgitory/Mambo-4.5.3-21/apps/httpdocs-files.tar .
    + rm -rf /tmp/mambo-fix
    [root@sml101 ~]#
     
  15. arazas

    arazas Guest

    0
     
    Oops!

    I tried on another server but fixed failed and still getting error:

    the result was as below:

    [root@cl-t058-280cl ~]# sh -x mambo_fix.sh
    + TMP_D=/tmp/mambo-fix
    ++ awk '/^PRODUCT_ROOT_D/{print $2}' /etc/psa/psa.conf
    + PSA_D=/usr/local/psa
    + MAMBO=/usr/local/psa/var/cgitory/Mambo-4.5.3-21/apps/httpdocs-files.tar
    + '[' -f /usr/local/psa/var/cgitory/Mambo-4.5.3-21/apps/httpdocs-files.tar -a '!' -f /usr/local/psa/var/cgitory/Mambo-4.5.3-21/apps/httpdocs-files.tar~ ']'
    [root@cl-t058-280cl ~]#
     
  16. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    Try to remove /usr/local/psa/var/cgitory/Mambo-4.5.3-21/apps/httpdocs-files.tar~ file and run script one more time.
     
  17. halfelite

    halfelite Guest

    0
     
    The new posted script finally worked on mine. All errors gone. Thanks you Dmitry Frantsev
     
  18. WaDavid

    WaDavid Guest

    0
     
    Thanks a lot this script worked for Mambo, but eGroupware has a similar problem.

    ......................
    Warning: sappmng: /usr/local/psa/var/cgitory/eGroupWare-1.0.0.009-39/scripts/postinstall execution failed:
    install_prefix=eGroupWare
    ssl_target_directory=false
    dbname=eshegroup
    dbuser=eshgrp222
    dbpasswd=12345
    admin_login=admin
    admin_passwd=827ccb0eea8a706c4c34a16891f84e7b
    setupadmin_login=admin
    setupadmin_passwd=e10adc3949ba59abbe56e057f20f883e
    headeradmin_login=admin
    headeradmin_passwd=fcea920f7412b5da7be0cf42b8c93759
    ssl=http
    application_url=eGroupWare
    vhost_path=/var/www/vhosts/eshara.za.net
    domain_name=eshara.za.net
    domain_display_name=eshara.za.netERROR 1071 (42000) at line 871: Specified key was too long; max key length is 1000 bytes
    unable to import sql data:

    /usr/bin/mysql --host="localhost" -u"eshgrp222" -p"12345" "eshegroup" </var/www/vhosts/eshara.za.net/httpdocs/eGroupWare/schema.sql.sql
    proc_close() failed: Empty error message from utility.
    ......................
     
  19. kerpau

    kerpau Guest

    0
     
    I wish I could remember the exact steps I took but I fixed this error by using (roughly) the following steps.

    Run the install
    Let it error out
    Locate the database that the install created
    Change the collation from the iso variant to a latin1 variant.
    Rerun the install and specify the same database
    Install finishes successfully

    It worked for me. Hope it helps!
     
Loading...