Seeing the following database error, after upgrading from MediaWiki 1.19 / MySql 5.562 to MediaWiki 1.31 / MariaDB 10.1.30:
Error: 1146 Table 'my_wiki.ldap_domains' doesn't exist (localhost)
Do I need to create this table? How?
Full error:
[85a8e00ef64ac8bad4257a0b] /mediawiki/index.php/Special:UserLogin Wikimedia\Rdbms\DBQueryError from line 1457 of /var/www/html/mediawiki/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? Query: SELECT domain FROM `ldap_domains` WHERE user_id = '1' LIMIT 1 Function: LdapAuthenticationPlugin::loadDomain Error: 1146 Table 'my_wiki.ldap_domains' doesn't exist (localhost) Backtrace: #0 /var/www/html/mediawiki/includes/libs/rdbms/database/Database.php(1427): Wikimedia\Rdbms\Database->makeQueryException(string, integer, string, string) #1 /var/www/html/mediawiki/includes/libs/rdbms/database/Database.php(1200): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean) #2 /var/www/html/mediawiki/includes/libs/rdbms/database/Database.php(1653): Wikimedia\Rdbms\Database->query(string, string) #3 /var/www/html/mediawiki/includes/libs/rdbms/database/Database.php(1730): Wikimedia\Rdbms\Database->select(string, array, array, string, array, array) #4 /var/www/html/mediawiki/extensions/LdapAuthentication/LdapAuthenticationPlugin.php(2142): Wikimedia\Rdbms\Database->selectRow(string, array, array, string) #5 /var/www/html/mediawiki/extensions/LdapAuthentication/LdapAuthenticationPlugin.php(2161): LdapAuthenticationPlugin::loadDomain(User) #6 /var/www/html/mediawiki/extensions/LdapAuthentication/LdapAuthenticationPlugin.php(1260): LdapAuthenticationPlugin::saveDomain(User, string) #7 /var/www/html/mediawiki/includes/auth/AuthPluginPrimaryAuthenticationProvider.php(145): LdapAuthenticationPlugin->updateUser(User) #8 /var/www/html/mediawiki/includes/Hooks.php(177): MediaWiki\Auth\AuthPluginPrimaryAuthenticationProvider->onUserLoggedIn(User) #9 /var/www/html/mediawiki/includes/Hooks.php(205): Hooks::callHook(string, array, array, NULL) #10 /var/www/html/mediawiki/includes/auth/AuthManager.php(2392): Hooks::run(string, array) #11 /var/www/html/mediawiki/includes/auth/AuthManager.php(691): MediaWiki\Auth\AuthManager->setSessionDataForUser(User, boolean) #12 /var/www/html/mediawiki/includes/auth/AuthManager.php(383): MediaWiki\Auth\AuthManager->continueAuthentication(array) #13 /var/www/html/mediawiki/includes/specialpage/AuthManagerSpecialPage.php(353): MediaWiki\Auth\AuthManager->beginAuthentication(array, string) #14 /var/www/html/mediawiki/includes/specialpage/AuthManagerSpecialPage.php(482): AuthManagerSpecialPage->performAuthenticationStep(string, array) #15 /var/www/html/mediawiki/includes/htmlform/HTMLForm.php(660): AuthManagerSpecialPage->handleFormSubmit(array, VFormHTMLForm) #16 /var/www/html/mediawiki/includes/specialpage/AuthManagerSpecialPage.php(416): HTMLForm->trySubmit() #17 /var/www/html/mediawiki/includes/specialpage/LoginSignupSpecialPage.php(316): AuthManagerSpecialPage->trySubmit() #18 /var/www/html/mediawiki/includes/specialpage/SpecialPage.php(522): LoginSignupSpecialPage->execute(NULL) #19 /var/www/html/mediawiki/includes/specialpage/SpecialPageFactory.php(568): SpecialPage->run(NULL) #20 /var/www/html/mediawiki/includes/MediaWiki.php(288): SpecialPageFactory::executePath(Title, RequestContext) #21 /var/www/html/mediawiki/includes/MediaWiki.php(861): MediaWiki->performRequest() #22 /var/www/html/mediawiki/includes/MediaWiki.php(524): MediaWiki->main() #23 /var/www/html/mediawiki/index.php(42): MediaWiki->run() #24 {main}
When I have this uncommented in the LocalSettings.php file on my Ubuntu 18.04 LTS host
# Enable LDAP Authentication require_once( "$IP/extensions/LdapAuthentication/LdapAuthentication.php" ); $wgAuth = new LdapAuthenticationPlugin(); $wgLDAPDomainNames = array( "acc.local" ); $wgLDAPServerNames = array( "acc.local" => "RWDC-GRAHAM-VM1.acc.local" ); $wgLDAPSearchStrings = array( "acc.local" => "ACC\USER-NAME" ); $wgLDAPEncryptionType = array( "acc.local" => "clear" ); $wgLDAPUseLocal = true; $wgMinimalPasswordLength = 1; $wgLDAPBaseDNs = array( "acc.local" => "dc=acc,dc=local" ); $wgLDAPSearchAttributes = array( "acc.local" => "sAMAccountName" ); $wgLDAPRetrievePrefs = array( "acc.local" => "true" ); $wgLDAPDebug = 3; //for debugging LDAP $wgShowExceptionDetails = true; //for debugging MediaWiki $wgLDAPProxyAgent = array('ACC' => 'cn=infowikibind,dc=acc,dc=local',); $wgLDAPProxyAgentPassword = array('ACC' => 'Hj89#2sA'); $wgLDAPPort = array('ACC' => 636,)