Home PostgreSQL Aubit4gl Install Setup

Installing Aubit4gl

OpenSSA source code is optimised and tested for Aubit4gl version 1.00 and above.

Download and install latest version from sourceforge.

Following are steps to be taken to install on a Fedora Core 4/5/6 platform.

  1. Create a working directory eg. /usr/local/aubit4gl.cvs , and cvs checkout the source code according to sourceforge.net instructions.
    md /usr/local/aubit4gl.cvs
    cd /usr/local/aubit4gl.cvs
    cvs -d:pserver:anonymous@aubit4gl.cvs.sourceforge.net:/cvsroot/aubit4gl \
      login
    cvs -z3 -d:pserver:anonymous@aubit4gl.cvs.sourceforge.net:/cvsroot/aubit4gl \
      co .
    
  2. Compile Aubit4gl, to install into /usr/local/aubit4gl
    cd aubit4glsrc
    ./configure --prefix=/usr/local/aubit4gl \
      --with-pgsql=/usr/local/pgsql --with-ecpg=/usr/local/pgsql \
      --with-informix=no
    make
    make install
    
  3. Check and edit if necessary the bold lines in /etc/opt/aubit4gl/aubitrc . Uncomment the line A4GL_TARGETDIALECT if necessary.
    AUBITDIR=/usr/local/aubit4gl
    AUBITDIR_SRC=/usr/local/aubit4gl.cvs/aubit4glsrc
    A4GL_SQLCNVPATH=/usr/local/aubit4gl/etc/convertsql
    
    A4GL_SQLTYPE=pg
    A4GL_SQLTYPE_DETECTED="nosql unixodbc"
    
    A4GL_LEXTYPE=EC
    A4GL_LEXTYPE_DETECTED="C EC"
    
    A4GL_LEXDILECT=POSTGRES
    A4GL_LEXDILECT_DETECTED=" POSTGRES"
    A4GL_TARGETDIALECT=POSTGRES8
    
    A4GL_PDFTYPE=PDF
    A4GL_PDFTYPE_DETECTED="NOPDF PDF"
    
    A4GL_UI=TUI
    A4GL_UI_DETECTED="CONSOLE HL_GTK TUI HL_TUI HL_TUIN"
    
  4. Edit following file
    /usr/local/aubit4gl/etc/convertsql/INFORMIX-POSTGRES8.cnv
    Make sure the following lines are commented.
    #FULL_INSERT
    #OMIT_SERIAL_COL_FROM_INSERT
    #CLOSE_CURSOR_BEFORE_OPEN
    
  5. Add the bold lines in /etc/profile ... last line is optional, but ease execution ...
    if [ "$EUID" = "0" ]; then
    	pathmunge /sbin
    	pathmunge /usr/sbin
    	pathmunge /usr/local/sbin
    fi
    pathmunge /usr/local/pgsql/bin after
    pathmunge /usr/local/aubit4gl/bin after
    .....
    pathmunge . after
    
    and source it
    . /etc/profile
    
  6. Create a new file /etc/ld.so.conf.d/aubit4gl.conf with following line
    /usr/local/aubit4gl/lib
    
    and activate it
    ldconfig
    
  7. Add the bold line in /etc/profile ...
    pathmunge DBDATE=dmy4/
    
    and source it.
    . /etc/bashrc
    
    Possible values are dmy4/ (Europe), y4md-(ISO), mdy4/ (America) etc. This would set default date format for date display and input in programs and forms. if y2 instead of y4 is used, the century will be automatically deduced.

  8. For Fedora Core 5 and up, if SELinux is enforced, make sure the following is allowed in the security level policy. For FC5, under "Compatibility" section, check the following.
    Allow the use of shared libraries with Text Relocation.
    
    Failing which, will result in the following error :
    Error: can't open DLL /usr/local/aubit4gl/lib/libESQL_POSTGRES.so - STOP
    Error msg: /usr/local/aubit4gl/lib/libESQL_POSTGRES.so: 
    cannot restore segment prot after reloc: Permission denied
    Cannot open DLL
    

  9. Proceed to download and install OpenSSA.