Search found 208 matches

by chris
Mon Oct 21, 2024 6:24 pm
Forum: Servers
Topic: dovocot: sl/tls alert bad certificate: SSL alert number 42
Replies: 1
Views: 854

Re: dovocot: sl/tls alert bad certificate: SSL alert number 42

The newer version of thunderbird are more strict on certificates, specially on self-signed certificates. If you have a private imap-server that you maintain yourself you probably use this. You can find a tutorial on this site: https://softwareprocess.es/homepage/posts/dovecot-thunderbird-ssl-alert-n...
by chris
Sun Oct 20, 2024 8:04 pm
Forum: Servers
Topic: ssl/tls alert certificate unknown: SSL alert number 46
Replies: 2
Views: 777

Re: ssl/tls alert certificate unknown: SSL alert number 46

Sounds like the client is not accepting the certificate. did you change the certificate of the server recently ? I think you need to accept the new certificate on the client software. In K-9 it is in Settings > accounts > Fetching mail > Incoming Server > Next of Advanced and accept the new certific...
by chris
Mon Oct 14, 2024 6:13 pm
Forum: SQL
Topic: Illegal mix of collations (utf8mb4
Replies: 1
Views: 1140

Re: Illegal mix of collations (utf8mb4

The problem is comparing different encode character-sets. You can see the character-sets with: SHOW VARIABLES LIKE 'char%'; SHOW CREATE TABLE table_name; FYI: utf8mb4 is NOT a character encoding, utf8mb4 is just MySQL's nickname for utf8. what MySQL calls utf8 is actually a 3-byte subset of the real...
by chris
Sun Sep 22, 2024 3:53 pm
Forum: SQL
Topic: [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type'
Replies: 1
Views: 923

Re: [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type'

found a solution.
Apparently something went wrong or was incomplete with the latest update
to mysql Ver 15.1 Distrib 10.11.6-MariaDB

running the upgrade command solved a lot of problems:

Code: Select all

mysql_upgrade -u root -p
by chris
Sun Sep 22, 2024 3:50 pm
Forum: SQL
Topic: [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type'
Replies: 1
Views: 923

[ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type'

Hello I get the following error in the logs of mariadb/mysql mariadbd[721379]: 2024-09-22 17:48:04 1693 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type' at position 9 to have type e…UBLE_PREC_HB'). mariadbd[721379]: 2024-09-22 17:48:04 1693 [ERROR] Incorrect defi...
by chris
Sat Jul 13, 2024 6:59 pm
Forum: General
Topic: SOLVED: Linux opera not playing videos
Replies: 3
Views: 22105

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

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

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

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

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...