Thread:Extension talk:LDAP Authentication/how to no anonymous bind and can't enable debug/reply

Here this databaseerror info and debug log I disable xcache now, but only uid=1 can login without databaseerror MediaWiki internal error.

Original exception: exception 'DBQueryError' with message 'A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: SELECT * FROM "ipblocks" WHERE ipb_address IN ('Ayaka','Ayaka') OR ((ipb_range_start LIKE '%' ) AND (ipb_range_start <= 0) AND (ipb_range_end >= 0)) Function: Block::newLoad Error: 1 错误: 操作符不存在: text <= integer LINE 1: ...(ipb_range_start LIKE '%' ) AND (ipb_range_start <= 0) AND ... ^ HINT: 没有匹配指定名称和参数类型的操作符. 您也许需要增加明确的类型转换. ' in /var/www/wiki.test.tw/includes/db/Database.php:918 Stack trace:
 * 1) 0 /var/www/wiki.test.tw/includes/db/Database.php(885): DatabaseBase->reportQueryError('??????: ??????...', 1, 'SELECT * FROM...', 'Block::newLoad', false)
 * 2) 1 /var/www/wiki.test.tw/includes/db/Database.php(1358): DatabaseBase->query('SELECT * FROM...', 'Block::newLoad')
 * 3) 2 /var/www/wiki.test.tw/includes/Block.php(246): DatabaseBase->select('ipblocks', '*', 'ipb_address IN ...', 'Block::newLoad')
 * 4) 3 /var/www/wiki.test.tw/includes/Block.php(1053): Block->newLoad('127.0.0.1')
 * 5) 4 /var/www/wiki.test.tw/includes/User.php(1281): Block::newFromTarget('127.0.0.1', '127.0.0.1', false)
 * 6) 5 /var/www/wiki.test.tw/includes/User.php(3034): User->getBlockedStatus
 * 7) 6 /var/www/wiki.test.tw/includes/specials/SpecialUserlogin.php(666): User->isBlockedFromCreateAccount
 * 8) 7 /var/www/wiki.test.tw/includes/specials/SpecialUserlogin.php(530): LoginForm->attemptAutoCreate(Object(User))
 * 9) 8 /var/www/wiki.test.tw/includes/specials/SpecialUserlogin.php(716): LoginForm->authenticateUserData
 * 10) 9 /var/www/wiki.test.tw/includes/specials/SpecialUserlogin.php(170): LoginForm->processLogin
 * 11) 10 /var/www/wiki.test.tw/includes/SpecialPageFactory.php(476): LoginForm->execute(NULL)
 * 12) 11 /var/www/wiki.test.tw/includes/Wiki.php(263): SpecialPageFactory::executePath(Object(Title), Object(RequestContext))
 * 13) 12 /var/www/wiki.test.tw/includes/Wiki.php(593): MediaWiki->performRequest
 * 14) 13 /var/www/wiki.test.tw/includes/Wiki.php(503): MediaWiki->main
 * 15) 14 /var/www/wiki.test.tw/index.php(58): MediaWiki->run
 * 16) 15 {main}

