novaBBS - comp.lang.tcl - Re: Issue with Apache-Rivet and Oratcl

Issue with Apache-Rivet and Oratcl

<e16c21fc-183e-45f5-bd80-1a18222e1353n@googlegroups.com>

https://www.novabbs.com/devel/article-flat.php?id=10142&group=comp.lang.tcl#10142

X-Received: by 2002:a05:622a:5c8c:b0:35b:b250:340c with SMTP id ge12-20020a05622a5c8c00b0035bb250340cmr11458329qtb.511.1668420921919;
Mon, 14 Nov 2022 02:15:21 -0800 (PST)
X-Received: by 2002:ad4:58cf:0:b0:4bb:85a0:1d9d with SMTP id
dh15-20020ad458cf000000b004bb85a01d9dmr12135683qvb.69.1668420921642; Mon, 14
Nov 2022 02:15:21 -0800 (PST)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.tcl
Date: Mon, 14 Nov 2022 02:15:21 -0800 (PST)
Injection-Info: google-groups.googlegroups.com; posting-host=147.161.165.113; posting-account=AOHKvwoAAADOqNomb3yowcuAvYCdrLO6
NNTP-Posting-Host: 147.161.165.113
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <e16c21fc-183e-45f5-bd80-1a18222e1353n@googlegroups.com>
Subject: Issue with Apache-Rivet and Oratcl
From: mssrs...@gmail.com (Manfred Schwarz)
Injection-Date: Mon, 14 Nov 2022 10:15:21 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 3133

by: Manfred Schwarz - Mon, 14 Nov 2022 10:15 UTC

Hi All,

I am running a cient/server application that I need to migrate to a new server.
The server is running Apache Server 2.4.54 with rivet.
Oratcl should be used for the connection to a Oracle database, and should be loaded in a rivet-script when Apache starts.
For this purpose, the following command is in the Apache Conf file:

RivetServerConf ChildInitScript "source /apps/apache2.4.54/lib/conf/globalscript.tcl"

Inside globalscript.tcl are following lines:

set ::env(ORACLE_LIBRARY) "/mein_user/bin/oracle/instantclient_21_8/libclntsh.so.21.1"
set ::env(ORACLE_HOME) "/mein_user/bin/oracle/instantclient_21_8"
set ::env(LD_LIBRARY_PATH) "/mein_user/bin/oracle/instantclient_21_8"

lappend auto_path "/mein_user/lib/tcl/"
lappend auto_path "/mein_user/bin/oracle/instantclient_21_8/"

package require Oratcl 4.5

When "package require Oratcl" is called, I get following error message:

(20014)Internal error (specific information not available): mod_rivet: Error in Child init script: source /apps/apache2.4.54/lib/conf/globalscript.tcl
(20014)Internal error (specific information not available): errorCode: NONE
(20014)Internal error (specific information not available): errorInfo:
while executing
"load /mein_user/lib/tcl/Oratcl4.5/libOratcl4.5.so"
("package ifneeded Oratcl 4.5" script)
invoked from within
"package require Oratcl 4.5"
(file "/apps/apache2.4.54/lib/conf/globalscript.tcl" line 11)
invoked from within
"source /apps/apache2.4.54/lib/conf/globalscript.tcl"

When the Apache server is subsequently terminated, the following error message is output:

Oratcl_Init(): Failed to load /mein_user/bin/oracle/instantclient_21_8/libclntsh.so.21.1 with error libnnz21.so: cannot open shared object file: No such file or directory
Oratcl_Init(): ORACLE_LIBRARY = /mein_user/bin/oracle/instantclient_21_8/libclntsh.so.21.1 : file not found.

The libraries libclntsh.so.21.1 and libnnz21.so exists, and are in the same directory.

If I run globalscript.tcl in a Tcl shell, everything works fine.

Do you have any idea why the error occurs?

Manfred

Re: Issue with Apache-Rivet and Oratcl

<adcc1b0c-0a46-4eb6-bba5-1f19caa194b6n@googlegroups.com>

copy mid

https://www.novabbs.com/devel/article-flat.php?id=10143&group=comp.lang.tcl#10143

copy link Newsgroups: comp.lang.tcl

