[10:55:51] I need to access wikimedia DB replicas. For that I was suggested to create a toolforge account. I managed to do it and to ssh into my toolforge section. I can also access replicas through terminal commands like mysql --user=$USER_FROM_REPLICA.MY.CNF --host=127.0.0.1 --port=4711 --password enwiki_p [10:56:26] and ask for specific table entries once the MariaDB interface activates [10:58:28] yes? [10:58:32] However, I would like to embed this connection and the sql queries into a Python script so to run the Python script from my toolforge account and, among other things, have the connection to the replicas and query them. Unfortunately it's not clear to me which steps to take for this [10:59:58] have you seen the examples on https://wikitech.wikimedia.org/wiki/Help:Toolforge/Database#Code_samples_for_common_languages yet? [11:02:01] Oooh thank you, I missed this, I'l try it. Just to fully understand, I need to run the python script from my personal repo on Toolforge? [11:03:48] the examples assume that you're inside toolforge and not just port forwarding to the database servers, yes [11:04:59] Great thanks, then I'll try that now [15:54:21] !log toolhub Update demo server to 617dea7 [15:54:22] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Toolhub/SAL [17:39:29] !log tools.bridgebot Enabled keepnick module for ZNC and flushed configuration to disk. [17:39:30] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.bridgebot/SAL [20:23:38] !log tools.notwikilambda git -C ~/public_html/w/extensions/WikiLambda/ submodule update [20:23:41] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.notwikilambda/SAL [20:25:59] !log tools.notwikilambda added git submodule update to ~/update script [20:26:01] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.notwikilambda/SAL [20:32:53] !log tools.notwikilambda added mem: 2G to ~/service.template and stop+started webservice [20:32:55] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.notwikilambda/SAL [20:34:47] *googles how to increase PHP memory limit without editing /etc/php/7.3/cgi/php.ini* [20:41:39] !log tools.notwikilambda added $wgMemoryLimit = '1G'; to LocalSettings.php [20:41:41] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.notwikilambda/SAL [20:41:52] ^ that’s how ^^ though it doesn’t seem to have helped [20:45:46] @lucaswerkmeister I think `$HOME/public_html/.user.ini` is the magic place -- https://wikitech.wikimedia.org/wiki/Help:Toolforge/Web/Lighttpd#PHP [20:46:04] ah, thanks [20:46:19] though $wgMemoryLimit is apparently able to raise the memory limit, I can see it’s higher in the error message [20:46:22] it’s just not enough [20:47:13] your container may need a higher limit as well. https://wikitech.wikimedia.org/wiki/Help:Toolforge/Web#Runtime_memory_limits [20:47:30] I bumped that already [20:47:52] (to 2G, which apparently translates into requests 1G, limits 2G) [20:56:16] more details in https://phabricator.wikimedia.org/T293828 btw [20:56:41] !log tools.notwikilambda previous log messages all related to T293828 [20:56:44] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.notwikilambda/SAL [20:56:49] (realized I should log that too ^^)