How to set VirtualHost in Apache2 which will be used if there is no matching ServerName?

Question

Apache HTTP Server

Actually, subject. There is a task to deny access to the site by server IP, the solution of which I implemented through the 0000-direct.conf file with the following content:

<IfModule mod_ssl.c>
<VirtualHost *:443>
    ServerName IP_моего_сервера
    Redirect 403 /
    DocumentRoot /dev/null
</VirtualHost>
</IfModule>
<VirtualHost *:80>
    ServerName IP_моего_сервера
    Redirect 403 /
    DocumentRoot /dev/null
</VirtualHost>

I would like to expand the solution: if there is no VirtualHost with ServerName satisfying the request, then a 403 error would be thrown (as in the example above). How can this be implemented?

Answer 1

Usually, the config is written based on the following Apache behavior - if there are no hosts that satisfy the condition, then show the first available host.
Accordingly, the first thing in the config is to specify the host on which the stub will be.

Answer 2

From the set of rows of the first table, we subtract the set of rows of the second table and write the result into the third table. In MySQL this is done with a single INSERT ... SELECT SQL statement. But since SQL-command EXCEPT (set difference) is not implemented in MySQL, its emulation is used by the standard technique (described in any textbook) through LEFT JOIN and IS NULL:

INSERT INTO table3
SELECT table1.*
FROM table1
LEFT JOIN table2
  ON table1.id = table2.id
WHERE table2.id IS NULL