cPanel: Search the site

MozOut www.my.mozout.com › My MozOut › Knowledge Base Knowledge baseDatabases

Installing PostgreSQL on a VPS

On a VPS running Ubuntu 22.04 LTS, as root, you install PostgreSQL with apt install postgresql postgresql-contrib. The service starts by itself and, by default, listens only on the server…

MozOut www.my.mozout.com › My MozOut › Knowledge Base Knowledge baseAutomation & n8n

n8n Schedule Trigger or a cron job: which to use

Use the n8n scheduler (the Schedule Trigger node) when the job is about connecting applications and you want to see each run inside n8n. Use a cron job when the…

MozOut www.my.mozout.com › My MozOut › Knowledge Base Knowledge baseNode.js, Python & Docker

Django DisallowedHost, CSRF failed and missing static files: the fixes

You put Django online and three errors show up that nearly everyone meets: DisallowedHost, CSRF verification failed and the page with no styles (static files give a 404). They have…

MozOut www.my.mozout.com › My MozOut › Knowledge Base Knowledge baseAutomation & n8n

A scheduled report by e-mail: a script, a cron job and an SMTP account

To get a summary of the site in your e-mail every morning (the day’s orders, enquiries received, new sign-ups) you need three pieces: a PHP script that fetches the figures…

MozOut www.my.mozout.com › My MozOut › Knowledge Base Knowledge baseSecurity

Someone is sending e-mail in the name of your domain: what SPF, DKIM and DMARC do about it

The short answer: sending an e-mail that looks as if it comes from [email protected] is trivial: the sender address is written freely, like the return address on a letter. To…

MozOut www.my.mozout.com › My MozOut › Knowledge Base Knowledge baseDatabases

Reaching MySQL or PostgreSQL through an SSH tunnel, step by step

The database ports (3306 for MySQL, 5432 for PostgreSQL) are not open from outside. An SSH tunnel solves that: it opens a port on your computer that leads, inside SSH,…

MozOut www.my.mozout.com › My MozOut › Knowledge Base Knowledge baseSecurity

After a hack, which backup do you restore? Choosing a clean copy

The short answer: restore the last copy from before the infection, not the most recent one. If you restore yesterday’s copy and the site had been infected for a week,…

MozOut www.my.mozout.com › My MozOut › Knowledge Base Knowledge baseSEO & Marketing

301 redirects when you change a page or a domain

You changed a page’s address, deleted an article or switched domain. Anyone holding the old address (in a bookmark, a search result, a link on another site) now lands on…

MozOut www.my.mozout.com › My MozOut › Knowledge Base Knowledge baseComparisons and alternatives

InnoDB or MyISAM: which storage engine, and what to do with an old table

Use InnoDB. It is the default engine of the MariaDB that runs on our hosting, it copes better with failures and simultaneous writes, and it is what current applications expect.…

MozOut www.my.mozout.com › My MozOut › Knowledge Base Knowledge baseDatabases

Error 1045 Access denied for user: the causes, in order

Error 1045 means one thing: the connection reached the database, and the database refused the username and password pair. It is not a server that is down or a closed…