Control Web Panel

WebPanel => MySQL => Topic started by: johnny09 on March 22, 2017, 08:26:26 AM

Title: After updating CWP get this MySQL errors
Post by: johnny09 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)
Title: Re: After updating CWP get this MySQL errors
Post by: Igor S. on March 22, 2017, 09:04:26 AM
Hi.

hm, it is not related with upgrade since the scripts do not touching MariaDB.
Title: Re: After updating CWP get this MySQL errors
Post by: johnny09 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....
Title: Re: After updating CWP get this MySQL errors
Post by: Igor S. 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.
Title: Re: After updating CWP get this MySQL errors
Post by: johnny09 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
Title: Re: After updating CWP get this MySQL errors
Post by: Administrator 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
Title: Re: After updating CWP get this MySQL errors
Post by: johnny09 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]
Title: Re: After updating CWP get this MySQL errors
Post by: johnny09 on March 23, 2017, 09:03:50 AM
Anyone any ideas about the imysql mport issue?
Title: Re: After updating CWP get this MySQL errors
Post by: Sandeep 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
Title: Re: After updating CWP get this MySQL errors
Post by: Administrator on March 26, 2017, 10:02:15 AM
phpmyadmin issue fix fro cwp versions 180+

Code: [Select]
yum update cwpsrv
sh /scripts/restart_cwpsrv