X-Received: by 2002:a0c:eda4:0:b0:4bc:129b:d783 with SMTP id h4-20020a0ceda4000000b004bc129bd783mr11955979qvr.69.1668426389404;
Mon, 14 Nov 2022 03:46:29 -0800 (PST)
X-Received: by 2002:ac8:7d94:0:b0:3a5:826c:1cfb with SMTP id
c20-20020ac87d94000000b003a5826c1cfbmr11708695qtd.643.1668426389083; Mon, 14
Nov 2022 03:46:29 -0800 (PST)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.tcl
Date: Mon, 14 Nov 2022 03:46:28 -0800 (PST)
In-Reply-To: <e16c21fc-183e-45f5-bd80-1a18222e1353n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=147.161.165.113; posting-account=AOHKvwoAAADOqNomb3yowcuAvYCdrLO6
NNTP-Posting-Host: 147.161.165.113
References: <e16c21fc-183e-45f5-bd80-1a18222e1353n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <adcc1b0c-0a46-4eb6-bba5-1f19caa194b6n@googlegroups.com>
Subject: Re: Issue with Apache-Rivet and Oratcl
From: mssrs...@gmail.com (Manfred Schwarz)
Injection-Date: Mon, 14 Nov 2022 11:46:29 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 3900

by: Manfred Schwarz - Mon, 14 Nov 2022 11:46 UTC

Manfred Schwarz schrieb am Montag, 14. November 2022 um 11:15:24 UTC+1:
> Hi All,
>
> I am running a cient/server application that I need to migrate to a new server.
> The server is running Apache Server 2.4.54 with rivet.
> Oratcl should be used for the connection to a Oracle database, and should be loaded in a rivet-script when Apache starts.
> For this purpose, the following command is in the Apache Conf file:
>
> RivetServerConf ChildInitScript "source /apps/apache2.4.54/lib/conf/globalscript.tcl"
>
> Inside globalscript.tcl are following lines:
>
> set ::env(ORACLE_LIBRARY) "/mein_user/bin/oracle/instantclient_21_8/libclntsh.so.21.1"
> set ::env(ORACLE_HOME) "/mein_user/bin/oracle/instantclient_21_8"
> set ::env(LD_LIBRARY_PATH) "/mein_user/bin/oracle/instantclient_21_8"
>
> lappend auto_path "/mein_user/lib/tcl/"
> lappend auto_path "/mein_user/bin/oracle/instantclient_21_8/"
>
> package require Oratcl 4.5
>
>
> When "package require Oratcl" is called, I get following error message:
>
> (20014)Internal error (specific information not available): mod_rivet: Error in Child init script: source /apps/apache2.4.54/lib/conf/globalscript.tcl
> (20014)Internal error (specific information not available): errorCode: NONE
> (20014)Internal error (specific information not available): errorInfo:
> while executing
> "load /mein_user/lib/tcl/Oratcl4.5/libOratcl4.5.so"
> ("package ifneeded Oratcl 4.5" script)
> invoked from within
> "package require Oratcl 4.5"
> (file "/apps/apache2.4.54/lib/conf/globalscript.tcl" line 11)
> invoked from within
> "source /apps/apache2.4.54/lib/conf/globalscript.tcl"
>
> When the Apache server is subsequently terminated, the following error message is output:
>
> Oratcl_Init(): Failed to load /mein_user/bin/oracle/instantclient_21_8/libclntsh.so.21.1 with error libnnz21.so: cannot open shared object file: No such file or directory
> Oratcl_Init(): ORACLE_LIBRARY = /mein_user/bin/oracle/instantclient_21_8/libclntsh.so.21.1 : file not found.
>
> The libraries libclntsh.so.21.1 and libnnz21.so exists, and are in the same directory.
>
> If I run globalscript.tcl in a Tcl shell, everything works fine.
>
> Do you have any idea why the error occurs?
>
> Manfred

Additional information:

When I first start Apache and then call globalscript.tcl from the browser, I get the following error message:

while executing
"load /home/flow_adm/lib/tcl/Oratcl4.5/libOratcl4.5.so"
("package ifneeded Oratcl 4.5" script)
invoked from within
"package require Oratcl 4.5"
(in namespace eval "::request" script line 10)
invoked from within
"namespace eval ::request $script"
("::try" body line 12)

Re: Issue with Apache-Rivet and Oratcl

<fe218909-cf1e-4ae6-95d7-99f91af93a63n@googlegroups.com>

copy mid

https://www.novabbs.com/devel/article-flat.php?id=10144&group=comp.lang.tcl#10144

