@levisadm the database is already added. If you go to the app's Web Terminal , if you run env | grep CLOUDRON_MYSQL_ you will get the values to use in your app. It's actually better if you just use the env variables directly in your app like getenv('CLOUDRON_MYSQL_USERNAME') etc

@girish said in Installing Attendize on LAMP - Need help:

@micmc said in Installing Attendize on LAMP - Need help:

You cannot install composer nor run docker in a LAMP under Cloudron.

You are correct about docker but composer is actually already installed. In fact, you can also use a new composer since composer itself is just php, so you can download it in any directory and run it.

Yep, thanks for the reminder. I think I've mixed composer with compose here loll Cheers!

@loudlemur said in Owncast in LAMP failed:

Shall I create an AppWish?

No, upvote the existing one as per the OP

https://forum.cloudron.io/post/22108

@girish Useful info mate! 🙂

Good work 😉 @humptydumpty

@jodumont said in what if I need 2 databases ?:

BTW: I found a typo: CLUODRON_MYSQL_DATABASE_PREFIX

thanks for reporting! I've fixed it now in the docs.

@ghodgeon said in LAMP PHP Set to 8.0. Doesn't update:

COMPOSER_MEMORY_LIMIT=-1 composer create-project pimcore/demo my-project

Can you try:

COMPOSER_MEMORY_LIMIT=-1 php8.0 /usr/bin/composer create-project pimcore/demo my-project

@freetommy mm, I assumed what you tried didn't work. It works for me.

I put the below in /app/data/.htaccess (placing this in /app/data/apache/app.conf inside VirtualHost also works:

SetEnvIf Authorization "(.*)" HTTP_AUTHORIZATION=$1

Restart the app. Then, I see the header passed on to PHP:

[HTTP_AUTHORIZATION] => Bearer YWxhZGRpbjpvcGVuc2VzYW1l

For future reference, this also worked (in apache config):

RewriteEngine On RewriteCond %{HTTP:Authorization} ^(.*) RewriteRule .* - [e=HTTP_AUTHORIZATION:%1]

@girish Thank you!

@shai Glad to hear it, I was going to give it a try this weekend, so this saves me a bit of time. Congrats.

@shai

What is the latest on deploying Drupal using Cloudron everybody?

@nebulon I also think plain database apps would be the way to go here. Patching the app code is complicated in this particular case, so for now I I will just go with an external database.

@jagan thanks for sharing the solution!

@girish the local_infile is the approach the app uses to load data sets for optional functionality. I'll go to the forum for OpenEMR and see if there is a way for me to manually upload the data instead of being done through the webapp UI.

@girish Thank you!

I was able to send mails with PHPMailer.

<?php use PHPMailer\PHPMailer\PHPMailer; use PHPMailer\PHPMailer\Exception; require 'vendor/autoload.php'; $sender = getenv('CLOUDRON_MAIL_FROM'); $senderName = 'LAMP Test Email'; $recipient = 'test@cloudron.io'; $usernameSmtp = getenv('CLOUDRON_MAIL_SMTP_USERNAME'); $passwordSmtp = getenv('CLOUDRON_MAIL_SMTP_PASSWORD'); $host = getenv('CLOUDRON_MAIL_SMTP_SERVER'); $port = (int) getenv('CLOUDRON_MAIL_SMTP_PORT'); $subject = 'Cloudron test (SMTP interface accessed using PHP)'; $bodyText = "Email Test\r\nThis email was sent through the Cloudron SMTP interface using the PHPMailer class."; $bodyHtml = '<h1>Email Test</h1>'; $mail = new PHPMailer(true); try { $mail->isSMTP(); $mail->setFrom($sender, $senderName); $mail->Username = $usernameSmtp; $mail->Password = $passwordSmtp; $mail->Host = $host; $mail->Port = $port; $mail->SMTPAuth = true; $mail->addAddress($recipient); $mail->isHTML(true); $mail->Subject = $subject; $mail->Body = $bodyHtml; $mail->AltBody = $bodyText; $mail->Send(); echo "Email sent!" , PHP_EOL; } catch (phpmailerException $e) { echo "An error occurred. {$e->errorMessage()}", PHP_EOL; //Catch errors from PHPMailer. } catch (Exception $e) { echo "Email not sent. {$mail->ErrorInfo}", PHP_EOL; } ?>

(Adapted from https://docs.aws.amazon.com/ses/latest/DeveloperGuide/send-using-smtp-php.html )

@thenils I have pushed a new package, can you please check? It should have composer 2.1.8

@argovaerts @darkben The latest package supports PHP 8. See https://docs.cloudron.io/apps/lamp/#supported-php-versions on how to switch.

@softdoctor hi there, not sure how this is related to Cloudron. On Cloudron apps are installed in their own containers, did you try to use the lamp app for this?