Undefined constant "OCI_COMMIT_ON_SUCCESS" error

818 views
Skip to first unread message

Nazar Hrytsuniak

unread,
Nov 29, 2022, 10:29:00 AM11/29/22
to Fusio
Hi.
Thanks for the fusio)

I've got the following error "Undefined constant "OCI_COMMIT_ON_SUCCESS" error" while trying to create a connection to Oracle db.
I used docker compose configs from https://github.com/apioo/fusio-docker. Do I need to do some additional configuration to be able to connect?

-Nazar

Christoph Kappestein

unread,
Nov 29, 2022, 1:41:56 PM11/29/22
to Fusio

Hi,

basically this means that the PHP oracle extension is not available, by default this is not configured please take a look at the PR s.

where a user has added oracle support. If there is a demand we could also embed the PHP oracle extension by default in our image but this also increases the complexity
of our image, so if you need oracle support by default please let me know. For the time being you can manually build the image with oracle support.

best regards
Christoph

Nazar Hrytsuniak

unread,
Dec 1, 2022, 4:24:51 PM12/1/22
to Fusio
Thanks. Docker file that you sent is enough.
I was able to create Oracle connection, but when I tried to execute I've got another error: 
 "success": false, 
 "message": "An error occurred at the worker: Undefined constant 'OCI_NO_AUTO_COMMIT'" 
}

вівторок, 29 листопада 2022 р. о 20:41:56 UTC+2 christoph....@gmail.com пише:

Christoph Kappestein

unread,
Dec 4, 2022, 4:50:10 AM12/4/22
to Fusio
Hi Nazar,

this is because the worker php client needs also the Oracle client, a user has here made also a PR to add this to the worker s.

In case you only want to connect to an Oracle database and dont want to install Fusio on an Oracle it is also enough to only
add the oracle client to the worker.

best regards
Christoph
Reply all
Reply to author
Forward
0 new messages