Search found 197 matches

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

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.
by chris
Sun Mar 14, 2021 8:25 pm
Forum: Servers
Topic: postsuper: fatal: scan_dir_push: open directory defer: Permission denied
Replies: 3
Views: 16374

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

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
by chris
Fri Feb 12, 2021 7:10 pm
Forum: General
Topic: linux repeat command x times
Replies: 1
Views: 5402

Re: linux repeat command x times

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, ideal ...
by chris
Sun Feb 07, 2021 7:48 am
Forum: SQL
Topic: mysql update add to text
Replies: 1
Views: 6182

Re: mysql update add to text

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.
by chris
Wed Sep 23, 2020 4:01 pm
Forum: Shell
Topic: switch in bash
Replies: 1
Views: 5618

Re: switch in bash

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.
by chris
Sat Sep 19, 2020 2:46 pm
Forum: Shell
Topic: Bash last char of a string
Replies: 2
Views: 33081

Re: Bash last char of a string

you can also use:

Code: Select all

echo ${STRING: -1}
Just remember that the last character can sometimes be a whitespace ( space, newline ...)
by chris
Tue Sep 08, 2020 1:43 pm
Forum: SQL
Topic: Join 1 table on 2 different tables
Replies: 1
Views: 5657

Re: Join 1 table on 2 different tables

You can work with a sub-query an UNION:

Code: Select all

SELECT table1.id,union_table.name FROM table1 LEFT JOIN 
   (SELECT id,name FROM table2 UNION SELECT id,title AS name FROM table3) 
   AS union_table ON table1.other_id=union_table.id;
by chris
Thu Apr 23, 2020 6:59 am
Forum: SQL
Topic: Solved: Incorrect date value: '0000-00-00' for column
Replies: 2
Views: 7078

Re: Incorrect date value: '0000-00-00' for column

The error is because MYSQL is in strict mode (default) You can Check MYSQL mode SELECT @@GLOBAL.sql_mode global, @@SESSION.sql_mode session You change it with the following query; SET sql_mode = ''; or SET GLOBAL sql_mode = ''; Using the keyword GLOBAL requires super privileges and it affects the op...
by chris
Mon Mar 30, 2020 8:14 pm
Forum: Servers
Topic: Linux startup script
Replies: 1
Views: 14179

Re: Linux startup script

There are several ways to run a script on startup/reboot on linux. My favorite : Crontab sudo crontab -e @reboot /home/me/scripts/this.sh Another way to do it, local.d scripts at boot time, add its init.d script to the default runlevel. Enable local.d Scripts rc-service local start and then create y...
by chris
Fri Mar 20, 2020 9:23 pm
Forum: MySQL
Topic: php mysqli_connect: authentication method unknown to the client [caching_sha2_password]
Replies: 1
Views: 11545

Re: php mysqli_connect: authentication method unknown to the client [caching_sha2_password]

MYSQL has changed it type of password (since Mysql 8 ?)
Anyway the easiest solution, is execute the following SQL command on MYSQL

Code: Select all

ALTER USER 'mysqlUsername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysqlUsernamePassword';
It should solve your problem.