Latest Comments

In response to: Apache

Comment from:

Update April 2022

After trying unsuccessfully to install an email server some months later the syetm started playing up once a new Encrypt certificate was requested.

In trying to restablish via Certbot I started loosing connections.

Failing to remedy the problems and they worsend I reinstalled the OS and started from scratch. I had to do this twice.

Today I rewired the power supply, and I had notice the server getting hot.

Current status is that Apache2 and php7.4 are working.

18/04/22 @ 09:17 pm

In response to: Postfix Config

Comment from:

Insert a new user into the database

First, we need to add our first domain name into the domains table

INSERT INTO mailserver . virtual_domains (name) VALUES ('rogerlovejoy.uk');

Second, we need to create the user. Replace mysupersecretpassword with your password.

INSERT INTO mailserver.virtual_users (`domain_id`, `password` , `email`)
VALUES ('1', ENCRYPT('mysupersecretpassword', CONCAT('$6$', SUBSTRING(SHA(RAND()), -16))), '######@rogerlovejoy.uk');

Third, we can optionally specify an alias (secondary email address) for the user. INSERT INTO `mailserver`.`virtual_aliases`
(`domain_id`, `source`, `destination`)
VALUES
('1', 'firstname.lastname@mydomain.com', 'myuser@mydomain.com');

Type exit once you are done to leave the context of MariaDB.

20/08/21 @ 05:46 pm

In response to: Postfix Config

Comment from:

Create a table for each of the domain names to be used for email addresses.

CREATE TABLE `mailserver`.`virtual_domains` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



Create a table that will hold each of the users that will need mailboxes.

CREATE TABLE `mailserver`.`virtual_users` (
`id` int(11) NOT NULL auto_increment,
`domain_id` int(11) NOT NULL,
`password` varchar(106) NOT NULL,
`email` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `email` (`email`),
FOREIGN KEY (domain_id) REFERENCES virtual_domains(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



Create a table that will hold aliases (additional email addresses) for a particular user.

CREATE TABLE `mailserver`.`virtual_aliases` (
`id` int(11) NOT NULL auto_increment,
`domain_id` int(11) NOT NULL,
`source` varchar(100) NOT NULL,
`destination` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
FOREIGN KEY (domain_id) REFERENCES virtual_domains(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

20/08/21 @ 05:22 pm

In response to: ELF Trust

Comment from:

Fatal error: Uncaught Error: Call to undefined function xml_parser_create() in /var/www/elf/inc/xhtml_validator/_xhtml_validator.class.php:145 Stack trace: #0 /var/www/elf/inc/_core/_param.funcs.php(2622): XHTML_Validator->__construct(’posting’, true, false, false, false, ‘UTF-8′) #1 /var/www/elf/inc/_core/_param.funcs.php(2344): check_html_sanity(’test content’, ‘posting’, Object(User), ‘utf-8′) #2 /var/www/elf/inc/items/model/_item.class.php(1164): param_check_html(’content’, ‘Invalid content…’) #3 /var/www/elf/inc/items/items.ctrl.php(1754): Item->load_from_Request(false, true) #4 /var/www/elf/evoadm.php(224): require(’/var/www/elf/in…’) #5 {main} thrown in /var/www/elf/inc/xhtml_validator/_xhtml_validator.class.php on line 145

14/08/21 @ 10:19 pm

In response to: PHP

Comment from:

id=’".$cat_id."‘

id=something
but as the something is not plain characters it has to go in single quotes
id=’something’
as the something is a variable is has to be converted to simple characters which it can do

1. Assume $cat_id is text
2. but as it isn’t directly it has to go inside a concatenation of [text . variable .text]
hence the use of the double quotes to allow the concatenation to explode
3. We get ” the value of the variable”

08/08/21 @ 09:29 pm

In response to: Public Access

Comment from:

RE: lovejoy.org.uk

Although the DNS on Fasthosts was directed to the ElfServer early on 13th July there has been no proper update.

Just after 12pm (11GMT) I edited the website to show the DNS, which had changed.

At 12:30 the site at Krystal is no longer visible but the one on Elf is not.

13:50 Called Fasthosts and they have the new site, so it’s some UK propagation that is slow
14:00 Called Zen who passed the buck to Nominet, not sure about their involvement.
14:15 Called Nominet 01865332211 who affirmed they do not deal with DNS
20:00 After more calls no resolve via the FritzBox. Using the Plusnet ADSL and BT Hub3 there is no problem ??

July 14th
01:32 Still no joy
09:00 OK Both rogerlovejoy.uk and lovejoy.org.uk resolve to the ElfServer via browse on Raspberry and Fairphone and traceroute works fine.
10:54 Change DNS for rogerlovejoy.co.uk to ZenBox too.

July 16th
08:00 lovejoy.org.uk, rogerlovejoy.uk and rogerlovejoy.co.uk resolve to ElfServer

It has taken 48hrs on average for the names to resolve ??

13/07/21 @ 12:40 pm