[00:45] == fgenesis_ [webchat@178.167.137.96.threembb.ie] has joined #bitblot
[00:45] == fgenesis_ has changed nick to fgenesis_ie
[00:55] == JohnBeak has changed nick to no_one
[00:58] == no_one has changed nick to Suicude
[01:00] == Suicude has changed nick to watashi
[01:01] == watashi has changed nick to JohnBeak
[01:02] <fgenesis_ie> hah, name changing ftw!
[01:34] == JohnBeak [~John.Beak@13.121.broadband5.iol.cz] has quit [Quit: wioy]
[02:39] == alecholowka [~alecholow@S01060015f240e1cf.wp.shawcable.net] has joined #bitblot
[02:39] <alecholowka> yo
[02:40] <alecholowka> party like it's 1969
[02:40] <fgenesis_ie> alecholowka: oh
[02:41] <fgenesis_ie> right
[02:41] <fgenesis_ie> now you got me right before pressing the shutdown button
[02:41] <fgenesis_ie> :P
[02:41] <fgenesis_ie> ready for something quick and dirty?
[02:42] <fgenesis_ie> oh gods the communication issues... ignore my last mail
[02:42] <fgenesis_ie> (for now)
[02:42] <fgenesis_ie> hi btw
[02:43] <fgenesis_ie> uhm, want to try, or delay it?
[02:43] <alecholowka> oh hey
[02:43] <alecholowka> yeah we could try something maybe
[02:44] <alecholowka> i dunno if the first step should be to try to back up all the SQL databases on the site or something
[02:44] <fgenesis_ie> yes
[02:44] <fgenesis_ie> definitely that
[02:44] <alecholowka> okay
[02:44] <fgenesis_ie> if a backup works, do that
[02:44] <alecholowka> i don't know how to do that either lol
[02:44] <alecholowka> maybe i should see what this admin panel has
[02:44] <fgenesis_ie> mysqldump -uUSER -p DATABASE > outfile.sql
[02:45] <alecholowka> hrm
[02:45] <alecholowka> i can at the very least stop SQL from the web admin
[02:45] <fgenesis_ie> SSH > web panel, always =)
[02:45] <fgenesis_ie> well, not necessary
[02:45] <alecholowka> virtualmin
[02:45] <fgenesis_ie> + you can't dump the tables when DB is down
[02:46] <alecholowka> virtualmin + webmin i guess
[02:46] <alecholowka> hmm webmin might have tools
[02:46] <alecholowka> "SQL show index from `smf_members` failed : Table './bb_forum/smf_members' is marked as crashed and should be repaired"
[02:46] <fgenesis_ie> unless you are going to hardcopy the plain table files, but i doubt you have quick access to them, and its also the worst choce if you need a backup
[02:46] <alecholowka> that's the message when i select the bb_forums table
[02:46] <fgenesis_ie> ah
[02:46] <fgenesis_ie> easy one, like i thought
[02:46] <alecholowka> k there's a backup databases button
[02:47] <fgenesis_ie> with the command i mailed you you can fix that in a second
[02:47] <fgenesis_ie> *if* backing up works for crashed tables...
[02:47] <alecholowka> right
[02:47] <fgenesis_ie> side note: nice to see you in here, never imagined that would happen :P
[02:48] <alecholowka> backup worked
[02:48] <alecholowka> i used to hang out here
[02:48] <alecholowka> just haven't been on irc for a long while
[02:48] <fgenesis_ie> oh, good, then see if it has everything
[02:48] <fgenesis_ie> well, you are busy and all, and IRC eats time if abused
[02:48] <fgenesis_ie> so it might be the better choice to stay out
[02:49] <fgenesis_ie> to get actual work done
[02:49] <fgenesis_ie> =)
[02:49] <fgenesis_ie> i mean especially smf_members table records
[02:50] <fgenesis_ie> make sure it has the data, not only the headers (fulltext search ftw!)
[02:50] <alecholowka> yeah, trying to find out where the file went :]
[02:50] <alecholowka> i haven't logged onto bit blot ftp in ages
[02:50] <fgenesis_ie> tss tss :P
[02:51] <fgenesis_ie> but, you really have ssh, and not only the web panel, i hope?
[02:52] <fgenesis_ie> oh wait, i vaguely remember SMF had a table repair option in the admin interface
[02:52] <fgenesis_ie> but i may be wrong, ignore that
[02:54] <alecholowka> i have ssh access, yea
[02:54]  * fgenesis_ie never used web panels
[02:54] <fgenesis_ie> after you got the backup, lets try that
[02:54] <alecholowka> hmm yeah
[02:55] <alecholowka> looks like backup failed
[02:55] <alecholowka> for that one
[02:55] <fgenesis_ie> lol, damn
[02:55] <alecholowka> gives the crashed message
[02:55] <fgenesis_ie> hrm, this is not good
[02:55] <fgenesis_ie> should you let me in ssh somehow (teamviewer?), i'll be extra careful
[02:56] <alecholowka> yeah i dunno
[02:57] <alecholowka> where would i want to be running sql commands from ?
[02:57] <fgenesis_ie> mysql cmd prompt
[02:57] <alecholowka> hmm
[02:57] <alecholowka> and how do i get to that
[02:57] <fgenesis_ie> that you start via mysql -uUSER -p
[02:58] <fgenesis_ie> -p will ask you for a password so it cant be seen in shell history
[02:58] <alecholowka> k logged in
[02:58] <fgenesis_ie> good
[02:58] <fgenesis_ie> use bb_forum;
[02:59] <alecholowka> oh good, access denied for this user
[02:59] <fgenesis_ie> damn i got really rusty in sql since i started using GUIs
[02:59] <fgenesis_ie> lol
[03:00] <fgenesis_ie> seems like a very well secured webspace to me, good job ;P
[03:00] <fgenesis_ie> or hm
[03:00] <alecholowka> hmm
[03:00] <fgenesis_ie> try that again with: mysql -uUSER -p bb_forum
[03:00] <fgenesis_ie> you do not have a root account, do you?
[03:01] <alecholowka> access denied for that user
[03:01] <alecholowka> we do have a root account, but
[03:01] <alecholowka> not sure if that is for sql or
[03:01] <alecholowka> O.o
[03:01] <alecholowka> what
[03:01] <fgenesis_ie> because no clue whether you have a webhost or a root server, but i guess its first
[03:01] <fgenesis_ie> lol, ssh root is unlikely unless its your own box, or a box that runs in a VM
[03:02] <alecholowka> i think it's a virtual server
[03:02] <fgenesis_ie> ok, that is already something to work with, admin-wise
[03:02] <fgenesis_ie> then try mysql root login
[03:03] <fgenesis_ie> it is possible to break in in case you forgot, forgot how to, but its only a few commands which google knows
[03:03] <fgenesis_ie> or
[03:03] <fgenesis_ie> the user data must be stored in SMF config
[03:04] <fgenesis_ie> and if the forum has access to it, you have as well
[03:05] <alecholowka> ah k
[03:05] <alecholowka> well there's a backup settings php file
[03:06] <alecholowka> username is not what i was using
[03:06] <fgenesis_ie> good, then try that other one
[03:06] <alecholowka> yeah k logged in
[03:06] <alecholowka> k use bb_forum; works
[03:06] <fgenesis_ie> but at some point you will need your root login... better have it at hand for possible future problems
[03:06] <fgenesis_ie> good
[03:07] <fgenesis_ie> then: REPAIR TABLE smf_members;
[03:07] <alecholowka> hmm why just that table
[03:07] <fgenesis_ie> no clue if REPAIR TABLE (SHOW TABLES); works, thats why
[03:07] <alecholowka> or can you only do one table at a time or something
[03:08] <fgenesis_ie> there is a query to use subselects via information_schema, but forgot how to, don't have a SQL db here i could access
[03:08] <fgenesis_ie> but i think it rather unlikely that all are broken
[03:08] <alecholowka> http://dev.mysql.com/doc/refman/5.0/en/myisam-repair.html
[03:08] <alecholowka> there's this stuff too
[03:08] <fgenesis_ie> so one by one should be fine
[03:08] <fgenesis_ie> oh
[03:08] <fgenesis_ie> sec
[03:08] <alecholowka> linked to via: https://www.virtualmin.com/node/15340
[03:09] <alecholowka> also i think i'm supposed to stop sql first before running repairs, right
[03:09] <fgenesis_ie> ok, in any case, do NOT use TRUNCATE
[03:09] <fgenesis_ie> no
[03:09] <fgenesis_ie> myisamchk is an esternal tool like mysqldump
[03:10] <fgenesis_ie> and all MyISAM repairs i ever did was while it was running
[03:10] <fgenesis_ie> and this is 95% of all cases, unless the harddrive is on the edge of failing
[03:10] <alecholowka> well this guide says to stop it i guess
[03:10] <alecholowka> "If you are going to repair a table from the command line, you must first stop the mysqld server. Note that when you do mysqladmin shutdown on a remote server, the mysqld server is still available for a while after mysqladmin returns, until all statement-processing has stopped and all index changes have been flushed to disk."
[03:11] <fgenesis_ie> yes, this is another way
[03:11] <alecholowka> right, but which way is bettaaar
[03:11] <fgenesis_ie> myisamchk accesses the raw DB files independently, ofc it must be stopped then
[03:11] <fgenesis_ie> imho mine, because it has always worked for me =)
[03:11] <fgenesis_ie> but choose your poison
[03:12] <fgenesis_ie> never used myisamchk, so i know as much about it as you do
[03:12] <fgenesis_ie> (was never necessary)
[03:12] <alecholowka> this crash happened i think because we ran out of disk space
[03:14] <fgenesis_ie> lool
[03:14] <alecholowka> not really sure why we ran out of disk space
[03:14] <fgenesis_ie> sweet, especially then do not stop the DB in case it has any unwritten stuff in RAM
[03:14] <fgenesis_ie> tried deleting some old logs?
[03:15] <alecholowka> we removed some files we weren't using anymore
[03:15] <fgenesis_ie> your webserver may be configured to dump each and every access to a log file
[03:15] <fgenesis_ie> afaik it is like that by default
[03:15] <fgenesis_ie> over the years that can get pretty large
[03:15] <fgenesis_ie> if there is no logrotate or auto-cleanup active
[03:16] <alecholowka> not sure how to check
[03:17] <fgenesis_ie> if you have enough space right now, delay that
[03:17] <fgenesis_ie> get the forum up first :)
[03:18] <fgenesis_ie> ah, got myself access to a SQL db
[03:20] <alecholowka> hmm
[03:20] <alecholowka> i think derek deleted a bunch of big files
[03:20] <alecholowka> so there's probably enough space for now
[03:20] <fgenesis_ie> alecholowka: just found this: http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html
[03:20] <fgenesis_ie> it may be the all-in-one thing you've been looking for
[03:21] <fgenesis_ie> (never used it as well)
[03:22] <fgenesis_ie> with --auto-repair and --all-databases
[03:23] <fgenesis_ie> not sure whether you have to shutdown mysql for this or not
[03:23] <alecholowka> hmm
[03:23] <alecholowka> at the top it said something about sql has to be running
[03:23] <fgenesis_ie> i think it can stay online
[03:23] <fgenesis_ie> yeah
[03:23] <fgenesis_ie> read/write lock means it can stay on
[03:24] <fgenesis_ie> which is good
[03:24] <alecholowka> http://dev.mysql.com/doc/refman/5.0/en/repair-table.html
[03:24] <fgenesis_ie> oh and btw, with a table repair you can't lose data unless they were lost before the repair, so this is always safe
[03:25] <alecholowka> okay
[03:25] <alecholowka> well maybe we should just try what we were gonna try initially
[03:25] <fgenesis_ie> if the table is fine it just does nothing
[03:25] <fgenesis_ie> yeah lol, i thought you already did that
[03:25] <alecholowka> oh i haven't tried the repair command yet
[03:26] <fgenesis_ie> too bad it cant clear out spambots as well lol
[03:26] <alecholowka> it printed out something
[03:26] <alecholowka> status OK
[03:26] <alecholowka> 1 row in set
[03:26] <fgenesis_ie> uhm
[03:26] <fgenesis_ie> yup, ok
[03:27] <alecholowka> so that table is alright then?
[03:27] <fgenesis_ie> should be
[03:27] <alecholowka> k
[03:27] <fgenesis_ie> try doing that again what produced the error message earlier
[03:27] <fgenesis_ie> if there is more to repair
[03:27] <fgenesis_ie> forum is still white for me
[03:28] <alecholowka> SQL show index from `smf_topics` failed : Table './bb_forum/smf_topics' is marked as crashed and should be repaired
[03:28] <alecholowka> k guess i just try running repair on that
[03:28] <fgenesis_ie> aaand again
[03:28] <alecholowka> status OK
[03:28] <alecholowka> 1 row in set
[03:28] <fgenesis_ie> in the worst case -- SMF has only 41 tables :P
[03:29] <alecholowka> k seems to load in this panel now
[03:29] <alecholowka> but the forum is still down
[03:29] <fgenesis_ie> k, then see if there is such a repair option in the admin panel like i mentionel earlier
[03:29] <fgenesis_ie> did someone (Derek?) move/rename the index.php file?
[03:30] <fgenesis_ie> because i remember there were error messags shown in the first few days
[03:30] <fgenesis_ie> which were gone later, replaced by plain white
[03:30] <alecholowka> hmm
[03:30] <alecholowka> checking
[03:31] <alecholowka> there's an index.php in there
[03:31] <fgenesis_ie> same for the member list, it has always been plain white but this is cool imho, less chances for spambots and email harvesters
[03:32] <alecholowka> welll
[03:32] <alecholowka> not sure what to try now
[03:32] <fgenesis_ie> mysqlcheck -uUSER -p --auto-repair --check --optimize --all-databases
[03:33] <fgenesis_ie> the sledgehammer one
[03:33] <fgenesis_ie> although --optimize is not necessary here imho
[03:34] <alecholowka> k everything was OK or table up to date
[03:34] <fgenesis_ie> cool
[03:34] <alecholowka> forum still does nothing
[03:34] <fgenesis_ie> hmm
[03:34] <fgenesis_ie> then maybe error reporting is disabled in webserver/PHP config?
[03:34] <alecholowka> i dunno
[03:34] <alecholowka> was the forum index.php reporting errors earlier?
[03:34] <fgenesis_ie> would be helpful to see the actual error
[03:34] <fgenesis_ie> yeah
[03:35] <alecholowka> definitely
[03:35] <alecholowka> not sure why it would have stopped
[03:35] <fgenesis_ie> "Unable to select database"
[03:35] <fgenesis_ie> ahh
[03:35] <alecholowka> hrm?
[03:35] <fgenesis_ie> [03:05] <alecholowka> well there's a backup settings php file
[03:35] <fgenesis_ie> backup only?
[03:36] <fgenesis_ie> maybe that file was renamed to turn off the forum?
[03:36] <alecholowka> hmmm
[03:36] <alecholowka> yeah
[03:36] <alecholowka> i'll try
[03:36] <fgenesis_ie> Settings.php <-- that should be there
[03:37] <alecholowka> yaaay
[03:37] <alecholowka> they're back
[03:37] <fgenesis_ie> at least
[03:37] <fgenesis_ie> good job :P
[03:38] <alecholowka> hurray for forums
[03:38]  * fgenesis_ie can spam again
[03:38] <alecholowka> do you have a twitter account i can credit?
[03:38] <fgenesis_ie> nah
[03:38] <fgenesis_ie> do not give credit
[03:38] <alecholowka> : P
[03:38] <fgenesis_ie> because officially i am totally unreachable until 1st september
[03:38] <alecholowka> i'll say thanks to "everyone"
[03:39] <fgenesis_ie> whatever you like
[03:39] <fgenesis_ie> oh and one thing
[03:40] <fgenesis_ie> i'll send you a php and a xml file in some time, can you put that on a web location that will stay reachable for a considerable time? infinieammo.ca maybe?
[03:40] <fgenesis_ie> thought it's the best thing if you do the master/redirection server for the aquaria online mods list i've been working on
[03:41] <fgenesis_ie> because the initial URL needs to be hardcoded
[03:41] <fgenesis_ie> to make it work out of the box
[03:41] <alecholowka> ahh
[03:41] <alecholowka> yeah that'd be cool
[03:41] <alecholowka> wonder what to do about mods on ipad...
[03:41] <alecholowka> maybe just release them as updates to the app
[03:41] <fgenesis_ie> .php just for future extensions
[03:41] <fgenesis_ie> either that
[03:41] <fgenesis_ie> or download and store somewhere
[03:41] <fgenesis_ie> one-file mods already work
[03:42] <fgenesis_ie> dunno if you tried out the builds i have been posting (guess not) :P
[03:42] <fgenesis_ie> so that might work for the ipad as well
[03:42] <alecholowka> oh i haven't had a chance to really check out any mods in a while
[03:43] <fgenesis_ie> eeh, still on the mailing list?
[03:43]  * fgenesis_ie is not chasing anyone for anything
[03:43] <fgenesis_ie> need anything specific?
[03:44] <alecholowka> there's a mailing list for mods?
[03:44] <fgenesis_ie> been hacking away, maybe there's something else that needs to be done?
[03:44] <fgenesis_ie> no
[03:44] <alecholowka> oh
[03:44] <fgenesis_ie> just for code changes
[03:44] <alecholowka> ahh
[03:44] <fgenesis_ie> i meant that one
[03:44] <alecholowka> yeah i'm on that one
[03:44] <fgenesis_ie> because i was talking about code hacking :P
[03:44] <alecholowka> gotcha
[03:45] <alecholowka> andrew + i have been making some changes for the ipad version
[03:45] <alecholowka> i think those might eventually make it into the main open source tree
[03:45] <alecholowka> e
[03:45] <alecholowka> bunch of fixes and little tweaks
[03:45] <fgenesis_ie> before i forget, thanks a lot for the source, i learned a lot from it... things to do, and things not to do :)
[03:45] <fgenesis_ie> i hope it will
[03:45] <alecholowka> and things to make the game a bit easier in the beginning
[03:45] <alecholowka> hehe
[03:45] <fgenesis_ie> andrew said it would be a totally new engine
[03:45] <fgenesis_ie> so no idea to what extent the patches made will be compatible, or if he keeps that stuff up to date
[03:46] <alecholowka> oh well the underlying stuff
[03:46] <alecholowka> yeah
[03:46] <alecholowka> but i think the upper level code still works with the same things
[03:46] <alecholowka> not sure though
[03:46] <fgenesis_ie> "a bit easier"?! noobs that can't play, but that probably applies for too many ipad users... good choice then :P
[03:46] <alecholowka> yeah ipad users are super casual
[03:47] <alecholowka> we're only really tweaking the first part up until you get out into open waters
[03:47] <alecholowka> in terms of difficulty
[03:47] <fgenesis_ie> just a few more hints would do
[03:48] <fgenesis_ie> but that is up to you
[03:48] <fgenesis_ie> http://blog.wolfire.com/2009/01/aquaria-design-tour/
[03:49] <fgenesis_ie> most things that may confuse "casual players" are mentioned there i think
[03:50] <fgenesis_ie> and yes the source for this should be opened as well... gotta poke a friend who hacks stuff for android
[03:50] <fgenesis_ie> might manage to fix up things to run on android, some day
[03:51] <fgenesis_ie> unless that would cause trouble with apple's crappy app store licensing policy
[03:51] <fgenesis_ie> but with the content license in place you should be safe
[03:54] <fgenesis_ie> time to go... almost 3 AM here now >.>
[03:55] <fgenesis_ie> my best wishes for Marian, btw :)
[03:56] <fgenesis_ie> will mail when i have something, until then, bye, good night, and sleep well!