Custom Lamp App Cloudron Build Error

[Shai]

@girish @murgero,

The problem was the GPG key for yarn.

By adding the following on line 5 of Dockerfile the problem was fixed:

RUN curl -sS https://dl.yarnpkg.com/debian/pubkey.gpg | apt-key add -

That line did generate the following warning; you tell me if it is of concern:

Warning: apt-key output should not be parsed (stdout is not a terminal)

I've successfully installed the app on my Cloudron. Now I'm configuring the two dbs.

[nebulon]

@shai ah we had this in the past indeed. One reason to update your custom package to the new base image v3:

FROM cloudron/base:3.0.0@sha256:455c70428723e3a823198c57472785437eb6eab082e79b3ff04ea584faf46e92

[Shai]

@nebulon Great. Thanks. That info should be put into Multiple Databases with Lamp instructions.

[nebulon]

@shai looks like we have to update the mentioned app to base image 3 as well as php7.4 not sure what a good strategy here is, to better update those template apps. @girish do you have any other idea, besides just forking those git repos?

[girish]

@nebulon I created a new repo with latest base image at https://git.cloudron.io/cloudron/lamp7.4-multidb-app

[arshsahzad]

@girish I have installed lamp7.4-multiDB-app in my cloudron server. When I'm trying to connect MySQL database using web terminal & Windows WSL Ubuntu 20.04. I'm getting an error in lamp7.4-multiDB-app.

#Web Terminal Error:
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2026 (HY000): SSL connection error: unknown error number

#WSL Ubuntu 20.04 Error:
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

[girish]

@arshsahzad Did you create the database after installing the app? You can create databases with a prefix of CLOUDRON_MYSQL_DATABASE_PREFIX . The "MySQL" button on top of the web terminal won't work immediately you have to replace the database name with the database you created previously. The MySQL button only works for single database apps. For multiple database apps, it doesn't know the name of the database.

[arshsahzad]

@girish said in Custom Lamp App Cloudron Build Error:

@arshsahzad Did you create the database after installing the app? You can create databases with a prefix of CLOUDRON_MYSQL_DATABASE_PREFIX . The "MySQL" button on top of the web terminal won't work immediately you have to replace the database name with the database you created previously. The MySQL button only works for single database apps. For multiple database apps, it doesn't know the name of the database.

I installed the LAMP MultiDB using WSL Ubuntu 20.04 to my cloudron server after login.

cloudron install --appstore-id lamp.cloudronapp

then cloudron exec --app test.example.com, but when I'm trying

mysql --user=${CLOUDRON_MYSQL_USERNAME} --password=${CLOUDRON_MYSQL_PASSWORD} --host=${CLOUDRON_MYSQL_HOST}

I'm getting the above-mentioned error, I don't know what to do next, I didn't created any database after installation because I'm not able to access the default created DB.

[girish]

@arshsahzad said in Custom Lamp App Cloudron Build Error:

cloudron install --appstore-id lamp.cloudronapp

This seems incorrect. You have to cloudron build and then cloudron install. With --appstore-id you are trying to install an app from the Cloudron App Store and it's not installing the Lamp 7.4 MultiDB app you just built.

I tried this now and this works for me:

root@26925401-6b67-4c07-b4f8-81f4402572ed:/app/data# env | grep PREFIX
CLOUDRON_MYSQL_DATABASE_PREFIX=f6433359711935b8_
root@26925401-6b67-4c07-b4f8-81f4402572ed:/app/data# mysql --user=${CLOUDRON_MYSQL_USERNAME} --password=${CLOUDRON_MYSQL_PASSWORD} --host=${CLOUDRON_MYSQL_HOST}
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 18989
Server version: 8.0.23-0ubuntu0.20.04.1 (Ubuntu)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE DATABASE f6433359711935b8_MyNewDatabase;
Query OK, 1 row affected (0.01 sec)

mysql> 

As seen above, I create arbitrary database with the prefix.

[arshsahzad]

@girish Now It's working, thanks for your help