SEARCH:

Running on Linux

Current Status

Andromeda's reference code is always developed on Linux. At Secure Data Software we use Ubuntu workstations and gentoo servers.

Installing Ubuntu Packages

Install the following packages, with any dependencies.

  • php5
  • php5-pgsql
  • php5-curl
  • php5-pear
  • postgresql-8.1 (or later version)
  • pgadmin3 (recommended but not required)
  • perl

Installing Gentoo Packages

On gentoo you need the USE flags "curl" and "postgres" set when you compile PHP. Otherwise you are installing the packages php, pear_pear, perl and postgres.

Configuration

Once the packages are installed, make these configuration changes.

Firefox's Brain-damaged Hotkey Setting

Firefox Step 1 of 1

Type "about:config" into the address bar, and then in the "filter" box type "ui.key". Look for "ui.key.contentAccess" and change it from 5 to 4, which sets it back to ALT.

PHP

PHP Step 1 of 3

There are a few php.ini settings that should be changed:

  • max_execution_time must be expanded. Building a database will often exceed 30 seconds, and can run as much as 3-4 minutes.
  • make sure the line "short_open_tag=on" says "on" and is not commented.
  • memory_limit must be expanded beyond 8M, otherwise a database build will simply stop with a maddening lack of any kind of error or notice.
  • Make sure the line "short_open_tag=on" says "on" and is not commented.

PHP Step 2 of 3

Use command-line PEAR to install Net_SMTP and any dependencies.

PHP Step 3 of 3

Use command-line PEAR to install Archive_Tar, along with any dependencies.

Apache

Apache Step 1 of 1

Apache mod_rewrite must be on to make use of friendly URLs.

Postgres

Postgres Step 1 of 4

Your pg_hba.conf file should look like the file below. It is important to keep the lines in the same order.

#  DEV SERVER ONLY, do not put this line in on a
#  production server.
local  all         postgres        ident andromeda

# Users in pg group "root" can connect to anything
local   all         +root          password

# Members of the anonymous role can login
local   samename    all           password
local  samegroup   all            password

Postgres Step 2 of 4

Add these lines to pg_ident.conf. This allows linux users root and postgres to connect to the postgres server.

# pg_ident.conf: Andromeda version
# --------------------------------------------------
# These two lines allow the Unix root user and the 
# postgres user to connect in w/o password.
#
# --------------------------------------------------
# MAPNAME     IDENT-USERNAME    PG-USERNAME
andromeda     postgres          postgres
andromeda     root              postgres

Postgres Step 3 of 4

Make the following changes to postgresql.conf to make sure that it is listening on TCP/IP. Each of the lines below should already be in the config file, make sure they are uncommented and set as shown:

listen_addresses='localhost'
port = 5432
max_connections = 100

After changing these 3 files you will need to restart the Postgres service.

Postgres Step 4 of 4

Enter the following commands in a pgadmin3 command window. Do this by launching pgadmin3, making a connection to localhost, and then:

create role root nologin;
create user USER_NAME superuser password 'PASSWORD';
grant root to USER_NAME;
create database andro;

Run Andromeda Install

You are now ready to download and install Andromeda.