Page MenuHomePhabricator

Postgresql 9.1; 42P01: ERROR: relation "ldap_domains" does not exist
Closed, ResolvedPublic

Description

Author: peterworden

Description:
Product Version
MediaWiki 1.20.2
PHP 5.3.10-1ubuntu3.5 (apache2handler)
PostgreSQL 9.1.8

LDAP Authentication Plugin (Version 2.0d)

Immediately after logging in:
"
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

SELECT domain FROM "ldap_domains" WHERE user_id = '14' LIMIT 1

from within function "LdapAuthenticationPlugin::loadDomain". Database returned error "42P01: ERROR: relation "ldap_domains" does not exist LINE 1: ...ionPlugin::loadDomain 10.20.8.70 */ domain FROM "ldap_doma... ^ ".
"

According to documentation for Postgresql:

42P01 UNDEFINED TABLE undefined_table

/var/www/wikimedia/maintenance/update.php had no positive effect since already running latest version.


Version: master
Severity: normal
OS: Linux

Details

Reference
bz45293

Event Timeline

bzimport raised the priority of this task from to Low.Nov 22 2014, 1:18 AM
bzimport set Reference to bz45293.

bob wrote:

The ldap.sql script is not postgres friendly. change it like so:

CREATE TABLE ldap_domains (

domain_id serial primary key,
domain varchar(255) not null,
user_id int not null

);

CREATE INDEX user_id on ldap_domains (user_id);

*** This bug has been marked as a duplicate of bug 44168 ***