Wondering what’s been happening with the offline problems and loss of some posts? Here’s DU’s sys admin, Marc Perkel, to explain it all.

And for those who keep popping off in the comments to posts about Windows or Mac, tell us again why Linux is the future and we’re all idiots for not seeing the light?

Here’s what’s happening.

In order to spread the load and increase capacity I was trying to move the MySQL server to another computer with the main server handling the web and the second server running the MySQL database. Even though I have 8 gigs of ram in the main server every now and then for some reason I can’t explain memory usage soars the the server quits working due to high load.

Most all applications talk to MySQL through “localhost” that resolves to IP address port 3306. Normally moving this service is trivial. I just shut down the database on the main server, move the database to another server, start it up there. Then I set up an SSH tunnel that pipes requests from the main server to the new server by intercepting requests and transporting them over TCP. Generally this just works.


The morons at MySQL decided to redefine the meaning of “localhost” and when an application uses “localhost” the client libraries force it to be redirected to talk to the Unix socket /var/lib/mysql/mysql.sock instead of the TCP port. Why they did this is crazy beyond belief but there’s no way to override it short of downloading the source code and fixing it and recompiling MySQL which is the standard answer that you get whenever you complain too much about Open Source.

I however don’t give up so easily. I found a Linux utility called “socat” (socket concatenate ?) that allowed me to create a fake Unix socket and pipe it to a TCP port. And it worked – for a while. But it wasn’t reliable. As long as I was awake and in front of the computer it worked fine. But as soon as I went to sleep it shut down. So I wake up to a mailbox full of “my web site is down”.

So – I put it back on the main server till I find a real solution.

But – this is yet another example of why open source will never fully replace paid for software. If you have a commercial product people can call up the vendor and scream at them to fix bugs. When I sold commercial software and someone called me needing something fixed or added I usually had it the same day. However in the open source world you have a lot of people who have a highly inflated sense of importance who think their software is the greatest thing that was ever written and it’s crap!

What it comes down to as far as I can tell is the VI editor that comes with Unix causes brain damage. I’m totally serious about this. The VI editor absolutely sucks. It’s years behind editors I got with DOS 20 years ago and is an example of how to make an interface that totally sucks. I have refused to learn this editor because I find it offensive. I do most all my editing with a Windows editor, Textpad, and I run Samba on the Linux boxes so that I can mount them from Windows. That’s because there are no good editors in the Linux world. Other than that I use Pico which is a great little Unix editor for quick and dirty but still isn’t up to the kind of power I had in DOS or even CP/M (Wordstar) which is a better editor than any text mode editor in the Unix world.

I’m still waiting for Linux to catch up to CP/M!!!

My theory is that when people use VI it lowers their standards as to what good software should look like and causes their minds to physically alter in a way that leads to VI syndrome leading to delusions that their little piece of shit software is the greatest program in the world and that they are just so superior to microsoft that it’s just a matter of days before Microsoft collapses and everyone accepts Linux as God.

But what the open source world doesn’t get is that Windows programs actually WORK! If you want to install a windows application you download it, click NEXT, AGREE, NEXT, NEXT, NEXT, FINISH and the program is running. In the Linux world this almost never happens and when it does you’re almost sure that something has to be wrong. In Linux you have to edit cryptic config files with poor documentation. Then you try to run the application, get an error, Google the error, and go back and edit again. After many hours you might have it working or you might have to give up.

