Ingex Documentation

DataBase installation
Home
Linux Installation
ACE + TAO Installation
Installing e2fsprogs-devel
Download Ingex Sources
DataBase installation
Unix ODBC installation
Install lame
Install ffmpeg
Web module Installation
Ingex Sources Installation
Initial testing
DVS Capture card installation
DVS Card Setup and Usage
Add NTFS read/write support

ingex_logo.gif

Setup the database....

Postgresql installation:
  • Remove any existing postgresql packages...
  • root> rpm -e postgresql 
Download the latest version postgresql (>= V 8.1) from http://www.postgres.org
I've downloaded "postgresql-8.2.3.tar.bz2"
  • Check with yast if the "readline-devel" package is installed!!!
  • or use root> rpm -q readline-devel
  • This should show "readline-devel-5.0.7" (on suse 9.3 systems)
  • Using a console go to the directory postgres is downloaded to and do a "root> tar xf <filename>"
  • Copy the extracted directory to /usr/local/src/ and rename to "pgsql" using Konqueror...
  • In a console: root> cd/usr/local/src/pgsql
  • than root> ./configure
  • than root> make
  • than root> make install

Create user:
 
Create a new user using YAST and than "Security and users" + "Edit and create users"
Username Postgresql User
logonname: postgres
password: postgres

Create and initialize database:
 
Create a directory called data
root> mkdir /usr/local/pgsql/data

Change the owner to postgres user
root> chown postgres /usr/local/pgsql/data
 
Login as postgres user and initialize the database..
What i always do is to start a remote desktop session on another machine using VNC (with the UltraVNC client on a windows machine for instance). Check with "ifconfig" in a console what the ipaddress of your linux machine is. In VNC connect to <ipaddress>:5901
postgres> /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
 
After the initdb is finished go with konqueror to the /usr/local/pgsql/data directory and search for the "pg_hba.conf" file. Add the following entry to the end of this file using KWrite:
host   prodautodb   ingex   <ipaddress line xxx.xxx.0.0>/16    trust
 
Search for the "postgresql.conf" file in the same directory and open it using KWrite. Use "Edit" menu and than "Find" and search for "listen_address". Now change "listen_address='localhost'" to "listen_address='*'". Be sure to remove the "#" comment sign in front of this line

Setup the startup script:
 
  • Go to the /usr/local/src/pgsql/contrib/start-scripts
  • Copy and past the "linux" file with the name "postgresql"
  • Copy this file to /etc/init.d/ directory
  • Select this file using Konqueror with the right mouse button and click "properties".
  • Go to the "Permissions" tab in the properties window.
  • check the "Is executable" checkbox and push "Ok".
  • Startup YAST and go to "system" and than "System Services"
  • Go to Expert mode..
  • Search for the "postgresql" service and check runlevel 3 and 5
  • Click the "Start/Stop/Refresh" button and select "Start Now"
  • Postgresql should start without problems....
  • Click Finish to save these settings...

Initialize prodautodb:
 
  • Go to /usr/local/src/ingex/Ingex/database/scripts/
  • make sure that all the *.sh file have executable permission checked..
  • Open every file with KWrite and remove the all the last blank lines..
  • Open a console and cd to /usr/local/src/ingex/Ingex/database/scripts
  • now run root> ./create_ingex_user.sh
  • than run root> ./create_prodautodb.sh
  • and last run root> ./add_basic_config.sh

BBC OpenSource Multichannel Capture And Logging Software for Avid systems.