[Info-ingres] Ingres Linux, Apache, PHP, ODBC and Joomla

[Paul White]

I'm hoping to get some assistance identifying a simple Joomla installation
recipe for Ingres/ActianX.

I read some time ago, that Ingres Community portal was powered by Joomla. I
guess this is prior to migration to SalesForce.    I am curious to know if
underlying database was Ingres or some other?

I found dead end here:
https://pecl.php.net/package/ingres/2.2.4
https://www.php.net/manual/en/book.ingres.php
http://community.ingres.com/wiki/Ingres_Articles#Ingres_and_Web_Servers
(could not find)

In the build of the PECL library there were lots of errors about invalid or
missing functions I think related to the zend library incompatibility withy
PHP7.   Here is an example of one of many errors:

error: ‘OnUpdateInt’ undeclared here (not in a function); did you mean
‘OnUpdateLong’

I had success with PHP ODBC instructions from here:
https://communities.actian.com/s/article/Ingres-ODBC-with-PHP

With Ingres 11.1, the PHP examples worked from command line straight up.
Publishing the examples to a URL proved difficult and needed help from
secret ninja PHP masters, I observed the LD_LIBRARY_PATH and ODBCSYSINI
variables confused matters for unixodbc and eventually removed the settings
out of httpd configuration.  So this works:

http://myurl/test3.php
>>success

After this, I started Joomla install sequence, the second page has a drop
down for database selection; initially NONE, I installed mysql (and lots of
other php modules) and then found there is just one DB offered, MYSQLi.
Behind the scenes, the configuration code has comments mentioning Ingres,
Postgres and several others but apparently disabled.   In the end, I have
picked mysql and then Joomla installed easily.

At this point I plan to try converting the MYSQL sqldump file to an
ingres load script and see if I can point the currently running
installation to Ingres via ODBC or through the DAS.


Paul White
&
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200206/1723a043/attachment.html>