Search found 203 matches

by chris
Sat Jul 13, 2024 6:59 pm
Forum: General
Topic: SOLVED: Linux opera not playing videos
Replies: 3
Views: 14930

Re: SOLVED: Linux opera not playing videos

With the lastest version of opera (version 125.0.6422.143) (and Chromium) the last workaround doesn't work anymore. It crashes the page on youtube and doesn't play the videos in rumble.com. You can download libffmpeg.so from : https://github.com/iteufel/nwjs-ffmpeg-prebuilt/releases/ and copy over t...
by chris
Tue Jul 02, 2024 7:29 pm
Forum: MySQL
Topic: Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. P
Replies: 0
Views: 1961

Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. P

I got the message in my logs /var/log/mysql/error.log Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead' So how to fix this ? On MySQL 8.0.34 through 8.3, you get this warning. After MySQL 8...
by chris
Wed Jun 12, 2024 7:25 pm
Forum: SQL
Topic: event_scheduler ?
Replies: 1
Views: 1667

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

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

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

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

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

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

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

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;