[03:22:48] what is the correct way to save persistent options in user scripts / gadgets? [04:37:19] ningu: you can save them as user options with the `userjs-` prefix. [07:03:39] Hi guys. My question: How do you turn off StructuredDiscussions/Flow extension? I tried with convertToText.php but nothing happens? [07:14:53] Hi. Need some help with setting with mediawiki here [07:15:13] the error has apparently something to do with php: https://dpaste.org/YTL0 [07:31:20] mediawiki: you're seeing that when you open mediawiki with a web browser? [07:31:42] Majavah: yes [07:31:52] what web server are you using? [07:32:08] apache2 [07:33:11] mediawiki: you probably need to enable mod_php [07:33:14] what OS are you using? [07:33:21] Raspbian Buster [07:33:59] i guess I'll need to use a2dismod, am I right? [07:34:14] sudo apt install libapache2-mod-php [07:34:20] and then a2enmod php [07:34:28] a2enmod right [07:34:30] (a2dismod disables modules) [07:44:48] what is the name of the module? [07:45:05] i don't see mod-php or even php there [07:45:22] libapache-mod-php was already installef [07:59:08] the module is just called "php" [07:59:15] oh it might be php7.3 [08:01:03] in fact module 7.3 is already installed. a2enmod and then entering php gives "ERROR: Module php does not exist!" [08:01:21] i don't see it on the list [08:01:47] I'm ok with reinstalling everything from scratch [08:02:04] Have no data stored anywhere [08:06:36] mediawiki: I mean did you try a2enmod php7.3 ? [08:14:24] Hello, good morning. [08:16:22] I wanted to make a blog style page. I thought I could use categories for grouping blog style entries. Is there a way to get get MW to write full date instead of just '2' for 20200803? [08:16:26] https://wiki.tnonline.net/w/Category:Blog [08:17:36] ok, I was disconnected after my last message [08:18:12] I guess I will reinstall mediawiki from scratch and try again [09:59:45] Hi. Is it possible to change the title of a page without changing the URL? For example "Forza's Blog" but url should be /Blog. At the moment I chose to have a redirect, but that isnt as neat. [10:00:43] !displaytitle [10:00:43] See . [10:02:16] Reedy: Thanks! [10:06:25] Worked great. Thanks =) https://wiki.tnonline.net/w/Blog [10:06:48] Any tips on "blogging" using MW? [10:11:47] Forza: There are some extensions that structure the page more like a blog. This is one example: https://www.mediawiki.org/wiki/Extension:BlogPage [10:13:15] An example of that extension: https://es.ssbwiki.com/wiki/Blog:Timeman/El_Rinc%C3%B3n_de_Eric_-_Volumen_16?uselang=en [10:14:00] I'm tempted to say it's a great extension but I'm only sliiiiiiightly biased ;-) [10:14:27] lol [10:25:22] ashley: :D [10:25:32] Iäve seen that site before, but it seems so busy to me [10:28:00] So I think this is the result of that page: https://es.ssbwiki.com/wiki/Categoría:Blogs/Timeman [10:28:11] Not any difference than current MW. [10:28:59] Is it possible to change so that category pages contain more than just a letter or a digit? For example on that page, everything is under "T" [10:29:44] I have the same here: https://wiki.tnonline.net/w/Category:Btrfs - just a single letter for each grouping. It would be lovely to be able to have a date (or just number 20200803) for grouping [10:40:47] This seems like it could do: https://followthescore.org/dpldemo/index.php?title=DPL_Example_005 [11:29:52] I went with this: https://www.mediawiki.org/wiki/Extension:DynamicPageList_(Wikimedia) Almost what I wanted, but close enough :) [11:58:20] This is how it looks. https://wiki.tnonline.net/w/Blog [16:49:13] Hi, I'm trying to install mediawiki. I'm running lighttpd and have successfully managed to enable PHP-FPM so when i load my onion url for the site I want to host, it brings up the index.php I wrote perfeclty fine now instead of giving me an error 503 [16:50:08] but now, whenever I try to access the mediawiki directory inside that directory, it gives me an error 403 [16:50:57] I downloaded the mediawiki tar.gz using wget, untarred it and placed it in /var/lib/mediawiki [16:51:15] oh, hang on, that might be it...one moment [16:55:49] ahah! that *was* it! [16:56:35] I mistakenly symlinked the mediawiki directory so everything was 1 directory deeper than it should've been [16:56:54] nevermind :) [16:56:57] problm solved [18:26:20] Hi, I'm trying to setup mediawiki and I'm running mariadb for my database. I'm on the first few pages of the config script and it's asking me for my database user ID and database password. I set up a database user like it said to in the guide at https://www.mediawiki.org/wiki/Manual:Running_MediaWiki_on_Debian_or_Ubuntu [18:26:35] but I didn't set a password for the database [18:27:13] yet even so, it keeps giving me an error when i try to advance to the next page and it says access denied for the specified user [18:34:32] hi all [18:34:48] trying to backup my mediawiki db but getting following [18:34:59] mysqldump: Got error: 1932: "Table 'wiki.text' doesn't exist in engine" when using LOCK TABLES [18:35:08] any ideas? [18:35:41] repair fails as its InnoDB [18:35:42] wiki.text [18:35:42] note : The storage engine for the table doesn't support repair [18:35:52] on mysql/mariadb 10.x [18:47:23] Hello :) [18:48:47] I'm using https://m.mediawiki.org/wiki/Extension:DynamicPageList_(Wikimedia) and use the [18:49:27] But it seems that the list only updates if I re-save the page. Is there a way to avoid that? Perhaps cron? [18:58:54] Hi, I'm installing mediawiki and I'm on the first part of the config script where it says to specify the database user and the database password [18:59:30] I setup the database acording to the guide here: https://www.mediawiki.org/wiki/Manual:Running_MediaWiki_on_Debian_or_Ubuntu [18:59:45] but for some reason it's not being granted access [19:00:00] any idea what's getting in the way? [19:07:15] Did you add the user on the database first? [19:08:03] Sometimes you have to add 'new_mysql_user'@'127.0.0.1' instead of just 'new_mysql_user'@'localhost' [20:07:42] Forza: I did GRANT ALL ON my_wiki.* TO 'new_db_user'@'localhost'; [20:07:50] and it said the query went ok [20:08:09] does that not add the user to the database? [20:10:46] One weird thing is that the database root password I set isn't needed if I'm root of my machine. If I'm the pi user on my raspberry pi and I enter the root password when trying to login to mariadb as root database user, even if I enter the password i set for it, it denies access [20:11:06] I think there might be something wrong with the mysql, I'm not sure [20:16:15] burning: no, you need to explicitly create the user [20:16:34] on my phone but of i remember correctly the syntax is [20:17:10] CREATE USER 'username_here'@'localhost' IDENTIFIED BY 'password_here'; [20:17:32] ik, I did that before the command I just posted [20:17:42] sorry for not being clear enough on that [20:19:29] I followed the instruction in the SQL section on this guide: https://www.mediawiki.org/wiki/Manual:Running_MediaWiki_on_Debian_or_Ubuntu [20:22:54] burning: the problem is that mysql might see php connecting from an ip instead of localhost. That's why I said you could add the ip 127.0.0.1 [20:23:23] ah, I am configuring it all for an onion site, so that might be the case [20:23:28] I'll give that a go [20:24:11] :) [20:27:27] just to clarify, you mean I should try CREATE USER 'my_db_user'@'127.0.0.1'IDENTIFIED BY 'password'; ? [20:27:42] :) [20:28:55] @localhost specifically, not 127.0.0.1 [20:29:03] the difference matters [20:29:12] (sadly) [20:29:18] oh? [20:29:38] I thought they were saying that typing @'loalhost' is what caused the problem? [20:29:45] because that's what I did the first time [20:30:13] on linux systems, connecting to mysql via 'localhost' uses a unix domain socket like /var/lib/mysql.sock (forgot the exact path, but it varies by distro anyway). 127.0.0.1 ACL entries will only ever be used if you tell the mysql client to connect over tcp instead [20:30:32] you did a GRANT ALL, but if the user didn't already exist then that GRANT wouldn't have done much [20:30:41] the user did exist already [20:30:48] I did the GRANT ALL after I made the user [20:30:58] k [20:31:01] and after I made the database [20:31:17] (that part isn't relevant, mysql lets you grant privileges to databases that don't exist yet) [20:31:40] let's do a bit more debugging: on the mediawiki side of things when you put in the username and password, what is the error message? [20:31:46] I just followed the *configuration mysql* section at https://www.mediawiki.org/Manual:Running_MediaWiki_on_Debian_or_Ubuntu [20:31:57] I'm assuming you're stuck at the web installer here [20:32:06] oh that's interesting, I didn't know that about granting privs [20:32:12] yeah, that's right, I am [20:32:19] one sec [20:36:23] Cannot access the database: :real_connect(): (HY000/1045): Access denied for user 'PAMS_WIKI_db'@'localhost' (using password: NO) [20:36:43] Hi guys, I have StructuredDiscussions installed and I want to turn it of on a namespace. I read Enabling or disabling StructuredDiscussions and also https://www.mediawiki.org/wiki/Extension:StructuredDiscussions/Turning_off_all_StructuredDiscussions. But It's not working. How can I turn off the extension if I don't want anymore to use it? [20:37:04] I tried setting the database host to 127.0.0.1 like it recommended but that just gives an identical error [20:37:18] Is this on the command line? [20:37:28] Or is that in the installer? [20:37:36] It sounds like you didn't put a password into the form... [20:37:41] installer [20:38:01] keep it with localhost, but it sounds like you omitted the password (as Reedy mentioned) [20:38:15] and I didn't put the password into the installer because I never set a password for my database because the I just followed the guide I posted earlier [20:38:28] the password for the user account [20:38:42] aka the password for PAMS_WIKI_db [20:38:48] strange, I tried the password for the user account even though i was working under the assumption the password wasn't for the user [20:38:53] maybe let's back up a step [20:39:11] I thought it said in the little help? box that the password *wasn't* for the user? [20:39:13] go into a mysql command line and run SELECT Host, User from mysql.user; [20:39:33] put the output in a pastebin like https://dpaste.de and link it here [20:39:38] done. It lists two users. root and PAMS_WIKI_db [20:39:43] ok [20:39:52] what's the host entry for PAMS_WIKI_db [20:39:59] (copy/paste the full line, don't retype) [20:40:09] k, one sec. brb [20:40:12] part of this is a typo check :) [20:41:10] Did we upset them? [20:42:32] Sorry, what was the last thing you said I should do? [20:42:50] I had irssi open outside of an X session so I wasn't able to c&p but now I should be able to [20:43:44] go into a mysql command line and run SELECT Host, User from mysql.user; [20:43:52] reason I asked for copy/paste was to check for typos :) [20:44:03] you just need to do the one line with PAMS_WIKI_db [20:44:11] ofc, one moment :) [20:44:22] PAMS_WIKI_db [20:44:41] did you run the exact command I specified? [20:44:45] there should be a host as well [20:45:10] oh, sorry I ran select User, Host from mysql.user; earler and took the output from that [20:45:18] one sec [20:45:49] localhost | PAMS_WIKI_db [20:46:02] great [20:46:14] next comman: SHOW GRANTS FOR PAMS_WIKI_db@localhost; [20:46:35] (if the response has a password in it, please redact that before posting here) [20:46:56] | GRANT USAGE ON *.* TO `PAMS_WIKI_db`@`localhost` IDENTIFIED BY [20:46:56] PASSWORD '*EFB02C995E96D3D202AA45579DBA7DE26D953872' | [20:47:05] that's the only line? [20:47:26] no, for some reason it posted half of it when I pasted it [20:47:36] sorry about that [20:47:44] I'll change that password after this [20:47:49] I meant there's only the GRANT USAGE and no other lines? [20:48:28] I'll paste the 3rd line, hang on [20:48:45] GRANT ALL PRIVILEGES ON `pams_wiki`.* TO `PAMS_WIKI_db`@`localhost` [20:49:03] ok [20:49:14] and pams_wiki is the name of your database, and the database exists? [20:49:24] yes [20:49:37] if i do SHOW DATABASES; it lists it among them [20:50:03] the database is called pams_wiki [20:50:11] the database user is called PAMS_WIKI_db [20:50:12] everything looks in order then. What I'd suggest then is changing the password for PAMS_WIKI_db@localhost via ALTER USER PAMS_WIKI_db@localhost IDENTIFIED BY 'new password'; [20:50:25] thanks, I'll do that now [20:50:32] then on the installer, use localhost as the hostname, PAMS_WIKI_db as the username, that new password as the password, and pams_wiki as the database name [20:52:08] (for avoidance of doubt, the single quotes around 'new password' are required, but are not part of the password itself, for example if you specified IDENTIFIED BY 'correcthorsebatterystaple' then the password to put into the installer is correcthorsebatterystaple -- without the quotes) [20:52:17] ok, thanks I'll try the installer again [20:52:30] and thanks, haha, I was aware :) [20:52:51] and nice xkcd reference [20:52:55] ;) [20:53:00] we get all levels of technical know-how here, so I tend to be a bit cautious unless told otherwise :) [20:53:26] was not meant as any slight or insult to your capabilities [20:54:40] oh of course! I wasn't offended in the slightest :) [20:55:07] and my technical knowledge is far from intermediate tbh. I'm still a beginner for the most part [21:00:47] ok, I just tried it again using the new password [21:01:00] but I get the exact same error [21:01:38] Cannot access the database: :real_connect(): (HY000/1045): Access denied for user 'PAMS_WIKI_db'@'localhost' (using password: YES). [21:04:28] burning: weird, run FLUSH PRIVILEGES; as root in the mysql prompt then try again [21:05:31] and the sanity check: verify that the web server and db server are running on the same host. If they're two different servers, then localhost is obviously not pointing to the right spot [21:07:04] they're both an rpi I think ;) [21:08:06] different servers can also mean different containers if you're running the webserver and database in separate docker containers [21:08:17] Skizzerz: I did have to add a grant for user@127.0.0.1 on my setup the other day. After install I changed it to socket, but wouldn't work as that during install [21:08:45] Ah [21:08:49] I've sorted the problem [21:09:00] :) what is it [21:09:03] what was it, if you don't mind sharing? [21:09:24] The initial fix of changing the password worked fine. I just needed to restart the services/reboot the server [21:09:36] ah [21:09:44] sometimes it really is simple [21:09:47] that's what FLUSH PRIVILEGES would have done as well (without needing the restart) [21:09:55] ah, crap [21:09:58] I thought FLUSH PRIVILEGES was "deprecated" [21:10:01] is it? [21:10:03] /advised against [21:10:07] I'm sure the guides say not to [21:10:27] >Privileges assigned through GRANT option do not need FLUSH PRIVILEGES to take effect - MySQL server will notice these changes and reload the grant tables immediately. [21:11:22] right, but it's possible the password alteration needed it [21:11:25] Hey guys does anyone have experience with StructuredDiscussions and know how to can deactivate it for a namespace after you activate it? [21:11:26] Is that true on mariadb too [21:11:48] Basically the same AFAIK [21:12:01] burning: the reboot does the same thing, just overkill. basically getting a bigger hammer [21:12:27] lol, fair enough :P [21:12:42] I'm pretty sure I had to do the flush on my setup and I'm running mariadb 10.4.13 [21:12:45] for some stuff, it's easier [21:12:54] Thanks for the help guys :) [21:13:27] Glad you got it to work [21:14:07] me too frankly [21:14:30] I posted a question earlier about Dpl and if there needs to be a cron or something for dynamic lists to update? Any ideas? [21:14:46] Job queue? [21:15:13] I was stuck on why all php files threw error 503 for like a week before I found out I just needed to enable php-fpm. So glad to be past that now [21:15:21] I'll look, Reedy [21:16:28] DPL shouldn't need a cron or job queue. I believe it refreshes whenever the parser cache updates, so you would need to purge the page or do a null edit for a refresh [21:16:48] Reedy: right i have it set once an hour. That would explain it [21:16:55] * Skizzerz strongly recommends against disabling the parser cache, it absolutely kills performance [21:17:17] ah, some parts would rely on job queue too [21:18:13] I'm thinking a job would be needed or it might be slow to fetch data from many pages [21:18:34] like if you changed a page's categories, the actual update of what pages are in which categories are done via job queue [21:18:52] and DPL would be fetching stale data until that job finishes [21:19:34] Can i trigger this refresh with a link ? Edit and save the post works ,is that what you mean by null edit ? [21:19:53] but the parser cache is also potentially impacting you: DPL does not update every time you refresh the page to avoid killing server performance (although I believe 3rd party DPL supports a mode that disables the parser cache for the pages it's used on) [21:19:58] I'm on the name section of the install script, what exactly is it talking about when it refers to namespaces? [21:20:12] "the project namespace" [21:20:15] burning: https://www.mediawiki.org/wiki/Help:Namespaces [21:20:16] Basically https://wiki.tnonline.net/w/Blog [21:20:23] ah, right. thanks [21:20:38] you can give the Project namespace a different name in addition to Project: [21:20:46] for example, wikipedia uses Wikipedia: as the project namespace [21:21:01] So my idea is that i add new blog posts and they should come up on that list [21:22:15] Skizzerz: i might look at tge forked dpl if its more real-time as such [21:22:48] well you have two issues potentially: job queue not running often enough, and parser cache keeping stale versions up [21:23:00] Would there be any harm in running cron jobs every 5 min or so? [21:23:03] I really really REALLY do not recommend disabling parser cache, it will slow your wiki to a crawl [21:23:14] none whatsoever, I run my job queue via cron every minute [21:23:18] and just to clarify, the project namespace is just the specific namespace for meta discussion about the development of the wiki? [21:23:36] burning: that's the intent, but you can invent whatever rules you'd like to about what namespace gets used for what purpose [21:23:42] it's your wiki after all :) [21:23:49] thanks :) [21:23:52] Forza: https://www.mediawiki.org/wiki/Extension:DynamicPageList_(Wikimedia)#Configuration [21:23:58] Skizzerz: how slow /fast compared to now ? It's instant for me, but it's local [21:24:01] you can tweak the parser cache TTL ia a setting [21:24:38] why does it say $1 though? as if it's going to charge me $1 for making it the same name as my site? [21:24:46] :P [21:24:55] $1, $2, $3, etc. are placeholders [21:24:58] ah [21:25:07] was wondering what it meant [21:25:09] thanks [21:25:22] generally you'll want to leave them as-is, because the software will replace it with whatever is supposed to go there [21:25:33] Ha ha its MW tax [21:26:09] Forza: proper caching gives page load times of maybe 100ms or less (has a lot of variables), compared to a lot longer than that if it has to re-parse the page from scratch every pageload (especially if the page is big or uses lots of templates) [21:26:34] once your site gets to be perceived as slow enough, your bounce rate will skyrocket [21:26:50] because nobody likes waiting on sites to load [21:27:23] Yea .that's why i don't understand WordPress .goes do slow very quickly [21:27:52] anyway see the link I gave, there's a config var that lets you control how long a page is kept in cache when DPL is in use on it [21:27:58] default is 1 day but you can reduce that [21:28:01] I only do opcache and php-fpm so far .do you think it's slow ? [21:28:21] Skizzerz: i saw it $wgDLPMaxCacheTime [21:28:47] getting a memory cache will help you a lot [21:28:56] (e.g. redis, memcached, or apcu) [21:29:50] Isn't opcache replacing apcu [21:29:57] no [21:30:03] opcache replaced half of old APC [21:30:07] apcu replaced the other half [21:30:42] opcache is an opcode cache, aka it saves the compiled versions of your php scripts so php doesn't need to recompile the code every request [21:31:21] apcu is a user-level cache, the application can tell it to store arbitrary values in memory that persist between requests, such as objects that take a long time to construct (perhaps because they require db queries) [21:31:58] redis and memcached serve the same purpose, but are disassociated with your php-fpm process so your cache doesn't die everytime php-fpm restarts [21:31:59] I thought fpm retained data. [21:32:37] no, fpm just runs php separately from the webserver so you don't have to pay php startup/initialization costs on every request unlike other sapis like mod_php [21:32:56] (things like reading php.ini, loading php extensions, etc.) [21:33:10] Right .thanks for explaining [21:33:32] I do have redis set.i forgot i set it :( [21:33:48] there's a manual on mediawiki.org; it's not a super straightforward process unfortunately [21:34:08] https://www.mediawiki.org/wiki/Redis [21:34:17] https://paste.ee/p/GPPP5 [21:34:33] That's my conf [21:34:54] ah [21:35:02] then you should already be using it :) [21:37:42] :) i remember know that i wasn't sure redis should be used for all things ? [21:39:26] sure? It's probably one of the better options for mediawiki memory caching [21:40:56] I mean rows 6-10 [21:41:22] Is it worth using it for all types of objects [21:45:35] only way to know for sure is to measure tbh; I think Wikipedia uses it for basically everything but their infrastructure setup is also wildly different from yours so being a copycat doesn't necessarily mean it's the best choice [21:49:40] heya, I'm setting up the email portion now. Is the return email address what users will see the email address as when they want to reset their passwords etc? [21:50:49] And I haven't touched PHP's mail settings yet, is it normally ok by default? Or am I going to have to mess with it a bit to allow authorised editors only? [21:52:20] Skizzerz: true . I'm happy with the speed so far [22:06:56] So, do i need to setup an email server if i want to enable authorised editing? Or does mediawiki sort that all out for whatever Return email address i set? [22:07:14] or do i need to have the valid return email address setup before I tell mediawiki what it is? [22:16:33] You can set email up late [22:16:33] r [22:17:56] oh ok, so does it matter if i've changed the contents of the field already and should I realoat the page before moving on? Or will it be alright for now and i can just deal with that later? [22:18:24] the values you set will end up in LocalSettings.php [22:18:42] oh cool, I can just change that later on then