Thread:Project:Support desk/Installation error: Setting the search path for use

'''Not sure which of the two following things resolved the issue:

1. the php code was changed to force the wikidb name as the value of $path. It appears as though some of the logic to manage $wgDBts2schema is picking up some unintended concatenation. 2. the privileges of wikidb were missing create, update, etc. '''

The system is Fedora 14, the error is reproducible with database users, postgres and postgresuser. There are no errors reported in either /var/log/messages or /secure.

The error is: Setting the search path for user "postgresuser" ... Warning: pg_query: Query failed: ERROR: zero-length delimited identifier at or near """" LINE 1: ...USER "postgresuser" SET search_path = "postgres", "", public ^ in /usr/share/mediawiki/includes/db/DatabasePostgres.php on line 518 FAILED.

The full install output is:

MediaWiki 1.16.5 Installation

* Don't forget security updates! Keep an eye on the low-traffic release announcements mailing list.

Checking environment...

Please include all of the lines below when reporting installation problems.

* PHP 5.3.6 installed * Found database drivers for: MySQL PostgreSQL SQLite * PHP server API is apache2handler; ok, using pretty URLs (index.php/Page_Title) * Have XML / Latin1-UTF-8 conversion support. * Session save path (/var/lib/php/session) appears to be valid. * PHP's memory_limit is 128M bytes. * Couldn't find eAccelerator, APC or XCache; cannot use these for object caching. * Found GNU diff3: /usr/bin/diff3. * Found ImageMagick: /usr/bin/convert; image thumbnailing will be enabled if you enable uploads. * Found GD graphics library built-in. * Installation directory: /usr/share/mediawiki * Script URI path: /wiki * Installing MediaWiki with php file extensions * Environment checked. You can install MediaWiki. *

Generating configuration file... * Database type: PostgreSQL * Loading class: DatabasePostgres * Attempting to connect to database "wikidb" as "postgresuser"...   * Checking the version of Postgres...version 8.4.8 is OK. * Checking for Pl/Pgsql ...not installed. Attempting to install Pl/Pgsql ...OK   * Creating schema postgres ...OK    * Setting the timezone to GMT for user "postgresuser" ...OK    * Setting the datestyle to ISO, YMD for user "postgresuser" ...OK    * Setting the search path for user "postgresuser" ... Warning: pg_query: Query failed: ERROR: zero-length delimited identifier at or near """" LINE 1: ...USER "postgresuser" SET search_path = "postgres", "", public ^ in /usr/share/mediawiki/includes/db/DatabasePostgres.php on line 518 FAILED.

Below are the postgres db: wikidb-> \l List of databases Name   |    Owner     | Encoding |  Collation  |    Ctype    |   Access privileges ---+--+--+-+-+--- postgres | postgres     | UTF8     | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres    | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres template1 | postgres    | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres wikidb   | postgresuser | UTF8     | en_US.UTF-8 | en_US.UTF-8 | (4 rows)

Below are the schemas: wikidb-> \dn List of schemas Name       |    Owner +-- information_schema | postgres pg_catalog        | postgres pg_toast          | postgres pg_toast_temp_1   | postgres postgres          | postgresuser public            | postgres (6 rows)