Last modified: 2014-10-24 14:25:43 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 T65803, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 63803 - `sql` does not work on deployment-prep
`sql` does not work on deployment-prep
Status: RESOLVED FIXED
Product: Wikimedia Labs
Classification: Unclassified
deployment-prep (beta) (Other open bugs)
unspecified
All All
: Unprioritized normal
: ---
Assigned To: Nobody - You can work on this!
:
Depends on: 63028
Blocks:
  Show dependency treegraph
 
Reported: 2014-04-11 04:26 UTC by Kunal Mehta (Legoktm)
Modified: 2014-10-24 14:25 UTC (History)
8 users (show)

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


Attachments

Description Kunal Mehta (Legoktm) 2014-04-11 04:26:21 UTC
legoktm@deployment-bastion:~$ sql metawiki
ERROR 2005 (HY000): Unknown MySQL server host 'db1' (0)

It should be connecting to deployment-db1 instead.
Comment 1 Bryan Davis 2014-04-11 04:32:01 UTC
This is the /usr/local/bin/sql script. It gets the database server name via:

    echo 'echo wfGetLB()->getServerName(0);' |
    /usr/local/bin/mwscript eval.php --wiki="$lookupdb"

The db-labs.php configuration file probably just needs to be updated to use valid hostnames as keys in $wgLBFactoryConf.
Comment 2 Gerrit Notification Bot 2014-04-11 04:39:57 UTC
Change 125373 had a related patch set uploaded by BryanDavis:
Use valid hostnames in $wgLBFactoryConf

https://gerrit.wikimedia.org/r/125373
Comment 3 Gerrit Notification Bot 2014-04-11 07:49:32 UTC
Change 125373 merged by jenkins-bot:
Use valid hostnames in $wgLBFactoryConf

https://gerrit.wikimedia.org/r/125373
Comment 4 Antoine "hashar" Musso (WMF) 2014-04-11 07:54:08 UTC
There is some progress:

$ sql metawiki
/usr/local/bin/sql: line 30: /usr/local/bin/wikiadmin_pass: Permission denied
Enter password: 


$ ls -l -d /usr/local/bin/wikiadmin_pass
-r-xr-x--- 1 root wikidev 43 Mar 14 14:23 /usr/local/bin/wikiadmin_pass*
$

Anyone that had its account importer from SVN has a GID 500 (svn) and thus would not be able to execute that script which has GID 550 (wikidev).  That is tracked by bug 63028 "inconsistent GID number (500 or 550) which I am adding as a blocker.
Comment 5 Bryan Davis 2014-04-11 22:35:19 UTC
Bug 45706 apparently still applies as well:

    $ sql metawiki
    ERROR 1045 (28000): Access denied for user 'wikiadmin'@'10.68.16.58' (using password: YES)
Comment 6 Antoine "hashar" Musso (WMF) 2014-10-24 14:25:43 UTC
That has been fixed somehow :-)

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


Navigation
Links