Open Source Development

Power Open Source Development

Explore the open source tools and capabilities for building and deploying modern applications on IBM Power platforms including AIX, IBM i, and Linux.


#Power


#Power

 View Only
  • 1.  httpd compiled with mysql support ?

    Posted Thu November 18, 2021 02:00 AM
    Hi there

    We want to use the latest httpd with php7 and also mysql server 8. We have everything running but it seems we would need a httpd version compiled with
    mysqli extension enabled:

    './configure' '--prefix=/opt/freeware' '--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--enable-shared' '--enable-cli' '--mandir=/opt/freeware/man' '--with-ldap=/opt/freeware' '--disable-debug' '--enable-dom' '--enable-json' '--enable-soap=shared' '--enable-ftp' '--without-pear' '--with-openssl=/usr' '--with-iconv=/opt/freeware' '--enable-fpm' '--enable-gd=shared' '--with-external-gd' '--with-jpeg-dir=/opt/freeware' '--with-png-dir=/opt/freeware' '--with-freetype' '--with-zlib=shared' '--with-curl=shared' '--with-bz2=shared' '--enable-exif=shared' '--with-apxs2=/opt/freeware/bin/apxs_64' '--libdir=/opt/freeware/lib64/php' '--without-mysqli' '--disable-pdo' 'PKG_CONFIG_PATH=/opt/freeware/lib64/pkgconfig:/opt/freeware/lib/pkgconfig' 'OPENSSL_CFLAGS=-I/usr/include/openssl' 'OPENSSL_LIBS=-lssl -lcrypto' 'PNG_CFLAGS=-I/opt/freeware/include' 'PNG_LIBS=-lpng' 'GDLIB_CFLAGS=-I/opt/freeware/include' 'GDLIB_LIBS=-lgd'

    Is this something you could consider ? Or do I miss something.

    Thanks and kind regards.




    ------------------------------
    Stefano Calisto
    ------------------------------

    #AIXOpenSource


  • 2.  RE: httpd compiled with mysql support ?

    Posted Thu November 18, 2021 02:23 AM
    Edited by Ayappan P Thu November 18, 2021 02:23 AM
    If I understand correctly you need php with mysql support. 
    The Toolbox php currently has it. 
    This is the AIX Toolbox php configuration.
    # /opt/freeware/bin/php -i
    phpinfo()
    PHP Version => 7.4.22

    System =>. XXXXXX
    Build Date => Sep 2 2021 12:11:30
    Configure Command => './configure' '--prefix=/opt/freeware' '--libdir=/opt/freeware/lib/php' '--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--enable-shared' '--enable-cli' '--mandir=/opt/freeware/man' '--with-ldap=/opt/freeware' '--disable-debug' '--enable-dom' '--enable-json' '--enable-soap=shared' '--enable-ftp' '--without-pear' '--with-openssl=/usr' '--with-iconv=/opt/freeware' '--enable-fpm' '--with-jpeg-dir=/opt/freeware' '--with-png-dir=/opt/freeware' '--with-freetype' '--enable-gd=shared' '--with-external-gd' '--with-zlib=shared' '--with-curl=shared' '--with-bz2=shared' '--enable-exif=shared' '--enable-mysqlnd=shared' '--with-mysqli=shared,mysqlnd' '--enable-pdo=shared' '--with-pdo-sqlite=shared,/opt/freeware' '--with-pdo-mysql=shared,mysqlnd' 'PKG_CONFIG_PATH=/opt/freeware/lib/pkgconfig' 'OPENSSL_CFLAGS=-I/usr/include/openssl' 'OPENSSL_LIBS=-lssl -lcrypto' 'PNG_CFLAGS=-I/opt/freeware/include' 'PNG_LIBS=-lpng' 'GDLIB_CFLAGS=-I/opt/freeware/include' 'GDLIB_LIBS=-lgd'

    The module is delivered through the "php-mysqlnd" rpm.

    ------------------------------
    Ayappan P
    ------------------------------



  • 3.  RE: httpd compiled with mysql support ?

    Posted Thu November 18, 2021 02:53 AM

    Hi there

     

    Thanks for the input I forgot to install php-mysqlnd.

     

    Thanks and kind regards,

     

    Stefano