NEOSYS Dev Wiki - User contributions [en]

Log of an installation of libexodus on Centos 5.3

2009-07-19T16:31:37Z

85.17.154.66: /* Ensure Exodus can logon to postgres */

=== Preparation ===

sudo yum update
sudo yum install boost-devel postgresql-devel gcc-c++ subversion postgresql-server

Centos needs you to start the database manually. Ubuntu doesnt.

sudo /etc/init.d/postgresql start

=== Exodus ===

For the latest version of the software:
cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk

Or for not the latest:
wget http://www.neosys.com/support/exodus_all-9.6.tar.gz
tar xvfz exodus_all-9.6.tar.gz
cd exodus_all-9.6

Classic installation steps
./configure
make
sudo make install

=== Setting up Postgres for Exodus ===

==== Register the exodus functions ====

Assume identity of a postgres superuser

sudo su - postgres

On Mac OSX only, ensure postgres can be found. Change 8.3 to your version) and check pg_config can run)

PATH=/Library/PostgreSQL/8.3/bin/:$PATH
pg_config

Log in to postgres as a postgres superuser and connect to database template1

psql -U postgres -d template1
\connect template1

{{postgres function installation}}

Check the functions loaded properly (count them)

\df exodus*

<pre>
List of functions
Schema | Name | Result data type | Argument data types
--------+-------------------------+-----------------------------+-----------------------------------------------------
public | exodus_call | bytea | bytea, bytea, bytea, bytea, bytea, integer, integer
public | exodus_extract_bytea | bytea | bytea, integer, integer, integer
public | exodus_extract_date | date | bytea, integer, integer, integer
public | exodus_extract_datetime | timestamp without time zone | bytea, integer, integer, integer
public | exodus_extract_sort | text | bytea, integer, integer, integer
public | exodus_extract_text | text | bytea, integer, integer, integer
public | exodus_extract_text2 | text | bytea, integer, integer, integer
public | exodus_extract_time | time without time zone | bytea, integer, integer, integer
(8 rows)
</pre>

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

==== Create a user and database for exodus ====

Use the example password for now to avoid further configuration in exodus.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;
CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

Quit postgres command prompt

\q

==== Ensure Exodus can logon to postgres ====

===== Edit pg_hba.conf =====

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/encrypted password (instead of only "ident sameuser" which means the logged-in username without password) For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

Redhat/Centos/MacOSX
nano ~/data/pg_hba.conf
or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines. NB DONT comment out any other similar lines esp. ones containining "postgres"
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines which allows the 'postgres' user local access through ident authentication, which is needed for cron scripts. The second line, allows anyone to connect locally on 127.0.0.1 if they can provide a valid username and password.

local all postgres ident sameuser
host all all 127.0.0.1 255.255.255.255 md5

quit postgres user

exit

Reload Postgres

Redhat/Centos
sudo /etc/init.d/postgresql reload
or Ubuntu
sudo /etc/init.d/postgresql-8.3 reload
or MacOSX
sudo su postgres
/Library/PostgreSQL/8.3/bin/pg_ctl reload -D /Library/PostgreSQL/8.3/data
exit

=== Testing ===

==== Test exodus library ====

nano test1.cpp

<pre>
#include <exodus/exodus.h>
program() {
date().oconv("D").outputln();
print(oconv(date(),"D"));
}
</pre>

g++ test1.cpp -lexodus

./a.out

27 JUN 2009
27 JUN 2009

==== Test database connection ====

nano test2.cpp

<pre>
#include <exodus/exodus.h>
program() {
createfile("exodustest");
}
</pre>

g++ test2.cpp -lexodus

./a.out

NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "exodustest_pkey" for table "exodustest"

==== Test symbolic dictionaries (call backs) ====

nano test3.cpp

<pre>

#include <exodus/exodus.h>

program() {

var testfilename="test_symbolics";
createfile("dict_"^testfilename);
write("F"^FM^0^FM^"ID","dict_"^testfilename,"ID");
write("S"^FM^FM^"Col1","dict_"^testfilename,"SYMCOL1");

createfile(testfilename);
write(1000^FM^2000,testfilename,"3000");

select("select "^testfilename^" with SYMCOL1 = 3000 or with ID = 3000");

//should fail since have not installed a function to handle symbolics in this test
//but it shows that everything else is working
var key1;
if (not readnext(key1))
stop("Cannot readnext (as expected)");
}

</pre>

g++ test3.cpp -lexodus

./a.out

Expected result is which means everything is working and we can implement symbolic dictionaries in exodus.

<pre>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dict_test_symbolics_pkey" for table "dict_test_symbolics"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "test_symbolics_pkey" for table "test_symbolics"
PGRES_FATAL_ERROR: ERROR: pgexodus exodus_call failed. (MVCipc() TEST_SYMBOLICS unknown filename)
Cannot readnext (as expected)</pre>

Log of an installation of libexodus on Centos 5.3

2009-07-19T16:19:13Z

85.17.154.66: /* Ensure Exodus can logon to postgres */

=== Preparation ===

sudo yum update
sudo yum install boost-devel postgresql-devel gcc-c++ subversion postgresql-server

Centos needs you to start the database manually. Ubuntu doesnt.

sudo /etc/init.d/postgresql start

=== Exodus ===

For the latest version of the software:
cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk

Or for not the latest:
wget http://www.neosys.com/support/exodus_all-9.6.tar.gz
tar xvfz exodus_all-9.6.tar.gz
cd exodus_all-9.6

Classic installation steps
./configure
make
sudo make install

=== Setting up Postgres for Exodus ===

==== Register the exodus functions ====

Assume identity of a postgres superuser

sudo su - postgres

On Mac OSX only, ensure postgres can be found. Change 8.3 to your version) and check pg_config can run)

PATH=/Library/PostgreSQL/8.3/bin/:$PATH
pg_config

Log in to postgres as a postgres superuser and connect to database template1

psql -U postgres -d template1
\connect template1

{{postgres function installation}}

Check the functions loaded properly (count them)

\df exodus*

<pre>
List of functions
Schema | Name | Result data type | Argument data types
--------+-------------------------+-----------------------------+-----------------------------------------------------
public | exodus_call | bytea | bytea, bytea, bytea, bytea, bytea, integer, integer
public | exodus_extract_bytea | bytea | bytea, integer, integer, integer
public | exodus_extract_date | date | bytea, integer, integer, integer
public | exodus_extract_datetime | timestamp without time zone | bytea, integer, integer, integer
public | exodus_extract_sort | text | bytea, integer, integer, integer
public | exodus_extract_text | text | bytea, integer, integer, integer
public | exodus_extract_text2 | text | bytea, integer, integer, integer
public | exodus_extract_time | time without time zone | bytea, integer, integer, integer
(8 rows)
</pre>

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

==== Create a user and database for exodus ====

Use the example password for now to avoid further configuration in exodus.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;
CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

Quit postgres command prompt

\q

==== Ensure Exodus can logon to postgres ====

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/encrypted password (instead of only "ident sameuser" which means the logged-in username without password) For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

Redhat/Centos/MacOSX
nano ~/data/pg_hba.conf
or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines. NB DONT comment out any other similar lines esp. ones containining "postgres"
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines which allows the 'postgres' user local access through ident authentication, which is needed for cron scripts. The second line, allows anyone to connect locally on 127.0.0.1 if they can provide a valid username and password.

local all postgres ident sameuser
host all all 127.0.0.1 255.255.255.255 md5

quit postgres user

exit

Reload Postgres

Centos
sudo /etc/init.d/postgresql reload
or Ubuntu
sudo /etc/init.d/postgresql-8.3 reload

=== Testing ===

==== Test exodus library ====

nano test1.cpp

<pre>
#include <exodus/exodus.h>
program() {
date().oconv("D").outputln();
print(oconv(date(),"D"));
}
</pre>

g++ test1.cpp -lexodus

./a.out

27 JUN 2009
27 JUN 2009

==== Test database connection ====

nano test2.cpp

<pre>
#include <exodus/exodus.h>
program() {
createfile("exodustest");
}
</pre>

g++ test2.cpp -lexodus

./a.out

NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "exodustest_pkey" for table "exodustest"

==== Test symbolic dictionaries (call backs) ====

nano test3.cpp

<pre>

#include <exodus/exodus.h>

program() {

var testfilename="test_symbolics";
createfile("dict_"^testfilename);
write("F"^FM^0^FM^"ID","dict_"^testfilename,"ID");
write("S"^FM^FM^"Col1","dict_"^testfilename,"SYMCOL1");

createfile(testfilename);
write(1000^FM^2000,testfilename,"3000");

select("select "^testfilename^" with SYMCOL1 = 3000 or with ID = 3000");

//should fail since have not installed a function to handle symbolics in this test
//but it shows that everything else is working
var key1;
if (not readnext(key1))
stop("Cannot readnext (as expected)");
}

</pre>

g++ test3.cpp -lexodus

./a.out

Expected result is which means everything is working and we can implement symbolic dictionaries in exodus.

<pre>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dict_test_symbolics_pkey" for table "dict_test_symbolics"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "test_symbolics_pkey" for table "test_symbolics"
PGRES_FATAL_ERROR: ERROR: pgexodus exodus_call failed. (MVCipc() TEST_SYMBOLICS unknown filename)
Cannot readnext (as expected)</pre>

Log of an installation of libexodus on Centos 5.3

2009-07-19T16:10:10Z

85.17.154.66: /* Register the exodus functions */

=== Preparation ===

sudo yum update
sudo yum install boost-devel postgresql-devel gcc-c++ subversion postgresql-server

Centos needs you to start the database manually. Ubuntu doesnt.

sudo /etc/init.d/postgresql start

=== Exodus ===

For the latest version of the software:
cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk

Or for not the latest:
wget http://www.neosys.com/support/exodus_all-9.6.tar.gz
tar xvfz exodus_all-9.6.tar.gz
cd exodus_all-9.6

Classic installation steps
./configure
make
sudo make install

=== Setting up Postgres for Exodus ===

==== Register the exodus functions ====

Assume identity of a postgres superuser

sudo su - postgres

On Mac OSX only, ensure postgres can be found. Change 8.3 to your version) and check pg_config can run)

PATH=/Library/PostgreSQL/8.3/bin/:$PATH
pg_config

Log in to postgres as a postgres superuser and connect to database template1

psql -U postgres -d template1
\connect template1

{{postgres function installation}}

Check the functions loaded properly (count them)

\df exodus*

<pre>
List of functions
Schema | Name | Result data type | Argument data types
--------+-------------------------+-----------------------------+-----------------------------------------------------
public | exodus_call | bytea | bytea, bytea, bytea, bytea, bytea, integer, integer
public | exodus_extract_bytea | bytea | bytea, integer, integer, integer
public | exodus_extract_date | date | bytea, integer, integer, integer
public | exodus_extract_datetime | timestamp without time zone | bytea, integer, integer, integer
public | exodus_extract_sort | text | bytea, integer, integer, integer
public | exodus_extract_text | text | bytea, integer, integer, integer
public | exodus_extract_text2 | text | bytea, integer, integer, integer
public | exodus_extract_time | time without time zone | bytea, integer, integer, integer
(8 rows)
</pre>

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

==== Create a user and database for exodus ====

Use the example password for now to avoid further configuration in exodus.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;
CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

Quit postgres command prompt

\q

==== Ensure Exodus can logon to postgres ====

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/encrypted password (instead of only logged-in username without password) For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

Centos
nano ~/data/pg_hba.conf
or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines. NB DONT comment out any other similar lines esp. ones containining "postgres"
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines which allows the 'postgres' user local access through ident authentication, which is needed for cron scripts. The second line, allows anyone to connect locally on 127.0.0.1 if they can provide a valid username and password.

local all postgres ident sameuser
host all all 127.0.0.1 255.255.255.255 md5

quit postgres user

exit

Reload Postgres

Centos
sudo /etc/init.d/postgresql reload
or Ubuntu
sudo /etc/init.d/postgresql-8.3 reload

=== Testing ===

==== Test exodus library ====

nano test1.cpp

<pre>
#include <exodus/exodus.h>
program() {
date().oconv("D").outputln();
print(oconv(date(),"D"));
}
</pre>

g++ test1.cpp -lexodus

./a.out

27 JUN 2009
27 JUN 2009

==== Test database connection ====

nano test2.cpp

<pre>
#include <exodus/exodus.h>
program() {
createfile("exodustest");
}
</pre>

g++ test2.cpp -lexodus

./a.out

NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "exodustest_pkey" for table "exodustest"

==== Test symbolic dictionaries (call backs) ====

nano test3.cpp

<pre>

#include <exodus/exodus.h>

program() {

var testfilename="test_symbolics";
createfile("dict_"^testfilename);
write("F"^FM^0^FM^"ID","dict_"^testfilename,"ID");
write("S"^FM^FM^"Col1","dict_"^testfilename,"SYMCOL1");

createfile(testfilename);
write(1000^FM^2000,testfilename,"3000");

select("select "^testfilename^" with SYMCOL1 = 3000 or with ID = 3000");

//should fail since have not installed a function to handle symbolics in this test
//but it shows that everything else is working
var key1;
if (not readnext(key1))
stop("Cannot readnext (as expected)");
}

</pre>

g++ test3.cpp -lexodus

./a.out

Expected result is which means everything is working and we can implement symbolic dictionaries in exodus.

<pre>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dict_test_symbolics_pkey" for table "dict_test_symbolics"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "test_symbolics_pkey" for table "test_symbolics"
PGRES_FATAL_ERROR: ERROR: pgexodus exodus_call failed. (MVCipc() TEST_SYMBOLICS unknown filename)
Cannot readnext (as expected)</pre>

Log of an installation of libexodus on Centos 5.3

2009-07-19T15:53:13Z

85.17.154.66: /* Register the exodus functions */

=== Preparation ===

sudo yum update
sudo yum install boost-devel postgresql-devel gcc-c++ subversion postgresql-server

Centos needs you to start the database manually. Ubuntu doesnt.

sudo /etc/init.d/postgresql start

=== Exodus ===

For the latest version of the software:
cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk

Or for not the latest:
wget http://www.neosys.com/support/exodus_all-9.6.tar.gz
tar xvfz exodus_all-9.6.tar.gz
cd exodus_all-9.6

Classic installation steps
./configure
make
sudo make install

=== Setting up Postgres for Exodus ===

==== Register the exodus functions ====

(on Mac OSX, ensure postgres can be found. Change 8.3 to your version) and check pg_config can run)

PATH=/Library/PostgreSQL/8.3/bin/:$PATH
pg_config

log in to postgres template1 database as a superuser

sudo su - postgres

psql -U postgres -d template1
\connect template1

{{postgres function installation}}

Check the functions loaded properly (count them)

\df exodus*

<pre>
List of functions
Schema | Name | Result data type | Argument data types
--------+-------------------------+-----------------------------+-----------------------------------------------------
public | exodus_call | bytea | bytea, bytea, bytea, bytea, bytea, integer, integer
public | exodus_extract_bytea | bytea | bytea, integer, integer, integer
public | exodus_extract_date | date | bytea, integer, integer, integer
public | exodus_extract_datetime | timestamp without time zone | bytea, integer, integer, integer
public | exodus_extract_sort | text | bytea, integer, integer, integer
public | exodus_extract_text | text | bytea, integer, integer, integer
public | exodus_extract_text2 | text | bytea, integer, integer, integer
public | exodus_extract_time | time without time zone | bytea, integer, integer, integer
(8 rows)
</pre>

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

==== Create a user and database for exodus ====

Use the example password for now to avoid further configuration in exodus.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;
CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

Quit postgres command prompt

\q

==== Ensure Exodus can logon to postgres ====

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/encrypted password (instead of only logged-in username without password) For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

Centos
nano ~/data/pg_hba.conf
or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines. NB DONT comment out any other similar lines esp. ones containining "postgres"
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines which allows the 'postgres' user local access through ident authentication, which is needed for cron scripts. The second line, allows anyone to connect locally on 127.0.0.1 if they can provide a valid username and password.

local all postgres ident sameuser
host all all 127.0.0.1 255.255.255.255 md5

quit postgres user

exit

Reload Postgres

Centos
sudo /etc/init.d/postgresql reload
or Ubuntu
sudo /etc/init.d/postgresql-8.3 reload

=== Testing ===

==== Test exodus library ====

nano test1.cpp

<pre>
#include <exodus/exodus.h>
program() {
date().oconv("D").outputln();
print(oconv(date(),"D"));
}
</pre>

g++ test1.cpp -lexodus

./a.out

27 JUN 2009
27 JUN 2009

==== Test database connection ====

nano test2.cpp

<pre>
#include <exodus/exodus.h>
program() {
createfile("exodustest");
}
</pre>

g++ test2.cpp -lexodus

./a.out

NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "exodustest_pkey" for table "exodustest"

==== Test symbolic dictionaries (call backs) ====

nano test3.cpp

<pre>

#include <exodus/exodus.h>

program() {

var testfilename="test_symbolics";
createfile("dict_"^testfilename);
write("F"^FM^0^FM^"ID","dict_"^testfilename,"ID");
write("S"^FM^FM^"Col1","dict_"^testfilename,"SYMCOL1");

createfile(testfilename);
write(1000^FM^2000,testfilename,"3000");

select("select "^testfilename^" with SYMCOL1 = 3000 or with ID = 3000");

//should fail since have not installed a function to handle symbolics in this test
//but it shows that everything else is working
var key1;
if (not readnext(key1))
stop("Cannot readnext (as expected)");
}

</pre>

g++ test3.cpp -lexodus

./a.out

Expected result is which means everything is working and we can implement symbolic dictionaries in exodus.

<pre>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dict_test_symbolics_pkey" for table "dict_test_symbolics"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "test_symbolics_pkey" for table "test_symbolics"
PGRES_FATAL_ERROR: ERROR: pgexodus exodus_call failed. (MVCipc() TEST_SYMBOLICS unknown filename)
Cannot readnext (as expected)</pre>

Log of an installation of libexodus on Centos 5.3

2009-07-19T15:52:56Z

85.17.154.66: /* Register the exodus functions */

=== Preparation ===

sudo yum update
sudo yum install boost-devel postgresql-devel gcc-c++ subversion postgresql-server

Centos needs you to start the database manually. Ubuntu doesnt.

sudo /etc/init.d/postgresql start

=== Exodus ===

For the latest version of the software:
cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk

