Package: phpwiki Version: 1.3.14-2 Severity: normal
When installing using postgres, I got a '"pg_ts_cfg" does not exist' error: An error seems to have occurred while installing the database. If it's of any help, this was the error encountered: At first init the database with: $ createdb phpwiki $ createuser -S -R -d 'wikiuser' $ psql -U 'wikiuser' phpwiki < /usr/share/postgresql/contrib/tsearch2.sql $ psql -U 'wikiuser' phpwiki < psql-initialize.sql Initializing PhpWiki tables with: prefix = '' httpd_user = ... ERROR: relation "pg_ts_cfg" does not exist Complete installation log attached -- System Information: Debian Release: lenny/sid APT prefers testing APT policy: (500, 'testing') Architecture: i386 (i686) Kernel: Linux 2.6.21-2-486 Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages phpwiki depends on: ii apache2 2.2.8-4~lenny1 Next generation, scalable, extenda ii apache2-mpm-prefork [http 2.2.8-4~lenny1 Traditional model for Apache HTTPD ii dbconfig-common 1.8.38 common framework for packaging dat ii debconf [debconf-2.0] 1.5.21 Debian configuration management sy ii libapache2-mod-php5 5.2.5-3 server-side, HTML-embedded scripti ii php-db 1.7.13-2 PHP PEAR Database Abstraction Laye ii php5-mysql 5.2.5-3 MySQL module for php5 ii php5-sqlite 5.2.5-3 SQLite module for php5 ii ucf 3.006 Update Configuration File: preserv Versions of packages phpwiki recommends: ii mysql-client 5.0.51a-6 MySQL database client (meta packag ii mysql-client-5.0 [mysql-clien 5.0.51a-6 MySQL database client binaries ii postgresql-client-8.3 [postgr 8.3.1-2+b1 front-end programs for PostgreSQL ii sqlite 2.8.17-4 command line interface for SQLite -- debconf information: * phpwiki/system/documentroot: phpwiki/pgsql/authmethod-user: ident phpwiki/upgrade-error: abort phpwiki/pgsql/manualconf: phpwiki/mysql/method: unix socket phpwiki/upgrade-backup: true phpwiki/dbconfig-upgrade: true phpwiki/dbconfig-remove: phpwiki/remote/newhost: phpwiki/remote/port: phpwiki/db/basepath: phpwiki/remote/host: phpwiki/purge: false phpwiki/system/localnet: 10.0.0.0/24 phpwiki/pgsql/admin-user: postgres phpwiki/internal/skip-preseed: false * phpwiki/install-error: ignore phpwiki/db/app-user: phpwiki phpwiki/system/accessible: localhost only phpwiki/passwords-do-not-match: phpwiki/mysql/admin-user: root phpwiki/dbconfig-reinstall: false phpwiki/pgsql/method: unix socket * phpwiki/database-type: pgsql phpwiki/pgsql/changeconf: false phpwiki/db/dbname: phpwiki phpwiki/notes/configupgrade: phpwiki/pgsql/no-empty-passwords: phpwiki/missing-db-package-error: abort phpwiki/remove-error: abort phpwiki/notes/introduction: phpwiki/internal/reconfiguring: false * phpwiki/dbconfig-install: true phpwiki/pgsql/authmethod-admin: ident
[EMAIL PROTECTED]:/etc$ sudo apt-get install phpwiki Reading package lists... Done Building dependency tree Reading state information... Done Suggested packages: php5-imap php5-ldap The following NEW packages will be installed phpwiki 0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded. Need to get 0B/3206kB of archives. After this operation, 14.9MB of additional disk space will be used. Preconfiguring packages ... Configuring phpwiki ------------------- phpwiki must have a database installed and configured before it can be used. If you like, this can be handled with dbconfig-common. If you are an advanced database administrator and know that you want to perform this configuration manually, or if your database has already been installed and configured, you should refuse this option. Details on what needs to be done should most likely be provided in /usr/share/doc/phpwiki. Otherwise, you should probably choose this option. Configure database for phpwiki with dbconfig-common? yes phpwiki can be configured to use one of many database types. Below, you will be presented with the available choices. 1. mysql 2. pgsql 3. sqlite Database type to be used by phpwiki: 2 Please provide a password for phpwiki to register with the database server. If left blank, a random password will be generated for you. . If you are using "ident" based authentication, the supplied password will not be used and can be left blank. Otherwise, PostgreSQL access may need to be reconfigured to allow password-authenticated access. PostgreSQL application password for phpwiki: Where should the web-accessible location of the PHPWiki be? This is the directory of your website that people should use to access the PHPWiki. By default, this is http://yourserver/phpwiki, but you can change it to be anything within your server. Enter just the directory portion below. Web-accessible location of the PHPWiki: Selecting previously deselected package phpwiki. (Reading database ... 46271 files and directories currently installed.) Unpacking phpwiki (from .../phpwiki_1.3.14-2_all.deb) ... Setting up phpwiki (1.3.14-2) ... dbconfig-common: writing config to /etc/dbconfig-common/phpwiki.conf Creating config file /etc/dbconfig-common/phpwiki.conf with new version Creating config file /etc/phpwiki/dbconf.tmp with new version creating postgres user phpwiki: success. verifying creation of user: success. creating database phpwiki: success. verifying database phpwiki exists: success. populating database via sql... warning: ident method specified but local account doesn't exist. warning: ident method specified but local account doesn't exist. error encountered populating database: At first init the database with: $ createdb phpwiki $ createuser -S -R -d 'wikiuser' $ psql -U 'wikiuser' phpwiki < /usr/share/postgresql/contrib/tsearch2.sql $ psql -U 'wikiuser' phpwiki < psql-initialize.sql Initializing PhpWiki tables with: prefix = '' httpd_user = 'wikiuser' Expect some 'NOTICE: CREATE ... will create implicit sequence/index ...' messages Creating page NOTICE: CREATE TABLE will create implicit sequence "page_id_seq" for serial column "page.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "page_pkey" for table "page" NOTICE: CREATE TABLE / UNIQUE will create implicit index "page_pagename_key" for table "page" Creating version Creating recent Creating nonempty Creating experimental pagedata (not yet used) Creating experimental versiondata (not yet used) Creating experimental pageperm (not yet used) Creating experimental page views (not yet used) Creating link Creating rating Creating session NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "session_pkey" for table "session" Creating pref NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "pref_pkey" for table "pref" Creating accesslog Initializing tsearch2 indices ERROR: relation "pg_ts_cfg" does not exist Access Control -------------- An error seems to have occurred while installing the database. If it's of any help, this was the error encountered: At first init the database with: $ createdb phpwiki $ createuser -S -R -d 'wikiuser' $ psql -U 'wikiuser' phpwiki < /usr/share/postgresql/contrib/tsearch2.sql $ psql -U 'wikiuser' phpwiki < psql-initialize.sql Initializing PhpWiki tables with: prefix = '' httpd_user = 'wikiuser' Expect some 'NOTICE: CREATE ... will create implicit sequence/index ...' messages Creating page NOTICE: CREATE TABLE will create implicit sequence "page_id_seq" for serial column "page.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "page_pkey" for table "page" NOTICE: CREATE TABLE / UNIQUE will create implicit index "page_pagename_key" for table "page" Creating version Creating recent Creating nonempty Creating experimental pagedata (not yet used) Creating experimental versiondata (not yet used) Creating experimental pageperm (not yet used) Creating experimental page views (not yet used) Creating link Creating rating Creating session NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "session_pkey" for table "session" Creating pref NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "pref_pkey" for table "pref" Creating accesslog Initializing tsearch2 indices ERROR: relation "pg_ts_cfg" does not exist At this point, you have the option to retry or abort the operation. If you choose "retry", you will be prompted with all the configuration questions once more and another attempt will be made at performing the operation. "retry (skip questions)" will immediately attempt the operation again, skipping all questions. If you choose "abort", the operation will fail and you will need to downgrade, reinstall, reconfigure this package, or otherwise manually intervene to continue using it. If you choose "ignore", the operation will continue, ignoring further errors from dbconfig-common. 1. abort 2. retry 3. retry (skip questions) 4. ignore Error installing database for phpwiki. Retry? 4 dbconfig-common: phpwiki configure: ignoring errors from here forwards done. dbconfig-common: flushing administrative password Creating config file /etc/phpwiki/config.ini with new version Creating config file /etc/phpwiki/apache.conf with new version Reloading web server config: apache2[Sat May 24 16:53:22 2008] [warn] The Alias directive in /etc/apache2/sites-enabled/phpwiki at line 1 will probably never match because it overlaps an earlier Alias. [Sat May 24 16:53:22 2008] [warn] The Alias directive in /etc/apache2/sites-enabled/phpwiki at line 2 will probably never match because it overlaps an earlier Alias. [Sat May 24 16:53:22 2008] [warn] The ScriptAlias directive in /etc/apache2/sites-enabled/pywiki at line 1 will probably never match because it overlaps an earlier Alias. .
