Search found 199 matches

by chris
Thu May 09, 2024 8:29 am
Forum: General
Topic: Linux fetchmail showing error
Replies: 1
Views: 32

Re: Linux fetchmail showing error

The certificate on your server is part of a chain. Many time the are delivered as separated files. Something like : server.cert and server.ca-bundle For dovecot, it easier to put them 1 file (order is important ! ). And add the file in /etc/dovecot/conf.d/10-ssl.conf ssl_cert = </etc/ssl/private/cer...
by chris
Thu May 02, 2024 6:42 pm
Forum: MySQL
Topic: Update problem ?
Replies: 1
Views: 88

Re: Update problem ?

The problem is that the key has expired.
You need to update it, but do it form a trustwordy source.

from Ubuntu

Code: Select all

apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys B7B3B788A8D3785C
Or from Mysql:

Code: Select all

wget -qO - https://repo.mysql.com/RPM-GPG-KEY-mysql-2023 | sudo apt-key add -
by chris
Mon Mar 06, 2023 8:47 pm
Forum: PHP
Topic: SOLVED: PHP Fatal error: Uncaught mysqli_sql_exception: Duplicate entry
Replies: 2
Views: 11319

Re: PHP Fatal error: Uncaught mysqli_sql_exception: Duplicate entry

You first should check why you have a duplicated key. You can use INSERT IGNORE command rather than the INSERT command. If a record doesn't duplicate an existing record, then MySQL inserts it as usual. If the record is a duplicate, then the IGNORE keyword tells MySQL to discard it silently without g...
by chris
Fri Feb 10, 2023 8:45 pm
Forum: Servers
Topic: install lighttp with php
Replies: 1
Views: 17484

Re: install lighttp with php

You can install php-fpm, best is to install the others also apt-get install php php-cli php-common php-fpm php-mysql To enable PHP support for Lighttpd. you need to modify the php.ini file nano /etc/php/7.4/fpm/php.ini Change cgi.fix_pathinfo value to 1: cgi.fix_pathinfo=1 By default, PHP-FPM listen...
by chris
Fri Feb 10, 2023 3:29 pm
Forum: SQL
Topic: change primary key
Replies: 1
Views: 11047

Re: change primary key

You first have to drop the current primary key,
and after create a new.
Best is to do it in 1 SQL alter statement.

Code: Select all

ALTER TABLE table_name DROP primary key, ADD primary key(k1, k2, k3);
by chris
Sun Oct 16, 2022 7:43 pm
Forum: Shell
Topic: Run commands parallel
Replies: 1
Views: 10205

Re: Run commands parallel

You can send a task to the background,
with &. (and symbol)

Code: Select all

#command to the background
ls -la /home &

#get the process id
P1=$!;

#wait for it to finish
wait $P1;
by chris
Fri Sep 02, 2022 11:11 am
Forum: Servers
Topic: What are some good hosting providers?
Replies: 1
Views: 67183

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

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

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

delete a block of text in nano

Does anyone know how to delete a block of multiple lines text in nano ?