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

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

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

WizNote is a Evernote alternative

Docker image of WizNote Server free

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 ...

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

@marcusquinn With these DNS records it should work without problem:

Hostname: xyz.example.com
Record type: MX
Expected value: 10 my.example.com.

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

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

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

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.

@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

@marcusquinn With these DNS records it should work without problem:

Hostname: xyz.example.com
Record type: MX
Expected value: 10 my.example.com.

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

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

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

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

Hi @fbartels,

Yes, it is actually a fairly frequent question that remains unsolved since Invoice Ninja version 4.X. They promised to fix this bug in version 5.X, but it still remains unsolved (https://forum.invoiceninja.com/t/invoice-rounding-amounts-not-limited-to-2-decimal-places/3978)

I have posted it here, in case someone in the community had the same thing and had found a way to solve it. Surely you have to touch some .php file that controls the rounding of taxes, but they are not accessible in the Cloudron package.

For example:

/tests/acceptance/TaxRatesCest.php

       $total = $itemCost;
       $total += round($itemCost * $invoiceTaxRate / 100, 2);

/app/Models/Invoice.php

       /**
            * @param $invoiceItem
            * @param $invoiceTotal
            *
            * @return float|int
            */
           public function getItemTaxable($invoiceItem, $invoiceTotal)
           {
               $total = $invoiceItem->qty * $invoiceItem->cost;
       
               if ($this->discount != 0) {
                   if ($this->is_amount_discount) {
                       if ($invoiceTotal + $this->discount != 0) {
                           $total -= $invoiceTotal ? ($total / ($invoiceTotal + $this->discount) * $this->discount) : 0;
                       }
                   } else {
                       $total *= (100 - $this->discount) / 100;
                   }
               }
       
               if ($invoiceItem->discount != 0) {
                   if ($this->is_amount_discount) {
                       $total -= $invoiceItem->discount;
                   } else {
                       $total -= $total * $invoiceItem->discount / 100;
                   }
               }
       
               return round($total, 2);
           }

If someone has found how to solve it ...