PHP and ODBC

 
Post new topic   Reply to topic    Aprelium Forum Index -> PHP
View previous topic :: View next topic  
Author Message
JohnEDee
-


Joined: 30 Jan 2019
Posts: 31

PostPosted: Thu Jul 09, 2020 9:46 pm    Post subject: PHP and ODBC Reply with quote

I'm trying to get ODBC working (using ActualTech's drivers) on macOS 10.14. I un-commented the ODBC stuff in php.ini and restarted the entire box, but I'm still getting the "Call to undefined function odbc_connect()" error in my PHP code.

(BTW, I did the PATH work with ~/.bash_profile to make Terminal use Aprelium's version of PHP instead of the macOS built-in version.)

When I use PHP in the terminal, it also complains about missing the ODBC extensions...I checked and they're not present. The Aprelium page for downloading PHP for macOS says that the macOS installer includes the ODBC extension, so I'm not sure what the issue is. I can't seem to find odbc.so anywhere in /Applications/PHP7/, and it's not available to download separately as far as I can tell.

Here's what PHP --ini says:
Code:
$ php --ini
PHP Warning:  PHP Startup: Unable to load dynamic library 'odbc' (tried: /Applications/PHP7/lib/php/extensions/no-debug-non-zts-20190902/odbc (dlopen(/Applications/PHP7/lib/php/extensions/no-debug-non-zts-20190902/odbc, 9): image not found), /Applications/PHP7/lib/php/extensions/no-debug-non-zts-20190902/odbc.so (dlopen(/Applications/PHP7/lib/php/extensions/no-debug-non-zts-20190902/odbc.so, 9): image not found)) in Unknown on line 0

Warning: PHP Startup: Unable to load dynamic library 'odbc' (tried: /Applications/PHP7/lib/php/extensions/no-debug-non-zts-20190902/odbc (dlopen(/Applications/PHP7/lib/php/extensions/no-debug-non-zts-20190902/odbc, 9): image not found), /Applications/PHP7/lib/php/extensions/no-debug-non-zts-20190902/odbc.so (dlopen(/Applications/PHP7/lib/php/extensions/no-debug-non-zts-20190902/odbc.so, 9): image not found)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'pdo_odbc' (tried: /Applications/PHP7/lib/php/extensions/no-debug-non-zts-20190902/pdo_odbc (dlopen(/Applications/PHP7/lib/php/extensions/no-debug-non-zts-20190902/pdo_odbc, 9): image not found), /Applications/PHP7/lib/php/extensions/no-debug-non-zts-20190902/pdo_odbc.so (dlopen(/Applications/PHP7/lib/php/extensions/no-debug-non-zts-20190902/pdo_odbc.so, 9): image not found)) in Unknown on line 0

Warning: PHP Startup: Unable to load dynamic library 'pdo_odbc' (tried: /Applications/PHP7/lib/php/extensions/no-debug-non-zts-20190902/pdo_odbc (dlopen(/Applications/PHP7/lib/php/extensions/no-debug-non-zts-20190902/pdo_odbc, 9): image not found), /Applications/PHP7/lib/php/extensions/no-debug-non-zts-20190902/pdo_odbc.so (dlopen(/Applications/PHP7/lib/php/extensions/no-debug-non-zts-20190902/pdo_odbc.so, 9): image not found)) in Unknown on line 0
Configuration File (php.ini) Path: /Applications/PHP7/lib
Loaded Configuration File:         /Applications/PHP7/lib/php.ini
Scan for additional .ini files in: /Applications/PHP7/etc/php.d
Additional .ini files parsed:      (none)
[/code]
Back to top View user's profile Send private message
JohnEDee
-


Joined: 30 Jan 2019
Posts: 31

PostPosted: Fri Jul 10, 2020 4:14 am    Post subject: Reply with quote

After more research, I ran across a mention that if php is compiled with support for an extension built-in (as the Aprelium version claims ODBC is in their build), then enabling the extension in php.ini will actually throw this error...but that the functionality should be available without it, because it was compiled with it.

So I re-commented the ODBC extension lines in php.ini and no longer get the errors...but ODBC functionality seems to still not bee enabled.

My guess at this point is that although the Aprelium page says "Download the PHP 7.4.7 package for macOS (~19 MB). It is a notarized package containing the FastCGI/CGI Interpreter version of PHP 7.4.7 with the following built-in extensions: bcmath, [...], odbc, [...] and zlib. Support for ftp, iconv, mbstring, GD2, PDO, SQLite, MySQL, and MySQLi is also turned on by default", that's actually not the case, at least for ODBC.

I think if it had been compiled with ODBC built-in, it would show up in the output of $ php -i but there's nothing in there about ODBC (see output below).

If PHP was just accidentally built without ODBC support, could we get a version of PHP compiled with ODBC, as the page claims? Or if not, is there another way for me to get ODBC support installed just for my installation? I'm a newbie at compiling and running PHP, so I'm just googling and trying to figure stuff out, so pardon my ignorance!

Code:
$ php -i
phpinfo()
PHP Version => 7.4.7

System => Darwin web-smtpserver.cciu.org 18.7.0 Darwin Kernel Version 18.7.0: Mon Apr 27 20:09:39 PDT 2020; root:xnu-4903.278.35~1/RELEASE_X86_64 x86_64
Build Date => Jun 11 2020 20:36:13
Configure Command =>  './configure'  '--host=x86_64-apple-darwin' '--target=x86_64-apple-darwin' '--prefix=/Applications/PHP7' '--build=x86_64-apple-darwin' '--program-prefix=' '--enable-mbstring' '--enable-gd' '--with-freetype' '--with-jpeg' '--enable-gd-jis-conv' '--with-zlib' '--with-iconv=/Applications/PHP7' '--with-libxml' '--with-xsl' '--with-openssl' '--with-openssl-dir=/Applications/PHP7' '--enable-bcmath' '--enable-calendar' '--with-curl' '--enable-dba=shared' '--enable-exif' '--enable-ftp' '--with-mysqli=mysqlnd' '--enable-pcntl' '--with-pdo-sqlite' '--with-pdo-mysql=mysqlnd' '--enable-shmop' '--enable-soap' '--enable-sockets' '--with-xmlrpc' '--with-zip' '--enable-posix' '--with-imap-ssl' '--without-pcre-jit' '--with-kerberos' '--without-ldap' '--enable-sysvmsg' '--enable-sysvsem' '--enable-sysvshm' '--with-pear' '--with-config-file-path=/Applications/PHP7/lib' '--with-config-file-scan-dir=/Applications/PHP7/etc/php.d' 'build_alias=x86_64-apple-darwin' 'host_alias=x86_64-apple-darwin' 'target_alias=x86_64-apple-darwin' 'PKG_CONFIG=/Users/moez/development/aprelium-phpfactory/mac/work/pkg-config-0.29.2/pkg-config' 'PKG_CONFIG_PATH=/Applications/PHP7/lib/pkgconfig' 'KERBEROS_CFLAGS= ' 'KERBEROS_LIBS=-lkrb5 -lgssapi_krb5' 'SQLITE_CFLAGS=-I/Users/moez/development/aprelium-phpfactory/mac/work/sqlite-amalgamation-3310100/' 'SQLITE_LIBS=-L/Applications/PHP7/lib -lsqlite3' 'ZLIB_CFLAGS= ' 'ZLIB_LIBS=-lz'
Server API => Command Line Interface
Virtual Directory Support => disabled
Configuration File (php.ini) Path => /Applications/PHP7/lib
Loaded Configuration File => /Applications/PHP7/lib/php.ini
Scan this dir for additional .ini files => /Applications/PHP7/etc/php.d
Additional .ini files parsed => (none)
PHP API => 20190902
PHP Extension => 20190902
Zend Extension => 320190902
Zend Extension Build => API320190902,NTS
PHP Extension Build => API20190902,NTS
Debug Build => no
Thread Safety => disabled
Zend Signal Handling => enabled
Zend Memory Manager => enabled
Zend Multibyte Support => provided by mbstring
IPv6 Support => enabled
DTrace Support => disabled

Registered PHP Streams => https, ftps, compress.zlib, php, file, glob, data, http, ftp, phar, zip
Registered Stream Socket Transports => tcp, udp, unix, udg, ssl, tls, tlsv1.0, tlsv1.1, tlsv1.2, tlsv1.3
Registered Stream Filters => zlib.*, convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk

This program makes use of the Zend Scripting Language Engine:
Zend Engine v3.4.0, Copyright (c) Zend Technologies


 _______________________________________________________________________


Configuration

bcmath

BCMath support => enabled

Directive => Local Value => Master Value
bcmath.scale => 0 => 0

calendar

Calendar support => enabled

Core

PHP Version => 7.4.7

Directive => Local Value => Master Value
allow_url_fopen => On => On
allow_url_include => Off => Off
arg_separator.input => & => &
arg_separator.output => & => &
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 => STDOUT => STDOUT
display_startup_errors => On => On
doc_root => no value => no value
docref_ext => no value => no value
docref_root => no value => no value
enable_dl => On => On
enable_post_data_reading => On => On
error_append_string => no value => no value
error_log => no value => no value
error_prepend_string => no value => no value
error_reporting => 22519 => 22519
expose_php => On => On
extension_dir => /Applications/PHP7/lib/php/extensions/no-debug-non-zts-20190902/ => /Applications/PHP7/lib/php/extensions/no-debug-non-zts-20190902/
file_uploads => On => On
hard_timeout => 2 => 2
highlight.comment => <font style="color: #FF8000">#FF8000</font> => <font style="color: #FF8000">#FF8000</font>
highlight.default => <font style="color: #0000BB">#0000BB</font> => <font style="color: #0000BB">#0000BB</font>
highlight.html => <font style="color: #000000">#000000</font> => <font style="color: #000000">#000000</font>
highlight.keyword => <font style="color: #007700">#007700</font> => <font style="color: #007700">#007700</font>
highlight.string => <font style="color: #DD0000">#DD0000</font> => <font style="color: #DD0000">#DD0000</font>
html_errors => Off => Off
ignore_repeated_errors => Off => Off
ignore_repeated_source => Off => Off
ignore_user_abort => Off => Off
implicit_flush => On => On
include_path => .:/Applications/PHP7/lib/php => .:/Applications/PHP7/lib/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 => Off => Off
mail.force_extra_parameters => no value => no value
mail.log => no value => no value
max_execution_time => 0 => 0
max_file_uploads => 20 => 20
max_input_nesting_level => 64 => 64
max_input_time => -1 => -1
max_input_vars => 1000 => 1000
memory_limit => 256M => 256M
open_basedir => no value => no value
output_buffering => 0 => 0
output_encoding => no value => no value
output_handler => no value => no value
post_max_size => 32M => 32M
precision => 14 => 14
realpath_cache_size => 4096K => 4096K
realpath_cache_ttl => 120 => 120
register_argc_argv => On => On
report_memleaks => On => On
report_zend_debug => Off => Off
request_order => GP => GP
sendmail_from => no value => no value
sendmail_path => /usr/sbin/sendmail -t -i => /usr/sbin/sendmail -t -i
serialize_precision => -1 => -1
short_open_tag => Off => Off
SMTP => localhost => localhost
smtp_port => 25 => 25
sys_temp_dir => no value => no value
syslog.facility => LOG_USER => LOG_USER
syslog.filter => no-ctrl => no-ctrl
syslog.ident => php => php
track_errors => Off => Off
unserialize_callback_func => no value => no value
upload_max_filesize => 32M => 32M
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.assertions => -1 => -1
zend.detect_unicode => On => On
zend.enable_gc => On => On
zend.exception_ignore_args => On => On
zend.multibyte => Off => Off
zend.script_encoding => no value => no value
zend.signal_check => Off => Off

ctype

ctype functions => enabled

curl

cURL support => enabled
cURL Information => 7.70.0
Age => 6
Features
AsynchDNS => Yes
CharConv => No
Debug => No
GSS-Negotiate => No
IDN => No
IPv6 => Yes
krb4 => No
Largefile => Yes
libz => Yes
NTLM => No
NTLMWB => No
SPNEGO => No
SSL => Yes
SSPI => No
TLS-SRP => Yes
HTTP2 => No
GSSAPI => No
KERBEROS5 => No
UNIX_SOCKETS => Yes
PSL => No
HTTPS_PROXY => Yes
MULTI_SSL => No
BROTLI => No
Protocols => dict, file, ftp, ftps, gopher, http, https, imap, imaps, ldap, ldaps, pop3, pop3s, rtsp, smtp, smtps, telnet, tftp
Host => x86_64-apple-darwin
SSL Version => OpenSSL/1.1.1g
ZLib Version => 1.2.11

Directive => Local Value => Master Value
curl.cainfo => no value => no value

date

date/time support => enabled
timelib version => 2018.03
"Olson" Timezone Database Version => 2020.1
Timezone Database => internal
Default timezone => UTC

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 => no value => no value

dba

DBA support => enabled
Supported handlers => cdb cdb_make 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.10
HTML Support => enabled
XPath Support => enabled
XPointer Support => enabled
Schema Support => enabled
RelaxNG Support => enabled

exif

EXIF Support => enabled
Supported EXIF Version => 0220
Supported filetypes => JPEG, TIFF
Multibyte decoding support using mbstring => enabled
Extended EXIF tag formats => Canon, Casio, Fujifilm, Nikon, Olympus, Samsung, Panasonic, DJI, Sony, Pentax, Minolta, Sigma, Foveon, Kyocera, Ricoh, AGFA, Epson

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
libmagic => 537

filter

Input Validation and Filtering => enabled

Directive => Local Value => Master Value
filter.default => unsafe_raw => unsafe_raw
filter.default_flags => no value => no value

ftp

FTP support => enabled
FTPS support => enabled

gd

GD Support => enabled
GD Version => bundled (2.1.0 compatible)
FreeType Support => enabled
FreeType Linkage => with freetype
FreeType Version => 2.10.1
GIF Read Support => enabled
GIF Create Support => enabled
JPEG Support => enabled
libJPEG Version => 9 compatible
PNG Support => enabled
libPNG Version => 1.6.37
WBMP Support => enabled
XBM Support => enabled
JIS-mapped Japanese Font Support => enabled
BMP Support => enabled
TGA Read Support => enabled

Directive => Local Value => Master Value
gd.jpeg_ignore_warning => 1 => 1

hash

hash support => enabled
Hashing Engines => md2 md4 md5 sha1 sha224 sha256 sha384 sha512/224 sha512/256 sha512 sha3-224 sha3-256 sha3-384 sha3-512 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 crc32c 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 => libiconv
iconv library version => 1.16

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

json

json support => enabled

libxml

libXML support => active
libXML Compiled Version => 2.9.10
libXML Loaded Version => 20910
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) version => 6.9.4

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.regex_retry_limit => 1000000 => 1000000
mbstring.regex_stack_limit => 100000 => 100000
mbstring.strict_detection => Off => Off
mbstring.substitute_character => no value => no value

mysqli

MysqlI Support => enabled
Client API library version => mysqlnd 7.4.7
Active Persistent Links => 0
Inactive Persistent Links => 0
Active Links => 0

Directive => Local Value => Master Value
mysqli.allow_local_infile => Off => Off
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 => no value => no value
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 7.4.7
Compression => supported
core SSL => supported
extended SSL => supported
Command buffer size => 4096
Read buffer size => 32768
Read timeout => 86400
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_caching_sha2_password,auth_plugin_sha256_password
API Extensions => pdo_mysql,mysqli

openssl

OpenSSL support => enabled
OpenSSL Library Version => OpenSSL 1.1.1g  21 Apr 2020
OpenSSL Header Version => OpenSSL 1.1.1g  21 Apr 2020
Openssl default config => /Applications/PHP7/ssl/openssl.cnf

Directive => Local Value => Master Value
openssl.cafile => no value => no value
openssl.capath => no value => no value

pcntl

pcntl support => enabled

pcre

PCRE (Perl Compatible Regular Expressions) Support => enabled
PCRE Library Version => 10.34 2019-11-21
PCRE Unicode Version => 12.1.0
PCRE JIT Support => not compiled in

Directive => Local Value => Master Value
pcre.backtrack_limit => 1000000 => 1000000
pcre.recursion_limit => 100000 => 100000

PDO

PDO support => enabled
PDO drivers => mysql, sqlite

pdo_mysql

PDO Driver for MySQL => enabled
Client API version => mysqlnd 7.4.7

Directive => Local Value => Master Value
pdo_mysql.default_socket => /tmp/mysql.sock => /tmp/mysql.sock

pdo_sqlite

PDO Driver for SQLite 3.x => enabled
SQLite Library => 3.31.1

Phar

Phar: PHP Archive support => enabled
Phar API version => 1.1.1
Phar-based phar archives => enabled
Tar-based phar archives => enabled
ZIP-based phar archives => enabled
gzip compression => enabled
bzip2 compression => disabled (install ext/bz2)
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

POSIX support => enabled

Reflection

Reflection => enabled

session

Session Support => enabled
Registered save handlers => files user
Registered serializer handlers => php_serialize php php_binary

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 => no value => no value
session.cookie_lifetime => 0 => 0
session.cookie_path => / => /
session.cookie_samesite => no value => no value
session.cookie_secure => 0 => 0
session.gc_divisor => 1000 => 1000
session.gc_maxlifetime => 1440 => 1440
session.gc_probability => 1 => 1
session.lazy_write => On => On
session.name => PHPSESSID => PHPSESSID
session.referer_check => no value => no value
session.save_handler => files => files
session.save_path => no value => no value
session.serialize_handler => php => php
session.sid_bits_per_character => 5 => 5
session.sid_length => 26 => 26
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 => 1 => 1
session.use_only_cookies => 1 => 1
session.use_strict_mode => 0 => 0
session.use_trans_sid => 0 => 0

shmop

shmop support => enabled

SimpleXML

SimpleXML support => enabled
Schema support => enabled

soap

Soap Client => enabled
Soap Server => enabled

Directive => Local Value => Master Value
soap.wsdl_cache => 1 => 1
soap.wsdl_cache_dir => /tmp => /tmp
soap.wsdl_cache_enabled => 1 => 1
soap.wsdl_cache_limit => 5 => 5
soap.wsdl_cache_ttl => 86400 => 86400

sockets

Sockets Support => enabled

SPL

SPL support => enabled
Interfaces => 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

sqlite3

SQLite3 support => enabled
SQLite Library => 3.31.1

Directive => Local Value => Master Value
sqlite3.defensive => 1 => 1
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.exception => 0 => 0
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
session.trans_sid_hosts => no value => no value
session.trans_sid_tags => a=href,area=href,frame=src,form= => a=href,area=href,frame=src,form=
unserialize_max_depth => 4096 => 4096
url_rewriter.hosts => no value => no value
url_rewriter.tags => form= => form=
user_agent => no value => no value

sysvmsg

sysvmsg support => enabled

sysvsem

sysvsem support => enabled

sysvshm

sysvshm support => enabled

tokenizer

Tokenizer Support => enabled

xml

XML Support => active
XML Namespace Support => active
libxml2 Version => 2.9.10

xmlreader

XMLReader => enabled

xmlrpc

core library version => xmlrpc-epi v. 0.51
author => Dan Libby
homepage => http://xmlrpc-epi.sourceforge.net
open sourced by => Epinions.com

xmlwriter

XMLWriter => enabled

xsl

XSL => enabled
libxslt Version => 1.1.34
libxslt compiled against libxml Version => 2.9.10
EXSLT => enabled
libexslt Version => 1.1.29

zip

Zip => enabled
Zip version => 1.15.6
Libzip headers version => 1.3.2
Libzip library version => 1.3.2

zlib

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

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

Environment

Variable => Value
TERM_PROGRAM => Apple_Terminal
SHELL => /bin/bash
TERM => xterm-256color
TMPDIR => /var/folders/wm/yhfj8k7n2n36kjsbvrrv8zhm0000gn/T/
Apple_PubSub_Socket_Render => /private/tmp/com.apple.launchd.kBNqfj09rj/Render
TERM_PROGRAM_VERSION => 421.2
TERM_SESSION_ID => 08E84774-109B-4C47-A627-FB5679188563
USER => admin
SSH_AUTH_SOCK => /private/tmp/com.apple.launchd.WZQPAyWXcy/Listeners
PATH => /Applications/PHP7/bin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin
PWD => /Users/admin
LANG => en_US.UTF-8
XPC_FLAGS => 0x0
XPC_SERVICE_NAME => 0
SHLVL => 1
HOME => /Users/admin
LOGNAME => admin
SECURITYSESSIONID => 186aa
_ => /Applications/PHP7/bin/php
OLDPWD => /Applications/PHP7/lib/php/extensions/no-debug-non-zts-20190902
__CF_USER_TEXT_ENCODING => 0x1F5:0x0:0x0

PHP Variables

Variable => Value
$_SERVER['TERM_PROGRAM'] => Apple_Terminal
$_SERVER['SHELL'] => /bin/bash
$_SERVER['TERM'] => xterm-256color
$_SERVER['TMPDIR'] => /var/folders/wm/yhfj8k7n2n36kjsbvrrv8zhm0000gn/T/
$_SERVER['Apple_PubSub_Socket_Render'] => /private/tmp/com.apple.launchd.kBNqfj09rj/Render
$_SERVER['TERM_PROGRAM_VERSION'] => 421.2
$_SERVER['TERM_SESSION_ID'] => 08E84774-109B-4C47-A627-FB5679188563
$_SERVER['USER'] => admin
$_SERVER['SSH_AUTH_SOCK'] => /private/tmp/com.apple.launchd.WZQPAyWXcy/Listeners
$_SERVER['PATH'] => /Applications/PHP7/bin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin
$_SERVER['PWD'] => /Users/admin
$_SERVER['LANG'] => en_US.UTF-8
$_SERVER['XPC_FLAGS'] => 0x0
$_SERVER['XPC_SERVICE_NAME'] => 0
$_SERVER['SHLVL'] => 1
$_SERVER['HOME'] => /Users/admin
$_SERVER['LOGNAME'] => admin
$_SERVER['SECURITYSESSIONID'] => 186aa
$_SERVER['_'] => /Applications/PHP7/bin/php
$_SERVER['OLDPWD'] => /Applications/PHP7/lib/php/extensions/no-debug-non-zts-20190902
$_SERVER['__CF_USER_TEXT_ENCODING'] => 0x1F5:0x0:0x0
$_SERVER['PHP_SELF'] =>
$_SERVER['SCRIPT_NAME'] =>
$_SERVER['SCRIPT_FILENAME'] =>
$_SERVER['PATH_TRANSLATED'] =>
$_SERVER['DOCUMENT_ROOT'] =>
$_SERVER['REQUEST_TIME_FLOAT'] => 1594349577.7722
$_SERVER['REQUEST_TIME'] => 1594349577
$_SERVER['argv'] => Array
(
)

$_SERVER['argc'] => 0

PHP License
This program is free software; you can redistribute it and/or modify
it under the terms of the PHP License as published by the PHP Group
and included in the distribution in the file:  LICENSE

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

If you did not receive a copy of the PHP license, or have any
questions about PHP licensing, please contact license@php.net.
Back to top View user's profile Send private message
JohnEDee
-


Joined: 30 Jan 2019
Posts: 31

PostPosted: Sat Jul 11, 2020 1:01 am    Post subject: Reply with quote

Emailed Support and they confirmed that ODBC is missing from the Aprelium-supplied package, so they're compiling a new one. :-)
Back to top View user's profile Send private message
admin
Site Admin


Joined: 03 Mar 2002
Posts: 1295

PostPosted: Wed Jul 15, 2020 6:17 pm    Post subject: Reply with quote

JohnEDee,

We have just released the preconfigured PHP 7.4.8 for macOS with ODBC support.

https://aprelium.com/forum/viewtopic.php?p=802051
_________________
Follow @abyssws on Twitter
Subscribe to our newsletter
_________________
Forum Administrator
Aprelium - https://aprelium.com
Back to top View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> PHP All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group