Solved thread

This post is marked as solved. If you think the information contained on this thread must be part of the official documentation, please contribute submitting a pull request to its repository.

Phalcon - Find CLOB from PDO/Oracle

Hi.. Please someone... I am struggling with this problem for a while now..

Is like this..

1) I have a CLOB field in my oracle database.

2) I am using the follwing connection

//Returning DB Class Adapter //PDO::ATTRSTRINGIFYFETCHES => true, Is to return the correct CLOB content instead resource id #

return new $dbclass(

[

'dbname' => $config->oracle->database,

'username' => $config->oracle->login,

'password' => $config->oracle->password,

'prefix' => $config->oracle->prefix,

'charset' => 'AL32UTF8',

"options" => array(
    PDO::ATTR_STRINGIFY_FETCHES => true,
)

] );

I am using PDO::ATTRSTRINGIFYFETCHES => true, because I want to get CLOB field as string and not as resource #id

3) I use a simple Log::Find($conditions, "bind"=> $params) like I use in every other place in my code;

4) It just dies like

The page 10.14.1.194 isn't working No data sent by 10.14.1.194 ERREMPTYRESPONSE

Does anyone have the same problem ? or Had the same problem? Many thanks Cheers

I did some testes and I think it is related with the size or quantity of rows..

Because I deleted everything from my database and started fresh. with one record it returns CLOB fields fine.

with two or more records it crashes..

It is at minimum strange behavior. =(

So ok .. I narrow down to a server problem. I have to servers, one windows other linux. The linux one is just dying. Must be a memory issue or something.

As soon I find out a solution I will try answer it here..

thanks =)



1.0k
Accepted
answer

Hi.. so.. after a lot of work..

I didn't find the problem, but a kind of find a half solution that allows apache2 execute "normally" the request. I have installed php-xcache module on linux. And somehow it started to work.. I think it can be a memory issue.

thanks =)

You have two servers, which role do they play in your use case?

Post your web server (apache) configuration, which SAPI interface are you running?

Xcache is not a solution, more like a workaround for this case.

When things are unstable like that, you really have to investigate and NOT to go into production, otherwise you may regret it.

Hello.. So yes.. it is a workaround and not a good one.. It only works sometimes and I didn't find the solution yet.

The two servers isn't together.. it's like I have two separated servers .. two environments to test. One linux VM and other Windows host Windows host has xampp and php5.6 Linux VM has apache2.4 with php5.5.9

They work fine.. until I have to select some CLOB fields from Oracle database. Because xampp server brings it just fine. And Linux one don't. I tried to build one server from scratch again.. The first one have oracle 10.2 The seconde have one oracle 11.2 UbuntuServer 14.02

The same problem has occurred

The apache2 server keeps throwing this "exit signal Segmentation fault (11)"

Any help will be welcome =) Thanks... cheers

Follows phpinfo config

PHP logo PHP Version 5.5.9-1ubuntu4.17

System Linux ubuntuServer14044 4.2.0-27-generic #32~14.04.1-Ubuntu SMP Fri Jan 22 15:32:26 UTC 2016 x8664 Build Date May 19 2016 19:05:33 Server API Apache 2.0 Handler Virtual Directory Support disabled Configuration File (php.ini) Path /etc/php5/apache2 Loaded Configuration File /etc/php5/apache2/php.ini Scan this dir for additional .ini files /etc/php5/apache2/conf.d Additional .ini files parsed /etc/php5/apache2/conf.d/05-opcache.ini, /etc/php5/apache2/conf.d/10-pdo.ini, /etc/php5/apache2/conf.d/20-apcu.ini, /etc/php5/apache2/conf.d/20-gd.ini, /etc/php5/apache2/conf.d/20-json.ini, /etc/php5/apache2/conf.d/20-memcache.ini, /etc/php5/apache2/conf.d/20-mssql.ini, /etc/php5/apache2/conf.d/20-mysql.ini, /etc/php5/apache2/conf.d/20-mysqli.ini, /etc/php5/apache2/conf.d/20-pdodblib.ini, /etc/php5/apache2/conf.d/20-pdomysql.ini, /etc/php5/apache2/conf.d/20-pdopgsql.ini, /etc/php5/apache2/conf.d/20-pgsql.ini, /etc/php5/apache2/conf.d/20-readline.ini, /etc/php5/apache2/conf.d/20-xsl.ini, /etc/php5/apache2/conf.d/oci8.ini, /etc/php5/apache2/conf.d/pdooci.ini, /etc/php5/apache2/conf.d/phalcon.ini PHP API 20121113 PHP Extension 20121212 Zend Extension 220121212 Zend Extension Build API220121212,NTS PHP Extension Build API20121212,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, compress.bzip2, php, file, glob, data, http, ftp, phar, zip Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, tls Registered Stream Filters zlib.*, bzip2.*, convert.iconv.*, string.rot13, string.toupper, string.tolower, string.striptags, convert.*, consumed, dechunk

