Vega的筆記本

使用GoogleDrive同步VSCode的snippets

2020-06-27T08:57:00.001+08:00

VSCode的snippet位置
%USERPROFILE%\AppData\Romaing\Code\User\snippets\

進入snippet目錄
cd %USERPROFILE%\AppData\Romaing\Code\User

先將原本的snippets目錄改名
rename snippets snippets.old

再建立snippet的目錄連結
mklink /D "snippets" "D:\GoogleDrive\sync\vscode\snippets"

Debian 9 Install PHP 5.6 Debian9安裝php5.6筆記

2019-08-05T14:35:00.001+08:00

apt-get --assume-yes install ca-certificates apt-transport-https
wget -q https://packages.sury.org/php/apt.gpg -O- | apt-key add -
echo "deb https://packages.sury.org/php/ stretch main" | tee /etc/apt/sources.list.d/php.list
apt-get update
apt-get --assume-yes install php5.6 php5.6-mysql

apt-get --assume-yes install apache2
apt-get --assume-yes install mysql-server

wget 錯誤:ERROR: The certificate of `url' is not trusted. 處理方式

2019-06-27T09:31:00.000+08:00

使用wget抓檔時如果是https，有時會出現如下錯誤：

ERROR: The certificate of `url' is not trusted.
ERROR: The certificate of `url' hasn't got a known issuer.

解決方式如下：
1.
#apt-get install ca-certificates

2.
#wget --no-check-certificate https://download/url

Sublime Text 3 在不同電腦間同步設定使用Dropbox

2019-05-14T14:57:00.001+08:00

MAC
假設Dropbox目錄在 ~/Dropbox/
建目錄 ~/Dropbox/sync/SublimeText/

到Sublime目錄
cd ~/Library/Application\ Support/Sublime\ Text\ 3/Packages/

把User目錄整個搬到~/Dropbox/sync/SublimeText/
mv User ~/Dropbox/sync/SublimeText/

建連結
ln -s ~/Dropbox/sync/SubilmeText/User

Windows
cd C:\Users\USERNAME\AppData\Roaming\Sublime Text 3\Packages
mklink /D "User" "\Dropbox\sync\SublimeText\User"

ASP.NET 連接Mysql 語法記錄

2019-04-13T14:55:00.000+08:00

string ConnString = System.Configuration.ConfigurationManager.ConnectionStrings["MysqlConnectionString"].ToString();
string sql = "";

MySqlConnection conn = new MySqlConnection(ConnString);
MySqlCommand cmd = new MySqlCommand();
MySqlDataAdapter da = new MySqlDataAdapter();

cmd.Connection = conn;

sql = "INSERT INTO table (var1,var2) VALUES (@v1,@v2);SELECT LAST_INSERT_ID()";
cmd.CommandText = sql;

da.SelectCommand = cmd;
da.SelectCommand.Parameters.AddWithValue("@v1", 1);
da.SelectCommand.Parameters.AddWithValue("@v2", "AA");

DataTable dt = new DataTable();
da.Fill(dt);

last_insert_id = dt.Rows[0][0].ToString();

CSS Flex 筆記

2019-01-05T11:26:00.000+08:00

主軸,次軸

啟用: 父層設定 display:flex

justify-content: flex-start , center , flex-end
justify-content: space-around , space-between

資料流橫:左到右直:上到下

align-items(單行子物件) align-content(多行子物件)
align-items: flex-start , center , flex-end , stretch

flex-wrap:wrap;(換行) nowrap/wrap/wrap-reverse
flex-direction:row; //( row/column/row-reverse/column-reverse )
整合flex-direction,flex-wrap
flex-flow:row wrap;

align-self: flex-start;

延展比:flex-grow //剩下來的空間做分配
收縮比:flex-shrink //
基本比:flex-basis //控制主軸方向的長度

XAMPP MAC 更換Documentroot

2019-01-03T18:13:00.002+08:00

mkdir /Users/vega/xampp

/Applications/XAMPP/etc/httpd.conf

DocumentRoot "/Users/vega/xampp"

...

/Applications/XAMPP/etc/extra/http-ssl.conf
DocumentRoot "/Users/vega/xampp/"

Javascript 強制轉換至https網址

2018-11-09T18:53:00.002+08:00

if (location.protocol != 'https:'){
location.replace( 'https:' + window.location.href.substring(window.location.protocol.length) );
}

Grocery_crud CKEditor 客製化功能選單

2018-11-01T16:32:00.000+08:00

Grocerycrud CKEditor客製化功能選單，留下常用的功能選單

/assets/grocery_crud/js/jquery_plusins/config/jquery.ckeditor.config.js
$(function(){
$( 'textarea.texteditor' ).ckeditor({toolbar:'MyBasic'});
$( 'textarea.mini-texteditor' ).ckeditor({toolbar:'MyBasic',width:700});
});

/assets/grocery_crud/texteditor/config.js
CKEDITOR.editorConfig = function( config )
{
CKEDITOR.config.toolbar_MyBasic =
[
[ 'Source','ShowBlocks','Maximize','Cut','Copy','Paste','PasteText','PasteFromWord','-','Undo','Redo','Bold','Italic','Underline','Strike','Subscript','Superscript','-','RemoveFormat'],
'/',
['Image','Table','HorizontalRule','Link','Unlink','Anchor'],
'/',
['Styles','Format','Font','FontSize','TextColor','BGColor' ]
];
};

css ellipsis 當字數過多時，顯示...

2018-09-20T16:51:00.000+08:00

當字數過多時，顯示...

.ellipsis {
overflow:hidden;
white-space: nowrap;
text-overflow: ellipsis;
}

Synology設定備忘

2017-12-29T15:30:00.000+08:00

synouser --setpw root

PHP CURL 設定筆記

2017-12-29T15:04:00.003+08:00

PHP CURL 設定筆記

GET

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, "http://somewhere/?var=val");
//curl_setopt($ch, CURLOPT_HEADER, false);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);//不直接輸出
$result = curl_exec($ch);
curl_close($ch);

POST

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, "http://somewhere/");
curl_setopt($ch, CURL_POST, true);
curl_setopt($ch, CURL_POSTFIELDS, http_build_query( array() ) );
//curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);//不直接輸出
$result = curl_exec($ch);
curl_close($ch);

Debian Fail2Ban 安裝設定筆記

2017-10-05T17:55:00.001+08:00

安裝
apt-get install fail2ban

設定檔
/etc/fail2ban/fail2ban.conf

check
logtarget = /var/log/fail2ban.log

cp jail.conf jail.local
修改jail.local內容就好，原始檔不動
jail.local設定會覆蓋jail.conf

注意事項
ignoreip = 127.0.0.1/8 192.168.1.0/24 (空白區隔)
bantime = 600(秒)
maxretry = 10 (失敗幾次封鎖)

增加dovecot

[dovecot]
enabled = true
port = pop3,pop3s,imap,imaps
filter = dovecot
logpath = /var/log/dovecot (看實際 log檔放哪)
maxretry = 10

/etc/fail2ban/filter.d/dovecot.conf
[Definition]
failregex = (?: pop3-login|imap-login): .*(?:Authentication failure|Aborted login \(auth failed|Aborted login \(tried to use disabled|Disconnected \(auth failed).*rip=(?P\S*),.*
ignoreregex =

/etc/fail2ban/filter.d/sasl.conf

failregex = (?i): warning: [-._\w]+\[<HOST>\]: SASL (?:LOGIN|PLAIN|(?:CRAM|DIGEST)-MD5) authentication failed(: [A-Za-z0-9+/ ]*={0,2})?$

=========

測規則

Example1

fail2ban-regex /var/log/dovecot /etc/fail2ban/filter.d/dovecot.conf

Example2

fail2ban-regex /var/log/mail.log /etc/fail2ban/filter.d/postfix.conf

Example3

fail2ban-regex /var/log/mail.log /etc/fail2ban/filter.d/sasl.conf

Git stash指令記錄

2017-09-04T17:46:00.000+08:00

儲存stash(僅追蹤中已修改)
git stash

儲存stash(包含未追蹤)
git stash -u

顯示已存的stash
git stash list

讀取stash
git stash apply

讀取stash (指定stash)
git stash apply stash@{1}

取出stash(原本stash會刪除)
git stash pop

刪除stash
git stash drop

刪除stash (指定stash)
git stash drop stash@{1}

清除stash
git stash clear

Git 使用情境記錄

2017-06-06T14:25:00.001+08:00

*建立branch
$git branch NewBranch

*切換branch
$git checkout TargetBranch
$git co TargetBranch

*假設目前有二個branch叫做master與bugfix
*為了方便理解我會在提示字元前面加上目前的branch名稱，例如：
master$ 代表目前在master 這個branch下
bugfix$ 代表目前在bugfix 這個branch下

*Merge
將一個branch的內容合併到另一支branch
EX:把bugfix的修改內容，合併到master
master$ git merge bugfix

*Rebase
將一個branch 基於另一支branch 合併起來
EX:把bugfix的修改內容，合併到master 這個branch之下
bugfix$ git rebase master

*取消上一次的操作
$ git reset --hard ORIG_HEAD

*取消已暫存的檔案
不小心用add加入了stage
$ git add filename
使用指令取消
$ git reset HEAD filename

*取消修改過的檔案(回復到本來的內容)
$ git checkout -- filename

*取消目前為止修改過的檔案
$ git checkout .

*merge中發生confict,想放棄merge,要取消merge
$ git reset --hard 可取消這次的merge

*取消這次的merge回到merge前的狀態
$ git reset --hard ORIG_HEAD
取消最近一次成功的merge以及所有在這次merge後的修改

*忽略chmod的修改(chmod造成的檔案修改)
$ git config core.filemode false
有時檔案會因為chmod的關係會讓git認為檔案已修改，造成無法順利pull

MYSQL on MAC 設定筆記

2017-06-06T13:46:00.000+08:00

/usr/local/mysql/my.cnf

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

MySQL5.0.2版本中的The Server SQL Mode 中新加了幾種 sql_mode,並且在sql的my.ini文件中的sql-mode 默認增加了其中的二種,一個是STRICT_TRANS_TABLES,就是導致auto_increament失敗的mode,這個sql_mode主要用于當一個值不能插入到表中是,則産生一個錯誤而不是一個警告並終止會話。

#有時太小會導致寫入失敗,預設值好像才1M
max_allowed_packet = 20M

Sublime Text 3 安裝設定

2016-10-21T21:13:00.000+08:00

1.安裝Package Control: Ctrl + ` 貼上此網站提供的連結

