1. Forum
  2. USENET
  3. comp.databases.ingres

  • accessdb

    From Rich Ford@richford990@gmail.com to comp.databases.ingres on Wed Dec 1 14:36:47 2021
    From Newsgroup: comp.databases.ingres

    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
    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From Paul White@shift7solutions@gmail.com to info-ingres on Thu Dec 2 08:51:20 2021
    From Newsgroup: comp.databases.ingres

    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-a 9-a 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>

    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From Karl Schendel@schendel@kbcomputer.com to Rich Ford on Wed Dec 1 17:50:32 2021
    From Newsgroup: comp.databases.ingres


    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
    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From Steve@s.anderson.au@gmail.com to comp.databases.ingres on Fri Dec 3 22:27:29 2021
    From Newsgroup: comp.databases.ingres

    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
    --- Synchronet 3.21b-Linux NewsLink 1.2