setting up Matomo

[JAC]

@phenomlab said in setting up Matomo:

@jac said in setting up Matomo:

I seem to remember having to lock the domain to public viewing when with Ionos?

That was only for the development environment to prevent it from duplicating content that already existed in production.

@jac said in setting up Matomo:

I think maybe something along the lines of stats.domain.com is suitable?

Yes, that’s fine. You just need to create an A record for that first, then you can create the virtual domain in Virtualmin

It was yes I remember now, fantastic Mark thank for the further instructions. I will do this later if I get on the laptop.

[JAC]

@jac just setting up now…

[JAC]

@jac said in setting up Matomo:

@jac just setting up now…

I’ve added the A record…

[phenomlab]

@jac I see it - you’ll need to create the new subdomain in your Virtualmin instance

[JAC]

@phenomlab logged in to Virtualmin now.

Just looking how to do this.

[JAC]

@jac looks tricky if you don’t know what you’re doing

[JAC]

@jac Create virtual server > sub server?

[JAC]

@jac I don’t want to post sensitive information but is this correct?

[phenomlab]

@jac Yep, that’s it.

[JAC]

@phenomlab thanks, now to proceed

[JAC]

@jac said in setting up Matomo:

@phenomlab thanks, now to proceed

rookie error

“Failed to create virtual server : A sub-server cannot have MySQL enabled unless the parent server does”

[phenomlab]

@jac Yes, that means that MySQL isn’t enabled at the root domain. You’ll need to go to the root domain, and enable that feature for it to work on subdomains.

The reason for it being missing is that you do not require MySQL for NodeBB as it uses MongoDB instead.

[JAC]

@phenomlab Thanks Mark,

I’ll go and locate this now.

[JAC]

@jac done

[phenomlab]

@jac Yes, this probably helps

[phenomlab]

@jac Now re-add the subdomain

[JAC]

@jac “Requesting a certificate for stats.stockportcounty.fans, www.stats.stockportcounty.fans from Let’s Encrypt …”

that will be interesting…

[phenomlab]

@jac Should be fine. It may bomb on the www request - let me know if that’s the case.

[JAC]

@phenomlab said in setting up Matomo:

@jac Should be fine. It may bomb on the www request - let me know if that’s the case.

Requesting a certificate for stats.stockportcounty.fans, www.stats.stockportcounty.fans from Let's Encrypt ..
.. request failed : Web-based validation failed :
 
Saving debug log to /var/log/letsencrypt/letsencrypt.log
Plugins selected: Authenticator webroot, Installer None
Obtaining a new certificate
Performing the following challenges:
http-01 challenge for stats.stockportcounty.fans
http-01 challenge for www.stats.stockportcounty.fans
Using the webroot path /home/stockportcounty/domains/stats.stockportcounty.fans/public_html for all unmatched domains.
Waiting for verification...
Challenge failed for domain www.stats.stockportcounty.fans
http-01 challenge for www.stats.stockportcounty.fans
Cleaning up challenges
Some challenges have failed.
IMPORTANT NOTES:
 - The following errors were reported by the server:
 
   Domain: www.stats.stockportcounty.fans
   Type:   dns
   Detail: DNS problem: NXDOMAIN looking up A for
   www.stats.stockportcounty.fans - check that a DNS record exists for
   this domain
 
   DNS-based validation failed :
 
Saving debug log to /var/log/letsencrypt/letsencrypt.log
Plugins selected: Authenticator manual, Installer None
Obtaining a new certificate
Performing the following challenges:
dns-01 challenge for www.stats.stockportcounty.fans
Running manual-auth-hook command: /etc/webmin/webmin/letsencrypt-dns.pl
Waiting for verification...
Challenge failed for domain www.stats.stockportcounty.fans
dns-01 challenge for www.stats.stockportcounty.fans
Cleaning up challenges
Running manual-cleanup-hook command: /etc/webmin/webmin/letsencrypt-cleanup.pl
Some challenges have failed.
IMPORTANT NOTES:
 - The following errors were reported by the server:
 
   Domain: www.stats.stockportcounty.fans
   Type:   dns
   Detail: DNS problem: NXDOMAIN looking up TXT for
   _acme-challenge.www.stats.stockportcounty.fans - check that a DNS
   record exists for this domain

[phenomlab]

@jac Unsurprising. There are two ways to do this

• Create a CNAME record called WWW and have it point to the subdomain in DNS
• Create a custom request for LE so that it ignores the www value, and only processes the actual domain you want

VirtualMin -> Server Configuration -> SSL Certificate

Let’s Encrypt

Set as per the example, so you only request the domain you want. Ensure that “Automatically renew certificate” is selected, then “Request Certificate”