Zend logo This program makes use of the Zend Scripting Language Engine: Zend Engine v2.5.0, Copyright (c) 1998-2014 Zend Technologies with Zend OPcache v7.0.3, Copyright (c) 1999-2014, by Zend Technologies

Configuration

apache2handler

Apache Version Apache/2.4.7 (Ubuntu) Apache API Version 20120211 Server Administrator [email protected] Hostname:Port 127.0.1.1:80 User/Group www-data(33)/33 Max Requests Per Child: 0 - Keep Alive: on - Max Per Connection: 100 Timeouts Connection: 300 - Keep-Alive: 5 Virtual Server Yes Server Root /etc/apache2 Loaded Modules core modso modwatchdog httpcore modlogconfig modlogio modversion modunixd modaccesscompat modalias modauthbasic modauthncore modauthnfile modauthzcore modauthzhost modauthzuser modautoindex moddeflate moddir modenv modfilter modmime prefork modnegotiation modphp5 modrewrite modsetenvif modstatus

Directive Local Value Master Value engine 1 1 last_modified 0 0 xbithack 0 0

Apache Environment

Variable Value REDIRECTREDIRECTSTATUS 200 REDIRECTSTATUS 200 HTTPHOST 10.14.1.244 HTTPCONNECTION keep-alive HTTPACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,/;q=0.8 HTTPUPGRADEINSECUREREQUESTS 1 HTTPUSERAGENT Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.102 Safari/537.36 HTTPACCEPTENCODING gzip, deflate, sdch HTTPACCEPTLANGUAGE pt-BR,pt;q=0.8,en-US;q=0.6,en;q=0.4 HTTPCOOKIE PHPSESSID=55bsdprr266ek1u2j0q1esjaj1 PATH /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin SERVERSIGNATURE <address>Apache/2.4.7 (Ubuntu) Server at 10.14.1.244 Port 80</address> SERVERSOFTWARE Apache/2.4.7 (Ubuntu) SERVERNAME 10.14.1.244 SERVERADDR 10.14.1.244 SERVERPORT 80 REMOTEADDR 10.14.0.76 DOCUMENTROOT /var/www/html REQUESTSCHEME http CONTEXTPREFIX no value CONTEXTDOCUMENTROOT /var/www/html SERVERADMIN [email protected] REMOTEPORT 58423 REDIRECTQUERYSTRING _url=/admin/phpInfo GATEWAYINTERFACE CGI/1.1 SERVERPROTOCOL HTTP/1.1 REQUESTMETHOD GET QUERY_STRING _url=/admin/phpInfo

HTTP Headers Information

HTTP Request Headers Host 10.14.1.244 Connection keep-alive Accept text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,/;q=0.8 Upgrade-Insecure-Requests 1 User-Agent Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.102 Safari/537.36 Accept-Encoding gzip, deflate, sdch Accept-Language pt-BR,pt;q=0.8,en-US;q=0.6,en;q=0.4 Cookie PHPSESSID=55bsdprr266ek1u2j0q1esjaj1 HTTP Response Headers X-Powered-By PHP/5.5.9-1ubuntu4.17 Expires Thu, 19 Nov 1981 08:52:00 GMT Cache-Control no-store, no-cache, must-revalidate, post-check=0, pre-check=0 Pragma no-cache

apc

APC support Emulated

apcu

APCu Support enabled Version 4.0.2 APCu Debugging Disabled MMAP Support Enabled MMAP File Mask no value Serialization Support php, eval Revision $Revision: 328290 $ Build Date Feb 19 2014 09:18:08

