Search found 199 matches
- Thu May 09, 2024 8:29 am
- Forum: General
- Topic: Linux fetchmail showing error
- Replies: 1
- Views: 28
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...
- Thu May 02, 2024 6:42 pm
- Forum: MySQL
- Topic: Update problem ?
- Replies: 1
- Views: 46
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
Or from Mysql:
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
Code: Select all
wget -qO - https://repo.mysql.com/RPM-GPG-KEY-mysql-2023 | sudo apt-key add -
- Mon Mar 06, 2023 8:47 pm
- Forum: PHP
- Topic: SOLVED: PHP Fatal error: Uncaught mysqli_sql_exception: Duplicate entry
- Replies: 2
- Views: 11230
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...
- Fri Feb 10, 2023 8:45 pm
- Forum: Servers
- Topic: install lighttp with php
- Replies: 1
- Views: 17416
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...
- Fri Feb 10, 2023 3:29 pm
- Forum: SQL
- Topic: change primary key
- Replies: 1
- Views: 10948
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.
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);
- Sun Oct 16, 2022 7:43 pm
- Forum: Shell
- Topic: Run commands parallel
- Replies: 1
- Views: 10110
Re: Run commands parallel
You can send a task to the background,
with &. (and symbol)
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;
- Fri Sep 02, 2022 11:11 am
- Forum: Servers
- Topic: What are some good hosting providers?
- Replies: 1
- Views: 67130
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/
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/
- Sat Aug 20, 2022 4:12 pm
- Forum: SQL
- Topic: Average of day over several years
- Replies: 1
- Views: 7059
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:
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)
- Sat Aug 06, 2022 11:19 am
- Forum: Shell
- Topic: delete a block of text in nano
- Replies: 1
- Views: 5304
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
CTRL+SHIFT+6 (or ^)
to start the selection
go down with arrows
and CTRL+K to cut/delete block
- Sat Aug 06, 2022 11:14 am
- Forum: Shell
- Topic: delete a block of text in nano
- Replies: 1
- Views: 5304
delete a block of text in nano
Does anyone know how to delete a block of multiple lines text in nano ?