Blog Archives

mysql basic

Although phpmyadmin can release you from remembering most mysql instructions, sometimes you have to use a few mysql commands. For example, on my NAT VPS, I do not install phpmyadmin due to limited disk space. Other circumstances that you have

Posted in tips of hosting

How to install phpmyadmin on NAT VPS

phpmyadmin is one of the most important packages(the others are ftp server and awstats) that are worth being installed on your VPS, even your VPS is a NAT VPS with limited resource.  Although phpmyadmin is not good to handle large

Posted in tips of hosting

install and configure proftpd on NAT VPS

We have talked about proftpd installation/configuration  on Sentora and zPanel.  Sentora/zPanel distribution comes with proftpd in it so you do not need to install proftpd separately. NAT VPS, which has limited disk space/memory, is often deployed with a minimum OS,

Posted in tips of hosting

How to install awstats on CentOS

We have known how to install awstats in a control panel like zPanel(Sentora), but how to install awstats in a resource limited VPS such as NAT vps without a control panel? First, download the awstats package. Install the rpm package:awstats-7.4-1.noarch.rpm

Posted in tips of hosting

How to set up a website on NAT VPS?

NAT VPS is cheap for it has no dedicated IPV4 address. After you order a NAT VPS, you will receive an email which includes the configuration information about your server. The most important information is the internal IPV4 address, the

Posted in tips of hosting

enable https for Sentora

By default, Sentora does not support https. We will add https support to Sentora most like we have done for zPanel. First, install ssl module for apache: yum install mod_ssl Now the configuration file of httpd have been changed to

Posted in tips of hosting

on mysql key/index

How to show a table in mysql? In the following mysql commands, which one is correct(suppose you have already login to a database)? show tablename; describe tablename; show table tablename; describe table tablename; The anwser is 2. How to know

Posted in tips of hosting

How to use sftp for Sentora?

Very interestingly, Sentora seems not to care about ssl. You can not find a https url for its control panel like in Kloxo-MR. Neither can you use the sftp function of proftpd to transfer files securely. We talked about enabling

Posted in tips of hosting

sentora installation

Click here to find recommended cheap VPS. Sentora is the successor of zPanel. The last CentOS version zPanel supports is CentOS 6.6 so if you try to install zPanel on CentOS 6.7,  it will give the following error: Sorry, this

Posted in tips of hosting

save baseline configuration for vps

Before you install new software, especially big software packages such as kloxo-mr, zpanel,etc., it is a good habit to save current system settings so that you can compare them with the settings after those packages are installed. With the baseline

Posted in tips of hosting