Out here in the real world localhost = everywhere EXCEPT in MySQL. Not only did they hard code the bizarre behavior but have no way to override it. In fact they do the opposite. Whatever you set the configuration to they override it and force you to use the Unix socket. So doing something that should be simple becomes a nightmare. And you can’t talk to them because they have VI syndrome.

  1. ChrisC says:

    I found Marc’s disgruntled analysis of his problem in the light of Open Source’s failings crystallised some of my own feelings. I was taken in by Open Source’s claims about ten years ago. It’s been a long journey realising many of the movements claims are not well based in fact.

    I find the responses to the original article quite typical: a OS product has departed from standard in a specific way. Rather than agreeing that the product must conform to accepted standards and that a fix is required, we get a great deal of emotion. I suspect this convinces no-one, outside the movement.

    The problem of standards gets to the heart of OS S’s great weakness: unity. There is an ancient idea: divide and conquer. This is particularity applicable to operating systems: Linux has dozens upon dozens of variants. If you are releasing software to users you cannot possibly perform QA on all of them, unlike other major platforms.

    On “flexibility”: flexibility is not actually what users want: users want tools that work well ,work the same way everywhere, and work first time (and every time) without needing to know anything outside the problem domain the tool addresses.

  2. With cheaper cost, better performance, and better reliability, Open Source is threatening Corporate America –more specifically, Microsoft.

    Corporate America is what stands between us and the never-ending threat of PRC, Islam, and Commie Liberals. If Microsoft dies, then so will America and the American family values. Open Source is UN-AMERICAN and threatening the very values that our Founding Fathers had strived for. Open Source is COMMIE. A true, patriotic American uses Microsoft.

  3. ouroborous says:

    I find the open source apologists interesting.

    They will blame everyone and everything except a piece of open source software for problems.

    As an example, I recently made a run at using Linux as my primary home desktop. The reason I did this was because (a) my hard disk had crashed and I did not feel like recovering Windows XP at the moment, and (b) I am fearful of the cluster-f*ck that is Vista. XP has served me faithfully for years now; why must Microsoft keep trying to FORCE me to buy Vista? Oh right, money…

    But, I digress.

    Installing Linux (Ubuntu, the “easiest” of the distros, no less) was easy. Making it WORK was an absolute nightmare. For instance, for some reason my system would invariably hang during boot if the splash screen wasn’t disabled. Why this is, I don’t care. But it would. So how is this a good user experience? I googled the issue and it was far from an uncommon problem, apparently.

    Next, making my graphics card support dual monitors and screen-spanning was an absolute, absolute, absolute NIGHTMARE. Something that Windows XP had handled effortlessly, almost in its sleep, required — in Ubuntu — endless reboots, endless twiddling with poorly-documented switches in xorg.conf, endless unexplained X shutdowns.

    Now, 90% of my hardware wouldn’t work. My TASCAM-US144L that I used for music production? Unsupported, never will be supported. My Logitech Razor mouse? Works, but none of the “extra” buttons work. My G15 keyboard? Only works as a 101-key keyboard (and don’t fool yourself, the open-source G15 libs are hobbyist quality AT BEST).

    Some of my Windows apps worked (yay! I could play WoW… and in Linux’s defense, it actually ran faster under Wine with OpenGL than it did natively on Windows; I blame DirectX) — but most didn’t.

    My VPN software (Juniper’s Netconnect) required an incredible amount of work and googling, not to mention the patience of a Buddhist monk, to get even limping along. And it’s written in Java, so you can’t blame OS-dependant code.

    The clock — the damned, system clock, that part of the PC that has “just worked” for me on computers since, oh, the stone ages — drifted, on the order of 20 minutes per hour. One time I ended up keeping my girlfriend up till 11pm playing WoW because the bloody clock said it was 9pm. I finally fixed this by disabling the TSC read (IIRC) in the kernel boot parms, but how many “mom and pop” people are going to be willing to touch the kernel params, let alone know which one to use?

    I mean, every aspect of the bloody OS was broken — from the UI to the clock to the drivers to the utter lack of compelling applications. I was never — NEVER — able to play a DVD from Netflix on that computer. But Windows “just worked”… hmmm…

    And that’s why I eventually switched back. Linux and open source may be great for some closed-box, server closet type applications (but even there, if I were a CIO, I would question whether saving a few hundred dollars on the OS was really worth having *NOBODY* to call when it broke). But for the average user, it’s just an absolute nightmare.

    And the attitude of the open source crowd — you know, the fanboys who think that typing “M$” is somehow clever — this just makes things worse. I’ve been writing kernel drivers for Windows for ages. I’ve hacked more programs than many of these fanboys have RUN. I’ve been doing assembly-level debugging (and coding) since 1983. I really, honestly, know what I’m doing (I just don’t want to have to reprogram my goddamn OS just to play a game…), so smug insinuations that I must be too stupid to understand Linux and open source really aren’t helping your cause much. There are some very, very clever, and very, very helpful people in the open source community… but sadly, they seem to be the exception rather than the rule.

    After this latest, six month experiment with Linux and open source, I’ve happily reverted to Windows XP. So far, everything just works — except Firefox, that is.


  4. RealPerson says:

    LOL @ open source nerds. I get paid 85 dollars an hour to implement M$ software that actually works for huge companies (the dollar sign in MS is getting really annoying btw, i’m already quite aware that i’m making a shitload money more than YOU are, so fuck off and go back to you dungeons and dragons)

  5. RealPerson says:

    LOL @ open source nerds. I get paid 85 dollars an hour to implement M$ software that actually works for huge companies (the dollar sign in MS is getting really annoying btw, i’m already quite aware that i’m making a shitload money more than YOU are, so fuck off and go back to your dungeons and dragons)

  6. ECA says:


    If someone would make a SOLID gaming OS..
    no matter if its LINUX or MS or APPLE..

  7. YES says:

    YEP, you got this right. I could add other reasons as to why OSS generally tends to suck, especially after it gets older, although NOT all of it fits this category. Some of it is great – but much is a disgrace and I wonder what the people working on it are smoking. Is pot usage on the rise among OSS developers or something?

    FireFox sucks–use OPERA. It’s free, it’s not IE, and it supports a crapload fancy features out of the box without installing a million stupid plugins. FireFox not to mention other browsers) has been stealing features from the INNOVATION PIONEER browser for years – yay Opera. Opera is an example of (former) COMMERCIAL software that HAD to work well or it would have died. Looking at FireFox’s current state, projected evolution, and the final state of Opera, the debate is about settled.

    Try using a fancy 3d editor like Rhino (commercial) – pretty easy right? Now try Blender (OSS). I rest my case. You’ll kill yourself within 5 minutes trying to learn that piece of UI design violation trash.

  8. YES says:

    Yeah, it’s about time someone has the you know what to say what everyone is thinking. Open source is NOT always the best choice.

  9. oroboro says:

    You’re absolutely right. Open-source is always garbage.

    Sure, Windows apparently has loads of security holes and is incredibly unstable. Somehow though, in the last 5 years of using XP on my personal desktop, I NEVER once had a BSoD and was never attacked.

    Just take a look at the bug reports and feature requests. OpenOffice has had a request for dashed borders since 2001, but the f*cking stuck up developers have refused to do a thing. I’ve used open-source libraries and every single one so far has had some bug or limitation that has required me to go into the source code and fix or add.

    Open-source bugs get fixed fast my ass. It’s right there in front of your faces – major bugs that haven’t been fixed for nearly a DECADE. Firefox STILL has the text search bug and crashes even faster than before.

    Ever wonder why not everyone uses shitty open-source software? Because it sucks and is unstable and open-source is ALWAYS filled with bugs. The only Linux programs I haven’t experienced bugs with after BASIC usage are the ones that have been out for decades and command-line tools.

    If you run the program yourself and experience bugs with it within the first 5-10 hours of using it, why the f*ck would you release it unless under beta? Maybe, it’s because you’re a stuck up f*ck who thinks he’s the best.

  10. Ronaldo says:

    The difference if MySQL was closed software is that you will never learn that they are using unix sockets for local addresses and would never have the freedom to change it.

  11. Bill says:

    As a developer who has worked with both linux/java and NT/C# as a sysadmin and web developer, I gotta say that the price paid for microsoft software more than makes up for the time saved not having to read documentation, hunt down prerequisites, etc. when setting up a server. Also, development in C# and ASP.NET is far more rapid and painless than any open source solution I’ve seen. And to those who bitch about having to pay MS for support, I’ve only had to call their support once, but once they realized it was a problem with their software they refunded me the $50 support cost. Again, even paying the $50 for immediate support is worth it since its less than I get paid per hour. All I ever hear about from linux people is that their software is free, but time is money and the time and productivity I’ve lost trying many OSS solutions isnt worth the savings in software costs. Just my opinion.

  12. Oh man you are so right about this. Linux sometimes sucks so hardly.. It is better to transfer all the business to Windows and live with the smile on your face. I had never had any problems with microsoft products in my life. Btw thanks for keeping your website up!

  13. john says:

    God I’m glad you geeks have no sway or voice in this world squabbling about the absolute pointless to bolster egos attached to Linux and Open Source lol. It’s pathetic.

  14. Bruce Mooly says:

    I just waned to say that the open source world is a mess. A total mess. As a developer if you try to become a Java expert you will find out that for the same functionality there N number of libraries.

    Imagine that you are trying to market yourself as a Java developer and you know about Depdency Injection, Aspect oriented programming, web service developmetn, database persistence and messaging. For each of the technologies above there many different implementations and libraries but each available position in the market requires a certain combination of these technologies. What are the chances that you become a highly potential candidates who is offered good money? not much. The reason is nowadays it is the employers market and they are looking for the perfect guy for the position. On the other hand if you are a .NET developer then you know that for distributed programming you need to know WCF that is the standard for .NET development, for UI you need to know WPF and that is a standard too. Also whatever you required to know when you do development for Windows are standards in the market and there are not 10000000000000 different products that do the same thing like in the open source community and the world of Java development. If you send your CV to an employeer who needs a Windows developer then you know what they would be expecting from you and it makes you a marketable developer.

    The whole Linux, Sun, IBM and Oracle alliance SUCKS and it does it big time. Above was just one of reasons and I am sure there are many more reasons that proov this fact.

  15. From your side you are absolutely right regarding Linux is the future but you think other site, many peoples necessary is Windows or Mac. By the way thank you! I found this very useful for me. Contributions like this help to develop a good understanding about the subject and gain a detailed insight of it. Further Novices like me get to bud themselves to advance and stay upfront in the cold & competitive industry.

  16. Marty says:

    I disagree! Openness doesn’t mean insecurity or anything like that. It means opportunity for further developments.


Bad Behavior has blocked 13682 access attempts in the last 7 days.