Or for not the latest:
wget http://www.neosys.com/support/exodus_all-9.6.tar.gz
tar xvfz exodus_all-9.6.tar.gz
cd exodus_all-9.6

Classic installation steps
./configure
make
sudo make install

=== Setting up Postgres for Exodus ===

==== Register the exodus functions ====

(on Mac OSX, ensure postgres can be found. Change 8.3 to your version) and check pg_config can run)

PATH=/Library/PostgreSQL/8.3/bin/:$PATH
pg_config

log in to postgres template1 database as a superuser

sudo su - postgres
psql -U postgres -d template1
\connect template1

{{postgres function installation}}

Check the functions loaded properly (count them)

\df exodus*

<pre>
List of functions
Schema | Name | Result data type | Argument data types
--------+-------------------------+-----------------------------+-----------------------------------------------------
public | exodus_call | bytea | bytea, bytea, bytea, bytea, bytea, integer, integer
public | exodus_extract_bytea | bytea | bytea, integer, integer, integer
public | exodus_extract_date | date | bytea, integer, integer, integer
public | exodus_extract_datetime | timestamp without time zone | bytea, integer, integer, integer
public | exodus_extract_sort | text | bytea, integer, integer, integer
public | exodus_extract_text | text | bytea, integer, integer, integer
public | exodus_extract_text2 | text | bytea, integer, integer, integer
public | exodus_extract_time | time without time zone | bytea, integer, integer, integer
(8 rows)
</pre>

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

==== Create a user and database for exodus ====

Use the example password for now to avoid further configuration in exodus.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;
CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

Quit postgres command prompt

\q

==== Ensure Exodus can logon to postgres ====

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/encrypted password (instead of only logged-in username without password) For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

Centos
nano ~/data/pg_hba.conf
or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines. NB DONT comment out any other similar lines esp. ones containining "postgres"
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines which allows the 'postgres' user local access through ident authentication, which is needed for cron scripts. The second line, allows anyone to connect locally on 127.0.0.1 if they can provide a valid username and password.

local all postgres ident sameuser
host all all 127.0.0.1 255.255.255.255 md5

quit postgres user

exit

Reload Postgres

Centos
sudo /etc/init.d/postgresql reload
or Ubuntu
sudo /etc/init.d/postgresql-8.3 reload

=== Testing ===

==== Test exodus library ====

nano test1.cpp

<pre>
#include <exodus/exodus.h>
program() {
date().oconv("D").outputln();
print(oconv(date(),"D"));
}
</pre>

g++ test1.cpp -lexodus

./a.out

27 JUN 2009
27 JUN 2009

==== Test database connection ====

nano test2.cpp

<pre>
#include <exodus/exodus.h>
program() {
createfile("exodustest");
}
</pre>

g++ test2.cpp -lexodus

./a.out

NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "exodustest_pkey" for table "exodustest"

==== Test symbolic dictionaries (call backs) ====

nano test3.cpp

<pre>

#include <exodus/exodus.h>

program() {

var testfilename="test_symbolics";
createfile("dict_"^testfilename);
write("F"^FM^0^FM^"ID","dict_"^testfilename,"ID");
write("S"^FM^FM^"Col1","dict_"^testfilename,"SYMCOL1");

createfile(testfilename);
write(1000^FM^2000,testfilename,"3000");

select("select "^testfilename^" with SYMCOL1 = 3000 or with ID = 3000");

//should fail since have not installed a function to handle symbolics in this test
//but it shows that everything else is working
var key1;
if (not readnext(key1))
stop("Cannot readnext (as expected)");
}

</pre>

g++ test3.cpp -lexodus

./a.out

Expected result is which means everything is working and we can implement symbolic dictionaries in exodus.

<pre>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dict_test_symbolics_pkey" for table "dict_test_symbolics"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "test_symbolics_pkey" for table "test_symbolics"
PGRES_FATAL_ERROR: ERROR: pgexodus exodus_call failed. (MVCipc() TEST_SYMBOLICS unknown filename)
Cannot readnext (as expected)</pre>

Building on Mac

2009-07-18T22:50:25Z

85.17.154.66: /* Building and Installing exodus */

Building on Mac

2009-07-18T22:50:06Z

85.17.154.66: /* Building and Installing exodus */

Building on Mac

2009-07-18T21:31:53Z

85.17.154.66: /* Installing Boost */

Log of an installation of libexodus on Centos 5.3

2009-07-16T17:00:16Z

85.17.154.66: /* Exodus */

=== Preparation ===

sudo yum update
sudo yum install boost-devel postgresql-devel gcc-c++ subversion postgresql-server

Centos needs you to start the database manually. Ubuntu doesnt.

sudo /etc/init.d/postgresql start

=== Exodus ===

For the latest version of the software:
cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk

Or for not the latest:
wget http://www.neosys.com/support/exodus_all-9.6.tar.gz
tar xvfz exodus_all-9.6.tar.gz
cd exodus_all-9.6

Classic installation steps
./configure
make
sudo make install

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;
CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

\connect exodus

{{postgres function installation}}

Check the functions loaded properly (count them)

\df exodus*

<pre>
List of functions
Schema | Name | Result data type | Argument data types
--------+-------------------------+-----------------------------+-----------------------------------------------------
public | exodus_call | bytea | bytea, bytea, bytea, bytea, bytea, integer, integer
public | exodus_extract_bytea | bytea | bytea, integer, integer, integer
public | exodus_extract_date | date | bytea, integer, integer, integer
public | exodus_extract_datetime | timestamp without time zone | bytea, integer, integer, integer
public | exodus_extract_sort | text | bytea, integer, integer, integer
public | exodus_extract_text | text | bytea, integer, integer, integer
public | exodus_extract_text2 | text | bytea, integer, integer, integer
public | exodus_extract_time | time without time zone | bytea, integer, integer, integer
(8 rows)
</pre>

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

Quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/encrypted password (instead of only logged-in username without password) For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

Centos
nano ~/data/pg_hba.conf
or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines. NB DONT comment out any other similar lines esp. ones containining "postgres"
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines which allows the 'postgres' user local access through ident authentication, which is needed for cron scripts. The second line, allows anyone to connect locally on 127.0.0.1 if they can provide a valid username and password.

local all postgres ident sameuser
host all all 127.0.0.1 255.255.255.255 md5

quit postgres user

exit

Reload Postgres

Centos
sudo /etc/init.d/postgresql reload
or Ubuntu
sudo /etc/init.d/postgresql-8.3 reload

=== Testing ===

==== Test exodus library ====

nano test1.cpp

<pre>
#include <exodus/exodus.h>
program() {
date().oconv("D").outputln();
print(oconv(date(),"D"));
}
</pre>

g++ test1.cpp -lexodus

./a.out

27 JUN 2009
27 JUN 2009

==== Test database connection ====

nano test2.cpp

<pre>
#include <exodus/exodus.h>
program() {
createfile("exodustest");
}
</pre>

g++ test2.cpp -lexodus

./a.out

NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "exodustest_pkey" for table "exodustest"

==== Test symbolic dictionaries (call backs) ====

nano test3.cpp

<pre>

#include <exodus/exodus.h>

program() {

var testfilename="test_symbolics";
createfile("dict_"^testfilename);
write("F"^FM^0^FM^"ID","dict_"^testfilename,"ID");
write("S"^FM^FM^"Col1","dict_"^testfilename,"SYMCOL1");

createfile(testfilename);
write(1000^FM^2000,testfilename,"3000");

select("select "^testfilename^" with SYMCOL1 = 3000 or with ID = 3000");

//should fail since have not installed a function to handle symbolics in this test
//but it shows that everything else is working
var key1;
if (not readnext(key1))
stop("Cannot readnext (as expected)");
}

</pre>

g++ test3.cpp -lexodus

./a.out

Expected result is which means everything is working and we can implement symbolic dictionaries in exodus.

<pre>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dict_test_symbolics_pkey" for table "dict_test_symbolics"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "test_symbolics_pkey" for table "test_symbolics"
PGRES_FATAL_ERROR: ERROR: pgexodus exodus_call failed. (MVCipc() TEST_SYMBOLICS unknown filename)
Cannot readnext (as expected)</pre>

Log of an installation of libexodus on Centos 5.3

2009-07-16T01:10:34Z

85.17.154.66: /* Test symbolic dictionaries (call backs) */

=== Preparation ===

sudo yum update
sudo yum install boost-devel postgresql-devel gcc-c++ subversion postgresql-server

Centos needs you to start the database manually. Ubuntu doesnt.

sudo /etc/init.d/postgresql start

=== Exodus ===

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk

./configure
make
sudo make install

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;
CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

\connect exodus

{{postgres function installation}}

Check the functions loaded properly (count them)

\df exodus*

<pre>
List of functions
Schema | Name | Result data type | Argument data types
--------+-------------------------+-----------------------------+-----------------------------------------------------
public | exodus_call | bytea | bytea, bytea, bytea, bytea, bytea, integer, integer
public | exodus_extract_bytea | bytea | bytea, integer, integer, integer
public | exodus_extract_date | date | bytea, integer, integer, integer
public | exodus_extract_datetime | timestamp without time zone | bytea, integer, integer, integer
public | exodus_extract_sort | text | bytea, integer, integer, integer
public | exodus_extract_text | text | bytea, integer, integer, integer
public | exodus_extract_text2 | text | bytea, integer, integer, integer
public | exodus_extract_time | time without time zone | bytea, integer, integer, integer
(8 rows)
</pre>

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

Quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/encrypted password (instead of only logged-in username without password) For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

Centos
nano ~/data/pg_hba.conf
or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines. NB DONT comment out any other similar lines esp. ones containining "postgres"
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines which allows the 'postgres' user local access through ident authentication, which is needed for cron scripts. The second line, allows anyone to connect locally on 127.0.0.1 if they can provide a valid username and password.

local all postgres ident sameuser
host all all 127.0.0.1 255.255.255.255 md5

quit postgres user

exit

Reload Postgres

Centos
sudo /etc/init.d/postgresql reload
or Ubuntu
sudo /etc/init.d/postgresql-8.3 reload

=== Testing ===

==== Test exodus library ====

nano test1.cpp

<pre>
#include <exodus/exodus.h>
program() {
date().oconv("D").outputln();
print(oconv(date(),"D"));
}
</pre>

g++ test1.cpp -lexodus

./a.out

27 JUN 2009
27 JUN 2009

==== Test database connection ====

nano test2.cpp

<pre>
#include <exodus/exodus.h>
program() {
createfile("exodustest");
}
</pre>

g++ test2.cpp -lexodus

./a.out

NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "exodustest_pkey" for table "exodustest"

==== Test symbolic dictionaries (call backs) ====

nano test3.cpp

<pre>

#include <exodus/exodus.h>

program() {

var testfilename="test_symbolics";
createfile("dict_"^testfilename);
write("F"^FM^0^FM^"ID","dict_"^testfilename,"ID");
write("S"^FM^FM^"Col1","dict_"^testfilename,"SYMCOL1");

createfile(testfilename);
write(1000^FM^2000,testfilename,"3000");

select("select "^testfilename^" with SYMCOL1 = 3000 or with ID = 3000");

//should fail since have not installed a function to handle symbolics in this test
//but it shows that everything else is working
var key1;
if (not readnext(key1))
stop("Cannot readnext (as expected)");
}

</pre>

g++ test3.cpp -lexodus

./a.out

Expected result is which means everything is working and we can implement symbolic dictionaries in exodus.

<pre>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dict_test_symbolics_pkey" for table "dict_test_symbolics"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "test_symbolics_pkey" for table "test_symbolics"
PGRES_FATAL_ERROR: ERROR: pgexodus exodus_call failed. (MVCipc() TEST_SYMBOLICS unknown filename)
Cannot readnext (as expected)</pre>

Log of an installation of libexodus on Centos 5.3

2009-07-16T01:05:39Z

85.17.154.66: /* Exodus */

=== Preparation ===

sudo yum update
sudo yum install boost-devel postgresql-devel gcc-c++ subversion postgresql-server

Centos needs you to start the database manually. Ubuntu doesnt.

sudo /etc/init.d/postgresql start

=== Exodus ===

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk

./configure
make
sudo make install

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;
CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

\connect exodus

{{postgres function installation}}

Check the functions loaded properly (count them)

\df exodus*

<pre>
List of functions
Schema | Name | Result data type | Argument data types
--------+-------------------------+-----------------------------+-----------------------------------------------------
public | exodus_call | bytea | bytea, bytea, bytea, bytea, bytea, integer, integer
public | exodus_extract_bytea | bytea | bytea, integer, integer, integer
public | exodus_extract_date | date | bytea, integer, integer, integer
public | exodus_extract_datetime | timestamp without time zone | bytea, integer, integer, integer
public | exodus_extract_sort | text | bytea, integer, integer, integer
public | exodus_extract_text | text | bytea, integer, integer, integer
public | exodus_extract_text2 | text | bytea, integer, integer, integer
public | exodus_extract_time | time without time zone | bytea, integer, integer, integer
(8 rows)
</pre>

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

Quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/encrypted password (instead of only logged-in username without password) For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

Centos
nano ~/data/pg_hba.conf
or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines. NB DONT comment out any other similar lines esp. ones containining "postgres"
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines which allows the 'postgres' user local access through ident authentication, which is needed for cron scripts. The second line, allows anyone to connect locally on 127.0.0.1 if they can provide a valid username and password.

local all postgres ident sameuser
host all all 127.0.0.1 255.255.255.255 md5

quit postgres user

exit

Reload Postgres

Centos
sudo /etc/init.d/postgresql reload
or Ubuntu
sudo /etc/init.d/postgresql-8.3 reload

=== Testing ===

==== Test exodus library ====

nano test1.cpp

<pre>
#include <exodus/exodus.h>
program() {
date().oconv("D").outputln();
print(oconv(date(),"D"));
}
</pre>

g++ test1.cpp -lexodus

./a.out

27 JUN 2009
27 JUN 2009

==== Test database connection ====

nano test2.cpp

<pre>
#include <exodus/exodus.h>
program() {
createfile("exodustest");
}
</pre>

g++ test2.cpp -lexodus

./a.out

NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "exodustest_pkey" for table "exodustest"

==== Test symbolic dictionaries (call backs) ====

nano test3.cpp

<pre>

#include <exodus.h>

program() {

var testfilename="test_symbolics";
createfile("dict_"^testfilename);
write("F"^FM^0^FM^"ID","dict_"^testfilename,"ID");
write("S"^FM^FM^"Col1","dict_"^testfilename,"SYMCOL1");

createfile(testfilename);
write(1000^FM^2000,testfilename,"3000");

select("select "^testfilename^" with SYMCOL1 = 3000 or with ID = 3000");

//should fail since have not installed a function to handle symbolics in this test
//but it shows that everything else is working
var key1;
if (not readnext(key1))
stop("Cannot readnext (as expected)");
}

</pre>

g++ test3.cpp -lexodus

./a.out

Expected result is which means everything is working and we can implement symbolic dictionaries in exodus.

<pre>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dict_test_symbolics_pkey" for table "dict_test_symbolics"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "test_symbolics_pkey" for table "test_symbolics"
PGRES_FATAL_ERROR: ERROR: pgexodus exodus_call failed. (MVCipc() TEST_SYMBOLICS unknown filename)
Cannot readnext (as expected)</pre>

Linux

2009-07-11T21:56:37Z

85.17.154.66:

== Building and Installing Exodus ==

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== exodus Dependencies ===

==== Building Boost from Source ====

Boost binaries are available for most platform but it can be easier to build from source as follows:

Minimum required is boost 1_32. Here we install 1.38.

Optionally get ICU to fully support unicode in boost regex

Centos
yum install libicu-devel
Ubuntu
apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build and install Boost

make
sudo make install

Centos - Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

sudo nano /etc/ld.so.conf

Ensure the new boost libraries are registered for use.

sudo /sbin/ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

sudo ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME

Building on Mac

2009-07-11T21:20:29Z

85.17.154.66:

Installing Exodus on Mac is almost identical to installing on Linux but it is a little harder to acquire and configure the dependencies.

This install was performed on OSX 10.5.5 (Leopard)

=== Installing dependencies ===

==== Installing C++ compiler ====

Older macs might need to install XCODE tools from http://developer.apple.com after free registration. This is unfortunately a large 1Gb download.

Newer macs have XCODE tools installer in the Applications or Library folder and you just have to install it.

The XCODE package includes subversion

==== Installing Postgres ====

http://www.postgresql.org/download/macosx

http://www.enterprisedb.com/products/pgdownload.do#osx

http://www.enterprisedb.com/getfile.jsp?fileid=484

Once downloaded, just do a standard install and remember the admin user password.

==== Installing Boost ====

Minimum required is boost 1_33. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex. How to do this on Mac OSX is unknown at the moment.

Download and unpack Boost Source

In safari get http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2 and move it to your home directory.

Open a classic console shell (terminal)

cd ~
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,regex,thread

Optionally, speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

sudo make install

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

sudo ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

=== Building and Installing libexodus ===

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

Ensure postgres can be found (change 8.3 to your version) and check pg_config can run

PATH=/Library/PostgreSQL/8.3/bin/:$PATH
pg_config

Find out where your boost libraries are installed and what they are named.

find /usr | grep libboost

Customise the following command to suit the boost library location and names that you found in the previous step. There might be a configure.bsd file to modify/use.

./configure --with-boost-libdir=/usr/local/lib \
--with-boost-date-time=boost_date_time-xgcc40-mt \
--with-boost-filesystem=boost_filesystem-xgcc40-mt \
--with-boost-regex=boost_regex-xgcc40-mt \
--with-boost-thread=boost_thread-xgcc40-mt

make
sudo make install

An additional installation step that unfortunately has to be done by hand at the moment.

sudo ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

From here on the steps are almost identical to [[Log_of_an_installation_of_libexodus_on_Centos_5.3]]

Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope

2009-07-11T18:54:30Z

85.17.154.66: /* Preparation */

=== Preparation ===

sudo apt-get update
sudo apt-get upgrade
sudo apt-get install postgresql postgresql-server-dev-8.3 libpq-dev libboost-dev build-essential subversion

=== Exodus ===

The rest of the installation is almost identical to [[Log_of_an_installation_of_libexodus_on_Centos_5.3]]

Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope

2009-07-11T18:52:07Z

85.17.154.66:

=== Preparation ===

sudo su -
apt-get update
apt-get upgrade
apt-get install postgresql postgresql-server-dev-8.3 libpq-dev libboost-dev build-essential subversion

