Search found 203 matches

by chris
Fri Sep 02, 2022 11:11 am
Forum: Servers
Topic: What are some good hosting providers?
Replies: 1
Views: 70158

Re: What are some good hosting providers?

I personaly like versio.nl.
It is a provider based in the Netherlands (Europe).
Good and fast service.


For more info about what types of hosting there are:
https://www.webmaster2020.com/hosting/
by chris
Sat Aug 20, 2022 4:12 pm
Forum: SQL
Topic: Average of day over several years
Replies: 1
Views: 9866

Re: Average of day over several years

Nice project, may I suggest alo add the max and minimum.

The folowing code should be a good start:

Code: Select all

SELECT MONTH(datum),DAY(datum),min(temperature),max(temperature),avg(temperature) FROM temperature GROUP BY MONTH(datum),DAY(datum)
by chris
Sat Aug 06, 2022 11:19 am
Forum: Shell
Topic: delete a block of text in nano
Replies: 1
Views: 8032

Re: delete a block of text in nano

Found it:

CTRL+SHIFT+6 (or ^)
to start the selection
go down with arrows
and CTRL+K to cut/delete block
by chris
Sat Aug 06, 2022 11:14 am
Forum: Shell
Topic: delete a block of text in nano
Replies: 1
Views: 8032

delete a block of text in nano

Does anyone know how to delete a block of multiple lines text in nano ?
by chris
Sun Jul 31, 2022 9:55 am
Forum: Servers
Topic: linux verify dates of SSL certificates
Replies: 2
Views: 17836

Re: linux verify dates of SSL certificates

If you havce access to the file directly:

Code: Select all

less certificate.crt | openssl x509 -noout -dates
by chris
Fri Jul 29, 2022 7:54 am
Forum: Servers
Topic: linux verify dates of SSL certificates
Replies: 2
Views: 17836

Re: linux verify dates of SSL certificates

You can use the following command : echo | openssl s_client -servername SERVERNAME -connect SERVER:PORT 2>/dev/null | openssl x509 -noout -dates An example: echo | openssl s_client -servername www.webmaster2020.com -connect www.webmaster2020.com:443 2>/dev/null | openssl x509 -noout -dates notBefore...
by chris
Thu Jul 14, 2022 10:58 am
Forum: HTML
Topic: remove line break after DIV in CSS
Replies: 0
Views: 23888

remove line break after DIV in CSS

a div show as a block and with a new line.
In some cases you dont want that.

You do this by adding the inline display ellemen in CSS.

Code: Select all

display:inline;
or

Code: Select all

display:inline-block;
by chris
Sun Jun 12, 2022 9:18 am
Forum: SQL
Topic: mysql remove last char
Replies: 1
Views: 8429

Re: mysql remove last char

You can use (in MySQL):

Code: Select all

SELECT column SUBSTRING(column,1,CHAR_LENGTH(column)-1) AS column_part FROM table;
You can also do an update and change all the data.
(Make a backup first ! )

Code: Select all

UPDATE table SET column=SUBSTRING(column,1,CHAR_LENGTH(column)-1) FROM table WHERe column Like '%,' ;
by chris
Mon Feb 21, 2022 8:37 pm
Forum: General
Topic: SOLVED: Linux opera not playing videos
Replies: 3
Views: 20350

Re: Linux opera not playing videos

I think the real reason is a legal issue, that Opera does have all the licences to plat the video (codecs). But there is a way around. If you have chrome or chromium installed, you can use their drive sudo apt install chromium-codecs-ffmpeg-extra Then delete the file that opera use sudo rm /usr/lib/...
by chris
Thu Jan 20, 2022 5:01 pm
Forum: Postfix
Topic: spamc[5442]: connect to spamd on ::1 failed, retrying (#1 of 3): Connection refused
Replies: 1
Views: 23471

Re: spamc[5442]: connect to spamd on ::1 failed, retrying (#1 of 3): Connection refused

you are trying to connect to the spamd daemon on IPv6.
Probably only IPv4 is working.

configure spamassassin to only use IPv4
Add in file /etc/mail/spamassassin/spamc.conf:

Code: Select all

-d 127.0.0.1
This worked for me.