[12:51:37] would anybody be able to help me backup an old 1.16.5 version mediawiki? [12:52:41] i have gotten into phpmyadmin but all attempts to export an sql file then re import it into a current mediawiki have failed [12:52:54] miserably :( [12:53:13] Parko: Probably :) [13:00:17] ive tried exporting specific databases and exporting all of them, using the DROP DATABASE checkbox, but it doesnt seem to want to work [13:00:26] I have only exported from my working mediawiki- and imported into a VM with the current version for testing [13:01:11] what do you mean by want to work? [13:04:34] ok so if I import the sql file with DROP DATABASE checked in the sql file, it will only drop my mediawiki database [13:07:27] so then I create a new bitnami_mediawiki database with uft8_general_ci then import the sql file without DROP DATABASE onto that empty database [13:08:50] then I get this error: [13:08:51] #1044 - Access denied for user 'root'@'localhost' to database 'information_schema' [13:09:40] where are you getting that? [13:09:47] and the wiki will display this in the browser: A database query error has occurred. This may indicate a bug in the software. [13:10:12] #1044 - Access denied for user 'root'@'localhost' to database 'information_schema' occurs in phpmyadmin after importing [13:15:28] merry christmas everyone :) [13:40:23] Parko: can you import from terminal ? [13:42:02] Parko: also you cant import an old dump into a new mediawiki version, you would need to upgrade the wiki to whatever version you want to use [13:45:46] I thought that may have been the case, but I didn't want to try to upgrade my old version and have that fail, as I haven't been able to find old releases of bitnami wikimedia stack to reinstall if it failed [13:46:36] Parko: I can walk you thru the process [13:46:52] Parko: can you get command line access to the sql host? [13:46:56] cool that would be sweet [13:47:05] !dump [13:47:05] For information on how to get dumps from Wikimedia Wikis, see http://meta.wikimedia.org/wiki/Data_dumps . For a how-to on importing dumps, see https://www.mediawiki.org/wiki/Manual:Importing_XML_dumps . [13:47:25] !backup [13:47:25] See http://www.mediawiki.org/wiki/Manual:Backing_up_a_wiki for information about backing up your wiki. For restoring your wiki, see http://www.mediawiki.org/wiki/Manual:Moving_a_wiki#Import_the_database_backup for more. If you don't have database access, try !grabber. [13:48:49] not sure of the sql root password for my old version, I'll try 'bitnami' though [13:49:09] Parko: what about the new version? [13:49:27] are you still using bitnami ? [13:50:32] Betacommand: yep, I just spent some time resetting the password for my new WAMP stack version [13:50:46] Parko: Ive got some bad news [13:50:56] !package | Parko [13:50:57] Parko: Many Linux distributions provide MediaWiki in a packaged format for that distro. These packages typically contain obsolete & unsupported versions of MediaWiki; they also like to move around & change files, & do other super-counterproductive things. You'll get the best support here if you install MediaWiki directly from one of our tarballs - https://www.mediawiki.org/ - or Git https://www.mediawiki.org/wiki/Download_from_Git [13:51:04] which I subsequently broke trying to import the old version [13:51:35] Parko: my suggestion is remove bitnami [13:51:41] :/ [13:51:59] install the correct miradb, and php [13:52:16] you will have fewer issues [13:52:20] aye aye aye [13:52:23] and apache2 [13:53:02] Parko: I just helped someone else with bitnami, was a real pain [13:54:02] ok well I guess I can just start with a fresh AWS instance [13:54:57] Parko: so here is how I would proceed. copy your old database and files to miradb and apache2 [13:55:19] Betacommand: but yer I am by no means competent with configuring these things - only just managed to get ssl working on my new wiki [13:55:27] once you get your old wiki working on the new setup we can then proceed to upgrade it [13:55:49] Parko: basic mediawiki setup is easy [13:56:19] Hell I did it in less than an hour, it took me a lot longer to install linux [13:56:45] hell copying the sql dump took just about as long [13:56:47] Betacommand: ok thats encouraging [13:57:08] Parko: basic mediawiki is really easy to setup [13:57:10] yer my wikis arent exactly expansive [13:57:34] Parko: mine was about 6GB dumped [13:58:05] nothing too massive [13:58:27] Parko: what OS are you working on? [13:58:56] Betacommand: whew, umm well I am familiar with windows mostly [13:59:33] Parko: installing it on Ubuntu is probably your easiest way [14:00:11] windows is slow and a pain to maintain. (I just retired my windows box a month or two ago myself [14:00:33] Betacommand: could do that, I'm taking advantage of AWS free tier atm [14:00:53] you can get better caching and performance on Ubuntu [14:02:00] Betacommand: So I could create a Ubuntu Server 14.04 LTS (HVM) instance and get that up on ssh [14:02:22] Parko: yeah [14:02:46] let me get the docs for you [14:03:45] Parko: http://www.mediawiki.org/wiki/Manual:Running_MediaWiki_on_Ubuntu [14:05:55] you will want to grab mediawiki 1.16.5 for the first install [14:06:42] Betacommand: ok getting this instance up then I need to remember how to get it to link with MobaXterm [14:06:50] then upgrade it to 1.18, 1.20, 1.22, and finally 1.23 [14:07:13] upgrading the wiki is fairly easy [14:08:46] you basically extract the mediawiki files, and corresponding extensions to your current directory, overwriting what you had, then run maintenance/update.php [14:09:11] Parko: remember to keep a backup of everything from your old wiki [14:11:08] Parko: do you follow my train of thought? [14:12:22] Betacommand: ok multitasking here, I think so, so I have access to phpmyadmin and the physical folders on my old wiki, will that be ok to export the database? [14:12:34] yeah [14:13:11] just zip up the entire folder and create an sql dump of the entire database [14:17:54] Betacommand: ok so within phpmyadmin I go to export, select all databases, don't check any DROP check boxes, leave template as __SERVER__, use no compression and save that [14:18:27] Parko: you just need to select your mediawiki database [14:18:49] roger that [14:19:35] I know some systems create meta databases that are pointless and may cause issues copying them [14:24:02] Betacommand: any tips on SSHing into a new ubuntu instance on AWS on MobaXterm? [14:24:34] Parko: No clue, I dont use either, I tend to use putty myself [14:36:11] Betacommand: sorry for the delay, ok I've gotten into ssh [14:36:19] with a file browser [14:40:26] sudo apt-get install apache2 mysql-server php5 php5-mysql libapache2-mod-php5 [14:40:37] wait [14:41:23] Betacommand: I've just run: sudo apt-get update, then: sudo apt-get upgrade [14:41:32] Parko: ok [14:41:41] first thing is https://downloads.mariadb.org/mariadb/repositories/#mirror=syringa&distro=Ubuntu&distro_release=trusty&version=5.5 [14:41:58] Betacommand: as in the guide you linked [14:42:05] then sudo apt-get install apache2 php5 php5-mysql libapache2-mod-php5 [14:42:13] Parko: thats good [14:42:49] Parko: miriadb is a better option than mysql [14:43:22] will that commend you just linked leave out mysql?? [14:43:38] yeah [14:43:49] miriadb is a fork [14:44:01] with a lot of improvements [14:44:07] ok so I'll run sudo apt-get install apache2 php5 php5-mysql libapache2-mod-php5 [14:44:09] which is what the wmf use [14:44:22] Parko: first install miria [14:45:15] Betacommand: so: as from here https://downloads.mariadb.org/mariadb/repositories/#mirror=syringa&distro=Ubuntu&distro_release=trusty&version=5.5 sudo apt-get install software-properties-common sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db sudo add-apt-repository 'deb http://mirror.aarnet.edu.au/pub/MariaDB/repo/5.5/ubuntu trusty main' [14:45:26] then: [14:45:39] sudo apt-get update [14:45:41] sudo apt-get install mariadb-server [14:46:01] great following along [14:46:06] then we can go back to the mediawiki.org guide [14:48:00] Betacommand: K its asking for a root pass for MariaDB [14:48:13] Betacommand: I'll create one I guess [14:48:16] Parko: yep [14:50:49] Betacommand: ok all good [14:51:11] then sudo apt-get install php-apc php5-intl imagemagick phpmyadmin vsftpd php5-cli [14:51:32] Betacommand: I take it we'll be skipping the LAMP stack parts... [14:51:39] No [14:52:12] I thought you had run Parko ok so I'll run sudo apt-get install apache2 php5 php5-mysql libapache2-mod-php5 [14:52:52] no only the update parts and the MariaDB parts [14:53:41] Ok, then run [14:53:59] Betacommand: cool - sudo apt-get install apache2 php5 php5-mysql libapache2-mod-php5 - missing SQL [14:54:09] sudo apt-get install apache2 php5 php5-mysql libapache2-mod-php5 [14:55:22] Betacommand: done, I love the speed of AWS internet :) [14:57:32] Parko: extract your ziped copy of mediawiki to /var/www/html [14:58:20] and set upload and memory limits http://www.mediawiki.org/wiki/Manual:Running_MediaWiki_on_Ubuntu#Optional:_Configure_PHP [14:59:37] ok so I have C:\Program Files\BitNami MediaWiki Stack\apps\mediawiki I should zip just mediawiki containing conf,config,htdocs ect [15:00:25] No [15:00:34] where is your localsettings.php ? [15:01:07] probably under htdocs [15:01:31] yup LocalSettings.php [15:01:59] grab the directory that contains localsettings and the actual mediawiki files [15:02:09] Mine is called w [15:02:18] Merry Christmas ya filthy animal! [15:03:51] Betacommand: :-/ so LocalSettings.php is in htdocs [15:04:34] Parko: is there an images and extensions directory in there too? [15:04:36] and also in htdocs is bin,cache,docs,extensions etc [15:04:42] (folders) [15:04:56] Betacommand: yup images [15:05:19] Parko: so grab that [15:05:30] thats why I hate packagers [15:06:54] ok so I can move the htdocs folder over to my new ubuntu instance in the www/html/ folder [15:07:09] and rename it to something useful [15:07:27] I use w so I can use the short url wiki [15:07:36] like wikipedia uses [15:08:17] Betacommand: ok, my adsl conection will love uploading at 51MB [15:11:42] Parko: then I thru something like http://pastebin.com/vCCu2Fbd at the bottom of /etc/apache2/apache2.conf [15:12:31] I then opened up mysql created a database with the same name as my old one, and then ran: [15:13:20] mysql -u USERNAME -p - YOUR-DATA-BASE-NAME-HERE < YOUR-.SQL.FILE-NAME-HERE [15:13:56] Betacommand: I've tried to move htdocs.zip to /html but I've got permission denied and also no such file [15:14:24] Parko: its a directory permission issue [15:15:05] yup my linux command line knowledge is [15:15:09] you need to give yourself (non-root) write permission to that folder [15:15:10] very small* [15:19:09] Parko: try: [15:19:15] sudo chmod a+w /var/www/html [15:20:38] Betacommand: hey great it looks like its going through [15:21:33] Parko: I am not magical I just know where to look for this info :P [15:22:40] haha yer being on the newb side of things can be annoying [15:23:32] Betacommand: I was only prob 10 mins from figuring out haha [15:28:06] Betacommand: ok so I've got htdocs.zip into /html [15:29:43] Betacommand: and added the pastebin code to my apache2.conf file although I don't know how it should be edited [15:31:37] Betacommand: I'll try unzipping htdocs and renaming it to w [15:38:23] Parko: see the top of http://www.mediawiki.org/wiki/Manual:Running_MediaWiki_on_Ubuntu [15:41:28] Betacommand: having some more permission troubles.. can't seem to get permission for the /etc/php5/apache2/ or /etc/apache2/ folders [15:42:01] Parko: you may need to use sudo to access/edit them [15:43:08] Betacommand: so sudo /etc/php5/apache2/php.ini ? [15:43:16] No [15:43:39] Betacommand: heh I'm worried I might blow something up [15:43:50] sudo nano /etc/php5/apache2/php.ini [15:44:05] vs just nano [15:44:14] I see [16:01:21] Betacommand: ok cool thanks, I think I'm caught up, just need to unzip htdocs.zip [16:01:53] Parko: have you imported the sql file? [16:02:16] just looking at that now [16:02:37] Betacommand: need to edit mysql -u USERNAME -p - YOUR-DATA-BASE-NAME-HERE < YOUR-.SQL.FILE-NAME-HERE [16:03:02] Parko: yeah with the correct values for your case [16:05:13] Betacommand: mysql -u root -p -bitnami_mediawiki < exported-file.sql me thinks [16:05:29] *Parko pulls at hair* [16:05:39] Parko: remove the stray - [16:05:51] mysql -u root -p bitnami_mediawiki < exported-file.sql [16:06:46] Betacommand: I havent created this database yet either :-/ [16:07:15] Betacommand: nor moved the exported file over [16:08:30] Betacommand: and for good measure I'm not sure the credentials/password on the old database [16:08:44] Parko: you dont need it [16:08:54] you have the .sql [16:10:17] Betacommand: ok cool, so this command mysql -u root -p bitnami_mediawiki < exported-file.sql require the sql file on my new instance? [16:11:02] yes [16:11:21] and should be preformed in the same directory where the file is located [16:12:54] Betacommand: ok could you reccomend a location to upload the sql file? [16:13:11] /etc/mysql/ doesnt have permission [16:13:23] Parko: your home directory is fine [16:14:55] Betacommand: uploading to /home/ubuntu/ [16:17:09] Betacommand: the command will be: mysql -u root -p bitnami_mediawiki < /home/ubuntu/export.sql ? [16:17:27] yeah [16:18:17] enter password [16:18:28] password [16:19:07] no luck [16:19:25] Parko: what was your miriadb password for root? [16:19:36] Parko: Remove the space between -p and your password [16:20:01] DrSkyLizard: the password isnt being passed [16:20:27] Betacommand: cool then that got to ERROR 1049 (42000): Unknown database 'bitnami_mediawiki' [16:20:39] Parko: you missed a step [16:20:43] yah [16:21:09] Betacommand: not sure how to create a database? [16:21:09] you need to mysql -u -p and create the database first [16:21:48] scoring a few noob points atm... haha [16:22:01] CREATE DATABASE bitnami_mediawiki; [16:22:35] then exit sql and run the previous command [16:23:15] Parko: this reminds me of a very old saying, Measure twice, cut once [16:25:02] yer kinda hurrying to get some sleep before xmas [16:25:38] ERROR 1007 (HY000) at line 21: Can't create database 'bitnami_mediawiki'; database exists [16:26:03] Parko: OK exit and try importing it again [16:27:59] ok I ran bitnami_mediawiki < /home/ubuntu/export.sql from MariaDB [(none)]> and it just went to new line [16:28:32] sorry about the incompetence.. [16:29:33] Parko: now modify localsettings.php with the new database username and password and see if your wiki works [16:33:17] OK so I have a question [16:33:38] I want to change the default landing page for http://masterceadeus.hostyd.net/wiki/ [16:33:54] right now it goes to Main Page, which has been moved to Home, so it says "redirected from Main Page" [16:34:01] so how do I change the default to go to Home [16:34:05] Edit MediaWiki:Mainpage [16:34:23] http://masterceadeus.hostyd.net/wiki/MediaWiki:Mainpage [16:35:14] Oh. I feel dumb [16:35:14] XD [16:35:15] !mainpage [16:35:15] To change which page is the "main page" of your wiki, edit MediaWiki:Mainpage. [16:35:16] Thanks [16:41:55] Parko: Ive only got about another 10 minutes or so before I need to head out [16:45:57] Betacommand: ok well thank for your help so far [16:47:00] Ive got something displaying.. I modified $wgDBtype = "mysql"; [16:47:01] $wgDBserver = "localhost"; [16:47:01] $wgDBname = "bitnami_mediawiki"; [16:47:01] $wgDBuser = "root"; [16:47:02] $wgDBpassword = "xxxx"; [16:47:20] which returned this in the browser: MediaWiki internal error. [16:47:21] Exception caught inside exception handler [16:47:46] Parko: you should be in pretty good shape, all you need to do is overwrite your mediawiki and run update.php in .2 increments [16:47:56] !debug | Parko [16:47:56] Parko: For information on debugging (including viewing errors), see http://www.mediawiki.org/wiki/Manual:How_to_debug . A list of related configuration variables is at https://www.mediawiki.org/wiki/Manual:Configuration_settings#Debug.2Flogging [16:47:57] I have $wgSecretKey in LocalSettings - not sure of that makes a diffrenece [16:48:16] great thanks [16:48:23] Parko: all you should have needed to change was dbuser and dbpassword [16:48:26] I'll have a look through thtat tomorrow [16:49:35] hopefully I can get something showing I can delete my old wiki and go ahead with a reformat for that computer [16:50:18] sleep time me thinks but thanks for all the help [17:20:39] Tgr: I am working on the bug T85234.Should this be done for all special pages or should the file related special pages be mentioned explicitly in the code? [17:23:21] !task 85234 [17:23:21] https://phabricator.wikimedia.org/T85234 [22:24:40] Hello, Happy Holidays everyone. I've stumbled upon a problem with my MW and went to the Support Desk to ask for help but I can't Start a new discussion. Can someone help me out?