2.安裝ConvertToUTF8

3.安裝Emmet

4.安裝SublimeCodeIntel

Postfix main.cf 設定檔記錄

2016-03-25T15:36:00.001+08:00

message_size_limit = 30720000
bounce_queue_lifetime = 1d
maximal_queue_lifetime = 2d
queue_run_delay = 10s

#20220105 update

minimal_backoff_time = 10s
maximal_backoff_time = 15s

#寄出時間
maximal_queue_lifetime = 1d
#退信時間
bounce_queue_lifetime = 1d

Synology DS414j 安裝設定備忘 (Tomcat7+Javabridge)

2016-03-25T15:35:00.001+08:00

1.先安裝JavaManager套件

Java Manager可協助安裝java
要去下載像是這樣的檔案jdk-7u60-linux-arm-vfp-hflt.tar.gz 再上傳，它就會幫你把java安裝起來
2.安裝tomcat7
安裝時設定一個目錄名稱取名為tomcat7
此目錄 /tomcat7 相當於一般tomcat的/webapps
將想要部署的filename.war放在這，會自動部署產生對應之/filename目錄，之後war檔就不需要了
2.1相關設定檔放在 /var/packages/Tomcat7/target/src/conf

2.2如要加額外的jar檔，把檔案複製到這(記得chmod 644)

