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/

elephant.io - https://github.com/Wisembly/elephant.io

1. elephantio.php -  elephant.io 다운로드 src폴더 데이터에 대한 include 또는 require 파일 만들기

1. <?php
2. $___ELEPHANTIO_DIR = dirname(__FILE__);
3. require $___ELEPHANTIO_DIR.'/Client.php';
4. require $___ELEPHANTIO_DIR.'/AbstractPayload.php';
5. require $___ELEPHANTIO_DIR.'/EngineInterface.php';
6. require $___ELEPHANTIO_DIR.'/Engine/AbstractSocketIO.php';
7. require $___ELEPHANTIO_DIR.'/Engine/SocketIO/Session.php';
8. require $___ELEPHANTIO_DIR.'/Engine/SocketIO/Version1X.php';
9. require $___ELEPHANTIO_DIR.'/Exception/MalformedUrlException.php';
10. require $___ELEPHANTIO_DIR.'/Exception/ServerConnectionFailureException.php';
11. require $___ELEPHANTIO_DIR.'/Exception/SocketException.php';
12. require $___ELEPHANTIO_DIR.'/Exception/UnsupportedActionException.php';
13. require $___ELEPHANTIO_DIR.'/Exception/UnsupportedTransportException.php';
14. require $___ELEPHANTIO_DIR.'/Payload/Decoder.php';
15. require $___ELEPHANTIO_DIR.'/Payload/Encoder.php';
16. ?>

2. client.php

1. <?php
2. include 'lib/elephantio/elephantio.php';
3. /*
4. * Version1X arg2 Option : ['context'=>[], 'debug'=>false,'wait'=>100*1000,'timeout'=>ini_get("default_socket_timeout")];
5. */
6. $EIO = new ElephantIO\Client(
7. new ElephantIO\Engine\SocketIO\Version1X('http://127.0.0.1:8001',['timeout'=>5])
8. );
9. $EIO->initialize();
10. $EIO->emit('msgIn', array('data1','data2') );
11. $EIO->close();
12. ?>

3. nodejs server

1. var io = require('socket.io').listen(8001);
2. io.sockets.on('connection', function (socket){
3. socket.on('msgIn',function(msg){
4. console.log('Msg In : ',msg);
5. });
6. socket.on('disconnect', function(){
7. console.log('NOT USER DISCONNECT : ', socket.id);
8. });
9. });
11. /*
12. * debug
13. * Msg In : [ 'data1', 'data2' ]
14. * NOT USER DISCONNECT : NPmXDQpuVM9OFYl0AAAA
15. */

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.

Memcached는 써보았는데 Redis는 아직 테스트를 안해봐서 아래 설명만 우선링크

phpredis 설치방법은 아래 글 참조

http://opens.kr/53

세션 서버 사용 설명- https://github.com/nicolasff/phpredis#php-session-handler

phpredis can be used to store PHP sessions. To do this, configure session.save_handler andsession.save_path in your php.ini to tell phpredis where to store the sessions:

session.save_handler = redis
session.save_path = "tcp://host1:6379?weight=1, tcp://host2:6379?weight=2&timeout=2.5, tcp://host3:6379?weight=2"

php.ini에서 위에 처럼 config 수정하는 방법도 있고 소스상에서 ini_set 으로 하는 방법도 있다.

Sessions have a lifetime expressed in seconds and stored in the INI variable "session.gc_maxlifetime". You can change it with ini_set(). The session handler requires a version of Redis with the SETEXcommand (at least 2.0). phpredis can also connect to a unix domain socket: session.save_path = "unix:///var/run/redis/redis.sock?persistent=1&weight=1&database=0.

아래 처럼 테스트 하니까 잘 된다. 

1. <?php
2. ini_set('session.save_handler', 'redis');
3. ini_set('session.save_path', 'tcp://127.0.0.1:6379');
4. //unix sock의 경우 아래처럼 그리고 & 파라미터로 database등 지정할수있는듯함
5. //ini_set('session.save_path', 'unix:///var/run/redis/redis.sock?persistent=1&weight=1&database=0');
6. ?>

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 이상부터 가능함!