Originally posted by: Gusb

Hi Team

I want to ask if there are plans to make new rpm packages for the most updated versions of Mysql or mariadb

Thanks in advance.

Originally posted by: T.Rex

Hi,

Before it is available here, maybe you could give a try to MariaDB 10.4.7 for AIX 7.2 from:  http://gnome.bullfreeware.com/?searching=true&package=mariadb&from=&to=&libraries=false&exact=false&version=5

We have still some incompatibilities with AIX ToolBox stuff however (  /opt/freeware/lib64/libcrypto.a(libcrypto.so.1.0.2)). Hope that they do not appear in this case.

I would be interested to know if this release does deliver all that a MariaDB user may need on AIX.

About MySQL, its' coming. Be patient. Let us know what you need from MySQL (so many plugins...).

Tony

Originally posted by: Gusb

Hi

I trying to use all packages from AIX Toolbox to avoid incompatibilities, this MySQL must be used with httpd and php, so I think the plugins for php and httpd are also needed.

Thanks in advance.

Gustavo.

Originally posted by: T.Rex

Hi

Do you have constraints about the versions of PHP and httpd ?

About MySQL, there are different components :

    MySQL Community Server
    MySQL Cluster
    MySQL Router
    MySQL Shell
    MySQL Workbench

Which ones do you need?

About "MySQL Community Server", we are working now on v8.0.16 & 8.0.17 . Are these the versions you need?

Thx

T.

Originally posted by: Gusb

Hi T.

Yes, "MySQL Community Server", I tried to compile 8.0.17, but I had problems with cmake and XLC/ gcc , the compilation doesn't worked.  If exist any RPM it would be great.

Also I will use it with the versions of PHP and httpd available on AIX Toolbox.

Thanks in advance.

Gustavo.

Originally posted by: T.Rex

Hi G.

Yes. Building MySQL on AIX is hell. Moreover, it must be built in DEBUG & RELEASE modes in order to find and fix all issues. I'm near the end now. With GCC 8.3 .

About CMake, we are using a transient version adapted to AIX that we have created. The official CMake project plans to deliver very soon (tomorrow maybe) a new version including some major changes for AIX. However, since they do not want to break some compatibility with past (wrong) behavior, they will not provide all that we required us to add and we'll provide our own CMake version on BullFreeware and we'll continue to work with the CMake community/company in order to push them to integrate all changes required by AIX. That means that, probably in October, you could use our CMake patches and .spec files to rebuild it and use it with MySQL if you still want to fight with MySQL. Or wait for a first release of MySQL, maybe in October if I can understand/fix a new issue I face now in RELEASE mode.

Regards,

Tony

Originally posted by: Gusb

Hi Tony

Definetively I need the rpm bin package for AIX, currently I already installed OpenSSL 1.0.2 on AIX 7.2, the objetive of install CMake was only for complie binaries for the latest MySQL, but I don't need CMake. Just MySQL to use with httpd and php available on AIX toolbox page.

Thanks in advance.

Gustavo.

Originally posted by: sanket

We are planning to publish MariaDB from AIX toolbox sooner. Hope we will have it 2 weeks. 

Originally posted by: sanket

We have published our first version of MariaDB on AIX toolbox.

Please try it and we would like to hear feedback about same. 

Originally posted by: Gusb

Hi Team

I cannot find package.

Could you provide URL Link, thanks in advance.

Gustavo.

Originally posted by: CS5D_Jesse_Harmon

Gustavo,

Here are the links for 7.2:

Index of /aix/freeSoftware/aixtoolbox/RPMS/ppc-7.2/mariadb
https://public.dhe.ibm.com/aix/freeSoftware/aixtoolbox/RPMS/ppc-7.2/mariadb/?C=M;O=D

Index of /aix/freeSoftware/aixtoolbox/RPMS/ppc-7.2/mariadb-connector-c
https://public.dhe.ibm.com/aix/freeSoftware/aixtoolbox/RPMS/ppc-7.2/mariadb-connector-c/?C=M;O=D

Thanks,

Jesse

Originally posted by: sanket

Thank you Jesse !!

Originally posted by: Gusb

I installed and mariaDB works, but I cannot use inside PHP,

php -m

shows

php -m
[PHP Modules]
Core
ctype
date
dom
fileinfo
filter
ftp
hash
iconv
json
ldap
libxml
openssl
pcre
PDO
pdo_sqlite
Phar
posix
Reflection
session
SimpleXML
soap
SPL
sqlite3
standard
tokenizer
xml
xmlreader
xmlwriter

