[13:23] *** now talking in #fooldriver [13:23] *** topic is Don't fuck with us!â„¢ SRSBSNS Channel | https://www.foolz.us/ - https://status.foolz.us/ | DON'T PM ANYONE WITHOUT THEIR PERMISSION! - INSTEAD OF WASTING TIME BY ASKING FOR HELP, JUST STATE YOUR PROBLEM/ISSUE IMMEDIATELY. [13:23] *** set by Kurisu on Sun Aug 31 13:46:14 2014 [13:23] *** channel #FoOlDriver mode is +stnr [13:23] *** channel created at Mon Jul 18 04:34:16 2011 [13:23] Mind if I hang out here? [13:25] <@Adm|nymous> go ahead [13:50] <@Adm|nymous> need anything Ctrl-S ? [13:51] *** Nertsy changed nick to Guest6697938 [13:52] *** Nertsy` (~Nertsy@89a6ad6.297f4433.tn.comcast.net) joined [13:56] *** Guest6697938 quit (Ping timeout: 360 seconds) [14:01]  /msg NickServ RELEASE Nertsy [14:01] My bad [14:01] *** Nertsy` changed nick to Nertsy [14:59] I'm tring to figure out how to import the heinessen /mlp/ archive (posts, thumbs, and images). I've gotten them both downloaded and am looking at how migrate.php from https://dev.foolz.us/foolz/asagi-toolkit/tree/master/fuuka-to-asagi-migration-tool works before I try running it [15:00] but i'm also interested in writing some monitoring scripts for asagi/foolfuuka so i can make sure it's not stopped working [15:00] but right now i'm just slowly learning how the import/merge works [15:01] oh yeah i've also downloaded the images table from archive.moe - /mlp/ images: http://jii.moe/7kT3GTH7.torrent [15:02] I've loaded the heinessen posts table and the moe images table into seperate databases so far, and extracted the images [15:13] <@Adm|nymous> hmm [15:14] <@Adm|nymous> should be pretty straight forward [15:15] <@Adm|nymous> what part confuses you Ctrl-S [15:15] <@Adm|nymous> also that script should only be used with fuuka dumps [15:16] <@Adm|nymous> which should be the db and thumbs [15:16] <@Adm|nymous> if you grabbed from heinessen [15:28] Should i run each phase seperately? [15:29] I also have the heinessen images torrent which i want to import [15:30] <@Adm|nymous> you should run them one after the other [15:30] do i need any tables other than the heinessen mlp for that? [15:30] <@Adm|nymous> im assuming you are running asagi in the bg ? [15:30] the images torrent was just a folder images with numeric folders inside [15:30] if possible [15:31] <@Adm|nymous> you need to use the other tool for that one [15:31] <@Adm|nymous> since the dump was made by archive.moe [15:32] <@Adm|nymous> either way the db needs to be imported first before images/thumbs can be done [15:32] I have a table from moe [15:32] mlp_images.tar.gz [15:32] mlp_images.sql [15:33] <@Adm|nymous> the mlp_images one from moe is required to import their images dump [15:33] <@Adm|nymous> heinessen posts only need the main mlp.sql dump [15:33] <@Adm|nymous> and that needs to be done before importing images/thumbs [15:33] this command? [15:33] $ php migrate.php --old-database heinessenmlp --board mlp --phase 1 [15:34] <@Adm|nymous> yes [15:34] with my current asagi.json in the script dir [15:34] <@Adm|nymous> yup [15:34] and I don't need to take any other preparatory measures other than a DB backup? [15:34] <@Adm|nymous> yea [15:37] thanks, backing up and setting up script for run now [15:38] <@Adm|nymous> also for paths [15:39] ? [15:39] <@Adm|nymous> the dir structure should be [15:39] <@Adm|nymous> .//thumb/ [15:40] <@Adm|nymous> so something like /path/to/boards/mlp/thumb/ [15:40] <@Adm|nymous> but you would only enter --old-path /path/to/boards/ [15:40] <@Adm|nymous> the rest is generated in the script [15:40] on my box images are located at /drives/drive1/archives/mlp [15:41] do i need to enter the old_path at phase1? [15:41] <@Adm|nymous> im talking bout heinessen thumbs [15:41] <@Adm|nymous> no [15:41] <@Adm|nymous> its only needed in phase 3 [15:41] <@Adm|nymous> which handles files [15:41] <@Adm|nymous> where did you store the heinessen thumbs ? [15:42] ./drives/drive2/heinessen/thumb/0037/64/1344476620818s.jpg [15:42] <@Adm|nymous> so it should be [15:43] <@Adm|nymous> well you would make a mlp dir in heinessen [15:43] <@Adm|nymous> and move thumb dir into it [15:43] <@Adm|nymous> so ./drives/drive2/heinessen/mlp/thumb/0037/64/1344476620818s.jpg [15:43] <@Adm|nymous> then you would use the following cmd: [15:43] <@Adm|nymous> php migrate.php --old-path /drives/drive2/heinessen/ --board mlp --phase 3 --process-thumbs [15:44] chmodding to 666 and then moving to new folder [15:45] Do i need phase 2? [15:45] <@Adm|nymous> doubt it [15:45] I don't understand what it does [15:46] <@Adm|nymous> it just recreates the triggers/procedures [15:46] <@Adm|nymous> was too lazy to move it somewhere else [15:46] I'd have thought FF or asagi would do that if needed [15:46] <@Adm|nymous> FF doesnt handle triggers [15:46] <@Adm|nymous> only asagi [15:47] <@Adm|nymous> uses the triggers/procedures to populate the other tables [15:49] I think I broke the folders when i moved them [16:00] <@Adm|nymous> not sure how you can do that [16:03] I can do phase 1 without the thumbs though, right? [16:03] <@Adm|nymous> yes [16:04] <@Adm|nymous> phase 1 only handles db data [16:05] I just want to confirm before I run a command like this, I use "php migrate.php --old-database heinessenmlp --board mlp --phase 1"? [16:05] from the folder with the php [16:05] <@Adm|nymous> yes [16:06] thank you so much [16:06] do i need to run as root? [16:07] <@Adm|nymous> depends on how you have all your stuff setup [16:07] <@Adm|nymous> but since phase 1 only deals with db [16:07] <@Adm|nymous> doesnt matter [16:08] http://pastebin.com/b6A1zEQA [16:10] <@Adm|nymous> probably has to do with your php installation [16:10] <@Adm|nymous> seems like readline isnt available [16:11] running yum install php to makes sure it's the latest version [16:12] latest version [16:12] [16:12] Package php-5.4.16-23.el7_0.3.x86_64 already installed and latest version [16:15] <@Adm|nymous> dont remember how they have it packaged on your distro [16:15] <@Adm|nymous> http://php.net/manual/en/book.readline.php [16:16] <@Adm|nymous> seems like you are missing that [16:17] yum install php-readline says php-cli is up to date :| [16:21] >I need to compile with readline support [16:23] I don't know what i should do now [16:28] <@Adm|nymous> probably missing some other dependency [16:29] what exactly is readline used for? can i bypass the need for it? [16:30] <@Adm|nymous> used to read the input [16:30] from the CLI? [16:30] So if i edited the PHP to have the commands as a string or something i could get it working? [16:50] <@Adm|nymous> yea [16:51] <@Adm|nymous> Ctrl-S, http://pastie.org/private/o66l58vzwkbxwoerpzf1a [16:51] <@Adm|nymous> save that as test.php [16:51] <@Adm|nymous> and do: php test --board mlp [16:51] thanks! [16:51] <@Adm|nymous> and see if that works [16:51] <@Adm|nymous> err: php test.php --board mlp [16:57] same error [16:57] I believe this line causes the problem: $args = new arg_parser(array()); [16:57] <@Adm|nymous> yea [16:57] possibly include 'resources/parameters.php'; [16:58] <@Adm|nymous> taht handles the input [16:58] <@Adm|nymous> centos ? [16:58] If that was replaced with an appropriate array of whatever, the cli class could be excluded, right? [16:58] centos 7 [16:59] <@Adm|nymous> php builds readline extension against libedit [16:59] <@Adm|nymous> so you can try updating that lib [16:59] nothing to do, already lastest ver [17:00] what does $args contain after it's defined? [17:02] <@Adm|nymous> the joys of dealing with distro packages [17:03] <@Adm|nymous> $args is a class [17:03] I'm thinking the best way is a simple hack where we define the values read from $args; or replace the statements where $args is read [17:04] like in python: args.phase =1 [17:04] <@Adm|nymous> like i said, its a class [17:07] sorry, I'll have to watch a few tutorials on php before i can do this [17:07] gotta learn the syntax [17:24] *** wafu (~aa@ec7593a.2af52808.optusnet.com.au) joined [17:24] *** Saber sets channel #FoOlDriver mode +o wafu [17:28] *** asianaussie quit (Ping timeout: 360 seconds) [17:30] *** Yarn (~Yarn@307e4d48.35474391.24862c5a.4e929bdX) joined [17:30] *** Saber sets channel #FoOlDriver mode +o Yarn [17:38] <@Adm|nymous> Ctrl-S, http://pastie.org/private/9uc1iu00o0eyoagzbtxq [17:38] <@Adm|nymous> just edit lines 54 to 56 accordingly [17:39] thanks [17:39] That is pretty much exactly what i was trying to learn to do [17:40] <@Adm|nymous> add: '--process-thumbs' => false, [17:40] <@Adm|nymous> to the array when you need to do thumbs [17:41] false? [17:41] <@Adm|nymous> well true [17:41] <@Adm|nymous> doesnt matter [17:41] just that it exists? [17:41] <@Adm|nymous> since the passed() method only checks if it exists [17:43] php migrate.php [17:43] no need for args [17:43] right? [17:44] <@Adm|nymous> yea [17:45] same error for some reason? [17:46] check if the file was actually uploaded etc. [17:47] nano shows the change [17:48] even after renaming the parameters.php it happens [17:48] is there a flag to show the traceback [17:50] *** Yarn quit (Ping timeout: 360 seconds) [17:50] [17:50] http://pastebin.com/775LZdw0 [17:50] i even tried just running the saves paste [17:53] sorry for all of this [17:53] <@Adm|nymous> should just compile php [20:52] *** formerly quit (Ping timeout: 360 seconds) [21:22] *** wafu quit (Quit: Leaving) [22:08] *** Felys changed nick to Felys`Offline [22:15] *** Darais (Darais@2e1bf8a9.36cd2766.asm.bellsouth.net) joined [22:15] *** Saber sets channel #FoOlDriver mode +o Darais [22:19] *** Daria quit (Ping timeout: 360 seconds) [02:15] *** Yarn (Yarn@307e4d48.35474391.24862c5a.4e929bdX) joined [02:15] *** Saber sets channel #FoOlDriver mode +o Yarn [02:39] *** formerly (~vedasisme@1c6ad229.2c464aa6.1f5b825b.1fbd6a28X) joined [04:24] *** formerly quit (Ping timeout: 360 seconds) [05:59] *** formerly (vedasisme@1c6ad229.2c464aa6.1f5b825b.1fbd6a28X) joined [06:35] <@Adm|nymous> heh woxxy should make that tool use symfony/console [06:35] yea [06:35] it would be best [06:35] easy as well [06:35] <@Adm|nymous> doesnt use the readline shit [06:35] or even include in foolfuuka so you get the entire stack of tools we use [06:36] <@Adm|nymous> plugin [06:36] sure [06:37] we got a pretty neat hooking point for console [06:37] i think [06:48] <@Adm|nymous> yup [06:50] damn foolframe suffered so many refactors [06:51] but it's so nice now [06:51] coding foolslide on top of it is easy as hell [07:06] *** scizzer12 (~Someone@263fce7a.20db5883.a7e4540.31a16b5dX) joined [07:06] *** Saber sets channel #FoOlDriver mode +o scizzer12 [07:19] <@Adm|nymous> ill think bout it heh [07:19] <@Adm|nymous> seems kinda pointless to rewrite something that already works [07:20] <@Adm|nymous> and its not something ppl should have to use [07:23] <@Darais> scizzer: how is ZnT coming? [07:24] <@scizzer12> ohYeah.gif [07:38] yea Adm|nymous wasted time i think too [07:38] if you had time you should rather implement the migration system [07:38] it's already there just not exposed [07:39] https://github.com/FoolCode/FoolFrame/blob/master/src/Model/SchemaManager.php#L143 [07:40] would be good at least to output the sql [07:40] easier updates [08:33] <@Adm|nymous> heh yea [08:33] <@Adm|nymous> one day [08:36] *** Bladeee quit (Quit: And what if I don't?) [08:36] *** asianaussie (~aa@dazzling.every.stage) joined [08:36] *** Saber sets channel #FoOlDriver mode +o asianaussie [09:19] *** Bladee (~Blade@wide.is.love) joined [09:21] <@Rukia> hmm is mute taken [09:21] *** Rukia changed nick to mute [09:22] <@mute> ehh [09:22] *** mute changed nick to Rukia [09:22] *** Rukia changed nick to Mute [09:23] <@Mute> nyoho [10:59] *** Felys`Offline changed nick to Felys [11:40] *** Felys changed nick to Felys`Offline [11:43] *** Everath quit (Quit: /me longcats away~~~~~) [11:43] *** Felys`Offline changed nick to Felys [11:51] *** Everath (~Everath@in.the.silent.sky) joined [13:08] *** salty quit (Read error: Connection reset by peer) [13:08] *** salty (sdd@1872b73.ec7593a.milwwi.ameritech.net) joined [13:15] *** salty quit (Quit: ) [13:18] *** salty (sdd@2e099bf0.263fce7a.342981b0.1fbd6a28X) joined