[09:10:36] hello, I am trying to move a wiki to a different server but there can't make the new wiki run after database move. any idea what those errors mean? https://35.233.93.1 [09:11:02] : Cannot access the database: Unknown error (localhost) [09:33:09] hello, I moved my wiki to a new server, imported database but got this error aftrying to run update.php: https://termbin.com/5ojz [09:33:16] any idea what's wrong? [09:34:01] baruna: that doesn't look like an error. The script simply ends after the countdown without any error shown? [09:34:54] Vulpix: ah I'm sorry, this is the right output: https://termbin.com/n0ow [09:35:18] > CREATE command denied to user '0002_auvajs'@'localhost' for table 'auvajs_interwiki' [09:35:23] this is a permission problem [09:35:44] You need to use a database user with sufficient permissions to create alter and drop tables and indices [09:35:45] I thought so too but I granted all privileges to this user [09:36:36] well, apparently you didn't according to what mysql says [09:36:51] GRANT ALL PRIVILEGES ON 0002_auvajs TO '0002_auvajs'@'localhost'.. isn't this enough? [09:37:03] also remember that '0002_auvajs'@'localhost' is different from '0002_auvajs'@'%' or '0002_auvajs'@'some random IP or hostname' [09:38:20] > GRANT ALL ON 0002_auvajs . * TO '0002_auvajs'@'localhost'; [09:38:33] assumin 0002_auvajs is the name of the database [09:39:51] hm I tried this and got the same error again; strange [09:41:30] Is the database name really 0002_auvajs ? [09:42:55] when I changed the user to root in LocalSettings I got this error: https://termbin.com/356mu [09:43:08] of course I also changed the password [09:44:19] maybe the root user uses a different password. In mysql users have their own passwords and privileges different from the OS [09:45:23] isn't the password used for loging into mysql? mysql -u root -p [09:45:26] Check also your're connecting to the correct server. It won't be the first time someone is connecting to a dev instance instead of the prod instance or similar [09:45:34] Yes, it is [09:46:24] hm I don't know what are those instances; this is a new vps and I only installed one instance (hopefully) via ubuntu installer [09:48:08] So you've set up $wgDBserver = 'localhost'? Note that setting $wgDBserver = '127.0.0.1'; will lead to different results [09:50:10] yes, "localhost" [09:50:28] and $wgDBTableOptions = "ENGINE=InnoDB, DEFAULT CHARSET=binary"; [09:52:58] Well, I'm out of options. Most you can do is connect with "mysql -u 0002_auvajs -p 0002_auvajs" and issue a simple CREATE TABLE and see what happens [09:56:56] hm there is something strange; the root user can see 132 rows in the 0002_auvajs database but the 0002_user sees empty set [09:58:34] but I really grant all to this user [10:01:41] Issue the GRANT again, with 0002_auvajs . * [10:04:48] https://pastebin.com/rgGUAn3h [10:05:26] > GRANT ALL PRIVILEGES ON `0002_auvajs`.`0002_auvajs` --> this makes no sense at all [10:06:01] > GRANT ALL ON 0002_auvajs . * TO '0002_auvajs'@'localhost'; [10:08:53] still nothing :( https://pastebin.com/zy28dAqN [10:15:22] baruna: what "nothing" means here? MediaWiki fails to install? you can't create a table from mysql command line? [10:16:43] Vulpix: the 0002_users sees no tables in the mediawiki database '0002_auvajs' where root users sees 132 rows [10:16:51] I mean 0002_auvajs user [10:17:47] Vulpix: maybe I'll trying everything again [10:17:56] drop the database and kill the user [10:18:06] ok [10:28:00] oh no. I made a new database (wiki01), new user (wiki01) with all privileges and again got the same error in mediawiki install: https://pastebin.com/hFRwEvXp [10:28:16] maybe it's some firewall problem or something [10:28:22] really no idea [10:31:56] It's not a firewall issue [10:31:56] Error: 1142 CREATE command denied to user 'wiki01'@'localhost' for table 'user' (localhost) [10:32:01] That's very much related to your grants [19:36:53] I'm trying to find all the edits made by rollback on all the wikimedia wikis. So for rollback-success on enwiki https://en.wikipedia.org/wiki/MediaWiki:Rollback-success, the default comment format is in a fmbox template [19:37:05] I wonder how the downstream modules are parsing this page? [19:51:12] groceryheist: That looks like an acknowledgement notification for the user performing the rollback, not the automatic edit summary [19:52:47] oh! [19:53:01] do you know where automatric edit summaries are configured for rollbacks? [19:54:32] This may be https://en.wikipedia.org/wiki/MediaWiki:Revertpage [20:00:30] ah! [20:00:32] I think that's right [20:00:36] thank you Vulpix ! [20:03:21] yw [20:20:28] Cannot get MW to upload an outside font file. Have attempted to upload the file directly as well as placing the font file in /var/www/w. No luck. Using an '@font-face' listing at the head of 'MW:Common.css'. Is there a setting that is required in order to have the file used. [20:20:55] checked your browser console