Search found 200 matches

by chris
Mon May 20, 2024 3:37 pm
Forum: Shell
Topic: grep : binary file matches
Replies: 1
Views: 2

Re: grep : binary file matches

Grep thinks that it is binary file for some reason,
and doesn't process it.
Maybe there are some special characters in the txt file.

You can solve it by forcing:
grep --text
grep -a
or grep --binary-files=text
by chris
Thu May 09, 2024 8:29 am
Forum: General
Topic: Solved: Linux fetchmail showing error
Replies: 2
Views: 42

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

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

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

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

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

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

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

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

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