Can not load the plugin 'OraclePlugin64.so'

Hi there

On a web server (Ubuntu 16, Apache, Oracle Instant Client 12) two applications are installed, which were developed with Xojo 2019r1.
An application does not need a database and works properly. The other application ‘Test_Oracle’ wants to establish a database connection, but can not load the plugin ‘OraclePlugin64.so’.

Because the environment variable LD_LIBRARY_PATH does not exist on the web server, I added the Perl script ‘Test_Oracle.cgi’ with the following command:
$ ENV {“LD_LIBRARY_PATH”} = “/usr/lib/oracle/12.1/client64/lib:/usr/lib/cgi-bin/Test_Oracle/LIBS”;

(LIBS is a symbolic link to the directory ‘/usr/lib/cgi-bin/Test_Oracle/Test_Oracle Libs’).

Nevertheless, it does not work.

I still get the following errors:
[Tue Jul 23 16:34:49.507389 2019] [cgi:error] [pid 61335] [client 10.48.74.21:58081] AH01215: Failed to load plugin OraclePlugin64.so:: /usr/lib/cgi-bin/Test_Oracle/test_oracle.cgi
[Tue Jul 23 16:34:49.507461 2019] [cgi:error] [pid 61335] [client 10.48.74.21:58081] AH01215: libstdc++.so.5: cannot open shared object file: No such file or directory: /usr/lib/cgi-bin/Test_Oracle/test_oracle.cgi
[Tue Jul 23 16:34:49.508569 2019] [cgi:error] [pid 61335] [client 10.48.74.21:58081] AH01215: Can’t use an undefined value as a symbol reference at /usr/lib/cgi-bin/Test_Oracle/test_oracle.cgi line 118.: /usr/lib/cgi-bin/Test_Oracle/test_oracle.cgi
[Tue Jul 23 16:34:49.509235 2019] [cgi:error] [pid 61335] [client 10.48.74.21:58081] End of script output before headers: test_oracle.cgi

Can someone help?

You should get this fixed first.

Hello Greg

Thank you for your reference.
We were able to install the missing library libstdc++.so.5. The problem with loading the plugin ‘OraclePlugin64.so’ is not fixed yet. We now receive the following error messages:

[Tue Jul 30 16:24:38.673730 2019] [cgi:error] [pid 2752] [client 10.48.74.21:50266] AH01215: Failed to load plugin OraclePlugin64.so:: /usr/lib/cgi-bin/Test_Oracle/test_oracle.cgi
[Tue Jul 30 16:24:38.673844 2019] [cgi:error] [pid 2752] [client 10.48.74.21:50266] AH01215: /usr/lib/x86_64-linux-gnu/libstdc++.so.5: version `CXXABI_1.2’ not found (required by /usr/lib/oracle/10.2.0.4/client64/lib/libocci.so.10.1): /usr/lib/cgi-bin/Test_Oracle/test_oracle.cgi

Although we only have one Oracle 12 Instant Client installed, 'OraclePlugin64.so’wants to load an Oracle 10.2.0.4 version. With the command: ‘ld OraclePlugin64.so’ I see that in ‘OraclePlugin64.so’ the Oracle 10 version (libocci.so.10.1) is required.

root@kyanit:/usr/lib/cgi-bin/Test_Oracle/LIBS# ld OraclePlugin64.so
ld: warning: libocci.so.10.1, needed by OraclePlugin64.so, not found (try using -rpath or -rpath-link)
ld: warning: libclntsh.so.10.1, needed by OraclePlugin64.so, not found (try using -rpath or -rpath-link)
ld: warning: libc++.so.1, needed by OraclePlugin64.so, not found (try using -rpath or -rpath-link)

Because Oracle 10 is no longer used on new systems for security reasons, I think the problem is in ‘OraclePlugin64.so’. Did I get an old version of ‘OraclePlugin64.so’ from Xojo or is it a mistake?

[quote=447941:@Willi Gschwend]Hello Greg

Thank you for your reference.
We were able to install the missing library libstdc++.so.5. The problem with loading the plugin ‘OraclePlugin64.so’ is not fixed yet. We now receive the following error messages:

[Tue Jul 30 16:24:38.673730 2019] [cgi:error] [pid 2752] [client 10.48.74.21:50266] AH01215: Failed to load plugin OraclePlugin64.so:: /usr/lib/cgi-bin/Test_Oracle/test_oracle.cgi
[Tue Jul 30 16:24:38.673844 2019] [cgi:error] [pid 2752] [client 10.48.74.21:50266] AH01215: /usr/lib/x86_64-linux-gnu/libstdc++.so.5: version `CXXABI_1.2’ not found (required by /usr/lib/oracle/10.2.0.4/client64/lib/libocci.so.10.1): /usr/lib/cgi-bin/Test_Oracle/test_oracle.cgi

Although we only have one Oracle 12 Instant Client installed, 'OraclePlugin64.so’wants to load an Oracle 10.2.0.4 version. With the command: ‘ld OraclePlugin64.so’ I see that in ‘OraclePlugin64.so’ the Oracle 10 version (libocci.so.10.1) is required.

root@kyanit:/usr/lib/cgi-bin/Test_Oracle/LIBS# ld OraclePlugin64.so
ld: warning: libocci.so.10.1, needed by OraclePlugin64.so, not found (try using -rpath or -rpath-link)
ld: warning: libclntsh.so.10.1, needed by OraclePlugin64.so, not found (try using -rpath or -rpath-link)
ld: warning: libc++.so.1, needed by OraclePlugin64.so, not found (try using -rpath or -rpath-link)

Because Oracle 10 is no longer used on new systems for security reasons, I think the problem is in ‘OraclePlugin64.so’. Did I get an old version of ‘OraclePlugin64.so’ from Xojo or is it a mistake?[/quote]
I doubt “by mistake”. It sounds like we haven’t updated the oracle plugin in a while though.

Please file a bug report about this.