opens.kr

PHP에서 Root 권한 계정으로 AD(Active Directory) 비밀번호 변경시 

AD의 이전 비밀번호 재사용 금지 정책 적용

<?php
function getPassword($sPassword) {
    $sPassword = '"' . $sPassword . '"';
    $nCount = strlen($sPassword);
    $sNewPassword = "";
    for ($i = 0; $i < $nCount; $i++) {
        $sNewPassword .= $sPassword[$i] . "\000";
    }
    return $sNewPassword;
}

$ctrl2012 = array(
    // LDAP_SERVER_POLICY_HINTS_OID for Windows 2012 and above
    "oid" => "1.2.840.113556.1.4.2239",
    "value" => sprintf("%c%c%c%c%c", 48, 3, 2, 1, 1)
);

$ctrl2008 = array(
    // LDAP_SERVER_POLICY_HINTS_DEPRECATED_OID for Windows 2008 R2 SP1 and above
    "oid" => "1.2.840.113556.1.4.2066",
    "value" => sprintf("%c%c%c%c%c", 48, 3, 2, 1, 1)
);

/******
** 윈도우 2012이상의 경우 $ctrl2012 사용
** 윈도우 2008의 경우 $ctrl2008 사용
*******/
if (!ldap_set_option($ldap_connection, LDAP_OPT_SERVER_CONTROLS, array($ctrl2008))) {
    echo "ERROR: Failed to set server controls";
}

$userdata["unicodePwd"] = getPassword('newPassword');
$result = ldap_mod_replace($ldap_connection, $dn , $userdata);
if (!$result) {
    echo "\nErrorNo : ".@ldap_errno($ldap_connection);
    echo "\nErrorMsg : ".@ldap_error($ldap_connection);
}else{
    echo 'OK';
}
?>

참고 해외 블로그 : http://laviefrugale.blogspot.kr/2013/01/enforcing-active-directory-password.html

MS  참고 자료 : https://msdn.microsoft.com/en-us/library/cc223320.aspx

프로시져 내부에 SELECT 구문이 여러개 있어서 output row을 여러개 받아야 할 경우 예시

1. 프로시져 ( MSSQL 기준 작성함...)

CREATE PROCEDURE [dbo].[spTest]
AS
BEGIN
SELECT TOP 2 log_id FROM testLog ;
SELECT TOP 2 log_id FROM testLog ;
END

2. PHP 코드

<?php
  $stmt = $conn->prepare("exec spTest");
  $stmt->execute();
  $results = array();
  do {
    $results[] = $stmt->fetchAll();
  }while ($stmt->nextRowset());
  print_r($results);
?>

3. 결과셋

Array
(
    [0] => Array
        (
            [0] => Array
                (
                    [log_id] => 1
                    [0] => 1
                )
           [1] => Array
                (
                    [log_id] => 2
                    [0] => 2
                )
        )
    [1] => Array
        (
            [0] => Array
                (
                    [log_id] => 1
                    [0] => 1
                )
            [1] => Array
                (
                    [log_id] => 2
                    [0] => 2
                )
        )
)

※ 위에 예시는 거의 사용할 일이 크게 없었으며....

   아래 참고사이트에 보면 나오듯이... 게시물에 total값 별도로 output 이나 리턴 받고.. 

   요청하는 범위에 게시물의 row 수를 받을때 사용하는 일이 더 많은 듯하다....

참고사이트 

http://trentrichardson.com/2011/08/10/making-sense-of-stored-procedures-with-php-pdo-and-sqlsrv/

http://www.joeyrivera.com/2009/using-mysql-stored-procedure-inout-and-recordset-w-php/

Github 주소

https://github.com/msgpack/msgpack-php

소스설치방법

$ wget https://github.com/msgpack/msgpack-php/zipball/master -O msgpack-php.zip
$ unzip msgpack-php.zip 
$ cd msgpack-msgpack-php-da24be3/
$ phpize
Configuring for:
PHP Api Version:         20121113
Zend Module Api No:      20121212
Zend Extension Api No:   220121212