Directive Local Value Master Value apc.coredumpunmap Off Off apc.enablecli Off Off apc.enabled On On apc.entrieshint 4096 4096 apc.gcttl 3600 3600 apc.mmapfilemask no value no value apc.preloadpath no value no value apc.rfc1867 Off Off apc.rfc1867freq 0 0 apc.rfc1867name APCUPLOADPROGRESS APCUPLOADPROGRESS apc.rfc1867prefix upload_ upload_ apc.rfc1867ttl 3600 3600 apc.serializer php php apc.shmsegments 1 1 apc.shmsize 32M 32M apc.slamdefense On On apc.smart 0 0 apc.ttl 0 0 apc.userequesttime On On apc.writable /tmp /tmp

bcmath

BCMath support enabled

Directive Local Value Master Value bcmath.scale 0 0

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

Core

PHP Version 5.5.9-1ubuntu4.17

Directive Local Value Master Value allowurlfopen On On allowurlinclude Off Off alwayspopulaterawpostdata Off Off argseparator.input & & argseparator.output & & asptags Off Off autoappendfile no value no value autoglobalsjit On On autoprependfile no value no value browscap no value no value defaultcharset no value no value defaultmimetype text/html text/html disableclasses no value no value disablefunctions pcntlalarm,pcntlfork,pcntlwaitpid,pcntlwait,pcntlwifexited,pcntlwifstopped,pcntlwifsignaled,pcntlwexitstatus,pcntlwtermsig,pcntlwstopsig,pcntlsignal,pcntlsignaldispatch,pcntlgetlasterror,pcntlstrerror,pcntlsigprocmask,pcntlsigwaitinfo,pcntlsigtimedwait,pcntlexec,pcntlgetpriority,pcntlsetpriority, pcntlalarm,pcntlfork,pcntlwaitpid,pcntlwait,pcntlwifexited,pcntlwifstopped,pcntlwifsignaled,pcntlwexitstatus,pcntlwtermsig,pcntlwstopsig,pcntlsignal,pcntlsignaldispatch,pcntlgetlasterror,pcntlstrerror,pcntlsigprocmask,pcntlsigwaitinfo,pcntlsigtimedwait,pcntlexec,pcntlgetpriority,pcntlsetpriority, displayerrors On Off displaystartuperrors Off Off docroot no value no value docrefext no value no value docrefroot no value no value enabledl Off Off enablepostdatareading On On errorappendstring no value no value errorlog no value no value errorprependstring no value no value errorreporting 32767 22527 exitontimeout Off Off exposephp On On extensiondir /usr/lib/php5/20121212 /usr/lib/php5/20121212 fileuploads On On highlight.comment #FF8000 #FF8000 highlight.default #0000BB #0000BB highlight.html #000000 #000000 highlight.keyword #007700 #007700 highlight.string #DD0000 #DD0000 htmlerrors On On ignorerepeatederrors Off Off ignorerepeatedsource Off Off ignoreuserabort Off Off implicitflush Off Off .:/usr/share/php:/usr/share/pear logerrors On On logerrorsmaxlen 1024 1024 mail.addxheader On On mail.forceextraparameters no value no value mail.log no value no value maxexecutiontime 30 30 maxfileuploads 20 20 maxinputnestinglevel 64 64 maxinputtime 60 60 maxinputvars 1000 1000 memorylimit 500M 500M openbasedir no value no value outputbuffering 4096 4096 outputhandler no value no value postmaxsize 8M 8M precision 14 14 realpathcachesize 16K 16K realpathcachettl 120 120 registerargcargv Off Off reportmemleaks On On reportzenddebug On On requestorder GP GP sendmailfrom no value no value sendmailpath /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i serializeprecision 17 17 shortopentag On On SMTP localhost localhost smtpport 25 25 sql.safemode Off Off systempdir no value no value trackerrors Off Off unserializecallbackfunc no value no value uploadmaxfilesize 2M 2M uploadtmpdir no value no value userdir no value no value userini.cachettl 300 300 userini.filename .user.ini .user.ini variablesorder GPCS GPCS xmlrpcerrornumber 0 0 xmlrpcerrors Off Off zend.detectunicode On On zend.enablegc On On zend.multibyte Off Off zend.scriptencoding no value no value

ctype

ctype functions enabled

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.defaultlatitude 31.7667 31.7667 date.defaultlongitude 35.2333 35.2333 date.sunrisezenith 90.583333 90.583333 date.sunsetzenith 90.583333 90.583333 date.timezone no value no value

dba

