Bitnami docker container with SuiteCRM 7.10.7 (sugar 6.5.25) to 7.11.1 upgrade problems

todsagt · 18 February 2019 12:27

Hello I am administrating a SuiteCRM docker container for my company. We began using SuiteCRM very rechently. I have discoverd that upgrading the bitnami container does not update SuiteCRM and breaks the installation… Then I tried the suggested way via the upgrade-wizard, but I cant find any upgrade-zip that would not be rejected by the upgrade-wizard or would just break the installation comepletely (even after tweaking the php.ini as suggestet for upgrading fom sugar to suite). Is there an upgrade path I just dont see or found yet? Is anyone here also using the bitnami-container, if yes, do you ever pull a new image? I would appreciate any help.

todsagt

pgr · 18 February 2019 17:08

i suggest just using plain-ubuntu without any Bitnami, it’s not necessary and complicates stack upgrades.

Any way the upgrades through upgrade wizard should work. If you want to troubleshoot that particular issue please give me more information and I’m sure we can get it to work.

Make sure you check your logs for errors, and also upgradeWizard.log.

todsagt · 19 February 2019 07:29

Thanks for the tipp, I will think about it.

Here is my version-info:

[spoiler][quote]root@7845b94c6946:/# cat bitnami/suitecrm/config.php | grep version
‘version’ => ‘5.3.3’,
‘js_custom_version’ => 1,
‘js_lang_version’ => 1,
‘securitysuite_version’ => ‘6.5.17’,
‘sugar_version’ => ‘6.5.25’,
‘suitecrm_version’ => ‘7.10.7’,[/quote][/spoiler]

And here are the logs:

