Webmaster2020.com

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

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

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

A good site to test your (mail)-ssl is
https://www.checktls.com/index.html

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

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.

It looks like postfix does not have access to one or more directories.
Somehow the rights must have been changed.

You can try:

Code: Select all

chown -R postfix /var/spool/postfix

or

Code: Select all

postfix set-permissions

With the up arrow you get the last commands you typed, and press enter to execute it.

If you want to run the same command several times,
you can use for-loop ( in bash)
for n in {1..3}; do <COMMAND>; done
repeats 3 times

Another option is watch
If you want to repeat a command every x seconds ...

you can use concat to add to already existing string (varchar,text,...)

Code: Select all

UPDATE table_name SET text_field=CONCAT(text_field,'string to add') WHERE  id='1';

It doesn't work if the value is NULL,
It works with an empty string ('').
So you should replace all NULL values with empty string before.

Yes, it look lik this:

Code: Select all

#Set the IP
case $VALUE in
1)
IP=192.168.1.160
NAME='a';
;;
2)
IP=192.168.1.161
NAME='B';
;;
*)
IP=192.168.1.1
NAME='Default';
;;
esac

in this case $VALUE can be 1 or 2,
anything else will result in default.
I think it is a string compare, so you can use anything.

Webmaster2020.com

Search found 212 matches

Re: Grant rights to a backup user.

Re: replace newline in text file

Re: Facebook not showing good picture for website

Re: Signed mail certificate

Re: Signed mail certificate

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

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

Re: linux repeat command x times

Re: mysql update add to text

Re: switch in bash