PHP | My Site

PHP解密AES

By My Site
Link: https://sskaje.me/2015/02/php-aes-encrypt-decrypt/

分析某客户端协议，发现如下代码：

      SecretKey localSecretKey = SecretKeySpec(paramArrayOfByte, "AES");
      Cipher localCipher = Cipher.getInstance("AES");
      localCipher.init(2, localSecretKey);
      byte[] arrayOfByte = localCipher.doFinal(paramArrayOfByte);

SecretKey localSecretKey = SecretKeySpec(paramArrayOfByte, "AES");

Cipher localCipher = Cipher.getInstance("AES");

localCipher.init(2, localSecretKey);

byte[] arrayOfByte = localCipher.doFinal(paramArrayOfByte);

这个和之前分析航旅纵横客户端时的代码类似，都是128位ECB。
当时只是用openssl看了看请求：

 openssl aes-128-ecb -d -in packet.aes -out packet.txt -a -K KEY_IN_HEX

1	openssl aes-128-ecb -d -in packet.aes -out packet.txt -a -K KEY_IN_HEX

于是参考mcrypt的文档，写了简单的代码实现上边Java代码里的AES 128 ECB加密解密

<?php
class aes_128_ecb
{
    protected function prepare_key($key)
    {
        $new_key = array_fill(0, 16, 0);
        for ($i=0; isset($key[$i]); $i++) {
            $new_key[$i % 16] ^= ord($key[$i]);
        }

        $key_text = '';
        foreach ($new_key as $c) {
            $key_text .= chr($c);
        }
        return $key_text;
    }

    public function decrypt($key, $cipher)
    {
        $key = $this->prepare_key($key);
        return rtrim(
            mcrypt_decrypt(
                MCRYPT_RIJNDAEL_128,
                $key,
                $cipher,
                MCRYPT_MODE_ECB,
                ''
            ),
            "\x00..\x1F"
        );
    }

    public function encrypt($key, $plain)
    {
        $key = $this->prepare_key($key);

        $pad_value = 16 - strlen($plain) % 16;
        if ($pad_value != 16) {
            $plain .= str_repeat(chr($pad_value), $pad_value);
        }

        return mcrypt_encrypt(
            MCRYPT_RIJNDAEL_128,
            $key,
            $plain,
            MCRYPT_MODE_ECB,
            mcrypt_create_iv(
                mcrypt_get_iv_size(MCRYPT_RIJNDAEL_128, MCRYPT_MODE_ECB),
                MCRYPT_DEV_URANDOM
            )
        );
    }
}

<?php

class aes_128_ecb

{

protected function prepare_key($key)

{

$new_key = array_fill(0, 16, 0);

for ($i=0; isset($key[$i]); $i++) {

$new_key[$i % 16] ^= ord($key[$i]);

}

$key_text = '';

foreach ($new_key as $c) {

$key_text .= chr($c);

}

return $key_text;

}

public function decrypt($key, $cipher)

{

$key = $this->prepare_key($key);

return rtrim(

mcrypt_decrypt(

MCRYPT_RIJNDAEL_128,

$key,

$cipher,

MCRYPT_MODE_ECB,

"\x00..\x1F"

);

}

public function encrypt($key, $plain)

{

$key = $this->prepare_key($key);

$pad_value = 16 - strlen($plain) % 16;

if ($pad_value != 16) {

$plain .= str_repeat(chr($pad_value), $pad_value);

}

return mcrypt_encrypt(

MCRYPT_RIJNDAEL_128,

$key,

$plain,

MCRYPT_MODE_ECB,

mcrypt_create_iv(

mcrypt_get_iv_size(MCRYPT_RIJNDAEL_128, MCRYPT_MODE_ECB),

MCRYPT_DEV_URANDOM

)

);

}

PHP解密AES by My Site: https://sskaje.me/2015/02/php-aes-encrypt-decrypt/

PHP ODBC Connect Cloudera Impala and Hive

By My Site
Link: https://sskaje.me/2014/07/php-odbc-connect-cloudera-impala-hive/

Environment

CentOS 5.5
PHP 5.3.10
(This article also works for PHP 5.3.3 on CentOS 6).

Dependencies

UnixODBC

UnixODBC can be installed from yum repo

yum install unixODBC unixODBC-devel

1	yum install unixODBC unixODBC-devel

I built a unixODBC 2.3.2 from source, installed to /usr/local/unixODBC

ODBC Connectors

Cloudera offers ODBC libs for both Hive and Impala:
http://www.cloudera.com/content/support/en/downloads/connectors/impala/impala-odbc-v2-5-15.html
http://www.cloudera.com/content/support/en/downloads/connectors/hive/hive-odbc-v2-5-9.html

Follow the install guide on urls above, only wget and yum –nogpgcheck localinstall xxx.rpm required.
Continue reading “PHP ODBC Connect Cloudera Impala and Hive” »

PHP ODBC Connect Cloudera Impala and Hive by My Site: https://sskaje.me/2014/07/php-odbc-connect-cloudera-impala-hive/

Incoming search terms:

Build Old PHP-ODBC from Source

By My Site
Link: https://sskaje.me/2014/07/build-php-odbc-source/

CentOS 5.5 + PHP 5.3.10, I’ve built the latest unixODBC 2.3.2 from source to /usr/local/unixODBC.

I need to add php-odbc to my php’s extension list, as what I did, phpize && configure && make, but error occurred:

# ./configure --with-unixODBC=/usr/local/unixODBC/ --with-php-config=/usr/local/php/bin/php-config 
...
checking for Adabas support... cp: cannot stat `/usr/local/lib/odbclib.a': No such file or directory
configure: error: ODBC header file '/usr/local/incl/sqlext.h' not found!

# ./configure --with-unixODBC=/usr/local/unixODBC/ --with-php-config=/usr/local/php/bin/php-config

...

checking for Adabas support... cp: cannot stat `/usr/local/lib/odbclib.a': No such file or directory

configure: error: ODBC header file '/usr/local/incl/sqlext.h' not found!

I tried to add ‘–with-adabas=no‘, but failed.

The solution is, DELETE all configs like

if test -z "$ODBC_TYPE"; then

1	if test -z "$ODBC_TYPE"; then

and leave the

if test -z "$ODBC_TYPE"; then
PHP_ARG_WITH(unixODBC,,
[  --with-unixODBC[=DIR]   Include unixODBC support [/usr/local]])

if test -z "$ODBC_TYPE"; then

PHP_ARG_WITH(unixODBC,,

[ --with-unixODBC[=DIR] Include unixODBC support [/usr/local]])

block in config.m4.

Then phpize, configure, make.

For pdo_odbc, configure may like

./configure --with-pdo-odbc=unixODBC,/usr/local/unixODBC/ --with-php-config=/usr/local/php/bin/php-config

1	./configure --with-pdo-odbc=unixODBC,/usr/local/unixODBC/ --with-php-config=/usr/local/php/bin/php-config

Build Old PHP-ODBC from Source by My Site: https://sskaje.me/2014/07/build-php-odbc-source/