$ ./configure
$ make && make install
Installing shared extensions:     /usr/lib64/php/modules/
Installing header files:          /usr/include/php/


$ cd /usr/lib64/php/modules/
$ ll | grep msgpack
-rwxr-xr-x 1 root root  388516 Sep 18 14:27 msgpack.so


##### php.conf 디렉토리에 맞게 ini 에 extension 등록하기! 안되면 php.ini등록해도됨
$ echo extension=msgpack.so > /etc/php.d/msgpack.ini 

##### 웹서버종류에 따라서 Apache Restart 또는 php-fpm restart
$ /etc/init.d/php-fpm restart

##### 최종확인
$ php -i | grep 'MessagePack Support'
MessagePack Support => enabled

<?php phpinfo() ?> 
MessagePack Support enabled
Session Support enabled
extension Version   0.5.6-dev
header Version  0.5.4
Directive   Local Value Master Value
msgpack.error_display   On  On
msgpack.illegal_key_insert  Off Off
msgpack.php_only    On  On

1. Redis List 데이터 사용 샘플소스

1. <?php
2. $redis = new Redis();
3. try {
4. $redis->connect('127.0.0.1', 6379, 2.5);//2.5 sec timeout
5. //Auth Password(redis.conf requirepass)
6. //$redis->auth('foobared');
7. } catch (Exception $e) {
8. exit( "Cannot connect to redis server : ".$e->getMessage() );
9. }
11. // //DB Select
12. if ( !$redis->select(0) ){
13. exit( "NOT DB Select");
14. }
16. $redis->delete('weblog:ws1');
17. //rPush 맨아래 배열로 입력
18. $redis->rPush('weblog:ws1', 'log1');
19. $redis->rPush('weblog:ws1', 'log2');
20. $redis->rPush('weblog:ws1', 'log3');
21. $redis->rPush('weblog:ws1', 'log4');
22. //lPush 첫번째 배열로 입력
23. $redis->lPush('weblog:ws1', 'log5');
24. //0~2번까지배열 가져오기
25. var_dump($redis->lRange('weblog:ws1', 0, 2));
26. //전체배열데이터 가져오기
27. var_dump($redis->lRange('weblog:ws1', 0, -1));
28. ?>

2. Redis 들어있는 데이터

3. 추가명령어 메뉴얼참조

- https://github.com/nicolasff/phpredis#lists

blPop, brPop - Remove and get the first/last element in a list

brpoplpush - Pop a value from a list, push it to another list and return it

lIndex, lGet - Get an element from a list by its index

lInsert - Insert an element before or after another element in a list

lLen, lSize - Get the length/size of a list

lPop - Remove and get the first element in a list

lPush - Prepend one or multiple values to a list

lPushx - Prepend a value to a list, only if the list exists

lRange, lGetRange - Get a range of elements from a list

lRem, lRemove - Remove elements from a list

lSet - Set the value of an element in a list by its index

lTrim, listTrim - Trim a list to the specified range

rPop - Remove and get the last element in a list

rpoplpush - Remove the last element in a list, append it to another list and return it (redis >= 1.1)

rPush - Append one or multiple values to a list

rPushx - Append a value to a list, only if the list exists

1. Redis Hash 데이터 사용 샘플 소스