Exception caught inside exception handler: exception 'DBQueryError' with message 'A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: SELECT value,exptime FROM "objectcache" WHERE keyname = 'wiki:resourceloader:filter:minify-css:7:c88e2bcd56513749bec09a7e29cb3ffa' LIMIT 1 Function: SqlBagOStuff::get Error: 1 错误: 当前事务被终止, 事务块结束之前的查询被忽略 ' in /var/www/wiki.test.tw/includes/db/Database.php:918 Stack trace: 2012-08-27 18:25:43 ritsuko wiki: 2.0a Entering validDomain 2012-08-27 18:25:43 ritsuko wiki: 2.0a User is not using a valid domain. 2012-08-27 18:25:43 ritsuko wiki: 2.0a Setting domain as: ldaptest 2012-08-27 18:25:44 ritsuko wiki: 2.0a Entering allowPasswordChange 2012-08-27 18:25:44 ritsuko wiki: 2.0a Entering modifyUITemplate 2012-08-27 18:26:00 ritsuko wiki: 2.0a Entering validDomain 2012-08-27 18:26:00 ritsuko wiki: 2.0a User is using a valid domain (ldaptest). 2012-08-27 18:26:00 ritsuko wiki: 2.0a Setting domain as: ldaptest 2012-08-27 18:26:00 ritsuko wiki: 2.0a Entering getCanonicalName 2012-08-27 18:26:00 ritsuko wiki: 2.0a Username isn't empty. 2012-08-27 18:26:00 ritsuko wiki: 2.0a Entering Connect 2012-08-27 18:26:00 ritsuko wiki: 2.0a Using SSL 2012-08-27 18:26:00 ritsuko wiki: 2.0a Using non-standard port: 636 2012-08-27 18:26:00 ritsuko wiki: 2.0a Using servers: ldaps://ldap.test.pri:636 2012-08-27 18:26:00 ritsuko wiki: 2.0a PHP's LDAP connect method returned true (note, this does not imply it connected to the server). 2012-08-27 18:26:00 ritsuko wiki: 2.0a Entering getUserDN 2012-08-27 18:26:00 ritsuko wiki: 2.0a Doing a proxy bind 2012-08-27 18:26:00 ritsuko wiki: 2.0a Created a regular filter: (uid=Ayaka) 2012-08-27 18:26:00 ritsuko wiki: 2.0a Entering getBaseDN 2012-08-27 18:26:00 ritsuko wiki: 2.0a basedn is ou=People,ou=web,dc=test,dc=tw 2012-08-27 18:26:00 ritsuko wiki: 2.0a Using base: ou=People,ou=web,dc=test,dc=tw 2012-08-27 18:26:00 ritsuko wiki: 2.0a Setting the LDAPUsername based on fetched wgLDAPSearchAttributes: ayaka 2012-08-27 18:26:00 ritsuko wiki: 2.0a Username munged by hook: ayaka 2012-08-27 18:26:00 ritsuko wiki: 2.0a Using LDAPUsername: ayaka 2012-08-27 18:26:00 ritsuko wiki: 2.0a Munged username: Ayaka 2012-08-27 18:26:00 ritsuko wiki: 2.0a Entering getCanonicalName 2012-08-27 18:26:00 ritsuko wiki: 2.0a Username isn't empty. 2012-08-27 18:26:00 ritsuko wiki: 2.0a Entering Connect 2012-08-27 18:26:00 ritsuko wiki: 2.0a Using SSL 2012-08-27 18:26:00 ritsuko wiki: 2.0a Using non-standard port: 636 2012-08-27 18:26:00 ritsuko wiki: 2.0a Using servers: ldaps://ldap.test.pri:636 2012-08-27 18:26:00 ritsuko wiki: 2.0a PHP's LDAP connect method returned true (note, this does not imply it connected to the server). 2012-08-27 18:26:00 ritsuko wiki: 2.0a Entering getUserDN 2012-08-27 18:26:00 ritsuko wiki: 2.0a Doing a proxy bind 2012-08-27 18:26:00 ritsuko wiki: 2.0a Created a regular filter: (uid=127.0.0.1) 2012-08-27 18:26:00 ritsuko wiki: 2.0a Entering getBaseDN 2012-08-27 18:26:00 ritsuko wiki: 2.0a basedn is ou=People,ou=web,dc=test,dc=tw 2012-08-27 18:26:00 ritsuko wiki: 2.0a Using base: ou=People,ou=web,dc=test,dc=tw 2012-08-27 18:26:00 ritsuko wiki: 2.0a Couldn't find an entry 2012-08-27 18:26:00 ritsuko wiki: 2.0a Username munged by hook: ayaka 2012-08-27 18:26:00 ritsuko wiki: 2.0a Using LDAPUsername: ayaka 2012-08-27 18:26:00 ritsuko wiki: 2.0a Munged username: Ayaka 2012-08-27 18:26:00 ritsuko wiki: 2.0a Entering getCanonicalName 2012-08-27 18:26:00 ritsuko wiki: 2.0a Username isn't empty. 2012-08-27 18:26:00 ritsuko wiki: 2.0a Entering Connect 2012-08-27 18:26:00 ritsuko wiki: 2.0a Using SSL 2012-08-27 18:26:00 ritsuko wiki: 2.0a Using non-standard port: 636 2012-08-27 18:26:00 ritsuko wiki: 2.0a Using servers: ldaps://ldap.test.pri:636 2012-08-27 18:26:00 ritsuko wiki: 2.0a PHP's LDAP connect method returned true (note, this does not imply it connected to the server). 2012-08-27 18:26:00 ritsuko wiki: 2.0a Entering getUserDN 2012-08-27 18:26:00 ritsuko wiki: 2.0a Doing a proxy bind 2012-08-27 18:26:00 ritsuko wiki: 2.0a Created a regular filter: (uid=Ayaka) 2012-08-27 18:26:00 ritsuko wiki: 2.0a Entering getBaseDN 2012-08-27 18:26:00 ritsuko wiki: 2.0a basedn is ou=People,ou=web,dc=test,dc=tw 2012-08-27 18:26:00 ritsuko wiki: 2.0a Using base: ou=People,ou=web,dc=test,dc=tw 2012-08-27 18:26:00 ritsuko wiki: 2.0a Setting the LDAPUsername based on fetched wgLDAPSearchAttributes: ayaka 2012-08-27 18:26:00 ritsuko wiki: 2.0a Username munged by hook: ayaka 2012-08-27 18:26:00 ritsuko wiki: 2.0a Using LDAPUsername: ayaka 2012-08-27 18:26:00 ritsuko wiki: 2.0a Munged username: Ayaka 2012-08-27 18:26:00 ritsuko wiki: 2.0a Entering getCanonicalName 2012-08-27 18:26:00 ritsuko wiki: 2.0a Username isn't empty. 2012-08-27 18:26:00 ritsuko wiki: 2.0a Entering Connect 2012-08-27 18:26:00 ritsuko wiki: 2.0a Using SSL 2012-08-27 18:26:00 ritsuko wiki: 2.0a Using non-standard port: 636 2012-08-27 18:26:00 ritsuko wiki: 2.0a Using servers: ldaps://ldap.test.pri:636 2012-08-27 18:26:00 ritsuko wiki: 2.0a PHP's LDAP connect method returned true (note, this does not imply it connected to the server). 2012-08-27 18:26:00 ritsuko wiki: 2.0a Entering getUserDN 2012-08-27 18:26:00 ritsuko wiki: 2.0a Doing a proxy bind 2012-08-27 18:26:00 ritsuko wiki: 2.0a Created a regular filter: (uid=127.0.0.1) 2012-08-27 18:26:00 ritsuko wiki: 2.0a Entering getBaseDN 2012-08-27 18:26:00 ritsuko wiki: 2.0a basedn is ou=People,ou=web,dc=test,dc=tw 2012-08-27 18:26:00 ritsuko wiki: 2.0a Using base: ou=People,ou=web,dc=test,dc=tw 2012-08-27 18:26:00 ritsuko wiki: 2.0a Couldn't find an entry 2012-08-27 18:26:00 ritsuko wiki: 2.0a Username munged by hook: ayaka 2012-08-27 18:26:00 ritsuko wiki: 2.0a Using LDAPUsername: ayaka 2012-08-27 18:26:00 ritsuko wiki: 2.0a Munged username: Ayaka
 * 1) 0 /var/www/wiki.test.tw/includes/db/Database.php(885): DatabaseBase->reportQueryError('??????: ??????...', 1, 'SELECT value,e...', 'SqlBagOStuff::g...', false)
 * 2) 1 /var/www/wiki.test.tw/includes/db/Database.php(1358): DatabaseBase->query('SELECT value,e...', 'SqlBagOStuff::g...')
 * 3) 2 /var/www/wiki.test.tw/includes/db/Database.php(1445): DatabaseBase->select('objectcache', Array, Array, 'SqlBagOStuff::g...', Array, Array)
 * 4) 3 /var/www/wiki.test.tw/includes/objectcache/SqlBagOStuff.php(124): DatabaseBase->selectRow('objectcache', Array, Array, 'SqlBagOStuff::g...')
 * 5) 4 /var/www/wiki.test.tw/includes/resourceloader/ResourceLoader.php(149): SqlBagOStuff->get('wiki:resourcelo...')
 * 6) 5 /var/www/wiki.test.tw/includes/resourceloader/ResourceLoader.php(783): ResourceLoader->filter('minify-css', 'a:lang(ar), a:l...')
 * 7) 6 /var/www/wiki.test.tw/includes/OutputPage.php(2594): ResourceLoader->makeModuleResponse(Object(ResourceLoaderContext), Array)
 * 8) 7 /var/www/wiki.test.tw/includes/OutputPage.php(3310): OutputPage->makeResourceLoaderLink(Array, 'styles')
 * 9) 8 /var/www/wiki.test.tw/includes/OutputPage.php(2407): OutputPage->buildCssLinks
 * 10) 9 /var/www/wiki.test.tw/includes/SkinTemplate.php(465): OutputPage->headElement(Object(SkinVector))
 * 11) 10 /var/www/wiki.test.tw/includes/OutputPage.php(1982): SkinTemplate->outputPage
 * 12) 11 /var/www/wiki.test.tw/includes/Exception.php(182): OutputPage->output
 * 13) 12 /var/www/wiki.test.tw/includes/Exception.php(209): MWException->reportHTML
 * 14) 13 /var/www/wiki.test.tw/includes/Exception.php(490): MWException->report
 * 15) 14 /var/www/wiki.test.tw/includes/Exception.php(569): MWExceptionHandler::report(Object(DBQueryError))
 * 16) 15 /var/www/wiki.test.tw/includes/Wiki.php(506): MWExceptionHandler::handle(Object(DBQueryError))
 * 17) 16 /var/www/wiki.test.tw/index.php(58): MediaWiki->run
 * 18) 17 {main}