Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Topics - juanyves

Pages: [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

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> quit
systemctl stop mysqld
systemctl unset-environment MYSQLD_OPTS
systemctl start mysqld
mysql -u root -p

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

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


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:
upload_max_filesize = 20M

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


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=[]:10024, delay=0.13, delays=0.1/0.02/0/0, dsn=4.4.2, status=deferred (lost connection with[] while receiving the initial server greeting)
If I disable CSF it works fine
If I disable Amavis in 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


Pages: [1]