Last modified: 2013-08-20 04:39:12 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T47293, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 45293 - Postgresql 9.1; 42P01: ERROR: relation "ldap_domains" does not exist
Postgresql 9.1; 42P01: ERROR: relation "ldap_domains" does not exist
Status: RESOLVED DUPLICATE of bug 44168
Product: MediaWiki extensions
Classification: Unclassified
LdapAuthentication (Other open bugs)
master
All Linux
: Low normal (vote)
: ---
Assigned To: Ryan Lane
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2013-02-22 21:25 UTC by peterworden
Modified: 2013-08-20 04:39 UTC (History)
2 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description peterworden 2013-02-22 21:25:25 UTC
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.
Comment 1 Bob Miller 2013-08-20 03:46:12 UTC
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);
Comment 2 Ryan Lane 2013-08-20 04:39:12 UTC

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

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links