@why42 yes I think this would not be suiteable for LAMP. But having a custom app package for custom scripts is very much doable if you have used docker at some point. Otherwise we are happy to help.

Here is my workaround for the Drupal 9.1.4 installation on the Cloudron LAMP app (Paket v1.4.0-1).

Install the LAMP app on your Cloudron Update the app ressources to minimal 1.5 GB RAM open the terminal switch to the www-data user su www-data change directory to /app/data cd /app/data install drupal via composer composer create-project drupal/recommended-project move everything from inside recommended-project into the root of /app/data mv recommended-project/* . & mv recommended-project/.* . remove the default public folder and make a symbolic link rm -rf public& ln -s web public open your browser and install drupal the last submit ends with an error in the terminal install drush via composer composer require drush/drush clear the cache php vendor/bin/drush cr open your drupal installation again. #yippie

Maybe there is an unknown error in the drupal installation process or something between mysql/drupal/cloudron. No hints in the logfiles. But this workflow works for me.

@girish Thank you

@subven As per https://github.com/PHPMailer/PHPMailer/wiki/Troubleshooting#could-not-instantiate-mail-function, if we use isSMTP which the addon uses, it should use SMTP directly. I will maybe give it a shot later today to understand why it's not sending mail.

@nebulon I think for a start just making ssh based git push/pull work with hooks on the Github Pages and LAMP app is good enough. I think for rest of the "complicated" apps, we have to really make some container based PaaS, where we build the container as well (just like Heroku). That's a really long term feature.

@girish sorry for spamming this old thread. I added a complete new post: https://forum.cloudron.io/topic/4203/git-push-ci-cd-workflow-for-the-lamp-app

apt install -y cron apache2-dev php7.4 php7.4-{bcmath,bz2,cgi,cli,common,curl,dba,dev,enchant,fpm,gd,gmp,imap,interbase,intl,json,ldap,mbstring,mysql,odbc,opcache,pgsql,phpdbg,pspell,readline,soap,sqlite3,sybase,tidy,xml,xmlrpc,xsl,zip} libapache2-mod-php7.4 php-{apcu,date,geoip,gettext,imagick,gnupg,mailparse,pear,redis,twig,uuid,validate,zmq} ghostscript libgs-dev ffmpeg && \

is what we install. exiftool is there in the base image.

The latest LAMP app now has LDAP addon enabled. For existing installations, LDAP will still be off (sorry).

@girish Thank you girish

@girish said in PHP mailparse extension/modul:

@andirahmat OK, I learnt a bit more about this now.

PECL is PHP extensions written in C. PEAR is PHP extensions written in PHP.

Luckily, as you pointed out mailparse is already there in apt. So, I have pushed an update for the PHP 7.4 app to have mailparse in it. I also added it to the php-postgres repo.

Thank you! I'll try again.

@p44 The MySQL database in Cloudron is shared by all the apps. In MySQL 5.7.5+, they changed the behavior to have ONLY_FULL_GROUP_BY to be the default to be more compliant. Disabling this at the server level will cause issues for other apps.

The correct way to fix this is to have the app disable this mode at a session level. Like https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html . Essentially, the app has to call "SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));" after creating a connection.

So, I guess the answer is:

Either sendy has to provide a mechanism to do the above. Alternately, you cannot run sendy in Cloudron. You have to create a dedicated server for this and setup MySQL accordingly.

@girish Hmm indeed, that's bad... couldn't some kind of basic auth be used instead a bit like the Youtube-DL app ?

@girish you're a genius man! I think it should work, I'll try it and come back. Thanks!!

This is unlikely to be supported by a specific LAMP app. In such a case it is probably better to build a customized app package following the documentation at https://cloudron.io/documentation/custom-apps/tutorial/

Currently the Lamp app still does not have LDAP enabled for the same reasons about the username:password mentioned in the linked forum thread.

@girish & @jdelon02

I believe LAMP app supports cron, in that case use the following script to auto-pull from a git repo whenever an update is pushed to that repo:

Put in /app/data/updateGit

#!/bin/sh ## CD to the path where the app is installed. cd /app/data/public UPSTREAM=${1:-'@{u}'} LOCAL=$(git rev-parse @) REMOTE=$(git rev-parse "$UPSTREAM") BASE=$(git merge-base @ "$UPSTREAM") if [ $LOCAL = $REMOTE ]; then echo "Up-to-date" elif [ $LOCAL = $BASE ]; then echo "Need to pull" git pull elif [ $REMOTE = $BASE ]; then echo "Need to push? Some files changed / commited here, this should not have happened." else echo "Diverged?? Help!" fi

Then in /app/data/crontab:

*/5 * * * * bash /app/data/updateGit 2>&1 ## Or if you wanna avoid filling logs: */5 * * * * bash /app/data/updateGit 2>&1 > /dev/null

This will check if a pull is needed from a repo every 5 minutes. (Re: https://crontab.guru/every-5-minutes)

You can also modify the bash script to rebuild, npm install, composer install, etc when needed too.

@jeau It looks like I closed https://git.cloudron.io/cloudron/lamp-app/issues/14 by mistake and this went off our radar. I have reopened it.

@hdavy2002 Pushed an update to fix this now.

Okay, I understand. It's fine by me.

The separate admin panel's latest release just renders a blank page for me (locally and on LAMP) ¯_(ツ)_/¯