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

Pages: 1 ... 6 7 [8]
Installation / Re: CentOS panel not installing on Aliyun Cloud
« on: October 12, 2016, 07:13:31 AM »
Try to disable all firewalls (look around your provider's control panel) if there is...

SSL / Re: Varnish+NginX+APache+Letsencrypt proposal
« on: September 20, 2016, 07:51:19 AM »
i got Nginx >> Varnish >> Apache working and results are amazing.

my $10 vps was able to handle 1000 clients/s for over 1 minute, theoretically that mean 86 million visitors a day. i am sure it can handle even more but i only test for 1000 clients using

3 GB data was  transferred in 1 minute.

It's gonna be better if you spend you time to give instruction instead of talking about your server.

Guys I tell you how to install Apache, Let's Encrypt and Varnish cache, latest Centos Web Panel on 20 Sep 2016. I haven't try NginX yet because I dont need it for now, maybe in future I will update this post

I assume you have done installing Centos Web panel. Now login at http://<your_ip>:2030/
Overview :
You might follow my setup in order : Apache Configuration > Lets encrypt > Varnish
1. Make your your website is running on port 80 ,
2. Navigate to Apache Setting > Install Let's encrypt > Manager , press Install
3. After install the service, go to that menu again and install SSL certificate for your first domain. Fill information on this box :  "Install Letsencrypt for Account/Main Domain" , or Custom Install of Letsencrypt if you modified your public_html folder location (default : /home/username/public_html)
Then press Install

Ok, now they are installing and verify certificate, if you failed or whatever error, here are some reasons:
- the folder is not exist . Go check if there is a folder named : '.well-known' inside your public_html folder
- If it is exist, go check on browser if you can load it on browser, because your server is going to verify this certificate via http

If you done this part, go check your domain at https://yourdomain/
At this point, even you failed at install SSL certificate, you still can access your Panel at https://yourdomain:2031 , but you will get warning from browser since it is missing certificate

Now you go ahead and choose your webserver. Apache Settings > Select Webservers
Choose Apache & Varnish Cache (Varnish on port 80 and apache on port 8181)

Click Save and Rebuild

Apache settings > Apache Configuration
Find Listen 80   , change it to 8181

Find and update

Save it and restart Apache

Test it:

Directly load Apache Server SSL:

Load Vanish cache:

Verify Vanish cache working:   and submit your site.

Please note that Vanish cache is not supported for https. So you will serve ether Vanish Cache http or https (no cache).
I think the process gonna be similar to NignX.

Information / Mongo DB
« on: September 16, 2016, 02:17:15 AM »
Would you mind to create a new section in this forum for MongoDB?
We might need to discuss on it

SSL / Re: How to install multiple SSL certificates on shared IP
« on: July 29, 2016, 10:31:57 AM »
How can i add letsencyrpt ssl for multi domains in the same ip?

edit /usr/local/apache/conf.d/vhosts-ssl-letsencrypt.conf , add this line
NameVirtualHost *:443
Listen 443

Please take note NameVirtualHost *:443 must above Liten 443
If you dont add that line above the Listen, you will get this warning when you restart httpd
[warn] _default_ VirtualHost overlap on port 443, the first has precedence
and the SSL is valid for first domain only

And... If you want to install SSL for multiple domains, you should change to * , instead of your actual ip
For example :

# vhost_start
<VirtualHost *:443>

# vhost_end

# another domain in same VPS, same shared ip
# vhost_start
<VirtualHost *:443>
# vhost_end

You are good to go with Let's encrypt for multiple domains.

Another thing need to consider, If you try to add certificate on a webpage protected with username and password, with .htaccess Ė youíll get an error like this. Letís encrypt cannot read the file under .well-known, so you need to temporary disable the .htaccess security by moving or renaming the file, while doing the letís encrypt process.

MySQL / Re: phpMyAdmin not login
« on: July 29, 2016, 06:58:58 AM »
You need to add Mysql user in CWP, or you can login using user root (password was shown up at the end of CWP installation), not recommend to login using root account.
I assume you understand the different of Mysql root account / SSH root account

Add this line to   /etc/csf/csf.pignore
You can use this command :  nano /etc/csf/csf.pignore  , then Ctrl-X , Y (to save file)

Note: you can remove the user which is not exist , this is just a common list of users

MySQL / Re: How to update mysql from 5.1 to 5.6
« on: July 23, 2016, 04:55:56 AM »

In the above link / article the remo repo will be enabled..

3) Now upgrade MySQL Server.

