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.
Pages: [1]
1
MySQL / MySQL backup recovery
« on: September 12, 2024, 05:58:58 PM »
Hi,
I'm facing a couple of issues after recovering a database from the backup (manual recover from the scripts)
The DB was deleted by the user probably via phpmyadmin, not sure, so, deleted grants, etc.
The issue is that, now , I can't login to phpmyadmin via the cwppro.user panel for clients . With the pro.admin yes, but seems that the user can't login.
The grant has the main user there so, that might have messed it up. Already tried to reset the user's account password to see if the mysql user would get updated but no luck.
The other issue is that the client is complaining about a missing stored procedure but I can't see that on the backup script. Are stored procedures backed up?
Thanks in advance for any help provided.
Best regards
Daniel
I'm facing a couple of issues after recovering a database from the backup (manual recover from the scripts)
The DB was deleted by the user probably via phpmyadmin, not sure, so, deleted grants, etc.
The issue is that, now , I can't login to phpmyadmin via the cwppro.user panel for clients . With the pro.admin yes, but seems that the user can't login.
The grant has the main user there so, that might have messed it up. Already tried to reset the user's account password to see if the mysql user would get updated but no luck.
The other issue is that the client is complaining about a missing stored procedure but I can't see that on the backup script. Are stored procedures backed up?
Thanks in advance for any help provided.
Best regards
Daniel
2
SSL / Certificate is duplicated on bundle
« on: July 21, 2023, 04:28:26 PM »
I'm having an issue with a client. CWP creates the certificate bundle including the original certificate, along with the root certificates.
This does not cause problem in browser but a more strict certificate validation (for a payment gateway) is not passing. Also, validating in ssllabs also returns the duplication error, on the chain.
A workaround is to remove that duplication, manually. Of course, doing that every 90 days is not ok.
How can I fix this?
This does not cause problem in browser but a more strict certificate validation (for a payment gateway) is not passing. Also, validating in ssllabs also returns the duplication error, on the chain.
A workaround is to remove that duplication, manually. Of course, doing that every 90 days is not ok.
How can I fix this?
3
CentOS 7 Problems / Issue with Backups
« on: May 31, 2021, 09:11:07 AM »
I have an issue with backups to a NFS share.
It's hanging on one of the backups for a ton of time.
Then, it changes the share's permissions to 600 so, the next backup will fail...
Also, when that happens, the next backup generates tar.gz files that appear to be the backups but are located in the /usr/local/cwpsrv/htdocs/resources/admin/include folder and are simply huge. The entiry /home folder is now about 20GB and it somehow generates close to 700GB of tar.gz files...
And it's not the dbs.. they are also very small...
Can't really understand all this issues.
And no, the NFS share shouldn't be the issue as it's used for other (cpanel) servers, with no problem.
It's hanging on one of the backups for a ton of time.
Then, it changes the share's permissions to 600 so, the next backup will fail...
Also, when that happens, the next backup generates tar.gz files that appear to be the backups but are located in the /usr/local/cwpsrv/htdocs/resources/admin/include folder and are simply huge. The entiry /home folder is now about 20GB and it somehow generates close to 700GB of tar.gz files...
And it's not the dbs.. they are also very small...
Can't really understand all this issues.
And no, the NFS share shouldn't be the issue as it's used for other (cpanel) servers, with no problem.
Pages: [1]