DBA support enabled Supported handlers cdb cdb_make db4 inifile flatfile

Directive Local Value Master Value dba.default_handler flatfile flatfile

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$ Supported EXIF Version 0220 Supported filetypes JPEG,TIFF

Directive Local Value Master Value exif.decodejisintel JIS JIS exif.decodejismotorola JIS JIS exif.decodeunicodeintel UCS-2LE UCS-2LE exif.decodeunicodemotorola UCS-2BE UCS-2BE exif.encodejis no value no value exif.encodeunicode ISO-8859-15 ISO-8859-15

fileinfo

fileinfo support enabled version 1.0.5-dev

filter

Input Validation and Filtering enabled Revision $Id: 4d3899e089e6e45b157975ceef2ac7deb6e9d762 $

Directive Local Value Master Value filter.default unsaferaw unsaferaw filter.default_flags no value no value

ftp

FTP support enabled

gd

GD Support enabled GD Version 2.1.1-dev FreeType Support enabled FreeType Linkage with freetype FreeType Version 2.5.2 GIF Read Support enabled GIF Create Support enabled JPEG Support enabled libJPEG Version 8 PNG Support enabled libPNG Version 1.2.50 WBMP Support enabled XPM Support enabled libXpm Version 30411 XBM Support enabled WebP Support enabled

Directive Local Value Master Value gd.jpegignorewarning 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 adler32 crc32 crc32b fnv132 fnv164 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.19

Directive Local Value Master Value iconv.inputencoding ISO-8859-1 ISO-8859-1 iconv.internalencoding ISO-8859-1 ISO-8859-1 iconv.output_encoding ISO-8859-1 ISO-8859-1

json

json support enabled json version 1.3.2 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.2

Directive Local Value Master Value mbstring.detectorder no value no value mbstring.encodingtranslation Off Off mbstring.funcoverload 0 0 mbstring.httpinput pass pass mbstring.httpoutput pass pass mbstring.httpoutputconvmimetypes ^(text/|application/xhtml+xml) ^(text/|application/xhtml+xml) mbstring.internalencoding no value no value mbstring.language neutral neutral mbstring.strictdetection Off Off mbstring.substitute_character no value no value

memcache

memcache support enabled Version 3.0.8 Revision $Revision: 329835 $

Directive Local Value Master Value memcache.allowfailover 1 1 memcache.chunksize 32768 32768 memcache.compressthreshold 20000 20000 memcache.defaultport 11211 11211 memcache.hashfunction crc32 crc32 memcache.hashstrategy consistent consistent memcache.locktimeout 15 15 memcache.maxfailoverattempts 20 20 memcache.protocol ascii ascii memcache.redundancy 1 1 memcache.sessionredundancy 2 2

mhash

MHASH support Enabled MHASH API Version Emulated Support

mssql

MSSQL Support enabled Active Persistent Links 0 Active Links 0 Library version FreeTDS

Directive Local Value Master Value mssql.allowpersistent On On mssql.batchsize 0 0 mssql.charset no value no value mssql.compatabilitymode Off Off mssql.compatibilitymode Off Off mssql.connecttimeout 5 5 mssql.datetimeconvert On On mssql.maxlinks Unlimited Unlimited mssql.maxpersistent Unlimited Unlimited mssql.maxprocs Unlimited Unlimited mssql.minerrorseverity 10 10 mssql.minmessageseverity 10 10 mssql.secureconnection Off Off mssql.textlimit Server default Server default mssql.textsize Server default Server default mssql.timeout 60 60

mysql

MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 5.5.49 MYSQLMODULETYPE external MYSQLSOCKET /var/run/mysqld/mysqld.sock MYSQLINCLUDE -I/usr/include/mysql MYSQLLIBS -L/usr/lib/x8664-linux-gnu -lmysqlclient_r

Directive Local Value Master Value mysql.allowlocalinfile On On mysql.allowpersistent On On mysql.connecttimeout 60 60 mysql.defaulthost no value no value mysql.defaultpassword no value no value mysql.defaultport no value no value mysql.defaultsocket /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock mysql.defaultuser no value no value mysql.maxlinks Unlimited Unlimited mysql.maxpersistent Unlimited Unlimited mysql.tracemode Off Off

mysqli

MysqlI Support enabled Client API library version 5.5.49 Active Persistent Links 0 Inactive Persistent Links 0 Active Links 0 Client API header version 5.5.49 MYSQLI_SOCKET /var/run/mysqld/mysqld.sock