1. <?php
2. $redis = new Redis();
3. try {
4. $redis->connect('127.0.0.1', 6379, 2.5);//2.5 sec timeout
5. //Auth Password(redis.conf requirepass)
6. //$redis->auth('foobared');
7. } catch (Exception $e) {
8. exit( "Cannot connect to redis server : ".$e->getMessage() );
9. }
11. // //DB Select
12. if ( !$redis->select(0) ){
13. exit( "NOT DB Select");
14. }
16. $redis->delete('user_list');
17. $redis->hSet('user_list', 'uid1', 1);
18. $redis->hSet('user_list', 'uid2', 2);
19. $redis->hSet('user_list', 'uid3', 3);
20. if ( $redis->hExists('user_list','uid1') ){
21. echo "uid1 : ".$redis->hGet('user_list','uid1')."\n";
22. }else{
23. echo 'NOT_DATA';
24. }
25. //여러개 HASH 데이터 한번에 입력
26. $redis->hMset('user_list', array('uid4' => 4, 'uid5' =>5));
27. //여러개 HASH 데이터를 한번에 가져옴
28. var_dump($redis->hMGet('user_list', array('uid4', 'uid5')));
29. var_dump($redis->hGetAll('user_list'));
30. /*
31. * Print
32. uid1 : 1
33. array(2) {
34. ["uid4"]=>
35. string(1) "4"
36. ["uid5"]=>
37. string(1) "5"
38. }
39. array(5) {
40. ["uid1"]=>
41. string(1) "1"
42. ["uid2"]=>
43. string(1) "2"
44. ["uid3"]=>
45. string(1) "3"
46. ["uid4"]=>
47. string(1) "4"
48. ["uid5"]=>
49. string(1) "5"
50. }
51. */
52. ?>

2. Redis 들어있는 데이터

3. 추가 명령어 메뉴얼 참조

- https://github.com/nicolasff/phpredis#hashes

hDel - Delete one or more hash fields

hExists - Determine if a hash field exists

hGet - Get the value of a hash field

hGetAll - Get all the fields and values in a hash

hIncrBy - Increment the integer value of a hash field by the given number

hIncrByFloat - Increment the float value of a hash field by the given amount

hKeys - Get all the fields in a hash

hLen - Get the number of fields in a hash

hMGet - Get the values of all the given hash fields

hMSet - Set multiple hash fields to multiple values

hSet - Set the string value of a hash field

hSetNx - Set the value of a hash field, only if the field does not exist

hVals - Get all the values in a hash

hScan - Scan a hash key for members

Connect와 기본 keys-and-strings 샘플자료

1. <?php
2. $redis = new Redis();
3. try {
4. $redis->connect('127.0.0.1', 6379, 2.5);//2.5 sec timeout
5. //Auth Password(redis.conf requirepass)
6. //$redis->auth('foobared');
7. } catch (Exception $e) {
8. exit( "Cannot connect to redis server : ".$e->getMessage() );
9. }
11. // //DB Select
12. if ( !$redis->select(0) ){
13. exit( "NOT DB Select");
14. }
16. $redis->set('key1','value1',10); //유효기간 10초
17. echo $redis->get('key1');
18. /*
19. * print : value1
20. */
21. ?>

자세한 명령어 사용법은 아래 메뉴얼참조

https://github.com/nicolasff/phpredis#keys-and-strings

Strings

append - Append a value to a key

bitcount - Count set bits in a string

bitop - Perform bitwise operations between strings

decr, decrBy - Decrement the value of a key

get - Get the value of a key

getBit - Returns the bit value at offset in the string value stored at key

getRange - Get a substring of the string stored at a key

getSet - Set the string value of a key and return its old value

incr, incrBy - Increment the value of a key

incrByFloat - Increment the float value of a key by the given amount

mGet, getMultiple - Get the values of all the given keys

mSet, mSetNX - Set multiple keys to multiple values

set - Set the string value of a key

setBit - Sets or clears the bit at offset in the string value stored at key

setex, psetex - Set the value and expiration of a key

setnx - Set the value of a key, only if the key does not exist

setRange - Overwrite part of a string at key starting at the specified offset

strlen - Get the length of the value stored in a key

Keys

del, delete - Delete a key

dump - Return a serialized version of the value stored at the specified key.

exists - Determine if a key exists

expire, setTimeout, pexpire - Set a key's time to live in seconds

expireAt, pexpireAt - Set the expiration for a key as a UNIX timestamp

keys, getKeys - Find all keys matching the given pattern

