Gitlab - 如何解決 "No authentication methods configured on login page" ? (gitlab version : 8.11.2)

1. 安裝 postgresql-client-common & postgresql-client

$sudo apt-get install postgresql-client postgresql-client-common

2. 連線資料庫

$sudo gitlab-psql gitlabhq_production

PS. 可以用 sudo gitlab-psql -l 查看資料庫列表

3. 進入 client 界面後輸入：

UPDATE application_settings set signin_enabled=true;
\q
4. 重新啟動 gitlab

$sudo gitlab-ctl restart

Spotify - 解決 ubuntu 16.04 下無法播放本機檔案問題

1. Download Spotify Library

$wget https://github.com/ramedeiros/spotify_libraries/archive/master.zip

or

$git clone https://github.com/ramedeiros/spotify_libraries.git

2. Copy files to lib folder.

$cd spotify_libraries
$sudo cp lib* /usr/lib/x86_64-linux-gnu/

3. link library

$sudo ldconfig
$sudo ln -frs /usr/lib/x86_64-linux-gnu/libavutil.so.52.6.100 /usr/lib/x86_64-linux-gnu/libavutil.so.52
$sudo ln -frs /usr/lib/x86_64-linux-gnu/libavformat.so.54.36.100 /usr/lib/x86_64-linux-gnu/libavformat.so.54
$sudo ln -frs /usr/lib/x86_64-linux-gnu/libavcodec.so.54.71.100 /usr/lib/x86_64-linux-gnu/libavcodec.so.54

Reference :
1. https://community.spotify.com/t5/Desktop-Linux-Windows-Web-Player/Linux-Local-files-do-not-play-on-Ubuntu-16-04-SOLVED/td-p/1343831
2. https://github.com/ramedeiros/spotify_libraries