copy link Newsgroups: comp.lang.tcl

X-Received: by 2002:a05:622a:5c8c:b0:35b:b250:340c with SMTP id ge12-20020a05622a5c8c00b0035bb250340cmr11839249qtb.511.1668428657125;
Mon, 14 Nov 2022 04:24:17 -0800 (PST)
X-Received: by 2002:a05:620a:1092:b0:6ee:b301:e302 with SMTP id
g18-20020a05620a109200b006eeb301e302mr10722332qkk.643.1668428656795; Mon, 14
Nov 2022 04:24:16 -0800 (PST)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.tcl
Date: Mon, 14 Nov 2022 04:24:16 -0800 (PST)
In-Reply-To: <e16c21fc-183e-45f5-bd80-1a18222e1353n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=147.161.165.113; posting-account=AOHKvwoAAADOqNomb3yowcuAvYCdrLO6
NNTP-Posting-Host: 147.161.165.113
References: <e16c21fc-183e-45f5-bd80-1a18222e1353n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <fe218909-cf1e-4ae6-95d7-99f91af93a63n@googlegroups.com>
Subject: Re: Issue with Apache-Rivet and Oratcl
From: mssrs...@gmail.com (Manfred Schwarz)
Injection-Date: Mon, 14 Nov 2022 12:24:17 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 3907

by: Manfred Schwarz - Mon, 14 Nov 2022 12:24 UTC

Additional information:

When I first start Apache and then call globalscript.tcl from the browser, I get the following error message:

while executing
"load /mein_user/lib/tcl/Oratcl4.5/libOratcl4.5.so"
("package ifneeded Oratcl 4.5" script)
invoked from within
"package require Oratcl 4.5"
(in namespace eval "::request" script line 10)
invoked from within
"namespace eval ::request $script"
("::try" body line 12)

Re: Issue with Apache-Rivet and Oratcl

<tktd8r$1n692$1@dont-email.me>

copy mid

https://www.novabbs.com/devel/article-flat.php?id=10145&group=comp.lang.tcl#10145

copy link Newsgroups: comp.lang.tcl

Path: i2pn2.org!i2pn.org!eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: wortka...@yahoo.com (Harald Oehlmann)
Newsgroups: comp.lang.tcl
Subject: Re: Issue with Apache-Rivet and Oratcl
Date: Mon, 14 Nov 2022 13:45:15 +0100
Organization: A noiseless patient Spider
Lines: 71
Message-ID: <tktd8r$1n692$1@dont-email.me>
References: <e16c21fc-183e-45f5-bd80-1a18222e1353n@googlegroups.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Mon, 14 Nov 2022 12:45:15 -0000 (UTC)
Injection-Info: reader01.eternal-september.org; posting-host="6ccebb712aa13362294ec07dd85b4328";
logging-data="1808674"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+k0MCYyVaGU7BLl5GYndps"
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101
Thunderbird/102.4.2
Cancel-Lock: sha1:Bebj8fvd9qhhLvmbwEcULucCU9E=
Content-Language: en-GB
In-Reply-To: <e16c21fc-183e-45f5-bd80-1a18222e1353n@googlegroups.com>

by: Harald Oehlmann - Mon, 14 Nov 2022 12:45 UTC

