Can some one help me to instal centralauth?
Topic on Project:Support desk
bug
Fatal error: Uncaught exception 'DBConnectionError' with message 'DB connection error: Access denied for user 'u875434364_ujene'@'10.1.2.47' todatabase 'centralauth' (localhost)' in /home/u875434364/public_html/wp/includes/db/Database.php:743Stack trace: #0 /home/u875434364/public_html/wp/includes/db/loadbalancer/LoadBalancer.php(872): DatabaseBase->reportConnectionError('Unknown error (...') #1 /home/u875434364/public_html/wp/includes/db/loadbalancer/LoadBalancer.php(563): LoadBalancer->reportConnectionError() #2 /home/u875434364/public_html/wp/extensions/CentralAuth/includes/CentralAuthUtils.php(53): LoadBalancer->getConnection(-2, Array, 'centralauth') #3 /home/u875434364/public_html/wp/extensions/CentralAuth/includes/CentralAuthUser.php(228): CentralAuthUtils::getCentralDB()#4 /home/u875434364/public_html/wp/extensions/CentralAuth/includes/CentralAuthUser.php(370): CentralAuthUser->getSafeReadDB() #5 /home/u875434364/public_html/wp/extensions/CentralAuth/includes/CentralAuthUser.php(580): CentralAuthUser->loadState in/home/u875434364/public_html/wp/includes/db/Database.phpon line743
also
Try waiting a few minutes and reloading.(Cannot access the database:Access denied for user 'u875434364_ujene'@'10.1.2.47' todatabase 'centralauth' (localhost))Backtrace:#0 /home/u875434364/public_html/wp/includes/db/loadbalancer/LoadBalancer.php(872): DatabaseBase->reportConnectionError('Unknown error (...')#1 /home/u875434364/public_html/wp/includes/db/loadbalancer/LoadBalancer.php(563): LoadBalancer->reportConnectionError()#2 /home/u875434364/public_html/wp/extensions/CentralAuth/includes/CentralAuthUtils.php(53):LoadBalancer->getConnection(-2, Array, 'centralauth')#3 /home/u875434364/public_html/wp/extensions/CentralAuth/includes/CentralAuthUser.php(228): CentralAuthUtils::getCentralDB()#4 /home/u875434364/public_html/wp/extensions/CentralAuth/includes/CentralAuthUser.php(370): CentralAuthUser->getSafeReadDB()#5 /home/u875434364/public_html/wp/extensions/CentralAuth/includes/CentralAuthUser.php(580): CentralAuthUser->loadState()#6 /home/u875434364/public_html/wp/extensions/CentralAuth/includes/session/CentralAuthSessionProvider.php(257): CentralAuthUser->isAttached()#7 /home/u875434364/public_html/wp/includes/session/CookieSessionProvider.php(199): CentralAuthSessionProvider->sessionDataToExport(Object(User))#8 /home/u875434364/public_html/wp/extensions/CentralAuth/includes/session/CentralAuthSessionProvider.php(275): MediaWiki\Session\CookieSessionProvider->persistSession(Object(MediaWiki\Session\SessionBackend), Object(WebRequest))#9 /home/u875434364/public_html/wp/includes/session/SessionBackend.php(677): CentralAuthSessionProvider->persistSession(Object(MediaWiki\Session\SessionBackend), Object(WebRequest))#10 /home/u875434364/public_html/wp/includes/session/SessionBackend.php(606): MediaWiki\Session\SessionBackend->save()#11 /home/u875434364/public_html/wp/includes/session/SessionBackend.php(291): MediaWiki\Session\SessionBackend->autosave()#12 /home/u875434364/public_html/wp/includes/session/Session.php(127): MediaWiki\Session\SessionBackend->persist()#13 /home/u875434364/public_html/wp/includes/specialpage/LoginSignupSpecialPage.php(221):MediaWiki\Session\Session->persist()#14 /home/u875434364/public_html/wp/includes/specialpage/SpecialPage.php(479): LoginSignupSpecialPage->execute(NULL)#15 /home/u875434364/public_html/wp/includes/specialpage/SpecialPageFactory.php(576): SpecialPage->run(NULL)#16 /home/u875434364/public_html/wp/includes/MediaWiki.php(282): SpecialPageFactory::executePath(Object(Title), Object(RequestContext))#17 /home/u875434364/public_html/wp/includes/MediaWiki.php(745): MediaWiki->performRequest()#18 /home/u875434364/public_html/wp/includes/MediaWiki.php(519): MediaWiki->main()#19 /home/u875434364/public_html/wp/index.php(43): MediaWiki->run()#20 {main}
It seems clear that you don't have the proper DB credentials or that your DB permissions aren't set up to allow access to centralauth db from 10.1.2.47.
how to grant acces?
That is really a MySQL question, not a MW question. I don't know anything about your db access or setup. Here is the low level info, though: https://dev.mysql.com/doc/refman/5.5/en/grant.html
bug
- .Query:SELECT gu_id,gu_name,lu_wiki,gu_salt,gu_password,gu_auth_token,gu_locked,gu_hidden,gu_registration,gu_email,gu_email_authenticated,gu_home_db,gu_cas_token FROM `globaluser` LEFT OUTER JOIN `localuser` ON ((gu_name=lu_name) AND lu_wiki= 'u875434364_eruxa-efgq_') WHERE gu_name = 'Vander' LIMIT 1*.Function:CentralAuthUser::loadState*.Error:1146 Table 'u875434364_eruxa.globaluser' doesn't exist (localhost)Backtrace:#0 /home/u875434364/public_html/wp/includes/db/Database.php(901): DatabaseBase->reportQueryError('Table 'u8754343...', 1146, 'SELECT gu_id,g...', 'CentralAuthUser...', false)#1 /home/u875434364/public_html/wp/includes/db/Database.php(1234): DatabaseBase->query('SELECT gu_id,g...', 'CentralAuthUser...')#2 /home/u875434364/public_html/wp/includes/db/Database.php(1293): DatabaseBase->select(Array, Array, Array, 'CentralAuthUser...', Array, Array)
can I download table globaluser.sql?
I know CentralAuth isn't really maintained for non-WMF wikis, but did you try running update.php?
Done but I have bug again
A database query error has occurred. This may indicate a bug inthe software.*.Query:SELECT gu_id,gu_name,lu_wiki,gu_salt,gu_password,gu_auth_token,gu_locked,gu_hidden,gu_registration,gu_email,gu_email_authenticated,gu_home_db,gu_cas_token FROM `globaluser` LEFT OUTER JOIN `localuser` ON ((gu_name=lu_name) AND lu_wiki= 'u875434364_eruxa-efgq_') WHERE gu_name = 'Vander' LIMIT 1*.Function:CentralAuthUser::loadState*.Error:1054 Unknown column 'gu_salt' in 'field list' (localhost)Backtrace:#0 /home/u875434364/public_html/wp/includes/db/Database.php(901): DatabaseBase->reportQueryError('Unknown column ...', 1054, 'SELECT gu_id,g...', 'CentralAuthUser...', false)...
@MarkAHershberger: User 'u875434364_ujene' has exceeded the 'max_user_connections' resource (current value: 3) (localhost))Backtrace:#0 /home/u875434364/public_html/wp/includes/db/loadbalancer/LoadBalancer.php(872): DatabaseBase->reportConnectionError('Unknown error (...')#1 /home/u875434364/public_html/wp/includes/db/loadbalancer/LoadBalancer.php(563): LoadBalancer->reportConnectionError()#2 /home/u875434364/public_html/wp/extensions/CentralAuth/includes/CentralAuthUser.php(2105): LoadBalancer->getConnection(-1, Array, 'wikipedia')#3 /home/u875434364/public_html/wp/extensions/CentralAuth/includes/CentralAuthUser.php(2092): CentralAuthUser->importLocalNames()
that is bug
Done resolved