Directive Local Value Master Value mysqli.allowlocalinfile On On mysqli.allowpersistent On On mysqli.defaulthost no value no value mysqli.defaultport 3306 3306 mysqli.defaultpw no value no value mysqli.defaultsocket /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock mysqli.defaultuser no value no value mysqli.maxlinks Unlimited Unlimited mysqli.maxpersistent Unlimited Unlimited mysqli.reconnect Off Off

oci8

OCI8 Support enabled OCI8 DTrace Support disabled OCI8 Version 2.0.11 Revision $Id: 8effa3c719ada4f4f79587ac85aca57b3b9f9b38 $ Oracle Run-time Client Library Version 11.2.0.4.0 Oracle Compile-time Instant Client Version 11.2

Directive Local Value Master Value oci8.connectionclass no value no value oci8.defaultprefetch 100 100 oci8.events Off Off oci8.maxpersistent -1 -1 oci8.oldociclosesemantics Off Off oci8.persistenttimeout -1 -1 oci8.pinginterval 60 60 oci8.privilegedconnect Off Off oci8.statementcache_size 20 20

Statistics
Active Persistent Connections 0 Active Connections 0

openssl

OpenSSL support enabled OpenSSL Library Version OpenSSL 1.0.1f 6 Jan 2014 OpenSSL Header Version OpenSSL 1.0.1f 6 Jan 2014

pcre

PCRE (Perl Compatible Regular Expressions) Support enabled PCRE Library Version 8.31 2012-07-06

Directive Local Value Master Value pcre.backtracklimit 1000000 1000000 pcre.recursionlimit 100000 100000

PDO

PDO support enabled PDO drivers dblib, mysql, pgsql, oci

pdo_dblib

PDO Driver for FreeTDS/Sybase DB-lib enabled Flavour freetds

pdo_mysql

PDO Driver for MySQL enabled Client API version 5.5.49

Directive Local Value Master Value pdomysql.defaultsocket /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock

PDO_OCI

PDO Driver for OCI 8 and later enabled

pdo_pgsql

PDO Driver for PostgreSQL enabled PostgreSQL(libpq) Version 9.3.11 Module version 1.0.2 Revision $Id$

pgsql

PostgreSQL Support enabled PostgreSQL(libpq) Version 9.3.11 PostgreSQL(libpq) PostgreSQL 9.3.11 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit Multibyte character support enabled SSL support enabled Active Persistent Links 0 Active Links 0

Directive Local Value Master Value pgsql.allowpersistent On On pgsql.autoresetpersistent Off Off pgsql.ignorenotice Off Off pgsql.lognotice Off Off pgsql.maxlinks Unlimited Unlimited pgsql.max_persistent Unlimited Unlimited

phalcon

Web framework delivered as a C-extension for PHP

phalcon enabled Author Phalcon Team and contributors Version 2.0.13 Build Date May 31 2016 09:50:08 Powered by Zephir Version 0.9.2a-dev

Directive Local Value Master Value phalcon.db.escapeidentifiers On On phalcon.db.forcecasting Off Off phalcon.orm.castonhydrate Off Off phalcon.orm.columnrenaming On On phalcon.orm.enableimplicitjoins On On phalcon.orm.enableliterals On On phalcon.orm.events On On phalcon.orm.exceptiononfailedsave Off Off phalcon.orm.ignoreunknowncolumns Off Off phalcon.orm.latestatebinding Off Off phalcon.orm.notnullvalidations On On phalcon.orm.virtualforeign_keys On On

Phar

Phar: PHP Archive support enabled Phar EXT version 2.0.2 Phar API version 1.1.1 SVN revision $Id: a5488937a80433d434af6753d3db8517feaf91df $ Phar-based phar archives enabled Tar-based phar archives enabled ZIP-based phar archives enabled gzip compression enabled bzip2 compression enabled 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.cachelist no value no value phar.readonly On On phar.requirehash On On

posix

Revision $Id: 1dfa9997ed76804e53c91e0ce862f3707617b6ed $

readline

Readline Support enabled Readline library EditLine wrapper

Directive Local Value Master Value cli.pager no value no value cli.prompt \b \> \b \>

Reflection

Reflection enabled Version $Id: 31d836a7ac92a37b5c580836d91ad4736fe2f376 $