/var/packages/Tomcat7/target/src/lib

2.安裝MariaDB+phpMyAdmin

Synology DS214Play 安裝設定備忘 (Tomcat7+Javabridge)

2016-03-25T15:35:00.000+08:00

1.先安裝JavaManager套件

Java Manager可協助安裝java
要去下載像是這樣的檔案jdk-7u60-linux-i586.tar.gz 再上傳，它就會幫你把java安裝起來
2.安裝tomcat7
安裝時設定一個目錄名稱取名為tomcat7
此目錄 /tomcat7 相當於一般tomcat的/webapps
將想要部署的JavaBridge.war放在這，會自動部署產生對應之/JavaBridge目錄，之後war檔就不需要了。

2.1相關設定檔放在 /var/packages/Tomcat7/target/src/conf

2.2如要加額外的jar檔(JavaBridge.jar, php-servlet.jar and php-script.jar)
把檔案複製到這
/var/packages/Tomcat7/target/src/lib (記得chmod 644)

2.3 預設port7070 修改為 8080
/volume1/@appstore/Tomcat7/src/conf/server.xml

3.安裝MariaDB+phpMyAdmin

重啟DB
/usr/syno/bin/synopkg restart MariaDB

/etc/mysql/my.cnf
[mysqld]
skip-name-resolve