[Zend Modules]

But no mysqli modules are  inside. How I could fix it?

Thanks in advance.

Originally posted by: AyappanP

MariaDB is published only recently in AIX Toolbox. And it's a beta release. We are working on a new version. 

After that we will enable mysql support in php. 

Originally posted by: Gusb

Hello Team, I need connection from php to mariadb, The .so to connect to mariadb is not available on the binary.

Alternatively I tried to compile the sources  available on AIX toolox but the compliation fails:

I downloaded php source code from:

https://public.dhe.ibm.com/aix/freeSoftware/aixtoolbox/SRPMS/php/php-7.2.19-2.src.rpm

by adding "--with-mysql=/opt/freeware/bin/mysql_config \ " in the .spec file

 The following is the output:

root@c01:/opt/freeware/src/packages/SPECS>rpmbuild -ba php-7.2.19-2.spec
warning: Macro %dotests defined but not used within scope
warning: bogus date in %changelog: Thu Aug 31 2018 Reshma V Kumar <reskumar@in.ibm.com> 7.0.31-1
warning: bogus date in %changelog: Thu Nov 25 2016 Nitish K Mishra <nitismis@in.ibm.com> 7.0.13-1
warning: bogus date in %changelog: Thu Nov 26 2008 Michael Perzl <michael@perzl.org> - 5.2.8-1
Executing(%prep): /bin/sh -e /var/tmp/rpm-tmp.q8wMea
+ umask 022
+ cd /opt/freeware/src/packages/BUILD
+ cd /opt/freeware/src/packages/BUILD
+ rm -rf php-7.2.19
+ /bin/gzip -dc /opt/freeware/src/packages/SOURCES/php-7.2.19.tar.gz
+ /bin/tar -xof -
+ STATUS=0
+ [ 0 -ne 0 ]
+ cd php-7.2.19
+ /bin/chmod -Rf a+rX,u+w,g-w,o-w .
+ echo Patch #0 (php-7.2.19-aixconfig.patch):
Patch #0 (php-7.2.19-aixconfig.patch):
+ /opt/freeware/bin/patch --no-backup-if-mismatch -p1 -b --suffix .aixconfig --fuzz=2
+ 0< /opt/freeware/src/packages/SOURCES/php-7.2.19-aixconfig.patch
patching file ext/mysqlnd/mysqlnd_result.c
+ echo Patch #2 (php-7.2.19-aix-build.patch):
Patch #2 (php-7.2.19-aix-build.patch):
+ /opt/freeware/bin/patch --no-backup-if-mismatch -p1 -b --suffix .build --fuzz=2
+ 0< /opt/freeware/src/packages/SOURCES/php-7.2.19-aix-build.patch
patching file Makefile.global
patching file configure
Hunk #1 succeeded at 7237 (offset 146 lines).
Hunk #2 succeeded at 10204 (offset 1 line).
patching file sapi/cgi/config9.m4
patching file sapi/cli/config.m4
+ echo Patch #3 (php-7.2.19-aix-network.patch):
Patch #3 (php-7.2.19-aix-network.patch):
+ /opt/freeware/bin/patch --no-backup-if-mismatch -p1 -b --suffix .network --fuzz=2
+ 0< /opt/freeware/src/packages/SOURCES/php-7.2.19-aix-network.patch
patching file ext/standard/basic_functions.c
Hunk #1 succeeded at 3986 (offset 31 lines).
+ echo Patch #4 (php-7.2.19-aix-setrlimit.patch):
Patch #4 (php-7.2.19-aix-setrlimit.patch):
+ /opt/freeware/bin/patch --no-backup-if-mismatch -p1 -b --suffix .setrlimit --fuzz=2
+ 0< /opt/freeware/src/packages/SOURCES/php-7.2.19-aix-setrlimit.patch
patching file ext/posix/posix.c
+ echo Patch #6 (php-7.2.19-aix-tests.patch):
Patch #6 (php-7.2.19-aix-tests.patch):
+ /opt/freeware/bin/patch --no-backup-if-mismatch -p1 -b --suffix .tests --fuzz=2
+ 0< /opt/freeware/src/packages/SOURCES/php-7.2.19-aix-tests.patch
patching file ext/soap/tests/bugs/bug29109.wsdl
+ echo Patch #7 (php-7.2.19-aix-trailing-slash.patch):
Patch #7 (php-7.2.19-aix-trailing-slash.patch):
+ /opt/freeware/bin/patch --no-backup-if-mismatch -p1 -b --suffix .trailing-slash --fuzz=2
+ 0< /opt/freeware/src/packages/SOURCES/php-7.2.19-aix-trailing-slash.patch
patching file Zend/zend_virtual_cwd.c
Hunk #1 succeeded at 368 (offset -40 lines).
patching file main/streams/plain_wrapper.c
patching file Zend/zend_virtual_cwd.h
patching file Zend/zend_virtual_cwd.c
+ echo Patch #9 (php-7.2.18-fpm.patch):
Patch #9 (php-7.2.18-fpm.patch):
+ /opt/freeware/bin/patch --no-backup-if-mismatch -p0 --fuzz=2
+ 0< /opt/freeware/src/packages/SOURCES/php-7.2.18-fpm.patch
patching file configure
+ rm -rf /tmp/php-7.2.19-32bit
+ cp -pr . /tmp/php-7.2.19-32bit
+ rm -fr CODING_STANDARDS CONTRIBUTING.md CREDITS EXTENSIONS INSTALL LICENSE Makefile.frag Makefile.gcov Makefile.global Makefile.global.build NEWS README.EXT_SKEL README.GIT-RULES README.MAILINGLIST_RULES README.NEW-OUTPUT-API README.PARAMETER_PARSING_API README.REDIST.BINS README.RELEASE_PROCESS README.SELF-CONTAINED-EXTENSIONS README.STREAMS README.SUBMITTING_PATCH README.TESTING README.TESTING2 README.UNIX-BUILD-SYSTEM README.WIN32-BUILD-SYSTEM README.input_filter README.md TSRM UPGRADING UPGRADING.INTERNALS Zend acinclude.m4 aclocal.m4 appveyor build buildconf buildconf.bat config.guess config.sub configure configure.ac configure.build ext footer generated_lists genfiles header install-sh ltmain.sh main makedist missing mkinstalldirs pear php.gif php.ini-development php.ini-production php7.spec.in run-tests.php sapi scripts server-tests-config.php server-tests.php snapshot stamp-h.in tests travis vcsclean win32
+ mv /tmp/php-7.2.19-32bit 32bit
+ cp -pr 32bit 64bit
+ exit 0
Executing(%build): /bin/sh -e /var/tmp/rpm-tmp.2JwMeb
+ umask 022
+ cd /opt/freeware/src/packages/BUILD
+ cd php-7.2.19
+ export CC=/opt/freeware/bin/gcc -fPIC
+ export CXX=/opt/freeware/bin/g++
+ export OBJECT_MODE=64
+ cd 64bit
+ export CFLAGS=-Wl,-bbigtoc -I/usr/include/openssl -O2 -maix64 -I/opt/freeware/include
+ export LDFLAGS=-L/opt/freeware/lib64 -L/usr/lib64 -L/opt/freeware/lib -L/usr/lib -lm -lXpm -lpthread -Wl,-blibpath:/opt/freeware/lib64:/opt/freeware/lib:/usr/lib:/lib
+ export PHP_LDFLAGS=-L/opt/freeware/lib64 -L/opt/freeware/lib -L/usr/lib -lm -Wl,-blibpath:/opt/freeware/lib64:/opt/freeware/lib:/usr/lib:/lib
+ patch -p0
+ 0< /opt/freeware/src/packages/SOURCES/php-7.2.19-phpini.patch
Hmm...  Looks like a unified context diff to me...
The text leading up to this was:
--------------------------
|--- main/php_ini.c.orig        2019-04-29 03:09:18 +0000
|+++ main/php_ini.c     2019-04-29 03:09:36 +0000
--------------------------
Patching file main/php_ini.c using Plan A...
Hunk #1 failed at 612.
1 out of 1 hunks failed--saving rejects to main/php_ini.c.rej
done
error: Bad exit status from /var/tmp/rpm-tmp.2JwMeb (%build)

RPM build errors:
    Macro %dotests defined but not used within scope
    bogus date in %changelog: Thu Aug 31 2018 Reshma V Kumar <reskumar@in.ibm.com> 7.0.31-1
    bogus date in %changelog: Thu Nov 25 2016 Nitish K Mishra <nitismis@in.ibm.com> 7.0.13-1
    bogus date in %changelog: Thu Nov 26 2008 Michael Perzl <michael@perzl.org> - 5.2.8-1
    Bad exit status from /var/tmp/rpm-tmp.2JwMeb (%build)
root@c01:/opt/freeware/src/packages/SPECS>

Could you help me to add mariaDB support to php available on AIX toolbox?

Thanks in advance.

Gustavo.