Platform installation

Geo2Tag platform installation

PosgreSQL building and installation

 * Download last version from http://www.postgresql.org/ and see INSTALL file to build and install
 * Or sudo apt-get install postgresql
 * Install unixODBC
 * Install postgres-odbc

PostgreSQL configuration
$ sudo -u postgres psql postgres postgres =# \password postgres  # to set new password $ sudo -u postgres createuser geo2tag $ sudo -u postgres createdb -O geo2tag geo2tag $ psql geo2tag -U geo2tag if "psql: FATAL: Ident authentication failed for user 'geo2tag'" error occured (in Ubuntu 10.10), try to edit file */etc/postgresql/8.4/main/pg_hba.conf*. Change "local all all ident" to "local all all trust" and "host all all 127.0.0.1/32 md5" to "host all all 127.0.0.1/32 trust". geo2tag=> \i $(PATH_TO_GEO2TAG_SOURCE)/scripts/base.sql geo2tag=> \q $ sudo service postgresql-8.4 restart [geo2tag] Description  = "" Driver   = PostgreSQL Trace  = No TraceFile   = Database   = geo2tag Servername   = 127.0.0.1 UserName   = geo2tag Password   = geo@tag Port   = 5432 Protocol   = 6.4 ReadOnly   = No RowVersioning   = No ShowSystemTables    = No ShowOidColumn   = No FakeOidIndex    = No ConnSettings    = [PostgreSQL] Description	= PostgreSQL ODBC driver (ANSI version) Driver		= /usr/lib/odbc/psqlodbca.so Setup		= /usr/lib/odbc/libodbcpsqlS.so Debug		= 0 CommLog		= 1
 * Change password
 * Create geo2tag user and geo2tag database:
 * Add /etc/odbc.ini:
 * Add /etc/odbcinst.ini:

[PostgreSQL Unicode] Description	= PostgreSQL ODBC driver (Unicode version) Driver		= /usr/lib/odbc/psqlodbcw.so Setup		= /usr/lib/odbc/libodbcpsqlS.so Debug		= 0 CommLog		= 1

Lighttpd building, installation

 * Download last version from http://www.lighttpd.net/download/ and See INSTALL file to build and install
 * Or sudo apt-get install lighttpd
 * Enable "mod_fastcgi" in /etc/lighttpd/lighttpd.conf

Lighttpd configuration
fastcgi.server = (   "/service" => ( "fcgi_server.handler" => (       "socket" => "/tmp/fcgi_server.socket",        "check-local" => "disable",        "bin-path" => "/opt/geo2tag/fcgi_server",	"bin-environment" => ("LD_LIBRARY_PATH" => "/opt/geo2tag"),        "min-procs" => 1,        "max-procs" => 1,        "idle-timeout" => 30      ) ),   "/sketch" => ( "sketch" => (       "socket" => "/tmp/sketch.socket",        "bin-path" => "/opt/geo2tag/sketch.wt",        "max-procs" => 1,        "check-local" => "disable",        "bin-environment" => ("FOO" => "bar", "LD_LIBRARY_PATH" => "/usr/local/lib:/opt/geo2tag")     ) ),   "/hello" => ( "hello" => (       "socket" => "/tmp/hello.socket",        "bin-path" => "/opt/geo2tag/hello.wt",        "max-procs" => 1,        "check-local" => "disable",        "bin-environment" => ("FOO" => "bar", "LD_LIBRARY_PATH" => "/usr/local/lib")     ) ) )
 * Add file /etc/lighttpd/conf-enabled/geo2tag.conf (change www.geo2tag.com to your host name):

Building and configuration geo2tag service

 * You need to have Qt4, unixODBC and cajun API installed
 * set target in config.pri to "linux"
 * qmake && make
 * cp -l ./src/lib/lib* /opt/geo2tag/
 * cp ./src/service/fcgi_service /opt/geo2tag/

Building and configuration webside

 * You need to have Qt4 and Wt installed. For Wt look at http://osll.spb.ru/wiki/geo2tag/Wt_installation_
 * set target in config.pri to "webside"
 * qmake && make
 * cp -l ./src/lib/libcommon.so* /opt/geo2tag/
 * cp ./src/webside/sketch.wt /opt/geo2tag/
 * cp -r $(PATH_TO_GEO2TAG_SOURCE)/src/webside/www-data/* /var/www (server.document-root=/var/www)