upgradWizard.log
[spoiler][quote]Wed, 13 Feb 2019 15:24:22 +0000 [UpgradeWizard] - setting session variables…
Wed, 13 Feb 2019 15:24:22 +0000 [UpgradeWizard] - -----------------------------------------------------------------------------
Wed, 13 Feb 2019 15:24:22 +0000 [UpgradeWizard] - Upgrade started. At start.php
Wed, 13 Feb 2019 15:24:22 +0000 [UpgradeWizard] - at unlinkUWTempFiles()
Wed, 13 Feb 2019 15:24:22 +0000 [UpgradeWizard] - finished!
Wed, 13 Feb 2019 15:24:22 +0000 [UpgradeWizard] - resetting $_SESSION
Wed, 13 Feb 2019 15:25:06 +0000 [UpgradeWizard] - setting session variables…
Wed, 13 Feb 2019 15:25:06 +0000 [UpgradeWizard] - [At systemCheck.php]
Wed, 13 Feb 2019 15:25:06 +0000 [UpgradeWizard] - Starting file permission check…
Wed, 13 Feb 2019 15:25:39 +0000 [UpgradeWizard] - Finished file permission check.
Wed, 13 Feb 2019 15:25:39 +0000 [UpgradeWizard] - Starting database permissions check…
Wed, 13 Feb 2019 15:25:39 +0000 [UpgradeWizard] - Checking CREATE TABLE permissions…
Wed, 13 Feb 2019 15:25:39 +0000 [UpgradeWizard] - Checking INSERT INTO permissions…
Wed, 13 Feb 2019 15:25:39 +0000 [UpgradeWizard] - Checking UPDATE TABLE permissions…
Wed, 13 Feb 2019 15:25:39 +0000 [UpgradeWizard] - Checking SELECT permissions…
Wed, 13 Feb 2019 15:25:39 +0000 [UpgradeWizard] - Checking DELETE FROM permissions…
Wed, 13 Feb 2019 15:25:39 +0000 [UpgradeWizard] - Checking ALTER TABLE ADD COLUMN permissions…
Wed, 13 Feb 2019 15:25:39 +0000 [UpgradeWizard] - Checking ALTER TABLE CHANGE COLUMN permissions…
Wed, 13 Feb 2019 15:25:39 +0000 [UpgradeWizard] - Checking ALTER TABLE DROP COLUMN permissions…
Wed, 13 Feb 2019 15:25:39 +0000 [UpgradeWizard] - Checking DROP TABLE permissions…
Wed, 13 Feb 2019 15:25:39 +0000 [UpgradeWizard] - No permissions errors found!
Wed, 13 Feb 2019 15:25:39 +0000 [UpgradeWizard] - Finished database permissions check.
Wed, 13 Feb 2019 15:25:43 +0000 [UpgradeWizard] - setting session variables…
Wed, 13 Feb 2019 15:25:43 +0000 [UpgradeWizard] - At upload.php
Wed, 13 Feb 2019 15:25:43 +0000 [UpgradeWizard] - finding new files for upgrade
Wed, 13 Feb 2019 15:25:43 +0000 [UpgradeWizard] - *** UW using [ ] as source for patch files.
Wed, 13 Feb 2019 15:26:20 +0000 [UpgradeWizard] - setting session variables…
Wed, 13 Feb 2019 15:26:20 +0000 [UpgradeWizard] - At upload.php
Wed, 13 Feb 2019 15:26:20 +0000 [UpgradeWizard] - running upload
Wed, 13 Feb 2019 15:26:20 +0000 [UpgradeWizard] - File uploaded to upload://SugarCE Migration 6.5.x to SuiteCRM 7.1.4.zip
Wed, 13 Feb 2019 15:26:20 +0000 [UpgradeWizard] - extracting manifest.
Wed, 13 Feb 2019 15:26:20 +0000 [UpgradeWizard] - validating manifest.php file
Wed, 13 Feb 2019 15:26:20 +0000 [UpgradeWizard] - finding new files for upgrade
Wed, 13 Feb 2019 15:26:20 +0000 [UpgradeWizard] - *** UW using [ ] as source for patch files.
Wed, 13 Feb 2019 15:27:02 +0000 [UpgradeWizard] - setting session variables…
Wed, 13 Feb 2019 15:27:02 +0000 [UpgradeWizard] - At upload.php
Wed, 13 Feb 2019 15:27:02 +0000 [UpgradeWizard] - running upload
Wed, 13 Feb 2019 15:27:02 +0000 [UpgradeWizard] - File uploaded to upload://SugarCE Migration 6.5.x to SuiteCRM 7.1.5.zip
Wed, 13 Feb 2019 15:27:02 +0000 [UpgradeWizard] - extracting manifest.
Wed, 13 Feb 2019 15:27:02 +0000 [UpgradeWizard] - validating manifest.php file
Wed, 13 Feb 2019 15:27:02 +0000 [UpgradeWizard] - finding new files for upgrade
Wed, 13 Feb 2019 15:27:02 +0000 [UpgradeWizard] - *** UW using [ ] as source for patch files.
Wed, 13 Feb 2019 15:28:00 +0000 [UpgradeWizard] - setting session variables…
Wed, 13 Feb 2019 15:28:00 +0000 [UpgradeWizard] - At upload.php
Wed, 13 Feb 2019 15:28:00 +0000 [UpgradeWizard] - running upload
Wed, 13 Feb 2019 15:28:00 +0000 [UpgradeWizard] - File uploaded to upload://SugarCE Migration 6.5.x to SuiteCRM 7.1.6.zip
Wed, 13 Feb 2019 15:28:00 +0000 [UpgradeWizard] - extracting manifest.
Wed, 13 Feb 2019 15:28:00 +0000 [UpgradeWizard] - validating manifest.php file
Wed, 13 Feb 2019 15:28:00 +0000 [UpgradeWizard] - finding new files for upgrade
Wed, 13 Feb 2019 15:28:00 +0000 [UpgradeWizard] - *** UW using [ ] as source for patch files.
Wed, 13 Feb 2019 15:29:17 +0000 [UpgradeWizard] - setting session variables…
Wed, 13 Feb 2019 15:29:17 +0000 [UpgradeWizard] - At upload.php
Wed, 13 Feb 2019 15:29:17 +0000 [UpgradeWizard] - running upload
Wed, 13 Feb 2019 15:29:17 +0000 [UpgradeWizard] - File uploaded to upload://suitecrm-Upgrade-6.5.x-to-7.0.1.zip
Wed, 13 Feb 2019 15:29:17 +0000 [UpgradeWizard] - extracting manifest.
Wed, 13 Feb 2019 15:29:17 +0000 [UpgradeWizard] - validating manifest.php file
Wed, 13 Feb 2019 15:29:17 +0000 [UpgradeWizard] - finding new files for upgrade
Wed, 13 Feb 2019 15:29:17 +0000 [UpgradeWizard] - *** UW using [ ] as source for patch files.
Wed, 13 Feb 2019 15:30:02 +0000 [UpgradeWizard] - setting session variables…
Wed, 13 Feb 2019 15:30:02 +0000 [UpgradeWizard] - At upload.php
Wed, 13 Feb 2019 15:30:02 +0000 [UpgradeWizard] - running upload
Wed, 13 Feb 2019 15:30:02 +0000 [UpgradeWizard] - File uploaded to upload://suitecrm-Upgrade-6.5.x-to-7.0.2.zip
Wed, 13 Feb 2019 15:30:02 +0000 [UpgradeWizard] - extracting manifest.
Wed, 13 Feb 2019 15:30:03 +0000 [UpgradeWizard] - validating manifest.php file
Wed, 13 Feb 2019 15:30:03 +0000 [UpgradeWizard] - finding new files for upgrade
Wed, 13 Feb 2019 15:30:03 +0000 [UpgradeWizard] - *** UW using [ ] as source for patch files.
Wed, 13 Feb 2019 15:38:42 +0000 [UpgradeWizard] - File uploaded to upload://SuiteCRM-Upgrade-7.10.x-to-7.11.1.zip
Wed, 13 Feb 2019 15:38:42 +0000 [UpgradeWizard] - extracting manifest.
Wed, 13 Feb 2019 15:38:43 +0000 [UpgradeWizard] - validating manifest.php file
Wed, 13 Feb 2019 15:38:43 +0000 [UpgradeWizard] - finding new files for upgrade
Wed, 13 Feb 2019 15:38:43 +0000 [UpgradeWizard] - *** UW using [ ] as source for patch files.
Wed, 13 Feb 2019 15:40:45 +0000 [UpgradeWizard] - setting session variables…
Wed, 13 Feb 2019 15:40:45 +0000 [UpgradeWizard] - At upload.php
Wed, 13 Feb 2019 15:40:45 +0000 [UpgradeWizard] - running upload
Wed, 13 Feb 2019 15:40:45 +0000 [UpgradeWizard] - File uploaded to upload://SuiteCRM-Upgrade-7.10.x-to-7.11.0.zip
Wed, 13 Feb 2019 15:40:45 +0000 [UpgradeWizard] - extracting manifest.
Wed, 13 Feb 2019 15:40:46 +0000 [UpgradeWizard] - validating manifest.php file
Wed, 13 Feb 2019 15:40:46 +0000 [UpgradeWizard] - finding new files for upgrade
Wed, 13 Feb 2019 15:40:46 +0000 [UpgradeWizard] - *** UW using [ ] as source for patch files.
Wed, 13 Feb 2019 15:51:17 +0000 [UpgradeWizard] - setting session variables…
Wed, 13 Feb 2019 15:51:17 +0000 [UpgradeWizard] - At upload.php
Wed, 13 Feb 2019 15:51:17 +0000 [UpgradeWizard] - running upload
Wed, 13 Feb 2019 15:51:17 +0000 [UpgradeWizard] - File uploaded to upload://SuiteCRM-Upgrade-7.10-to-7.10.8.zip
Wed, 13 Feb 2019 15:51:17 +0000 [UpgradeWizard] - extracting manifest.
Wed, 13 Feb 2019 15:51:18 +0000 [UpgradeWizard] - validating manifest.php file
Wed, 13 Feb 2019 15:51:18 +0000 [UpgradeWizard] - finding new files for upgrade
Wed, 13 Feb 2019 15:51:18 +0000 [UpgradeWizard] - *** UW using [ ] as source for patch files.[/quote][/spoiler]
As you can see, I tried a few zip files, but they were rejected by suitecrm every time.

