accessdb

[Rich Ford]

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

[Karl Schendel]

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

[Paul White]

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

> _______________________________________________
> Info-ingres mailing list
> Info-...@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....@shift7solutions.com.au<br>
w: https://www.shift7solutions.com.au<br>
International: +61414681799<br>

[Steve]

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