yii2-gii icon indicating copy to clipboard operation
yii2-gii copied to clipboard

Published 20 hours ago • verified publisher icon yiisoft

V2.0.4 Model Generator in Oracle error

Open ayurep opened this issue 8 years ago • 15 comments

V2.0.4 "Model Generator" in Oracle error (YII2 v2.0.6)

PHP Fatal Error – yii\base\ErrorException Maximum execution time of 120 seconds exceeded

V2.0.3 normal

Excuse me, is this the bug, or is it the problem for me.

ayurep avatar Aug 24 '15 08:08 ayurep

Could you provide Oracle version and database schema to reproduce the issue?

samdark avatar Aug 24 '15 08:08 samdark

Oracle 10g through OCI connection

            'dsn' => 'oci:dbname=smdb;charset=utf8',
            'username' => 'tgj',
            'password' => 'tgj123',
            'charset' => 'utf8',

I found that from the yii2 v2.0.4 and later versions are not normal use

yii2 v2.0.4 error tips

Database Exception – yii\db\Exception

SQLSTATE[01002]: Disconnect error: 3113 OCIStmtExecute: ORA-03113: end-of-file on communication channel
Process ID: 1204
Session ID: 144 Serial number: 886
(ext\pdo_oci\oci_statement.c:148)
The SQL being executed was: SELECT D.CONSTRAINT_NAME, C.COLUMN_NAME, C.POSITION, D.R_CONSTRAINT_NAME,
E.TABLE_NAME AS TABLE_REF, F.COLUMN_NAME AS COLUMN_REF,
C.TABLE_NAME
FROM ALL_CONS_COLUMNS C
INNER JOIN ALL_CONSTRAINTS D ON D.OWNER = C.OWNER AND D.CONSTRAINT_NAME = C.CONSTRAINT_NAME
LEFT JOIN ALL_CONSTRAINTS E ON E.OWNER = D.R_OWNER AND E.CONSTRAINT_NAME = D.R_CONSTRAINT_NAME
LEFT JOIN ALL_CONS_COLUMNS F ON F.OWNER = E.OWNER AND F.CONSTRAINT_NAME = E.CONSTRAINT_NAME AND F.POSITION = C.POSITION
WHERE C.OWNER = 'TGJ'
AND C.TABLE_NAME = 'T_TEL'
AND D.CONSTRAINT_TYPE = 'R'
ORDER BY D.CONSTRAINT_NAME, C.POSITION
Error Info: Array
(
    [0] => 01002
    [1] => 3113
    [2] => OCIStmtExecute: ORA-03113: end-of-file on communication channel
Process ID: 1204
Session ID: 144 Serial number: 886
 (ext\pdo_oci\oci_statement.c:148)
)
↵
Caused by: PDOException

SQLSTATE[01002]: Disconnect error: 3113 OCIStmtExecute: ORA-03113: end-of-file on communication channel
Process ID: 1204
Session ID: 144 Serial number: 886
(ext\pdo_oci\oci_statement.c:148)

in G:\AyurepSite\CCQY\basic204\vendor\yiisoft\yii2\db\Command.php at line 825

ayurep avatar Aug 24 '15 08:08 ayurep

yii2 v2.0.4 and later versions of the gii are v2.0.4，So guess is the problem of gii v2.0.4

yii2 v2.0-v2.0.3 normal

ayurep avatar Aug 24 '15 08:08 ayurep

should be fixed by https://github.com/yiisoft/yii2/issues/8843 already. note that this only works completely in 2.0.7-dev version of yii framework (https://github.com/yiisoft/yii2/issues/9415). Gii version should not matter much.

cebe avatar Aug 24 '15 09:08 cebe

Yiisoft/yii2#8843 I saw that v2.0.6 yii2 has been modified, but it is also a problem, the wrong tip for the top post. Now want to download to try your v2.0.7-dev, do not know there is no advanced template download, thank you!

ayurep avatar Aug 25 '15 01:08 ayurep

you can change your composer.json to require "yiisoft/yii2": ">2.0.6@dev", no need to download an application template.

cebe avatar Aug 25 '15 14:08 cebe

Has been updated to 2.0.7-dev, and the error is due to the problem of my running environment

Error PHP Notice – yii\base\ErrorException

Trying to get property of non-object

  1. in E:\TGJcn\Yii\SourceCode\vendor\yiisoft\yii2-gii\generators\model\Generator.php at line 536 527528529530531532533534535536537538539540541542543544545 } if ($multiple) { $key = Inflector::pluralize($key); } $name = $rawName = Inflector::id2camel($key, '_'); $i = 0; while (isset($table->columns[lcfirst($name)])) { $name = $rawName . ($i++); } while (isset($relations[$table->fullName][$name])) { $name = $rawName . ($i++); }
    return $name;
}

/**
 * Validates the [[db]] attribute.
 */

  1. in E:\TGJcn\Yii\SourceCode\vendor\yiisoft\yii2-gii\generators\model\Generator.php at line 536 – yii\base\ErrorHandler::handleError(8, 'Trying to get property of non-ob...', 'E:\TGJcn\Yii\SourceCode\vendor\y...', 536, ...) 530531532533534535536537538539540541542 } $name = $rawName = Inflector::id2camel($key, '_'); $i = 0; while (isset($table->columns[lcfirst($name)])) { $name = $rawName . ($i++); } while (isset($relations[$table->fullName][$name])) { $name = $rawName . ($i++); }

    return $name;

    }

  2. in E:\TGJcn\Yii\SourceCode\vendor\yiisoft\yii2-gii\generators\model\Generator.php at line 363 – yii\gii\generators\model\Generator::generateRelationName([], null, 'USERNAME', true) 357358359360361362363364365366367368369 $className1 = $this->generateClassName($table1); $table0Schema = $db->getTableSchema($table0); $table1Schema = $db->getTableSchema($table1);

    $link = $this->generateRelationLink([$fks[$table->primaryKey[1]][1] => $table->primaryKey[1]]);
$viaLink = $this->generateRelationLink([$table->primaryKey[0] => $fks[$table->primaryKey[0]][1]]);
$relationName = $this->generateRelationName($relations, $table0Schema, $table->primaryKey[1], true);
$relations[$table0Schema->fullName][$relationName] = [
    "return \$this->hasMany($className1::className(), $link)->viaTable('"
    . $this->generateTableName($table->name) . "', $viaLink);",
    $className1,
    true,
];

  3. in E:\TGJcn\Yii\SourceCode\vendor\yiisoft\yii2-gii\generators\model\Generator.php at line 462 – yii\gii\generators\model\Generator::generateManyManyRelations(yii\db\TableSchema, ['USERNAME' => ['BAIRONG_ADMINISTRATOR', 'USERNAME'], 'ROLENAME' => ['BAIRONG_ROLES', 'ROLENAME']], []) 456457458459460461462463464465466467468 }

            if (($fks = $this->checkPivotTable($table)) === false) {
            continue;
        }

        $relations = $this->generateManyManyRelations($table, $fks, $relations);
    }
}