session

Session Support enabled Registered save handlers files user memcache Registered serializer handlers phpserialize php phpbinary wddx

Directive Local Value Master Value session.autostart Off Off session.cacheexpire 180 180 session.cachelimiter nocache nocache session.cookiedomain no value no value session.cookiehttponly Off Off session.cookielifetime 0 0 session.cookiepath / / session.cookiesecure Off Off session.entropyfile /dev/urandom /dev/urandom session.entropylength 32 32 session.gcdivisor 1000 1000 session.gcmaxlifetime 1440 1440 session.gcprobability 0 0 session.hashbitspercharacter 5 5 session.hashfunction 0 0 session.name PHPSESSID PHPSESSID session.referercheck no value no value session.savehandler files files session.savepath /var/lib/php5 /var/lib/php5 session.serializehandler php php session.uploadprogress.cleanup On On session.uploadprogress.enabled On On session.uploadprogress.freq 1% 1% session.uploadprogress.minfreq 1 1 session.uploadprogress.name PHPSESSIONUPLOADPROGRESS PHPSESSIONUPLOADPROGRESS session.uploadprogress.prefix uploadprogress uploadprogress session.usecookies On On session.useonlycookies On On session.usestrictmode Off Off session.usetrans_sid 0 0

shmop

shmop support enabled

SimpleXML

Simplexml support enabled Revision $Id: 363ea1fc44b0b7775e2ec3ce8456530fec6d1660 $ Schema support enabled

soap

Soap Client enabled Soap Server enabled

Directive Local Value Master Value soap.wsdlcache 1 1 soap.wsdlcachedir /tmp /tmp soap.wsdlcacheenabled 1 1 soap.wsdlcachelimit 5 5 soap.wsdlcache_ttl 86400 86400

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

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.quieteval 0 0 assert.warning 1 1 autodetectlineendings 0 0 defaultsockettimeout 30 60 from no value no value urlrewriter.tags a=href,area=href,frame=src,input=src,form=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry useragent no value no value

sysvmsg

sysvmsg support enabled Revision $Id: adf1d2d6be849c46eed3c3ee6f1cbebd1448d6e5 $

tokenizer

Tokenizer Support enabled

wddx

WDDX Support enabled WDDX Session Serializer enabled

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 OPcache

Opcode Caching Up and Running Optimization Enabled Startup OK Shared memory model mmap Cache hits 154 Cache misses 51 Used memory 6772448 Free memory 60336416 Wasted memory 0 Cached scripts 51 Cached keys 82 Max keys 3907 OOM restarts 0 Hash keys restarts 0 Manual restarts 0

Directive Local Value Master Value opcache.blacklistfilename no value no value opcache.consistencychecks 0 0 opcache.dupsfix Off Off opcache.enable On On opcache.enablecli Off Off opcache.enablefileoverride Off Off opcache.errorlog no value no value opcache.fastshutdown 0 0 opcache.fileupdateprotection 2 2 opcache.forcerestarttimeout 180 180 opcache.inheritedhack On On opcache.internedstringsbuffer 4 4 opcache.loadcomments 1 1 opcache.logverbositylevel 1 1 opcache.maxacceleratedfiles 2000 2000 opcache.maxfilesize 0 0 opcache.maxwastedpercentage 5 5 opcache.memoryconsumption 64 64 opcache.optimizationlevel 0xFFFFFFFF 0xFFFFFFFF opcache.preferredmemorymodel no value no value opcache.protectmemory 0 0 opcache.restrictapi no value no value opcache.revalidatefreq 2 2 opcache.revalidatepath Off Off opcache.savecomments 1 1 opcache.usecwd On On opcache.validate_timestamps On On

zip

Zip enabled Extension Version $Id: 05dd1ecc211075107543b0ef8cee488dd229fccf $ Zip version 1.11.0 Libzip version 0.10.1

zlib

ZLib Support enabled Stream Wrapper compress.zlib:// Stream Filter zlib.inflate, zlib.deflate Compiled Version 1.2.8 Linked Version 1.2.8

Directive Local Value Master Value zlib.outputcompression Off Off zlib.outputcompressionlevel -1 -1 zlib.outputhandler no value no value

Additional Modules

Module Name sysvsem sysvshm

Environment

