프로그램 사용/VPN(PPTP)2018. 5. 12. 12:04

iptime vpn 제약?

공유기 성능에 따라 VPN 통신속도 1MB/s 정도로 제한되기도 한다고

[링크 : https://www.clien.net/service/board/kin/10024149]


PPTP설정시

1723/all

47/gre 설정이 되어야 한다는데

GRE는 머지?

[링크 : https://livingmethod.wordpress.com/2015/03/19/iptime-공유기에서-내부-pptp서버-운영하기/]


GRE 메카니즘을 쓰는데 프로토콜로서 정해지는게 아닌거 같은데 머지?

PPTP uses an enhanced GRE (Generic Routing Encapsulation) mechanism to provide a flow- and congestion-controlled encapsulated datagram service for carrying PPP packets. 

[링크 : https://tools.ietf.org/html/rfc2637]


+

일단 중요한건 이게 아니라..

설정이 잘못된건지 모르겠지만

VPN을 통해서 접속하고 포트 포워딩을 통해 80번 포트나 22번 포트를 돌려줘도 외부에서 접속이 되지 않는다.

접속 설정 문제인지, iptime VPN의 제한인진 확인필요



+

2018.05.14

EFM에 문의해보니 원격지 게이트웨이 문제인 것 같다고.

[링크 : http://iptime.com/iptime/?page_id=174&nType=...=]


다시 설정해서 route 목록을 확인해봐야겠다.

Routing

Once you have connected to your VPN, you should be able to interact with anything available on the VPN server. To access anything on the remote network, you need to add a new route to your routing table.


Note: Depending on your configuration, you may need to re-add the routing information every time you connect to your VPN.

For more information on how to add routes, you can read this article which has many more examples: PPTP Routing Howto


Split Tunneling

Packets with a destination of your VPN's network should be routed through the VPN interface (usually ppp0). To do this, you create the route:


# ip route add 192.168.10.0/24 dev ppp0

This will route all the traffic with a destination of 192.168.10.* through your VPN's interface, (ppp0).


Route All Traffic

It may be desirable to route all traffic through your VPN connection. You can do this by running:


# ip route add default dev ppp0 

[링크 : https://wiki.archlinux.org/index.php/PPTP_Client]


+

버전이 낮아서 버그가 있다 보니 그런건가..

100일 정도 리부팅 안하고 써서 맛이 간건가..

일단 한번 접속하고 끊으면 안 붙는 문제는 수정 된것 같으나

default remote gateway 문제인지 포트포워딩으로 접속이 안된다.

$ route

Kernel IP routing table

Destination     Gateway         Genmask         Flags Metric Ref    Use Iface

default         192.168.10.1    0.0.0.0         UG    100    0        0 eth0

125.177.70.133  192.168.10.1    255.255.255.255 UGH   0      0        0 eth0

link-local      *               255.255.0.0     U     1000   0        0 eth0

192.168.10.0    *               255.255.255.0   U     100    0        0 eth0

192.168.219.1   *               255.255.255.255 UH    0      0        0 ppp0


$ sudo poff SARANG


$ route

Kernel IP routing table

Destination     Gateway         Genmask         Flags Metric Ref    Use Iface

default         192.168.10.1    0.0.0.0         UG    100    0        0 eth0

125.177.70.133  192.168.10.1    255.255.255.255 UGH   0      0        0 eth0

link-local      *               255.255.0.0     U     1000   0        0 eth0

192.168.10.0    *               255.255.255.0   U     100    0        0 eth0 


저작자표시 (새창열림)

'프로그램 사용 > VPN(PPTP)' 카테고리의 다른 글

VPN / 웹서버 설정  (0) 2018.05.14
rpi vpn client 설치 및 설정!  (0) 2018.05.12
Posted by 구차니
프로그램 사용/VPN(PPTP)2018. 5. 12. 11:22

rpi vpn client 설치 및 설정!

실은 odroid에 한거임 ㅋㅋㅋ

$ sudo apt-get install openvpn 

인 줄 알았는데 굳이 이거 아니어도 되는건가?


아래는 좀 다시 내용을 봐야 할 듯..

$ sudo apt-get install pptp-linux 

[링크 : https://prosindo.com/blog/2015/08/24/vpn-pptp-client-on-raspberry-pi/]

+

2018.05.14

라즈베리에서 설치해보니 위에 패키지를 깔면 된다.

$ sudo apt-get install pptp-linux

Reading package lists... Done

Building dependency tree

Reading state information... Done

The following extra packages will be installed:

  ppp

The following NEW packages will be installed:

  ppp pptp-linux

0 upgraded, 2 newly installed, 0 to remove and 10 not upgraded.

Need to get 358 kB of archives.

After this operation, 859 kB of additional disk space will be used.

Do you want to continue? [Y/n]

+


$ sudo pptpsetup --create MYCONNECTION --server vpn.ourcompany.com --domain DOMAINNAME --username myname --password ******* --encrypt --start 

[링크 : https://www.raspberrypi.org/forums/viewtopic.php?t=123022]


+

주소와 계정은 임의로 변조함

$ sudo pptpsetup --create TUNN --server vpntest.minimonk.net --username pi --password raspberrypi --encrypt --start

Using interface ppp0

Connect: ppp0 <--> /dev/pts/9

CHAP authentication succeeded

MPPE 128-bit stateless compression enabled

local  IP address 192.168.219.205

remote IP address 192.168.219.1 


원격으로 접속해서 크롬으로 접속하다 보니 영어로 나옴.. -_-a

아무튼 VPN 상태에서 Connected로 뜸!!


전혀 다른 아이피와 전혀 다른 NIC으로 접속이 됨

$ ifconfig

eth0      Link encap:Ethernet  HWaddr 3a:02:dd:--:--:--

          inet addr:192.168.10.83  Bcast:192.168.10.255  Mask:255.255.255.0

          inet6 addr: fe80::3802:ddff:fe--:----/64 Scope:Link

          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

          RX packets:27646 errors:0 dropped:0 overruns:0 frame:0

          TX packets:12819 errors:0 dropped:0 overruns:0 carrier:0

          collisions:0 txqueuelen:1000

          RX bytes:35345850 (35.3 MB)  TX bytes:1348771 (1.3 MB)


lo        Link encap:Local Loopback

          inet addr:127.0.0.1  Mask:255.0.0.0

          inet6 addr: ::1/128 Scope:Host

          UP LOOPBACK RUNNING  MTU:65536  Metric:1

          RX packets:228 errors:0 dropped:0 overruns:0 frame:0

          TX packets:228 errors:0 dropped:0 overruns:0 carrier:0

          collisions:0 txqueuelen:0

          RX bytes:23139 (23.1 KB)  TX bytes:23139 (23.1 KB)


ppp0      Link encap:Point-to-Point Protocol

          inet addr:192.168.219.205  P-t-P:192.168.219.1  Mask:255.255.255.255

          UP POINTOPOINT RUNNING NOARP MULTICAST  MTU:1496  Metric:1

          RX packets:7 errors:0 dropped:0 overruns:0 frame:0

          TX packets:7 errors:0 dropped:0 overruns:0 carrier:0

          collisions:0 txqueuelen:3

          RX bytes:70 (70.0 B)  TX bytes:76 (76.0 B) 


$ ping 192.168.219.1

PING 192.168.219.1 (192.168.219.1) 56(84) bytes of data.

64 bytes from 192.168.219.1: icmp_seq=1 ttl=64 time=6.53 ms

64 bytes from 192.168.219.1: icmp_seq=2 ttl=64 time=7.12 ms

64 bytes from 192.168.219.1: icmp_seq=3 ttl=64 time=6.41 ms

^C

--- 192.168.219.1 ping statistics ---

3 packets transmitted, 3 received, 0% packet loss, time 2002ms

rtt min/avg/max/mdev = 6.417/6.693/7.129/0.325 ms 


$ ping 192.168.10.1

PING 192.168.10.1 (192.168.10.1) 56(84) bytes of data.

64 bytes from 192.168.10.1: icmp_seq=1 ttl=64 time=0.774 ms

64 bytes from 192.168.10.1: icmp_seq=2 ttl=64 time=0.892 ms

^C

--- 192.168.10.1 ping statistics ---

2 packets transmitted, 2 received, 0% packet loss, time 999ms

rtt min/avg/max/mdev = 0.774/0.833/0.892/0.059 ms


그런데.. 80번 포트 포워딩 해서 접속해보려고 하는데 이건 안되네..


+

$ pptpsetup --help

pptpsetup --create <TUNNEL> --server <SERVER> [--domain <DOMAIN>]

          --username <USERNAME> [--password <PASSWORD>]

          [--encrypt] [--start]


pptpsetup --delete <TUNNEL>


Options:


* the name you wish to use to refer to the tunnel (you choose it),

* the IP address or host name of the server,

* the authentication domain name (optional),

* the username you are to use,

* the password you are to use,

* whether encryption is required,

* whether to start the connection after configuration.


pptpsetup - Point-to-Point Tunneling Protocol setup


Copyright (C) 2006 Nelson Ferraz


pptpsetup comes with ABSOLUTELY NO WARRANTY; for details see source.

This is free software, and you are welcome to redistribute it

under certain conditions; see source for details. 


+

2018.05.14

터널 설정은 위에서 한 대로 pptpsetup을 이용하면되고

접속은

$ sudo pon TUNN 


+

접속 끊기는

$ sudo poff TUNN

[링크 : https://wiki.archlinux.org/index.php/PPTP_Client]


이상하게 접속이 안되는 경우가 있는데, 일단은 SD 메모리 불량으로 EXT 파일 경고가 뜨는거 봐서는

시스템이 엉겨서 그런 듯..

$ sudo pptpsetup --create TUNN ...

Using interface ppp0

Connect: ppp0 <--> /dev/pts/9

Modem hangup

Connection terminated. 


Ubuntu 14.04 에서는 커널 모듈 문제로 발생하는 경우도 있는 듯

[링크 : https://askubuntu.com/questions/269399/failed-to-connect-to-pptp-vpn-server-on-ubuntu]


+

접속 로그 보는 방법

# pon <TUNNEL> debug dump logfd 2 nodetach 

[링크 : https://wiki.archlinux.org/index.php/PPTP_Client]


해보니까.. debug랑 nodetach만 해도 된다.

저작자표시 (새창열림)

'프로그램 사용 > VPN(PPTP)' 카테고리의 다른 글

VPN / 웹서버 설정  (0) 2018.05.14
iptime vpn 제약?  (0) 2018.05.12
Posted by 구차니
프로그램 사용/ssh scp sftp2018. 5. 11. 18:53

rpi vpn client

웹서버 구축하고

iptime의 vpn서버 에 붙여서

내부 아이피로 연결 후

공유기에서포트 포워딩하면 되는걸려나?


+

2018.05.12 


음.. 일반 패키지는 아니고 빌드해야 하나?

[링크 : https://gist.github.com/superjamie/ac55b6d2c080582a3e64]

저작자표시 (새창열림)

'프로그램 사용 > ssh scp sftp' 카테고리의 다른 글

ssh remote port forwarding  (0) 2019.01.28
reverse SSH  (0) 2018.05.14
scp: ambiguous target 에러  (0) 2016.09.21
sshpass를 이용한 scp 암호 자동 입력  (0) 2016.09.19
ssh X11 forwarding 속도 향상  (0) 2015.09.24
Posted by 구차니
프로그램 사용/notepad++2018. 5. 9. 13:15

notepad++ 주석 삭제하기

코드에 주석이 많아서 보기 귀찮은 지라


1. 찾기 창에서 Mark로 간다음 책갈피 표시

2. 찾기-책깔피-모든책깔피삭제

[링크 : https://stackoverflow.com/.../is-there-a-way-to-delete-all-comments-in-a-file-using-notepad]



정규표현식 쓰는것도 있는데 조금 번거로워도 이게 기억하기 쉬운듯하다.

저작자표시 (새창열림)

'프로그램 사용 > notepad++' 카테고리의 다른 글

notepad++ multi line edit  (0) 2019.12.30
notepad++ for ubuntu?  (0) 2019.12.21
notepad++ 특정 라인 열도록 실행하기  (0) 2018.01.02
notepad++ 따옴표 자동완성 끄기  (0) 2017.12.10
notepad++ 줄순서 뒤바꾸기  (2) 2017.11.22
Posted by 구차니
프로그램 사용/autocad2018. 5. 1. 13:14

원 채우기

hatch 명령으로 채우면 됨


[링크 : https://knowledge.autodesk.com/.../GUID-EFAAB5F6-FE3C-4052-9E04-560AE6A8B814-htm.html]


donut도 있긴한데 내가 원하는 큰 점을 그리는 방법으로는

circle로 그리고 hatch로 채우는게 나을 듯(solid)

[링크 : https://blog.naver.com/comwj/130139793166]

저작자표시 (새창열림)

'프로그램 사용 > autocad' 카테고리의 다른 글

autocad web app 구동조건이 64bit 그리고?  (0) 2020.06.21
캐드 명령어 이것저것  (0) 2018.01.09
autocad 명령어  (0) 2018.01.08
autolisp  (0) 2014.03.17
AutoCad 2011 도움말 - 명령어  (0) 2014.01.17
Posted by 구차니
프로그램 사용/wiki2018. 4. 27. 13:27

mediawiki 다국어 지원(extension:translate)

요약하자면.. 기준 언어로 글을 쓰고

그걸 번역하면서 다국어 지원하는 개념이라 translate extension이 핵심이 된다.


그리고 사용자가 번역 페이지를 만들려면 권한이 필요한데

이 부분은 검색중..


---

아.. 이래서 UFO:AI 번역할때 웹에서 하도록 한거였나..

po 파일과 wiki를 연동가능해서?


It is also possible to export messages for translation in other off-line and on-line tools that accept the Gettext pofile format. 

[링크 : https://www.mediawiki.org/wiki/Help:Extension:Translate]


Usually you can't make translations without asking for permissions. Some wikis however have enabled translation to all users. You will quickly notice if you lack the rights to translate. If this is the case, contact a translation administrator of your wiki. Let's start with getting to the translation view.

  • 1a. Go to the Fréttinga page.
  • 2a. Click the "Translate this page" link (if it does not show up you don't have permission to translate). 

[링크 : https://www.mediawiki.org/wiki/Help:Extension:Translate/Translation_example]


비 로그인으로 해봐서 그런건가?

require_once "$IP/extensions/Translate/Translate.php";

$wgGroupPermissions['user']['translate'] = true;

$wgGroupPermissions['user']['translate-messagereview'] = true;

$wgGroupPermissions['user']['translate-groupreview'] = true;

$wgGroupPermissions['user']['translate-import'] = true;

$wgGroupPermissions['sysop']['pagetranslation'] = true;

$wgGroupPermissions['sysop']['translate-manage'] = true;


[링크 : https://www.mediawiki.org/wiki/Help:Extension:Translate/Configuration]

[링크 : https://www.mediawiki.org/wiki/Help:Extension:Translate/Page_translation_administration]

저작자표시 (새창열림)

'프로그램 사용 > wiki' 카테고리의 다른 글

mediawiki 다국어 설정?  (1) 2018.04.27
mediawiki 1.27.4 로그인 하이재킹 문제  (0) 2018.04.20
mediawiki upgrade 1.19(LTS) to ???  (0) 2018.04.20
mediawiki sql debug dump  (0) 2017.06.16
mediawiki 데이터 구조 - page / revision  (0) 2017.01.16
Posted by 구차니
프로그램 사용/wiki2018. 4. 27. 11:22

mediawiki 다국어 설정?

어느게 맞는건지 모르겠다

internationalize 인지

localize인지

multilingual인지 어느게

다국어 페이지를 지원하는건지 도통 감이 안온다



[링크 : https://www.mediawiki.org/wiki/Multilingual_MediaWiki] 오래된 문서

[링크 : https://www.mediawiki.org/wiki/Extension%3aTranslate] 얘가 그거라는데 암만봐도 구글 번역 붙이는 느낌?


internationalization?

[링크 : https://stackoverflow.com/./multilingual-mediawiki-installation-using-wiki-family-vs-single-multilingual-med]

[링크 : https://www.mediawiki.org/wiki/Category:Internationalization_extensions]

[링크 : https://www.mediawiki.org/wiki/Category:Localisation_extensions]


2018.04 언어 확장 번들

https://translatewiki.net/mleb/MediaWikiLanguageExtensionBundle-2018.04.tar.bz2 


추가하고 설정해줄 내용인데.. 확장만 해도 5가지를 깔아야 완성되는건가?

wfLoadExtension( 'Babel' );


wfLoadExtension( 'cldr' );


wfLoadExtension( 'CleanChanges' );

$wgCCTrailerFilter = true;

$wgCCUserFilter = false;

$wgDefaultUserOptions['usenewrc'] = 1;


wfLoadExtension( 'LocalisationUpdate' );

$wgLocalisationUpdateDirectory = "$IP/cache";


require_once "$IP/extensions/Translate/Translate.php";

$wgGroupPermissions['user']['translate'] = true;

$wgGroupPermissions['user']['translate-messagereview'] = true;

$wgGroupPermissions['user']['translate-groupreview'] = true;

$wgGroupPermissions['user']['translate-import'] = true;

$wgGroupPermissions['sysop']['pagetranslation'] = true;

$wgGroupPermissions['sysop']['translate-manage'] = true;

$wgTranslateDocumentationLanguageCode = 'qqq';

$wgExtraLanguageNames['qqq'] = 'Message documentation'; # No linguistic content. Used for documenting messages


wfLoadExtension( 'UniversalLanguageSelector' ); 


[링크 : https://www.mediawiki.org/wiki/MediaWiki_Language_Extension_Bundle]


+

쓰는게 구버전 위키라 그런지 에러 뱉네.. 퉤~

버전업을 해야하나.. ㅠㅠ

/var/www/html/mediawiki$ php index.php

PHP Fatal error:  Uncaught Exception: Babel is not compatible with the current MediaWiki core (version 1.27.4), it requires: >= 1.29.0.

UniversalLanguageSelector is not compatible with the current MediaWiki core (version 1.27.4), it requires: >= 1.29.0. in /var/www/html/mediawiki/includes/registration/ExtensionRegistry.php:222

Stack trace:

#0 /var/www/html/mediawiki/includes/registration/ExtensionRegistry.php(137): ExtensionRegistry->readFromQueue(Array)

#1 /var/www/html/mediawiki/includes/Setup.php(39): ExtensionRegistry->loadFromQueue()

#2 /var/www/html/mediawiki/includes/WebStart.php(137): require_once('/var/www/html/m...')

#3 /var/www/html/mediawiki/index.php(40): require('/var/www/html/m...')

#4 {main}

  thrown in /var/www/html/mediawiki/includes/registration/ExtensionRegistry.php on line 222 


위키피디아 가서 보니 흐음..

MediaWiki 1.32.0-wmf.1 (d5ae4d6)

2018년 4월 27일 (금) 05:59


Babel 1.11.0 (1230b4c) 2018년 4월 22일 (일) 05:15 GPL-2.0-or-later 사용자 지정 틀을 포함할 수 있는 바벨 유저박스 단을 만들 수 있도록 #babel 파서 함수를 추가합니다

CLDR 4.5.0 (4ef981f) 2018년 4월 14일 (토) 18:25 GPL-2.0-or-later CLDR 데이터에 따라 한 언어로 번역된 언어 이름을 제공하는 확장 기능

LocalisationUpdate 1.4.0 (6e07084) 2018년 4월 14일 (토) 12:45 GPL-2.0-or-later 번역된 메시지를 가능한 한 최신으로 유지합니다

UniversalLanguageSelector 2018-04-10 (5f153f0) 2018년 4월 25일 (수) 00:55 GPL-2.0-or-later 사용자에게 언어를 선택하고 언어 설정을 바꾸는 몇 가지 방법을 제공합니다 


[링크 : https://ko.wikipedia.org/wiki/특수:버전]



+

귀찮아서 1.30 받고

2018.04 언어팩 받고


설치하니 에러뿜뿜

$ php index.php

<!DOCTYPE html>

<html><head><title>Internal error - 130wiki</title><style>body { font-family: sans-serif; margin: 0; padding: 0.5em 2em; }</style></head><body>

<div class="errorbox">[b57e80505ebcc0c92c24ee07] 2018-04-27 03:02:49: Fatal exception of type MWException</div>

<!-- Set $wgShowExceptionDetails = true; at the bottom of LocalSettings.php to show detailed debugging information. --></body></html> 


고민해보니.. db 업데이트 안되서 그런거 같으니

$ sudo php maintenance/update.php 

이거 실행하고 나니 ok


상단에 한국어 버튼이 생기는데, 대문이 다른 언어로 추가되는건 아닌거 같고 UI가 다국어 지원하도록 변경된다.


글들이 다국어 지원하게 하려면 어떻게 해야하려나..

저작자표시 (새창열림)

'프로그램 사용 > wiki' 카테고리의 다른 글

mediawiki 다국어 지원(extension:translate)  (0) 2018.04.27
mediawiki 1.27.4 로그인 하이재킹 문제  (0) 2018.04.20
mediawiki upgrade 1.19(LTS) to ???  (0) 2018.04.20
mediawiki sql debug dump  (0) 2017.06.16
mediawiki 데이터 구조 - page / revision  (0) 2017.01.16
Posted by 구차니
프로그램 사용/Version Control2018. 4. 24. 16:02

우분투에서 GIT 사용방법

GIT 쓸 일이 없다 보니..

일단 리눅스에서 개발하면서 한번 써보면 파악이 되겠지 머..


$ apt-cache search git | grep ^git

git - fast, scalable, distributed revision control system

git-core - fast, scalable, distributed revision control system (obsolete) 

git-all - fast, scalable, distributed revision control system (all subpackages)


step 1. 패키지 설치(안되어 있다면)

$ sudo apt-get install git 


step 2. git 설정

$ git config --global user.name "이름"

$ git config --global user.email "이메일주소"

$ git config --global color.ui "auto" 


step 3. 설정 내용 확인

$ git config --list

user.name=이름

user.email=이메일주소

color.ui=auto

$ vi ~/.gitconfig

[user]

        name = 이름

        email = 이메일주소

[color]

        ui = auto 


step 4. 저장소 생성

$ mkdir git_repo

$ cd git_repo

~/src/git_repo$ git init
초기화: 빈 깃 저장소, 위치 /home/odroid/src/git_repo/.git/ 
$ ll
합계 12
drwxrwxr-x 3 odroid odroid 4096  4월 24 15:56 ./
drwxrwxr-x 5 odroid odroid 4096  4월 24 16:08 ../
drwxrwxr-x 7 odroid odroid 4096  4월 24 15:56 .git/
$ du -h
8.0K    ./.git/info
44K     ./.git/hooks
4.0K    ./.git/objects/info
4.0K    ./.git/objects/pack
12K     ./.git/objects
4.0K    ./.git/branches
4.0K    ./.git/refs/heads
4.0K    ./.git/refs/tags
12K     ./.git/refs
96K     ./.git
100K    .


step 5. 저장소 복제
$ mkdir test
$ cd test
$ git clone ~/src/git_repo/
'git_repo'에 복제합니다...
warning: 빈 저장소를 복제한 것처럼 보입니다.
완료. 


[링크 : http://devaom.com/?p=745]

[링크 : https://git-scm.com/book/ko/v2/Git-서버-프로토콜]



+

bare를 주면 .git 아래 생성될게 바로 생성되는건가?

$ git init --bare --shared

초기화: 빈 공유 깃 저장소, 위치 /home/odroid/src/tt/


$ ll

합계 40

drwxrwsr-x 7 odroid odroid 4096  4월 24 16:08 ./

drwxrwxr-x 5 odroid odroid 4096  4월 24 16:08 ../

-rw-rw-r-- 1 odroid odroid   23  4월 24 16:08 HEAD

drwxrwsr-x 2 odroid odroid 4096  4월 24 16:08 branches/

-rw-rw-r-- 1 odroid odroid  126  4월 24 16:08 config

-rw-rw-r-- 1 odroid odroid   73  4월 24 16:08 description

drwxrwsr-x 2 odroid odroid 4096  4월 24 16:08 hooks/

drwxrwsr-x 2 odroid odroid 4096  4월 24 16:08 info/

drwxrwsr-x 4 odroid odroid 4096  4월 24 16:08 objects/

drwxrwsr-x 4 odroid odroid 4096  4월 24 16:08 refs/


$ du -h

8.0K    ./info

44K     ./hooks

4.0K    ./objects/info

4.0K    ./objects/pack

12K     ./objects

4.0K    ./branches

4.0K    ./refs/heads

4.0K    ./refs/tags

12K     ./refs

96K     .


[링크 : https://git-scm.com/book/ko/v2/Git-서버-서버에-Git-설치하기]


+

shared가 정의되지 않으면 umask에 의해 나오는 결과로 생성하는 것으로 보인다.

근데.. shared만 설정하면 머가 되는진 모르겠네?

 

--shared[=(false|true|umask|group|all|world|everybody|0xxx)]

Specify that the Git repository is to be shared amongst several users. This allows users belonging to the same group to push into that repository. When specified, the config variable "core.sharedRepository" is set so that files and directories under $GIT_DIR are created with the requested permissions. When not specified, Git will use permissions reported by umask(2).

The option can have the following values, defaulting to group if no value is given:

umask (or false)

Use permissions reported by umask(2). The default, when --shared is not specified.

group (or true)

Make the repository group-writable, (and g+sx, since the git group may be not the primary group of all users). This is used to loosen the permissions of an otherwise safe umask(2) value. Note that the umask still applies to the other permission bits (e.g. if umask is 0022, using group will not remove read privileges from other (non-group) users). See 0xxx for how to exactly specify the repository permissions.

all (or world or everybody)

Same as group, but make the repository readable by all users.

0xxx

0xxx is an octal number and each file will have mode 0xxx. 0xxx will override users' umask(2) value (and not only loosen permissions as group and all does). 0640 will create a repository which is group-readable, but not group-writable or accessible to others. 0660 will create a repo that is readable and writable to the current user and group, but inaccessible to others.

By default, the configuration flag receive.denyNonFastForwards is enabled in shared repositories, so that you cannot force a non fast-forwarding push into it.

If you provide a directory, the command is run inside it. If this directory does not exist, it will be created.


[링크 : https://git-scm.com/docs/git-init#git-init---sharedfalsetrueumaskgroupallworldeverybody0xxx]


위에 기록을 보니..

SGID를 통해서 접근 통제를 하도록(그룹권한을 따름) rws로 설정된다.



+

git 혼자사용으로 검색

[링크 : http://www.internetmap.kr/entry/Simple-Guide-for-Git]


+

2018.04.26

git 콘솔 명령어 목록 모음

[링크 : https://github.com/jeonghwan-kim/git-usage]

저작자표시 (새창열림)

'프로그램 사용 > Version Control' 카테고리의 다른 글

git mv 와 log  (0) 2018.08.14
git mv  (0) 2018.08.13
svn 로그 수정 pre-revprop-change  (0) 2017.12.20
svn externals commit 제외하기  (0) 2017.12.10
svn externals 제약사항 (파일은 안됨)  (0) 2017.11.03
Posted by 구차니
프로그램 사용/wiki2018. 4. 20. 19:13

mediawiki 1.27.4 로그인 하이재킹 문제

캐시문제로 발생하는 것이니 끄면 된다고..

그런데 저거 켜놓고 로그인 되게 하려면 어떻게 해야 하려나...


$ sudo vi LocalSettings.php

## Shared memory settings

#$wgMainCacheType = CACHE_ACCEL;

$wgMainCacheType = CACHE_NONE;

$wgMemCachedServers = []; 


[링크 : https://stackoverflow.com/.../cant-log-in-to-mediawiki-canceled-as-a-precaution-against-session-hijacking]


+

php7-fpm 지워서 그런건가?


CACHE_ACCEL – APC, APCu, WinCache or XCache if available. Note: If using CACHE_ACCEL, increasing apc.shm_size may improve performance.

[링크 : https://www.mediawiki.org/wiki/Manual:$wgMainCacheType]

저작자표시 (새창열림)

'프로그램 사용 > wiki' 카테고리의 다른 글

mediawiki 다국어 지원(extension:translate)  (0) 2018.04.27
mediawiki 다국어 설정?  (1) 2018.04.27
mediawiki upgrade 1.19(LTS) to ???  (0) 2018.04.20
mediawiki sql debug dump  (0) 2017.06.16
mediawiki 데이터 구조 - page / revision  (0) 2017.01.16
Posted by 구차니
프로그램 사용/wiki2018. 4. 20. 15:00

mediawiki upgrade 1.19(LTS) to ???

걍.. 백업이 잘못되서

watchlist 관련 테이블이 복원이 안되서 그런 듯?

[링크 : https://www.mediawiki.org/wiki/Manual:Upgrading]



--

1.19는 LTS 구버전이다.


일단.. 1.19 이후에는 1.23과, 1.27 이 LTS로 존재하니..

1.19 -> 1.23 을 시도해보면 될 듯?


[링크 : https://en.wikipedia.org/wiki/MediaWiki_version_history]


구버전 다운로드

[링크 : https://releases.wikimedia.org/mediawiki/]



---

woobi 측

phpmyadmin 2.11.11

mysql 5.0.95



odroid u3

phpmyadmin 4.5.4

mariaddb 10.0.34



#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 21

[링크 : https://stackoverflow.com/.../1064-error-in-create-table-type-myisam]


You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=HEAP MAX_ROWS=25000'

[링크 : https://stackoverflow.com/.../mysql-server-version-for-the-right-syntax-to-use-near-type-heap-at-line-1]



+

phpmyadmin을 통하지 말고 그냥

phpmyadmin 에서 dump 한 다음 로컬에서 데이터 복구하고

sudo php maintenance/update.php 로 실행하니 끝

odroid@odroid_2:/var/www/html/mediawiki/maintenance$ sudo php update.php

MediaWiki 1.27.4 Updater


Your composer.lock file is up to date with current dependencies!

Going to run database updates for minimonk-mw_

Depending on the size of your database this may take a while!

Abort with control-c in the next five seconds (skip this countdown with --quick) ... 0

Turning off Content Handler DB fields for this part of upgrade.

...have ipb_id field in ipblocks table.

...have ipb_expiry field in ipblocks table.

...already have interwiki table

...indexes seem up to 20031107 standards.

...have rc_type field in recentchanges table.

...index new_name_timestamp already set on recentchanges table.

...have user_real_name field in user table.

...querycache table already exists.

...objectcache table already exists.

...categorylinks table already exists.

...have pagelinks; skipping old links table updates

...il_from OK

...have rc_ip field in recentchanges table.

...index PRIMARY already set on image table.

...have rc_id field in recentchanges table.

...have rc_patrolled field in recentchanges table.

...logging table already exists.

...have user_token field in user table.

...have wl_notificationtimestamp field in watchlist table.

...watchlist talk page rows already present.

...user table does not contain user_emailauthenticationtimestamp field.

...page table already exists.

...have log_params field in logging table.

...logging table has correct log_title encoding.

...have ar_rev_id field in archive table.

...have page_len field in page table.

...revision table does not contain inverse_timestamp field.

...have rev_text_id field in revision table.

...have rev_deleted field in revision table.

...have img_width field in image table.

...have img_metadata field in image table.

...have user_email_token field in user table.

...have ar_text_id field in archive table.

...page_namespace is already a full int (int(11)).

...ar_namespace is already a full int (int(11)).

...rc_namespace is already a full int (int(11)).

...wl_namespace is already a full int (int(11)).

...qc_namespace is already a full int (int(11)).

...log_namespace is already a full int (int(11)).

...have img_media_type field in image table.

...already have pagelinks table.

...image table does not contain img_type field.

...already have unique user_name index.

...user_groups table exists and is in current format.

...have ss_total_pages field in site_stats table.

...user_newtalk table already exists.

...transcache table already exists.

...have iw_trans field in interwiki table.

...wl_notificationtimestamp is already nullable.

...index times already set on logging table.

...have ipb_range_start field in ipblocks table.

...no page_random rows needed to be set

...have user_registration field in user table.

...templatelinks table already exists

...externallinks table already exists.

...job table already exists.

...have ss_images field in site_stats table.

...langlinks table already exists.

...querycache_info table already exists.

...filearchive table already exists.

...have ipb_anon_only field in ipblocks table.

...index rc_ns_usertext already set on recentchanges table.

...index rc_user_text already set on recentchanges table.

...have user_newpass_time field in user table.

...redirect table already exists.

...querycachetwo table already exists.

...have ipb_enable_autoblock field in ipblocks table.

...index pl_namespace on table pagelinks includes field pl_from.

...index tl_namespace on table templatelinks includes field tl_from.

...index il_to on table imagelinks includes field il_from.

...have rc_old_len field in recentchanges table.

...have user_editcount field in user table.

...page_restrictions table already exists.

...have log_id field in logging table.

...have rev_parent_id field in revision table.

...have pr_id field in page_restrictions table.

...have rev_len field in revision table.

...have rc_deleted field in recentchanges table.

...have log_deleted field in logging table.

...have ar_deleted field in archive table.

...have ipb_deleted field in ipblocks table.

...have fa_deleted field in filearchive table.

...have ar_len field in archive table.

...have ipb_block_email field in ipblocks table.

...index cl_sortkey on table categorylinks includes field cl_from.

...have oi_metadata field in oldimage table.

...index usertext_timestamp already set on archive table.

...index img_usertext_timestamp already set on image table.

...index oi_usertext_timestamp already set on oldimage table.

...have ar_page_id field in archive table.

...have img_sha1 field in image table.

...protected_titles table already exists.

...have ipb_by_text field in ipblocks table.

...page_props table already exists.

...updatelog table already exists.

...category table already exists.

...category table already populated.

...have ar_parent_id field in archive table.

...have user_last_timestamp field in user_newtalk table.

...protected_titles table has correct pt_title encoding.

...have ss_active_users field in site_stats table.

...ss_active_users user count set...

...have ipb_allow_usertalk field in ipblocks table.

...pl_namespace, tl_namespace, il_to indices are already UNIQUE.

...change_tag table already exists.

...tag_summary table already exists.

...valid_tag table already exists.

...user_properties table already exists.

...log_search table already exists.

...have log_user_text field in logging table.

...l10n_cache table already exists.

...index ls_field_val already set on log_search table.

...index change_tag_rc_tag already set on change_tag table.

...have rd_interwiki field in redirect table.

...transcache tc_time already converted.

...*_mime_minor fields are already long enough.

...iwlinks table already exists.

...index iwl_prefix_title_from already set on iwlinks table.

...have ul_value field in updatelog table.

...have iw_api field in interwiki table.

...iwl_prefix key doesn't exist.

...have cl_collation field in categorylinks table.

...categorylinks up-to-date.

...module_deps table already exists.

...ar_page_revid key doesn't exist.

...index ar_revid already set on archive table.

...ll_lang is up-to-date.

...user_last_timestamp is already nullable.

...index user_email already set on user table.

...up_property in table user_properties already modified by patch patch-up_property.sql.

...uploadstash table already exists.

...user_former_groups table already exists.

...index type_action already set on logging table.

...have rev_sha1 field in revision table.

...batch conversion of user_options: nothing to migrate. done.

...user table does not contain user_options field.

...have ar_sha1 field in archive table.

...index page_redirect_namespace_len already set on page table.

...have us_chunk_inx field in uploadstash table.

...have job_timestamp field in job table.

Adding index page_user_timestamp to table revision ...done.

Adding ipb_parent_block_id field to table ipblocks ...done.

Adding index ipb_parent_block_id to table ipblocks ...done.

Table category contains cat_hidden field. Dropping ...done.

Adding rev_content_format field to table revision ...done.

Adding rev_content_model field to table revision ...done.

Adding ar_content_format field to table archive ...done.

Adding ar_content_model field to table archive ...done.

Adding page_content_model field to table page ...done.

Content Handler DB fields should be usable now.

Table site_stats contains ss_admins field. Dropping ...done.

Table recentchanges contains rc_moved_to_title field. Dropping ...done.

Creating sites table ...done.

Adding fa_sha1 field to table filearchive ...done.

Adding job_token field to table job ...done.

Adding job_attempts field to table job ...done.

Adding us_props field to table uploadstash ...done.

Modifying ug_group field of table user_groups ...done.

Modifying ufg_group field of table user_former_groups ...done.

Adding index pp_propname_page to table page_props ...done.

Adding index img_media_mime to table image ...done.

Making iwl_prefix_title_from index non-UNIQUE ...done.

Adding index iwl_prefix_from_title to table iwlinks ...done.

Adding ar_id field to table archive ...done.

Adding el_id field to table externallinks ...done.

Adding rc_source field to table recentchanges ...done.

Adding index log_user_text_type_time to table logging ...done.

Adding index log_user_text_time to table logging ...done.

Adding page_links_updated field to table page ...done.

Adding user_password_expires field to table user ...done.

Adding pp_sortkey field to table page_props ...done.

Table recentchanges contains rc_cur_time field. Dropping ...done.

Adding index wl_user_notificationtimestamp to table watchlist ...done.

Adding page_lang field to table page ...done.

Adding pl_from_namespace field to table pagelinks ...done.

Adding tl_from_namespace field to table templatelinks ...done.

Adding il_from_namespace field to table imagelinks ...done.

Modifying img_major_mime field of table image ...done.

Modifying oi_major_mime field of table oldimage ...done.

Modifying fa_major_mime field of table filearchive ...done.

Making user_id unsigned int ...done.

Modifying rc_comment field of table recentchanges ...done.

Dropping table hitcounter ...done.

Table site_stats contains ss_total_views field. Dropping ...done.

Table page contains page_counter field. Dropping ...done.

Dropping table msg_resource_links ...done.

Dropping table msg_resource ...done.

Creating bot_passwords table ...done.

Adding wl_id field to table watchlist ...done.

Dropping cl_collation index from table categorylinks ...done.

Adding index cl_collation_ext to table categorylinks ...done.

...collations up-to-date.

...site_stats is populated...done.

Checking existence of old default messages...done.

Populating rev_len column

...doing rev_id from 13 to 212

...doing rev_id from 213 to 412

...doing rev_id from 413 to 612

...doing rev_id from 613 to 812

...doing rev_id from 813 to 1012

...doing rev_id from 1013 to 1212

...doing rev_id from 1213 to 1412

...doing rev_id from 1413 to 1612

...doing rev_id from 1613 to 1812

...doing rev_id from 1813 to 2012

...doing rev_id from 2013 to 2212

...doing rev_id from 2213 to 2412

Populating ar_len column

...archive table seems to be empty.

rev_len and ar_len population complete [0 revision rows, 0 archive rows].

Populating rev_sha1 column

...doing rev_id from 13 to 212

...doing rev_id from 213 to 412

...doing rev_id from 413 to 612

...doing rev_id from 613 to 812

...doing rev_id from 813 to 1012

...doing rev_id from 1013 to 1212

...doing rev_id from 1213 to 1412

...doing rev_id from 1413 to 1612

...doing rev_id from 1613 to 1812

...doing rev_id from 1813 to 2012

...doing rev_id from 2013 to 2212

...doing rev_id from 2213 to 2412

Populating ar_sha1 column

...archive table seems to be empty.

Populating ar_sha1 column legacy rows

rev_sha1 and ar_sha1 population complete [0 revision rows, 0 archive rows].

Populating img_sha1 field


Done 0 files in 0.0 seconds

Fixing protocol-relative entries in the externallinks table...

Done, 0 rows updated.

Populating fa_sha1 field from fa_storage_key


Done 0 files in 0.0 seconds

Updating *_from_namespace fields in links tables.

...doing page_id from 1 to 200

Purging caches...done.


Done in 5.2 s. 


[링크 : http://chongmoa.com/sql/630]

저작자표시 (새창열림)

'프로그램 사용 > wiki' 카테고리의 다른 글

mediawiki 다국어 설정?  (1) 2018.04.27
mediawiki 1.27.4 로그인 하이재킹 문제  (0) 2018.04.20
mediawiki sql debug dump  (0) 2017.06.16
mediawiki 데이터 구조 - page / revision  (0) 2017.01.16
mediawiki 다국어 확장 및 번역 확장  (0) 2017.01.10
Posted by 구차니

티스토리툴바