Am 14.11.2022 um 11:15 schrieb Manfred Schwarz:
> Hi All,
>
> I am running a cient/server application that I need to migrate to a new server.
> The server is running Apache Server 2.4.54 with rivet.
> Oratcl should be used for the connection to a Oracle database, and should be loaded in a rivet-script when Apache starts.
> For this purpose, the following command is in the Apache Conf file:
>
> RivetServerConf ChildInitScript "source /apps/apache2.4.54/lib/conf/globalscript.tcl"
>
> Inside globalscript.tcl are following lines:
>
> set ::env(ORACLE_LIBRARY) "/mein_user/bin/oracle/instantclient_21_8/libclntsh.so.21.1"
> set ::env(ORACLE_HOME) "/mein_user/bin/oracle/instantclient_21_8"
> set ::env(LD_LIBRARY_PATH) "/mein_user/bin/oracle/instantclient_21_8"
>
> lappend auto_path "/mein_user/lib/tcl/"
> lappend auto_path "/mein_user/bin/oracle/instantclient_21_8/"
>
> package require Oratcl 4.5
>
>
> When "package require Oratcl" is called, I get following error message:
>
> (20014)Internal error (specific information not available): mod_rivet: Error in Child init script: source /apps/apache2.4.54/lib/conf/globalscript.tcl
> (20014)Internal error (specific information not available): errorCode: NONE
> (20014)Internal error (specific information not available): errorInfo:
> while executing
> "load /mein_user/lib/tcl/Oratcl4.5/libOratcl4.5.so"
> ("package ifneeded Oratcl 4.5" script)
> invoked from within
> "package require Oratcl 4.5"
> (file "/apps/apache2.4.54/lib/conf/globalscript.tcl" line 11)
> invoked from within
> "source /apps/apache2.4.54/lib/conf/globalscript.tcl"
>
> When the Apache server is subsequently terminated, the following error message is output:
>
> Oratcl_Init(): Failed to load /mein_user/bin/oracle/instantclient_21_8/libclntsh.so.21.1 with error libnnz21.so: cannot open shared object file: No such file or directory
> Oratcl_Init(): ORACLE_LIBRARY = /mein_user/bin/oracle/instantclient_21_8/libclntsh.so.21.1 : file not found.
>
> The libraries libclntsh.so.21.1 and libnnz21.so exists, and are in the same directory.
>
> If I run globalscript.tcl in a Tcl shell, everything works fine.
>
> Do you have any idea why the error occurs?
>
> Manfred

Dear Manfred,
thank you for the report. The main difference between apache and a plain
tclsh is the involved user. I suppose, the apache user may require some
rights. In addition, I can imagine, that security packages like selinux
may block here.
In the time, I still used great rivet, I had no issues like that.
Can you try to load another .so file and check if this works?

The unload error of not loading "libclntsh.so" is also interesting.
Apparently, Oratcl is half loaded.

Sorry, no more info from my side. Did you consider to ask on the rivet
mailing list ? rivet-dey@tcl.apache.org ? Some of the folks there may
know the reason.

Take care,
Harald

Re: Issue with Apache-Rivet and Oratcl

<b369377b-d07c-4677-88b5-66e21cdbf6een@googlegroups.com>

copy mid

https://www.novabbs.com/devel/article-flat.php?id=10146&group=comp.lang.tcl#10146

copy link Newsgroups: comp.lang.tcl

X-Received: by 2002:a05:6214:4498:b0:4b1:ae16:ee41 with SMTP id on24-20020a056214449800b004b1ae16ee41mr12696986qvb.0.1668432718987;
Mon, 14 Nov 2022 05:31:58 -0800 (PST)
X-Received: by 2002:a05:6214:44a0:b0:4bb:9180:638f with SMTP id
on32-20020a05621444a000b004bb9180638fmr12216664qvb.98.1668432718715; Mon, 14
Nov 2022 05:31:58 -0800 (PST)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.tcl
Date: Mon, 14 Nov 2022 05:31:58 -0800 (PST)
In-Reply-To: <tktd8r$1n692$1@dont-email.me>
Injection-Info: google-groups.googlegroups.com; posting-host=147.161.165.113; posting-account=AOHKvwoAAADOqNomb3yowcuAvYCdrLO6
NNTP-Posting-Host: 147.161.165.113
References: <e16c21fc-183e-45f5-bd80-1a18222e1353n@googlegroups.com> <tktd8r$1n692$1@dont-email.me>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <b369377b-d07c-4677-88b5-66e21cdbf6een@googlegroups.com>
Subject: Re: Issue with Apache-Rivet and Oratcl
From: mssrs...@gmail.com (Manfred Schwarz)
Injection-Date: Mon, 14 Nov 2022 13:31:58 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 4768

by: Manfred Schwarz - Mon, 14 Nov 2022 13:31 UTC

