Install on Debian Jessie with PostrgeSQL database

[arnocertic]

Hi, I have already install with success OTX on debian jessie with a PostgreSQL database.

php-config

For information php-config package is still not exists on Debian Jessie so you have to download last known package (wheezy version) and install it by hand :

dpkg -i php-config_1.10.12-4_all.deb

.htaccess

You're also need to modify install/.htaccess if you want to use apache2.4

 <IfVersion < 2.4>
     Order allow,deny
     Deny from all
 </IfVersion>
 <IfVersion >= 2.4>
     Require all denied
 </IfVersion>

PostgreSQL

For PostgreSQL install, I wrote a compatible init.pgsql

--
-- Table structure for table Document
--

DROP TABLE IF EXISTS Document;

CREATE TABLE Document (
  idDocument serial PRIMARY KEY,
  pathDocument varchar(255) NOT NULL DEFAULT '',
  nbNotes int NOT NULL DEFAULT '0',
  realname varchar(255) NOT NULL DEFAULT '',
  tmpname varchar(255) NOT NULL DEFAULT ''
);

--
-- Table structure for table NotePossible
--

DROP TABLE IF EXISTS NotePossible;

CREATE TABLE NotePossible (
  idNote serial,
  numNote int NOT NULL DEFAULT '0',
  motNote varchar(255) NOT NULL DEFAULT '',
  extraitMotNote text NOT NULL,
  probaNote int NOT NULL DEFAULT '0',
  idDocument int NOT NULL DEFAULT '0',
  PRIMARY KEY (idNote,idDocument)
);

--
-- Table structure for table NoteTexte
--

DROP TABLE IF EXISTS NoteTexte;

CREATE TABLE NoteTexte (
  numNote int NOT NULL DEFAULT '0',
  texteNote text NOT NULL,
  idDocument int NOT NULL DEFAULT '0',
  PRIMARY KEY (numNote,idDocument)
);

--
-- Table structure for table users
--

DROP TABLE IF EXISTS users;

CREATE TABLE users (
  id serial PRIMARY KEY,
  username varchar(255) NOT NULL DEFAULT '',
  password varchar(255) NOT NULL DEFAULT ''
);

Best regards

Arno