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.


Messages - MAMAC

Pages: [1] 2
1
MySQL / Re: Mysql problem
« on: December 21, 2018, 02:29:00 PM »
Solved thanks to igor from support. Also if u delete root user by accident like i did :) , here is a quick solution.

service mysqld stop
killall -vw mysqld
mysqld_safe --skip-grant-tables &

mysql -u root
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');
FLUSH PRIVILEGES;

2
MySQL / Re: Mysql problem
« on: December 20, 2018, 07:22:28 AM »
Find something new :P when i use this

service mysqld stop
killall -vw mysqld
mysqld_safe --skip-grant-tables  &

And check, mysql running fine in mysql safe... all working even in mysql manager i see databases... but when i return to regular mysql nothing work... its like cwp dont have acces to mysql...

3
MySQL / Re: Mysql problem
« on: December 19, 2018, 11:07:01 AM »
when i use script to reboot mysql password i get crash from cwp panel, and mysql password dont change (beacuse i login again to mysql with old pass


Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0


Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: sh /scripts/restart_cwpsrv

**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf


Warning: mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Could not connect:

4
MySQL / Re: Mysql problem
« on: December 19, 2018, 10:44:20 AM »
to add when i run ./upgrade_mysql



CWP MySQL & phpMyAdmin Upgrade Script
#######################################

Server Version NOT supported!

5
MySQL / Mysql problem
« on: December 19, 2018, 08:42:43 AM »
Hello i got a strange problem i lost acces to mysql over cwp. also some cronjobs doesent work. i must say that i try mysql scrip to resset password i try to google and many other things nothing work. i return manualy old password to make cwp working again

http://prntscr.com/lwva5k

also when i try to update mysql script i got mysql root password error...

6
How to / Re: Disable varnish on xenforo 2
« on: December 07, 2018, 10:32:48 AM »
that is a last solution to change to subdomain :P

7
Updates / Re: PHP-FPM Enable
« on: December 06, 2018, 08:31:48 PM »
I enabled Apache -> PHP-FPM with version 7.2, however, when I run phpinfo() function it shows CGI/FastCGI version 5.6. So why PHP-FPM not working?

I also have enabled Apache -> PHP-FPM in Webserver domain Conf. Even I tried using nginx only with php-fpm but it gives 404 error. By the way, i am testing this on freshly installed machine.

Please help me to understand it better.

I have exactly the same problem. I am using apache + php-fpm 7.2.
I think there is problem in permissions - for me seems php-fpm working , but only for root , not for users (i have 3 of them):



Also i can see in CWP dashboard's -Top 5 Process- - when process is running by root it is php-fpm mostly , some times php - and when from other user - php-cgi. And at that time i have big spikes on cpu usage.

I rebuilded all vhosts in Main Conf and Domain Conf.

Here my php info:



I must say that i add config in  webservers domain config https://prnt.sc/lrolbl  maybe it can help to u.

8
How to / Re: Disable varnish on xenforo 2
« on: December 06, 2018, 04:46:57 PM »
I have on same domain wordpress and /forum is xenforo... so i dont want to disable varnish for wordpress only for subfolder.

i try many things in /etc/varnish/ including in hosts i add

if (req.url ~ "^/\forum/") {
      return (pass);
   }

i try like everything that i find on net but it seems like it doesent apply... i even try to reboot machine after changes...


EDIT:

http://prntscr.com/lrlk2y

9
How to / Disable varnish on xenforo 2
« on: December 06, 2018, 03:53:42 PM »
Hello, im trying to disable varnish on xf2, i try many things that i find on google but nothing works. i still have varnish on xf. Problem is that varnish doesent work ok with xenforo admin panel. he logout u as admin every time u click something in panel.

10
Updates / Re: PHP-FPM Enable
« on: December 06, 2018, 06:34:35 AM »
For me its running  https://prnt.sc/lr8v06

can you pls copy vhosts here ?


Code: [Select]
server {
listen 188.165.216.48:443 ssl http2 ;
server_name name.com  www.name.com;
access_log /usr/local/apache/domlogs/name.com.bytes bytes;
access_log /usr/local/apache/domlogs/name.com.log combined;
error_log /usr/local/apache/domlogs/name.com.error.log error;

ssl_certificate      /etc/pki/tls/certs/name.com.bundle;
ssl_certificate_key  /etc/pki/tls/private/name.com.key;
ssl_protocols TLSv1 TLSv1.1 TLSv1.2;
ssl_ciphers EECDH+ECDSA+AESGCM:EECDH+aRSA+AESGCM:EECDH+ECDSA+SHA384:EECDH+ECDSA+SHA256:EECDH+aRSA+SHA384:EECDH+aRSA+SHA256:EECDH+aRSA!RC4:EECDH:!RC4:!aNULL:!eNULL:!LOW:!3DES:!MD5:!EXP:!PSK:!SRP:!DSS;
ssl_prefer_server_ciphers   on;

ssl_session_cache   shared:SSL:10m;
ssl_session_timeout 60m;

location / {
location ~.*\.(3gp|gif|jpg|jpeg|png|ico|wmv|avi|asf|asx|mpg|mpeg|mp4|pls|mp3|mid|wav|swf|flv|html|htm|txt|js|css|exe|zip|tar|rar|gz|tgz|bz2|uha|7z|doc|docx|xls|xlsx|pdf|iso|woff|ttf|svg|eot|sh)\$ {
root /home/name/public_html;
expires max;
try_files \$uri \@backend;
}

error_page 405 = \@backend;
error_page 500 = \@custom;
add_header X-Cache "HIT from Backend";
add_header Strict-Transport-Security "max-age=31536000";
add_header X-Content-Type-Options nosniff;
proxy_pass http://188.165.216.48:82;
include proxy.inc;
}

location \@backend {
internal;
proxy_pass http://188.165.216.48:82;
include proxy.inc;
}

location \@custom {
internal;
proxy_pass http://188.165.216.48:82;
include proxy.inc;
}

location ~ .*\.(php|jsp|cgi|pl|py)?\$ {
proxy_pass http://188.165.216.48:82;
include proxy.inc;
}

location ~ /\.ht    {deny all;}
location ~ /\.svn/  {deny all;}
location ~ /\.git/  {deny all;}
location ~ /\.hg/   {deny all;}
location ~ /\.bzr/  {deny all;}

disable_symlinks if_not_owner from=/home/name/public_html;

location /.well-known/acme-challenge {
default_type "text/plain";
alias /usr/local/apache/autossl_tmp/.well-known/acme-challenge;
}
}

11
Updates / Re: PHP-FPM Enable
« on: December 05, 2018, 10:13:30 PM »
For me its running  https://prnt.sc/lr8v06

12
Information / Re: CWP version 0.9.8.744 totally broken.
« on: December 05, 2018, 08:34:08 PM »
I got that too today but only few times then i reboot varnish and all get ok. also i close chrome totaly and login again in cwp and i did ctrl + f5

13
Suggestions / Re: cwp updates
« on: December 05, 2018, 05:20:18 PM »
I cant wait, but i want to know when something come new :P so release note for every update can be a good thing.

14
Updates / Re: Issues After version: 0.9.8.742 Update
« on: December 05, 2018, 03:07:36 PM »
What u use? Apache ningx varnish or? I had loop problem i solve it setting default WebServer in nginx insted php-fpm. Also rebuild apache, and php to latest version. And remove all configs ( if u have) in domain conf.

15
Updates / Re: Update Nginx + Varnish + Apache breaks
« on: December 05, 2018, 03:02:26 PM »
I had similar problem. My solution is to switch to apache only, reboot than switch again to apache nginx varnish

Pages: [1] 2