max_allowed_packet = 256M

SSLCertificateFile /etc/ssl/certs/www.tkcenter.com.crt
SSLCertificateKeyFile /etc/ssl/private/www.tkcenter.com.key

export PS1='\h:\w\$ '
export PS1='\[\033[1;31m\]\u@\h:\w\$\033[0m\] '
umask 022

# You may uncomment the following lines if you want `ls' to be colorized:
export LS_OPTIONS='--color=auto'
# eval "`dircolors`"
alias ls='ls $LS_OPTIONS'
alias ll='ls $LS_OPTIONS -l'
alias l='ls $LS_OPTIONS -lA'
#
# Some more alias to avoid making mistakes:
# alias rm='rm -i'
# alias cp='cp -i'
# alias mv='mv -i'

alias h='cd ~;ll'
alias u='cd ..'

alias aptg='apt-get install'
alias aptr='apt-get remove'
alias aptu='apt-get update'
alias aptc='apt-get clean'
alias apts='apt-cache search'

alias n='netstat -ntl'
alias df='df -BMB'

我的MacBook 初始設定

2016-03-25T15:33:00.000+08:00

顯示隱藏檔
command line:
defaults write com.apple.finder AppleShowAllFiles TRUE && killall Finder

顯示隱藏檔案：defaults write com.apple.finder AppleShowAllFiles TRUE;\killall Finder

不顯示隱藏檔案：defaults write com.apple.finder AppleShowAllFiles FALSE;\killall Finder

將iTunes備份移到別顆硬碟
/Users/使用者名稱/Music/iTunes/iTunes Media
/Users/使用者名稱/Library/Application Support/MobileSync

ln -s /Volumes/500G/MobileSync /Users/使用者名稱/Library/Application\ Support/MobileSync
ln -s /Volumes/500G/MobileSync /Users/vega/Library/Application\ Support/MobileSync

ln -s /Volumes/500G/iTunes\ Media/ ./iTunes\ Media
ln -s /Volumes/500G/iTunes\ Media/ /Users/vega/Music/iTunes/iTunes\ Media

MacOS Sierra
允許安裝任何來源

sudo spctl --master-disable

