Search found 186 matches

by chris
Sun Jun 12, 2022 9:18 am
Forum: SQL
Topic: mysql remove last char
Replies: 1
Views: 253

Re: mysql remove last char

You can use (in MySQL):

Code: Select all

SELECT column SUBSTRING(column,1,CHAR_LENGTH(column)-1) AS column_part FROM table;
You can also do an update and change all the data.
(Make a backup first ! )

Code: Select all

UPDATE table SET column=SUBSTRING(column,1,CHAR_LENGTH(column)-1) FROM table WHERe column Like '%,' ;
by chris
Mon Feb 21, 2022 8:37 pm
Forum: General
Topic: SOLVED: Linux opera not playing videos
Replies: 2
Views: 221

Re: Linux opera not playing videos

I think the real reason is a legal issue, that Opera does have all the licences to plat the video (codecs). But there is a way around. If you have chrome or chromium installed, you can use their drive sudo apt install chromium-codecs-ffmpeg-extra Then delete the file that opera use sudo rm /usr/lib/...
by chris
Thu Jan 20, 2022 5:01 pm
Forum: Postfix
Topic: spamc[5442]: connect to spamd on ::1 failed, retrying (#1 of 3): Connection refused
Replies: 1
Views: 254

Re: spamc[5442]: connect to spamd on ::1 failed, retrying (#1 of 3): Connection refused

you are trying to connect to the spamd daemon on IPv6.
Probably only IPv4 is working.

configure spamassassin to only use IPv4
Add in file /etc/mail/spamassassin/spamc.conf:

Code: Select all

-d 127.0.0.1
This worked for me.
by chris
Tue Jun 08, 2021 6:23 pm
Forum: PHP
Topic: Solved : find if GD2 is installed
Replies: 2
Views: 1285

Re: find if GD2 is installed

You can find ii with the command ( in shell)

Code: Select all

php -i | grep 'GD\|ImageMagick'
of with the following code in a php/html-file.

Code: Select all

<?php phpinfo(); ?>
It should be listed, if installed.
by chris
Sun May 16, 2021 8:39 am
Forum: MySQL
Topic: Grant rights to a backup user.
Replies: 2
Views: 15052

Re: Grant rights to a backup user.

PROCESS privilege is new as of MySQL 5.7.31 and MySQL 8.0.21 and is also needed if you don't use --no-tablespaces . privilege needed for mysqldump backup user: SELECT privilege for dumped tables SHOW VIEW for dumped views TRIGGER for dumped triggers LOCK TABLES if you don’t use the --single-transact...
by chris
Sun May 16, 2021 8:15 am
Forum: Shell
Topic: replace newline in text file
Replies: 1
Views: 1101

Re: replace newline in text file

You can use sed

replace it with FOO:

Code: Select all

sed '{:q;N;s/\n/FOO/g;t q}' /path/text.txt
or just remove it:

Code: Select all

sed '{:q;N;s/\n//g;t q}' /path/text.txt
by chris
Sat May 08, 2021 8:41 am
Forum: General
Topic: Solved: Facebook not showing good picture for website
Replies: 1
Views: 1156

Re: Facebook not showing good picture for website

Facebook uses Open Graph protocol to create a "template" of the web-page. If it can find it, it will try to create it's own. Normally it pretty good, but sometimes it goes really wrong. The good news is, Facebook engineers provided a great tool that can help you: https://developers.faceboo...
by chris
Sat Apr 17, 2021 4:18 pm
Forum: Postfix
Topic: Signed mail certificate
Replies: 2
Views: 1335

Re: Signed mail certificate

A good site to test your (mail)-ssl is
https://www.checktls.com/index.html
by chris
Sat Apr 17, 2021 12:14 pm
Forum: Postfix
Topic: Signed mail certificate
Replies: 2
Views: 1335

Re: Signed mail certificate

you first need to generate csr-file (and key). openssl req -new -nodes -keyout mail.server.com.key -out mail.server.com.csr Make sure you use the same host-name as used in your postfix config file (of dovecot or other mail server) in this example mail.server.com , not just the domain. Then send the ...
by chris
Sun Mar 14, 2021 8:53 pm
Forum: Servers
Topic: postsuper: fatal: scan_dir_push: open directory defer: Permission denied
Replies: 3
Views: 2460

Re: postsuper: fatal: scan_dir_push: open directory defer: Permission denied

If it can't write the mails, it can't process the mail to send them.

an extreme solution is to delete the dir

Code: Select all

rm -fr /var/spool/postfix
and do a reinstall

Code: Select all

apt-get reinstall postfix
it will recreate the dir with the correct file-settings.