Harald Oehlmann schrieb am Montag, 14. November 2022 um 13:45:29 UTC+1:
> Am 14.11.2022 um 11:15 schrieb Manfred Schwarz:
> > Hi All,
> >
> > I am running a cient/server application that I need to migrate to a new server.
> > The server is running Apache Server 2.4.54 with rivet.
> > Oratcl should be used for the connection to a Oracle database, and should be loaded in a rivet-script when Apache starts.
> > For this purpose, the following command is in the Apache Conf file:
> >
> > RivetServerConf ChildInitScript "source /apps/apache2.4.54/lib/conf/globalscript.tcl"
> >
> > Inside globalscript.tcl are following lines:
> >
> > set ::env(ORACLE_LIBRARY) "/mein_user/bin/oracle/instantclient_21_8/libclntsh.so.21.1"
> > set ::env(ORACLE_HOME) "/mein_user/bin/oracle/instantclient_21_8"
> > set ::env(LD_LIBRARY_PATH) "/mein_user/bin/oracle/instantclient_21_8"
> >
> > lappend auto_path "/mein_user/lib/tcl/"
> > lappend auto_path "/mein_user/bin/oracle/instantclient_21_8/"
> >
> > package require Oratcl 4.5
> >
> >
> > When "package require Oratcl" is called, I get following error message:
> >
> > (20014)Internal error (specific information not available): mod_rivet: Error in Child init script: source /apps/apache2.4.54/lib/conf/globalscript.tcl
> > (20014)Internal error (specific information not available): errorCode: NONE
> > (20014)Internal error (specific information not available): errorInfo:
> > while executing
> > "load /mein_user/lib/tcl/Oratcl4.5/libOratcl4.5.so"
> > ("package ifneeded Oratcl 4.5" script)
> > invoked from within
> > "package require Oratcl 4.5"
> > (file "/apps/apache2.4.54/lib/conf/globalscript.tcl" line 11)
> > invoked from within
> > "source /apps/apache2.4.54/lib/conf/globalscript.tcl"
> >
> > When the Apache server is subsequently terminated, the following error message is output:
> >
> > Oratcl_Init(): Failed to load /mein_user/bin/oracle/instantclient_21_8/libclntsh.so.21.1 with error libnnz21.so: cannot open shared object file: No such file or directory
> > Oratcl_Init(): ORACLE_LIBRARY = /mein_user/bin/oracle/instantclient_21_8/libclntsh.so.21.1 : file not found.
> >
> > The libraries libclntsh.so.21.1 and libnnz21.so exists, and are in the same directory.
> >
> > If I run globalscript.tcl in a Tcl shell, everything works fine.
> >
> > Do you have any idea why the error occurs?
> >
> > Manfred
> Dear Manfred,
> thank you for the report. The main difference between apache and a plain
> tclsh is the involved user. I suppose, the apache user may require some
> rights. In addition, I can imagine, that security packages like selinux
> may block here.
> In the time, I still used great rivet, I had no issues like that.
> Can you try to load another .so file and check if this works?
>
> The unload error of not loading "libclntsh.so" is also interesting.
> Apparently, Oratcl is half loaded.
>
> Sorry, no more info from my side. Did you consider to ask on the rivet
> mailing list ? rive...@tcl.apache.org ? Some of the folks there may
> know the reason.
>
> Take care,
> Harald

Dear Harald,
thank you for your quick reply.
The thing with the different users, could be the reason.
On my current server, Apache, rivet and Oratcl are running under the same user and all works fine.
On my new server Apache and Oratcl are stored in different users, and I have no direct access to the Apache/Rivet user.
I will try to get the access and try it with that.

Thanks also for the tip with the Rivet mailing list!

Manfred

Re: Issue with Apache-Rivet and Oratcl

<tktlk1$1pe6p$1@dont-email.me>

copy mid

https://www.novabbs.com/devel/article-flat.php?id=10147&group=comp.lang.tcl#10147

copy link Newsgroups: comp.lang.tcl

Path: i2pn2.org!i2pn.org!eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: ric...@example.invalid (Rich)
Newsgroups: comp.lang.tcl
Subject: Re: Issue with Apache-Rivet and Oratcl
Date: Mon, 14 Nov 2022 15:07:45 -0000 (UTC)
Organization: A noiseless patient Spider
Lines: 24
Message-ID: <tktlk1$1pe6p$1@dont-email.me>
References: <e16c21fc-183e-45f5-bd80-1a18222e1353n@googlegroups.com> <tktd8r$1n692$1@dont-email.me> <b369377b-d07c-4677-88b5-66e21cdbf6een@googlegroups.com>
Injection-Date: Mon, 14 Nov 2022 15:07:45 -0000 (UTC)
Injection-Info: reader01.eternal-september.org; posting-host="3015b00dab9a5273fc49ac3dccf7bebf";
logging-data="1882329"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18sCgsE9hJX/n1FBIyImBHl"
User-Agent: tin/2.0.1-20111224 ("Achenvoir") (UNIX) (Linux/3.10.17 (x86_64))
Cancel-Lock: sha1:yvI+Tm1im03ft8naCi1TusIRQF4=

