Install ISPCONFIG on Debian

apt-get update && apt-get upgrade
apt-get install unzip 
cd /tmp
wget --no-check-certificate https://github.com/servisys/ispconfig_setup/archive/master.zip
unzip master.zip

cd ispconfig_setup-master/
./install.sh

 1. Initially, we login as a root user and find the ISPConfig config file that contains MySQL information.

cat /usr/local/ispconfig/server/lib/mysql_clientdb.conf

The result looks like,

$conf['db_database'] = 'dbispconfig';

$clientdb_host = ‘localhost’;

$clientdb_user = ‘root’;

$clientdb_password = ‘Password’;

 

2. After that, we log into the MySQL server from the command line with the information extracted from mysql_clientdb.conf. This helps us to confirm that the password actually works.

mysql -h localhost -p dbispconfig

3. Then we set this password in the MySQL database by running:

UPDATE sys_user SET passwort = md5('YourNewPassword') WHERE username = 'admin';
FLUSH PRIVILEGES;
quit;

5. Finally, restart MySQL service.

Let's encrypt Wilcard ssl on Centos 7

yum install epel-release
yum install yum-utils
yum install python2-certbot-apache
yum install python2-certbot-nginx

certbot certonly --manual -d *.easyware.id -d easyware.id --agree-tos --manual-public-ip-logging-ok --preferred-challenges dns-01 --server https://acme-v02.api.letsencrypt.org/directory

certbot certonly --manual -d *.pastioke.com --agree-tos --manual-public-ip-logging-ok --preferred-challenges dns-01 --server https://acme-v02.api.letsencrypt.org/directory --register-unsafely-without-email

key
/etc/letsencrypt/live/easyware.id/privkey.pem

cert atas //  CA bundle bawah
/etc/letsencrypt/live/easyware.id/fullchain.pem

Webuzo Install

Open a Shell Terminal (e.g. PuTTY) and SSH to your server. Run the following commands:

wget -N http://files.webuzo.com/install.sh
chmod 0755 install.sh
./install.sh     // This will install the LAMP Stack, DNS Server and FTP server along with Webuzo

OR

./install.sh --install=lamp,bind // This will install the LAMP Stack(softname -> lamp) and DNS Server 
                                    (softname -> bind) along with Webuzo.
                                    Note : softname for Apps should be comma separated.
                                    Get list of softnames for the Apps here : http://api.webuzo.com/apps.php

OR

./install.sh --install=none // This will install only Webuzo without any LAMP Stack.
                               You can later install apps from the Apps Category in the Enduser Panel.

src http://www.webuzo.com/wiki/Install
mysql root pasword are saved in /var/webuzo/my.conf 

if WEBUZO STOP AFTER RESTART you can try this step

service webuzo restart

or in centos, execute this command

setenforce 0 >> /dev/null 2>&1
iptables -F >> /dev/null 2>&1
iptables -P INPUT ACCEPT >> /dev/null 2>&1

Tambahan Catatan Untuk mysql

Disable ONLY_FULL_GROUP_BY

Solution 1: Remove ONLY_FULL_GROUP_BY from mysql console

mysql -u pastuoke -p
mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

you can read more here

Solution 2: Remove ONLY_FULL_GROUP_BY from phpmyadmin

• Open phpmyadmin & select localhost
• Click on menu Variables & scroll down for sql mode
• Click on edit button to change the values & remove ONLY_FULL_GROUP_BY & click on save.

 d