Variable Value APACHERUNDIR /var/run/apache2 APACHEPIDFILE /var/run/apache2/apache2.pid PATH /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin APACHELOCKDIR /var/lock/apache2 LANG C APACHERUNUSER www-data APACHERUNGROUP www-data APACHELOGDIR /var/log/apache2 PWD / ORACLEHOME /usr/local/lib/instantclient11_2

PHP Variables

Variable Value REQUEST["url"] /admin/phpInfo GET["url"] /admin/phpInfo COOKIE["PHPSESSID"] 55bsdprr266ek1u2j0q1esjaj1 _SERVER["REDIRECTREDIRECTSTATUS"] 200 _SERVER["REDIRECTSTATUS"] 200 SERVER["HTTPHOST"] 10.14.1.244 SERVER["HTTPCONNECTION"] keep-alive SERVER["HTTPACCEPT"] text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,/;q=0.8 SERVER["HTTPUPGRADEINSECUREREQUESTS"] 1 SERVER["HTTPUSERAGENT"] Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.102 Safari/537.36 _SERVER["HTTPACCEPTENCODING"] gzip, deflate, sdch _SERVER["HTTPACCEPTLANGUAGE"] pt-BR,pt;q=0.8,en-US;q=0.6,en;q=0.4 _SERVER["HTTPCOOKIE"] PHPSESSID=55bsdprr266ek1u2j0q1esjaj1 SERVER["PATH"] /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin _SERVER["SERVERSIGNATURE"] <address>Apache/2.4.7 (Ubuntu) Server at 10.14.1.244 Port 80</address> SERVER["SERVERSOFTWARE"] Apache/2.4.7 (Ubuntu) SERVER["SERVERNAME"] 10.14.1.244 SERVER["SERVERADDR"] 10.14.1.244 SERVER["SERVERPORT"] 80 SERVER["REMOTEADDR"] 10.14.0.76 SERVER["DOCUMENTROOT"] /var/www/html SERVER["REQUESTSCHEME"] http SERVER["CONTEXTPREFIX"] no value SERVER["CONTEXTDOCUMENTROOT"] /var/www/html _SERVER["SERVERADMIN"] [email protected] SERVER["REMOTEPORT"] 58423 SERVER["REDIRECTQUERYSTRING"] _url=/admin/phpInfo _SERVER["GATEWAYINTERFACE"] CGI/1.1 SERVER["SERVERPROTOCOL"] HTTP/1.1 SERVER["REQUESTMETHOD"] GET SERVER["QUERYSTRING"] url=/admin/phpInfo _SERVER["REQUESTTIMEFLOAT"] 1464782359.216 _SERVER["REQUESTTIME"] 1464782359

SAPI Modules Contribution Authors AOLserver Sascha Schumann Apache 1.3 (apache_hooks) Rasmus Lerdorf, Zeev Suraski, Stig Bakken, David Sklar, George Schlossnagle, Lukas Schroeder Apache 1.3 Rasmus Lerdorf, Zeev Suraski, Stig Bakken, David Sklar Apache 2.0 Filter Sascha Schumann, Aaron Bannert Apache 2.0 Handler Ian Holsman, Justin Erenkrantz (based on Apache 2.0 Filter code) Caudium / Roxen David Hedbor CGI / FastCGI Rasmus Lerdorf, Stig Bakken, Shane Caraveo, Dmitry Stogov CLI Edin Kadribasic, Marcus Boerger, Johannes Schlueter, Moriyoshi Koizumi, Xinchen Hui Continuity Alex Leigh (based on nsapi code) Embed Edin Kadribasic FastCGI Process Manager Andrei Nigmatulin, dreamcat4, Antony Dovgal, Jerome Loyet ISAPI Andi Gutmans, Zeev Suraski litespeed George Wang NSAPI Jayakumar Muthukumarasamy, Uwe Schindler phttpd Thies C. Arntzen pi3web Holger Zimmermann Sendmail Milter Harald Radi thttpd Sascha Schumann tux Sascha Schumann WebJames Alex Waugh

Hi.. with some help I discovered what was the issue...

It was pdo_oci.so. I went to pecl get their last version. But there is a giant comment warning users about that problem, that they aren't maintaining it.

So I went to php.net download php source code, and looked into ext folder There is loads of libs, including pdo_oci to my version of php.

I compiled it and tried again. It worked =) Problem solved.

Great! You see, relying on a deprecated packages can cause you lot of trouble.