yum --enablerepo=remi update mysql-server
sudo mysql_upgrade

Question there is no need to disable the remi repo afterwards as it is done later for the atomic repo for upgrading to mysql 5.6 / 5.7? ? It will not break future updates of CWP ?

I'm not really sure about it and that's an optional step. I didn't disable it

CentOS-WebPanel Bugs / Re: cannot add email account
« on: July 23, 2016, 04:44:59 AM »
There is another way: disable STRICT_TRANS_TABLES  on your mysql.
edit your /usr/my.cnf:


Alright, thank you very much. You made my day easy

SSL / Re: Varnish+NginX+APache+Letsencrypt proposal
« on: July 21, 2016, 09:52:15 AM »
Wao, sounds like your website has very high traffic  ;D

SSL / Re: Error 500 after SSL with Letsencrypt
« on: July 21, 2016, 09:50:34 AM »
Try this
Go to the home folder (replace your username account)
cd /home/user_name/public_html

Fix permission of folders
find ./ -type d -exec chmod 755 {} \;

Fix permission of files
find ./ -type f -exec chmod 644 {} \;

MySQL / Re: can't start mysqld
« on: July 20, 2016, 08:41:38 AM »
solved after removing some folders and file, thanks for the help  ;)

Can you tell me which folders you remove? same problem

I guess you ran out of disk space
You can delete all unused log files or root's email. It happened to me after few months of using

du --max-depth=1 -h /   : List folder size
find / -type f -size +100M   : Find files with the size above 100MB
ls -1 -sh   : list folder and file
du -msh Folder_Name   : Get size of a  folder

MySQL / Re: MySQL Server down after daily cron
« on: July 20, 2016, 08:37:53 AM »
Maybe you you add another cron to automatic restart mysqld service after that daily cron

service mysqld restart

MySQL / Re: How to update mysql from 5.1 to 5.6
« on: July 20, 2016, 06:48:53 AM »
I found a very simple solution and it did it successfully

Upgrading MySQL to 5.5 in CentOS Web Panel [CWP]

Upgrading PhpMyAdmin in CentOS Web Panel [CWP]

Ok, now are are at version 5.5. Next step you need to upgrade 5.6 or 5.7 (upto you)
Detail at this url : , look for section "For centos". By the way, follow the following (what I did) for a shortcut :

Stop MySQL service:
# service mysqld stop

Back up MySQL databases: (Optional)
# mkdir /var/lib/mysqlcopy
# cp -aR /var/lib/mysql/* /var/lib/mysqlcopy

Disable Atomic repository, if it is enabled:(Optional)
# vi atomic.repo
  enabled = 0

Start installing , important!
# yum install

Disable upgrade to MySQL 5.7, enable upgrade to MySQL 5.6: (Optional, if you dont want 5.7 by default)
# vi /etc/yum.repos.d/mysql-community.repo

Install MySQL packages:
# yum install mysql

Start MySQL service:
# service mysqld start

Upgrade your database structure

Important! You must add this line to your mysql configuration, or else you could not add emails account and other SQL query from panel might be failed

(steps: IN CWP, under menu MySQL Services> Mysql Configuration, add the line above under [mysqld]  section )

Congratulations, you now at Mysql 5.7 , you are able to use
- Foreign keys for MyISAM DB engine
- Fulltext index for InnoDB engine

Hi, have a good day !
I'm looking for solution to change default phpmyadmin login URL

I don't want anybody public out there able to guess it, perharps change it to something like

How can i do that? please help.

Pages: 1 ... 6 7 [8]