Author Topic: After updating CWP get this MySQL errors  (Read 20432 times)

0 Members and 2 Guests are viewing this topic.

Offline
**
After updating CWP get this MySQL errors
« on: March 22, 2017, 08:26:26 AM »
Finaly got cwp version 0.9.8.188, but in mysql get this:

The configuration file now needs a secret passphrase (blowfish_secret).

1.Cant find info how to fix it or were..... help

2.And the second thing is that I cant import mysql db size 1m, loads loads and then - The connection was reset... help...its urgent....

Code: [Select]
MySQL info

    Server: Localhost via UNIX socket
    Server type: MariaDB
    Server version: 10.1.22-MariaDB - MariaDB Server
    Protocol version: 10
    User: libau_bad@localhost
    Server charset: UTF-8 Unicode (utf8)

     nginx/1.10.2
    Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $
    PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation
    PHP version: 7.0.16

 Version information: 4.6.6 (up to date)

Offline
*****
Re: After updating CWP get this MySQL errors
« Reply #1 on: March 22, 2017, 09:04:26 AM »
Hi.

hm, it is not related with upgrade since the scripts do not touching MariaDB.
You can ask me to solve any problem with your server for some money in pm  ;)
Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor
Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp

Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
**
Re: After updating CWP get this MySQL errors
« Reply #2 on: March 22, 2017, 09:10:56 AM »
Yesterday I upgraded my CWP version, If I had known that there will be such problems had better left it alone...

Solution?

Everything else seems ok, only these 2 points.

ModSecurity installed coses Apache to stop, after ModSecurity unninstall it gets back green....
« Last Edit: March 22, 2017, 09:13:23 AM by johnny09 »

Offline
*****
Re: After updating CWP get this MySQL errors
« Reply #3 on: March 22, 2017, 09:18:34 AM »
Hello, johnny09

Contact with CWP support and we will check the issue.
Unfortunately, I didn't see something like the issue and I can not say how to fix it.
You can ask me to solve any problem with your server for some money in pm  ;)
Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor
Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp

Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
**
Re: After updating CWP get this MySQL errors
« Reply #4 on: March 22, 2017, 09:21:04 AM »
About the ModSecurity just to know:

Dose not work, get after restart or stop this:

Stopping httpd: [FAILED]
Starting httpd: httpd: Syntax error on line 507 of /usr/local/apache/conf/httpd.conf: Syntax error on line 5 of /usr/local/apache/conf.d/mod_security.conf: Cannot load modules/mod_security2.so into server: /usr/local/apache/modules/mod_security2.so: undefined symbol: apr_crypto_block_cleanup
[FAILED]

WORKS - OWASP latest (Latest version of OWASP rules with automatic updates) [CWPpro required]
DOSE NOT WORK - Comodo WAF (Latest version of Comodo WAF rules with automatic updates) [CWPpro required] Installed version: 1.117

Sent a mail to support
« Last Edit: March 22, 2017, 09:37:22 AM by johnny09 »

Offline
*
Re: After updating CWP get this MySQL errors
« Reply #5 on: March 22, 2017, 11:25:18 AM »
Dose not work, get after restart or stop this:

Stopping httpd: [FAILED]
Starting httpd: httpd: Syntax error on line 507 of /usr/local/apache/conf/httpd.conf: Syntax error on line 5 of /usr/local/apache/conf.d/mod_security.conf: Cannot load modules/mod_security2.so into server: /usr/local/apache/modules/mod_security2.so: undefined symbol: apr_crypto_block_cleanup
[FAILED]

you can simply delete that file and then install again mod security from CWP
Code: [Select]
rm -f /usr/local/apache/conf.d/mod_security.conf
service httpd restart
AntiDDoS Protection (web + mail)
http://centos-webpanel.com/website-ddos-protection-proxy

Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp


Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Do you need Fast and FREE Support included for your CWP linux server?
http://centos-webpanel.com/noc-partner-list
Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
**
Re: After updating CWP get this MySQL errors
« Reply #6 on: March 22, 2017, 01:12:39 PM »
1.Uninstalled ModSecurity
2.Installed again, everything fine until I restart or stop Apache. Apache show this with installed ModSecurity

Code: [Select]
Stopping httpd: [FAILED]
Starting httpd: httpd: Syntax error on line 507 of /usr/local/apache/conf/httpd.conf: Syntax error on line 5 of /usr/local/apache/conf.d/mod_security.conf: Cannot load modules/mod_security2.so into server: /usr/local/apache/modules/mod_security2.so: undefined symbol: apr_crypto_block_cleanup
[FAILED]

Offline
**
Re: After updating CWP get this MySQL errors
« Reply #7 on: March 23, 2017, 09:03:50 AM »
Anyone any ideas about the imysql mport issue?

Offline
*****
Re: After updating CWP get this MySQL errors
« Reply #8 on: March 23, 2017, 11:47:40 AM »
Anyone any ideas about the imysql mport issue?
i just replied a question on your previous reply

Offline
*
Re: After updating CWP get this MySQL errors
« Reply #9 on: March 26, 2017, 10:02:15 AM »
phpmyadmin issue fix fro cwp versions 180+

Code: [Select]
yum update cwpsrv
sh /scripts/restart_cwpsrv
AntiDDoS Protection (web + mail)
http://centos-webpanel.com/website-ddos-protection-proxy

Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp


Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Do you need Fast and FREE Support included for your CWP linux server?
http://centos-webpanel.com/noc-partner-list
Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services