Search found 201 matches

by chris
Wed Jun 12, 2024 7:25 pm
Forum: SQL
Topic: event_scheduler ?
Replies: 1
Views: 92

Re: event_scheduler ?

The event_Scheduler is, a way to Schedule Events (in this case queries) to run in MySQL at a given time. It is simply waiting for an event to trigger it. It is enabled by default, but can be disabled by running: SET @@global.event_scheduler = 0; or add it to my.conf of /etc/mysql/mysql.conf.d/mysqld...
by chris
Mon May 20, 2024 3:37 pm
Forum: Shell
Topic: grep : binary file matches
Replies: 1
Views: 130

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

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

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:// --recv-keys B7B3B788A8D3785C
Or from Mysql:

Code: Select all

wget -qO - | 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: 11830

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

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

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

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

#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: 67533

Re: What are some good hosting providers?

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

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

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)