The only entry for that day in suitecrm.log:
[spoiler]

[/spoiler]

I am not sure if I have to enable the php.log since there is an “.tpl” at the end?

pgr · 19 February 2019 11:42

Yes you should check your PHP error log, location is defined in your php.ini.

You must be hitting some resource limit in php.ini that is keeping the upgrade pack from loading, namely one or more of these:

max_execution_time
memory_limit (512MB recommended)
max_post_size
max_upload_size (large enough for the upgrade zip)

todsagt · 19 February 2019 14:10

With php error_log enabled this is my output on the suitecrm upgradeWizard site:

[spoiler][quote]Warning: include(suitecrm_version.php): failed to open stream: No such file or directory in /bitnami/suitecrm/modules/UpgradeWizard/uw_utils.php on line 2114

Warning: include(): Failed opening ‘suitecrm_version.php’ for inclusion (include_path=’/bitnami/suitecrm:/bitnami/suitecrm/include/…:.:/opt/bitnami/php/lib/php’) in /bitnami/suitecrm/modules/UpgradeWizard/uw_utils.php on line 2114

Notice: Undefined variable: suitecrm_version in /bitnami/suitecrm/modules/UpgradeWizard/uw_utils.php on line 2193

Notice: Undefined variable: suitecrm_version in /bitnami/suitecrm/modules/UpgradeWizard/uw_utils.php on line 2201

