Search found 196 matches

by mister_v
Sun Mar 14, 2021 8:41 pm
Forum: Servers
Topic: postsuper: fatal: scan_dir_push: open directory defer: Permission denied
Replies: 3
Views: 18206

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

Tries to change the owner

Code: Select all

chown -R postfix /var/spool/postfix
did not solve the problem.
the system is not sending mails either.
by mister_v
Sun Mar 14, 2021 8:10 pm
Forum: Servers
Topic: postsuper: fatal: scan_dir_push: open directory defer: Permission denied
Replies: 3
Views: 18206

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

I got a problem with postfix,
got the following message in /var/log/mail.err

Code: Select all

postsuper: fatal: scan_dir_push: open directory defer: Permission denied
I don't know what it is.
by mister_v
Fri Feb 12, 2021 6:01 pm
Forum: General
Topic: linux repeat command x times
Replies: 1
Views: 6805

linux repeat command x times

Hey,

is there a way to repeat a command several times ?
with out re-typing the command.
by mister_v
Sat Feb 06, 2021 10:03 pm
Forum: SQL
Topic: mysql update add to text
Replies: 1
Views: 7774

mysql update add to text

Can you update field to add text to an existing text, or string ?

With a single SQL-query ?
by mister_v
Thu Nov 26, 2020 2:10 pm
Forum: WordPress
Topic: Solved: Wordpress upgrade
Replies: 2
Views: 59678

Re: Wordpress upgrade

Thanks, that works.
by mister_v
Sat Sep 19, 2020 2:21 pm
Forum: Shell
Topic: switch in bash
Replies: 1
Views: 7049

switch in bash

Hi,

is there an equivalent of switch in bash?
by mister_v
Tue Sep 08, 2020 9:39 am
Forum: SQL
Topic: Join 1 table on 2 different tables
Replies: 1
Views: 6963

Join 1 table on 2 different tables

Hi,

how do I make a join of 1 table on 2 different tables with the same identifier ?

Table1 : id, other_id;
table2 : id, name
table3 : id, title

So table 1 on table2 and on table 3 with other_id to id.
by mister_v
Thu Apr 23, 2020 9:46 am
Forum: SQL
Topic: Solved: Incorrect date value: '0000-00-00' for column
Replies: 2
Views: 8445

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

Thanks that solved it
by mister_v
Wed Apr 22, 2020 7:18 pm
Forum: SQL
Topic: Solved: Incorrect date value: '0000-00-00' for column
Replies: 2
Views: 8445

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

Hi, somehow there are is a "bad" date in the table ( 0000-00-00' ), It tried to update it to another value but each time I get the error-message: Incorrect date value: '0000-00-00' for column Even delete doesn't work: DELETE FROM table WHERE start_date='0000-00-00'; How do I fix this?
by mister_v
Fri Mar 20, 2020 9:15 pm
Forum: MySQL
Topic: php mysqli_connect: authentication method unknown to the client [caching_sha2_password]
Replies: 1
Views: 12655

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

Hi,

I get the following error whe I tried to connect with php to MySQL server.
mysqli::__construct(): The server requested authentication method unknown to the client

How can I fix this?
I use standard login function:
$dbconn=new mysqli('127.0.0.1','user','passwd','database');