Bonum Certa Men Certa

IRC: #boycottnovell @ FreeNode: February 1st, 2009 - Part 2

GNOME Gedit



Enter the IRC channel now









schestowitzWait, I'll try something tooFeb 01 12:15
schestowitzHere's the thingFeb 01 12:15
schestowitzIt seems like the original DB had no usersFeb 01 12:15
oiaohm2Repair tries to rebuild the database struct.Feb 01 12:15
schestowitzLike the users that was in it just isn't registered with itFeb 01 12:15
oiaohm2Ok the user file of the database could be gone.Feb 01 12:15
schestowitz*userFeb 01 12:15
oiaohm2That might be the extent of the failure.Feb 01 12:16
schestowitzShould I try to reattach the user to the old DB?Feb 01 12:16
oiaohm2I normally like backups on the damaged database before playing any more.  IE file backups not mysql backups.Feb 01 12:16
oiaohm2Rule of recovering data don't edit it without a backup so you can undo your edit.Feb 01 12:17
schestowitzYes, I tryFeb 01 12:17
oiaohm2Basically get it up temp then talk to host.Feb 01 12:17
oiaohm2I guess you don't have access to the raw mysql directories to back that up.Feb 01 12:18
schestowitzHere is the thingFeb 01 12:18
schestowitzI'm glad you are here to help meFeb 01 12:18
schestowitz>> boycottn_wrdp1  81.41 MB    Feb 01 12:18
schestowitzThat's the old databaseFeb 01 12:18
oiaohm2The older one should be twice the size at least.Feb 01 12:18
schestowitzIt has no user attached to it, which is strangeFeb 01 12:18
schestowitzOK, GOODFeb 01 12:19
schestowitzI'm relived!Feb 01 12:19
schestowitzCause for a moment I thought data was maybe lostFeb 01 12:19
oiaohm2Ie new one has not created its backup yet.Feb 01 12:19
schestowitz>> boycottn_wrdp2  37.06 MB  Feb 01 12:19
oiaohm2So it should expand too.Feb 01 12:19
schestowitzThis is the one I just restoredFeb 01 12:19
oiaohm2When that part of the mysql cycle comes around.Feb 01 12:19
schestowitzIt obviously has no user attached to it yetFeb 01 12:19
schestowitzMy question is this:Feb 01 12:19
*amarsh04 (n=amarsh04@ppp121-45-62-63.lns11.adl2.internode.on.net) has joined #boycottnovellFeb 01 12:20
schestowitzis it possible that the old DB was never gone and just the user detached from it?Feb 01 12:20
schestowitzShould I try to reattach it to the old DB?Feb 01 12:20
schestowitzAnd see what happens?Feb 01 12:20
oiaohm2If its not just that damaged doing that will do more damage.Feb 01 12:20
oiaohm2You need the file backups done on there end first.Feb 01 12:21
schestowitzSo should I not reattack user to the old DB?Feb 01 12:21
oiaohm2Not at this time.Feb 01 12:21
schestowitzSom you advise me to just leave itFeb 01 12:21
schestowitzShould I attach it to the new DB in the mean time?Feb 01 12:21
oiaohm2Until you can get the host to back it up filebase.Feb 01 12:21
schestowitzSo that I can serve pages from the old DB?Feb 01 12:21
oiaohm2Yep attached the new database to cover the gap.Feb 01 12:22
schestowitzThanks!Feb 01 12:22
schestowitzWait..Feb 01 12:22
schestowitzAttacch old user or create new one?Feb 01 12:22
oiaohm2And most likely put up post telling users that there is a issue.Feb 01 12:22
schestowitzYesFeb 01 12:22
oiaohm2Is old user used by other database as well.Feb 01 12:23
schestowitzNo, just the broken DBFeb 01 12:23
schestowitzJust one DBFeb 01 12:23
schestowitzBut it's not attached to the old DB for some reasonFeb 01 12:23
oiaohm2I would create a new one.  basically try not to over lap with anything that could explain the problem.Feb 01 12:23
schestowitzOKFeb 01 12:23
oiaohm2Its expermenting without backups that normally make datarecovery down the track impossiable.Feb 01 12:24
oiaohm2Creating new user and new database is not expermienting with your data.Feb 01 12:25
oiaohm2Next time server is intermiting increase you backup cycle too schestowitzFeb 01 12:26
oiaohm2You have backup the wiki?Feb 01 12:26
schestowitzYesFeb 01 12:27
schestowitzoiaohm2: How frequent?Feb 01 12:27
schestowitzI did one at 7am todayFeb 01 12:27
oiaohm2How much are you prepaird to loss.Feb 01 12:28
oiaohm2That is the factor.  Shortest time is dayly.Feb 01 12:28
schestowitzI only wrote about 7 posts since the last backupFeb 01 12:28
schestowitzHmm.. Feb 01 12:29
schestowitzhttp://boycottnovell.com/2009/02/01/androi... WordPress database error: [Table 'boycottn_wrdp2.wp_users' doesn't exist]Feb 01 12:29
schestowitzSELECT * FROM wp_users WHERE user_login = 'schestowitz'Feb 01 12:29
schestowitzIt must be trying the old table names...Feb 01 12:30
schestowitzThis one might have boycottn_wrdp1 <-- 1Feb 01 12:30
schestowitzLet me checkFeb 01 12:30
oiaohm2At least its displaying something now.Feb 01 12:32
oiaohm2Ok complainign about wp_users table being missing.Feb 01 12:32
oiaohm2In these problems something is better than nothing.Feb 01 12:33
schestowitzLet me check mysqladminFeb 01 12:34
schestowitzI'll check the structure of itFeb 01 12:35
schestowitzwp_categories  wp_comments & nbsp;wp_crossreferences   wp_linkcategories  wp_links   wp_options   wp_pollsa   wp_pollsip   wp_pollsq  wp_post2cat  wp_postmeta   wp_posts  Feb 01 12:36
schestowitzNone for users?Feb 01 12:36
oiaohm2That is exactly what the php told you.Feb 01 12:37
oiaohm2It cannot find the users table at all.Feb 01 12:37
schestowitzThere seem to be too few posts as well.Feb 01 12:37
oiaohm2Now I don't know how you backed it up with it.Feb 01 12:37
schestowitzwp_posts had  3,846 recordsFeb 01 12:37
schestowitzLet me check other backups for comparisonFeb 01 12:38
oiaohm2Seams like your backup is not in perfect condition either.Feb 01 12:38
oiaohm2You are really having a bad run.Feb 01 12:38
schestowitzI have backups as HTMLFeb 01 12:38
schestowitzBut those are not needed since the host has BUsFeb 01 12:39
oiaohm2Yep the web equal to paper backups.Feb 01 12:39
schestowitzYesterday it was 19.6MB, today 19.7MBFeb 01 12:39
schestowitzSo the backup was consistentFeb 01 12:40
schestowitzMight this be related to DB size?Feb 01 12:40
schestowitzHere's the thingFeb 01 12:40
schestowitzComment count seems correct..Feb 01 12:40
oiaohm2Wonder if your backup was just on the edge of the splat.Feb 01 12:41
oiaohm2Or the start of the splat.Feb 01 12:41
oiaohm2Do you have a local mysql database server to restore into Yesterday one.Feb 01 12:42
schestowitzYou mean mysqldump?Feb 01 12:42
schestowitzoiaohm2: the backup done with the cpanel front end is weirdFeb 01 12:42
schestowitzIt echoes everything it resoresFeb 01 12:42
schestowitzSo maybe it doesn't restore it entirely.Feb 01 12:42
schestowitzThe page got HUGE... which freezes the browserFeb 01 12:43
schestowitzWaitFeb 01 12:43
schestowitzI'm looking at other WP blogs of mineFeb 01 12:43
schestowitzThey have 12 tablesFeb 01 12:43
schestowitzLike in this casFeb 01 12:43
schestowitzBut different ones.Feb 01 12:44
schestowitzwp_comments  wp_links  wp_options   wp_postmeta  wp_posts  wp_terms  wp_term_relationships   wp_term_taxonomy   wp_usermeta   wp_users   wp_wp2pdf  wp_wp2pdf_fonts  Feb 01 12:44
oiaohm2Notice wp_usersFeb 01 12:44
oiaohm2Other one is missing it.Feb 01 12:44
schestowitzYesFeb 01 12:44
schestowitzBut it misses parts of wp-posts I think... count is too lowFeb 01 12:45
schestowitzSo maybe I should resore from command lineFeb 01 12:45
schestowitzBut the host gives no shellFeb 01 12:45
schestowitzI might have to use cron job in cpanelFeb 01 12:45
oiaohm2NormalFeb 01 12:45
schestowitzOh.Feb 01 12:45
oiaohm2Issue here give you shell you can do major harm.Feb 01 12:46
oiaohm2Reason why you have to wait to do some particular commands.Feb 01 12:46
oiaohm2I love when person can restore locallly.Feb 01 12:46
oiaohm2You have mysqladmin access if we can see yesterdays and todays compare most likely can add the differences back in.Feb 01 12:47
oiaohm2Either todays did not upload right or its never backed up right because the problem was starting.Feb 01 12:47
schestowitzIt increased in size over time thoughFeb 01 12:47
oiaohm2Lets try to work out what one.Feb 01 12:47
schestowitzSo it's not always cutFeb 01 12:48
oiaohm2Increasing size does not mean that the data in there is perfect.Feb 01 12:48
schestowitzDB sizes: boycottn_wrdp1  81.41 MB vs boycottn_wrdp2  37.06 MBFeb 01 12:48
oiaohm2We focus on the backups at this point we cannot backup boycottn_wrp1.Feb 01 12:49
oiaohm2Do you have a local running mysql ?Feb 01 12:49
schestowitzI think that Shane made a lovcal full backup a month agoFeb 01 12:50
schestowitzMe? No... no local sql server on my PCFeb 01 12:50
schestowitzLet me try to upload and rewrite db2 (the one from backup)Feb 01 12:50
oiaohm2You really should have one just in cases these problems happen.Feb 01 12:50
oiaohm2Its lot faster to upload the backups and check them into local than to remote.Feb 01 12:51
schestowitzI thought to meant for hosting the site with remote mysql on my pcFeb 01 12:52
oiaohm2I was meaning for testing of backups.Feb 01 12:52
schestowitzOhFeb 01 12:53
oiaohm2Nothing is worse than thinking you have a backup when you don't.Feb 01 12:53
schestowitzYesFeb 01 12:53
schestowitzThe host has backups too, but not as frequent, AKAIKFeb 01 12:53
schestowitzAFAIKFeb 01 12:53
oiaohm2We basically need to know if todays backup is complete compared to yesterdays.Feb 01 12:54
oiaohm2Ie if current problem is a upload failure or if its a bad backup.Feb 01 12:54
schestowitzYes, I agreeFeb 01 12:54
schestowitzI look at my backupsFeb 01 12:55
oiaohm2Best way for that is loading the both into the local mysql to make sure they restore.Feb 01 12:55
schestowitzThey grew every week.Feb 01 12:55
schestowitz13mb.. 14mb.. 18 mb.. 20mbFeb 01 12:55
oiaohm2Grew is not a good test.Feb 01 12:55
oiaohm2They can grow yet not be restorable.Feb 01 12:55
oiaohm2Restored is always the test.Feb 01 12:55
oiaohm2Backup process.  Backup from server.   Restore on to local check local if fine backup good.Feb 01 12:56
schestowitzI think that because the upload is done on Firefox and the page grows massive, then maybe it times out with incomplete DB uploadFeb 01 12:56
schestowitzoiaohm2: I'll use this tip from now on :-)Feb 01 12:57
oiaohm2If we knew the backup was good we could be sure of that.Feb 01 12:57
oiaohm2Also after restore is proved checksum the backup.Feb 01 12:57
oiaohm2So any other damage can be detected.Feb 01 12:57
oiaohm2Yes the process of backing up a database is longer than most people think.Feb 01 12:57
oiaohm2We need to do the other parts of the backup process we we know where we stand.Feb 01 12:58
schestowitzYesFeb 01 12:58
schestowitzI sort of trusted it cause it grewFeb 01 12:58
schestowitzI still suspsect it's tyhe browser thingFeb 01 12:58
oiaohm2Thing is the page is partly up at the moment.Feb 01 12:59
oiaohm2Partly is better than nothing.Feb 01 12:59
schestowitzWhen the page grows past some threshold, then the Web-based front-end might just..Feb 01 12:59
schestowitzoiaohm2: it's up cause WP connects to the DB and then starts rendering.Feb 01 12:59
oiaohm2If its the web based front end sending another could make it worse.Feb 01 12:59
oiaohm2Ie no page rendering at all.Feb 01 12:59
oiaohm2Because it will all depend on where it breaking.Feb 01 13:00
oiaohm2If its the backup we can send another.Feb 01 13:00
oiaohm2If it rains it pores on you today schestowitzFeb 01 13:00
schestowitzThat's OKFeb 01 13:00
schestowitzwe have other backups (host, home dirFeb 01 13:01
schestowitzBeing stressed won't help, will itFeb 01 13:01
schestowitzOKFeb 01 13:01
schestowitzWait...Feb 01 13:01
schestowitzAhaFeb 01 13:01
oiaohm2I have mastered the art of not being stressed.Feb 01 13:01
schestowitzWait..Feb 01 13:01
schestowitzI look at my backup from last month..Feb 01 13:02
schestowitzInside thee gzip I have wrdp1.sqlFeb 01 13:02
schestowitzSice is 71MBFeb 01 13:02
schestowitzIt's possible that we did another 5-10 MB in the past monthFeb 01 13:02
schestowitzDoes that make sense?Feb 01 13:03
oiaohm2Not really sql is text based.Feb 01 13:03
oiaohm2mysql internal storage is binary.Feb 01 13:03
schestowitzBut regarding sizeFeb 01 13:03
oiaohm2So sql gives no size compare.Feb 01 13:03
oiaohm2Ok what is current backups .sql size.Feb 01 13:04
schestowitzDoes this mean that restoring to about 40MB means we don't pass the whole thing over the Web?Feb 01 13:04
schestowitzThe lastest one (this morning , 7AM) is 82MBFeb 01 13:04
oiaohm2No binary vs .sql binary storage is smaller.Feb 01 13:04
schestowitzThat's the SQL gileFeb 01 13:05
schestowitz*fileFeb 01 13:05
oiaohm2Its the reason why you need to restore those .sql into a local server.Feb 01 13:05
oiaohm2So you can see what there size should be.Feb 01 13:05
schestowitzBut wait...Feb 01 13:05
schestowitzDoes that make sense?Feb 01 13:05
schestowitzIs it true then that the  restored DB ought to be 80+MB if restored properly?Feb 01 13:06
oiaohm2It might be right too.Feb 01 13:06
oiaohm2Depends how much in the .sql struct stores smaller when converted to mysql internal binary format.Feb 01 13:06
schestowitzI've just attempted another resotreFeb 01 13:07
schestowitzLet me check...Feb 01 13:07
oiaohm2Basically you have to restore into a mysql server to size.Feb 01 13:07
schestowitzOh, I see...Feb 01 13:07
schestowitzOK GOODFeb 01 13:10
schestowitzNow my restore is 47MB in sizeFeb 01 13:10
schestowitzCompared to 37MB beforehandFeb 01 13:10
schestowitzThis means that the same file gave inconsistent resored due to browser issue, IMHOFeb 01 13:11
schestowitz*sigh of relief*Feb 01 13:12
schestowitzMaybe it's still uploading it actuallyFeb 01 13:12
schestowitzYesFeb 01 13:13
schestowitzI can see now... it doesn't restore fully.Feb 01 13:14
schestowitzI wish it didn't ECHO everything that's restoredFeb 01 13:14
oiaohm2GreatFeb 01 13:14
schestowitzSo the DB is in okay shapeFeb 01 13:15
oiaohm2Would have been simpler if we could 100 percent trusted the backups.Feb 01 13:15
schestowitzI think the old one too is OKFeb 01 13:15
schestowitzBut it has no user attachedFeb 01 13:15
oiaohm2I am not sure.Feb 01 13:15
oiaohm2Its strange the user disappeared.Feb 01 13:15
schestowitzThen againFeb 01 13:15
oiaohm2I still want host side backup before you play with that one.Feb 01 13:15
schestowitzI think WP would complain about user not being there, not suggest that I 'install' WPFeb 01 13:16
schestowitzoiaohm2: thank you SO muchFeb 01 13:16
oiaohm2I have give a lot of good notes make sure you reread this log and build your self some good producures.Feb 01 13:17
oiaohm2Makes if it happens again lot less worring.Feb 01 13:17
schestowitzMostly about testing BUs locallyFeb 01 13:18
schestowitzAnd cases in which this may recurFeb 01 13:18
schestowitzWe had an incident in 2006 or 2007Feb 01 13:18
schestowitzShane handled it Feb 01 13:18
oiaohm2You need issue handling on paper.Feb 01 13:19
oiaohm2Like not altering failed one without it backed up on host.Feb 01 13:19
oiaohm2If you take my notes here you can build yourself handling instructions just to follow in case of failure.Feb 01 13:19
oiaohm2Lot less worring.Feb 01 13:20
schestowitzI suppose you do some of this for a living (sysadmining)Feb 01 13:20
*Omar871 (n=omar@94.249.1.158) has left #boycottnovellFeb 01 13:20
oiaohm2I am not what you call a normal system admin.Feb 01 13:21
schestowitzYes, the upload is cut abruptly. I can see it nowFeb 01 13:21
oiaohm2I am data recovery and system admin.Feb 01 13:21
schestowitzBut it depends on how much load..Feb 01 13:21
schestowitzI guess the browser times out or somethingFeb 01 13:21
schestowitz8-10-09 03:00:59','',0,'http://boycottnovell.com/2008/10/08/r...',0,'' ,'',0)--------------Feb 01 13:21
schestowitzEND of ECHOFeb 01 13:21
schestowitzNo closing brackets evenFeb 01 13:22
schestowitzAnd in the previous one it didn't get this farFeb 01 13:22
schestowitz37MB vs 40 seomthingFeb 01 13:22
schestowitzMaybe I should try another Web browserFeb 01 13:22
oiaohm2That is kinda the next stop.Feb 01 13:23
oiaohm2Worst case is that is a pure time out limit.Feb 01 13:23
schestowitzI do it from Konqueror nowFeb 01 13:24
schestowitzoiaohm2: that's what I reckonFeb 01 13:24
schestowitzThe first time Firefox didn't even turn out a favicon, which I though was wierdFeb 01 13:25
schestowitz*weirdFeb 01 13:25
schestowitzThis time it was 40 megs. Reattempting.Feb 01 13:31
schestowitzIt sort of doesn't complete the transactionFeb 01 13:32
*schestowitz uploading again (letting the resources be available to the browser)Feb 01 13:36
*oiaohm3 (n=oiaohm@240.120.dsl.brs.iprimus.net.au) has joined #boycottnovellFeb 01 13:40
oiaohm3Bugger connction diedFeb 01 13:40
oiaohm3Try Konqueror really what do you have to lose. schestowitzFeb 01 13:41
schestowitzhttp://boycottnovell.com/irc-channel/Feb 01 13:41
oiaohm3I really do need to find my irc password.Feb 01 13:41
schestowitzOops. Wrong windowsFeb 01 13:41
*lar2 (wonderland) has joined #boycottnovellFeb 01 13:41
schestowitzoiaohm3: I do pw nowFeb 01 13:42
lar2ok figured out IRCFeb 01 13:42
schestowitzHey, lar2 Feb 01 13:42
lar2heyFeb 01 13:42
schestowitzWe had a DB failureFeb 01 13:42
lar2what symptomsFeb 01 13:42
schestowitzI suppose you saw the errorFeb 01 13:42
lar2?Feb 01 13:42
lar2yesFeb 01 13:42
lar2wpFeb 01 13:42
schestowitzoiaohm2 here is a DB recovery expert we're lucky to haveFeb 01 13:42
schestowitzmysql, not wpFeb 01 13:43
schestowitzYes, wp couldn't find the DB or userFeb 01 13:43
schestowitzWordPress wouldn't tellFeb 01 13:43
oiaohm3Currnet oiaohm3 until oiaohm2 diesFeb 01 13:43
schestowitzBut the db vanished from the backup page in cpanelFeb 01 13:43
schestowitzBut it's still there in DB listFeb 01 13:43
oiaohm3Yes I really do need to find where I put that password for my IRC account.Feb 01 13:43
lar2was the wp user still there in the table 'mysql' ?Feb 01 13:43
schestowitzI can't access it from phpmysqladminFeb 01 13:43
schestowitzI can still see it there thoughFeb 01 13:43
schestowitzIt also lost attachment to the userFeb 01 13:44
schestowitzDB user that isFeb 01 13:44
lar2how about accessing it from the client in the shellFeb 01 13:44
oiaohm3Remote host lar2Feb 01 13:44
schestowitzSo what you see in bn.com now is a sem-complete restoreFeb 01 13:44
oiaohm3Makes life a little hard.Feb 01 13:44
schestowitzI can't get it to restore the whole lumpFeb 01 13:44
lar2if it's really hosed you need to run from mysqladminFeb 01 13:44
schestowitzBut I have full BUFeb 01 13:44
lar2you might have it set up to make incremental backups every time you post an articleFeb 01 13:44
schestowitzlar2: user as in user table or user as in DB user?Feb 01 13:45
lar2user as in the table 'mysql'Feb 01 13:45
lar2that's the table with all the db usersFeb 01 13:45
schestowitzlar2: yesFeb 01 13:45
lar2that points to privileges to the database that wp usesFeb 01 13:45
oiaohm3Issue here not all users disappeared.Feb 01 13:45
schestowitzThe backup you see now in BN was not /restored/ fullyFeb 01 13:45
schestowitzBut I have pretty good backup from 7amFeb 01 13:45
oiaohm3Ie db users.Feb 01 13:46
schestowitzThe rest I could get from static front page or restore manually, but I 'd rather wait for host to check original DBFeb 01 13:46
schestowitzThe one that's 'broken'Feb 01 13:46
lar2is there an external (ideally stackless) log server to do forensics with ?Feb 01 13:46
schestowitzI can't even "check" or "repair" ols DB. It's there, but cpanel doesn't let me play with itFeb 01 13:47
lar2can you get access to a shell and run 'mysql' right from the shell?Feb 01 13:47
schestowitzoiaohm2: wiki users is still there for wiki DBFeb 01 13:47
schestowitzlar2: log server for mysql?Feb 01 13:48
oiaohm3Exactly mysql did not complete drop the ball.Feb 01 13:48
lar2yes, logserver for mysql, apache and the hostFeb 01 13:48
schestowitzI only have the web log (mostly php errors)Feb 01 13:48
schestowitzI looked at itFeb 01 13:48
schestowitzNothing interesting thereFeb 01 13:48
schestowitzJust some old php warnings.Feb 01 13:48
schestowitzI only have access to http log Feb 01 13:49
schestowitzmaybe ftp tooFeb 01 13:49
lar2web interfaces for administration only work when everything is perfect, so the main administrators should always strive to stay in practice with the shellFeb 01 13:49
schestowitzBut not anything beneath itFeb 01 13:49
lar2web log might be enough, but there should also be a mysql log somewhereFeb 01 13:49
schestowitzWhat filename?Feb 01 13:49
*oiaohm2 has quit (Read error: 110 (Connection timed out))Feb 01 13:50
oiaohm3Paided hosting lar2.  shell not alway forth coming.Feb 01 13:50
lar2just a sec, gotta install mysql-serverFeb 01 13:50
schestowitzThanks a lotFeb 01 13:50
lar2oiaohm3: no shell, no money from me!Feb 01 13:51
lar2shell is a prerequisite for hosting@!Feb 01 13:51
oiaohm3This case we have to work with what we have lar2 no what we wish for.Feb 01 13:52
oiaohm3I asked if he had shell as one of the first things.Feb 01 13:52
lar2yes, the cleanup must occur first , then move to shell accountFeb 01 13:53
lar2slow net : 216kB/sFeb 01 13:53
lar2mysql logs are often here:Feb 01 13:54
lar2$ find /var/log/ -name 'mysql*' -printFeb 01 13:54
lar2/var/log/mysql.logFeb 01 13:54
lar2/var/log/mysql.errFeb 01 13:54
lar2/var/log/mysqlFeb 01 13:54
schestowitzOhFeb 01 13:54
schestowitzI can't get that 'far'Feb 01 13:54
oiaohm3We are very much down to host restore.Feb 01 13:54
schestowitzunless I do a cronjob maybeFeb 01 13:54
oiaohm3maybe is the real thing here.Feb 01 13:55
oiaohm3Secuirty can block your access from that as well.Feb 01 13:55
schestowitzYes, I know.Feb 01 13:55
oiaohm3I have to get to bed is midnight here.Feb 01 13:55
schestowitzoiaohm3: thank you for the helpFeb 01 13:55
oiaohm3More sane time where you are lar2?Feb 01 13:55
schestowitzlar2: I think I'll try to restore from morning backup (7am) and then ask host to check the old DB (11am)Feb 01 13:56
schestowitzIn the mean time I created a second similar DB to just serve pages.Feb 01 13:57
schestowitzBut I can't upload it properly.Feb 01 13:57
oiaohm3I would recommend db3Feb 01 13:57
schestowitzIt seems to time out at the browser, but at varying points along the way depending on timeouts, system load..Feb 01 13:57
schestowitzA third one?Feb 01 13:57
oiaohm3Ie third one for upload attemptsFeb 01 13:57
schestowitzOhFeb 01 13:58
oiaohm3So you only stay on the best.Feb 01 13:58
schestowitzOK, good.Feb 01 13:58
oiaohm3No point ended up worse.Feb 01 13:58
schestowitzLast upload was lame.. 20.53 MBFeb 01 13:58
schestowitzSo I shaved off data!Feb 01 13:58
schestowitzI'll try againFeb 01 13:58
oiaohm3If everything goes ok everything should be back to normal ish in 24 hours.Feb 01 13:59
oiaohm3Worst case is when you end up having to email backup to host so they can restore it.Feb 01 13:59
oiaohm3Boy that suxsFeb 01 14:00
schestowitzYesFeb 01 14:00
schestowitzBetter than rotten backupsFeb 01 14:00
oiaohm3DependsFeb 01 14:00
oiaohm3If you internet connection has good completely suspect is hell.Feb 01 14:01
oiaohm3good/goneFeb 01 14:01
schestowitzWhat do you mean?Feb 01 14:01
schestowitzOh, well.. on the servers,, right?Feb 01 14:01
schestowitzI could work from my office if the Net was down at home.Feb 01 14:01
schestowitzDone this in Sept.Feb 01 14:02
oiaohm3I have had the busness adsl line here go problem.Feb 01 14:02
oiaohm3Without notice.  So tried to restore threw web failed.  Tried to email it up and it was also damaged.Feb 01 14:02
oiaohm3Reason line I had was stuffed.Feb 01 14:02
oiaohm3Took ages to find out that was the case.Feb 01 14:02
oiaohm3Your ISP static IP where you are uploading from.Feb 01 14:03
oiaohm3Just had a bad idea have had problems from time to time with large uploads from dynamic IP ISP's.Feb 01 14:03
oiaohm3Hopefully by the time I am back on Line you still don't need me schestowitzFeb 01 14:04
*oiaohm3 has quit (Remote closed the connection)Feb 01 14:04
schestowitzlar2: I'm starting a third DBFeb 01 14:07
schestowitzI wish cpanel wasn't stupid enough to ECHO the whole thing doing restoreFeb 01 14:07
trmancoschestowitz, another fish nym on COLA?Feb 01 14:09
schestowitzYes, many appear all the timeFeb 01 14:09
trmancoso BN is infected with a virus :-PFeb 01 14:10
schestowitzNoFeb 01 14:10
schestowitzHost errorsFeb 01 14:10
schestowitzyesterday it was too much loadFeb 01 14:10
schestowitzAnd today the DB went bonkersFeb 01 14:10
schestowitzRelated to load tooFeb 01 14:10
schestowitzSo it needs attention from the hostFeb 01 14:11
schestowitzIt ought to be possible to fix, but I don't want to do anything without them backing it up firstFeb 01 14:11
lar2just a complex thought hereFeb 01 14:11
lar2mysql can do automatic replication, that could be used to mirror the data off siteFeb 01 14:11
lar2from there full backups could be done each time a new article is added with less load on the main serverFeb 01 14:11
schestowitzReally?Feb 01 14:11
trmancoschestowitz, I was just kidding :-OFeb 01 14:11
trmanco:-P*Feb 01 14:11
schestowitzCan I replicate without CLI access?Feb 01 14:11
schestowitztrmanco: I knowFeb 01 14:11
lar2CLI ?Feb 01 14:11
schestowitztrmanco: but it's easy for some people to be fooled.Feb 01 14:12
trmancothey should just check from themselvesFeb 01 14:12
schestowitzlar2: how can I replicate a DB?Feb 01 14:12
schestowitzin Cpanel that is..Feb 01 14:12
schestowitzI have:Feb 01 14:13
schestowitzboycottn_wiki  2.05 MB   Feb 01 14:13
schestowitzboycottn_wki Delete UserFeb 01 14:13
schestowitzDelete DatabaseFeb 01 14:13
schestowitzboycottn_wrdp1 81.41 MB  Feb 01 14:13
schestowitzDelete DatabaseFeb 01 14:13
schestowitzboycottn_wrdp2 45.35 MB  Feb 01 14:13
schestowitzboycottn_wrdp2 Delete UserFeb 01 14:13
schestowitzDelete DatabaseFeb 01 14:13
schestowitzboycottn_wrdp3 45.35 MB  Feb 01 14:13
schestowitzDelete DatabaseFeb 01 14:13
trmanco:OFeb 01 14:13
trmanco3 databases?Feb 01 14:13
schestowitzThat second and third (well, 3rd and 4th) are my uploads Feb 01 14:14
schestowitztrmanco: the first is the originalFeb 01 14:14
schestowitzI needs admins to check itFeb 01 14:14
trmancowow 81 megs is hugeFeb 01 14:14
schestowitzI try to replicate onto other dbs and then load BN from theseFeb 01 14:14
trmancomine only gas aout 7 :-PFeb 01 14:14
schestowitztrmanco: yes, we have a lot of textFeb 01 14:14
trmancoyou can make a landing page, with some mirrorsFeb 01 14:15
lar2for replication, you'll need at least on other machine, any *nix will do, even your desktopFeb 01 14:15
schestowitzIf only I could copy from boycottn_wrdp1 to anoter slotFeb 01 14:15
trmancoschestowitz, 404 no found?Feb 01 14:15
lar2http://dev.mysql.com/doc/refman/5...Feb 01 14:15
schestowitztrmanco: ignore the site's output for nowFeb 01 14:15
trmancookFeb 01 14:16
schestowitzI just try to restore something temporarilyFeb 01 14:16
trmancoschestowitz, if you need some help, just askFeb 01 14:16
schestowitzThanks.Feb 01 14:16
schestowitzlar2: do you suggest I ran the DB locally?Feb 01 14:17
trmancomy host can try and handle some of your loadFeb 01 14:17
*schestowitz installed mysqlFeb 01 14:18
schestowitzI'll need it to test backups anywayFeb 01 14:18
lar2yes, that's one way run the slave locallyFeb 01 14:19
lar2it's a small db, right?  <= 100MBFeb 01 14:19
schestowitzYesFeb 01 14:20
schestowitzBut heavy load, I thinkFeb 01 14:20
schestowitzNone for Mandriva: http://dev.mysql.com/downloads...Feb 01 14:21
schestowitzThe repo doesn't give the option either.Feb 01 14:21
trmancojust found this: http://identi.ca/rmsFeb 01 14:22
schestowitzOK, I contacted the hostFeb 01 14:28
schestowitzUrgent - DB issue For no reason (other than heavy load), the WordPress DB, boycottn_wrdp1, was suddenly made unavailble. I can't touch it from mysqladmin and I can't make a backup of it, but it's still there on the server (I can see it in list of databases) and for some reason it also dropped its only DB-user. Feb 01 14:28
schestowitzAn admin with full access to the box needs to check what happened to this DB and restore its working order with the DB-user connected to it so that WordPress can communicate with it.Feb 01 14:28
schestowitzIn the mean time, I have created incomplete copies of this database (backed up hours before it sort of crashed) in boycottn_wrdp2 and boycottn_wrdp3 and I try to have WordPress access them as temporary solutions.Feb 01 14:28
schestowitzThat pretty much sums up the situationFeb 01 14:28
lar2it'd be important to find out how the only DB-user got droppedFeb 01 14:30
schestowitzYesFeb 01 14:31
schestowitzThere is another user in Wiki DBFeb 01 14:31
schestowitzIt stayed... and so has the DBFeb 01 14:31
schestowitzSo the DB decided to run away (it's still there, just not accessible) and the user is not tied to it.Feb 01 14:32
schestowitzLinux injured KDE: http://aseigo.blogspot.com/2009/01/i-...Feb 01 14:33
lar2the user from the mysql db or from the boycottn_wrdp db ?Feb 01 14:35
*maxstirner (n=user@xdsl-87-79-134-116.netcologne.de) has joined #boycottnovellFeb 01 14:35
schestowitzFrom the mysql dbFeb 01 14:35
schestowitzNot the WordPress one.Feb 01 14:35
maxstirneroh youre discussing the problem alreadyFeb 01 14:36
maxstirnerwas just tgoing to point out..Feb 01 14:36
schestowitzYes..Feb 01 14:36
schestowitzI get E-mails about it too.Feb 01 14:36
schestowitzKonqueror stops uploading after 45 MBFeb 01 14:37
schestowitzmaxstirner: I try to restore from backup to new slotsFeb 01 14:37
schestowitzBut it's too big for the browsersFeb 01 14:37
lar2scp, sftp insteadFeb 01 14:37
lar2or use ssh to tunnel to the mysql db and use the clients locallyFeb 01 14:38
schestowitzlar2: where need to mysql file be though?Feb 01 14:38
schestowitzNot in public_html or /home/useraccountFeb 01 14:39
lar2for the ssh tunnel, it can be on your local machineFeb 01 14:39
schestowitzYou're thinking about running the site off my desktopFeb 01 14:39
lar2not in that example,Feb 01 14:39
schestowitzOhFeb 01 14:40
lar2that would be restoring the server from your desktopFeb 01 14:40
schestowitzBut I can't SSH to my serverFeb 01 14:40
lar2?!?!?!?!Feb 01 14:40
schestowitzI can'tFeb 01 14:40
lar2what happenedFeb 01 14:40
schestowitzHost won't let that beFeb 01 14:40
lar2new host!Feb 01 14:40
*maxstirner (n=user@xdsl-87-79-134-116.netcologne.de) has left #boycottnovellFeb 01 14:40
schestowitzI can't bear the thought of E-mailing people big mysql DBsFeb 01 14:42
schestowitzWith passwords and all.Feb 01 14:42
schestowitzKonqueror uploads just 45.35 MB, FF does 20.53 MBFeb 01 14:43
lar2don't email data, please, please, that's an artifact of how the technological failure of MS-based infrastructure have damaged behaviorsFeb 01 14:43
schestowitzLet me try to upload from the Fedora roomsFeb 01 14:44
schestowitz*LOL*Feb 01 14:46
schestowitzFirefox 3 gives me EULA on FeodraFeb 01 14:46
schestowitzlet's try OperaFeb 01 14:55
schestowitzOpera does decently so farFeb 01 14:59
schestowitzLet's see when it gives up..Feb 01 14:59
schestowitzFirefox give up at the earliest stage, Konqueror better, but the testing conditions are not identical.Feb 01 15:00
lar2you are uploading to the host service via some upload form?Feb 01 15:00
schestowitzYesFeb 01 15:00
schestowitzPreciselyFeb 01 15:00
schestowitzI use the Fedora clusters nowFeb 01 15:00
schestowitzMore powerful machines, tons of software installed on the domainFeb 01 15:01
schestowitzOpera still going :-)Feb 01 15:01
schestowitz48 MBFeb 01 15:01
schestowitzIt needs to reach 81Feb 01 15:01
schestowitzFirefox does about 21 on both Mandriva  and FedoraFeb 01 15:01
schestowitzSometimes 40MBFeb 01 15:01
schestowitzFirefox 2 and 3 respectivelyFeb 01 15:01
schestowitz57MB :-)Feb 01 15:02
schestowitzIf it completes it, then BN become accessible at leastFeb 01 15:02
schestowitzWe lost another Digg front page because of this messFeb 01 15:02
schestowitz65MB..Feb 01 15:02
schestowitzFingers crossed..Feb 01 15:02
schestowitzAh! Bless Norway, now let's change some vars.Feb 01 15:04
schestowitzboycottn_wrdp1  81.41 MBFeb 01 15:04
schestowitzboycottn_wrdp3  80.89 MBFeb 01 15:04
schestowitz4-hour diffFeb 01 15:04
schestowitzOK :-)Feb 01 15:05
schestowitzWe didn't lose much then.Feb 01 15:05
schestowitzMaybe it's better to just let the old DB done and restore the diffs manually.Feb 01 15:05
schestowitzhttp://boycottnovell.com/Feb 01 15:06
schestowitzBless Opera!Feb 01 15:06
lar2excellentFeb 01 15:07
schestowitzHold onFeb 01 15:11
schestowitzI'll ensure no data lossFeb 01 15:11
lar2ok but now the forensics to be able to avoid a repeatFeb 01 15:16
schestowitzOK comments shutFeb 01 15:17
schestowitzI posted a notificartionFeb 01 15:17
schestowitzYes, that's the thingFeb 01 15:17
schestowitzI'd rather use the old DB after diagnosticsFeb 01 15:17
schestowitzThis one at least serves as an archiveFeb 01 15:18
schestowitzMost of our visitors (like 50%+) are not subscribers but people who read our archives (5000 posts)Feb 01 15:18
schestowitzSo I don't mind freezing it like Groklaw for a little while.Feb 01 15:18
schestowitzWe lost a front page methinks :-( ... http://digg.com/linux_unix/Bill_Gates_on_Lin...Feb 01 15:19
lar2too bad,Feb 01 15:20
lar2it's a good one thoughFeb 01 15:20
lar2the iowa case had good stuff onlineFeb 01 15:21
schestowitzYeah..Feb 01 15:21
schestowitzBut I began worrying about it alll... you know, being resotredFeb 01 15:21
schestowitzPJ mailed me last nigthFeb 01 15:21
lar2which is probably why ms settled so quicklyFeb 01 15:21
schestowitzShe's not posting properly anymore, just member-onlies.Feb 01 15:21
lar2i noticedFeb 01 15:21
schestowitzWith "sign --Groklaw team")Feb 01 15:21
schestowitz*sinedFeb 01 15:21
schestowitz*signedFeb 01 15:21
lar2have they stepped up the harassment or threats against her?Feb 01 15:22
schestowitzBut the preservation part if importanytFeb 01 15:22
schestowitzWe get heaps of archives being used and not by the chair (to which we preach)Feb 01 15:22
schestowitzlar2: if so, they got their way, which pisses me offFeb 01 15:22
lar2the preservation is very useful, but they could be better indexed or catalogedFeb 01 15:22
schestowitzWhen I was a PhD student (2006) I was getting lots of harrassment like that for MERELY PROMOTING LinuxFeb 01 15:23
schestowitzSo I said, look... if I quit now, they winFeb 01 15:23
schestowitzInstead they only urged me to dig up the filth and write about my findingsFeb 01 15:23
schestowitzlar2: indexing will be done over time. When I have many pages like OOXML corruption, then I set up an indexFeb 01 15:24
schestowitzGroklaw rebuilds SCO indices now.Feb 01 15:24
schestowitzBecause SCO is practically over if you ignore yesterday noise from MOGFeb 01 15:24
lar2yes, but she seems to be missing or not willing to deal with the appearance that everything with SCO the last 3 years seems to be setting the stage for novell to be the next scoFeb 01 15:32
schestowitzYesFeb 01 15:33
schestowitzSomeone else said thisFeb 01 15:33
schestowitzI believe she's concerned about posting SCO-hostile stuff. I don't know if the threats keep it quiet. Either way, that along with Technocrat and Linux.com, is a major loss to us as a reporting assetFeb 01 15:33
lar2i have some comments offline about technocrat,Feb 01 15:39
lar2i saw newsforge folding *way* back, then linux.comFeb 01 15:39
lar2it'd be useful to get daylight on what's going on with linux.comFeb 01 15:39
schestowitzYesFeb 01 15:42
schestowitzI look carefullyFeb 01 15:42
schestowitzNothing major have I heard since........Feb 01 15:42
schestowitzTechnocrat.. same here. Lost comments... I mailed Bruce about it asking for archives to stay, but alas no response ...Feb 01 15:43
schestowitzChina birth defects 'up sharply' < http://news.bbc.co.uk/1/hi/worl... > Pollution deathsFeb 01 15:43
lar2yeah defect-causing pollution is very wide spread, more than most are willing to face up to...Feb 01 15:46
lar2it's basically everywhereFeb 01 15:46
schestowitzIn the UK, you now get fines for shooting pics.. http://www.flickr.com/photos/22658121@N00... (The €£50 Photograph)Feb 01 15:47
lar2even in norway, the brits have dump nuke cores which make there way quickly up the food chain till the birds shit technium onto the landFeb 01 15:47
schestowitz"Then a voice behind me demanded that I stop whatever I was doing. It was a policeman. Two policemen. They talked in very stern terms about terrorism and security.. But is this kind of incident getting out of control? I'm hearing more & more stories like this from friends who take photographs, and quite frankly, it scares the hell out of me. "Feb 01 15:47
lar2lame that the photographers knuckled underFeb 01 15:48
schestowitzI just LOVE this one: http://www.boingboing.net/2008/07/...Feb 01 15:49
schestowitzThey let the white-collar criminals go and chase old ladies that are supposedly child-molesting terrorists because they bought some cameras they play with on a tripFeb 01 15:49
lar2reminds me of a story a friend had when pumping gas in SC one Dec 23rd,Feb 01 15:50
lar2the sheriff gave him the option of paying the fine right  then and there, in cash, or settin his as in jail till the sheriff's brother inlaw the judge could come back after newyears to hear the case...Feb 01 15:50
lar2hey if they were using the laws for pursuing white collar crime pretty much every MS gold partner would be locked up, it's much easier and for some small-balled individuals to go shake down old ladies insteadFeb 01 15:51
schestowitzIn a world of Barbarians, punching someone in the face is acutely "impolite"Feb 01 15:51
schestowitz“Microsoft’s perspective is best reflected by Bob Herbold, Chief Operating Officer, to whom the CFO reports. Bob very sincerely replied, “Bill, everyone is doing it.”" http://www.billparish.com/msftfra...Feb 01 15:52
lar2they appear to have copied enrons methods after running the loss in 1998Feb 01 15:53
schestowitzSony's Profits Down 95% < http://www.osnews.com/story/20889/Son... >Feb 01 15:53
schestowitzCost of DRM, eh?Feb 01 15:53
lar2wouln't surprise me if most of their money comes from printing new stock / buybacksFeb 01 15:53
schestowitzhttp://schestowitz.com/temp/research...Feb 01 15:53
schestowitzI'm still poised to do an article about DRM  (Comes)Feb 01 15:54
schestowitzBut BN is on freeze nowFeb 01 15:54
schestowitzhttp://boycottnovell.com/wiki/ind...Feb 01 15:54
schestowitzlar2: re: printing money, see the Bill Parish piece. That's just what they do. The gains go from Mom&Pop investors (esp. in the past year) into the 'safe' (Ballmer@Switzerland, Gates Foundry)Feb 01 15:55
PetoKrausschestowitz: how's your DB restore goint?Feb 01 15:56
schestowitzEch..Feb 01 15:56
schestowitzI'll stop posting until the host comes up with somethingFeb 01 15:57
PetoKrausyeahFeb 01 15:57
schestowitzNo data was lost though, so no duplicate labourFeb 01 15:57
schestowitzI could restore within 20-30 minutes, but I could just wait and hear a diagnosisFeb 01 15:58
schestowitzMerging two DBs isn't fun, not at this scale (81MB)Feb 01 15:58
PetoKrausyahFeb 01 15:58
schestowitzMicrosoft 'Quality Control' = [Q]uality for the stock and for Microsoft to [C]ontrol minds: http://www.osnews.com/story/20884/Only_O... The [U]ser?? Na... that's just a 'side-effect... let them east VistaFeb 01 15:59
lar2anything about windows 7 is really just chaff - the topic at hand is vista failure, vista drm and ubuntu and other distros rocketingFeb 01 16:00
schestowitzNoFeb 01 16:00
schestowitzThey change the topic :-)Feb 01 16:00
schestowitzThat's the thingFeb 01 16:00
lar2only if they are allowedFeb 01 16:00
schestowitzI did a semi-scinetific thingFeb 01 16:00
lar2elaborate pelaseFeb 01 16:00
schestowitzEvery Sat/Sun I look at 600 news items on 'microsoft' (Google News)Feb 01 16:01
schestowitzI handle them by slicing with filtersFeb 01 16:01
schestowitzFirst 'vista'Feb 01 16:01
schestowitzthen 'down 7'Feb 01 16:01
schestowitz*'dows 7'Feb 01 16:01
schestowitzGuess what? Vista doesn't exist anymoreFeb 01 16:01
lar2i often wonder how much help they get with that from insiders at googleFeb 01 16:01
schestowitzFor the past 2 months I have done this test. Wrote about this briefly in BN (twice) and also in IRC and USENETFeb 01 16:02
lar2google has been polluting itself with MS hires for a long while and leopards don't change their spotsFeb 01 16:02
schestowitzsearch the GOOG for "Vista 7"Feb 01 16:02
schestowitzPage 1 is usFeb 01 16:02
lar2LOLFeb 01 16:02
schestowitzAproposFeb 01 16:02
schestowitzWait..Feb 01 16:02
lar2IIRC opendocument was torpedoed in google news starting since aug 2007Feb 01 16:02
schestowitzOK, got it...Feb 01 16:03
schestowitzhttp://www.techcrunch.com/2009/01/...Feb 01 16:03
schestowitzSee theseFeb 01 16:03
schestowitz"From: StephenFeb 01 16:04
schestowitzDate: Wed, 28 May 2008 13:25:07 -0700 (PDT)Feb 01 16:04
schestowitzLocal: Wed, May 28 2008 2:25 pmFeb 01 16:04
schestowitzSubject: Re: So… Why’d you left, guys? I mean, seriously.Feb 01 16:04
schestowitzActually, I hit the Send button on this before I intended to.Feb 01 16:04
schestowitzI left Microsoft to work for Google in 2005. I stayed 10 months. IFeb 01 16:04
schestowitzwas demoralized. I shouldn’t have ever taken that job. I wasFeb 01 16:04
schestowitzdisenchanted the whole time, and yes, like you, my regret over theFeb 01 16:04
schestowitzpoor bargain I’d made affected my performance."Feb 01 16:04
schestowitz--------------Feb 01 16:04
schestowitz"From: TedFeb 01 16:04
schestowitzDate: Wed, 28 May 2008 17:39:06 -0700 (PDT)Feb 01 16:04
schestowitzLocal: Wed, May 28 2008 6:39 pmFeb 01 16:04
schestowitzSubject: Re: So… Why’d you left, guys? I mean, seriously."Feb 01 16:04
schestowitz[...]Feb 01 16:04
schestowitz"Also I was surprised that Google seemed to be proud that they didn’tFeb 01 16:04
schestowitzcommunicate from one interviewer to the next: at Microsoft it was aFeb 01 16:04
schestowitzgood opportunity to find more appropriate interviewers, etc. if aFeb 01 16:04
schestowitzperson seemed misslated. Oh well, I thought my interview and hiringFeb 01 16:04
schestowitzprocess was an anomaly."Feb 01 16:04
schestowitz=====Feb 01 16:04
schestowitzTechCrunch is run by Michael Arrington (aka "spit in face")Feb 01 16:05
schestowitzhttp://web2.commongate.com/post/Micr...Feb 01 16:05
schestowitz"Valleywag is taking Mike Arrington, Om Malik, and John Battelle to task for allegedly doing a Federated Media version of “pay to post”. "Feb 01 16:05
schestowitzhttp://www.techcrunch.com/2009/01...Feb 01 16:05
schestowitz"by Michael Arrington on January 18, 2009"Feb 01 16:06
schestowitzhttp://www.techcrunch.com/Feb 01 16:06
schestowitz2 million readers (claimed)Feb 01 16:06
schestowitzTakeaway message: "Google sucks to work for, I wanna be back to Redmond"Feb 01 16:06
lar2trolling i presumeFeb 01 16:07
lar2i have contact with a few "former" softersFeb 01 16:07
schestowitz"In 2008 Google HR set up a private Google Group to ask former employees why they left the company. We’ve been forwarded what appears to be authentic posts to the thread by a number of ex-Googlers, which we reprint below minus identifying information other than their first names."Feb 01 16:07
schestowitzForwarded?Feb 01 16:07
schestowitzBy whom?Feb 01 16:07
schestowitzHow did he get that?Feb 01 16:07
schestowitzW-E?Feb 01 16:07
lar2lame, lazy and stupid in their own wayFeb 01 16:07
schestowitzAndre de La Costa du jour?Feb 01 16:08
schestowitzIn USENET (earlier today) a 18-year ols Microsoft veteran posted in the Linux advocacy NGFeb 01 16:08
schestowitzHe struck back at [H]omer, who wrote about Microsoft putting $$$ on GNU's table (FSF donation)Feb 01 16:08
schestowitzI called it hush-hush money. RMS et al could use the money after all.Feb 01 16:09
schestowitzThe Turfers love pointing to this < http://www.fsf.org/licensing/licenses/ > page, which now contains Microsoft licences after some prodding from LWN.net from what I could once gather. FSF very reluctantly put the ms-* in therFeb 01 16:10
lar2hey, one of the costs that's adding to the economic hardships is the failure of windows to be able to manage files, very different from real systemsFeb 01 16:10
schestowitzThat's what MCSEs are forFeb 01 16:11
schestowitzA dozen per box (overstating)Feb 01 16:11
schestowitzRex calls em "box booters"Feb 01 16:11
lar2yeah but they're only there to burn out the user so that they give up on getting their files backFeb 01 16:11
schestowitzOf course, you could also call them Registry/malware cleaners/defraggers etc etcFeb 01 16:12
schestowitzWhat I did today on the BN server was caused by million of hits on one boxFeb 01 16:12
schestowitzAnd it hasn't happened to me in like.. EVER!Feb 01 16:12
lar2another item is the ecological and economic catastrophes in the server room, i see that it looks like every shop with servers infected with MS have worse than 1:1 service:server ratio.Feb 01 16:12
schestowitzI never needed to repair a mysql DB in 5 years of handling (now) about 20+ DBsFeb 01 16:13
lar2at 300W - 500W a whack, that adds upFeb 01 16:13
lar2can you give more details (sanitized if necessary) on how the service was slashdotted?Feb 01 16:13
schestowitzThe MSFTers stormed all over this one: http://digg.com/linux_unix/Microsoft_o...Feb 01 16:13
schestowitzlar2: What do you mean by /.ed?Feb 01 16:14
lar2too much user loadFeb 01 16:14
schestowitzI have it from a reliable source that /. is gamed by MS hires'peripheral agents.Feb 01 16:14
schestowitzSame in Digg, naturally (but I don't have it said from Digg staff)Feb 01 16:14
lar2i can see that, tooFeb 01 16:14
lar2i never run into the old /. staff to be sureFeb 01 16:15
schestowitzlar2: say I need to do 200 db queries per pageFeb 01 16:15
schestowitzit's not staticFeb 01 16:15
schestowitzI have corss-refs (done on the fly)Feb 01 16:15
schestowitzThat's how I get so many so quicklyFeb 01 16:15
lar2its to the point that background checks need to cover redmond tiesFeb 01 16:15
schestowitzSo if we get 1000 visit per hours, that's a lot of db thrashingFeb 01 16:15
schestowitzPLUS... we cross-link..Feb 01 16:15
lar2do you have pound in front?Feb 01 16:15
schestowitzYou know what that means... people stick around, so more page requestsFeb 01 16:16
lar2sounds like you need a reverse proxyFeb 01 16:16
schestowitzIf it loads at all..Feb 01 16:16
lar2the db is only needed for the first load or  for interactive workFeb 01 16:16
lar2such as commentsFeb 01 16:16
schestowitzYesFeb 01 16:16
schestowitzI use CoralFeb 01 16:16
schestowitzI close comments, then throw it over there.Feb 01 16:16
schestowitzBut peole depart from the page, so it's no longer staticFeb 01 16:16
lar2http://www.squid-cache.org/Feb 01 16:17
lar2http://www.apsis.ch/pound/Feb 01 16:17
schestowitzI couldn't care less about whether traffic is measured on BN or some $ProxyPoxy.. as long as people manage the read the stuffFeb 01 16:17
schestowitzWordPress has memcacheFeb 01 16:17
schestowitzBut Ryan Boren dropped it at the time, IIRCFeb 01 16:18
schestowitzI was more closely involved in WP at the time.Feb 01 16:18
schestowitzIt caused trouble and they tropped itFeb 01 16:18
schestowitz*droppedFeb 01 16:18
lar2no need for them to reinvent the wheel, squid or pound might do enoughFeb 01 16:18
schestowitzAnd we use the 'Debian' version (5-year LTS) of  WordPress, so it lags behind and gets security patchesFeb 01 16:18
schestowitzThis reminds me I need to produce the monthly WordPress-Hackers stats for the mailing listFeb 01 16:19
lar2patches are good, upgrades == suprises == :(Feb 01 16:19
lar2lagging behind == predictable == goodFeb 01 16:19
lar2from a sysadmin perspectiveFeb 01 16:19
*schestowitz looks at URLSFeb 01 16:19
schestowitzYesFeb 01 16:19
schestowitzThat's what I sayFeb 01 16:19
schestowitzPlugins especiallyFeb 01 16:19
schestowitzI'm almost frantic about having to reprogram my plugins myselfFeb 01 16:20
schestowitzMy cross-refs ALL depend on it.Feb 01 16:20
schestowitzAbout 20,000+ (!!) cross-refsFeb 01 16:20
lar2hmm interesting research material,Feb 01 16:20
schestowitzIs Squid better than the latterFeb 01 16:21
schestowitzWhich one to look at firstFeb 01 16:21
schestowitzCombining too is moot/impossibleFeb 01 16:21
schestowitzI also have 8GB of pages on my HDDFeb 01 16:21
schestowitzPages that I cite I keep copy ofFeb 01 16:21
schestowitz(Proven useful before because Web Archive is slow to grab 'pulled' articles)Feb 01 16:22


Recent Techrights' Posts

More Information About Public Talks That Richard Stallman Gave This Week in Europe
Two talks in Switzerland
SoylentNews Grows Up, Registers as a Business, Site Traffic Reportedly Grows
More people realise that social control media may in fact be a passing fad
 
Links 29/03/2024: Fentanylware (TikTok) Fines and UK High Court Makes It Seem OK to Assassinate People Wrongly (Falsely) Associated With "Russia"
Links for the day
Garden Season Starts Today
Outdoor time, officially...
Engadget is Still a Spamfarm, It's Just an Amazon Catalogue (SPAM/SEO), a Sea of Junk Disguised as "Articles" With Few 'Fillers' (Real Articles) in Between
Engadget writes for bots now, not for humans
Richard Stallman's Talks in Switzerland This Week
We need to put an end to 'cancer culture'; it's trying to kill people and it is even swatting people
Over at Tux Machines...
GNU/Linux news for the past day
IRC Proceedings: Thursday, March 28, 2024
IRC logs for Thursday, March 28, 2024
[Meme] EPO's New Ways of Working (NWoW), a.k.a. You Don't Even Get a Desk at Work and Cannot be Near Known Colleagues
Seems more like union-busting (divide and rule)
Hiding Microsoft's Culpability in Security Breaches and Other Major Blunders (in the United Kingdom, This May Mean You Can't Get Food)
Total Cost of Ownership (TCO) is vast
Giving back to the community
Reprinted with permission from Daniel Pocock
Links 28/03/2024: Sega, Nintendo, and Bell Layoffs
Links for the day
Open letter to the ACM regarding Codes of Conduct impersonating the Code of Ethics
Reprinted with permission from Daniel Pocock
With 9 Mentions of Azure In Its Latest Blog Post, Canonical is Again Promoting Microsoft and Intel Vendor Lock-in, Surveillance, Back Doors, Considerable Power Waste, and Defects That Cannot be Fixed
Microsoft did not even have to buy Canonical (for Canonical to act like it happened)
Links 28/03/2024: GAFAM Replacing Full-Time Workers With Interns Now
Links for the day
Consent & Debian's illegitimate constitution
Reprinted with permission from Daniel Pocock
The Time Our Server Host Died in a Car Accident
If Debian has internal problems, then they need to be illuminated and then tackled, at the very least in order to ensure we do not end up with "Deadian"
China's New 'IT' Rules Are a Massive Headache for Microsoft
On the issue of China we're neutral except when it comes to human rights issues
Over at Tux Machines...
GNU/Linux news for the past day
IRC Proceedings: Wednesday, March 27, 2024
IRC logs for Wednesday, March 27, 2024
WeMakeFedora.org: harassment decision, victory for volunteers and Fedora Foundations
Reprinted with permission from Daniel Pocock
Links 27/03/2024: Terrorism Grows in Africa, Unemployment in Finland Rose Sharply in a Year, Chinese Aggression Escalates
Links for the day
Links 27/03/2024: Ericsson and Tencent Layoffs
Links for the day
Amid Online Reports of XBox Sales Collapsing, Mass Layoffs in More Teams, and Windows Making Things Worse (Admission of Losses, Rumours About XBox Canceled as a Hardware Unit)...
Windows has loads of issues, also as a gaming platform
Links 27/03/2024: BBC Resorts to CG Cruft, Akamai Blocking Blunders in Piracy Shield
Links for the day
Android Approaches 90% of the Operating Systems Market in Chad (Windows Down From 99.5% 15 Years Ago to Just 2.5% Right Now)
Windows is down to about 2% on the Web-connected client side as measured by statCounter
Sainsbury's: Let Them Eat Yoghurts (and Microsoft Downtimes When They Need Proper Food)
a social control media 'scandal' this week
IRC Proceedings: Tuesday, March 26, 2024
IRC logs for Tuesday, March 26, 2024
Over at Tux Machines...
GNU/Linux news for the past day
Windows/Client at Microsoft Falling Sharply (Well Over 10% Decline Every Quarter), So For His Next Trick the Ponzi in Chief Merges Units, Spices Everything Up With "AI"
Hiding the steep decline of Windows/Client at Microsoft?
Free technology in housing and construction
Reprinted with permission from Daniel Pocock
We Need Open Standards With Free Software Implementations, Not "Interoperability" Alone
Sadly we're confronting misguided managers and a bunch of clowns trying to herd us all - sometimes without consent - into "clown computing"
Microsoft's Collapse in the Web Server Space Continued This Month
Microsoft is the "2%", just like Windows in some countries