=== Exodus ===

The rest of the installation is almost identical to [[Log_of_an_installation_of_libexodus_on_Centos_5.3]]

Linux

2009-07-11T14:15:27Z

85.17.154.66: /* Setting up Postgres for Exodus */

== Building and Installing libexodus ==

requires Boost >= 1.32 and Postgres >= 8.1

Following steps are from Centos 5.2/Boost 1.38/Postgres 8.3/Gnu Compiler 4.1.2

alternatively:

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== libexodus Dependencies ===

==== Installing g++ compiler ====

yum list|grep gcc

yum install gcc-c++.i386

or for Ubuntu
sudo aptitude install build-essential

==== Installing Boost ====

Minimum required is boost 1_35. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex

yum install libicu-devel

or on Ubuntu

apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

su

make install

Skip to the next section if on Ubuntu, this part is unnecessary.

Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

nano /etc/ld.so.conf

Ensure the new config is operational.

ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

==== Installing Postgres ====

Version 8.3

yum install postgresql-devel

or on Ubuntu

sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Downloading and Building libexodus ===

libexodus.so is a shared library that allows you to write c++ programs with the style and semantics of pick basic. If you want traditional pick-like dictionary based sort/select/index it requires pgexodus to be built and installed too.

To give some insight into the automatic procedure see [[Manual Building with g++]]

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (may be out of date)

cd ~
wget http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Build and Install

./configure
make
make install

A couple of installation steps that unfortunately have to be done by hand at the moment.

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can down develop in c++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus -I/usr/local/include/exodus
./a.out
25 JUN 2009

== Building and Installing pgexodus ==

pgexodus.so is a shared library addin c function for postgres to perform sort/select/index functions otherwise it is not required.

=== pgexodus Dependencies ===

==== Installing Postgres ====

Version 8.3

yum install postgresql
yum install postgresql-devel

or on Ubuntu

sudo aptitude install postgresql-8.3
sudo aptitude install postgresql-dev
sudo aptitude install libpq-dev

Locate fmgr.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate fmgr.h

=== Building pgexodus ===

Currently hand built without even a make file. standard configure/make using autoconf/automake will be available soon http://www.lrde.epita.fr/~adl/dl/autotools.pdf

here are some old manual [[pgexodus handbuilding instructions]]

check you have access to the pg_config program

pg_config

if not, do something like the following, depending on where your Postgres is installed.

PATH=/Library/PostgreSQL/8.3/bin/:$PATH
pg_config

Do the classic configure, make, make install procedure

cd ~/exodus/trunk/exodus/pgexodus
./configure
make
sudo make install

=== Installing pgexodus ===

Register the c functions in postgres

sudo su - postgres

psql
\connect exodus

{{postgres function installation}}

Check the functions loaded properly (count them)

\df exodus*

<pre>
List of functions
Schema | Name | Result data type | Argument data types
--------+-------------------------+-----------------------------+-----------------------------------------------------
public | exodus_call | bytea | bytea, bytea, bytea, bytea, bytea, integer, integer
public | exodus_extract_bytea | bytea | bytea, integer, integer, integer
public | exodus_extract_date | date | bytea, integer, integer, integer
public | exodus_extract_datetime | timestamp without time zone | bytea, integer, integer, integer
public | exodus_extract_sort | text | bytea, integer, integer, integer
public | exodus_extract_text | text | bytea, integer, integer, integer
public | exodus_extract_text2 | text | bytea, integer, integer, integer
public | exodus_extract_time | time without time zone | bytea, integer, integer, integer
(8 rows)
</pre>

Quit postgres command prompt and quite postgres user

\q
exit

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;
CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

#quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/unencrypted password (instead of only logged-in username without password)

For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

nano ~/data/pg_hba.conf

or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines. NB DONT comment out any other similar lines esp. ones containining "postgres"
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines
local all all password
host all all 127.0.0.1/32 password
hostssl all all 0.0.0.0/0 password

quit postgres user

exit

for redhat/centos
service postgresql reload
or for Ubuntu
sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME

Log of an installation of libexodus on Centos 5.3

2009-07-11T14:09:47Z

85.17.154.66: /* Preparation */

=== Preparation ===

sudo su -
yum update
yum install boost-devel postgresql-devel gcc-c++ subversion postgresql-server
service postgresql start

=== Exodus ===

(pgexodus, which allows "sort/select/index by", isnt included in this quick install)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

ln -s /usr/include /usr/include/postgresql

./configure
make
make install

nano /etc/ld.so.conf

... and add the following line (nb with no preceding word include)

/usr/local/lib

register the new libraries

/sbin/ldconfig

make a pointer to the include files

ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

=== Testing ===

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
print(oconv(date(),"D"));
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus

./a.out

27 JUN 2009
27 JUN 2009

Log of an installation of libexodus on Centos 5.3

2009-07-11T14:08:46Z

85.17.154.66: /* Preparation */

=== Preparation ===

sudo su -
yum update
yum install boost-devel postgresql-devel gcc-c++ subversion postgresql-server

=== Exodus ===

(pgexodus, which allows "sort/select/index by", isnt included in this quick install)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

ln -s /usr/include /usr/include/postgresql

./configure
make
make install

nano /etc/ld.so.conf

... and add the following line (nb with no preceding word include)

/usr/local/lib

register the new libraries

/sbin/ldconfig

make a pointer to the include files

ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

=== Testing ===

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
print(oconv(date(),"D"));
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus

./a.out

27 JUN 2009
27 JUN 2009

Linux

2009-07-11T11:04:59Z

85.17.154.66: /* Building and Installing libexodus */

== Building and Installing libexodus ==

requires Boost >= 1.32 and Postgres >= 8.1

Following steps are from Centos 5.2/Boost 1.38/Postgres 8.3/Gnu Compiler 4.1.2

alternatively:

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== libexodus Dependencies ===

==== Installing g++ compiler ====

yum list|grep gcc

yum install gcc-c++.i386

or for Ubuntu
sudo aptitude install build-essential

==== Installing Boost ====

Minimum required is boost 1_35. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex

yum install libicu-devel

or on Ubuntu

apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

su

make install

Skip to the next section if on Ubuntu, this part is unnecessary.

Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

nano /etc/ld.so.conf

Ensure the new config is operational.

ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

==== Installing Postgres ====

Version 8.3

yum install postgresql-devel

or on Ubuntu

sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Downloading and Building libexodus ===

libexodus.so is a shared library that allows you to write c++ programs with the style and semantics of pick basic. If you want traditional pick-like dictionary based sort/select/index it requires pgexodus to be built and installed too.

To give some insight into the automatic procedure see [[Manual Building with g++]]

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (may be out of date)

cd ~
wget http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Build and Install

./configure
make
make install

A couple of installation steps that unfortunately have to be done by hand at the moment.

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can down develop in c++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus -I/usr/local/include/exodus
./a.out
25 JUN 2009

== Building and Installing pgexodus ==

pgexodus.so is a shared library addin c function for postgres to perform sort/select/index functions otherwise it is not required.

=== pgexodus Dependencies ===

==== Installing Postgres ====

Version 8.3

yum install postgresql
yum install postgresql-devel

or on Ubuntu

sudo aptitude install postgresql-8.3
sudo aptitude install postgresql-dev
sudo aptitude install libpq-dev

Locate fmgr.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate fmgr.h

=== Building pgexodus ===

Currently hand built without even a make file. standard configure/make using autoconf/automake will be available soon http://www.lrde.epita.fr/~adl/dl/autotools.pdf

here are some old manual [[pgexodus handbuilding instructions]]

check you have access to the pg_config program

pg_config

if not, do something like the following, depending on where your Postgres is installed.

PATH=/Library/PostgreSQL/8.3/bin/:$PATH
pg_config

Do the classic configure, make, make install procedure

cd ~/exodus/trunk/exodus/pgexodus
./configure
make
sudo make install

=== Installing pgexodus ===

Register the c functions in postgres

sudo su - postgres

psql
\connect exodus

{{postgres function installation}}

Check the functions loaded properly (count them)

\df exodus*

<pre>
List of functions
Schema | Name | Result data type | Argument data types
--------+-------------------------+-----------------------------+-----------------------------------------------------
public | exodus_call | bytea | bytea, bytea, bytea, bytea, bytea, integer, integer
public | exodus_extract_bytea | bytea | bytea, integer, integer, integer
public | exodus_extract_date | date | bytea, integer, integer, integer
public | exodus_extract_datetime | timestamp without time zone | bytea, integer, integer, integer
public | exodus_extract_sort | text | bytea, integer, integer, integer
public | exodus_extract_text | text | bytea, integer, integer, integer
public | exodus_extract_text2 | text | bytea, integer, integer, integer
public | exodus_extract_time | time without time zone | bytea, integer, integer, integer
(8 rows)
</pre>

Quit postgres command prompt and quite postgres user

\q
exit

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;
CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

#quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/unencrypted password (instead of only logged-in username without password)

For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

nano data/pg_hba.conf

or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines. NB DONT comment out any other similar lines esp. ones containining "postgres"
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines
local all all password
host all all 127.0.0.1/32 password
hostssl all all 0.0.0.0/0 password

quit postgres user

exit

for redhat/centos
service postgresql reload
or for Ubuntu
sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME

Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope

2009-07-11T10:41:34Z

85.17.154.66: /* Testing */

=== Preparation ===

sudo su -
apt-get update
apt-get upgrade
apt-get install postgresql libpq-dev libboost-dev build-essential subversion

=== Exodus ===

(pgexodus (which allows "sort/select/index by") isnt included in this quick install)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

./configure
make
make install

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

=== Testing ===

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
println(oconv(date(),"D"));
}
</pre>

g++ tester.cpp -lexodus -I/usr/local/include/exodus

/a.out

25 JUN 2009
25 JUN 2009

Building on Mac

2009-07-11T09:19:11Z

85.17.154.66: /* Building and Installing libexodus */

Installing Exodus on Mac is almost identical to installing on Linux but it is a little harder to acquire and configure the dependencies.

This install was performed on OSX 10.5.5 (Leopard)

=== Installing dependencies ===

==== Installing C++ compiler ====

Older macs might need to install XCODE tools from http://developer.apple.com after free registration. This is unfortunately a large 1Gb download.

Newer macs have XCODE tools installer in the Applications or Library folder and you just have to install it.

The XCODE package includes subversion

==== Installing Postgres ====

http://www.postgresql.org/download/macosx

http://www.enterprisedb.com/products/pgdownload.do#osx

http://www.enterprisedb.com/getfile.jsp?fileid=484

Once downloaded, just do a standard install and remember the admin user password.

==== Installing Boost ====

Minimum required is boost 1_33. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex. How to do this on Mac OSX is unknown at the moment.

Download and unpack Boost Source

In safari get http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2 and move it to your home directory.

Open a classic console shell (terminal)

cd ~
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,regex,thread

Optionally, speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

sudo make install

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

sudo ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

=== Building and Installing libexodus ===

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (using curl since wget isnt default installed on mac osx) - may not be the latest version

cd ~
curl http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz>Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Ensure postgres can be found (change 8.3 to your version) and check pg_config can run

PATH=/Library/PostgreSQL/8.3/bin/:$PATH
pg_config

Find out where your boost libraries are installed and what they are named.

find /usr | grep libboost

Customise the following command to suit the boost library location and names that you found in the previous step. There might be a configure.mac file to modify/use.

./configure --with-boost-libdir=/usr/local/lib \
--with-boost-date-time=boost_date_time-xgcc40-mt \
--with-boost-filesystem=boost_filesystem-xgcc40-mt \
--with-boost-regex=boost_regex-xgcc40-mt \
--with-boost-thread=boost_thread-xgcc40-mt

make
sudo make install

An additional installation step that unfortunately has to be done by hand at the moment.

sudo ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can now develop in C++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus -I/usr/local/include/exodus
./a.out
25 JUN 2009

=== Setting up Postgres for Exodus ===

#Finder, Places, Applications, PostgreSQL 8.3, PGAdmin III
#Login as superuser eg postgres
#Select the postgres database
#Click SQL in the toolbar and enter the following sql command.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;

and click the Execute Query button. It should show "Query returned successfully"

CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

and click the Execute Query button. It should show "Query returned successfully"

Building on Mac

2009-07-11T09:15:23Z

85.17.154.66: /* Building and Installing libexodus */

Installing Exodus on Mac is almost identical to installing on Linux but it is a little harder to acquire and configure the dependencies.

This install was performed on OSX 10.5.5 (Leopard)

=== Installing dependencies ===

==== Installing C++ compiler ====

Older macs might need to install XCODE tools from http://developer.apple.com after free registration. This is unfortunately a large 1Gb download.

Newer macs have XCODE tools installer in the Applications or Library folder and you just have to install it.

The XCODE package includes subversion

==== Installing Postgres ====

http://www.postgresql.org/download/macosx

http://www.enterprisedb.com/products/pgdownload.do#osx

http://www.enterprisedb.com/getfile.jsp?fileid=484

Once downloaded, just do a standard install and remember the admin user password.

==== Installing Boost ====

Minimum required is boost 1_33. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex. How to do this on Mac OSX is unknown at the moment.

Download and unpack Boost Source

In safari get http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2 and move it to your home directory.

Open a classic console shell (terminal)

cd ~
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,regex,thread

Optionally, speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

sudo make install

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

sudo ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

=== Building and Installing libexodus ===

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (using curl not wget) - may not be the latest version

cd ~
curl http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz>Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Ensure postgres can be found (change 8.3 to your version) and check pg_config can run

PATH=/Library/PostgreSQL/8.3/bin/:$PATH
pg_config

Find out where your boost libraries are installed and what they are named.

find /usr | grep libboost

Customise the following command to suit the boost library location and names that you found in the previous step. There might be a configure.mac file to modify/use.

./configure --with-boost-libdir=/usr/local/lib \
--with-boost-date-time=boost_date_time-xgcc40-mt \
--with-boost-filesystem=boost_filesystem-xgcc40-mt \
--with-boost-regex=boost_regex-xgcc40-mt \
--with-boost-thread=boost_thread-xgcc40-mt

make
sudo make install

An additional installation step that unfortunately has to be done by hand at the moment.

sudo ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can now develop in C++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus -I/usr/local/include/exodus
./a.out
25 JUN 2009

=== Setting up Postgres for Exodus ===

#Finder, Places, Applications, PostgreSQL 8.3, PGAdmin III
#Login as superuser eg postgres
#Select the postgres database
#Click SQL in the toolbar and enter the following sql command.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;

and click the Execute Query button. It should show "Query returned successfully"

CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

and click the Execute Query button. It should show "Query returned successfully"

Log of an installation of libexodus on Ubuntu 8.04.1 LTS

2009-07-11T09:14:08Z

85.17.154.66:

=== Preparation ===

sudo su -

apt-get update
apt-get upgrade
apt-get install postgresql postgresql-server-dev* libpq-dev libboost-dev libboost-date-time-dev libboost-filesystem-dev libboost-regex-dev libboost-thread-dev build-essential subversion

=== Exodus ===

(pgexodus (which allows "sort/select/index by") isnt included in this quick install)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

./configure
make
make install

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

=== Testing ===

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
println(oconv(date(),"D"));
}
</pre>

g++ tester.cpp -lexodus -I/usr/local/include/exodus

/a.out

25 JUN 2009
25 JUN 2009

Linux

2009-07-11T08:42:48Z

85.17.154.66:

== Building and Installing libexodus ==

requires Boost >= 1.35 and Postgres >= 8.1

Following steps are from Centos 5.2/Boost 1.38/Postgres 8.3/Gnu Compiler 4.1.2

alternatively:

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== libexodus Dependencies ===

==== Installing g++ compiler ====

yum list|grep gcc

yum install gcc-c++.i386

or for Ubuntu
sudo aptitude install build-essential

==== Installing Boost ====

Minimum required is boost 1_35. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex

yum install libicu-devel

or on Ubuntu

apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

su

make install

Skip to the next section if on Ubuntu, this part is unnecessary.

Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

nano /etc/ld.so.conf

Ensure the new config is operational.

ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

==== Installing Postgres ====

Version 8.3

yum install postgresql-devel

or on Ubuntu

sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Downloading and Building libexodus ===

libexodus.so is a shared library that allows you to write c++ programs with the style and semantics of pick basic. If you want traditional pick-like dictionary based sort/select/index it requires pgexodus to be built and installed too.

To give some insight into the automatic procedure see [[Manual Building with g++]]

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (may be out of date)

cd ~
wget http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Build and Install

./configure
make
make install

A couple of installation steps that unfortunately have to be done by hand at the moment.

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can down develop in c++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus -I/usr/local/include/exodus
./a.out
25 JUN 2009

== Building and Installing pgexodus ==

pgexodus.so is a shared library addin c function for postgres to perform sort/select/index functions otherwise it is not required.

=== pgexodus Dependencies ===

==== Installing Postgres ====

Version 8.3

yum install postgresql
yum install postgresql-devel

or on Ubuntu

sudo aptitude install postgresql-8.3
sudo aptitude install postgresql-dev
sudo aptitude install libpq-dev

Locate fmgr.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate fmgr.h

=== Building pgexodus ===

Currently hand built without even a make file. standard configure/make using autoconf/automake will be available soon http://www.lrde.epita.fr/~adl/dl/autotools.pdf

here are some old manual [[pgexodus handbuilding instructions]]

check you have access to the pg_config program

pg_config

if not, do something like the following, depending on where your Postgres is installed.

PATH=/Library/PostgreSQL/8.3/bin/:$PATH
pg_config

Do the classic configure, make, make install procedure

cd ~/exodus/trunk/exodus/pgexodus
./configure
make
sudo make install

=== Installing pgexodus ===

Register the c functions in postgres

sudo su - postgres

psql
\connect exodus

{{postgres function installation}}

Check the functions loaded properly (count them)

\df exodus*

<pre>
List of functions
Schema | Name | Result data type | Argument data types
--------+-------------------------+-----------------------------+-----------------------------------------------------
public | exodus_call | bytea | bytea, bytea, bytea, bytea, bytea, integer, integer
public | exodus_extract_bytea | bytea | bytea, integer, integer, integer
public | exodus_extract_date | date | bytea, integer, integer, integer
public | exodus_extract_datetime | timestamp without time zone | bytea, integer, integer, integer
public | exodus_extract_sort | text | bytea, integer, integer, integer
public | exodus_extract_text | text | bytea, integer, integer, integer
public | exodus_extract_text2 | text | bytea, integer, integer, integer
public | exodus_extract_time | time without time zone | bytea, integer, integer, integer
(8 rows)
</pre>

Quit postgres command prompt and quite postgres user

\q
exit

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;
CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

#quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/unencrypted password (instead of only logged-in username without password)

For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

nano data/pg_hba.conf

or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines. NB DONT comment out any other similar lines esp. ones containining "postgres"
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines
local all all password
host all all 127.0.0.1/32 password
hostssl all all 0.0.0.0/0 password

quit postgres user

exit

for redhat/centos
service postgresql reload
or for Ubuntu
sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME

Linux

2009-07-10T14:21:40Z

85.17.154.66: /* Installing pgexodus */

== Building and Installing libexodus ==

requires Boost >= 1.35 and Postgres >= 8.1

Following steps are from Centos 5.2/Boost 1.38/Postgres 8.3/Gnu Compiler 4.1.2

alternatively:

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== libexodus Dependencies ===

==== Installing g++ compiler ====

yum list|grep gcc

yum install gcc-c++.i386

or for Ubuntu
sudo aptitude install build-essential

==== Installing Boost ====

Minimum required is boost 1_35. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex

yum install libicu-devel

or on Ubuntu

apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

su

make install

Skip to the next section if on Ubuntu, this part is unnecessary.

Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

nano /etc/ld.so.conf

Ensure the new config is operational.

ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

==== Installing Postgres ====

Version 8.3

yum install postgresql-devel

or on Ubuntu

sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Downloading and Building libexodus ===

libexodus.so is a shared library that allows you to write c++ programs with the style and semantics of pick basic. If you want traditional pick-like dictionary based sort/select/index it requires pgexodus to be built and installed too.

To give some insight into the automatic procedure see [[Manual Building with g++]]

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (may be out of date)

cd ~
wget http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Build and Install

./configure
make
make install

A couple of installation steps that unfortunately have to be done by hand at the moment.

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can down develop in c++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

== Building and Installing pgexodus ==

pgexodus.so is a shared library addin c function for postgres to perform sort/select/index functions otherwise it is not required.

=== pgexodus Dependencies ===

==== Installing Postgres ====

Version 8.3

yum install postgresql
yum install postgresql-devel

or on Ubuntu

sudo aptitude install postgresql-8.3
sudo aptitude install postgresql-dev
sudo aptitude install libpq-dev

Locate fmgr.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate fmgr.h

=== Building pgexodus ===

Currently hand built without even a make file. standard configure/make using autoconf/automake will be available soon http://www.lrde.epita.fr/~adl/dl/autotools.pdf

here are some old manual [[pgexodus handbuilding instructions]]

check you have access to the pg_config program

pg_config

if not, do something like the following, depending on where your Postgres is installed.

PATH=/Library/PostgreSQL/8.3/bin/:$PATH
pg_config

Do the classic configure, make, make install procedure

cd ~/exodus/trunk/exodus/pgexodus
./configure
make
sudo make install

=== Installing pgexodus ===

Register the c functions in postgres

sudo su - postgres

psql
\connect exodus

{{postgres function installation}}

Check the functions loaded properly (count them)

\df exodus*

<pre>
List of functions
Schema | Name | Result data type | Argument data types
--------+-------------------------+-----------------------------+-----------------------------------------------------
public | exodus_call | bytea | bytea, bytea, bytea, bytea, bytea, integer, integer
public | exodus_extract_bytea | bytea | bytea, integer, integer, integer
public | exodus_extract_date | date | bytea, integer, integer, integer
public | exodus_extract_datetime | timestamp without time zone | bytea, integer, integer, integer
public | exodus_extract_sort | text | bytea, integer, integer, integer
public | exodus_extract_text | text | bytea, integer, integer, integer
public | exodus_extract_text2 | text | bytea, integer, integer, integer
public | exodus_extract_time | time without time zone | bytea, integer, integer, integer
(8 rows)
</pre>

Quit postgres command prompt and quite postgres user

\q
exit

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;
CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

#quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/unencrypted password (instead of only logged-in username without password)

For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

nano data/pg_hba.conf

or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines. NB DONT comment out any other similar lines esp. ones containining "postgres"
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines
local all all password
host all all 127.0.0.1/32 password
hostssl all all 0.0.0.0/0 password

quit postgres user

exit

for redhat/centos
service postgresql reload
or for Ubuntu
sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME

Linux

2009-07-10T12:44:20Z

85.17.154.66: /* Building pgexodus */

== Building and Installing libexodus ==

requires Boost >= 1.35 and Postgres >= 8.1

Following steps are from Centos 5.2/Boost 1.38/Postgres 8.3/Gnu Compiler 4.1.2

alternatively:

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== libexodus Dependencies ===

==== Installing g++ compiler ====

yum list|grep gcc

yum install gcc-c++.i386

or for Ubuntu
sudo aptitude install build-essential

==== Installing Boost ====

Minimum required is boost 1_35. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex

yum install libicu-devel

or on Ubuntu

apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

su

make install

Skip to the next section if on Ubuntu, this part is unnecessary.

Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

nano /etc/ld.so.conf

Ensure the new config is operational.

ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

==== Installing Postgres ====

Version 8.3

yum install postgresql-devel

or on Ubuntu

sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Downloading and Building libexodus ===

libexodus.so is a shared library that allows you to write c++ programs with the style and semantics of pick basic. If you want traditional pick-like dictionary based sort/select/index it requires pgexodus to be built and installed too.

To give some insight into the automatic procedure see [[Manual Building with g++]]

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (may be out of date)

cd ~
wget http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Build and Install

./configure
make
make install

A couple of installation steps that unfortunately have to be done by hand at the moment.

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can down develop in c++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

== Building and Installing pgexodus ==

pgexodus.so is a shared library addin c function for postgres to perform sort/select/index functions otherwise it is not required.

=== pgexodus Dependencies ===

==== Installing Postgres ====

Version 8.3

yum install postgresql
yum install postgresql-devel

or on Ubuntu

sudo aptitude install postgresql-8.3
sudo aptitude install postgresql-dev
sudo aptitude install libpq-dev

Locate fmgr.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate fmgr.h

=== Building pgexodus ===

Currently hand built without even a make file. standard configure/make using autoconf/automake will be available soon http://www.lrde.epita.fr/~adl/dl/autotools.pdf

here are some old manual [[pgexodus handbuilding instructions]]

check you have access to the pg_config program

pg_config

if not, do something like the following, depending on where your Postgres is installed.

PATH=/Library/PostgreSQL/8.3/bin/:$PATH
pg_config

Do the classic configure, make, make install procedure

cd ~/exodus/trunk/exodus/pgexodus
./configure
make
sudo make install

=== Installing pgexodus ===

Register the c functions in postgres

sudo su - postgres

psql
\connect exodus

{{postgres function installation}}

Check the functions loaded properly

\df exodus*

<pre>
List of functions
Schema | Name | Result data type | Argument data types
--------+-------------------------+-----------------------------+-----------------------------------------------------
public | exodus_call | bytea | bytea, bytea, bytea, bytea, bytea, integer, integer
public | exodus_extract_bytea | bytea | bytea, integer, integer, integer
public | exodus_extract_date | date | bytea, integer, integer, integer
public | exodus_extract_datetime | timestamp without time zone | bytea, integer, integer, integer
public | exodus_extract_sort | text | bytea, integer, integer, integer
public | exodus_extract_text | text | bytea, integer, integer, integer
public | exodus_extract_text2 | text | bytea, integer, integer, integer
public | exodus_extract_time | time without time zone | bytea, integer, integer, integer
(8 rows)
</pre>

Quit postgres command prompt and quite postgres user

\q
exit

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;
CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

#quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/unencrypted password (instead of only logged-in username without password)

For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

nano data/pg_hba.conf

or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines. NB DONT comment out any other similar lines esp. ones containining "postgres"
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines
local all all password
host all all 127.0.0.1/32 password
hostssl all all 0.0.0.0/0 password

quit postgres user

exit

for redhat/centos
service postgresql reload
or for Ubuntu
sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME

Linux

2009-07-10T12:40:56Z

85.17.154.66: /* Building pgexodus */

== Building and Installing libexodus ==

requires Boost >= 1.35 and Postgres >= 8.1

Following steps are from Centos 5.2/Boost 1.38/Postgres 8.3/Gnu Compiler 4.1.2

alternatively:

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== libexodus Dependencies ===

==== Installing g++ compiler ====

yum list|grep gcc

yum install gcc-c++.i386

or for Ubuntu
sudo aptitude install build-essential

==== Installing Boost ====

Minimum required is boost 1_35. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex

yum install libicu-devel

or on Ubuntu

apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

su

make install

Skip to the next section if on Ubuntu, this part is unnecessary.

Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

nano /etc/ld.so.conf

Ensure the new config is operational.

ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

==== Installing Postgres ====

Version 8.3

yum install postgresql-devel

or on Ubuntu

sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Downloading and Building libexodus ===

libexodus.so is a shared library that allows you to write c++ programs with the style and semantics of pick basic. If you want traditional pick-like dictionary based sort/select/index it requires pgexodus to be built and installed too.

To give some insight into the automatic procedure see [[Manual Building with g++]]

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (may be out of date)

cd ~
wget http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Build and Install

./configure
make
make install

A couple of installation steps that unfortunately have to be done by hand at the moment.

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can down develop in c++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

== Building and Installing pgexodus ==

pgexodus.so is a shared library addin c function for postgres to perform sort/select/index functions otherwise it is not required.

=== pgexodus Dependencies ===

==== Installing Postgres ====

Version 8.3

yum install postgresql
yum install postgresql-devel

or on Ubuntu

sudo aptitude install postgresql-8.3
sudo aptitude install postgresql-dev
sudo aptitude install libpq-dev

Locate fmgr.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate fmgr.h

=== Building pgexodus ===

Currently hand built without even a make file. standard configure/make using autoconf/automake will be available soon http://www.lrde.epita.fr/~adl/dl/autotools.pdf

here are some old manual [[pgexodus handbuilding instructions]]

ensure you have access to the pg_config program or type a path to it

export PATH=/usr/local/postgresl:$PATH

cd ~/exodus/trunk/exodus/pgexodus
./configure
make
sudo make install

=== Installing pgexodus ===

Register the c functions in postgres

sudo su - postgres

psql
\connect exodus

{{postgres function installation}}

Check the functions loaded properly

\df exodus*

<pre>
List of functions
Schema | Name | Result data type | Argument data types
--------+-------------------------+-----------------------------+-----------------------------------------------------
public | exodus_call | bytea | bytea, bytea, bytea, bytea, bytea, integer, integer
public | exodus_extract_bytea | bytea | bytea, integer, integer, integer
public | exodus_extract_date | date | bytea, integer, integer, integer
public | exodus_extract_datetime | timestamp without time zone | bytea, integer, integer, integer
public | exodus_extract_sort | text | bytea, integer, integer, integer
public | exodus_extract_text | text | bytea, integer, integer, integer
public | exodus_extract_text2 | text | bytea, integer, integer, integer
public | exodus_extract_time | time without time zone | bytea, integer, integer, integer
(8 rows)
</pre>

Quit postgres command prompt and quite postgres user

\q
exit

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;
CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

#quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/unencrypted password (instead of only logged-in username without password)

For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

nano data/pg_hba.conf

or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines. NB DONT comment out any other similar lines esp. ones containining "postgres"
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines
local all all password
host all all 127.0.0.1/32 password
hostssl all all 0.0.0.0/0 password

quit postgres user

exit

for redhat/centos
service postgresql reload
or for Ubuntu
sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME

Linux

2009-07-10T12:35:53Z

85.17.154.66: /* Installing Postgres */

== Building and Installing libexodus ==

requires Boost >= 1.35 and Postgres >= 8.1

Following steps are from Centos 5.2/Boost 1.38/Postgres 8.3/Gnu Compiler 4.1.2

alternatively:

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== libexodus Dependencies ===

==== Installing g++ compiler ====

yum list|grep gcc

yum install gcc-c++.i386

or for Ubuntu
sudo aptitude install build-essential

==== Installing Boost ====

Minimum required is boost 1_35. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex

yum install libicu-devel

or on Ubuntu

apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

su

make install

Skip to the next section if on Ubuntu, this part is unnecessary.

Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

nano /etc/ld.so.conf

Ensure the new config is operational.

ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

==== Installing Postgres ====

Version 8.3

yum install postgresql-devel

or on Ubuntu

sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Downloading and Building libexodus ===

libexodus.so is a shared library that allows you to write c++ programs with the style and semantics of pick basic. If you want traditional pick-like dictionary based sort/select/index it requires pgexodus to be built and installed too.

To give some insight into the automatic procedure see [[Manual Building with g++]]

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (may be out of date)

cd ~
wget http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Build and Install

./configure
make
make install

A couple of installation steps that unfortunately have to be done by hand at the moment.

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can down develop in c++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

== Building and Installing pgexodus ==

pgexodus.so is a shared library addin c function for postgres to perform sort/select/index functions otherwise it is not required.

=== pgexodus Dependencies ===

==== Installing Postgres ====

Version 8.3

yum install postgresql
yum install postgresql-devel

or on Ubuntu

sudo aptitude install postgresql-8.3
sudo aptitude install postgresql-dev
sudo aptitude install libpq-dev

Locate fmgr.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate fmgr.h

=== Building pgexodus ===

Currently hand built without even a make file. standard configure/make using autoconf/automake will be available soon http://www.lrde.epita.fr/~adl/dl/autotools.pdf

here are some old manual [[pgexodus handbuilding instructions]]

=== Installing pgexodus ===

Register the c functions in postgres

sudo su - postgres

psql
\connect exodus

{{postgres function installation}}

Check the functions loaded properly

\df exodus*

<pre>
List of functions
Schema | Name | Result data type | Argument data types
--------+-------------------------+-----------------------------+-----------------------------------------------------
public | exodus_call | bytea | bytea, bytea, bytea, bytea, bytea, integer, integer
public | exodus_extract_bytea | bytea | bytea, integer, integer, integer
public | exodus_extract_date | date | bytea, integer, integer, integer
public | exodus_extract_datetime | timestamp without time zone | bytea, integer, integer, integer
public | exodus_extract_sort | text | bytea, integer, integer, integer
public | exodus_extract_text | text | bytea, integer, integer, integer
public | exodus_extract_text2 | text | bytea, integer, integer, integer
public | exodus_extract_time | time without time zone | bytea, integer, integer, integer
(8 rows)
</pre>

Quit postgres command prompt and quite postgres user

\q
exit

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;
CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

#quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/unencrypted password (instead of only logged-in username without password)

For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

nano data/pg_hba.conf

or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines. NB DONT comment out any other similar lines esp. ones containining "postgres"
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines
local all all password
host all all 127.0.0.1/32 password
hostssl all all 0.0.0.0/0 password

quit postgres user

exit

for redhat/centos
service postgresql reload
or for Ubuntu
sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME

Linux

2009-07-10T12:35:01Z

85.17.154.66: /* Installing Postgres */

== Building and Installing libexodus ==

requires Boost >= 1.35 and Postgres >= 8.1

Following steps are from Centos 5.2/Boost 1.38/Postgres 8.3/Gnu Compiler 4.1.2

alternatively:

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== libexodus Dependencies ===

==== Installing g++ compiler ====

yum list|grep gcc

yum install gcc-c++.i386

or for Ubuntu
sudo aptitude install build-essential

==== Installing Boost ====

Minimum required is boost 1_35. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex

yum install libicu-devel

or on Ubuntu

apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

su

make install

Skip to the next section if on Ubuntu, this part is unnecessary.

Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

nano /etc/ld.so.conf

Ensure the new config is operational.

ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

==== Installing Postgres ====

Version 8.3

yum install postgresql-devel

or on Ubuntu

sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Downloading and Building libexodus ===

libexodus.so is a shared library that allows you to write c++ programs with the style and semantics of pick basic. If you want traditional pick-like dictionary based sort/select/index it requires pgexodus to be built and installed too.

To give some insight into the automatic procedure see [[Manual Building with g++]]

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (may be out of date)

cd ~
wget http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Build and Install

./configure
make
make install

A couple of installation steps that unfortunately have to be done by hand at the moment.

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can down develop in c++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

== Building and Installing pgexodus ==

pgexodus.so is a shared library addin c function for postgres to perform sort/select/index functions otherwise it is not required.

=== pgexodus Dependencies ===

==== Installing Postgres ====

Version 8.3

yum install postgresql
yum install postgresql-devel

or on Ubuntu

sudo aptitude install postgresql-8.3
sudo aptitude install postgresql-dev
sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate fmgr.h

=== Building pgexodus ===

Currently hand built without even a make file. standard configure/make using autoconf/automake will be available soon http://www.lrde.epita.fr/~adl/dl/autotools.pdf

here are some old manual [[pgexodus handbuilding instructions]]

=== Installing pgexodus ===

Register the c functions in postgres

sudo su - postgres

psql
\connect exodus

{{postgres function installation}}

Check the functions loaded properly

\df exodus*

<pre>
List of functions
Schema | Name | Result data type | Argument data types
--------+-------------------------+-----------------------------+-----------------------------------------------------
public | exodus_call | bytea | bytea, bytea, bytea, bytea, bytea, integer, integer
public | exodus_extract_bytea | bytea | bytea, integer, integer, integer
public | exodus_extract_date | date | bytea, integer, integer, integer
public | exodus_extract_datetime | timestamp without time zone | bytea, integer, integer, integer
public | exodus_extract_sort | text | bytea, integer, integer, integer
public | exodus_extract_text | text | bytea, integer, integer, integer
public | exodus_extract_text2 | text | bytea, integer, integer, integer
public | exodus_extract_time | time without time zone | bytea, integer, integer, integer
(8 rows)
</pre>

Quit postgres command prompt and quite postgres user

\q
exit

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;
CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

#quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/unencrypted password (instead of only logged-in username without password)

For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

nano data/pg_hba.conf

or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines. NB DONT comment out any other similar lines esp. ones containining "postgres"
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines
local all all password
host all all 127.0.0.1/32 password
hostssl all all 0.0.0.0/0 password

quit postgres user

exit

for redhat/centos
service postgresql reload
or for Ubuntu
sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME

Pgexodus handbuilding instructions

2009-07-10T12:34:02Z

85.17.154.66:

Note that all routines are marked for "C linkage" in order to work with the postgres library "pq". For convenience they are all compiled under C++ since callexodus requires boost which is c++. The .c routines could equally well be compiled with the plain c compiler. The link stage must be done in c++ style in order to link to the c++ runtime library "rt".

cd ~/exodus/trunk/exodus/pgexodus/src

g++ -fpic -c *.c *.cpp -I`pg_config --includedir` -I`pg_config --includedir-server`
g++ -shared -o pgexodus.so *.o -lrt -lpq

Check the build as follows:

ld pgexodus.so

Should give something like the following. These 8 references to the postgres library all seem to be resolved at runtime.

<pre>
pgexodus.so: undefined reference to `Float8GetDatum'
pgexodus.so: undefined reference to `pg_atoi'
pgexodus.so: undefined reference to `CurrentMemoryContext'
pgexodus.so: undefined reference to `pg_detoast_datum'
pgexodus.so: undefined reference to `pfree'
pgexodus.so: undefined reference to `elog_start'
pgexodus.so: undefined reference to `MemoryContextAlloc'
pgexodus.so: undefined reference to `elog_finish'
</pre>

Also check the following

ldd -u pgexodus.so

Should give something like:

<pre>
./pgexodus.so: error: symbol lookup error: undefined symbol: CurrentMemoryContext (continued)
undefined symbol: CurrentMemoryContext (./pgexodus.so)
Unused direct dependencies:

/lib/librt.so.1
/usr/lib/libpq.so.5
/lib/libm.so.6
/lib/libgcc_s.so.1
</pre>

Copy the library to the postgres library folder

sudo cp pgexodus.so `pg_config --pkglibdir`

and restart postgres if this isnt the first time you are installing pgexodus

sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

Linux

2009-07-10T12:33:26Z

85.17.154.66: /* Installing pgexodus */

== Building and Installing libexodus ==

requires Boost >= 1.35 and Postgres >= 8.1

Following steps are from Centos 5.2/Boost 1.38/Postgres 8.3/Gnu Compiler 4.1.2

alternatively:

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== libexodus Dependencies ===

==== Installing g++ compiler ====

yum list|grep gcc

yum install gcc-c++.i386

or for Ubuntu
sudo aptitude install build-essential

==== Installing Boost ====

Minimum required is boost 1_35. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex

yum install libicu-devel

or on Ubuntu

apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

su

make install

Skip to the next section if on Ubuntu, this part is unnecessary.

Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

nano /etc/ld.so.conf

Ensure the new config is operational.

ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

==== Installing Postgres ====

Version 8.3

yum install postgresql-devel

or on Ubuntu

sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Downloading and Building libexodus ===

libexodus.so is a shared library that allows you to write c++ programs with the style and semantics of pick basic. If you want traditional pick-like dictionary based sort/select/index it requires pgexodus to be built and installed too.

To give some insight into the automatic procedure see [[Manual Building with g++]]

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (may be out of date)

cd ~
wget http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Build and Install

./configure
make
make install

A couple of installation steps that unfortunately have to be done by hand at the moment.

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can down develop in c++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

== Building and Installing pgexodus ==

pgexodus.so is a shared library addin c function for postgres to perform sort/select/index functions otherwise it is not required.

=== pgexodus Dependencies ===

==== Installing Postgres ====

Version 8.3

yum install postgresql
yum install postgresql-devel

or on Ubuntu

sudo aptitude install postgresql-8.3
sudo aptitude install postgresql-dev
sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Building pgexodus ===

Currently hand built without even a make file. standard configure/make using autoconf/automake will be available soon http://www.lrde.epita.fr/~adl/dl/autotools.pdf

here are some old manual [[pgexodus handbuilding instructions]]

=== Installing pgexodus ===

Register the c functions in postgres

sudo su - postgres

psql
\connect exodus

{{postgres function installation}}

Check the functions loaded properly

\df exodus*

<pre>
List of functions
Schema | Name | Result data type | Argument data types
--------+-------------------------+-----------------------------+-----------------------------------------------------
public | exodus_call | bytea | bytea, bytea, bytea, bytea, bytea, integer, integer
public | exodus_extract_bytea | bytea | bytea, integer, integer, integer
public | exodus_extract_date | date | bytea, integer, integer, integer
public | exodus_extract_datetime | timestamp without time zone | bytea, integer, integer, integer
public | exodus_extract_sort | text | bytea, integer, integer, integer
public | exodus_extract_text | text | bytea, integer, integer, integer
public | exodus_extract_text2 | text | bytea, integer, integer, integer
public | exodus_extract_time | time without time zone | bytea, integer, integer, integer
(8 rows)
</pre>

Quit postgres command prompt and quite postgres user

\q
exit

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;
CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

#quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/unencrypted password (instead of only logged-in username without password)

For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

nano data/pg_hba.conf

or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines. NB DONT comment out any other similar lines esp. ones containining "postgres"
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines
local all all password
host all all 127.0.0.1/32 password
hostssl all all 0.0.0.0/0 password

quit postgres user

exit

for redhat/centos
service postgresql reload
or for Ubuntu
sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME

Pgexodus handbuilding instructions

2009-07-10T12:32:54Z

85.17.154.66: New page: Note that all routines are marked for "C linkage" in order to work with the postgres library "pq". For convenience they are all compiled under C++ since callexodus requires boost which is...

Linux

2009-07-10T12:32:16Z

85.17.154.66: /* Building pgexodus */

== Building and Installing libexodus ==

requires Boost >= 1.35 and Postgres >= 8.1

Following steps are from Centos 5.2/Boost 1.38/Postgres 8.3/Gnu Compiler 4.1.2

alternatively:

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== libexodus Dependencies ===

==== Installing g++ compiler ====

yum list|grep gcc

yum install gcc-c++.i386

or for Ubuntu
sudo aptitude install build-essential

==== Installing Boost ====

Minimum required is boost 1_35. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex

yum install libicu-devel

or on Ubuntu

apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

su

make install

Skip to the next section if on Ubuntu, this part is unnecessary.

Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

nano /etc/ld.so.conf

Ensure the new config is operational.

ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

==== Installing Postgres ====

Version 8.3

yum install postgresql-devel

or on Ubuntu

sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Downloading and Building libexodus ===

libexodus.so is a shared library that allows you to write c++ programs with the style and semantics of pick basic. If you want traditional pick-like dictionary based sort/select/index it requires pgexodus to be built and installed too.

To give some insight into the automatic procedure see [[Manual Building with g++]]

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (may be out of date)

cd ~
wget http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Build and Install

./configure
make
make install

A couple of installation steps that unfortunately have to be done by hand at the moment.

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can down develop in c++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

== Building and Installing pgexodus ==

pgexodus.so is a shared library addin c function for postgres to perform sort/select/index functions otherwise it is not required.

=== pgexodus Dependencies ===

==== Installing Postgres ====

Version 8.3

yum install postgresql
yum install postgresql-devel

or on Ubuntu

sudo aptitude install postgresql-8.3
sudo aptitude install postgresql-dev
sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Building pgexodus ===

Currently hand built without even a make file. standard configure/make using autoconf/automake will be available soon http://www.lrde.epita.fr/~adl/dl/autotools.pdf

here are some old manual [[pgexodus handbuilding instructions]]

=== Installing pgexodus ===

Copy the library to the postgres library folder

sudo cp pgexodus.so `pg_config --pkglibdir`

and restart postgres if this isnt the first time you are installing pgexodus

sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

Register the c functions in postgres

sudo su - postgres

psql
\connect exodus

{{postgres function installation}}

Check the functions loaded properly

\df exodus*

<pre>
List of functions
Schema | Name | Result data type | Argument data types
--------+-------------------------+-----------------------------+-----------------------------------------------------
public | exodus_call | bytea | bytea, bytea, bytea, bytea, bytea, integer, integer
public | exodus_extract_bytea | bytea | bytea, integer, integer, integer
public | exodus_extract_date | date | bytea, integer, integer, integer
public | exodus_extract_datetime | timestamp without time zone | bytea, integer, integer, integer
public | exodus_extract_sort | text | bytea, integer, integer, integer
public | exodus_extract_text | text | bytea, integer, integer, integer
public | exodus_extract_text2 | text | bytea, integer, integer, integer
public | exodus_extract_time | time without time zone | bytea, integer, integer, integer
(8 rows)
</pre>

Quit postgres command prompt and quite postgres user

\q
exit

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;
CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

#quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/unencrypted password (instead of only logged-in username without password)

For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

nano data/pg_hba.conf

or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines. NB DONT comment out any other similar lines esp. ones containining "postgres"
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines
local all all password
host all all 127.0.0.1/32 password
hostssl all all 0.0.0.0/0 password

quit postgres user

exit

for redhat/centos
service postgresql reload
or for Ubuntu
sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME

Building on Mac

2009-07-08T22:25:00Z

85.17.154.66: /* Building and Installing libexodus */

Installing Exodus on Mac is almost identical to installing on Linux but it is a little harder to acquire and configure the dependencies.

This install was performed on OSX 10.5.5 (Leopard)

=== Installing dependencies ===

==== Installing C++ compiler ====

Older macs might need to install XCODE tools from http://developer.apple.com after free registration. This is unfortunately a large 1Gb download.

Newer macs have XCODE tools installer in the Applications or Library folder and you just have to install it.

The XCODE package includes subversion

==== Installing Postgres ====

http://www.postgresql.org/download/macosx

http://www.enterprisedb.com/products/pgdownload.do#osx

http://www.enterprisedb.com/getfile.jsp?fileid=484

Once downloaded, just do a standard install and remember the admin user password.

==== Installing Boost ====

Minimum required is boost 1_33. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex. How to do this on Mac OSX is unknown at the moment.

Download and unpack Boost Source

In safari get http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2 and move it to your home directory.

Open a classic console shell (terminal)

cd ~
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,regex,thread

Optionally, speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

sudo make install

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

sudo ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

=== Building and Installing libexodus ===

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (using curl not wget) - may not be the latest version

cd ~
curl http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz>Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Ensure postgres can be found (change 8.3 to your version) and check pg_config can run

PATH=/Library/PostgreSQL/8.3/bin/:$PATH
pg_config

Find out where your boost libraries are installed and what they are named.

find /usr | grep libboost

Customise the following command to suit the boost library location and names that you found in the previous step. There might be a configure.mac file to modify/use.

./configure --with-boost-libdir=/usr/local/lib \
--with-boost-date-time=boost_date_time-xgcc40-mt \
--with-boost-filesystem=boost_filesystem-xgcc40-mt \
--with-boost-regex=boost_regex-xgcc40-mt \
--with-boost-thread=boost_thread-xgcc40-mt

make
sudo make install

An additional installation step that unfortunately has to be done by hand at the moment.

sudo ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can now develop in C++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

=== Setting up Postgres for Exodus ===

#Finder, Places, Applications, PostgreSQL 8.3, PGAdmin III
#Login as superuser eg postgres
#Select the postgres database
#Click SQL in the toolbar and enter the following sql command.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;

and click the Execute Query button. It should show "Query returned successfully"

CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

and click the Execute Query button. It should show "Query returned successfully"

Building on Mac

2009-07-08T21:10:59Z

85.17.154.66: /* Building and Installing libexodus */

Installing Exodus on Mac is almost identical to installing on Linux but it is a little harder to acquire and configure the dependencies.

This install was performed on OSX 10.5.5 (Leopard)

=== Installing dependencies ===

==== Installing C++ compiler ====

Older macs might need to install XCODE tools from http://developer.apple.com after free registration. This is unfortunately a large 1Gb download.

Newer macs have XCODE tools installer in the Applications or Library folder and you just have to install it.

The XCODE package includes subversion

==== Installing Postgres ====

http://www.postgresql.org/download/macosx

http://www.enterprisedb.com/products/pgdownload.do#osx

http://www.enterprisedb.com/getfile.jsp?fileid=484

Once downloaded, just do a standard install and remember the admin user password.

==== Installing Boost ====

Minimum required is boost 1_33. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex. How to do this on Mac OSX is unknown at the moment.

Download and unpack Boost Source

In safari get http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2 and move it to your home directory.

Open a classic console shell (terminal)

cd ~
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,regex,thread

Optionally, speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

sudo make install

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

sudo ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

=== Building and Installing libexodus ===

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (using curl not wget) - may not be the latest version

cd ~
curl http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz>Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Ensure postgres can be found (change 8.3 to your version) and check pg_config can run

PATH=/Library/PostgreSQL/8.3/bin/:$PATH
pg_config

Find out where your boost libraries are installed and what they are named.

find /usr | grep libboost

Customise the following command to suit the boost library location and names that you found in the previous step. There might be a configure.mac file to modify/use.

./configure --with-boost-libdir=/usr/local/lib \
--with-boost-date-time=boost_date_time-xgcc40-mt \
--with-boost-filesystem=boost_filesystem-xgcc40-mt \
--with-boost-regex=boost_regex-xgcc40-mt \
--with-boost-thread=boost_thread-xgcc40-mt

make
sudo make install

An additional installation step that unfortunately has to be done by hand at the moment.

ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can now develop in C++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

=== Setting up Postgres for Exodus ===

#Finder, Places, Applications, PostgreSQL 8.3, PGAdmin III
#Login as superuser eg postgres
#Select the postgres database
#Click SQL in the toolbar and enter the following sql command.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;

and click the Execute Query button. It should show "Query returned successfully"

CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

and click the Execute Query button. It should show "Query returned successfully"

Building on Mac

2009-07-08T18:44:49Z

85.17.154.66: /* Installing Boost */

Installing Exodus on Mac is almost identical to installing on Linux but it is a little harder to acquire and configure the dependencies.

This install was performed on OSX 10.5.5 (Leopard)

=== Installing dependencies ===

==== Installing C++ compiler ====

Older macs might need to install XCODE tools from http://developer.apple.com after free registration. This is unfortunately a large 1Gb download.

Newer macs have XCODE tools installer in the Applications or Library folder and you just have to install it.

The XCODE package includes subversion

==== Installing Postgres ====

http://www.postgresql.org/download/macosx

http://www.enterprisedb.com/products/pgdownload.do#osx

http://www.enterprisedb.com/getfile.jsp?fileid=484

Once downloaded, just do a standard install and remember the admin user password.

==== Installing Boost ====

Minimum required is boost 1_33. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex. How to do this on Mac OSX is unknown at the moment.

Download and unpack Boost Source

In safari get http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2 and move it to your home directory.

Open a classic console shell (terminal)

cd ~
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

sudo su -

make install

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

=== Building and Installing libexodus ===

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (using curl not wget) - may not be the latest version

cd ~
curl http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz>Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Ensure postgres can be found (change 8.3 to your version) and check pg_config can run

PATH=/Library/PostgreSQL/8.3/bin/:$PATH
pg_config

Find out where your boost libraries are installed and what they are named.

find /usr | grep libboost

Customise the following command to suit the boost library location and names that you found in the previous step.

./configure --with-boost-libdir=/usr/local/lib \
--with-boost-date-time=boost_date_time-xgcc40-mt \
--with-boost-filesystem=boost_filesystem-xgcc40-mt \
--with-boost-regex=boost_regex-xgcc40-mt \
--with-boost-system=boost_system-xgcc40-mt \
--with-boost-thread=boost_thread-xgcc40-mt

make
sudo make install

An additional installation step that unfortunately has to be done by hand at the moment.

ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can now develop in C++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

=== Setting up Postgres for Exodus ===

#Finder, Places, Applications, PostgreSQL 8.3, PGAdmin III
#Login as superuser eg postgres
#Select the postgres database
#Click SQL in the toolbar and enter the following sql command.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;

and click the Execute Query button. It should show "Query returned successfully"

CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

and click the Execute Query button. It should show "Query returned successfully"

Building on Mac

2009-07-08T18:03:43Z

85.17.154.66: /* Installing Boost */

Installing Exodus on Mac is almost identical to installing on Linux but it is a little harder to acquire and configure the dependencies.

This install was performed on OSX 10.5.5 (Leopard)

=== Installing dependencies ===

==== Installing C++ compiler ====

Older macs might need to install XCODE tools from http://developer.apple.com after free registration. This is unfortunately a large 1Gb download.

Newer macs have XCODE tools installer in the Applications or Library folder and you just have to install it.

The XCODE package includes subversion

==== Installing Postgres ====

http://www.postgresql.org/download/macosx

http://www.enterprisedb.com/products/pgdownload.do#osx

http://www.enterprisedb.com/getfile.jsp?fileid=484

Once downloaded, just do a standard install and remember the admin user password.

==== Installing Boost ====

Minimum required is boost 1_33. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex. How to do this on Mac OSX is unknown at the moment.

Download and unpack Boost Source

In safari get http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2 and move it to your home directory.

Open a classic console shell (terminal)

cd ~
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

sudo su -

make install

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

=== Building and Installing libexodus ===

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (using curl not wget) - may not be the latest version

cd ~
curl http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz>Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Ensure postgres can be found (change 8.3 to your version) and check pg_config can run

PATH=/Library/PostgreSQL/8.3/bin/:$PATH
pg_config

Find out where your boost libraries are installed and what they are named.

find /usr | grep libboost

Customise the following command to suit the boost library location and names that you found in the previous step.

./configure --with-boost-libdir=/usr/local/lib \
--with-boost-date-time=boost_date_time-xgcc40-mt \
--with-boost-filesystem=boost_filesystem-xgcc40-mt \
--with-boost-regex=boost_regex-xgcc40-mt \
--with-boost-system=boost_system-xgcc40-mt \
--with-boost-thread=boost_thread-xgcc40-mt

make
sudo make install

An additional installation step that unfortunately has to be done by hand at the moment.

ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can now develop in C++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

=== Setting up Postgres for Exodus ===

#Finder, Places, Applications, PostgreSQL 8.3, PGAdmin III
#Login as superuser eg postgres
#Select the postgres database
#Click SQL in the toolbar and enter the following sql command.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;

and click the Execute Query button. It should show "Query returned successfully"

CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

and click the Execute Query button. It should show "Query returned successfully"

Linux

2009-07-08T13:37:52Z

85.17.154.66: /* Installing pgexodus */

== Building and Installing libexodus ==

requires Boost >= 1.35 and Postgres >= 8.1

Following steps are from Centos 5.2/Boost 1.38/Postgres 8.3/Gnu Compiler 4.1.2

alternatively:

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== libexodus Dependencies ===

==== Installing g++ compiler ====

yum list|grep gcc

yum install gcc-c++.i386

or for Ubuntu
sudo aptitude install build-essential

==== Installing Boost ====

Minimum required is boost 1_35. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex

yum install libicu-devel

or on Ubuntu

apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

su

make install

Skip to the next section if on Ubuntu, this part is unnecessary.

Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

nano /etc/ld.so.conf

Ensure the new config is operational.

ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

==== Installing Postgres ====

Version 8.3

yum install postgresql-devel

or on Ubuntu

sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Downloading and Building libexodus ===

libexodus.so is a shared library that allows you to write c++ programs with the style and semantics of pick basic. If you want traditional pick-like dictionary based sort/select/index it requires pgexodus to be built and installed too.

To give some insight into the automatic procedure see [[Manual Building with g++]]

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (may be out of date)

cd ~
wget http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Build and Install

./configure
make
make install

A couple of installation steps that unfortunately have to be done by hand at the moment.

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can down develop in c++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

== Building and Installing pgexodus ==

pgexodus.so is a shared library addin c function for postgres to perform sort/select/index functions otherwise it is not required.

=== pgexodus Dependencies ===

==== Installing Postgres ====

Version 8.3

yum install postgresql
yum install postgresql-devel

or on Ubuntu

sudo aptitude install postgresql-8.3
sudo aptitude install postgresql-dev
sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Building pgexodus ===

Currently hand built without even a make file. standard configure/make using autoconf/automake will be available soon http://www.lrde.epita.fr/~adl/dl/autotools.pdf

Note that all routines are marked for "C linkage" in order to work with the postgres library "pq". For convenience they are all compiled under C++ since callexodus requires boost which is c++. The .c routines could equally well be compiled with the plain c compiler. The link stage must be done in c++ style in order to link to the c++ runtime library "rt".

cd ~/exodus/trunk/exodus/pgexodus/src

g++ -fpic -c *.c *.cpp -I`pg_config --includedir` -I`pg_config --includedir-server`
g++ -shared -o pgexodus.so *.o -lrt -lpq

Check the build as follows:

ld pgexodus.so

Should give something like the following. These 8 references to the postgres library all seem to be resolved at runtime.

<pre>
pgexodus.so: undefined reference to `Float8GetDatum'
pgexodus.so: undefined reference to `pg_atoi'
pgexodus.so: undefined reference to `CurrentMemoryContext'
pgexodus.so: undefined reference to `pg_detoast_datum'
pgexodus.so: undefined reference to `pfree'
pgexodus.so: undefined reference to `elog_start'
pgexodus.so: undefined reference to `MemoryContextAlloc'
pgexodus.so: undefined reference to `elog_finish'
</pre>

Also check the following

ldd -u pgexodus.so

Should give something like:

<pre>
./pgexodus.so: error: symbol lookup error: undefined symbol: CurrentMemoryContext (continued)
undefined symbol: CurrentMemoryContext (./pgexodus.so)
Unused direct dependencies:

/lib/librt.so.1
/usr/lib/libpq.so.5
/lib/libm.so.6
/lib/libgcc_s.so.1
</pre>

=== Installing pgexodus ===

Copy the library to the postgres library folder

sudo cp pgexodus.so `pg_config --pkglibdir`

and restart postgres if this isnt the first time you are installing pgexodus

sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

Register the c functions in postgres

sudo su - postgres

psql
\connect exodus

{{postgres function installation}}

Check the functions loaded properly

\df exodus*

<pre>
List of functions
Schema | Name | Result data type | Argument data types
--------+-------------------------+-----------------------------+-----------------------------------------------------
public | exodus_call | bytea | bytea, bytea, bytea, bytea, bytea, integer, integer
public | exodus_extract_bytea | bytea | bytea, integer, integer, integer
public | exodus_extract_date | date | bytea, integer, integer, integer
public | exodus_extract_datetime | timestamp without time zone | bytea, integer, integer, integer
public | exodus_extract_sort | text | bytea, integer, integer, integer
public | exodus_extract_text | text | bytea, integer, integer, integer
public | exodus_extract_text2 | text | bytea, integer, integer, integer
public | exodus_extract_time | time without time zone | bytea, integer, integer, integer
(8 rows)
</pre>

Quit postgres command prompt and quite postgres user

\q
exit

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;
CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

#quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/unencrypted password (instead of only logged-in username without password)

For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

nano data/pg_hba.conf

or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines. NB DONT comment out any other similar lines esp. ones containining "postgres"
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines
local all all password
host all all 127.0.0.1/32 password
hostssl all all 0.0.0.0/0 password

quit postgres user

exit

for redhat/centos
service postgresql reload
or for Ubuntu
sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME

Linux

2009-07-08T13:35:49Z

85.17.154.66: /* Setting up Postgres for Exodus */

== Building and Installing libexodus ==

requires Boost >= 1.35 and Postgres >= 8.1

Following steps are from Centos 5.2/Boost 1.38/Postgres 8.3/Gnu Compiler 4.1.2

alternatively:

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== libexodus Dependencies ===

==== Installing g++ compiler ====

yum list|grep gcc

yum install gcc-c++.i386

or for Ubuntu
sudo aptitude install build-essential

==== Installing Boost ====

Minimum required is boost 1_35. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex

yum install libicu-devel

or on Ubuntu

apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

su

make install

Skip to the next section if on Ubuntu, this part is unnecessary.

Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

nano /etc/ld.so.conf

Ensure the new config is operational.

ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

==== Installing Postgres ====

Version 8.3

yum install postgresql-devel

or on Ubuntu

sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Downloading and Building libexodus ===

libexodus.so is a shared library that allows you to write c++ programs with the style and semantics of pick basic. If you want traditional pick-like dictionary based sort/select/index it requires pgexodus to be built and installed too.

To give some insight into the automatic procedure see [[Manual Building with g++]]

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (may be out of date)

cd ~
wget http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Build and Install

./configure
make
make install

A couple of installation steps that unfortunately have to be done by hand at the moment.

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can down develop in c++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

== Building and Installing pgexodus ==

pgexodus.so is a shared library addin c function for postgres to perform sort/select/index functions otherwise it is not required.

=== pgexodus Dependencies ===

==== Installing Postgres ====

Version 8.3

yum install postgresql
yum install postgresql-devel

or on Ubuntu

sudo aptitude install postgresql-8.3
sudo aptitude install postgresql-dev
sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Building pgexodus ===

Currently hand built without even a make file. standard configure/make using autoconf/automake will be available soon http://www.lrde.epita.fr/~adl/dl/autotools.pdf

Note that all routines are marked for "C linkage" in order to work with the postgres library "pq". For convenience they are all compiled under C++ since callexodus requires boost which is c++. The .c routines could equally well be compiled with the plain c compiler. The link stage must be done in c++ style in order to link to the c++ runtime library "rt".

cd ~/exodus/trunk/exodus/pgexodus/src

g++ -fpic -c *.c *.cpp -I`pg_config --includedir` -I`pg_config --includedir-server`
g++ -shared -o pgexodus.so *.o -lrt -lpq

Check the build as follows:

ld pgexodus.so

Should give something like the following. These 8 references to the postgres library all seem to be resolved at runtime.

<pre>
pgexodus.so: undefined reference to `Float8GetDatum'
pgexodus.so: undefined reference to `pg_atoi'
pgexodus.so: undefined reference to `CurrentMemoryContext'
pgexodus.so: undefined reference to `pg_detoast_datum'
pgexodus.so: undefined reference to `pfree'
pgexodus.so: undefined reference to `elog_start'
pgexodus.so: undefined reference to `MemoryContextAlloc'
pgexodus.so: undefined reference to `elog_finish'
</pre>

Also check the following

ldd -u pgexodus.so

Should give something like:

<pre>
./pgexodus.so: error: symbol lookup error: undefined symbol: CurrentMemoryContext (continued)
undefined symbol: CurrentMemoryContext (./pgexodus.so)
Unused direct dependencies:

/lib/librt.so.1
/usr/lib/libpq.so.5
/lib/libm.so.6
/lib/libgcc_s.so.1
</pre>

=== Installing pgexodus ===

Copy the library to the postgres library folder

sudo cp pgexodus.so `pg_config --pkglibdir`

and restart postgres if this isnt the first time you are installing pgexodus

sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

Register the c functions in postgres

sudo su - postgres

psql
\connect exodus

{{postgres function installation}}

Check the functions loaded properly

\df exodus*

Quit postgres command prompt and quite postgres user

\q
exit

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;
CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

#quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/unencrypted password (instead of only logged-in username without password)

For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

nano data/pg_hba.conf

or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines. NB DONT comment out any other similar lines esp. ones containining "postgres"
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines
local all all password
host all all 127.0.0.1/32 password
hostssl all all 0.0.0.0/0 password

quit postgres user

exit

for redhat/centos
service postgresql reload
or for Ubuntu
sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME

Linux

2009-07-08T13:11:31Z

85.17.154.66: /* Setting up Postgres for Exodus */

== Building and Installing libexodus ==

requires Boost >= 1.35 and Postgres >= 8.1

Following steps are from Centos 5.2/Boost 1.38/Postgres 8.3/Gnu Compiler 4.1.2

alternatively:

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== libexodus Dependencies ===

==== Installing g++ compiler ====

yum list|grep gcc

yum install gcc-c++.i386

or for Ubuntu
sudo aptitude install build-essential

==== Installing Boost ====

Minimum required is boost 1_35. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex

yum install libicu-devel

or on Ubuntu

apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

su

make install

Skip to the next section if on Ubuntu, this part is unnecessary.

Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

nano /etc/ld.so.conf

Ensure the new config is operational.

ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

==== Installing Postgres ====

Version 8.3

yum install postgresql-devel

or on Ubuntu

sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Downloading and Building libexodus ===

libexodus.so is a shared library that allows you to write c++ programs with the style and semantics of pick basic. If you want traditional pick-like dictionary based sort/select/index it requires pgexodus to be built and installed too.

To give some insight into the automatic procedure see [[Manual Building with g++]]

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (may be out of date)

cd ~
wget http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Build and Install

./configure
make
make install

A couple of installation steps that unfortunately have to be done by hand at the moment.

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can down develop in c++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

== Building and Installing pgexodus ==

pgexodus.so is a shared library addin c function for postgres to perform sort/select/index functions otherwise it is not required.

=== pgexodus Dependencies ===

==== Installing Postgres ====

Version 8.3

yum install postgresql
yum install postgresql-devel

or on Ubuntu

sudo aptitude install postgresql-8.3
sudo aptitude install postgresql-dev
sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Building pgexodus ===

Currently hand built without even a make file. standard configure/make using autoconf/automake will be available soon http://www.lrde.epita.fr/~adl/dl/autotools.pdf

Note that all routines are marked for "C linkage" in order to work with the postgres library "pq". For convenience they are all compiled under C++ since callexodus requires boost which is c++. The .c routines could equally well be compiled with the plain c compiler. The link stage must be done in c++ style in order to link to the c++ runtime library "rt".

cd ~/exodus/trunk/exodus/pgexodus/src

g++ -fpic -c *.c *.cpp -I`pg_config --includedir` -I`pg_config --includedir-server`
g++ -shared -o pgexodus.so *.o -lrt -lpq

Check the build as follows:

ld pgexodus.so

Should give something like the following. These 8 references to the postgres library all seem to be resolved at runtime.

<pre>
pgexodus.so: undefined reference to `Float8GetDatum'
pgexodus.so: undefined reference to `pg_atoi'
pgexodus.so: undefined reference to `CurrentMemoryContext'
pgexodus.so: undefined reference to `pg_detoast_datum'
pgexodus.so: undefined reference to `pfree'
pgexodus.so: undefined reference to `elog_start'
pgexodus.so: undefined reference to `MemoryContextAlloc'
pgexodus.so: undefined reference to `elog_finish'
</pre>

Also check the following

ldd -u pgexodus.so

Should give something like:

<pre>
./pgexodus.so: error: symbol lookup error: undefined symbol: CurrentMemoryContext (continued)
undefined symbol: CurrentMemoryContext (./pgexodus.so)
Unused direct dependencies:

/lib/librt.so.1
/usr/lib/libpq.so.5
/lib/libm.so.6
/lib/libgcc_s.so.1
</pre>

=== Installing pgexodus ===

Copy the library to the postgres library folder

sudo cp pgexodus.so `pg_config --pkglibdir`

and restart postgres if this isnt the first time you are installing pgexodus

sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

Register the c functions in postgres

sudo su - postgres

psql
\connect exodus

{{postgres function installation}}

Check the functions loaded properly

\df exodus*

Quit postgres command prompt and quite postgres user

\q
exit

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;
CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

#quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/unencrypted password (instead of only logged-in username without password)

For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

nano data/pg_hba.conf

or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines
local all all password
host all all 127.0.0.1/32 password
hostssl all all 0.0.0.0/0 password

quit postgres user

exit

for redhat/centos
service postgresql reload
or for Ubuntu
sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME

Linux

2009-07-08T13:10:51Z

85.17.154.66: /* Installing pgexodus */

== Building and Installing libexodus ==

requires Boost >= 1.35 and Postgres >= 8.1

Following steps are from Centos 5.2/Boost 1.38/Postgres 8.3/Gnu Compiler 4.1.2

alternatively:

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== libexodus Dependencies ===

==== Installing g++ compiler ====

yum list|grep gcc

yum install gcc-c++.i386

or for Ubuntu
sudo aptitude install build-essential

==== Installing Boost ====

Minimum required is boost 1_35. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex

yum install libicu-devel

or on Ubuntu

apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

su

make install

Skip to the next section if on Ubuntu, this part is unnecessary.

Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

nano /etc/ld.so.conf

Ensure the new config is operational.

ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

==== Installing Postgres ====

Version 8.3

yum install postgresql-devel

or on Ubuntu

sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Downloading and Building libexodus ===

libexodus.so is a shared library that allows you to write c++ programs with the style and semantics of pick basic. If you want traditional pick-like dictionary based sort/select/index it requires pgexodus to be built and installed too.

To give some insight into the automatic procedure see [[Manual Building with g++]]

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (may be out of date)

cd ~
wget http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Build and Install

./configure
make
make install

A couple of installation steps that unfortunately have to be done by hand at the moment.

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can down develop in c++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

== Building and Installing pgexodus ==

pgexodus.so is a shared library addin c function for postgres to perform sort/select/index functions otherwise it is not required.

=== pgexodus Dependencies ===

==== Installing Postgres ====

Version 8.3

yum install postgresql
yum install postgresql-devel

or on Ubuntu

sudo aptitude install postgresql-8.3
sudo aptitude install postgresql-dev
sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Building pgexodus ===

Currently hand built without even a make file. standard configure/make using autoconf/automake will be available soon http://www.lrde.epita.fr/~adl/dl/autotools.pdf

Note that all routines are marked for "C linkage" in order to work with the postgres library "pq". For convenience they are all compiled under C++ since callexodus requires boost which is c++. The .c routines could equally well be compiled with the plain c compiler. The link stage must be done in c++ style in order to link to the c++ runtime library "rt".

cd ~/exodus/trunk/exodus/pgexodus/src

g++ -fpic -c *.c *.cpp -I`pg_config --includedir` -I`pg_config --includedir-server`
g++ -shared -o pgexodus.so *.o -lrt -lpq

Check the build as follows:

ld pgexodus.so

Should give something like the following. These 8 references to the postgres library all seem to be resolved at runtime.

<pre>
pgexodus.so: undefined reference to `Float8GetDatum'
pgexodus.so: undefined reference to `pg_atoi'
pgexodus.so: undefined reference to `CurrentMemoryContext'
pgexodus.so: undefined reference to `pg_detoast_datum'
pgexodus.so: undefined reference to `pfree'
pgexodus.so: undefined reference to `elog_start'
pgexodus.so: undefined reference to `MemoryContextAlloc'
pgexodus.so: undefined reference to `elog_finish'
</pre>

Also check the following

ldd -u pgexodus.so

Should give something like:

<pre>
./pgexodus.so: error: symbol lookup error: undefined symbol: CurrentMemoryContext (continued)
undefined symbol: CurrentMemoryContext (./pgexodus.so)
Unused direct dependencies:

/lib/librt.so.1
/usr/lib/libpq.so.5
/lib/libm.so.6
/lib/libgcc_s.so.1
</pre>

=== Installing pgexodus ===

Copy the library to the postgres library folder

sudo cp pgexodus.so `pg_config --pkglibdir`

and restart postgres if this isnt the first time you are installing pgexodus

sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

Register the c functions in postgres

sudo su - postgres

psql
\connect exodus

{{postgres function installation}}

Check the functions loaded properly

\df exodus*

Quit postgres command prompt and quite postgres user

\q
exit

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;

CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

#quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/unencrypted password (instead of only logged-in username without password)

For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

nano data/pg_hba.conf

or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines
local all all password
host all all 127.0.0.1/32 password
hostssl all all 0.0.0.0/0 password

quit postgres user

exit

for redhat/centos
service postgresql reload
or for Ubuntu
sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME

Linux

2009-07-08T13:10:10Z

85.17.154.66: /* Installing pgexodus */

== Building and Installing libexodus ==

requires Boost >= 1.35 and Postgres >= 8.1

Following steps are from Centos 5.2/Boost 1.38/Postgres 8.3/Gnu Compiler 4.1.2

alternatively:

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== libexodus Dependencies ===

==== Installing g++ compiler ====

yum list|grep gcc

yum install gcc-c++.i386

or for Ubuntu
sudo aptitude install build-essential

==== Installing Boost ====

Minimum required is boost 1_35. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex

yum install libicu-devel

or on Ubuntu

apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

su

make install

Skip to the next section if on Ubuntu, this part is unnecessary.

Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

nano /etc/ld.so.conf

Ensure the new config is operational.

ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

==== Installing Postgres ====

Version 8.3

yum install postgresql-devel

or on Ubuntu

sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Downloading and Building libexodus ===

libexodus.so is a shared library that allows you to write c++ programs with the style and semantics of pick basic. If you want traditional pick-like dictionary based sort/select/index it requires pgexodus to be built and installed too.

To give some insight into the automatic procedure see [[Manual Building with g++]]

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (may be out of date)

cd ~
wget http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Build and Install

./configure
make
make install

A couple of installation steps that unfortunately have to be done by hand at the moment.

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can down develop in c++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

== Building and Installing pgexodus ==

pgexodus.so is a shared library addin c function for postgres to perform sort/select/index functions otherwise it is not required.

=== pgexodus Dependencies ===

==== Installing Postgres ====

Version 8.3

yum install postgresql
yum install postgresql-devel

or on Ubuntu

sudo aptitude install postgresql-8.3
sudo aptitude install postgresql-dev
sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Building pgexodus ===

Currently hand built without even a make file. standard configure/make using autoconf/automake will be available soon http://www.lrde.epita.fr/~adl/dl/autotools.pdf

Note that all routines are marked for "C linkage" in order to work with the postgres library "pq". For convenience they are all compiled under C++ since callexodus requires boost which is c++. The .c routines could equally well be compiled with the plain c compiler. The link stage must be done in c++ style in order to link to the c++ runtime library "rt".

cd ~/exodus/trunk/exodus/pgexodus/src

g++ -fpic -c *.c *.cpp -I`pg_config --includedir` -I`pg_config --includedir-server`
g++ -shared -o pgexodus.so *.o -lrt -lpq

Check the build as follows:

ld pgexodus.so

Should give something like the following. These 8 references to the postgres library all seem to be resolved at runtime.

<pre>
pgexodus.so: undefined reference to `Float8GetDatum'
pgexodus.so: undefined reference to `pg_atoi'
pgexodus.so: undefined reference to `CurrentMemoryContext'
pgexodus.so: undefined reference to `pg_detoast_datum'
pgexodus.so: undefined reference to `pfree'
pgexodus.so: undefined reference to `elog_start'
pgexodus.so: undefined reference to `MemoryContextAlloc'
pgexodus.so: undefined reference to `elog_finish'
</pre>

Also check the following

ldd -u pgexodus.so

Should give something like:

<pre>
./pgexodus.so: error: symbol lookup error: undefined symbol: CurrentMemoryContext (continued)
undefined symbol: CurrentMemoryContext (./pgexodus.so)
Unused direct dependencies:

/lib/librt.so.1
/usr/lib/libpq.so.5
/lib/libm.so.6
/lib/libgcc_s.so.1
</pre>

=== Installing pgexodus ===

Copy the library to the postgres library folder

sudo cp pgexodus.so `pg_config --pkglibdir`

and restart postgres if this isnt the first time you are installing pgexodus

sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

Register the c functions in postgres

sudo su - postgres
psql
\connect exodus

{{postgres function installation}}

Check the functions loaded properly

\df exodus*

Quit postgres command prompt and quite postgres user

\q
exit

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;

CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

#quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/unencrypted password (instead of only logged-in username without password)

For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

nano data/pg_hba.conf

or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines
local all all password
host all all 127.0.0.1/32 password
hostssl all all 0.0.0.0/0 password

quit postgres user

exit

for redhat/centos
service postgresql reload
or for Ubuntu
sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME

Linux

2009-07-08T13:08:45Z

85.17.154.66: /* Building pgexodus */

== Building and Installing libexodus ==

requires Boost >= 1.35 and Postgres >= 8.1

Following steps are from Centos 5.2/Boost 1.38/Postgres 8.3/Gnu Compiler 4.1.2

alternatively:

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== libexodus Dependencies ===

==== Installing g++ compiler ====

yum list|grep gcc

yum install gcc-c++.i386

or for Ubuntu
sudo aptitude install build-essential

==== Installing Boost ====

Minimum required is boost 1_35. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex

yum install libicu-devel

or on Ubuntu

apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

su

make install

Skip to the next section if on Ubuntu, this part is unnecessary.

Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

nano /etc/ld.so.conf

Ensure the new config is operational.

ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

==== Installing Postgres ====

Version 8.3

yum install postgresql-devel

or on Ubuntu

sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Downloading and Building libexodus ===

libexodus.so is a shared library that allows you to write c++ programs with the style and semantics of pick basic. If you want traditional pick-like dictionary based sort/select/index it requires pgexodus to be built and installed too.

To give some insight into the automatic procedure see [[Manual Building with g++]]

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (may be out of date)

cd ~
wget http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Build and Install

./configure
make
make install

A couple of installation steps that unfortunately have to be done by hand at the moment.

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can down develop in c++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

== Building and Installing pgexodus ==

pgexodus.so is a shared library addin c function for postgres to perform sort/select/index functions otherwise it is not required.

=== pgexodus Dependencies ===

==== Installing Postgres ====

Version 8.3

yum install postgresql
yum install postgresql-devel

or on Ubuntu

sudo aptitude install postgresql-8.3
sudo aptitude install postgresql-dev
sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Building pgexodus ===

Currently hand built without even a make file. standard configure/make using autoconf/automake will be available soon http://www.lrde.epita.fr/~adl/dl/autotools.pdf

Note that all routines are marked for "C linkage" in order to work with the postgres library "pq". For convenience they are all compiled under C++ since callexodus requires boost which is c++. The .c routines could equally well be compiled with the plain c compiler. The link stage must be done in c++ style in order to link to the c++ runtime library "rt".

cd ~/exodus/trunk/exodus/pgexodus/src

g++ -fpic -c *.c *.cpp -I`pg_config --includedir` -I`pg_config --includedir-server`
g++ -shared -o pgexodus.so *.o -lrt -lpq

Check the build as follows:

ld pgexodus.so

Should give something like the following. These 8 references to the postgres library all seem to be resolved at runtime.

<pre>
pgexodus.so: undefined reference to `Float8GetDatum'
pgexodus.so: undefined reference to `pg_atoi'
pgexodus.so: undefined reference to `CurrentMemoryContext'
pgexodus.so: undefined reference to `pg_detoast_datum'
pgexodus.so: undefined reference to `pfree'
pgexodus.so: undefined reference to `elog_start'
pgexodus.so: undefined reference to `MemoryContextAlloc'
pgexodus.so: undefined reference to `elog_finish'
</pre>

Also check the following

ldd -u pgexodus.so

Should give something like:

<pre>
./pgexodus.so: error: symbol lookup error: undefined symbol: CurrentMemoryContext (continued)
undefined symbol: CurrentMemoryContext (./pgexodus.so)
Unused direct dependencies:

/lib/librt.so.1
/usr/lib/libpq.so.5
/lib/libm.so.6
/lib/libgcc_s.so.1
</pre>

=== Installing pgexodus ===

Copy the library to the postgres library folder

sudo cp pgexodus.so `pg_config --pkglibdir`

and restart postgres if this isnt the first time you are installing pgexodus

sudo /etc/init.d/postgresql restart

Register the c functions in postgres

sudo su - postgres
psql
\connect exodus

{{postgres function installation}}

Check the functions loaded properly

\df exodus*

Quit postgres command prompt and quite postgres user

\q
exit

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;

CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

#quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/unencrypted password (instead of only logged-in username without password)

For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

nano data/pg_hba.conf

or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines
local all all password
host all all 127.0.0.1/32 password
hostssl all all 0.0.0.0/0 password

quit postgres user

exit

for redhat/centos
service postgresql reload
or for Ubuntu
sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME

Log of an installation of libexodus on Ubuntu 8.04.1 LTS

2009-07-08T13:01:48Z

85.17.154.66: /* Preparation */

=== Preparation ===

sudo su -

apt-get update
apt-get upgrade
apt-get install postgresql postgresql-server-dev* libpq-dev libboost-dev libboost-date-time-dev libboost-filesystem-dev libboost-regex-dev libboost-thread-dev build-essential subversion

=== Exodus ===

(pgexodus (which allows "sort/select/index by") isnt included in this quick install)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

./configure
make
make install

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

=== Testing ===

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
println(oconv(date(),"D"));
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus

/a.out

25 JUN 2009
25 JUN 2009

Linux

2009-07-08T11:31:51Z

85.17.154.66: /* Building pgexodus */

== Building and Installing libexodus ==

requires Boost >= 1.35 and Postgres >= 8.1

Following steps are from Centos 5.2/Boost 1.38/Postgres 8.3/Gnu Compiler 4.1.2

alternatively:

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== libexodus Dependencies ===

==== Installing g++ compiler ====

yum list|grep gcc

yum install gcc-c++.i386

or for Ubuntu
sudo aptitude install build-essential

==== Installing Boost ====

Minimum required is boost 1_35. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex

yum install libicu-devel

or on Ubuntu

apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

su

make install

Skip to the next section if on Ubuntu, this part is unnecessary.

Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

nano /etc/ld.so.conf

Ensure the new config is operational.

ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

==== Installing Postgres ====

Version 8.3

yum install postgresql-devel

or on Ubuntu

sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Downloading and Building libexodus ===

libexodus.so is a shared library that allows you to write c++ programs with the style and semantics of pick basic. If you want traditional pick-like dictionary based sort/select/index it requires pgexodus to be built and installed too.

To give some insight into the automatic procedure see [[Manual Building with g++]]

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (may be out of date)

cd ~
wget http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Build and Install

./configure
make
make install

A couple of installation steps that unfortunately have to be done by hand at the moment.

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can down develop in c++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

== Building and Installing pgexodus ==

pgexodus.so is a shared library addin c function for postgres to perform sort/select/index functions otherwise it is not required.

=== pgexodus Dependencies ===

==== Installing Postgres ====

Version 8.3

yum install postgresql
yum install postgresql-devel

or on Ubuntu

sudo aptitude install postgresql-8.3
sudo aptitude install postgresql-dev
sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Building pgexodus ===

Currently hand built without even a make file. standard configure/make using autoconf/automake will be available soon http://www.lrde.epita.fr/~adl/dl/autotools.pdf

Note that all routines are marked for "C linkage" in order to work with the postgres library "pq". For convenience they are all compiled under C++ since callexodus requires boost which is c++. The .c routines could equally well be compiled with the plain c compiler. The link stage must be done in c++ style in order to link to the c++ runtime library "rt".

cd ~/exodus/trunk/exodus/pgexodus/src

g++ -fpic -c *.c *.cpp -I `pg_config --includedir --includedir-server`
g++ -shared -o pgexodus.so *.o -lrt -lpq

Check the build as follows:

ld pgexodus.so

Should give something like the following. These 8 references to the postgres library all seem to be resolved at runtime.

<pre>
pgexodus.so: undefined reference to `Float8GetDatum'
pgexodus.so: undefined reference to `pg_atoi'
pgexodus.so: undefined reference to `CurrentMemoryContext'
pgexodus.so: undefined reference to `pg_detoast_datum'
pgexodus.so: undefined reference to `pfree'
pgexodus.so: undefined reference to `elog_start'
pgexodus.so: undefined reference to `MemoryContextAlloc'
pgexodus.so: undefined reference to `elog_finish'
</pre>

Also check the following

ldd -u pgexodus.so

Should give something like:

<pre>
./pgexodus.so: error: symbol lookup error: undefined symbol: CurrentMemoryContext (continued)
undefined symbol: CurrentMemoryContext (./pgexodus.so)
Unused direct dependencies:

/lib/librt.so.1
/usr/lib/libpq.so.5
/lib/libm.so.6
/lib/libgcc_s.so.1
</pre>

=== Installing pgexodus ===

Copy the library to the postgres library folder

sudo cp pgexodus.so `pg_config --pkglibdir`

and restart postgres if this isnt the first time you are installing pgexodus

sudo /etc/init.d/postgresql restart

Register the c functions in postgres

sudo su - postgres
psql
\connect exodus

{{postgres function installation}}

Check the functions loaded properly

\df exodus*

Quit postgres command prompt and quite postgres user

\q
exit

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;

CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

#quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/unencrypted password (instead of only logged-in username without password)

For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

nano data/pg_hba.conf

or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines
local all all password
host all all 127.0.0.1/32 password
hostssl all all 0.0.0.0/0 password

quit postgres user

exit

for redhat/centos
service postgresql reload
or for Ubuntu
sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME

Linux

2009-07-08T11:25:57Z

85.17.154.66: /* Building pgexodus */

== Building and Installing libexodus ==

requires Boost >= 1.35 and Postgres >= 8.1

Following steps are from Centos 5.2/Boost 1.38/Postgres 8.3/Gnu Compiler 4.1.2

alternatively:

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== libexodus Dependencies ===

==== Installing g++ compiler ====

yum list|grep gcc

yum install gcc-c++.i386

or for Ubuntu
sudo aptitude install build-essential

==== Installing Boost ====

Minimum required is boost 1_35. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex

yum install libicu-devel

or on Ubuntu

apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

su

make install

Skip to the next section if on Ubuntu, this part is unnecessary.

Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

nano /etc/ld.so.conf

Ensure the new config is operational.

ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

==== Installing Postgres ====

Version 8.3

yum install postgresql-devel

or on Ubuntu

sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Downloading and Building libexodus ===

libexodus.so is a shared library that allows you to write c++ programs with the style and semantics of pick basic. If you want traditional pick-like dictionary based sort/select/index it requires pgexodus to be built and installed too.

To give some insight into the automatic procedure see [[Manual Building with g++]]

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (may be out of date)

cd ~
wget http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Build and Install

./configure
make
make install

A couple of installation steps that unfortunately have to be done by hand at the moment.

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can down develop in c++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

== Building and Installing pgexodus ==

pgexodus.so is a shared library addin c function for postgres to perform sort/select/index functions otherwise it is not required.

=== pgexodus Dependencies ===

==== Installing Postgres ====

Version 8.3

yum install postgresql
yum install postgresql-devel

or on Ubuntu

sudo aptitude install postgresql-8.3
sudo aptitude install postgresql-dev
sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Building pgexodus ===

Currently hand built without even a make file. standard configure/make using autoconf/automake will be available soon http://www.lrde.epita.fr/~adl/dl/autotools.pdf

Note that all routines are marked for "C linkage" in order to work with the postgres library "pq". For convenience they are all compiled under C++ since callexodus requires boost which is c++. The .c routines could equally well be compiled with the plain c compiler. The link stage must be done in c++ style in order to link to the c++ runtime library "rt".

cd ~/exodus/trunk/exodus/pgexodus/src

g++ -fpic -c *.c *.cpp -I `pg_config --includedir-server`
g++ -shared -o pgexodus.so *.o -lrt -lpq

Check the build as follows:

ld pgexodus.so

Should give something like the following. These 8 references to the postgres library all seem to be resolved at runtime.

<pre>
pgexodus.so: undefined reference to `Float8GetDatum'
pgexodus.so: undefined reference to `pg_atoi'
pgexodus.so: undefined reference to `CurrentMemoryContext'
pgexodus.so: undefined reference to `pg_detoast_datum'
pgexodus.so: undefined reference to `pfree'
pgexodus.so: undefined reference to `elog_start'
pgexodus.so: undefined reference to `MemoryContextAlloc'
pgexodus.so: undefined reference to `elog_finish'
</pre>

Also check the following

ldd -u pgexodus.so

Should give something like:

<pre>
./pgexodus.so: error: symbol lookup error: undefined symbol: CurrentMemoryContext (continued)
undefined symbol: CurrentMemoryContext (./pgexodus.so)
Unused direct dependencies:

/lib/librt.so.1
/usr/lib/libpq.so.5
/lib/libm.so.6
/lib/libgcc_s.so.1
</pre>

=== Installing pgexodus ===

Copy the library to the postgres library folder

sudo cp pgexodus.so `pg_config --pkglibdir`

and restart postgres if this isnt the first time you are installing pgexodus

sudo /etc/init.d/postgresql restart

Register the c functions in postgres

sudo su - postgres
psql
\connect exodus

{{postgres function installation}}

Check the functions loaded properly

\df exodus*

Quit postgres command prompt and quite postgres user

\q
exit

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;

CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

#quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/unencrypted password (instead of only logged-in username without password)

For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

nano data/pg_hba.conf

or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines
local all all password
host all all 127.0.0.1/32 password
hostssl all all 0.0.0.0/0 password

quit postgres user

exit

for redhat/centos
service postgresql reload
or for Ubuntu
sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME

Linux

2009-07-08T11:09:44Z

85.17.154.66: /* Setting up Postgres for Exodus */

== Building and Installing libexodus ==

requires Boost >= 1.35 and Postgres >= 8.1

Following steps are from Centos 5.2/Boost 1.38/Postgres 8.3/Gnu Compiler 4.1.2

alternatively:

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== libexodus Dependencies ===

==== Installing g++ compiler ====

yum list|grep gcc

yum install gcc-c++.i386

or for Ubuntu
sudo aptitude install build-essential

==== Installing Boost ====

Minimum required is boost 1_35. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex

yum install libicu-devel

or on Ubuntu

apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

su

make install

Skip to the next section if on Ubuntu, this part is unnecessary.

Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

nano /etc/ld.so.conf

Ensure the new config is operational.

ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

==== Installing Postgres ====

Version 8.3

yum install postgresql-devel

or on Ubuntu

sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Downloading and Building libexodus ===

libexodus.so is a shared library that allows you to write c++ programs with the style and semantics of pick basic. If you want traditional pick-like dictionary based sort/select/index it requires pgexodus to be built and installed too.

To give some insight into the automatic procedure see [[Manual Building with g++]]

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (may be out of date)

cd ~
wget http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Build and Install

./configure
make
make install

A couple of installation steps that unfortunately have to be done by hand at the moment.

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can down develop in c++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

== Building and Installing pgexodus ==

pgexodus.so is a shared library addin c function for postgres to perform sort/select/index functions otherwise it is not required.

=== pgexodus Dependencies ===

==== Installing Postgres ====

Version 8.3

yum install postgresql
yum install postgresql-devel

or on Ubuntu

sudo aptitude install postgresql-8.3
sudo aptitude install postgresql-dev
sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Building pgexodus ===

Currently hand built without even a make file. standard configure/make using autoconf/automake will be available soon http://www.lrde.epita.fr/~adl/dl/autotools.pdf

Note that all routines are marked for "C linkage" in order to work with the postgres library "pq". For convenience they are all compiled under C++ since callexodus requires boost which is c++. The .c routines could equally well be compiled with the plain c compiler. The link stage must be done in c++ style in order to link to the c++ runtime library "rt".

cd ~/exodus/trunk/exodus/pgexodus/src

g++ -fpic -c *.c *.cpp -I `pg_config --includedir-server` -I /usr/local/include/boost-1_38
g++ -shared -o pgexodus.so *.o -lrt -lpq

Check the build as follows:

ld pgexodus.so

Should give something like the following. These 8 references to the postgres library all seem to be resolved at runtime.

<pre>
pgexodus.so: undefined reference to `Float8GetDatum'
pgexodus.so: undefined reference to `pg_atoi'
pgexodus.so: undefined reference to `CurrentMemoryContext'
pgexodus.so: undefined reference to `pg_detoast_datum'
pgexodus.so: undefined reference to `pfree'
pgexodus.so: undefined reference to `elog_start'
pgexodus.so: undefined reference to `MemoryContextAlloc'
pgexodus.so: undefined reference to `elog_finish'
</pre>

Also check the following

ldd -u pgexodus.so

Should give something like:

<pre>
./pgexodus.so: error: symbol lookup error: undefined symbol: CurrentMemoryContext (continued)
undefined symbol: CurrentMemoryContext (./pgexodus.so)
Unused direct dependencies:

/lib/librt.so.1
/usr/lib/libpq.so.5
/lib/libm.so.6
/lib/libgcc_s.so.1
</pre>

=== Installing pgexodus ===

Copy the library to the postgres library folder

sudo cp pgexodus.so `pg_config --pkglibdir`

and restart postgres if this isnt the first time you are installing pgexodus

sudo /etc/init.d/postgresql restart

Register the c functions in postgres

sudo su - postgres
psql
\connect exodus

{{postgres function installation}}

Check the functions loaded properly

\df exodus*

Quit postgres command prompt and quite postgres user

\q
exit

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;

CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

#quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/unencrypted password (instead of only logged-in username without password)

For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

nano data/pg_hba.conf

or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines
local all all password
host all all 127.0.0.1/32 password
hostssl all all 0.0.0.0/0 password

quit postgres user

exit

for redhat/centos
service postgresql reload
or for Ubuntu
sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME

Linux

2009-07-08T11:07:48Z

85.17.154.66: /* Setting up Postgres for Exodus */

== Building and Installing libexodus ==

requires Boost >= 1.35 and Postgres >= 8.1

Following steps are from Centos 5.2/Boost 1.38/Postgres 8.3/Gnu Compiler 4.1.2

alternatively:

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== libexodus Dependencies ===

==== Installing g++ compiler ====

yum list|grep gcc

yum install gcc-c++.i386

or for Ubuntu
sudo aptitude install build-essential

==== Installing Boost ====

Minimum required is boost 1_35. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex

yum install libicu-devel

or on Ubuntu

apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

su

make install

Skip to the next section if on Ubuntu, this part is unnecessary.

Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

nano /etc/ld.so.conf

Ensure the new config is operational.

ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

==== Installing Postgres ====

Version 8.3

yum install postgresql-devel

or on Ubuntu

sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Downloading and Building libexodus ===

libexodus.so is a shared library that allows you to write c++ programs with the style and semantics of pick basic. If you want traditional pick-like dictionary based sort/select/index it requires pgexodus to be built and installed too.

To give some insight into the automatic procedure see [[Manual Building with g++]]

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (may be out of date)

cd ~
wget http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Build and Install

./configure
make
make install

A couple of installation steps that unfortunately have to be done by hand at the moment.

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can down develop in c++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

== Building and Installing pgexodus ==

pgexodus.so is a shared library addin c function for postgres to perform sort/select/index functions otherwise it is not required.

=== pgexodus Dependencies ===

==== Installing Postgres ====

Version 8.3

yum install postgresql
yum install postgresql-devel

or on Ubuntu

sudo aptitude install postgresql-8.3
sudo aptitude install postgresql-dev
sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Building pgexodus ===

Currently hand built without even a make file. standard configure/make using autoconf/automake will be available soon http://www.lrde.epita.fr/~adl/dl/autotools.pdf

Note that all routines are marked for "C linkage" in order to work with the postgres library "pq". For convenience they are all compiled under C++ since callexodus requires boost which is c++. The .c routines could equally well be compiled with the plain c compiler. The link stage must be done in c++ style in order to link to the c++ runtime library "rt".

cd ~/exodus/trunk/exodus/pgexodus/src

g++ -fpic -c *.c *.cpp -I `pg_config --includedir-server` -I /usr/local/include/boost-1_38
g++ -shared -o pgexodus.so *.o -lrt -lpq

Check the build as follows:

ld pgexodus.so

Should give something like the following. These 8 references to the postgres library all seem to be resolved at runtime.

<pre>
pgexodus.so: undefined reference to `Float8GetDatum'
pgexodus.so: undefined reference to `pg_atoi'
pgexodus.so: undefined reference to `CurrentMemoryContext'
pgexodus.so: undefined reference to `pg_detoast_datum'
pgexodus.so: undefined reference to `pfree'
pgexodus.so: undefined reference to `elog_start'
pgexodus.so: undefined reference to `MemoryContextAlloc'
pgexodus.so: undefined reference to `elog_finish'
</pre>

Also check the following

ldd -u pgexodus.so

Should give something like:

<pre>
./pgexodus.so: error: symbol lookup error: undefined symbol: CurrentMemoryContext (continued)
undefined symbol: CurrentMemoryContext (./pgexodus.so)
Unused direct dependencies:

/lib/librt.so.1
/usr/lib/libpq.so.5
/lib/libm.so.6
/lib/libgcc_s.so.1
</pre>

=== Installing pgexodus ===

Copy the library to the postgres library folder

sudo cp pgexodus.so `pg_config --pkglibdir`

and restart postgres if this isnt the first time you are installing pgexodus

sudo /etc/init.d/postgresql restart

Register the c functions in postgres

sudo su - postgres
psql
\connect exodus

{{postgres function installation}}

Check the functions loaded properly

\df exodus*

Quit postgres command prompt and quite postgres user

\q
exit

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;

CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

#quit postgres command prompt

\q

Unless you are only going to run Exodus as user "exodus" from the local machine, grant login from 127.0.0.1 using username/unencrypted password (instead of only logged-in username without password)

For more info see http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

nano data/pg_hba.conf

or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines
local all all password
host all all 127.0.0.1/32 password
hostssl all all 0.0.0.0/0 password

quit postgres user

exit

service postgresql reload
or for Ubuntu
sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME

Linux

2009-07-08T11:05:01Z

85.17.154.66: /* Setting up Postgres for Exodus */

== Building and Installing libexodus ==

requires Boost >= 1.35 and Postgres >= 8.1

Following steps are from Centos 5.2/Boost 1.38/Postgres 8.3/Gnu Compiler 4.1.2

alternatively:

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== libexodus Dependencies ===

==== Installing g++ compiler ====

yum list|grep gcc

yum install gcc-c++.i386

or for Ubuntu
sudo aptitude install build-essential

==== Installing Boost ====

Minimum required is boost 1_35. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex

yum install libicu-devel

or on Ubuntu

apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

su

make install

Skip to the next section if on Ubuntu, this part is unnecessary.

Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

nano /etc/ld.so.conf

Ensure the new config is operational.

ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

==== Installing Postgres ====

Version 8.3

yum install postgresql-devel

or on Ubuntu

sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Downloading and Building libexodus ===

libexodus.so is a shared library that allows you to write c++ programs with the style and semantics of pick basic. If you want traditional pick-like dictionary based sort/select/index it requires pgexodus to be built and installed too.

To give some insight into the automatic procedure see [[Manual Building with g++]]

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (may be out of date)

cd ~
wget http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Build and Install

./configure
make
make install

A couple of installation steps that unfortunately have to be done by hand at the moment.

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can down develop in c++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

== Building and Installing pgexodus ==

pgexodus.so is a shared library addin c function for postgres to perform sort/select/index functions otherwise it is not required.

=== pgexodus Dependencies ===

==== Installing Postgres ====

Version 8.3

yum install postgresql
yum install postgresql-devel

or on Ubuntu

sudo aptitude install postgresql-8.3
sudo aptitude install postgresql-dev
sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Building pgexodus ===

Currently hand built without even a make file. standard configure/make using autoconf/automake will be available soon http://www.lrde.epita.fr/~adl/dl/autotools.pdf

Note that all routines are marked for "C linkage" in order to work with the postgres library "pq". For convenience they are all compiled under C++ since callexodus requires boost which is c++. The .c routines could equally well be compiled with the plain c compiler. The link stage must be done in c++ style in order to link to the c++ runtime library "rt".

cd ~/exodus/trunk/exodus/pgexodus/src

g++ -fpic -c *.c *.cpp -I `pg_config --includedir-server` -I /usr/local/include/boost-1_38
g++ -shared -o pgexodus.so *.o -lrt -lpq

Check the build as follows:

ld pgexodus.so

Should give something like the following. These 8 references to the postgres library all seem to be resolved at runtime.

<pre>
pgexodus.so: undefined reference to `Float8GetDatum'
pgexodus.so: undefined reference to `pg_atoi'
pgexodus.so: undefined reference to `CurrentMemoryContext'
pgexodus.so: undefined reference to `pg_detoast_datum'
pgexodus.so: undefined reference to `pfree'
pgexodus.so: undefined reference to `elog_start'
pgexodus.so: undefined reference to `MemoryContextAlloc'
pgexodus.so: undefined reference to `elog_finish'
</pre>

Also check the following

ldd -u pgexodus.so

Should give something like:

<pre>
./pgexodus.so: error: symbol lookup error: undefined symbol: CurrentMemoryContext (continued)
undefined symbol: CurrentMemoryContext (./pgexodus.so)
Unused direct dependencies:

/lib/librt.so.1
/usr/lib/libpq.so.5
/lib/libm.so.6
/lib/libgcc_s.so.1
</pre>

=== Installing pgexodus ===

Copy the library to the postgres library folder

sudo cp pgexodus.so `pg_config --pkglibdir`

and restart postgres if this isnt the first time you are installing pgexodus

sudo /etc/init.d/postgresql restart

Register the c functions in postgres

sudo su - postgres
psql
\connect exodus

{{postgres function installation}}

Check the functions loaded properly

\df exodus*

Quit postgres command prompt and quite postgres user

\q
exit

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus. Use the given password for now.

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;

CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

#quit postgres command prompt

\q

Allow login from 127.0.0.1 using username/unencrypted password (instead of only logged-in username without password)
http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

nano data/pg_hba.conf

or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines
local all all password
host all all 127.0.0.1/32 password
hostssl all all 0.0.0.0/0 password

quit postgres user

exit

service postgresql reload
or for Ubuntu
sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME

Linux

2009-07-08T11:03:25Z

85.17.154.66: /* Setting up Postgres for Exodus */

== Building and Installing libexodus ==

requires Boost >= 1.35 and Postgres >= 8.1

Following steps are from Centos 5.2/Boost 1.38/Postgres 8.3/Gnu Compiler 4.1.2

alternatively:

[[Log of an installation of libexodus on Ubuntu 8.04.1 LTS]]

[[Log of an installation of libexodus on Ubuntu 9.04 Jaunty Jackalope]]

[[Log of an installation of libexodus on Centos 5.3]]

=== libexodus Dependencies ===

==== Installing g++ compiler ====

yum list|grep gcc

yum install gcc-c++.i386

or for Ubuntu
sudo aptitude install build-essential

==== Installing Boost ====

Minimum required is boost 1_35. Here we install 1.38.

---

Optionally get ICU to fully support unicode in boost regex

yum install libicu-devel

or on Ubuntu

apt-get install libicu-dev

Download and unpack Boost Source

wget http://downloads.sourceforge.net/boost/boost_1_38_0.tar.bz2
tar xvf boost_1_38_0.tar.bz2
cd boost_1_38_0

./configure --help
./configure --with-libraries=date_time,filesystem,iostreams,program_options,regex,system,thread

Speed up the build of Boost by only doing the libraries and versions required. ADD additional config to the BJAM_CONFIG line as follows:

nano Makefile

BJAM_CONFIG= xxxxxxxxxxxxx -j4 variant=release link=shared

Build Boost

make

Install Boost after becoming superuser

su

make install

Skip to the next section if on Ubuntu, this part is unnecessary.

Add "/usr/local/lib" to the list of lib directories to ensure that the boost libs can be found.

nano /etc/ld.so.conf

Ensure the new config is operational.

ldconfig

Ensure boost includes can be found. This step might be eliminated in a better Exodos installer.

ln -s /usr/local/include/boost-1_38/boost /usr/local/include/boost

Quit superuser

exit

==== Installing Postgres ====

Version 8.3

yum install postgresql-devel

or on Ubuntu

sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Downloading and Building libexodus ===

libexodus.so is a shared library that allows you to write c++ programs with the style and semantics of pick basic. If you want traditional pick-like dictionary based sort/select/index it requires pgexodus to be built and installed too.

To give some insight into the automatic procedure see [[Manual Building with g++]]

Either download Exodus using Subversion (recommended - latest version)

cd ~
mkdir exodus
cd exodus
svn co http://svn.neosys.com/svn/trunk
cd trunk/exodus/exodus

or download a tarball (may be out of date)

cd ~
wget http://devwiki.neosys.com/images/2/2a/Exodus-9.6.0.tar.gz
tar xvfz Exodus-9.6.0.tar.gz
cd exodus-9.6.0

Build and Install

./configure
make
make install

A couple of installation steps that unfortunately have to be done by hand at the moment.

ldconfig
ln -s /usr/local/include/exodus-9.6/exodus /usr/local/include/exodus

Test that you can down develop in c++ with Exodus. The libs and includes will no longer be required with a better installer.

nano tester.cpp

<pre>
#include <exodus/exodus.h>
int main() {
date().oconv("D").outputln();
}
</pre>

g++ tester.cpp -lexodus-9.6 -I/usr/local/include/exodus
./a.out
25 JUN 2009

== Building and Installing pgexodus ==

pgexodus.so is a shared library addin c function for postgres to perform sort/select/index functions otherwise it is not required.

=== pgexodus Dependencies ===

==== Installing Postgres ====

Version 8.3

yum install postgresql
yum install postgresql-devel

or on Ubuntu

sudo aptitude install postgresql-8.3
sudo aptitude install postgresql-dev
sudo aptitude install libpq-dev

Locate libpq-fe.h to check. Probably in /usr/include/postgresql/ or /usr/include/postgresql/8.3/server/ on Ubuntu

updatedb
locate libpq-fe.h

=== Building pgexodus ===

Currently hand built without even a make file. standard configure/make using autoconf/automake will be available soon http://www.lrde.epita.fr/~adl/dl/autotools.pdf

Note that all routines are marked for "C linkage" in order to work with the postgres library "pq". For convenience they are all compiled under C++ since callexodus requires boost which is c++. The .c routines could equally well be compiled with the plain c compiler. The link stage must be done in c++ style in order to link to the c++ runtime library "rt".

cd ~/exodus/trunk/exodus/pgexodus/src

g++ -fpic -c *.c *.cpp -I `pg_config --includedir-server` -I /usr/local/include/boost-1_38
g++ -shared -o pgexodus.so *.o -lrt -lpq

Check the build as follows:

ld pgexodus.so

Should give something like the following. These 8 references to the postgres library all seem to be resolved at runtime.

<pre>
pgexodus.so: undefined reference to `Float8GetDatum'
pgexodus.so: undefined reference to `pg_atoi'
pgexodus.so: undefined reference to `CurrentMemoryContext'
pgexodus.so: undefined reference to `pg_detoast_datum'
pgexodus.so: undefined reference to `pfree'
pgexodus.so: undefined reference to `elog_start'
pgexodus.so: undefined reference to `MemoryContextAlloc'
pgexodus.so: undefined reference to `elog_finish'
</pre>

Also check the following

ldd -u pgexodus.so

Should give something like:

<pre>
./pgexodus.so: error: symbol lookup error: undefined symbol: CurrentMemoryContext (continued)
undefined symbol: CurrentMemoryContext (./pgexodus.so)
Unused direct dependencies:

/lib/librt.so.1
/usr/lib/libpq.so.5
/lib/libm.so.6
/lib/libgcc_s.so.1
</pre>

=== Installing pgexodus ===

Copy the library to the postgres library folder

sudo cp pgexodus.so `pg_config --pkglibdir`

and restart postgres if this isnt the first time you are installing pgexodus

sudo /etc/init.d/postgresql restart

Register the c functions in postgres

sudo su - postgres
psql
\connect exodus

{{postgres function installation}}

Check the functions loaded properly

\df exodus*

Quit postgres command prompt and quite postgres user

\q
exit

For more information see http://www.postgresql.org/docs/8.1/static/app-psql.html

=== Setting up Postgres for Exodus ===

become user postgres and get into postgres command prompt

sudo su - postgres

psql

create a user and database for exodus

CREATE ROLE exodus LOGIN
PASSWORD 'somesillysecret'
CREATEDB CREATEROLE;

CREATE DATABASE exodus
WITH ENCODING='UTF8'
OWNER=exodus;

#quit postgres command prompt

\q

Allow login from 127.0.0.1 using username/unencrypted password (instead of only logged-in username without password)
http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

nano data/pg_hba.conf

or for Ubuntu
nano /etc/postgresql/8.3/main/pg_hba.conf

comment out the following lines
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser

and add these lines
local all all password
host all all 127.0.0.1/32 password
hostssl all all 0.0.0.0/0 password

quit postgres user

exit

service postgresql reload
or for Ubuntu
sudo /etc/init.d/postgresql restart
or
sudo /etc/init.d/postgresql-8.3 restart

== Building service ==

service is an incomplete multithreaded framework to support dynamic loading of library routines and serving a request/response queue.

www provides an optional web interface to the request/response queue. Windows only at the moment due to a single asp files but could be ported to php.

=== Building service ===

cd ~/exodus/trunk/service/service

g++ -fPIC -c *.cpp -I/usr/local/include/boost-1_38 -I../../exodus/mv/src
g++ -shared -o libservice.so -lc *.o
g++ -o service main.cpp -I/usr/local/include/boost-1_38 -L. -L/usr/local/lib -lexodus -lpq -lboost_filesystem-gcc41-mt\
-lboost_regex-gcc41-mt -lboost_thread-gcc41-mt -L../../exodus/mv/src -I../../exodus/mv/src -L./ -lservice

=== Running service ===

export LD_LIBRARY_PATH=../../exodus/mv/src:.:/usr/local/lib:$LD_LIBRARY_PATH

./service

== Developing libexodus/pgexosdus/service ==

=== Committing your developments ===

First get a username and password by running the following unix command and send the output to an exodus subversion administrator eg steve.bush@neosys.com

htpasswd -nm YOURDESIREDUSERNAME

The administrator needs to run the following command as root and enter the encrypted pass (the bit AFTER the :) ignoring the warning about plain text password because it is already encrypted.

htpasswd -p /etc/apache2/dav_svn.passwd YOURDESIREDUSERNAME