Rocksolid Light

Welcome to RetroBBS

mail  files  register  newsreader  groups  login

Message-ID:  

I do not find in orthodox Christianity one redeeming feature. -- Thomas Jefferson

devel / comp.databases.ingres / accessdb

SubjectAuthor
* accessdbRich Ford
+- Re: [Info-ingres] accessdbKarl Schendel
+- Re: [Info-ingres] accessdbPaul White
`- Re: accessdbSteve

1
accessdb

<43a1b7c5-cfc3-4965-9280-01e92a5c97a2n@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=136&group=comp.databases.ingres#136

  copy link   Newsgroups: comp.databases.ingres
X-Received: by 2002:a05:620a:2a05:: with SMTP id o5mr9276885qkp.527.1638398208173;
Wed, 01 Dec 2021 14:36:48 -0800 (PST)
X-Received: by 2002:a9d:4d8b:: with SMTP id u11mr8286598otk.144.1638398207861;
Wed, 01 Dec 2021 14:36:47 -0800 (PST)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ingres
Date: Wed, 1 Dec 2021 14:36:47 -0800 (PST)
Injection-Info: google-groups.googlegroups.com; posting-host=2600:8801:d500:6b60:c077:fb26:5b99:54fd;
posting-account=MD_47woAAABULmOe11ZqdjPGw6zni88O
NNTP-Posting-Host: 2600:8801:d500:6b60:c077:fb26:5b99:54fd
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <43a1b7c5-cfc3-4965-9280-01e92a5c97a2n@googlegroups.com>
Subject: accessdb
From: richford990@gmail.com (Rich Ford)
Injection-Date: Wed, 01 Dec 2021 22:36:48 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 6
 by: Rich Ford - Wed, 1 Dec 2021 22:36 UTC

Do I need to have root privs in order to run accessdb?

accessdb
Absolute path to 'accessdb' is '/usr/sbin/accessdb', so running it may require superuser privileges (eg. root).

Thanks,
Rich

Re: [Info-ingres] accessdb

<mailman.104.1638399036.1681.info-ingres@lists.planetingres.org>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=137&group=comp.databases.ingres#137

  copy link   Newsgroups: comp.databases.ingres
Path: i2pn2.org!i2pn.org!aioe.org!news.uzoreto.com!tr1.eu1.usenetexpress.com!feeder.usenetexpress.com!tr3.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!buffer1.nntp.dca1.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Wed, 01 Dec 2021 16:52:03 -0600
Return-Path: <schendel@kbcomputer.com>
X-Original-To: info-ingres@lists.planetingres.org
Delivered-To: info-ingres@mort.croker.net
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.120.0.1.13\))
From: schendel@kbcomputer.com (Karl Schendel)
In-Reply-To: <43a1b7c5-cfc3-4965-9280-01e92a5c97a2n@googlegroups.com>
Date: Wed, 1 Dec 2021 17:50:32 -0500
Content-Transfer-Encoding: quoted-printable
References: <43a1b7c5-cfc3-4965-9280-01e92a5c97a2n@googlegroups.com>
To: Rich Ford <richford990@gmail.com>
X-Mailer: Apple Mail (2.3654.120.0.1.13)
Cc: info-ingres@lists.planetingres.org
Subject: Re: [Info-ingres] accessdb
X-BeenThere: info-ingres@lists.planetingres.org
X-Mailman-Version: 2.1.12
Precedence: list
List-Id: <info-ingres.lists.planetingres.org>
List-Unsubscribe: <https://lists.planetingres.org/mailman/options/info-ingres>, <mailto:info-ingres-request@lists.planetingres.org?subject=unsubscribe>
List-Archive: <https://lists.planetingres.org/pipermail/info-ingres/>
List-Post: <mailto:info-ingres@lists.planetingres.org>
List-Help: <mailto:info-ingres-request@lists.planetingres.org?subject=help>
List-Subscribe: <https://lists.planetingres.org/mailman/listinfo/info-ingres>, <mailto:info-ingres-request@lists.planetingres.org?subject=subscribe>
Newsgroups: comp.databases.ingres
Message-ID: <mailman.104.1638399036.1681.info-ingres@lists.planetingres.org>
Lines: 19
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-UVzazb6yzNCHMzbnXDBYe6j9nNzvykzie08g5BsQJ+zuSx1vqg+dtNBXEZ5uUrJg8ewmhZGqMl2RI/r!DrMMNAfKFaMiVw4BvHo5Z5flAjqLfIJYmVQjBGVTDYbO3dm2UTj0YA0zy4WblnY0VPnVJLAHur+H!mYS9MyXXi/r+mB/l/t7XGcI=
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
X-Original-Bytes: 2563
 by: Karl Schendel - Wed, 1 Dec 2021 22:50 UTC

> On Dec 1, 2021, at 5:36 PM, Rich Ford <richford990@gmail.com> wrote:
>
> Do I need to have root privs in order to run accessdb?
>
> accessdb
> Absolute path to 'accessdb' is '/usr/sbin/accessdb', so running it may require superuser privileges (eg. root).
>

That appears to be the wrong accessdb.

The one you want is in $II_SYSTEM/ingres/bin, and does not need root privs.
(It's actually a shellscript that runs ingcntrl -m

Karl

Re: [Info-ingres] accessdb

<mailman.105.1638399088.1681.info-ingres@lists.planetingres.org>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=138&group=comp.databases.ingres#138

  copy link   Newsgroups: comp.databases.ingres
Path: i2pn2.org!i2pn.org!paganini.bofh.team!news.dns-netz.com!news.freedyn.net!newsfeed.xs4all.nl!newsfeed8.news.xs4all.nl!tr3.eu1.usenetexpress.com!feeder.usenetexpress.com!tr1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!buffer1.nntp.dca1.giganews.com!buffer2.nntp.dca1.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Wed, 01 Dec 2021 16:52:04 -0600
Return-Path: <shift7solutions@gmail.com>
X-Original-To: info-ingres@lists.planetingres.org
Delivered-To: info-ingres@mort.croker.net
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=message-id:date:mime-version:user-agent:reply-to:subject :content-language:to:references:from:organization:in-reply-to :content-transfer-encoding; bh=uLWyK2HjJaWoIfIR7lrzwsncKvrg0FTlr37gYi6L1Rs=; b=PX80OBYd9pXhu9RsIWYt42bsxLzkTykMM13Q1+78caw4Pfluv7IzVI/kMIKByGzoXM dbFSzGmXzH+kYzqEqexoQPe9ij17vdALT73yC3euP7GyudMTgUxgZeLon3pidppR35Fa hsBijIcLNum4bpTIe2oWW++Z6xszDyw7jkIvzpk4jfZcvuv3zD+D8Ui8rTQNkxq3UCA1 0E2+u0ts1iFBYrWmlemhnq7M1eP3VoA9V4nw5knzSLdWtVbE2TSauZA3CXsrlERwqqLW oT9nEPjLb4GLi+HgDlAfWS2JCdpfC+chrOfd2TPaabnpGPMM9dD9cK9wxKiJer8MUdBL h8TQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:date:mime-version:user-agent:reply-to :subject:content-language:to:references:from:organization :in-reply-to:content-transfer-encoding; bh=uLWyK2HjJaWoIfIR7lrzwsncKvrg0FTlr37gYi6L1Rs=; b=IfcqsozDo4vpMn2Hm2Fc37X4BUuOGaVCqkdichj439JX8VA54+BFhBq6BsnvSGUOYs ecFDhnrISyWo7FQt9FdS5LEGfIeDDizq9QhwXFCfg7uZPSKWWC2oNLdPHqWZAaGXlqrZ p9E/7FBRnStafdjfol2lbCn463/bh1axmaOsstavOhmmTYCL7GCNNzSgngeISTMfrQON byhZ/KTECBUum8kTAf3Yt2t2tiO2ZKVavov09n0vXFjhJ7aplqHoO6IFm2ZKH9ZTz6Ot y3rWncD/Nv8f8vAi0S50McHaQYWWL2YRFriPbUJXh6sLmaDFkzs6HjW9gvk3Rn1snnsW DYCA==
X-Gm-Message-State: AOAM533ZNyDH5TXxVgkGGGJo3WNMu2PxaCAM5dW6b4hRpiyVoKc5jxWN GKYPYArrhmiCmlp/NixjxFXO5+ecjx0=
X-Google-Smtp-Source: ABdhPJwYlg72MmX3XLNusgVEal3tbJraIUOGTFf8Jx3wmwd2kflx6zIwn2Zvforj006xyqHYC8TkHQ==
X-Received: by 2002:aa7:9561:0:b0:49f:c8cd:ce6d with SMTP id x1-20020aa79561000000b0049fc8cdce6dmr8895577pfq.67.1638399085280; Wed, 01 Dec 2021 14:51:25 -0800 (PST)
Date: Thu, 2 Dec 2021 08:51:20 +1000
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:91.0) Gecko/20100101 Thunderbird/91.3.2
Reply-To: shift7solutions@gmail.com
Content-Language: en-US
To: info-ingres@lists.planetingres.org
References: <43a1b7c5-cfc3-4965-9280-01e92a5c97a2n@googlegroups.com>
From: shift7solutions@gmail.com (Paul White)
Organization: Shift Seven Solutions
In-Reply-To: <43a1b7c5-cfc3-4965-9280-01e92a5c97a2n@googlegroups.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Subject: Re: [Info-ingres] accessdb
X-BeenThere: info-ingres@lists.planetingres.org
X-Mailman-Version: 2.1.12
Precedence: list
List-Id: <info-ingres.lists.planetingres.org>
List-Unsubscribe: <https://lists.planetingres.org/mailman/options/info-ingres>, <mailto:info-ingres-request@lists.planetingres.org?subject=unsubscribe>
List-Archive: <https://lists.planetingres.org/pipermail/info-ingres/>
List-Post: <mailto:info-ingres@lists.planetingres.org>
List-Help: <mailto:info-ingres-request@lists.planetingres.org?subject=help>
List-Subscribe: <https://lists.planetingres.org/mailman/listinfo/info-ingres>, <mailto:info-ingres-request@lists.planetingres.org?subject=subscribe>
Newsgroups: comp.databases.ingres
Message-ID: <mailman.105.1638399088.1681.info-ingres@lists.planetingres.org>
Lines: 45
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-SDfuyg2iaPfeUWSz0cJjjjtZTH99kcIe1aQa4azj8wTpAO1290ptytLd30uRyzk3kAYahwhoSL0+80h!bGbHSRVFa3zksiQflq2fqBYCL+tJGhRhV82oSYv6shd1iucaRkbdbLXP96BNPO2aPoWFZ6KuF5PD!/KYt8eGYnlEl4+3ZFN9r348=
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
X-Original-Bytes: 5137
 by: Paul White - Wed, 1 Dec 2021 22:51 UTC

Hi Rich,

In my experience, accessdb is found in the Ingres installation directory.

$ echo $II_SYSTEM
/home/ingres/IngresII
$ ls -l /home/ingres/IngresII/ingres/bin/accessdb
-rwxr-xr-x. 1 ingres ingres 299 Apr  9  2019
/home/ingres/IngresII/ingres/bin/accessdb
$ echo $PATH
/home/ingres/IngresII/ingres/bin:/home/ingres/IngresII/ingres/utility:/home/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/utils:/home/ingres/.local/bin:/home/ingres/bin
$

It is usually run by the installation owner Ingres or by any user with
as DBA security permissions.

Paul

On 2/12/2021 8:36 am, Rich Ford wrote:
> Do I need to have root privs in order to run accessdb?
>
> accessdb
> Absolute path to 'accessdb' is '/usr/sbin/accessdb', so running it may require superuser privileges (eg. root).
>
> Thanks,
> Rich

> _______________________________________________
> Info-ingres mailing list
> Info-ingres@lists.planetingres.org
> https://lists.planetingres.org/mailman/listinfo/info-ingres

--
Paul White<br>
Shift Seven Solutions<br>
<b>m: 0414681799</b><br>
p: 0754482137<br>
e: paul.white@shift7solutions.com.au<br>
w: https://www.shift7solutions.com.au<br>
International: +61414681799<br>

Re: accessdb

<82b3d8ee-b364-4cc6-9880-d1a540ba3bf9n@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=153&group=comp.databases.ingres#153

  copy link   Newsgroups: comp.databases.ingres
X-Received: by 2002:a05:6214:b01:: with SMTP id u1mr23616375qvj.37.1638599250306;
Fri, 03 Dec 2021 22:27:30 -0800 (PST)
X-Received: by 2002:a9d:64d4:: with SMTP id n20mr19481375otl.328.1638599250025;
Fri, 03 Dec 2021 22:27:30 -0800 (PST)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ingres
Date: Fri, 3 Dec 2021 22:27:29 -0800 (PST)
In-Reply-To: <43a1b7c5-cfc3-4965-9280-01e92a5c97a2n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=1.145.107.180; posting-account=uL8iyAoAAABmcpUSs5hxN0c_ls8MZOL5
NNTP-Posting-Host: 1.145.107.180
References: <43a1b7c5-cfc3-4965-9280-01e92a5c97a2n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <82b3d8ee-b364-4cc6-9880-d1a540ba3bf9n@googlegroups.com>
Subject: Re: accessdb
From: s.anderson.au@gmail.com (Steve)
Injection-Date: Sat, 04 Dec 2021 06:27:30 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 17
 by: Steve - Sat, 4 Dec 2021 06:27 UTC

On Thursday, December 2, 2021 at 9:36:48 AM UTC+11, richf...@gmail.com wrote:
> Do I need to have root privs in order to run accessdb?
>
> accessdb
> Absolute path to 'accessdb' is '/usr/sbin/accessdb', so running it may require superuser privileges (eg. root).
>
> Thanks,
> Rich

Hi Rich

It seems the accessdb you were inadvertently trying to run is a Linux command not related to Ingres.

https://linuxcommandlibrary.com/man/accessdb

I have a similar issue with the createdb command in my installation (it finds the Postgres createdb command), indicating my PATH environment variable needs to be tweaked so $II_SYSTEM/ingres/bin and $II_SYSTEM/ingres/utility are searched earlier.

Steve

1
server_pubkey.txt

rocksolid light 0.9.81
clearnet tor