Topics

1

CentOS-WebPanel Bugs / Migration and mysql stored procedure

« on: June 06, 2021, 09:45:42 PM »

When a migration between 2 cwp servers the mysql databases doesn't migrate the stored procedures and the events. It should be easy to fix it just adding --events and --routines parameters to the dump triggers are default.
Hope they do it

2

CentOS-WebPanel Bugs / mysql script mysql_pwd_reset doesn't work

« on: June 05, 2021, 09:42:47 PM »

Password get changed in /root/my.conf and /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php but then there is no change in mysql database
It's done with

systemctl stop mysqld
systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
systemctl start mysqld
mysql -u root
mysql> UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPassword') WHERE User = 'root' AND Host = 'localhost';
mysql> FLUSH PRIVILEGES;
mysql> quit
systemctl stop mysqld
systemctl unset-environment MYSQLD_OPTS
systemctl start mysqld
mysql -u root -p

3

CSF Firewall / CWP add temporary allow ip on login control panel

« on: June 01, 2021, 02:00:04 PM »

I have 2 servers with the same configuration.
One add my ip when I login to the admin panel and the other not.
I don't remember having configured this out.
Where does this get configured
Thanks

4

CentOS-WebPanel Bugs / CSF makes user cannot log through user panel

« on: May 14, 2021, 03:10:12 PM »

Port 2082 and 2083 are open in csf.conf and server is whitelisted

[root@xxx ~]# lsof -i :2083
COMMAND  PID   USER   FD   TYPE  DEVICE SIZE/OFF NODE NAME
httpd   3952 nobody  157u  IPv4  470156      0t0  TCP localhost:45456->localhost            :radsec (CLOSE_WAIT)
httpd   3952 nobody  162u  IPv4  777864      0t0  TCP localhost:45588->localhost            :radsec (CLOSE_WAIT)
httpd   3952 nobody  163u  IPv4  929547      0t0  TCP localhost:45636->localhost            :radsec (CLOSE_WAIT)
httpd   3952 nobody  164u  IPv4 1023068      0t0  TCP localhost:45730->localhost            :radsec (CLOSE_WAIT)
cwpsrv  4777   root   15u  IPv4  408277      0t0  TCP *:radsec (LISTEN)
cwpsrv  4778   root   15u  IPv4  408277      0t0  TCP *:radsec (LISTEN)
cwpsrv  4780   root   15u  IPv4  408277      0t0  TCP *:radsec (LISTEN)

After logging user is pushed back to login page but if I flush th iptables rules through csf -f then user get logged and it works fine.

Any suggestion to fix it?

Thanks

5

CentOS 7 Problems / php.ini per folder or user

« on: May 10, 2021, 05:21:49 PM »

I have centos 7 and php-fpm 8.0
I created a file /home/USERNAME/php.ini with a new value for upload_max_filesize
But the value I get with phpInfo stay the same after reload php-fpm and restarted Apache
New php.ini is:
[PHP]
upload_max_filesize = 20M

Is php-fpm doesn't allow php.ini per folder?

Thanks

6

Postfix / All incoming and outgoing mails stay in the mail queue

« on: November 18, 2019, 06:07:01 PM »

All incoming and outgoing mails stay in the mail queue.
Error in logs is:
postfix/smtp[8979]: C5FBF40165: to=, relay=127.0.0.1[127.0.0.1]:10024, delay=0.13, delays=0.1/0.02/0/0, dsn=4.4.2, status=deferred (lost connection with 127.0.0.1[127.0.0.1] while receiving the initial server greeting)
If I disable CSF it works fine
If I disable Amavis in master.cf it works fine.
All mails which comes from an email account of the server to a internal email account are delivered without problems.
Server is not blacklisted

Please help

Thanks