1. jdk.dmg
2. download tomcat
3. move tomcat folder to /usr/local
4. sudo ln -s /usr/local/tomcat /Library/Tomcat
5. sudo chown -R vega /Library/Tomcat
6. sudo chmod +x /Library/Tomcat/bin/*.sh
7. /Library/Tomcat/bin/startup.sh

1. apachectl start
/Library/WebServer/Documents

2. /etc/apache2/httpd.conf
#LoadModule php5_module libexec/apache2/libphp5.so
#LoadModule rewrite_module libexec/apache2/mod_rewrite.so
User 你的用戶名
Group staff

mysql

cd /var
mkdir mysql
cd mysql
ln -s /tmp/mysql.sock mysql.sock

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';

grant all privileges on *.* to 'vega'@'localhost' identified by 'vega' with grant option;
grant all privileges on *.* to 'vega'@'%' identified by 'vega' with grant option;
flush privileges;

.profile

export PS1='\[\033[1;31m\]\u@\h:\w\$\033[0m\] '

export PS1='\[\033[1;31m\]\u@\h:\w\$ \[\033[0m\]' #ubuntu works

umask 022

alias ls='ls -la'

alias ll='ls -la'

alias l='ls -lAa'

alias h='cd ~;ll'

alias u='cd ..'

alias n='netstat -ntl'

#alias df='df -BMB'

alias sudo='sudo -i'

.profile root

alias tomcaton='/usr/local/tomcat/bin/startup.sh'

alias tomcatoff='/usr/local/tomcat/bin/shutdown.sh'

Sublime Text 3 設定調校

2016-03-25T15:32:00.002+08:00

CMD+SHIFT+P

編輯Preferences.sublime-settings

{
"bold_folder_labels": true,
"caret_style": "phase",
"fade_fold_buttons": false,
"font_size": 15,
"highlight_line": true,
"ignored_packages":
[
"Vintage"
],
"line_padding_bottom": 1,
"line_padding_top": 1,
"tab_size": 2,
"translate_tabs_to_spaces": false,
"update_check": false,
"wide_caret": true

}

//key binding
{
"keys": ["ctrl+y"],
"command": "show_overlay",
"args": {
"overlay": "command_palette",
"text": "Snippet: "
}

}

Git on Synology Note

2016-03-25T15:29:00.001+08:00

Git on Synonogy Note

/volume1/git/project.git

初始化

git --bare init

chmod 700 config

chown -R git:users *

URL:ssh://git@ip:/volume1/git/project.git

建立新branch

git branch NewBranchName

切換branch

git checkout BranchName

merge

merge somebranch到master

在master下git merge somebranch

將二個branch所做的修改合併至master產生一個新的commit

*當master與somebranch處於同一個commit時，就可以把somebranch刪除

git branch -d somebranch

DELL R730 增加SSD CACHE

2015-04-21T09:27:00.000+08:00

找出SSD硬碟ID
esxcli storage core path list

1.esxcli storage nmp satp rule add --satp VMW_SATP_LOCAL --device naa.6b083fe0e8f4ad001c468d8a6c55f0bd --option=enable_ssd

2.esxcli storage nmp satp rule list | grep enable_ssd

3.esxcli storage core claiming reclaim -d naa.6b083fe0e8f4ad001c468d8a6c55f0bd

4.vim-cmd hostsvc/storage/refresh

Thunderbird 郵件備份相關

2014-11-04T09:40:00.002+08:00

1.於Thunderbird內建目錄 testfolder ，會產生 testfolder,testfolder.msf 二個檔案。
2.於Thunderbird內test下建子目錄並放入郵件，會產生test.sbd目錄(如裡面沒有郵件則不會產生)。
3.要移mail時copy test跟test.msf二個檔案，.msf檔不一定要有，會自動生成。

郵件檔位置
Thunderbird\Data\profile\Mail\Local Folders