Cloudron Forum

martinkbs

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

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

martinkbs

WizNote is a Evernote alternative

Docker image of WizNote Server free

WizNote Getting a Tidy Style by Markdown.md.png

martinkbs

Hi guys,

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

Export the /wp-content/ folder on the origin server to a wp-content.zip file
Export the database on the source server to a .sql file. In phpmyadmin, select all the tables, and export to bbdd.sql
Create a clean install of WordPress on the target Cloudron
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

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.

martinkbs

@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:

Captura de pantalla 2021-09-18 a las 10.16.07.png

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

Captura de pantalla 2021-09-18 a las 10.29.39.png

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

Captura de pantalla 2021-09-18 a las 10.31.40.png

In this case, the addresses:

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

Captura de pantalla 2021-09-18 a las 10.41.03.png

Captura de pantalla 2021-09-18 a las 10.45.04.png

martinkbs

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

Captura de pantalla 2021-06-16 a las 9.52.39.png

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

Captura de pantalla 2021-06-16 a las 9.48.46.png

martinkbs

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

martinkbs

@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

martinkbs

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

martinkbs

@girish Thanks!

martinkbs

You just have to use the command in the server terminal to identify the host IP.

docker inspect mysql | grep IPAddress

With this and with the credentials of the application database, you can connect Redash.

martinkbs

@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:

Captura de pantalla 2021-09-18 a las 10.16.07.png

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

Captura de pantalla 2021-09-18 a las 10.29.39.png

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

Captura de pantalla 2021-09-18 a las 10.31.40.png

In this case, the addresses:

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

Captura de pantalla 2021-09-18 a las 10.41.03.png

Captura de pantalla 2021-09-18 a las 10.45.04.png

martinkbs

@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

martinkbs

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

martinkbs

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

martinkbs

Hi guys,

I think Invoice Ninja is having trouble rounding VAT amounts.

Suppose I want to sell a product for 10€ VAT included (21%)

Invoice Ninja only allows the following combinations:

8,26 + 1,73 = 9,99€
8,27 + 1,74 = 10,01€

This happens in both exclusive and inclusive tax methods.

In another accounting SAAS, the invoice is as follows:

Subtotal: 8,26€
VAT: 1,74€
Total: 10,00€

But right now, in Invoice Ninja there is no way to put a total of 10€ that contains 21% VAT.

Is there any way to solve it?

Thanks!

martinkbs

Thanks @girish

Checked. After starting the terminal, inserting the commandsource /root/.bashrc, WP-cli works normally.

Connecting...
If you resize the browser window, press Ctrl+D to start a new session with the current size.
root@2d2d8096-2889-44f0-b36b-0aed411943c6:/app/code# source /root/.bashrc
root@2d2d8096-2889-44f0-b36b-0aed411943c6:/app/code# wp core version
5.8
root@2d2d8096-2889-44f0-b36b-0aed411943c6:/app/code#

At least, even temporarily, it solves the problem and lets you use the terminal.

If you need help, please let me know to make checks.

Thanks again!

martinkbs

Hi @girish

WP-cli commands, up to version 6.3.X update have always worked the same way. In fact, I have several Cloudrons in version 6.2.8, in which the 'wp plugin list' command works as WP-cli has to.

According to your explanation, it means that from now on, in version 6.3.X you have to put the command as you mentioned?

sudo -E -u www-data php /app/pkg/wp --path=/app/data/public/ plugin list

Or is it going to restore the original format that was used until now? As you will see, it is not a very productive way to work with the terminal.

martinkbs

@girish

With /app/pkg/wp plugin list

Imagen PNG 5.png

With cd /app/pkg, then ./wp plugin list

Imagen PNG 6.png

The installation is always WordPress (Developer)

martinkbs

@girish

Reconnecting...
If you resize the browser window, press Ctrl+D to start a new session with the current size.
root@2d2d8096-2889-44f0-b36b-0aed411943c6:/app/code# cd /app/pkg/wp
bash: cd: /app/pkg/wp: Not a directory
root@2d2d8096-2889-44f0-b36b-0aed411943c6:/app/code# cd /app/pkg/  
root@2d2d8096-2889-44f0-b36b-0aed411943c6:/app/pkg# ls         
authLdap.zip  credentials.template  cron.sh  mpm_prefork.conf  smtp-mailer.zip  start.sh  wp  wp-convert-multisite  wp-redis-cache.zip
root@2d2d8096-2889-44f0-b36b-0aed411943c6:/app/pkg# wp plugin list
bash: wp: command not found
root@2d2d8096-2889-44f0-b36b-0aed411943c6:/app/pkg#

martinkbs

wp-cli not working on 6.3.5?

Hi guys,

After updating two Cloudrons I find the same problem in the WordPress (managed) installations.

Connecting...
If you resize the browser window, press Ctrl+D to start a new session with the current size.
root@2d2d8096-2889-44f0-b36b-0aed411943c6:/app/code# wp plugin list
bash: wp: command not found
root@2d2d8096-2889-44f0-b36b-0aed411943c6:/app/code#

Anyone has encountered the same error?

Thanks!

Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.

martinkbs

@martinkbs

Best posts made by martinkbs

Latest posts made by martinkbs