Page MenuHomePhabricator
Create Task
Maniphest T72225

Freshly installed wiki fails with "Permission denied" on PostgreSQL socket
Closed, InvalidPublic
Actions

Description

After running:

php -c "${HOME}/php.ini" maintenance/install.php --dbtype="postgres" --dbname=${db} \
--dbuser=wikiuser --dbpass=${pass} \
--installdbuser=*someuser* --installdbpass=*somepassword* \
--server http://tools.wikimedia.pl --scriptpath "${script}" \
--showexceptions=true --pass test postgrestest WikiAdmin

a wiki installs fine, but the first invocation of /w/index.php gives:

(Cannot contact the database server: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: Permission denied Is the server running locally and accepting connections on Unix domain socket "/run/postgresql/.s.PGSQL.5432"?)

Backtrace:

#0 w/includes/db/Database.php(822): DatabasePostgres->open('', 'wikiuser', '*pass*', '*database*')
#1 w/includes/db/Database.php(919): DatabaseBase->__construct(Array)
#2 w/includes/db/LoadBalancer.php(717): DatabaseBase::factory('postgres', Array)
#3 w/includes/db/LoadBalancer.php(591): LoadBalancer->reallyOpenConnection(Array, false)
#4 w/includes/db/LoadBalancer.php(471): LoadBalancer->openConnection(0, false)
#5 w/includes/GlobalFunctions.php(3618): LoadBalancer->getConnection(-1, Array, false)
#6 w/includes/page/WikiPage.php(379): wfGetDB(-1)
#7 w/includes/page/WikiPage.php(462): WikiPage->loadPageData()
#8 w/includes/page/WikiPage.php(515): WikiPage->exists()
#9 w/includes/page/WikiPage.php(222): WikiPage->getContentModel()
#10 w/includes/page/WikiPage.php(208): WikiPage->getContentHandler()
#11 w/includes/actions/Action.php(96): WikiPage->getActionOverrides()
#12 w/includes/actions/Action.php(149): Action::factory('view', Object(WikiPage), Object(RequestContext))
#13 w/includes/MediaWiki.php(164): Action::getActionName(Object(RequestContext))
#14 w/includes/MediaWiki.php(533): MediaWiki->getAction()
#15 w/includes/MediaWiki.php(460): MediaWiki->main()
#16 w/index.php(46): MediaWiki->run()
#17 {main}

LocalSettings.php include:

$wgDBtype = "postgres";
$wgDBserver = "";
$wgDBname = "*dbname*";

Running the installer with explicit --dbserver=localhost

php -c "${HOME}/php.ini" maintenance/install.php --dbtype="postgres" --dbname=${db} \
--dbuser=wikiuser --dbpass=${pass} \
--dbserver=localhost \
--installdbuser=*user* --installdbpass=*pass* \
--server http://tools.wikimedia.pl --scriptpath "${script}" \
--showexceptions=true --pass test postgrestest WikiAdmin

Seems to create LocalSettings.php with

Now LocalSettings.php include:

$wgDBtype = "postgres";
$wgDBserver = "localhost";
$wgDBname = "*dbname*";

which indicates this is probably another intstance of bug 69291

Version: 1.24rc
Severity: normal
See Also:
https://bugzilla.wikimedia.org/show_bug.cgi?id=70223

Details

Reference
bz70225

Related Objects
Search...

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
· · ·
ResolvedUmherirrenderT71281 Missing defaults in GUI installer
InvalidNoneT2384 [REPLACED BY TAG] PostgreSQL/pgsql support (tracking)
InvalidNoneT72225 Freshly installed wiki fails with "Permission denied" on PostgreSQL socket
· · ·

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 3:39 AM
• bzimport added a project: MediaWiki-libs-Rdbms.
• bzimport set Reference to bz70225.
• bzimport added a subscriber: Unknown Object (MLST).
saper created this task.Aug 31 2014, 12:59 AM
saper added a comment.Aug 31 2014, 1:25 AM

... I mean "another instance of bug 69281"

Jjanes added a comment.Aug 31 2014, 2:17 AM

I agree that bugs 69281 and 70233 are relevant here.

Based on the error message, it is trying to connect to postgres through a local unix socket rather than a TCP socket, which is certainly to do possible. But web servers are often prevented from doing that by selinux, private Temp Files, or some other security feature.

Rather than trying to fight those invisible train wrecks, I just don't even attempt to use local unix sockets. (Which you weren't attempting to do, but only did accidentally through lack of defaults.)

To clarify, once you filled in "localhost", it then worked, right?

saper added a comment.Aug 31 2014, 2:25 AM

Yes, it worked but... I am not using selinux (only FreeBSD) and socket-only connection works from the commandline.

I just reconfigured PostgreSQL to listen only on the socket connection and see how it works.

saper added a comment.Aug 31 2014, 2:35 AM

So, with I61d5f262e60722bc08201b40b61a298d8af42223 (patch for bug 70030) and I0ded13f9f7a2ab93a070224e7448cda34ac83df1 (patch for bug 70223) the CLI installer runs just fine with empty value for the database servers and finishes its work generating LocalSettings.php with $wgDBserver = "";

WebInstaller fails with an error, however:

DB connection error: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: Permission denied Is the server running locally and accepting connections on Unix domain socket "/run/postgresql/.s.PGSQL.5432"

saper added a comment.Aug 31 2014, 3:10 AM

Ah, nevermind... this was because webserver could not access the socket (directory permissions). I have changed the permissions and now everything works fine.

Jdforrester-WMF added a project: PostgreSQL.Nov 2 2016, 8:16 PM
Jdforrester-WMF subscribed.

Migrating from the old tracking task to a tag for PostgreSQL-related tasks.

Krinkle mentioned this in T72223: 'Unknown error' in LoadBalancer->reportConnectionError() hides a real database problem.Jul 28 2018, 11:41 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits