EExcel 丞燕快速查詢2

EExcel 丞燕快速查詢2
EExcel 丞燕快速查詢2 https://sandk.ffbizs.com/

Let’s Encrypt ubuntu 14.04 vmware 2

Using Let’s Encrypt (beta) with Vesta Control Panel
https://docs.google.com/document/d/1y5tTtImTGk_zqYe3lelGtMl8_gSCQcNgCCdbYTQAb7E/edit#heading=h.fc0utsgks117

./letsencrypt-auto certonly -a webroot --renew-by-default --agree-dev-preview --server https://acme-v01.api.letsencrypt.org/directory --webroot-path /home/admin/web/<domain>/public_html -d <domain>

other way:
./letsencrypt-auto --server https://acme-v01.api.letsencrypt.org/directory \
  --renew-by-default \
  -a webroot --webroot-path [PATH_TO_APP_WEBROOT] --email [EMAIL] --text \
  --agree-tos --agree-dev-preview -d [DOMAIN_NAME] auth


Super Important  now open not need to do

https://docs.google.com/forms/d/15Ucm4A20y2rf9gySCTXD6yoLG6Tba7AwYgglV7CKHmM/viewform?edit_requested=true


Super Important2

open pem file, copy inside data put in vestacp..............no put path/file


SO Wait for Let’s Encrypt OPEN~~~


=====renew=====
 ./letsencrypt-auto renew

1、If   /etc/letsencrypt/archive/<domain>/  have  new file:cert2.pem 、 chain2.pem、fullchain2.pem 、privkey2.pem then

check  /etc/letsencrypt/live/<domain>/   If link is new file, the mean
ln -s /etc/letsencrypt/live/<domain>/fullchain.pem /home/admin/conf/web/ssl.<domain>.pem
ln -s /etc/letsencrypt/live/<domain>/privkey.pem /home/admin/conf/web/ssl.<domain>.key
ln -s /etc/letsencrypt/live/<domain>/cert.pem /home/admin/conf/web/ssl.<domain>.crt
ln -s /etc/letsencrypt/live/<domain>/chain.pem /home/admin/conf/web/ssl.<domain>.ca
this no use.

2、put new file:cert2.pem 、 chain2.pem、fullchain2.pem 、privkey2.pem to vestacp SSL Support again

SSL Certificate   =  cert2.pem
SSL Key  =  privkey2.pem
SSL Certificate Authority / Intermediate (optional)  = chain2.pem

3、restart apache and nginx then ok~~~


vestacp install

1、https://vestacp.com/#install
2、login change admin password
3、restore backup 

restore backup Fails


Super Important 
A

Old vmware or server setting:~admin/conf/web/*.conf  must keep or backup. Beacuse vestacp backup & resstore have big promble at here.

Example: I have nginx.xxxxx.conf use include other nginx.ooooo.conf .  When resotre conf, vestacp make error, put all conf together one file.

So Best Way is backup old server conf/web/* , restore conf/web/  then

nginx -t   for test check conf, If ok, nginx is work ok.

So this step must remeber~~~~~~

B
named  bind9 load file permission denied

HOW to check

tail -f /var/log/syslog
then
sudo service bind9 restart
then can see log. IF see named load file have permission denied, the mean log /home/admin/conf/dns conf faild!

SO  NOW EDIT

sudo nano /etc/apparmor.d/usr.sbin.named
put
  /home/admin/conf/dns/** rw,
  /home/admin/conf/dns/ rw,
then
sudo service apparmor reload
then 
sudo service bind9 restart
then check syslog agin.
tail -f /var/log/syslog
IF Not see  permission denied,  It's mean SUCCESS!

Search google, some article chmod、chgrp、chown /home/admin/con/dns/*  is not use for me.

Let’s Encrypt ubuntu 14.04 vmware

DHCP can use internet.

1、install new ubuntu 14.04
2、install vmware-tools
3、install ssh
sudo apt-get install openssh-server
4、install git
sudo apt-get update
sudo apt-get install git
5、https://letsencrypt.readthedocs.org/en/latest/using.html#installation

use root at root directory
git clone https://github.com/letsencrypt/letsencrypt
cd letsencrypt
https://letsencrypt.readthedocs.org/en/latest/contributing.html#ubuntu
 ./bootstrap/ubuntu.sh
 https://letsencrypt.readthedocs.org/en/latest/using.html#letsencrypt-auto
 ./letsencrypt-auto 

.netword static ip & dns

static ip
nano /etc/network/interfaces
iface eth0 inet static
address 192.168.0.xxx
netmask 255.255.255.0
gateway 192.168.0.xxx

dns
nano /etc/resolvconf/resolv.conf.d/base
nameserver 8.8.8.8
nameserver 8.8.4.4
resolvconf -u
--close vm NIC,

reboot

ui 畫面 制作

http://blog.akanelee.me/


photoshop 製作 Mockup

http://blog.akanelee.me/posts/260806-noteprototype-software




https://uistore.io/downloads/category/tools/

Blocs 整個排版
WebZap photo排版




網頁 版面 html動畫
http://tumult.com/hype/
http://tumult.com/hype/pro/

vestacp Restore Fails

nginx restart error
nginx: [emerg] unexpected end of file, expecting ";" or "}" in
he problem is in /etc/nginx/conf.d/vesta.conf
There is probably a apache.conf line and you need to remove it and problem solved.

https://forum.vestacp.com/viewtopic.php?t=5352
https://forum.vestacp.com/viewtopic.php?t=6213

=====

Error: Database connection to localhost failed

service mysql stop && service mysql start && dpkg-reconfigure mysql-server-5.5
>> the mean: reset root passwd

https://forum.vestacp.com/viewtopic.php?t=5195

=====
phpmyadmin can't login

nano /usr/local/vesta/conf/mysql.conf   see root passwd

http://ljasonh.com/find-and-change-vestacp-mysql-root-password/

vestacp restore backup



v-restore-user admin admin.2015-11-08.tar


you should run this command under root
or (under sudo user)
/usr/local/vesta/bin/v-restore-user


Error: backup doesn't exist
mkdir /home/backup
chown admin backup
chgrp admin backup
ln -s /home/backup / 
move   admin admin.2015-11-08.tar to directory backup

 IF still can not, put admin.2015-11-08.tar in backup

 IF no /home/backup  mkdir and chown chgrp, but check /etc/passwd have account