NocoDB is an open source #NoCode platform that turns any database into a smart spreadsheet.

https://www.nocodb.com
https://github.com/nocodb/nocodb

WizNote is a Evernote alternative

Docker image of WizNote Server free

Community centric product feedback

Open-source ideation tool to close the feedback loop between your product and customers.

Youtube Video

https://clearflask.com/
https://github.com/clearflask/clearflask/blob/master/INSTALLATION.md

Hi guys,

The fastest way to migrate any WordPress installation to Cloudron is very simple:

1. Export the /wp-content/ folder on the origin server to a wp-content.zip file
2. Export the database on the source server to a .sql file. In phpmyadmin, select all the tables, and export to bbdd.sql
3. Create a clean install of WordPress on the target Cloudron
4. Once created, go to the file manager of the Cloudron WordPress installation and into the /public/ folder:

• upload the wp-content.zip file
• delete existing /wp-content/ folder
• unzip the file wp-content.zip
• change ownership to www-data from /wp-content/ folder which has been unzipped

5. Finally, upload the .sql file of the database from step 2 to the path /app/data/

After this, all that remains is to migrate the database. To do this, go to the application console in Cloudron. Once in it, you just have to type:

cd ..

cd data

wp db reset

wp db import bbdd.sql

With this, the migration is complete.

@timconsidine No, it is not a redundant step. Otherwise, Cloudron will not interpret the subdomain as something "different" from the main domain. Additionally, it is required for Cloudron to generate the credentials for the DKIM registry.

It is a step that I have skipped, because @marcusquinn was only asking for DNS records, but it is a necessary step.

I put a functional example to make it clearer: Installation of Mautic on the marketing.domain.es subdomain

First step: register the subdomain marketin.domain.es in Cloudron. In this case, the Manual configuration has been chosen due to organization restrictions when using Cloudflare.

This will generate, within the Cloudron Email configuration, the following records for the subdomain:

With the information from the Cloudron records, we must go to the DNS panel of our domain and configure the records as follows:

Hostname: marketing.domain.es
Record type: A
Expected value: XXX.XXX.XXX.XXX /* your IP server */

Hostname: marketing.domain.es
Record type: MX
Expected value: 10 my.example.com.

Hostname: cloudron-xxxxxx._domainkey.marketing
Record type: TXT
Expected value: v=DKIM1; t=s; p=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hostname: marketing.domain.es
Record type: TXT
Expected value: v=spf1 a:my.example.com ~all

Hostname: _dmarc.marketing
Record type: TXT
Expected value: v=DMARC1; p=reject; pct=100

Once the DNS records of the domain have been propagated, we can install the app within the Cloudron

Now, in the Email section of the app, we can configure the email address @marketing.domain.es for sending emails from the app

And in the Email section of the marketing.domain.es subdomain we can configure the email accounts we need:

In this case, the addresses:

• no-reply@marketing.domain.es
• bounces@marketing.domain.es

send and receive emails normally and Mautic works without problems in the marketing.domain.es subdomain

@atrilahiji Depending on the size of the backups to be stored in Wasabi, I would review in detail their 90 day minimum storage charge policy applies (https://wasabi-support.zendesk.com/hc/en-us/articles/115003947151-If-I-delete-a-file-within-90-days-after-storing-it-how-is-that-handled-from-a-billing-and-file-recovery-perspective-). Because this can make your monthly bill grow considerably.

For example, the last bill I paid from Wasabi was in July of last year, for an amount of $ 10 per month (for a bucket of about 100 Gb).

For that same bucket I am now paying in Scaleway (https://www.scaleway.com/en/object-storage/) about € 0.25 per month.

This invoice shows the consumption of a bucket of about 100Gb (the first 75Gb portion is free).

Simple No BS project management application with a minimalist UI.

• Simple and User friendly
• Support for multiple Orgs
• Role based access control

https://compito.adi.so/
https://github.com/adisreyaj/compito

@eddowding There are basically two steps:

1. Create the link with rClone with the Drive you want to synchronize the files
2. Mount that drive in a folder on your system so that Cloudron can view it. This is the step that you will surely miss. To do this you just have to run the following command:

rclone mount NAME-UNIT:/ /mnt/backups --allow-other --delete-before

After this step, if you do a ls on the folder //mnt/backups you should already see the files that are in the Drive unit, and therefore you can already link this folder from Cloudron to make the backups. The files in the //mnt/backups folder and the Drive are synced bi-directionally.

If I have a gap this week, I will prepare a small guide with all the steps, because now that I remember, it is necessary to create a small bash and put it in the crontab so that everything continues to work when the server restarts ...

Hi @d19dotca,

Yes, it is possible, and with n8n it is easy.

You just need to have SSH access to each website you want to manage to run the WP-CLI command you want. In Cloudron, since there is no external SSH access to the application, you have to identify the container ID that corresponds to the website, in order to run a docker exec.

docker exec CONTAINERID wp media regenerate --yes

In this example workflow from n8n you can see how you can do all the actions you want, executing them manually, through a cron or with the trigger you want.

You are right @girish. The screenshot of @eddowding is the volume interface.

The Configure Backup Storage looks like this:

Although this same procedure is also compatible with Volumes and can be used in applications such as Navidrome, etc.

root@xxxxxxxxx:~# rclone config
Current remotes:

Name                 Type
====                 ====
GDRIVE-MUSIC         drive

e) Edit existing remote
n) New remote
d) Delete remote
r) Rename remote
c) Copy remote
s) Set configuration password
q) Quit config
e/n/d/r/c/s/q>

