After updating CWP get this MySQL errors

[johnny09]

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 Expand

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)

[Igor S.]

Hi.

hm, it is not related with upgrade since the scripts do not touching MariaDB.

[johnny09]

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

[Igor S.]

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.

[johnny09]

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

[Administrator]

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 Expand

rm -f /usr/local/apache/conf.d/mod_security.conf
service httpd restart


[johnny09]

1.Uninstalled ModSecurity
2.Installed again, everything fine until I restart or stop Apache. Apache show this with installed ModSecurity

Code Select Expand

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]

[johnny09]

Anyone any ideas about the imysql mport issue?

[Sandeep]

Anyone any ideas about the imysql mport issue?

i just replied a question on your previous reply

[Administrator]

phpmyadmin issue fix fro cwp versions 180+

Code Select Expand

yum update cwpsrv
sh /scripts/restart_cwpsrv