return $relations;

    }

  4. in E:\TGJcn\Yii\SourceCode\vendor\yiisoft\yii2-gii\generators\model\Generator.php at line 183 – yii\gii\generators\model\Generator::generateRelations() 177178179180181182183184185186187188189 /**

    • @inheritdoc */ public function generate() { $files = []; $relations = $this->generateRelations(); $db = $this->getDbConnection(); foreach ($this->getTableNames() as $tableName) { // model : $modelClassName = $this->generateClassName($tableName); $queryClassName = ($this->generateQuery) ? $this->generateQueryClassName($modelClassName) : false; $tableSchema = $db->getTableSchema($tableName);

  5. in E:\TGJcn\Yii\SourceCode\vendor\yiisoft\yii2-gii\controllers\DefaultController.php at line 45 – yii\gii\generators\model\Generator::generate() 39404142434445464748495051 { $generator = $this->loadGenerator($id); $params = ['generator' => $generator, 'id' => $id]; if (isset($_POST['preview']) || isset($_POST['generate'])) { if ($generator->validate()) { $generator->saveStickyAttributes(); $files = $generator->generate(); if (isset($_POST['generate']) && !empty($_POST['answers'])) { $params['hasError'] = !$generator->save($files, (array) $_POST['answers'], $results); $params['results'] = $results; } else { $params['files'] = $files; $params['answers'] = isset($_POST['answers']) ? $_POST['answers'] : null;

  6. yii\gii\controllers\DefaultController::actionView('model')

  7. in E:\TGJcn\Yii\SourceCode\vendor\yiisoft\yii2\base\InlineAction.php at line 55 – call_user_func_array([yii\gii\controllers\DefaultController, 'actionView'], ['model'])

  8. in E:\TGJcn\Yii\SourceCode\vendor\yiisoft\yii2\base\Controller.php at line 151 – yii\base\InlineAction::runWithParams(['id' => 'model'])

  9. in E:\TGJcn\Yii\SourceCode\vendor\yiisoft\yii2\base\Module.php at line 455 – yii\base\Controller::runAction('view', ['id' => 'model'])

  10. in E:\TGJcn\Yii\SourceCode\vendor\yiisoft\yii2\web\Application.php at line 84 – yii\base\Module::runAction('gii/default/view', ['id' => 'model'])

  11. in E:\TGJcn\Yii\SourceCode\vendor\yiisoft\yii2\base\Application.php at line 375 – yii\web\Application::handleRequest(yii\web\Request)

  12. in E:\TGJcn\Yii\SourceCode\frontend\web\index.php at line 18 – yii\base\Application::run() 12131415161718 require(DIR . '/../../common/config/main-local.php'), require(DIR . '/../config/main.php'), require(DIR . '/../config/main-local.php') );

$application = new yii\web\Application($config); $application->run(); $_GET = [ 'id' => 'model', ];

$_POST = [ '_csrf' => 'YTF5QnNMMFUiYTd1QH1KFy1wLjsqHgVkCwAYMEo0diAXc097QjVDDw==', 'Generator' => [ 'tableName' => 'T_MART_PRICE1', 'modelClass' => 'TBASEMILL', 'ns' => 'app\models', 'baseClass' => 'yii\db\ActiveRecord', 'db' => 'db', 'useTablePrefix' => '0', 'generateRelations' => '1', 'generateLabelsFromComments' => '0', 'generateQuery' => '0', 'queryNs' => 'app\models', 'queryClass' => 'TBASEMILLQuery', 'queryBaseClass' => 'yii\db\ActiveQuery', 'enableI18N' => '0', 'messageCategory' => 'app', 'useSchemaName' => '1', 'template' => 'default', ], 'preview' => '', ];

$SERVER = [ 'PATH' => 'C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;d:\app\instantclient_12_1;d:\app\client\Administrator\product\12.1.0\client_1;d:\app\client\Administrator\product\12.1.0\client_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0;C:\Program Files\Microsoft SQL Server\110\Tools\Binn;C:\Program Files\Microsoft SQL Server\120\Tools\Binn;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn;C:\Program Files\Microsoft SQL Server\100\Tools\Binn;C:\Program Files\Microsoft SQL Server\100\DTS\Binn;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn;E:\Server\phpStudy\php56n;C:\ProgramData\ComposerSetup\bin;C:\Program Files\TortoiseSVN\bin;C:\Windows\system32\config\systemprofile.dnx\bin;C:\Program Files\Microsoft DNX\Dnvm;C:\Program Files (x86)\nodejs;C:\Program Files\Microsoft\Web Platform Installer;C:\Users\Administrator\AppData\Roaming\npm', 'SYSTEMROOT' => 'C:\Windows', 'COMSPEC' => 'C:\Windows\system32\cmd.exe', 'PATHEXT' => '.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC', 'WINDIR' => 'C:\Windows', 'PHP_FCGI_MAX_REQUESTS' => '1000', 'PHPRC' => 'E:/Server/phpStudy/php56n', 'FCGI_SHUTDOWN_EVENT' => '1916', 'SCRIPT_NAME' => '/index.php', 'REQUEST_URI' => '/gii/model', 'QUERY_STRING' => '', 'REQUEST_METHOD' => 'POST', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'REDIRECT_URL' => '/gii/model', 'REMOTE_PORT' => '37348', 'SCRIPT_FILENAME' => 'E:/TGJcn/Yii/SourceCode/frontend/web/index.php', 'SERVER_ADMIN' => '[email protected]', 'CONTEXT_DOCUMENT_ROOT' => 'E:/TGJcn/Yii/SourceCode/frontend/web', 'CONTEXT_PREFIX' => '', 'REQUEST_SCHEME' => 'http', 'DOCUMENT_ROOT' => 'E:/TGJcn/Yii/SourceCode/frontend/web', 'REMOTE_ADDR' => '127.0.0.1', 'SERVER_PORT' => '80', 'SERVER_ADDR' => '127.0.0.1', 'SERVER_NAME' => 'tgj', 'SERVER_SOFTWARE' => 'Apache/2.4.10 (Win32) OpenSSL/1.0.1i mod_fcgid/2.3.9', 'SERVER_SIGNATURE' => '', 'SystemRoot' => 'C:\Windows', 'HTTP_COOKIE' => 'PHPSESSID=i6eeeh88t5actvp3ur746mlus1; csrf=4976e6eb09482ca1c7046b16c8a01cd14fd6ef3721ff03f630c5f3055a9f6c64a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22CPN731zBLAWyYR51j1ar9xFuvB691ysZ%22%3B%7D', 'HTTP_ACCEPT_LANGUAGE' => 'zh-CN,zh;q=0.8,en;q=0.6,zh-TW;q=0.4', 'HTTP_ACCEPT_ENCODING' => 'gzip, deflate', 'HTTP_REFERER' => 'http://tgj/gii/model', 'CONTENT_TYPE' => 'application/x-www-form-urlencoded', 'HTTP_USER_AGENT' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.152 Safari/537.36', 'HTTP_ORIGIN' => 'http://tgj', 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,/;q=0.8', 'HTTP_CACHE_CONTROL' => 'max-age=0', 'CONTENT_LENGTH' => '724', 'HTTP_CONNECTION' => 'close', 'HTTP_HOST' => 'tgj', 'REDIRECT_STATUS' => '200', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => 1440563897.1117301, 'REQUEST_TIME' => 1440563897, ];

$_COOKIE = [ 'PHPSESSID' => 'i6eeeh88t5actvp3ur746mlus1', '_csrf' => '4976e6eb09482ca1c7046b16c8a01cd14fd6ef3721ff03f630c5f3055a9f6c64a:2:{i:0;s:5:"_csrf";i:1;s:32:"CPN731zBLAWyYR51j1ar9xFuvB691ysZ";}', ]; Yii Framework 2015-08-26, 12:38:52

Apache/2.4.10 (Win32) OpenSSL/1.0.1i mod_fcgid/2.3.9 Yii Framework/2.0.7-dev

ayurep avatar Aug 26 '15 04:08 ayurep

I tried the same thing and gave error , use centos 64x 7.1, with php- fpm oci8 and pdo , only when I select relations , the error occurs , try other driver would be the " apaoww \ oci8 " however sometimes it works , sometimes not and when works have to increase php timeout , but working even generates relations for example with name get01 () .. it would be in getProduct () true, but with the driver coming in yii2 , explodes this error, tested with 2.0.4 , 2.0.6 and 2.0.7 -dev

Thank you

havennow avatar Oct 07 '15 13:10 havennow

That was just fixed in master of Gii. Try updating.

samdark avatar Oct 07 '15 14:10 samdark

i try = yiisoft/yii2-gii (dev-master 3946123)

same error , follow code

PHP Notice – yii\base\ErrorException Trying to get property of non-object

1. in /var/www/guilherme/basic/vendor/yiisoft/yii2-gii/generators/model/Generator.php at line 622
613614615616617618619620621622623624625626627628629630631

        }
        if ($multiple) {
            $key = Inflector::pluralize($key);
        }
        $name = $rawName = Inflector::id2camel($key, '_');
        $i = 0;
        while (isset($table->columns[lcfirst($name)])) {
            $name = $rawName . ($i++);
        }
        while (isset($relations[$table->fullName][$name])) {
            $name = $rawName . ($i++);
        }

        return $name;
    }

    /**
     * Validates the [[db]] attribute.
     */

2. in /var/www/guilherme/basic/vendor/yiisoft/yii2-gii/generators/model/Generator.php at line 470 – yii\gii\generators\model\Generator::generateManyManyRelations()
464465466467468469470471472473474475476

                }

                if (($junctionFks = $this->checkJunctionTable($table)) === false) {
                    continue;
                }

                $relations = $this->generateManyManyRelations($table, $junctionFks, $relations);
            }
        }

        if ($this->generateRelations === self::RELATIONS_ALL_INVERSE) {
            return $this->addInverseRelations($relations);
        }

3. in /var/www/guilherme/basic/vendor/yiisoft/yii2-gii/generators/model/Generator.php at line 189 – yii\gii\generators\model\Generator::generateRelations()
183184185186187188189190191192193194195

    /**
     * @inheritdoc
     */
    public function generate()
    {
        $files = [];
        $relations = $this->generateRelations();
        $db = $this->getDbConnection();
        foreach ($this->getTableNames() as $tableName) {
            // model :
            $modelClassName = $this->generateClassName($tableName);
            $queryClassName = ($this->generateQuery) ? $this->generateQueryClassName($modelClassName) : false;
            $tableSchema = $db->getTableSchema($tableName);

4. in /var/www/guilherme/basic/vendor/yiisoft/yii2-gii/controllers/DefaultController.php at line 45 – yii\gii\generators\model\Generator::generate()
39404142434445464748495051

    {
        $generator = $this->loadGenerator($id);
        $params = ['generator' => $generator, 'id' => $id];
        if (isset($_POST['preview']) || isset($_POST['generate'])) {
            if ($generator->validate()) {
                $generator->saveStickyAttributes();
                $files = $generator->generate();
                if (isset($_POST['generate']) && !empty($_POST['answers'])) {
                    $params['hasError'] = !$generator->save($files, (array) $_POST['answers'], $results);
                    $params['results'] = $results;
                } else {
                    $params['files'] = $files;
                    $params['answers'] = isset($_POST['answers']) ? $_POST['answers'] : null;

5. in /var/www/guilherme/basic/vendor/yiisoft/yii2/base/InlineAction.php at line 55 – yii\gii\controllers\DefaultController::actionView()
6. in /var/www/guilherme/basic/vendor/yiisoft/yii2/base/InlineAction.php at line 55 – call_user_func_array:{/var/www/guilherme/basic/vendor/yiisoft/yii2/base/InlineAction.php:55}()
7. in /var/www/guilherme/basic/vendor/yiisoft/yii2/base/Controller.php at line 151 – yii\base\InlineAction::runWithParams()
8. in /var/www/guilherme/basic/vendor/yiisoft/yii2/base/Module.php at line 455 – yii\base\Controller::runAction()
9. in /var/www/guilherme/basic/vendor/yiisoft/yii2/web/Application.php at line 84 – yii\base\Module::runAction()
10. in /var/www/guilherme/basic/vendor/yiisoft/yii2/base/Application.php at line 375 – yii\web\Application::handleRequest()
11. in /var/www/guilherme/basic/web/index.php at line 12 – yii\base\Application::run()
6789101112


require(__DIR__ . '/../vendor/autoload.php');
require(__DIR__ . '/../vendor/yiisoft/yii2/Yii.php');

$config = require(__DIR__ . '/../config/web.php');

(new yii\web\Application($config))->run();

$_GET = [ 'r' => 'gii/default/view', 'id' => 'model', ];

$_POST = [ 'Generator' => [ 'tableName' => 'auth_assignment', 'modelClass' => 'AuthAssignment', 'ns' => 'app\models', 'baseClass' => 'yii\db\ActiveRecord', 'db' => 'db', 'useTablePrefix' => '0', 'generateRelations' => 'all', 'generateLabelsFromComments' => '0', 'generateQuery' => '0', 'queryNs' => 'app\models', 'queryClass' => 'AUTHEQuery', 'queryBaseClass' => 'yii\db\ActiveQuery', 'enableI18N' => '0', 'messageCategory' => 'app', 'useSchemaName' => '0', 'template' => 'default', ], 'preview' => '', ];

$SERVER = [ 'USER' => 'nobody', 'HOME' => '/', 'FCGI_ROLE' => 'RESPONDER', 'QUERY_STRING' => 'r=gii%2Fdefault%2Fview&id=model', 'REQUEST_METHOD' => 'POST', 'CONTENT_TYPE' => 'application/x-www-form-urlencoded', 'CONTENT_LENGTH' => '663', 'SCRIPT_NAME' => '/index.php', 'REQUEST_URI' => '/index.php?r=gii%2Fdefault%2Fview&id=model', 'DOCUMENT_URI' => '/index.php', 'DOCUMENT_ROOT' => '/var/www/guilherme/basic/web', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'SERVER_SOFTWARE' => 'nginx/1.6.3', 'REMOTE_ADDR' => '192.168.1.47', 'REMOTE_PORT' => '51890', 'SERVER_ADDR' => 'localhost', 'SERVER_PORT' => '8086', 'SERVER_NAME' => 'localhost', 'REDIRECT_STATUS' => '200', 'SCRIPT_FILENAME' => '/var/www/guilherme/basic/web/index.php', 'HTTP_HOST' => 'localhost:8086', 'HTTP_USER_AGENT' => 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:41.0) Gecko/20100101 Firefox/41.0', 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,/_;q=0.8', 'HTTP_ACCEPT_LANGUAGE' => 'pt-BR,pt;q=0.8,en-US;q=0.5,en;q=0.3', 'HTTP_ACCEPT_ENCODING' => 'gzip, deflate', 'HTTP_REFERER' => 'http://localhost:8086/index.php?r=gii%2Fdefault%2Fview&id=model', 'HTTP_CONNECTION' => 'keep-alive', 'HTTP_CONTENT_TYPE' => 'application/x-www-form-urlencoded', 'HTTP_CONTENT_LENGTH' => '663', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => 1444230828.5699201, 'REQUEST_TIME' => 1444230828, ];

Yii Framework

2015-10-07, 12:14:05

nginx/1.6.3

Yii Framework/2.0.7-dev

Configuration

#db.php

'yii\db\Connection', 'dsn' => 'oci:dbname=//ipdatabase/orcl', 'username' => 'user', 'password' => 'pass', ]; ``` Application Configuration Name Value Yii Version 2.0.7-dev Application Name My Application Environment dev Debug Mode Yes Installed Extensions Name Value apaoww/yii2-oci8 9999999-dev yiisoft/yii2-bootstrap 9999999-dev yiisoft/yii2-codeception 9999999-dev yiisoft/yii2-debug 9999999-dev yiisoft/yii2-faker 9999999-dev yiisoft/yii2-gii 9999999-dev yiisoft/yii2-swiftmailer 9999999-dev PHP Configuration Name Value PHP Version 5.6.13 Xdebug Enabled APC Enabled Memcache Enabled PHP logo PHP Version 5.6.13 System Linux serv-centos.guilherme 3.10.0-229.14.1.el7.x86_64 #1 SMP Tue Sep 15 15:05:51 UTC 2015 x86_64 Build Date Sep 3 2015 14:10:02 Server API FPM/FastCGI Virtual Directory Support disabled Configuration File (php.ini) Path /etc Loaded Configuration File /etc/php.ini Scan this dir for additional .ini files /etc/php.d Additional .ini files parsed /etc/php.d/10-opcache.ini, /etc/php.d/10-zendguardloader.ini, /etc/php.d/20-bz2.ini, /etc/php.d/20-calendar.ini, /etc/php.d/20-ctype.ini, /etc/php.d/20-curl.ini, /etc/php.d/20-dom.ini, /etc/php.d/20-exif.ini, /etc/php.d/20-fileinfo.ini, /etc/php.d/20-ftp.ini, /etc/php.d/20-gd.ini, /etc/php.d/20-gettext.ini, /etc/php.d/20-iconv.ini, /etc/php.d/20-mbstring.ini, /etc/php.d/20-mcrypt.ini, /etc/php.d/20-mysqlnd.ini, /etc/php.d/20-oci8.ini, /etc/php.d/20-pdo.ini, /etc/php.d/20-phar.ini, /etc/php.d/20-posix.ini, /etc/php.d/20-shmop.ini, /etc/php.d/20-simplexml.ini, /etc/php.d/20-sockets.ini, /etc/php.d/20-sqlite3.ini, /etc/php.d/20-sysvmsg.ini, /etc/php.d/20-sysvsem.ini, /etc/php.d/20-sysvshm.ini, /etc/php.d/20-tokenizer.ini, /etc/php.d/20-xml.ini, /etc/php.d/20-xmlwriter.ini, /etc/php.d/20-xsl.ini, /etc/php.d/30-mysql.ini, /etc/php.d/30-mysqli.ini, /etc/php.d/30-pdo_mysql.ini, /etc/php.d/30-pdo_oci.ini, /etc/php.d/30-pdo_sqlite.ini, /etc/php.d/30-wddx.ini, /etc/php.d/30-xmlreader.ini, /etc/php.d/40-apcu.ini, /etc/php.d/40-igbinary.ini, /etc/php.d/40-json.ini, /etc/php.d/40-memcache.ini, /etc/php.d/40-msgpack.ini, /etc/php.d/40-sqlite.ini, /etc/php.d/40-zip.ini, /etc/php.d/50-memcached.ini PHP API 20131106 PHP Extension 20131226 Zend Extension 220131226 Zend Extension Build API220131226,NTS PHP Extension Build API20131226,NTS Debug Build no Thread Safety disabled Zend Signal Handling disabled Zend Memory Manager enabled Zend Multibyte Support provided by mbstring IPv6 Support enabled DTrace Support enabled Registered PHP Streams https, ftps, compress.zlib, php, file, glob, data, http, ftp, compress.bzip2, phar, zip Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls, tlsv1.0, tlsv1.1, tlsv1.2 Registered Stream Filters zlib._, string.rot13, string.toupper, string.tolower, string.strip_tags, convert._, consumed, dechunk, bzip2._, convert.iconv._, mcrypt._, mdecrypt._ Zend logo This program makes use of the Zend Scripting Language Engine: Zend Engine v2.6.0, Copyright (c) 1998-2015 Zend Technologies with Xdebug v2.3.2, Copyright (c) 2002-2015, by Derick Rethans with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2015, by Zend Technologies with Zend Guard Loader v3.3, Copyright (c) 1998-2014, by Zend Technologies Configuration apc APC support Emulated apcu APCu Support Enabled Version 4.0.7 APCu Debugging Disabled MMAP Support Enabled MMAP File Mask /tmp/apc.oaNw6C Serialization Support php, igbinary Revision $Revision: 328290 $ Build Date Jun 9 2015 15:07:00 Directive Local Value Master Value apc.coredump_unmap Off Off apc.enable_cli Off Off apc.enabled On On apc.entries_hint 4096 4096 apc.gc_ttl 3600 3600 apc.mmap_file_mask /tmp/apc.oaNw6C /tmp/apc.oaNw6C apc.preload_path no value no value apc.rfc1867 Off Off apc.rfc1867_freq 0 0 apc.rfc1867_name APC_UPLOAD_PROGRESS APC_UPLOAD_PROGRESS apc.rfc1867_prefix upload_ upload_ apc.rfc1867_ttl 3600 3600 apc.serializer php php apc.shm_segments 1 1 apc.shm_size 32M 32M apc.slam_defense On On apc.smart 0 0 apc.ttl 0 0 apc.use_request_time On On apc.writable /tmp /tmp bz2 BZip2 Support Enabled Stream Wrapper support compress.bzip2:// Stream Filter support bzip2.decompress, bzip2.compress BZip2 Version 1.0.6, 6-Sept-2010 calendar Calendar support enabled cgi-fcgi php-fpm active Directive Local Value Master Value cgi.discard_path 0 0 cgi.fix_pathinfo 0 0 cgi.force_redirect 1 1 cgi.nph 0 0 cgi.redirect_status_env no value no value cgi.rfc2616_headers 0 0 fastcgi.error_header no value no value fastcgi.logging 1 1 fpm.config no value no value Core PHP Version 5.6.13 Directive Local Value Master Value allow_url_fopen On On allow_url_include Off Off always_populate_raw_post_data 0 0 arg_separator.input & & arg_separator.output & & asp_tags Off Off auto_append_file no value no value auto_globals_jit On On auto_prepend_file no value no value browscap no value no value default_charset UTF-8 UTF-8 default_mimetype text/html text/html disable_classes no value no value disable_functions no value no value display_errors Off Off display_startup_errors Off Off doc_root no value no value docref_ext no value no value docref_root no value no value enable_dl Off Off enable_post_data_reading On On error_append_string no value no value error_log /var/log/php-fpm/www-error.log /var/log/php-fpm/www-error.log error_prepend_string no value no value error_reporting 22527 22527 exit_on_timeout Off Off expose_php On On extension_dir /usr/lib64/php/modules /usr/lib64/php/modules file_uploads On On highlight.comment #FF8000 #FF8000 highlight.default #0000BB #0000BB highlight.html #000000 #000000 highlight.keyword #007700 #007700 highlight.string #DD0000 #DD0000 html_errors On On ignore_repeated_errors Off Off ignore_repeated_source Off Off ignore_user_abort Off Off implicit_flush Off Off include_path .:/usr/share/pear:/usr/share/php .:/usr/share/pear:/usr/share/php input_encoding no value no value internal_encoding no value no value log_errors On On log_errors_max_len 1024 1024 mail.add_x_header On On mail.force_extra_parameters no value no value mail.log no value no value max_execution_time 300 300 max_file_uploads 20 20 max_input_nesting_level 64 64 max_input_time 60 60 max_input_vars 1000 1000 memory_limit 256M 256M open_basedir no value no value output_buffering 4096 4096 output_encoding no value no value output_handler no value no value post_max_size 8M 8M precision 14 14 realpath_cache_size 16K 16K realpath_cache_ttl 120 120 register_argc_argv Off Off report_memleaks On On report_zend_debug On On request_order GP GP sendmail_from no value no value sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i serialize_precision 17 17 short_open_tag Off Off SMTP localhost localhost smtp_port 25 25 sql.safe_mode Off Off sys_temp_dir no value no value track_errors Off Off unserialize_callback_func no value no value upload_max_filesize 2M 2M upload_tmp_dir no value no value user_dir no value no value user_ini.cache_ttl 300 300 user_ini.filename .user.ini .user.ini variables_order GPCS GPCS xmlrpc_error_number 0 0 xmlrpc_errors Off Off zend.detect_unicode On On zend.enable_gc On On zend.multibyte Off Off zend.script_encoding no value no value ctype ctype functions enabled curl cURL support enabled cURL Information 7.29.0 Age 3 Features AsynchDNS Yes CharConv No Debug No GSS-Negotiate Yes IDN Yes IPv6 Yes krb4 No Largefile Yes libz Yes NTLM Yes NTLMWB Yes SPNEGO No SSL Yes SSPI No TLS-SRP No Protocols dict, file, ftp, ftps, gopher, http, https, imap, imaps, ldap, ldaps, pop3, pop3s, rtsp, scp, sftp, smtp, smtps, telnet, tftp Host x86_64-redhat-linux-gnu SSL Version NSS/3.15.4 ZLib Version 1.2.7 libSSH Version libssh2/1.4.3 date date/time support enabled "Olson" Timezone Database Version 0.system Timezone Database internal Default timezone America/Sao_Paulo Directive Local Value Master Value date.default_latitude 31.7667 31.7667 date.default_longitude 35.2333 35.2333 date.sunrise_zenith 90.583333 90.583333 date.sunset_zenith 90.583333 90.583333 date.timezone America/Sao_Paulo America/Sao_Paulo dom DOM/XML enabled DOM/XML API Version 20031129 libxml Version 2.9.1 HTML Support enabled XPath Support enabled XPointer Support enabled Schema Support enabled RelaxNG Support enabled ereg Regex Library Bundled library enabled exif EXIF Support enabled EXIF Version 1.4 $Id: a0425de51ec3270d01522bf62d41bfe78893f78d $ Supported EXIF Version 0220 Supported filetypes JPEG,TIFF Directive Local Value Master Value exif.decode_jis_intel JIS JIS exif.decode_jis_motorola JIS JIS exif.decode_unicode_intel UCS-2LE UCS-2LE exif.decode_unicode_motorola UCS-2BE UCS-2BE exif.encode_jis no value no value exif.encode_unicode ISO-8859-15 ISO-8859-15 fileinfo fileinfo support enabled version 1.0.5 libmagic 517 filter Input Validation and Filtering enabled Revision $Id: 86120bba568c551914a35636ec408f1e7e66af32 $ Directive Local Value Master Value filter.default unsafe_raw unsafe_raw filter.default_flags no value no value ftp FTP support enabled gd GD Support enabled GD headers Version 2.1.1 GD library Version 2.1.1 FreeType Support enabled FreeType Linkage with freetype FreeType Version 2.4.11 T1Lib Support enabled GIF Read Support enabled GIF Create Support enabled JPEG Support enabled libJPEG Version 6b PNG Support enabled libPNG Version 1.5.13 WBMP Support enabled XPM Support enabled libXpm Version 30411 XBM Support enabled WebP Support enabled Directive Local Value Master Value gd.jpeg_ignore_warning 0 0 gettext GetText Support enabled hash hash support enabled Hashing Engines md2 md4 md5 sha1 sha224 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost gost-crypto adler32 crc32 crc32b fnv132 fnv1a32 fnv164 fnv1a64 joaat haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5 iconv iconv support enabled iconv implementation glibc iconv library version 2.17 Directive Local Value Master Value iconv.input_encoding no value no value iconv.internal_encoding no value no value iconv.output_encoding no value no value igbinary igbinary support enabled igbinary version 1.2.1 igbinary APCU serializer ABI 0 igbinary session support yes Directive Local Value Master Value igbinary.compact_strings On On json json support enabled json version 1.3.9 JSON-C version (bundled) 0.11 libxml libXML support active libXML Compiled Version 2.9.1 libXML Loaded Version 20901 libXML streams enabled mbstring Multibyte Support enabled Multibyte string engine libmbfl HTTP input encoding translation disabled libmbfl version 1.3.2 mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1. Multibyte (japanese) regex support enabled Multibyte regex (oniguruma) backtrack check On Multibyte regex (oniguruma) version 5.9.5 Directive Local Value Master Value mbstring.detect_order no value no value mbstring.encoding_translation Off Off mbstring.func_overload 0 0 mbstring.http_input no value no value mbstring.http_output no value no value mbstring.http_output_conv_mimetypes ^(text/|application/xhtml+xml) ^(text/|application/xhtml+xml) mbstring.internal_encoding no value no value mbstring.language neutral neutral mbstring.strict_detection Off Off mbstring.substitute_character no value no value mcrypt mcrypt support enabled mcrypt_filter support enabled Version 2.5.8 Api No 20021217 Supported ciphers cast-128 gost rijndael-128 twofish arcfour cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes Supported modes cbc cfb ctr ecb ncfb nofb ofb stream Directive Local Value Master Value mcrypt.algorithms_dir no value no value mcrypt.modes_dir no value no value memcache memcache support enabled Version 3.0.8 Revision $Revision: 329835 $ Directive Local Value Master Value memcache.allow_failover 1 1 memcache.chunk_size 32768 32768 memcache.compress_threshold 20000 20000 memcache.default_port 11211 11211 memcache.hash_function crc32 crc32 memcache.hash_strategy consistent consistent memcache.lock_timeout 15 15 memcache.max_failover_attempts 20 20 memcache.protocol ascii ascii memcache.redundancy 1 1 memcache.session_redundancy 2 2 memcached memcached support enabled Version 2.2.0 libmemcached version 1.0.16 SASL support yes Session support yes igbinary support yes json support yes msgpack support yes Directive Local Value Master Value memcached.compression_factor 1.3 1.3 memcached.compression_threshold 2000 2000 memcached.compression_type fastlz fastlz memcached.serializer igbinary igbinary memcached.sess_binary no value no value memcached.sess_connect_timeout 1000 1000 memcached.sess_consistent_hash no value no value memcached.sess_lock_expire 0 0 memcached.sess_lock_max_wait 0 0 memcached.sess_lock_wait 150000 150000 memcached.sess_locking 1 1 memcached.sess_number_of_replicas 0 0 memcached.sess_prefix memc.sess.key. memc.sess.key. memcached.sess_randomize_replica_read no value no value memcached.sess_remove_failed 1 1 memcached.sess_sasl_password no value no value memcached.sess_sasl_username no value no value memcached.store_retry_count 2 2 memcached.use_sasl no value no value mhash MHASH support Enabled MHASH API Version Emulated Support msgpack MessagePack Support enabled Session Support enabled extension Version 0.5.7 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 msgpack.use_str8_serialization On On mysql MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $ Directive Local Value Master Value mysql.allow_local_infile On On mysql.allow_persistent On On mysql.connect_timeout 60 60 mysql.default_host no value no value mysql.default_password no value no value mysql.default_port no value no value mysql.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock mysql.default_user no value no value mysql.max_links Unlimited Unlimited mysql.max_persistent Unlimited Unlimited mysql.trace_mode Off Off mysqli MysqlI Support enabled Client API library version mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $ Active Persistent Links 0 Inactive Persistent Links 0 Active Links 0 Directive Local Value Master Value mysqli.allow_local_infile On On mysqli.allow_persistent On On mysqli.default_host no value no value mysqli.default_port 3306 3306 mysqli.default_pw no value no value mysqli.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock mysqli.default_user no value no value mysqli.max_links Unlimited Unlimited mysqli.max_persistent Unlimited Unlimited mysqli.reconnect Off Off mysqli.rollback_on_cached_plink Off Off mysqlnd mysqlnd enabled Version mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $ Compression supported core SSL supported extended SSL supported Command buffer size 4096 Read buffer size 32768 Read timeout 31536000 Collecting statistics Yes Collecting memory statistics No Tracing n/a Loaded plugins mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_sha256_password API Extensions mysql,mysqli,pdo_mysql mysqlnd statistics bytes_sent 0 bytes_received 0 packets_sent 0 packets_received 0 protocol_overhead_in 0 protocol_overhead_out 0 bytes_received_ok_packet 0 bytes_received_eof_packet 0 bytes_received_rset_header_packet 0 bytes_received_rset_field_meta_packet 0 bytes_received_rset_row_packet 0 bytes_received_prepare_response_packet 0 bytes_received_change_user_packet 0 packets_sent_command 0 packets_received_ok 0 packets_received_eof 0 packets_received_rset_header 0 packets_received_rset_field_meta 0 packets_received_rset_row 0 packets_received_prepare_response 0 packets_received_change_user 0 result_set_queries 0 non_result_set_queries 0 no_index_used 0 bad_index_used 0 slow_queries 0 buffered_sets 0 unbuffered_sets 0 ps_buffered_sets 0 ps_unbuffered_sets 0 flushed_normal_sets 0 flushed_ps_sets 0 ps_prepared_never_executed 0 ps_prepared_once_executed 0 rows_fetched_from_server_normal 0 rows_fetched_from_server_ps 0 rows_buffered_from_client_normal 0 rows_buffered_from_client_ps 0 rows_fetched_from_client_normal_buffered 0 rows_fetched_from_client_normal_unbuffered 0 rows_fetched_from_client_ps_buffered 0 rows_fetched_from_client_ps_unbuffered 0 rows_fetched_from_client_ps_cursor 0 rows_affected_normal 0 rows_affected_ps 0 rows_skipped_normal 0 rows_skipped_ps 0 copy_on_write_saved 0 copy_on_write_performed 0 command_buffer_too_small 0 connect_success 0 connect_failure 0 connection_reused 0 reconnect 0 pconnect_success 0 active_connections 0 active_persistent_connections 0 explicit_close 0 implicit_close 0 disconnect_close 0 in_middle_of_command_close 0 explicit_free_result 0 implicit_free_result 0 explicit_stmt_close 0 implicit_stmt_close 0 mem_emalloc_count 0 mem_emalloc_amount 0 mem_ecalloc_count 0 mem_ecalloc_amount 0 mem_erealloc_count 0 mem_erealloc_amount 0 mem_efree_count 0 mem_efree_amount 0 mem_malloc_count 0 mem_malloc_amount 0 mem_calloc_count 0 mem_calloc_amount 0 mem_realloc_count 0 mem_realloc_amount 0 mem_free_count 0 mem_free_amount 0 mem_estrndup_count 0 mem_strndup_count 0 mem_estndup_count 0 mem_strdup_count 0 proto_text_fetched_null 0 proto_text_fetched_bit 0 proto_text_fetched_tinyint 0 proto_text_fetched_short 0 proto_text_fetched_int24 0 proto_text_fetched_int 0 proto_text_fetched_bigint 0 proto_text_fetched_decimal 0 proto_text_fetched_float 0 proto_text_fetched_double 0 proto_text_fetched_date 0 proto_text_fetched_year 0 proto_text_fetched_time 0 proto_text_fetched_datetime 0 proto_text_fetched_timestamp 0 proto_text_fetched_string 0 proto_text_fetched_blob 0 proto_text_fetched_enum 0 proto_text_fetched_set 0 proto_text_fetched_geometry 0 proto_text_fetched_other 0 proto_binary_fetched_null 0 proto_binary_fetched_bit 0 proto_binary_fetched_tinyint 0 proto_binary_fetched_short 0 proto_binary_fetched_int24 0 proto_binary_fetched_int 0 proto_binary_fetched_bigint 0 proto_binary_fetched_decimal 0 proto_binary_fetched_float 0 proto_binary_fetched_double 0 proto_binary_fetched_date 0 proto_binary_fetched_year 0 proto_binary_fetched_time 0 proto_binary_fetched_datetime 0 proto_binary_fetched_timestamp 0 proto_binary_fetched_string 0 proto_binary_fetched_blob 0 proto_binary_fetched_enum 0 proto_binary_fetched_set 0 proto_binary_fetched_geometry 0 proto_binary_fetched_other 0 init_command_executed_count 0 init_command_failed_count 0 com_quit 0 com_init_db 0 com_query 0 com_field_list 0 com_create_db 0 com_drop_db 0 com_refresh 0 com_shutdown 0 com_statistics 0 com_process_info 0 com_connect 0 com_process_kill 0 com_debug 0 com_ping 0 com_time 0 com_delayed_insert 0 com_change_user 0 com_binlog_dump 0 com_table_dump 0 com_connect_out 0 com_register_slave 0 com_stmt_prepare 0 com_stmt_execute 0 com_stmt_send_long_data 0 com_stmt_close 0 com_stmt_reset 0 com_stmt_set_option 0 com_stmt_fetch 0 com_deamon 0 bytes_received_real_data_normal 0 bytes_received_real_data_ps 0 oci8 OCI8 Support enabled OCI8 DTrace Support enabled OCI8 Version 2.0.8 Revision $Id: f04114d4d67cffea4cdc2ed3b7f0229c2caa5016 $ Oracle Run-time Client Library Version 12.1.0.2.0 Oracle Compile-time Instant Client Version 12.1 Directive Local Value Master Value oci8.connection_class no value no value oci8.default_prefetch 100 100 oci8.events Off Off oci8.max_persistent -1 -1 oci8.old_oci_close_semantics Off Off oci8.persistent_timeout -1 -1 oci8.ping_interval 60 60 oci8.privileged_connect Off Off oci8.statement_cache_size 20 20 Statistics Active Persistent Connections 0 Active Connections 0 openssl OpenSSL support enabled OpenSSL Library Version OpenSSL 1.0.1e-fips 11 Feb 2013 OpenSSL Header Version OpenSSL 1.0.1e-fips 11 Feb 2013 Directive Local Value Master Value openssl.cafile no value no value openssl.capath no value no value pcre PCRE (Perl Compatible Regular Expressions) Support enabled PCRE Library Version 8.32 2012-11-30 Directive Local Value Master Value pcre.backtrack_limit 1000000 1000000 pcre.recursion_limit 100000 100000 PDO PDO support enabled PDO drivers mysql, oci, sqlite, sqlite2 pdo_mysql PDO Driver for MySQL enabled Client API version mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $ Directive Local Value Master Value pdo_mysql.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock PDO_OCI PDO Driver for OCI 8 and later enabled pdo_sqlite PDO Driver for SQLite 3.x enabled SQLite Library 3.7.17 Phar Phar: PHP Archive support enabled Phar EXT version 2.0.2 Phar API version 1.1.1 SVN revision $Id: 72d7e004b07d106bb1ef7c5663a186cbae621385 $ Phar-based phar archives enabled Tar-based phar archives enabled ZIP-based phar archives enabled gzip compression enabled bzip2 compression enabled Native OpenSSL support enabled Phar based on pear/PHP_Archive, original concept by Davey Shafik. Phar fully realized by Gregory Beaver and Marcus Boerger. Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle. Directive Local Value Master Value phar.cache_list no value no value phar.readonly On On phar.require_hash On On posix Revision $Id: 5d20de77687b7d961b15450873fa23b9e64a136a $ Reflection Reflection enabled Version $Id: eff8bdc65b0beaf8f4ade6f06f848e6d43dfd826 $ session Session Support enabled Registered save handlers files user memcache sqlite memcached Registered serializer handlers php_serialize php php_binary wddx igbinary msgpack Directive Local Value Master Value session.auto_start Off Off session.cache_expire 180 180 session.cache_limiter nocache nocache session.cookie_domain no value no value session.cookie_httponly Off Off session.cookie_lifetime 0 0 session.cookie_path / / session.cookie_secure Off Off session.entropy_file /dev/urandom /dev/urandom session.entropy_length 32 32 session.gc_divisor 1000 1000 session.gc_maxlifetime 1440 1440 session.gc_probability 1 1 session.hash_bits_per_character 5 5 session.hash_function 0 0 session.name PHPSESSID PHPSESSID session.referer_check no value no value session.save_handler files files session.save_path /var/lib/php/session /var/lib/php/session session.serialize_handler php php session.upload_progress.cleanup On On session.upload_progress.enabled On On session.upload_progress.freq 1% 1% session.upload_progress.min_freq 1 1 session.upload_progress.name PHP_SESSION_UPLOAD_PROGRESS PHP_SESSION_UPLOAD_PROGRESS session.upload_progress.prefix upload_progress_ upload_progress_ session.use_cookies On On session.use_only_cookies On On session.use_strict_mode Off Off session.use_trans_sid 0 0 shmop shmop support enabled SimpleXML Simplexml support enabled Revision $Id: 6b8e23a01a85046737ef7d31346da5164505c179 $ Schema support enabled sockets Sockets Support enabled SPL SPL support enabled Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, CallbackFilterIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveCallbackFilterIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException SQLite SQLite support enabled PECL Module version 2.0-dev $Id: sqlite.c 299692 2010-05-24 14:11:39Z dmitry $ SQLite Library 2.8.17 SQLite Encoding UTF-8 Directive Local Value Master Value sqlite.assoc_case 0 0 sqlite3 SQLite3 support enabled SQLite3 module version 0.7-dev SQLite Library 3.7.17 Directive Local Value Master Value sqlite3.extension_dir no value no value standard Dynamic Library Support enabled Path to sendmail /usr/sbin/sendmail -t -i Directive Local Value Master Value assert.active 1 1 assert.bail 0 0 assert.callback no value no value assert.quiet_eval 0 0 assert.warning 1 1 auto_detect_line_endings 0 0 default_socket_timeout 60 60 from no value no value url_rewriter.tags a=href,area=href,frame=src,input=src,form=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry user_agent no value no value sysvmsg sysvmsg support enabled Revision $Id: 1e821e8a0cbb868efec453560ba303e04f3a1db2 $ tokenizer Tokenizer Support enabled wddx WDDX Support enabled WDDX Session Serializer enabled xdebug xdebug support enabled Version 2.3.2 IDE Key nobody Supported protocols Revision DBGp - Common DeBuGger Protocol $Revision: 1.145 $ Directive Local Value Master Value xdebug.auto_trace Off Off xdebug.cli_color 0 0 xdebug.collect_assignments Off Off xdebug.collect_includes On On xdebug.collect_params 0 0 xdebug.collect_return Off Off xdebug.collect_vars Off Off xdebug.coverage_enable On On xdebug.default_enable On On xdebug.dump.COOKIE no value no value xdebug.dump.ENV no value no value xdebug.dump.FILES no value no value xdebug.dump.GET no value no value xdebug.dump.POST no value no value xdebug.dump.REQUEST no value no value xdebug.dump.SERVER no value no value xdebug.dump.SESSION no value no value xdebug.dump_globals On On xdebug.dump_once On On xdebug.dump_undefined Off Off xdebug.extended_info On On xdebug.file_link_format no value no value xdebug.force_display_errors Off Off xdebug.force_error_reporting 0 0 xdebug.halt_level 0 0 xdebug.idekey no value no value xdebug.max_nesting_level 256 256 xdebug.max_stack_frames -1 -1 xdebug.overload_var_dump On On xdebug.profiler_aggregate Off Off xdebug.profiler_append Off Off xdebug.profiler_enable Off Off xdebug.profiler_enable_trigger On On xdebug.profiler_enable_trigger_value no value no value xdebug.profiler_output_dir /var/www/zend/log /var/www/zend/log xdebug.profiler_output_name cachegrind.out.%u.%H_%R cachegrind.out.%u.%H_%R xdebug.remote_autostart Off Off xdebug.remote_connect_back Off Off xdebug.remote_cookie_expire_time 3600 3600 xdebug.remote_enable On On xdebug.remote_handler dbgp dbgp xdebug.remote_host localhost localhost xdebug.remote_log no value no value xdebug.remote_mode req req xdebug.remote_port 9000 9000 xdebug.scream Off Off xdebug.show_exception_trace Off Off xdebug.show_local_vars Off Off xdebug.show_mem_delta Off Off xdebug.trace_enable_trigger Off Off xdebug.trace_enable_trigger_value no value no value xdebug.trace_format 0 0 xdebug.trace_options 0 0 xdebug.trace_output_dir /var/www/zend/log /var/www/zend/log xdebug.trace_output_name trace.%c trace.%c xdebug.var_display_max_children 128 128 xdebug.var_display_max_data 512 512 xdebug.var_display_max_depth 3 3 xml XML Support active XML Namespace Support active libxml2 Version 2.9.1 xmlreader XMLReader enabled xmlwriter XMLWriter enabled xsl XSL enabled libxslt Version 1.1.28 libxslt compiled against libxml Version 2.9.1 EXSLT enabled libexslt Version 1.1.28 Zend Guard Loader Zend Guard Loader enabled License Path no value Obfuscation level 0 Zend OPcache Opcode Caching Up and Running Optimization Enabled Startup OK Shared memory model mmap Cache hits 19711 Cache misses 636 Used memory 31281200 Free memory 102237648 Wasted memory 698880 Interned Strings Used memory 1583472 Interned Strings Free memory 6805136 Cached scripts 595 Cached keys 609 Max keys 7963 OOM restarts 0 Hash keys restarts 0 Manual restarts 0 Directive Local Value Master Value opcache.blacklist_filename /etc/php.d/opcache_.blacklist /etc/php.d/opcache_.blacklist opcache.consistency_checks 0 0 opcache.dups_fix Off Off opcache.enable On On opcache.enable_cli Off Off opcache.enable_file_override Off Off opcache.error_log no value no value opcache.fast_shutdown 0 0 opcache.file_update_protection 2 2 opcache.force_restart_timeout 180 180 opcache.inherited_hack On On opcache.interned_strings_buffer 8 8 opcache.load_comments 1 1 opcache.log_verbosity_level 1 1 opcache.max_accelerated_files 4000 4000 opcache.max_file_size 0 0 opcache.max_wasted_percentage 5 5 opcache.memory_consumption 128 128 opcache.optimization_level 0xFFFFFFFF 0xFFFFFFFF opcache.preferred_memory_model no value no value opcache.protect_memory 0 0 opcache.restrict_api no value no value opcache.revalidate_freq 2 2 opcache.revalidate_path Off Off opcache.save_comments 1 1 opcache.use_cwd On On opcache.validate_timestamps On On zip Zip enabled Extension Version $Id: 872affeb4da56999accae9cdc682d3f3bb3f3458 $ Zip version 1.13.1 Libzip version 1.0.1 zlib ZLib Support enabled Stream Wrapper compress.zlib:// Stream Filter zlib.inflate, zlib.deflate Compiled Version 1.2.7 Linked Version 1.2.7 Directive Local Value Master Value zlib.output_compression Off Off zlib.output_compression_level -1 -1 zlib.output_handler no value no value Additional Modules Module Name sysvsem sysvshm Environment Variable Value USER nobody HOME / PHP Variables Variable Value _REQUEST["r"] debug/default/view _REQUEST["panel"] config _REQUEST["tag"] 5615359b54c17 _GET["r"] debug/default/view _GET["panel"] config _GET["tag"] 5615359b54c17 _SERVER["USER"] nobody _SERVER["HOME"] / _SERVER["FCGI_ROLE"] RESPONDER _SERVER["QUERY_STRING"] r=debug%2Fdefault%2Fview&panel=config&tag=5615359b54c17 _SERVER["REQUEST_METHOD"] GET _SERVER["CONTENT_TYPE"] no value _SERVER["CONTENT_LENGTH"] no value _SERVER["SCRIPT_NAME"] /index.php _SERVER["REQUEST_URI"] /index.php?r=debug%2Fdefault%2Fview&panel=config&tag=5615359b54c17 _SERVER["DOCUMENT_URI"] /index.php _SERVER["DOCUMENT_ROOT"] /var/www/guilherme/basic/web _SERVER["SERVER_PROTOCOL"] HTTP/1.1 _SERVER["GATEWAY_INTERFACE"] CGI/1.1 _SERVER["SERVER_SOFTWARE"] nginx/1.6.3 _SERVER["REMOTE_ADDR"] 192.168.1.47 _SERVER["REMOTE_PORT"] 51876 _SERVER["SERVER_ADDR"] localhost _SERVER["SERVER_PORT"] 8086 _SERVER["SERVER_NAME"] localhost _SERVER["REDIRECT_STATUS"] 200 _SERVER["SCRIPT_FILENAME"] /var/www/guilherme/basic/web/index.php _SERVER["HTTP_HOST"] localhost:8086 _SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:41.0) Gecko/20100101 Firefox/41.0 _SERVER["HTTP_ACCEPT"] text/html,application/xhtml+xml,application/xml;q=0.9,_/_;q=0.8 _SERVER["HTTP_ACCEPT_LANGUAGE"] pt-BR,pt;q=0.8,en-US;q=0.5,en;q=0.3 _SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate _SERVER["HTTP_REFERER"] http://localhost:8086/index.php?r=gii%2Fdefault%2Fview&id=model _SERVER["HTTP_CONNECTION"] keep-alive _SERVER["PHP_SELF"] /index.php _SERVER["REQUEST_TIME_FLOAT"] 1444230626.6734 _SERVER["REQUEST_TIME"] 1444230626

havennow avatar Oct 07 '15 15:10 havennow

follow DDL table rbac migration used for try make model with relations

-- DDL for Table auth_assignment

CREATE TABLE "YII"."auth_assignment" ( "item_name" VARCHAR2(64 BYTE), "user_id" VARCHAR2(64 BYTE), "created_at" NUMBER(10,0) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "YII_DATA" ;

-- DDL for Index SYS_C0015935

CREATE UNIQUE INDEX "YII"."SYS_C0015935" ON "YII"."auth_assignment" ("item_name", "user_id") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "YII_DATA" ;

-- Constraints for Table auth_assignment

ALTER TABLE "YII"."auth_assignment" MODIFY ("item_name" NOT NULL ENABLE);

ALTER TABLE "YII"."auth_assignment" MODIFY ("user_id" NOT NULL ENABLE);

ALTER TABLE "YII"."auth_assignment" ADD PRIMARY KEY ("item_name", "user_id") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "YII_DATA" ENABLE;

-- Ref Constraints for Table auth_assignment

ALTER TABLE "YII"."auth_assignment" ADD FOREIGN KEY ("item_name") REFERENCES "YII"."auth_item" ("name") ON DELETE CASCADE ENABLE;

havennow avatar Oct 07 '15 15:10 havennow

@havennow so you have both Yii and extension from master, right?

samdark avatar Oct 10 '15 15:10 samdark

sorry my bad english , iam have only dev branch 2.0.7 BASIC skeleton

havennow avatar Oct 10 '15 22:10 havennow

i have news , in 2.0.7-dev , i try many drivers , i found https://github.com/sfedosimov/yii2-oci8pdo and ... WORKS! but i found configuration PHP NLS params for work fine PDO, in my case BRAZILIAN set see https://gist.github.com/marciopaiva/5c8087e53691d50a046b

in pool php-fpm env[HOSTNAME] = 'ms-devel' env[NLS_LANG] = 'BRAZILIAN PORTUGUESE_BRAZIL.AL32UTF8' env[NLS_TERRITORY] = 'BRAZIL' env[NLS_DUAL_CURRENCY] = 'R$' env[NLS_CURRENCY] = 'R$' env[NLS_ISO_CURRENCY] = 'BRAZIL' env[NLS_DATE_LANGUAGE] = 'BRAZILIAN PORTUGUESE' env[NLS_DATE_FORMAT] = 'DD/MM/YYYY' env[NLS_TIME_FORMAT] = 'HH24:MI:SS' env[NLS_TIMESTAMP_FORMAT] = 'DD/MM/YYYY HH24:MI:SS'

and , worked , but i test with driver yii2 oci official , not 3thd driver , not work this problem with only Generate Relations option GII model generator

Thanks

havennow avatar Nov 03 '15 14:11 havennow

The same problem in 2.0.4 2.0.3 is ok.

  1. in test/vendor/yiisoft/yii2-gii/generators/model/Generator.php at line 511 while (isset($relations[$table->fullName][$name])) {
  2. in test/vendor/yiisoft/yii2-gii/generators/model/Generator.php at line 511 – yii\base\ErrorHandler::handleError(8, 'Trying to get property of non-ob...', '/home/railton/html/intr...', 511, ...) 505506507508509510511512513514515516517 } while (isset($relations[$table->fullName][$name])) {
  3. in test/vendor/yiisoft/yii2-gii/generators/model/Generator.php at line 425 – yii\gii\generators\model\Generator::generateRelationName(['HR.COUNTRIES' => ['REGION' => ['return $this->hasOne(REGIONS::cl...', 'REGIONS', false]]], null, 'HRCOUNTRIES', true)

railton avatar Mar 07 '16 06:03 railton