Yes, you're probably on to something TaqPol. As for setting up your
environment, refer to Help:Tool Labs
<https://wikitech.wikimedia.org/wiki/Help:Tool_Labs> on how to gain access.
There is an access request form
<https://wikitech.wikimedia.org/wiki/Special:FormEdit/Tools_Access_Request>
you'll
need to submit, among other things. Beyond that you should be able to work
completely independently of labs, all you need is set up the SSH tunnel and
MySQL credentials in your ~/.replica.my.cnf
Thanks for helping out!
On 6 July 2015 at 19:59, TaqPol <taqpol.wiki(a)icloud.com> wrote:
Hi,
No that's not what I meant. Is ".labsdb" the correct host for any
database? In MusikAnimal's message, there is an error message:
FastCGI-stderr: PHP Warning: mysqli::mysqli(): (HY000/2005): Unknown
MySQL server host '.labsdb' (0) in /data/project/xtools/modules/WebTool.php
on line 1154
which suggested that the script try to access the host ".labsdb".
Cheers,
TaqPol
On Jul 07, 2015, at 12:56 AM, Maximilian Doerr <maximilian.doerr(a)gmail.com>
wrote:
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(a)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&A
<http://stackoverflow.com/questions/464317/connect-to-a-mysql-server-over-ssh-in-php>
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(a)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
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(a)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
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
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(a)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
_______________________________________________
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