Mambo installation failure

[Dmitry Frantsev]

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.

 

[hazzah]

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

 

[Dmitry Frantsev]

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.

 

[halfelite]

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

 

[Dmitry Frantsev]

Try to run script with following way and give me output of this:

# sh -x mambo_fix.sh

 

[halfelite]

[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 ~]#

 

[Dmitry Frantsev]

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.

 

[andrewlopoztli]

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?

 

[Superman859]

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.

 

[Dmitry Frantsev]

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.

 

[Superman859]

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.

 

[Dmitry Frantsev]

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.

 

[Superman859]

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.

 

[arazas]

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 ~]#

 

[arazas]

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 ~]#

 

[Dmitry Frantsev]

Try to remove /usr/local/psa/var/cgitory/Mambo-4.5.3-21/apps/httpdocs-files.tar~ file and run script one more time.

 

[halfelite]

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

 

[WaDavid]

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.
......................

 

[kerpau]

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!