Enwiki.labsdb is the correct host
en.wikipedia.org
There are many ways to access the enwiki database.
Cyberpower678
English Wikipedia Account Creation Team
Mailing List Moderator
From: xtools-bounces(a)lists.wikimedia.org [mailto:xtools-bounces@lists.wikimedia.org] On
Behalf Of TaqPol
Sent: Monday, July 06, 2015 7:31 PM
To: xtools(a)lists.wikimedia.org
Subject: [xTools] Organisation
Hi,
I'd be more than happy to set up a local environment but I don't currently have
access to the Tools project. I would request for permission and set it up then.
Judging from the response, it would sound like the server name '.labsdb' instead
of, for example 'enwiki.labsdb', was used which is clearly not right.
This would point to the following code:
if ($dbnameIn == "tools"){
$server = "p:".$dbnameIn.".labsdb";
$dbname = "";
$checkReplag = false;
}
elseif (in_array( $dbnameIn,
array("s1","s2","s3","s4","s5","s6","s7")
) ){
$server = $dbnameIn.".labsdb";
$dbname = "";
$checkReplag = false;
}
// elseif ( in_array( $dbnameIn, array("wikidatawiki") ) ){
// $server = "p:s2.labsdb";
// $dbname = $dbnameIn."_p";
// }
elseif ($dbnameIn){
$server = "c2.labsdb"; //$dbnameIn.".labsdb";
$dbname = $dbnameIn."_p";
}
else{
$wi = $this->getWikiInfo( $lang, $wiki);
$server = $wi->database.".labsdb";
$dbname = $wi->database."_p";
}
(WebTools.php, lines 604-626)
and would suggest that $wi->database returned is empty... I still couldn't get over
the fact that with the same code the other tools works but just not articleinfo though...
I will write back when I got more things to share.
Cheers,
TaqPol
On Jul 06, 2015, at 04:44 PM, MusikAnimal <musikanimal(a)gmail.com> wrote:
Hello all, hope your weekend went well. I am going to continue to establish new devs and
what technologies/frameworks we'll use for the xtools rewrite. In the meantime,
however, I think we should focus on getting this revisions history tool running. It worked
before, we can make it work again.
Yesterday I mentioned the issue I was observing was with a string to integer conversion
(or something similar). Back at my computer, I've been trying to reproduce that and I
am unable to. In fact, no error is reported when I hit Submit using the revisions history
tool. Tried rebooting the app and still no errors being logged. The most recent errors
that were logged were in fact database-related:
FastCGI-stderr: PHP Warning: mysqli::close(): Couldn't fetch mysqli in
/data/project/xtools/modules/WebTool.php on line 1180
FastCGI-stderr: PHP Warning: mysqli::mysqli(): (HY000/2005): Unknown MySQL server host
'.labsdb' (0) in /data/project/xtools/modules/WebTool.php on line 1154
This suggests maybe we are looking at a connection problem. Either way, I'd like to
see if we can reproduce the issue locally. Cyberpower678, TaqPol, Ancheta Wis or any PHP
developer: Would you mind attempting to get the current xtools application running on your
local environment? Aren't there a set of PHP modules one would need to install? Does
anyone know what modules those are? Please inform.
For those unfamiliar with how this should work: If you are using a Mac, you should not
need to worry too much about configuring your environment to emulate "precise",
which is what we're using on labs. I'm afraid I don't know what to recommend
for Windows, but seemingly so long as the dependencies are there you should still be able
to run the application. I believe the old code relies on PHP v5.3, and some undefined set
of modules. If you are not set up to SSH into labs, you will need to create your Wikitech
account, request shell access, upload your SSH keys, etc. See Help:Getting Started
<https://wikitech.wikimedia.org/wiki/Help:Getting_Started> for the full
instructions. SSH into Labs, and your home directory should contain a
"replica.my.cnf" with credentials to connect to the replica database. That is
what you'll be using locally, but you'll also need to set up the connection to be
over SSH. This StackOverflow Q
<http://stackoverflow.com/questions/464317/connect-to-a-mysql-server-over-ssh-in-php>
&A should offer some advice on how to accomplish that, see also Help:Tool
Labs/Database
<https://wikitech.wikimedia.org/wiki/Help:Tool_Labs/Database#Configuring_MySQL_Workbench>
.
Please keep us informed if you have gotten anywhere setting up your local environment.
Whoever does manage to do it can then document what they did for the rest of us to follow.
Even if we don't get the full app running, maybe we can use the "PHP
console" or whatever you guys use to attempt to connect to the replica dbs like we do
in WebTool.php so we can know for sure if that much is being done correctly.
On 5 July 2015 at 11:36, ShoeMaker Royality <legend.of.the.red.dragon(a)gmail.com>
wrote:
MusikAnimal is right. Find out where in the code refers to the error handler that produces
that specific message and tell it to give more detail (best to do it in a hidden div or
span that you can toggle with a simple JavaScript so eu don't see it). T13
On Jul 5, 2015 11:23 AM, "MusikAnimal" <musikanimal(a)gmail.com> wrote:
Look at the error log. It's complaining about a string to integer conversion, or
something of the sort. Sounds like you should be able to put a debugger in there and find
out more. It could be as simple as doing some typecasting. I would tell you what line
number but I'm away from a computer.
I don't think there's anything wrong with the database connection as it's only
the revisions history tool that has that issue, yet it's connecting just like the
other working tools are. The issue causing the "no revisions found" message I
believe is simply bad error handling and shouldn't be taken literally.
On Jul 5, 2015 09:22, "Maximilian Doerr" <maximilian.doerr(a)gmail.com>
wrote:
Good news. APPER has added me to wikihistory, if he gives me permission I should be
allowed to port the code over to temporarily replace articleinfo.
Cyberpower678
English Wikipedia Account Creation Team
Mailing List Moderator
From: xtools-bounces(a)lists.wikimedia.org [mailto:xtools-bounces@lists.wikimedia.org] On
Behalf Of ShoeMaker Royality
Sent: Sunday, July 05, 2015 8:28 AM
To: Discussion list for xTools
Subject: Re: [xTools] Organisation
I believe that both YuviPanda and Coren (and Betacommand for that matter) have said those
lines should be correct. T13
On Jul 5, 2015 4:02 AM, "Ancheta Wis" <tekftu4q(a)gmail.com> wrote:
Kudpung and TacPol and everyone who can add to the solution, I could use some more
information about the database servers :
I draw your attention to the following lines 132, 598, and 619 in
https://github.com/x-Tools/xtools/blob/master/modules/WebTool.php
What bothers is some hard-coded data in what I presume is in the xTools production code
* line 131 //Init permanent connection to tools-db
* line 132 $dbrtools = $this->loadDatabase(null, null, "tools");
* line 598 public function loadDatabase( $lang, $wiki, $dbnameIn=null) {
* line 605 >>> $server = "p:".$dbnameIn.".labsdb";
* line 615 // $server = "p:s2.labsdb";
* line 619 $server = "c2.labsdb"; //$dbnameIn.".labsdb";
* line 1138 class Database2{
My question is "Are these accurate?". Is this in production?
On Sat, Jul 4, 2015 at 11:50 PM, TaqPol <taqpol.wiki(a)icloud.com> wrote:
Hi,
I presume this response is directed to myself.
I cannot help but feel that you are intrinsically against the participation of younger
developers, considering you said that you does not "believe that high school
students and freshmen will be able to wrest themselves from their school athletics and
homework to devote sufficient time to these pressing issues". I emphasise that
"I do have until late September free and plan to commit more time that", as I
wrote in my previous message. This means that I can devote a good amount of time for
xTools as I am currently on holiday and don't have athletics and homework to juggle
until early October.
Put things simply, I can put in quite a lot of time within a timeframe of days and weeks,
but things are a lot more uncertain within a timeframe of months and years.
Cheers,
TaqPol
On Jul 05, 2015, at 07:30 AM, Chris <cs(a)edubkk.org> wrote:
I see words being used such as ‘September’ and ‘October’. I stress again that the task of
getting these tools up and running is urgent and that I do not believe that high school
students and freshmen will be able to wrest themselves from their school athletics and
homework to devote sufficient time to these pressing issues. We have a time frame of days
at this stage - not weeks or months.If X-Tools is a global project, I’ll just remind
everyone:
'Wikimedia Labs was designed to give volunteer software developers a place to write
and test software for WMF operations with the goal being to increase the volunteers
helping maintain the WMF's infrastructure. It was opened for beta testing to a limited
number of users in October 2011. After several months of testing, the service was opened
to the general public in April 2012.’ (Source:
https://en.wikipedia.org/wiki/Wikipedia:Wikimedia_Labs)
'Because of the importance of toolserver tools and the difficulty in maintaining the
toolserver infrastructure, it was decided that a move to a larger organization would be
good, decommissioning the current toolserver. WMDE has committed to funding and
maintaining the toolserver until all users have had a sufficient chance to move to the new
system. […] In February 2013, the Wikimedia Foundation contracted Marc-André Pelletier
<https://www.mediawiki.org/wiki/User:MPelletier_%28WMF%29> to provide assistance to
tool/bot authors in migrating their tools and bots to the Wikimedia Labs' servers. A
help page for migrating has been setup at wikitech:User:Magnus Manske/Migrating from
toolserver
<https://wikitech.wikimedia.org/wiki/User:Magnus_Manske/Migrating_from_toolserver>
with helpful advice. General information may be found at mw:Wikimedia Labs/Migration of
Toolserver tools
<https://www.mediawiki.org/wiki/Wikimedia_Labs/Migration_of_Toolserver_tools> . […]
the full-scale migration process began in June 2013 and expected to be complete by
December 2013 with everything completed by June 2014 when items on the toolserver will be
deleted. Final decommissioning of the toolserver was tentatively scheduled to be complete
by December 2014.
We are now in the middle of 2015.
Kudpung
On 5Jul, 2015, at 13:03, Ancheta Wis <tekftu4q(a)gmail.com> wrote:
C678, Kudpung, L235, MusikAnimal, T13, Hedonil, TParis, X ...
I am trying to debug just how far the database connection, etc., is getting. In my
experience, once a database query is actually returning values, there is no reason the
whole-stitched-together app cannot work. It appears there is a missing resource needed to
make a connection.
I have to say that once something like
[
http://php.net/manual/en/function.mysql-connect.php this mysql snippet] works for xTools,
I can fade out of this picture.
--[https://en.wikipedia.org/wiki/User:Ancheta_Wis Ancheta]
On Sat, Jul 4, 2015 at 7:48 PM, ShoeMaker Royality
<legend.of.the.red.dragon(a)gmail.com> wrote:
On which wiki? xTools is a global project. I honestly don't care much about how much a
specific community trusts a developer or not. As long as the other team members trust the
user, then that's not a concern of mine. T13
On Jul 4, 2015 10:20 PM, "L235 Wikipedia" <l235(a)l235.net> wrote:
Regarding TaqPol, my largest concern is the level of trust you currently have on-wiki.
Your fiftieth edit was a month and a half ago, and though becoming a maintainer on xtools
is certainly nothing like RfA, I'd like to think that some level of community trust
should be needed. (This isn't an oppose, and I'm not making this a formal opinion,
just something for the other maintainers to keep in mind.)
Thanks,
L235
<https://en.wikipedia.org/wiki/User:L235>
https://en.wikipedia.org/wiki/User:L235
On Sat, Jul 4, 2015 at 9:18 PM, Maximilian Doerr <maximilian.doerr(a)gmail.com>
wrote:
The idea of voice/video conferencing is appealing, but likely not feasible with everyone
having different schedules and timezones. So email and IRC will have to do.
Cyberpower678
English Wikipedia Account Creation Team
Mailing List Moderator
From: xtools-bounces(a)lists.wikimedia.org [mailto:xtools-bounces@lists.wikimedia.org] On
Behalf Of ShoeMaker Royality
Sent: Saturday, July 04, 2015 10:04 PM
To: Discussion list for xTools
Subject: Re: [xTools] Organisation
At this point, after the terrorization onwiki, video/voice doesn't work for me.
I've no interest in participating in that. I'm willing to listen and view, but
only share via text at this point. I hope everyone can understand and respect my position
on that. T13
On Jul 4, 2015 9:59 PM, "L235 Wikipedia" <l235(a)l235.net> wrote:
I support the video/voice conferencing, but I often work in an environment where it's
important to be quiet, so I hope it's fine if I provide my (limited, due to
limited/nonexistent PHP skills) input over text and mainly listen. My commitment of one
hour a week was a minimum; I plan/hope to spend more time on the project.
Thanks,
L235
<https://en.wikipedia.org/wiki/User:L235>
https://en.wikipedia.org/wiki/User:L235
On Sat, Jul 4, 2015 at 8:55 PM, ShoeMaker Royality
<legend.of.the.red.dragon(a)gmail.com> wrote:
I personally intend to dedicate 3 or 4 full days a week to development once I get back on
top of my classes next week. It'll likely take me a few hours to get accommodated
with our new environment, but I should be able to quick migrate tools in one at a time
once I am familiar. Getting the first tool set ul and the connection to the database will
be the hardest part, the rest will fall into place easily and be cake work. T13
On Jul 4, 2015 9:47 PM, "Chris" <cs(a)edubkk.org> wrote:
I think we need to admit that while the organisation and coordination of the work is in
every way as important as getting these essential tools back up and running, unlike
writing new articles for Wikipedia , time is not on our side. I’m therefore rater hesitant
with offers of help that due to school can only inject one or two hours a week into the
project. That’s partly what got us into this mess in the first place.
I realise that not everyone is like me: over 65 , retired, and has time on their hands,
but I think we should be looking at a dedication of two or three complete evenings a week
until the job is done. Public holidays should be providing more time rather than being a
reason to take leave from the urgency.
Also, addressing the advantages of video conferencing again, I am in exactly the opposite
time zone to the whole of the USA which means I often have to chat in what is the middle
of the night here in Thailand. I think that’s also the least anyone should be prepared to
do for multi-zone, multi-cultural Wikipedia.
Kudpung
On 4Jul, 2015, at 22:15, L235 Wikipedia <l235(a)l235.net> wrote:
No objections from me.
Thanks,
L235
<https://en.wikipedia.org/wiki/User:L235>
https://en.wikipedia.org/wiki/User:L235
On Sat, Jul 4, 2015 at 9:54 AM, TaqPol <taqpol.wiki(a)icloud.com> wrote:
Hi,
I do understand and I would be okay with that as long as it is the consensus of the group.
I have created a new GitHub account @TaqPol-wiki as I’d prefer to separate this account
from the one I used for LxCenter and my personal projects.
I’m glad that my limited availability is okay with you. I usually can contribute more than
that but the amount of work I have for university is unpredictable so I don’t really want
to make commitments that I cannot meet.
Best wishes,
TaqPol
https://en.wikipedia.org/wiki/User:TaqPol
TaqPol.wiki(a)icloud.com
On 4 Jul, 2015, at 10:39 pm, MusikAnimal <musikanimal(a)gmail.com> wrote:
Looks good, but note we may not necessarily be using a framework, it seems (getting
conflicting recommendations), but certainly a templating engine of sorts. We are open to
all ideas, but would you be okay working with something other than Laravel if it came down
to it? Also, do you have a GitHub account?
Thank you for also being upfront about your availability. It's all volunteer work and
even small contributions here and there are helpful and appreciated.
On Jul 4, 2015 08:41, "Maximilian Doerr" <maximilian.doerr(a)gmail.com>
wrote:
He’s got my thumbs up. Any objections?
Cyberpower678
English Wikipedia Account Creation Team
Mailing List Moderator
From: xtools-bounces(a)lists.wikimedia.org [mailto:xtools-bounces@lists.wikimedia.org] On
Behalf Of TaqPol
Sent: Saturday, July 04, 2015 6:10 AM
To: xtools(a)lists.wikimedia.org
Subject: [xTools] TaqPol - PHP Developer & Sysadmin
Hello,
I am writing in response to the call of developers for xTools on Wikipedia.
I have previously been a Core member in the LxCenter team, which released the open source
web hosting control panel Kloxo and the VPS control panel HyperVM. I work as both a PHP
developer and a sysadmin there, as I also find sponsorship on behalf of LxCenter and
manages the sponsored server although another developer manages the main web server etc.
I currently develop with Laravel, although for simpler application I use packages from
Packgist (e.g. Plates) and I personally think Laravel would be the best way to go,
considering the a MVC implementation is desirable and it provides many useful functions
e.g. an excellent ORM, code injection interface and template engine.
I am afraid I don’t have 10-15 years of experience and I self-learnt PHP. That being said,
I am very willing to learn new stuffs. I am willing to commit to the project. I generally
respond to messages in 24 hours and can commit for at least 2 hours per week during term
time.
Best wishes,
TaqPol
https://en.wikipedia.org/wiki/User:TaqPol
TaqPol.wiki(a)icloud.com
_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon
xTools mailing list
xTools(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools
_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools
_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools
_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools
_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools
_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools
_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools
_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools
_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools
_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools
_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools
_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools
_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools
_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools
_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools
_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools
_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools
_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools