Search found 212 matches

by chris
Sat Aug 20, 2022 4:12 pm
Forum: SQL
Topic: Average of day over several years
Replies: 1
Views: 43536

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: 42903

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: 42903

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: 59010

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: 59010

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 ...
by chris
Thu Jul 14, 2022 10:58 am
Forum: HTML
Topic: remove line break after DIV in CSS
Replies: 0
Views: 133983

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: 42437

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: 246915

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 ...
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: 60028

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.
by chris
Tue Jun 08, 2021 6:23 pm
Forum: PHP
Topic: Solved : find if GD2 is installed
Replies: 2
Views: 53899

Re: find if GD2 is installed

You can find ii with the command ( in shell)

Code: Select all

php -i | grep 'GD\|ImageMagick'
of with the following code in a php/html-file.

Code: Select all

<?php phpinfo(); ?>
It should be listed, if installed.