Notice: Undefined variable: suitecrm_version in /bitnami/suitecrm/modules/UpgradeWizard/uw_utils.php on line 2209[/quote][/spoiler]

And:

[quote]The uploaded file is not compatible with this version of SuiteCRM:
SuiteCRM System Version: [/quote]

Note that the version number is absent, which corresponds to the warnings/notices.
I checked the installation, and there is a suitecrm_version.php:
[spoiler][quote]root@7845b94c6946:/# find . | grep suitecrm_version.php
./opt/bitnami/suitecrm/suitecrm_version.php[/quote][/spoiler]

The corresponding upgradeWizard.log:

[spoiler]

[/spoiler]

The suitecrm.log has no corresponding entries.

Next I will try the same upgrade.zip with changed values for:

max_execution_time
memory_limit (512MB recommended)
max_post_size
max_upload_size (large enough for the upgrade zip)

Any tipps on the values?

Thanks so far!

todsagt · 19 February 2019 14:26

I have just made an symlink

and now I can proceed with the upgrade process, I will inform you if it succeeds.

Thanks!

todsagt · 19 February 2019 15:17

The site timed out between the steps, but observing the upgradeWizard.log:

I was able to see that the upgrade was still ongoning. I was just about to give up all hope, because there seemed to bo no progress anymore (about 10min) the log showed some life and the side answered. Upgrade seems to be a success.

Thanks again! Any idea why the suitecrm_version.php wasnt in the correct directory/the upgradeWizard.php wasnt able to find suitecrm_version.php?

pgr · 19 February 2019 18:40

The correct directory for suitecrm_version.php is at the root of your installation.

I wonder if your web server could be having trouble reading it, due to permissions problems?

todsagt · 20 February 2019 08:09

Doesnt seem like its permissions related, everyone may execute

[quote]root@7845b94c6946:/# ls -la /opt/bitnami/suitecrm/suitecrm_version.php
-rwxr-xr-x 1 root root 170 Jul 9 2018 /opt/bitnami/suitecrm/suitecrm_version.php[/quote]

So the root of the Installation (since it comes preinstalled on the container) would be /bitnami/suitecrm/? With this upgrade process the bitnami-container doesnt make much sense, how do you set up your plain ubuntu? Just the ubuntu container and then install suitecrm into it with the root of the installation in a volume?

pgr · 20 February 2019 10:57

Installing in Ubuntu is quite easy, see this tutorial here

https://suitecrm.com/suitecrm/forum/installation-upgrade-help/11561-installing-on-ubuntu-16-04-1#45976

You need to adapt that for Docker - I am not too familiar with Docker, so I can’t give you precise instructions…

todsagt · 21 February 2019 06:35

So Ive just migrated our current suitecrm to a selfmade php7-apache container, works great so far. The bitnami container had the additional problem, that imap connection cant be ssl encrypted - at least for us.

Thank you very much for the support! If anyone is interested in the Dockerfile as an alternative to bitnami just ask.