Search found 203 matches
- Sat Jul 13, 2024 6:59 pm
- Forum: General
- Topic: SOLVED: Linux opera not playing videos
- Replies: 3
- Views: 14966
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...
- 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: 2000
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...
- Wed Jun 12, 2024 7:25 pm
- Forum: SQL
- Topic: event_scheduler ?
- Replies: 1
- Views: 1689
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...
- Mon May 20, 2024 3:37 pm
- Forum: Shell
- Topic: grep : binary file matches
- Replies: 1
- Views: 1694
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
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
- Thu May 09, 2024 8:29 am
- Forum: General
- Topic: Solved: Linux fetchmail showing error
- Replies: 2
- Views: 1794
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: 1330
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: 13494
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: 18734
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: 12450
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: 11485
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;