Search found 181 matches

by mister_v
Sat Sep 19, 2020 2:21 pm
Forum: Shell
Topic: switch in bash
Replies: 1
Views: 1379

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

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

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

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

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');
by mister_v
Mon Mar 16, 2020 8:01 pm
Forum: Servers
Topic: Linux startup script
Replies: 1
Views: 2121

Linux startup script

Hi,

How do I make sure that a script is run when a server is started of restarted ?

/home/me/scripts/this.sh
by mister_v
Sun Feb 16, 2020 9:05 pm
Forum: Postfix
Topic: postfix not mail from other hosts
Replies: 4
Views: 3640

Re: postfix not mail from other hosts

thanks, that was indeed the problem.
When I add the domain name,
the mail is delivered.

I thought that before, the hostname was enough?
by mister_v
Sun Feb 16, 2020 9:01 pm
Forum: Postfix
Topic: postfix not mail from other hosts
Replies: 4
Views: 3640

Re: postfix not mail from other hosts

The mail leaves the client to the server,
but it is not delivered.
by mister_v
Sun Feb 16, 2020 1:05 pm
Forum: Postfix
Topic: postfix not mail from other hosts
Replies: 4
Views: 3640

postfix not mail from other hosts

my mail server is not accepting from other server on the same network.
But i did set it to subnet in main.cf

Code: Select all

mynetworks_style = subnet
anyone has any ideas ?
by mister_v
Sun Oct 13, 2019 7:01 pm
Forum: WordPress
Topic: Wordpress change login page
Replies: 1
Views: 18425

Wordpress change login page

Hello,

I tried to rename the login page of my Wordpress site,
I did it with iThemes Security, but the "new" login page does work.