by: Rich - Mon, 14 Nov 2022 15:07 UTC

Manfred Schwarz <mssrsubs@gmail.com> wrote:
> thank you for your quick reply.
> The thing with the different users, could be the reason.
> On my current server, Apache, rivet and Oratcl are running under the
> same user and all works fine.
> On my new server Apache and Oratcl are stored in different users, and
> I have no direct access to the Apache/Rivet user.
> I will try to get the access and try it with that.
>
> Thanks also for the tip with the Rivet mailing list!

If the Apache and Oratcl users differ, then the permissions on every
path element here:

/mein_user/lib/tcl/Oratcl4.5/libOratcl4.5.so

need to be set such that the Apache user can access the file. If
Apache and Oracle users are not in the same group (likely) then this
means all the directories (/mein_user/lib/tcl/Oratcl4.5) need to be
world readable and world executable) and the libOratcl4.5.so file needs
to be world readable (and might need to also be world executable).

You might not need "access to the apache user" if you set the
permissions on the library paths and files properly.

Re: Issue with Apache-Rivet and Oratcl

<96ca60cd-709d-4cc8-bc31-b4968acc35afn@googlegroups.com>

copy mid

https://www.novabbs.com/devel/article-flat.php?id=10148&group=comp.lang.tcl#10148

copy link Newsgroups: comp.lang.tcl

X-Received: by 2002:a05:622a:1108:b0:3a5:7848:4b4 with SMTP id e8-20020a05622a110800b003a5784804b4mr13480093qty.176.1668445427478;
Mon, 14 Nov 2022 09:03:47 -0800 (PST)
X-Received: by 2002:ac8:44d7:0:b0:39c:c7ba:4af4 with SMTP id
b23-20020ac844d7000000b0039cc7ba4af4mr13227278qto.99.1668445427156; Mon, 14
Nov 2022 09:03:47 -0800 (PST)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.tcl
Date: Mon, 14 Nov 2022 09:03:46 -0800 (PST)
In-Reply-To: <tktlk1$1pe6p$1@dont-email.me>
Injection-Info: google-groups.googlegroups.com; posting-host=147.161.165.113; posting-account=AOHKvwoAAADOqNomb3yowcuAvYCdrLO6
NNTP-Posting-Host: 147.161.165.113
References: <e16c21fc-183e-45f5-bd80-1a18222e1353n@googlegroups.com>
<tktd8r$1n692$1@dont-email.me> <b369377b-d07c-4677-88b5-66e21cdbf6een@googlegroups.com>
<tktlk1$1pe6p$1@dont-email.me>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <96ca60cd-709d-4cc8-bc31-b4968acc35afn@googlegroups.com>
Subject: Re: Issue with Apache-Rivet and Oratcl
From: mssrs...@gmail.com (Manfred Schwarz)
Injection-Date: Mon, 14 Nov 2022 17:03:47 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 2574

by: Manfred Schwarz - Mon, 14 Nov 2022 17:03 UTC

Rich schrieb am Montag, 14. November 2022 um 16:07:49 UTC+1:
> Manfred Schwarz <mssr...@gmail.com> wrote:
> > thank you for your quick reply.
> > The thing with the different users, could be the reason.
> > On my current server, Apache, rivet and Oratcl are running under the
> > same user and all works fine.
> > On my new server Apache and Oratcl are stored in different users, and
> > I have no direct access to the Apache/Rivet user.
> > I will try to get the access and try it with that.
> >
> > Thanks also for the tip with the Rivet mailing list!
> If the Apache and Oratcl users differ, then the permissions on every
> path element here:
>
> /mein_user/lib/tcl/Oratcl4.5/libOratcl4.5.so
>
> need to be set such that the Apache user can access the file. If
> Apache and Oracle users are not in the same group (likely) then this
> means all the directories (/mein_user/lib/tcl/Oratcl4.5) need to be
> world readable and world executable) and the libOratcl4.5.so file needs
> to be world readable (and might need to also be world executable).
>
> You might not need "access to the apache user" if you set the
> permissions on the library paths and files properly.

