[00:54:59] I broke my wiki. Anyone around got time to help me out? [01:01:51] ShadowReine: what error message do you see? [01:02:27] Attempting to restore a backed up wiki from one system onto another, appears to be a MAMP versioning issue: Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; FakeConverter has a deprecated constructor in /Applications/MAMP/htdocs/wiki/languages/Language.php on line 35 [01:02:28] Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; DBObject has a deprecated constructor in /Applications/MAMP/htdocs/wiki/includes/db/Database.php on line 2405 [01:02:29] Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; ResultWrapper has a deprecated constructor in /Applications/MAMP/htdocs/wiki/includes/db/Database.php on line 2759 [01:02:30] Fatal error: Uncaught TypeError: Argument 1 passed to wfReportException() must be an instance of Exception, instance of Error given, called in /Applications/MAMP/htdocs/wiki/includes/Exception.php on line 348 and defined in /Applications/MAMP/htdocs/wiki/includes/Exception.php:285 Stack trace: #0 /Applications/MAMP/htdocs/wiki/includes/Exception.php(348): wfReportException(Object(Error)) #1 [internal function]: [01:02:31] wfExceptionHandler(Object(Error)) #2 {main} thrown in /Applications/MAMP/htdocs/wiki/includes/Exception.php on line 285 [01:11:50] Did that get through? [01:12:33] ShadowReine: ended in "Exception.php on line 285" [01:12:36] so I guess it did [01:12:42] Okay. [01:13:06] update mediawiki? [01:14:11] I’m trying to get Mediawiki to load the database from my old comp, fresh installs of MAMP and Mediawiki. [01:17:10] So…any thoughts at all? I rather need this working :/. [01:18:52] which mediawiki version is this? [01:19:07] seems you are using an old mediawiki with a modern php [01:19:36] I think there are some people which also had the same problem https://www.mediawiki.org/wiki/Topic:Tazthc8drqv4sexr [01:19:54] I don't know what MAMP is, but it could be bundling an old mediawiki version, too [01:19:57] I thought I downloaded and installed the most recent version. [01:20:11] although bundling a version incompatible with itself seems silly... [01:20:20] Can somebody give me the most recent number to verify? [01:20:32] 1.30.0 [01:20:41] released a month ago [01:20:51] Okay, I am not using the most recent version. Let’s try that fix. [01:21:14] I must have somehow navigated to a bad page. [01:21:34] Oh wait, that’s not where I’m looking…but let’s reinstall anyway. [01:24:43] Oh, I see the problem. What it’s trying to restore is the entire wiki, I just need the database. [01:25:18] Anyone know of a good walk through for that? [01:27:08] Sorry to be so difficult. My usual superuser is too busy to help. [01:38:11] Help? This is like…some of my business’ important data and such. [01:48:11] Okay, I tried moving just the wiki database to the new mysql and running update.php. Still getting database connection refused. [01:55:02] Okay, apparently…I need to get a copy of 1.5. [01:55:20] Wait no. [01:56:04] I wonder what this actually means as it’s telling me to update to a newer version than the version. [01:56:57] Okay. So, I think the problem is I can’t one step upgrade from 1.16 to 1.3. Is that correct, and if so what interim version should I get? [02:01:30] Ugh. Apparently tonight is a bad time to get help. [02:05:04] Oh, I see, 1.5 means 1.05, so it SHOULD have worked. [02:06:38] *tries sudoing* [02:07:15] Nope. [02:15:57] Hrm. Let’s try doing it this way… [02:17:19] Ugh. I can’t remember the database username. [02:20:02] Is there a way to retrieve it? [02:22:57] Crap. I found it in localsettings, but it doesn’t say it’s valid. [02:23:30] I can’t lose my entire wiki. I can’t. That’s like…too much. [02:27:46] I really need help :/. [02:33:23] Maybe doing a reconfig with an existing database isn’t actually possible? [02:40:32] Oh well. Apparently no help to be had tonight, no help to be had on the internet in general... [03:07:39] ShadowReine: resetting the database pass is easy if you have root access [03:08:10] oh username [03:08:10] uh [03:08:22] True, but the thing is, I know the username and password are correct, so I think something else is going on. [03:09:03] uh, networking enabled? using the permission table enabled? [03:09:35] It’s all local. [03:24:06] I got some help except for not being able to find where MAMP puts mysqldump [03:29:10] *throws things* It’s telling me the mysqldump command is not found when I can SEE it right there. [03:36:30] Hopefully I’m making progress. [03:54:37] Nope. Made a dump, transferred it, tried to extract, not taking the password I *used to make the dump* [04:03:34] I…gods…I wish MediaWiki wasn’t so useful right now. [04:25:51] …I give up. NOTHING is making this work. [04:27:55] ShadowReine: 1.16 -> 1.23 (on PHP 5), then upgrade to PHP 7 and do 1.23 -> 1.30 [04:27:59] note that 1.30 is not the same as 1.3 [04:28:07] think of the . as a separator, not a decimal point [04:28:14] there are 27 versions between 1.3 and 1.30 [04:28:45] MAMP. [04:29:04] I have no clue what PHP version I have, and I am not trying anything but MAMP, did THAT before. [04:29:12] also not using macOS is probably going to be helpful in this endeavor [04:29:26] Well, that’s what I have. [04:30:02] the thing is, if your MAMP has PHP 7, old versions of mediawiki (e.g. 1.16) will straight-up not work [04:30:18] if that's the case, you'll need to install an older version of MAMP to proceed [04:30:27] I dumped the DB and reloaded it. [04:30:34] k [04:30:46] I am not trying to use 1.16. [04:30:52] what version is the database currently at? [04:30:54] I am trying to use 1.30. [04:31:02] 1.30, in theory, I ran update and everything. [04:31:11] and update.php succeeded? [04:31:24] It didn’t fail. [04:31:33] ...right [04:31:52] Well, that’s all I can tell. I ran it, it didn’t error out. [04:31:55] so you updated the database, you have the 1.30 files accessible from the web, so what's the problem? [04:32:05] It can’t connect to the database. [04:32:07] at this point, since the problem described earlier seems to no longer be valid? [04:32:11] ok [04:32:15] can YOU connect to the db as root? [04:32:41] Not quite sure how to do that. [04:32:47] running mysql as sudo should do the trick [04:32:49] in terminal [04:32:56] sudo mysql -uroot [04:33:14] Root isn’t enabled. Hold on. [04:33:26] you don't need the root account enabled in macOS [04:33:43] there's a root user in mysql which is separate from the root account, and sudo should work even with the root account disabled [04:33:52] if you really need to enable it though, I guess go for it [04:33:55] Well, the error I’m getting when I try to do that is “access denied for user ‘root’@‘localhost’ [04:34:03] ok, hmm [04:34:26] I’ve been banging my head against this for hours, tried all sorts of things and everything coes back to “Cannot connect to database” [04:34:31] try sudo mysqladmin -u root password SOMETHINGHERE [04:34:38] that will reset the root mysql password to SOMETHINGHERE [04:34:46] then you can log in with mysql -uroot -p [04:34:48] I know the root mysql password [04:34:51] and type SOMETHINGHERE in the password prompt [04:34:51] oh [04:34:53] Aha. Okay. [04:35:08] I needed the -p [04:35:15] That got me to a mysql prompt [04:35:18] awesome [04:35:41] So, what does that tell us about the issue? [04:36:08] now do SELECT user, host FROM mysql.user; [04:36:23] check to see if the user set in LocalSettings.php is listed in there or not [04:37:11] (the semicolon at the end is important, otherwise it'll keep prompting you with new lines) [04:37:32] Not. [04:37:40] ok [04:37:44] Hold on, let me try something. [04:37:55] now type CREATE USER username IDENTIFIED BY password; [04:38:04] where username and password match the username and password in your LocalSettings.php [04:38:40] after that, type GRANT ALL ON wikidb.* TO username@localhost; (where wikidb is the database name, and username is the user you just created -- leave localhost as is) [04:38:49] ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'jrpwikipass' at line 1' [04:38:57] hmm [04:38:58] oh [04:38:59] Oops. Ah well. [04:39:07] maybe CREATE USER username@localhost IDENTIFIED BY password; ? [04:39:13] I forgot the host bit [04:39:28] and password probably needs to be quoted in single quotes [04:39:36] e.g. if your password is blah, IDENTIFIED BY 'blah'; [04:40:15] (going from memory here, which is spotty sometimes :P) [04:40:16] That was the problem. [04:40:34] ok now run that grant statement [04:40:44] Done. [04:40:49] and then try running the update.php maintenance script one more time for good measure (type exit; to leave the prompt) [04:41:10] Okay... [04:41:17] after that try loading up your wiki [04:41:22] Nope. [04:41:33] same error? [04:42:06] or what's the error message on the wiki? [04:42:08] Yup. [04:42:21] the exact message (don't need stack traces, just the message) [04:42:27] Cannot access the database: Connection refused [04:42:35] ok [04:42:50] in your LocalSettings.php what is your database host set to? [04:43:07] You mean the database name? [04:43:09] $wgDBserver [04:43:16] 127.0.0.1 [04:43:23] try making it 'localhost' instead [04:44:12] That changed the error. [04:44:13] MediaWiki internal error. [04:44:13] Original exception: [3f1407dbe5a1330a9e9a5d68] 2018-01-13 04:44:01: Fatal exception of type "Wikimedia\Rdbms\DBQueryError" [04:44:14] Exception caught inside exception handler. [04:44:15] Set $wgShowDBErrorBacktrace = true; at the bottom of LocalSettings.php to show detailed debugging information. [04:45:12] ok do what that says (add $wgShowDBErrorBacktrace = true; to LocalSettings.php at the bottom) [04:45:49] that will create a lot of output [04:46:10] It did. [04:46:12] you should pastebin it somewhere (such as https://dpaste.de ) [04:48:07] It’s pretty much saying I didn’t run update.php. Except I did, twice. [04:48:22] yeah but you ran it back when the db settings were messed up in LocalSettings/the db [04:48:25] now run it again a third time [04:48:38] it should count down from 5 seconds and then say "applied blah to blah" about 250 times [04:49:14] Nope, it’s erroring. [04:49:19] update.php is? [04:49:24] [00e2497d1ef4e985893de486] [no req] Wikimedia\Rdbms\DBConnectionError from line 800 of /Applications/MAMP/htdocs/wiki/includes/libs/rdbms/database/Database.php: Cannot access the database: No such file or directory (localhost) [04:49:25] Backtrace: [04:49:26] #0 /Applications/MAMP/htdocs/wiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1028): Wikimedia\Rdbms\Database->reportConnectionError(string) [04:49:28] #1 /Applications/MAMP/htdocs/wiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php(670): Wikimedia\Rdbms\LoadBalancer->reportConnectionError() [04:49:29] #2 /Applications/MAMP/htdocs/wiki/includes/GlobalFunctions.php(2858): Wikimedia\Rdbms\LoadBalancer->getConnection(integer, array, boolean) [04:49:31] #3 /Applications/MAMP/htdocs/wiki/maintenance/Maintenance.php(1253): wfGetDB(integer, array, boolean) [04:49:32] #4 /Applications/MAMP/htdocs/wiki/maintenance/update.php(146): Maintenance->getDB(integer) [04:49:33] don't paste the stack [04:49:34] #5 /Applications/MAMP/htdocs/wiki/maintenance/doMaintenance.php(92): UpdateMediaWiki->execute() [04:49:35] #6 /Applications/MAMP/htdocs/wiki/maintenance/update.php(249): require_once(string) [04:49:36] #7 {main} [04:49:37] Yes. [04:49:40] Sigyn doesn't like that [04:49:46] My apologies. [04:49:57] (Sigyn is a bot that will automatically ban you from freenode if you're too spammy) [04:50:52] that error seems nonsensical :( [04:50:54] So, what the heck do I try now? [04:51:01] try the web updater [04:51:14] go to /mw-config in your wiki [04:51:27] e.g. if your wiki is localhost/wiki/index.php, then go to localhost/wiki/mw-config/ [04:51:47] it may ask for an upgrade key, if so, copy/paste it from $wgUpgradeKey in LocalSettings.php [04:51:56] (just the value inside the quotes, not the full thing) [04:52:23] Safari cannot connect to the server “localhost" [04:52:36] Oh, wait, duh. They changed something I keep forgetting. [04:52:38] that was an example, you'll need to set the URL appropriately for your install [04:54:09] if that STILL doesn't work, you may need to modify your php.ini file [04:54:35] That gave me a blank database. I mean, wiki is running, no data present. [04:54:56] uh [04:55:06] The database is still, like, present. [04:55:08] ??????? [04:55:19] like a blank white page with no content? [04:55:21] But all I get on the main page is “MediaWiki has been installed." [04:55:27] No, the default for there is no database. [04:55:42] hmm [04:55:43] ok [04:55:59] let's try to figure out the socket thing then [04:56:10] I think it just hates me :P. [04:56:25] Last time I had to transfer my wiki it was bad, but I am pretty sure it wasn’t THIS bad. [04:56:27] look in your MAMP install for the file my.cnf [04:56:53] might be something like /Applications/MAMP/mysql/my.cnf [04:57:01] Found it. [04:57:12] near the top of that file, there should be a line that says socket = /something/goes/here [04:57:26] copy or make a note of that socket path [04:57:33] then close the file [04:57:42] (you aren't changing anything there) [04:57:45] okay. [04:57:52] then go to your php.ini file [04:58:43] look for the lines mysql.default_socket and mysqli.default_socket [04:58:52] Okay, so…MAMP has…ugh *pokes at it* [04:58:52] and set the value for each of them to that path you copied from my.cnf [04:59:14] Like 50 php versions in it. [04:59:20] uh [04:59:36] that seems odd [04:59:50] but not insurmountable [05:00:01] from the terminal, do php --version [05:00:14] that will tell you what version of PHP is in use when you try to run the update.php script [05:00:25] Faster way to do that in mamp, I found it ;). [05:00:29] ah [05:01:15] after you modify those two lines in php.ini, try running the update.php script one more time, and hopefully it'll work [05:01:32] if it does work, restart apache (so that apache can pick up on the changes too) and your wiki should now be accessible [05:01:37] It’s already set to that. [05:01:43] hmm [05:01:52] I think your computer just hates you [05:01:56] “Sorry, I’m this like hideous bug magnet. [05:02:26] still do the php --version thing then in terminal [05:02:29] Unfortunately, giving up is not an option. [05:02:30] just to make super sure that it's the same [05:03:26] Nope. Same result. [05:03:40] sigh [05:04:18] ok lets try something else [05:04:25] change $wgDBserver back to 127.0.0.1 [05:04:30] then go and edit that my.cnf file again [05:05:17] Didn’t change anything. [05:05:19] look for a line that says skip-networking [05:05:25] if you find it add a # in front [05:05:30] (to comment it out) [05:05:49] also make sure you have a line that starts with bind-address [05:05:55] if you have it, ensure it's set to 127.0.0.1 [05:06:06] if you don't, add it in: bind-address = 127.0.0.1 [05:06:16] put it in the [mysqld] section near the top [05:06:21] skip-networking is already commented out. [05:06:37] and double-check port is 3306 [05:06:52] if all of that is already set, try restarting mysql and then running update.php again [05:07:04] if it still says "connection refused" then something really weird is going on [05:07:39] Connection refused. [05:07:46] You have to understand. [05:07:54] I will find bugs that happen to nobody else out of MILLIONS of users. [05:08:13] this is a config issue [05:08:19] not a bug [05:08:28] I just can't figure out where the config issue *is* [05:08:36] Because it’s somewhere weird because it’s me. [05:08:51] is copying the database to a different server not an option? [05:08:59] It is not an option. [05:09:12] k then [05:09:26] in your terminal, msyql -h127.0.0.1 -uroot -p [05:09:32] see what that spits out [05:09:41] er [05:09:42] mysql* [05:09:44] I typoed :P [05:09:56] It’s fine, I read what you meant. Now that gives can’t connect. [05:10:18] check your firewall settings [05:10:23] It’s all local. [05:10:26] yes [05:10:32] check them anyway [05:10:38] ensure that everything on the loopback interface is allowed [05:11:06] Meaning? Mysqld is allowed. [05:11:10] (I cannot assist with exactly how to go about doing that) [05:11:14] meaning *everything* [05:11:17] Which is the only thing it asked. [05:11:18] loopback shouldn't be restricted [05:11:29] There’s no loopback option. [05:11:35] hmm [05:13:09] database and tables is on it really? [05:14:07] I will note that the firewall settings are identical to the old system so it seems unlikely they’d be causing difficulties. [05:14:28] ShadowReine: oh does MAMP have a UI thing? [05:14:39] It has some UI stuff. [05:14:52] if so look at the mysql settings there [05:15:04] ensure that if there is a setting like "Allow local access only" that it is NOT checked [05:15:05] It has phpMyAdmin [05:15:13] that's irrelevant [05:15:39] ok so no on the UI [05:15:45] in the directory where you found your my.cnf file [05:15:58] No web UI to acces mysql settings, no…oh wait. Hold on. [05:16:40] It shows mysqli and mysqlnd [05:16:48] that's PHP stuff [05:16:54] but that's ok [05:17:01] in there does it have an entry for ports? [05:17:06] if so, ensure that it is set to 3306 [05:17:13] and in your my.cnf, ensure that the port is set to 3306 [05:17:33] if you needed to edit my.cnf, restart the mysql service [05:18:13] Port is correct in my.cnf [05:20:53] ok at this point I'm out of ideas. My only recommendation is to restore it to a different server. Failing that, completely uninstall and reinstall MAMP (make a backup of your database first using mysqldump) [05:21:20] It’s a freaking completely fresh install and I do not have another server to restore it to. [05:22:08] so get one? Quite a few providers offer trials for 30 days or whatnot [05:22:31] or try installing the stuff outside of using MAMP, idk [05:22:47] Can’t add another bill, and doing it outside of MAMP in MacOS is…welp…not something a sane person would do. [05:23:39] But if you’re stumped you’re stumped, thanks for trying. [05:30:28] ...wait. [05:30:42] …okay, this is…this is JUST the kind of thing that happens to me. [05:30:52] Somewhere in the dump and restore process? The dang thing added a database prefix. [05:31:53] I thiiink. [05:34:02] Yup. [05:34:06] I never set a prefix. [05:34:12] It’s not what I would have set as a prefix. [05:34:16] Gremlins, I tell you. Gremlins. [12:24:14] Hello. I have now installed Extension:ConfirmAccount and made a test request for an account. This isn't showing up for my normal sysop-level user. Do I need to make myself Bureaucrat for the new account request to show up? [12:27:49] jubo2: looking at the extension's page, I see there's a special permission for that only available to bureaucrats by default: "As a bureaucrat (or other user with the confirmaccount permission), browse to Special:ConfirmAccounts" [12:33:02] Vulpix: Going to Special:ConfirmAccounts there is no button to confirm account so I need to add myself to the bureaucrat group or otherwise give confirm account rights [12:34:13] jubo2: yes, that's what the extension page says [12:35:37] I use this.. seems most risk free option https://www.mediawiki.org/wiki/Manual:CreateAndPromote.php [12:38:07] jubo2: yes, that's a good way to promote yourself to some user group [12:38:42] I run 'php createAndPromote.php --bureaucrat --sysop --force Jukeboksi' and it replied "Account exists and nothing to do." [12:39:07] I look if I have bureaucrat rights. [12:39:58] My user groups are "bureaucrat, developer, administrator" [12:40:50] ahh yes.. now I see where I can actually approve the users [13:03:04] I am trying to checkout in to an older version of mediawiki(1.22) , I couldn't see a remote gerrit in my core folder since I had cloned from git. [13:06:44] Gopa: did you follow https://www.mediawiki.org/wiki/Download_from_Git ? [13:12:44] Vulpix: yeah. i did it through https method. I am unable to do git pull. I think its because that I lack a git remote [13:14:11] you should clone the branch directly, instead of checking out the branch after clone: git clone -b [13:25:27] Vulpix: oh! I thought, for switching to 1.22, I could checkout into REL_1.22 and then do 'git pull' [14:03:02] Vulpix the branch was deleted [14:03:20] Gopa ^^ [14:03:50] Gopa you could checkout a tagged release like git checkout 1.22.15 [18:01:49] hi [18:01:54] anyone here? [18:01:55] Hi Legolas_, I am here, if you need anything, please ask, otherwise no one is going to help you... Thank you [18:02:02] ehm [18:02:05] how are you [18:02:22] i need help with mediawiki syntax [18:02:48] maybe not