scan - Scan for keys in the keyspace (Redis >= 2.8.0)

migrate - Atomically transfer a key from a Redis instance to another one

move - Move a key to another database

object - Inspect the internals of Redis objects

persist - Remove the expiration from a key

randomKey - Return a random key from the keyspace

rename, renameKey - Rename a key

renameNx - Rename a key, only if the new key does not exist

type - Determine the type stored at key

sort - Sort the elements in a list, set or sorted set

ttl, pttl - Get the time to live for a key

restore - Create a key using the provided serialized value, previously obtained with dump.

http://redis.io/clients 

=> 공식 사이트 들어가보면  아래 두가지를 추천하는 듯함

Predis ☺ ★ Repository JoL1hAHN Mature and supported

phpredis ☺ ★ Repository yowgi This is a client written in C as a PHP module.

$ wget https://github.com/nicolasff/phpredis/zipball/master -O phpredis.zip
$ unzip phpredis.zip 
$ ll
drwxr-xr-x  5 root root   4096 Sep  3 04:27 nicolasff-phpredis-4c1f1bc

$ cd nicolasff-phpredis-4c1f1bc/
$ phpize 
Can't find PHP headers in /usr/include/php
The php-devel package is required for use of this command.

$ yum install php-devel #PHP devel 미설치시 설치하기!
$ phpize
Configuring for:
PHP Api Version:         20121113
Zend Module Api No:      20121212
Zend Extension Api No:   220121212

$ ./configure
$ make && make install
Installing shared extensions:     /usr/lib64/php/modules/

$ cd /usr/lib64/php/modules/
$ ll | grep redis
-rwxr-xr-x 1 root root  942112 Sep 16 12:11 redis.so

##### php.conf 디렉토리에 맞게 ini 에 extension 등록하기! 안되면 php.ini등록해도됨
$ echo extension=redis.so > /etc/php.d/redis.ini 


##### 웹서버종류에 따라서 Apache Restart 또는 php-fpm restart
$ /etc/init.d/php-fpm restart

##### 최종확인
$ php -i | grep 'Redis Version'
Redis Version => 2.2.5

<?php phpinfo() ?> 
redis
Redis Support => enabled
Redis Version => 2.2.5

Anonymous functions - http://php.net/manual/ro/functions.anonymous.php

있다는 것만 알지.. 사용하지 않았다.. 

그런데 구글링 중 괜찮은 활용 방법을 찾아서!! 왠지 jquery 하는듯한 느낌은 뭐지...;;

 - 특정 배열값 파싱하거나 재구성할때 for문 안돌리고 array_map 이용할때 괜찮은듯함.

예) http://stackoverflow.com/questions/13435747/how-can-i-remove-the-file-extension-from-each-string-in-a-php-array

1. <?php
3. # your array
4. $slike = array('1.jpg','253455.jpg','32.jpg','477.jpg');
6. # if you have PHP >= 5.3, I'd use this
7. $slike = array_map(function($e){
8. return pathinfo($e, PATHINFO_FILENAME);
9. }, $slike);
11. # if you have PHP <= 5.2, use this
12. $slike = array_map('pathinfo', $slike, array_fill(
13. 0, count($slike), PATHINFO_FILENAME
14. ));
16. # dump
17. print_r($slike);
18. /*print
19. Array
20. (
21. [0] => 1
22. [1] => 253455
23. [2] => 32
24. [3] => 477
25. )
26. */
27. ?>

※ 단 PHP 5.3 이상부터 가능함!

1. Cache-Control:
   no-store, no-cache, must-revalidate, post-check=0, pre-check=0
2. Connection:
   keep-alive
3. Content-Type:
   text/html; charset=UTF-8
4. Date:
   Fri, 29 Aug 2014 06:22:59 GMT
5. Expires:
   Thu, 19 Nov 1981 08:52:00 GMT
6. Pragma:
   no-cache
7. Server:
   nginx/1.6.1
8. Transfer-Encoding:
   chunked
9. X-Powered-By:
   PHP/5.5.15

※ X-Powered-By:PHP/5.5.15 삭제

vi /etc/php.ini

expose_php = Off <== OFF로 변경

※ Nginx 숨기기

http://wiki.nginx.org/HttpCoreModule#server_tokens

vi /etc/nginx/nginx.conf

server_tokens off; <==내용추가함

=> php와 nginx수정하였다면 php-fpm과 nginx 재시작해줘야됨

※ Nginx라는 서버이름을 바꾸고 싶을때

1. HttpHeadersMoreModule 추가모듈설치 하여서 셋팅

http://wiki.nginx.org/HttpHeadersMoreModule#Installation

※ 소스설치시 추가하면됨

./configure --prefix=/opt/nginx --add-module=/path/to/headers-more-nginx-module

※ set the Server output header 

    more_set_headers 'Server: my-server';

2. 컴파일전에 소스코드에서 해당내용 삭제 또는 변경 

http://forum.nginx.org/read.php?11,1646

vi /path/to/nginx-0.*/src/http/ngx_http_header_filter_module.c lines 48 and 49:

====================================================

static char ngx_http_server_string[] = "Server: nginx" CRLF;

static char ngx_http_server_full_string[] = "Server: " NGINX_VER CRLF;

====================================================

※ Apache 경우

vi /etc/httpd/conf/httpd.conf

ServerTokens Prod

ServerSignature Off

Linux uninxODBC SQL Server Native Client 11.0 한글문제 - http://www.opens.kr/35

※ SQL Server Native bind 처리도 문제있는 듯하다 ㅠㅠ

http://hbs.pe.kr/50113950707

http://connect.microsoft.com/SQLServer/feedback/details/521409/odbc-client-mssql-does-not-work-with-bound-parameters-in-subquery

※ FreeTDS bindValue 쓰면 되는 것 처럼 보이는 데 

    실제 SQL Server Profiler 해보면 prepare statement bind 안되어서 들어온다ㅠㅠ;;

PHP5.3/5.4/5.5 Yum 설치 - http://www.opens.kr/33  으로 PHP 설치 사용했다면

그냥 yum install php55w-mssql 만 설치하면 자동으로 설치가 다 된다.

1) 설치

$ yum install php55w-mssql
==================================================================================
 Package                               Arch                            Version                                  Repository                         Size
==================================================================================
Installing:
 php55w-mssql                          x86_64                          5.5.12-1.w6                     
Installing for dependencies:
 freetds                               x86_64                          0.91-2.el6               
 php55w-pdo                            x86_64                          5.5.12-1.w6              
 unixODBC                              x86_64                          2.2.14-12.el6_3  
Transaction Summary
==================================================================================
Install       4 Package(s)

2) 접속 테스트 아래 링크에 tsql / isql 이용해서 하면된다.

리눅스 unixODBC FreeTDS 설치 (MSSQL) - http://www.opens.kr/36

3) 글로벌 설정

$ vi /etc/freetds.conf
------------------------
[global]
tds version = 8.0
client charset = UTF-8
text size = 64512
timeout = 10
connect timeout = 10
------------------------

※ TDS protocol 버전정보와 자세한 옵션 정보는 아래 freetds 사이트 가이드 참조하면 된다.

http://www.freetds.org/userguide/choosingtdsprotocol.htm

http://www.freetds.org/userguide/

4) PHP PDO에서 접속예시 

$dsn = 'dblib:host=192.168.0.0;dbname=DBNAME';
$user = "user_id";
$password = "user_password";

try {
    $dbh = new PDO($dsn, $user, $password); 
} catch (PDOException $e) {
    echo $e->getMessage();
}
$sQuery = "select * from sysobjects where xtype = 'U'";
$sth =  $dbh->prepare($sQuery);
$sth->execute();
$result = $sth->fetchAll(PDO::FETCH_ASSOC);
print_r($result);