Hi Rich,
thank you for your suggestion!
I have set the appropiate permissions but it still does not work. :-(

Manfred

Re: Issue with Apache-Rivet and Oratcl

<4ef8fa38-98f0-4cb1-a3d5-687835d4871en@googlegroups.com>

copy mid

https://www.novabbs.com/devel/article-flat.php?id=10226&group=comp.lang.tcl#10226

copy link Newsgroups: comp.lang.tcl

X-Received: by 2002:a0c:e649:0:b0:4c6:1e50:f01c with SMTP id c9-20020a0ce649000000b004c61e50f01cmr3085019qvn.87.1669113130025;
Tue, 22 Nov 2022 02:32:10 -0800 (PST)
X-Received: by 2002:a05:620a:1098:b0:6d2:c5d6:7055 with SMTP id
g24-20020a05620a109800b006d2c5d67055mr19907354qkk.84.1669113129738; Tue, 22
Nov 2022 02:32:09 -0800 (PST)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.tcl
Date: Tue, 22 Nov 2022 02:32:09 -0800 (PST)
In-Reply-To: <96ca60cd-709d-4cc8-bc31-b4968acc35afn@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=147.161.251.72; posting-account=AOHKvwoAAADOqNomb3yowcuAvYCdrLO6
NNTP-Posting-Host: 147.161.251.72
References: <e16c21fc-183e-45f5-bd80-1a18222e1353n@googlegroups.com>
<tktd8r$1n692$1@dont-email.me> <b369377b-d07c-4677-88b5-66e21cdbf6een@googlegroups.com>
<tktlk1$1pe6p$1@dont-email.me> <96ca60cd-709d-4cc8-bc31-b4968acc35afn@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <4ef8fa38-98f0-4cb1-a3d5-687835d4871en@googlegroups.com>
Subject: Re: Issue with Apache-Rivet and Oratcl
From: mssrs...@gmail.com (Manfred Schwarz)
Injection-Date: Tue, 22 Nov 2022 10:32:10 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 3128

by: Manfred Schwarz - Tue, 22 Nov 2022 10:32 UTC

Manfred Schwarz schrieb am Montag, 14. November 2022 um 18:03:49 UTC+1:
> Rich schrieb am Montag, 14. November 2022 um 16:07:49 UTC+1:
> > Manfred Schwarz <mssr...@gmail.com> wrote:
> > > thank you for your quick reply.
> > > The thing with the different users, could be the reason.
> > > On my current server, Apache, rivet and Oratcl are running under the
> > > same user and all works fine.
> > > On my new server Apache and Oratcl are stored in different users, and
> > > I have no direct access to the Apache/Rivet user.
> > > I will try to get the access and try it with that.
> > >
> > > Thanks also for the tip with the Rivet mailing list!
> > If the Apache and Oratcl users differ, then the permissions on every
> > path element here:
> >
> > /mein_user/lib/tcl/Oratcl4.5/libOratcl4.5.so
> >
> > need to be set such that the Apache user can access the file. If
> > Apache and Oracle users are not in the same group (likely) then this
> > means all the directories (/mein_user/lib/tcl/Oratcl4.5) need to be
> > world readable and world executable) and the libOratcl4.5.so file needs
> > to be world readable (and might need to also be world executable).
> >
> > You might not need "access to the apache user" if you set the
> > permissions on the library paths and files properly.
> Hi Rich,
> thank you for your suggestion!
> I have set the appropiate permissions but it still does not work. :-(
>
> Manfred

Hi All,

for those who are interested:
After some experimentation I have found the, ultimately simple solution.

sudo sh -c "echo /<path_to_oracle_client_dir>/instantclient_21_8 > /etc/ld.so.conf.d/oracle-instantclient.conf"
sudo ldconfig

After that, the Oracle client finds its libraries and loads them without errors.

Manfred

"You know, we've won awards for this crap." -- David Letterman

devel / comp.lang.tcl / Re: Issue with Apache-Rivet and Oratcl

Subject	Author
Issue with Apache-Rivet and Oratcl	Manfred Schwarz
Issue with Apache-Rivet and Oratcl	Manfred Schwarz
Issue with Apache-Rivet and Oratcl	Manfred Schwarz
Issue with Apache-Rivet and Oratcl	Harald Oehlmann
Issue with Apache-Rivet and Oratcl	Manfred Schwarz
Issue with Apache-Rivet and Oratcl	Rich
Issue with Apache-Rivet and Oratcl	Manfred Schwarz
Issue with Apache-Rivet and Oratcl	Manfred Schwarz