Emm… Very bizarre. So I’ve got access to the Tools projects and have created a Tools account. I logged in to login.tools.wmflabs.org with my shell account then switched to my Tools account by typing “become taqpol-test” (taqpol-test is my Tools account name)

But when I listed the files in my home directory I got something like that:
tools.taqpol-test@tools-bastion-02:~$ ls -a
.   .bash_history     .description  public_html
..  .cloud-locale-test.skip  .viminfo
And clearly there is no .replica.my.cnf… 

Have I done something wrong? Help would be much appreciated.

Best wishes,
TaqPol
https://en.wikipedia.org/wiki/User:TaqPol
TaqPol.wiki@icloud.com

On 7 Jul, 2015, at 10:42 pm, MusikAnimal <musikanimal@gmail.com> wrote:

Yes, you're probably on to something TaqPol. As for setting up your environment, refer to Help:Tool Labs on how to gain access. There is an access request form 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@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@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@lists.wikimedia.org [mailto:xtools-bounces@lists.wikimedia.org] On Behalf Of TaqPol
Sent: Monday, July 06, 2015 7:31 PM
To: xtools@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@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 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 should offer some advice on how to accomplish that, see also Help:Tool Labs/Database.

 

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@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@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@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@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@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@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@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 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 with helpful advice. General information may be found at mw: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@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@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@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.)

 
 
 

On Sat, Jul 4, 2015 at 9:18 PM, Maximilian Doerr <maximilian.doerr@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@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@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.

 
 

On Sat, Jul 4, 2015 at 8:55 PM, ShoeMaker Royality <legend.of.the.red.dragon@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@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@l235.net> wrote:

 

No objections from me.

 
 

On Sat, Jul 4, 2015 at 9:54 AM, TaqPol <taqpol.wiki@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,

 

On 4 Jul, 2015, at 10:39 pm, MusikAnimal <musikanimal@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@gmail.com> wrote:

He’s got my thumbs up.  Any objections?

 

Cyberpower678

English Wikipedia Account Creation Team

Mailing List Moderator

 

From: xtools-bounces@lists.wikimedia.org [mailto:xtools-bounces@lists.wikimedia.org] On Behalf Of TaqPol
Sent: Saturday, July 04, 2015 6:10 AM
To: xtools@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


_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon
xTools mailing list
xTools@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools

_______________________________________________

Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools

 


_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools

 

_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools

 


_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools


_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools

 


_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools


_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools

 


_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools


_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools

 

_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools

 

_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools


_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools

 


_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools


_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools


_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools


_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools

 

_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools

_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools

_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools


_______________________________________________
Maintainers: Cyberpower678, Technical 13, MusikAnimal, Elee, Nakon, L235
xTools mailing list
xTools@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/xtools