LOVAPI

How to run Jenkins under a different user in Linux [Redhat]
When I wanted to change the Jenkins user I first checked /etc/init.d/jenkins script.  There I found two important variables $JENKINS_CONFIG(=/etc/sysconfig/jenkins) and $JENKINS_USER. So if you want, you can change the JENKINS_USER variable in the /etc/init.d/jenkins file; but it is not the correct way to do.

To change the jenkins user, open the /etc/sysconfig/jenkins (in debian this file is created in /etc/default) and change the JENKINS_USER to whatever you want. Make sure that user exists in the system (you can check the user in the /etc/passwd file ).
**$JENKINS_USER="manula"**
Then change the ownership of the Jenkins home, Jenkins webroot and logs.
**chown -R manula:manula /var/lib/jenkins 
chown -R manula:manula /var/cache/jenkins
chown -R manula:manula /var/log/jenkins**
Then restarted the Jenkins jenkins and check the user has changed using a ps command 
/etc/init.d/jenkins restart
ps -ef | grep jenkins

https://stackoverflow.com/questions/6119774/ssh-to-aws-instance-without-key-pairs


B) Setup the necessary users and their passwords with

# sudo adduser USERNAME
# sudo passwd USERNAME
C) Edit /etc/ssh/sshd_config setting

PasswordAuthentication yes
D) Restart the ssh daemon with

# sudo service ssh restart

MSSQL 에서 SP 내용 알아내는 법


sp_helptext storedProcedureName

 * 주의사항
  sp_helptext 를 사용할 때는 DB 를 지정한 후에 사용해야 한다. 

공유기에 ftp pasv설정이 없으면 dmz로 바꾸시는게 거의 답입니다. (pasv가 서버->인터넷으로 tcp 1024-65535입니다....)

- 아마존 시큐리티그룹에 해당 IP Inbound 로 1024-65535 레인지 허용해야 함

**[UTF-8 로 변경하고 싶을때, nvarchar로 강제 캐스팅 ]**
` ... cast(HKAM.AM_CategoryName  AS nvarchar) as AM_CategoryName ...`


** [언어셋 지정하여 필드값 받아오기, 언어셋이 다른 상황에 정렬시 사용될 수 있음]**
`select AM_CategoryName COLLATE Korean_wansung_CI_AS  from  HK_AdminMenu`
ex) https://msdn.microsoft.com/en-us/library/ms184391.aspx

**[codepage 지정]**
`Response.CharSet="euc-kr"`
`Ression.codepage="949"`
`Response.codepage="949"`
`Response.ContentType="text/html;charset=euc-kr"`

`Response.CharSet="ascii"`
`Session.codepage="0"`
`Response.codepage="0"`
`Response.ContentType="text/html;charset=euc-kr"`

`Response.CharSet="utf-8"`
`Session.codepage="65001"`
`Response.codepage="65001"`
`Response.ContentType="text/html;charset=utf-8"`

**[nvarchar 사용]**
http://enoya.tistory.com/4
ex) insert into tbl_est values(N'쀍쀍')

http://stackoverflow.com/questions/24921694/how-do-you-share-drives-between-amazon-aws-instances

- 동일한 시큐리티 그룹에 445포트 인바운드 정책추가(내부 아이피로)
- 각 서버에서 내부 IP로 접근
- 접근 지정 계정 지정 및 해당 폴더 공유

http://www.iis.net/learn/get-started/whats-new-in-iis-8/iis-80-using-aspnet-35-and-aspnet-45

http://stackoverflow.com/questions/20323107/could-not-load-file-or-assembly-system-web-http-webhost-after-published-to-azure

1. IIS 설치 
http://www.orcsweb.com/blog/jamie-furr/manage-and-install-iis8-on-windows-2012-server-core/

2. 연결을 위해서 8172 포트가 열려야 함 (외부 방화벽 확인필)
http://serverfault.com/questions/240739/what-port-does-iis-7-use-to-connect-to-another-iis-server

3. 사용자 추가, 그룹 추가
$ net user {id} {pw} /add
$ net user  // 확인
$ net localgroup administrators {id} /add
$ net localgroup administrators // 확인
http://superuser.com/questions/515175/create-admin-user-from-command-line

http://docs.continuent.com/tungsten-replicator-2.2/deployment-amazonrds-rdsconfig.html


parameter group 변경하려면 read-only를 풀어야 한다 https://aws.amazon.com/ko/premiumsupport/knowledge-center/rds-read-replica/?nc1=h_ls

적용 후 다시 read-only를 켜야 정합성 문제가 발생하지 않음