[ewiki] Re: ewiki - postgreSQL

> That's all I can recall, I went back to MySQL, Postgres was just too
> frustrating.,

Works like a charm for me.
I have a system wide ewiki, the archive extracted to
/var/www/apps/ewiki/ (ewiki-CVS-20050210).

index.php for every site:
  $this_file = substr(__FILE__, strrpos(__FILE__, "/") + 1);
  define("EWIKI_SCRIPT", $this_file . "?page=");
  define("EWIKI_SCRIPT_BINARY", $this_file . "?binary=");
  define("EWIKI_CONTROL_LINE", 0);
  define("EWIKI_SCRIPT_URL", "http://host.domain/"; . $this_file . "?page=");

  define("EWIKI_DB_TABLE_NAME", "wiki"); // Datenbank Tabelle
  define("EWIKI_PAGE_INDEX",    "Home"); // Startseite
  define("EWIKI_USE_PATH_INFO", "1");    // fuer Apache
  define("EWIKI_PRINT_TITLE",   "0");    // Seitenname nicht ausgeben
  define("EWIKI_IMAGE_MAXSIZE", 1*1024*1024); // max Groesse fuer Bilder
Uploads=1MB
  define("EWIKI_DEFAULT_LANG", "de");

  // Auth
  define("EWIKI_PROTECTED_MODE", 2);
  $ewiki_ring = 3;  // Default nur browsen

  // die Postgres DB ist in Unicode, die Seite in ISO-8859-1
  define("EWIKI_DB_UTF8", true);

  // default ist ./init-pages
  define("EWIKI_INIT_PAGES", "/var/www/apps/ewiki/init-pages");

  // Plugin: Datenbank
  include("DB.php"); // PEAR
  include("/var/www/apps/ewiki/plugins/db/any.php");
  // host, user, passwort, dbname, dbtype
  $db = anydb_connect("127.0.0.1", "user", "pwd", "database", "pgsql");

  // eWiki Hauptdatei
  include("/var/www/apps/ewiki/ewiki.php");

  // die Seite schon erzeugen
  $page_content = ewiki_page();
?>

HTH,
Thomas

Other related posts: