Messages

106

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

107

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

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 , http://your_domain.com/
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
ServerName yourdomain.com

Save it and restart Apache

Test it:
https://yourdomain.com
https://yourdomain.com

Directly load Apache Server SSL:
http://yourdomain.com:443

Load Vanish cache:
http://yourdomain.com

Verify Vanish cache working:
http://www.isvarnishworking.com   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.

108

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

109

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 your_domain.com
<VirtualHost *:443>
 ServerName your_domain.com
 ServerAdmin no-reply@your_domain.com

...
...
# vhost_end your_domain.com

# another domain in same VPS, same shared ip
# vhost_start your_domain2.com
<VirtualHost *:443>
 ServerName your_domain2.com
 ServerAdmin no-reply@your_domain2.com
...
...
# vhost_end your_domain2.com

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

110

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

111

MySQL / Re: [ask] email "Suspicious process running under user mysql", what should I do?

« on: July 29, 2016, 06:43:49 AM »

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)

user:root
user:named
user:apache
user:ntp
user:dbus
user:smmsp
user:postfix
user:www-data
user:dovecot
user:daemon
user:sync
user:admin
user:nobody
user:rpm
user:diradmin
user:mysql
user:webapps
user:majordomo
user:mail
user:exim
user:sshd
user:webalizer
user:mgmt
user:qmaill
user:qmailr
user:qmailq
user:mailman
user:qmails
user:qmaild
user:haldaemon

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

112

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

113

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:

sql_mode=NO_ENGINE_SUBSTITUTION

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

114

SSL / Re: Varnish+NginX+APache+Letsencrypt proposal

« on: July 21, 2016, 09:52:15 AM »

Wao, sounds like your website has very high traffic 

115

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 {} \;

116

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

117

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

118

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]
https://blog.bullten.com/upgrading-mysql-to-5-5-in-centos-web-panel-cwp/

Upgrading PhpMyAdmin in CentOS Web Panel [CWP]
https://blog.bullten.com/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 : https://kb.plesk.com/en/127962 , 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 http://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm

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
  [mysql56-community]
  enabled=1
  [mysql57-community]
  enabled=0

Install MySQL packages:
# yum install mysql

Start MySQL service:
# service mysqld start

Upgrade your database structure
mysql_upgrade

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
sql_mode=NO_ENGINE_SUBSTITUTION
(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

119

CentOS-WebPanel GUI / Re: Changing PhpMyadmin URL - modifying the php code of CWP for link?

« on: May 21, 2016, 10:15:44 AM »

Hi, have a good day !
I'm looking for solution to change default phpmyadmin login URL
http://yourdomain.com/phpmyadmin

I don't want anybody public out there able to guess it, perharps change it to something like http://yourdomain.com/dbadminlogin

How can i do that? please help.