!/bin/bash
/usr/bin/rclone mount GDRIVE-MUSIC:/ /mnt/media/music --allow-other

It will also have to be included in the guide...

PS: GDRIVE-MUSIC is a shared drive @robi

That was the piece of information I was missing. Now it works perfect.

How much time am I going to save updating WordPress Developer applications...

Thank you @girish

Thanks @girish, but there must be something I'm forgetting.

I have tried to push a pending update of the FreeScout application (to version 1.9.0), and I have tried to pass the appStoreId as you say and I get the same error.

Is there any other parameter to take into account?

Hi guys,

I am trying to launch an application update through the Cloudron API, and it returns the following error:

{
    "status": "Bad Request",
    "message": "appStoreId or manifest is required"
}

How should the appStoreId be defined to generate the update?

I have tried to launch individual backups of the application with the same API Token and it has worked without problems.

Hi @d19dotca,

Yes, it is possible, and with n8n it is easy.

You just need to have SSH access to each website you want to manage to run the WP-CLI command you want. In Cloudron, since there is no external SSH access to the application, you have to identify the container ID that corresponds to the website, in order to run a docker exec.

docker exec CONTAINERID wp media regenerate --yes

In this example workflow from n8n you can see how you can do all the actions you want, executing them manually, through a cron or with the trigger you want.

You are right @girish. The screenshot of @eddowding is the volume interface.

The Configure Backup Storage looks like this:

Although this same procedure is also compatible with Volumes and can be used in applications such as Navidrome, etc.

root@xxxxxxxxx:~# rclone config
Current remotes:

Name                 Type
====                 ====
GDRIVE-MUSIC         drive

e) Edit existing remote
n) New remote
d) Delete remote
r) Rename remote
c) Copy remote
s) Set configuration password
q) Quit config
e/n/d/r/c/s/q>

!/bin/bash
/usr/bin/rclone mount GDRIVE-MUSIC:/ /mnt/media/music --allow-other

It will also have to be included in the guide...

PS: GDRIVE-MUSIC is a shared drive @robi

@eddowding There are basically two steps:

1. Create the link with rClone with the Drive you want to synchronize the files
2. Mount that drive in a folder on your system so that Cloudron can view it. This is the step that you will surely miss. To do this you just have to run the following command:

rclone mount NAME-UNIT:/ /mnt/backups --allow-other --delete-before

After this step, if you do a ls on the folder //mnt/backups you should already see the files that are in the Drive unit, and therefore you can already link this folder from Cloudron to make the backups. The files in the //mnt/backups folder and the Drive are synced bi-directionally.

If I have a gap this week, I will prepare a small guide with all the steps, because now that I remember, it is necessary to create a small bash and put it in the crontab so that everything continues to work when the server restarts ...

@robi The screenshot of Drive that you see is a shared drive

@eddowding As @mdreira has already commented, you just have to mount the Google Drive you want to use in the system folder with rClone and the backup system will work without problems.

Community centric product feedback

Open-source ideation tool to close the feedback loop between your product and customers.

Youtube Video

https://clearflask.com/
https://github.com/clearflask/clearflask/blob/master/INSTALLATION.md

Hi @d19dotca ,

It is a common problem when the time zone is not configured correctly in WordPress.

You just have to adjust the time zone with the capital of your country, and WordPress will automatically adjust the web to match the local time.

With that, the WooCommerce coupon will expire on the date and time that you have defined as its limits.