Archive for the 'Open Source' Category

MySQL Cheatsheet By Example

Published
by
Tyler
on December 24, 2007
in Internet, Linux, Open Source and Personal
. 2 Comments Tags: , , , , , , .

Tech-Evangelist has put together an excellent cheatsheet for MySQL. There’s lots of other MySQL cheatsheets out there, but this one is unique in the fact that it gives examples of usage rather than just snippets of code.

This cheatsheet also includes a summary of commonly used MySQL data types, which will be really helpful to me. I can’t tell you how many times in a week I hit the MySQL website looking for specs on a certain data type.

If you think this cheatsheet would be useful to you, head on over to Tech-Evangelist to download the PDF.

Popularity: 11% [?]

Unwakeable: The Future And WordPress 2.3

Published
by
Tyler
on October 9, 2007
in Internet, Noteworthy, Open Source, PHP, Personal, Unwakeable and WordPress
. 6 Comments Tags: , , , , , , , , .

I’ve waited far too long to post an update on Unwakeable 2.0 and it’s status, so here it is, almost. First, I’d like to address the issues with the current Unwakeable release (version 1.2.1) and WordPress 2.3. There’s a few issues, although most of them are fairly minor.

1. Tags: Unwakeable 1.2.1 does not support the new tagging system in WordPress 2.3. If you’re using the new tagging system, your tags will not be displayed. Ultimate Tag Warrior still works just fine with Unwakeable 1.2.1 and WordPress 2.3.

2. Prototype: Livesearch (and probably rolling archives) don’t work with WordPress 2.3. I really have no idea why, it’s probably a combination of a few things. One major contributor is probably the fact that WordPress 2.3 likes jQuery instead of Prototype, and Unwakeable relies heavily on Prototype for it’s ajax effects, such as livesearch, rolling archives, and live commenting. I only use livesearch, so I can’t say for certain if rolling archives and live commenting were truly broken. All I know is Firefox CPU usage skyrockets when loading this site when livesearch is enabled.

3. Archives Page: The archives page is slightly broken, it displays an error similar to this at the top:

WordPress database error: [Table 'tlongren_wordpress.wp_categories' doesn't exist]

That happens because Unwakeable 1.2.1 doesn’t know about the new taxonomy schema in WordPress 2.3. WordPress 2.3 does away with three tables, categories, post2cat, and link2cat. Those tables are replaced by three new tables that, when combined, offer much greater flexibility in handling post categories and blogroll categories. I think this new schema handles tags as well.

4.Tag Archives: This may be unique to this site, I haven’t tested, but whenever you try to visit a tag archive (my unwakeable tag archive for example), a 404 is received. Obviously, it should display all the posts with the given tag. Can anyone using Unwakeable 1.2.x confirm this is also broken on their WordPress 2.3 site?

5. Unknowns: There’s probably lots of broken things I’m not aware of. K2 Sidebar Modules may very well be one of them. I really doubt they work 100% because they make some use of categories. If you’ve got anything I’ve missed, please let me know about it so I can make sure it’s working in Unwakeable 2.0. One thing that DOES work that I entirely expected to be broken are the category archives. I was ready for all sorts of errors when trying to view a category archive, like the Unwakeable category archive, but they display exactly as they did with WordPress 2.2.x. Please let me know if you’re aware of any other incompatibilities between Unwakeable 1.2.x and WordPress 2.3.
Continue reading ‘Unwakeable: The Future And WordPress 2.3′

Popularity: 19% [?]

How To: Cisco VPN Client On Ubuntu

Published
by
Tyler
on May 17, 2007
in Internet, Linux, Noteworthy and Open Source
. 183 Comments Tags: , , , , , , , .

IMPORTANT UPDATE, SEE BELOW

So, I installed Ubuntu 7.04 Feisty Fawn beta about 2 months ago. I installed it on my notebook and one of my workstations, both of which had Windows installed previously. I’m not dual booting on those machine, they’re 100% Ubuntu now.

After getting everything setup and running nicely, I realized I had no way of connecting to the Cisco PIX VPN we have at work. This is really important for me to be able to do, my job depends on it. I immediately went to Google and started searching. Turns out a nice fellow named Alexander Griesser has created a patch for the Cisco VPN client. The most recent CIsco VPN client for linux won’t compile with kernels 2.6.19 or newer. There’s really not much of a difference between his instructions and this how-to. However, I’m including more detailed instructions for those who may not be familiar with compiling software on Linux.

Here’s the steps I took to get the Cisco VPN Client to work under Unbutu 7.04 (Feisty Fawn). In all reality, this should work with any version of Ubuntu, not just 7.04. I used this same method to get the Cisco VPN Client working on Ubuntu 8.04. Note: A $ at the beginning of a line signifies a command to be run from the terminal.

  1. Download vpnclient-linux-4.8.00.0490-k9.tar.gz (mirror) to your home directory.
  2. Open a terminal window and untar the vpnclient with the following command:
    $ tar xzf vpnclient-linux-4.8.00.0490-k9.tar.gz
    This will create a new folder called vpnclient in your home directory. Leave the terminal window open, you’ll need it later.
  3. Download the patch (mirror) and save it to the vpnclient folder that was created in step 2.
  4. Go back to your terminal window and move into the vpnclient folder:
    $ cd vpnclient/
  5. Now patch the Cisco VPN source with this command:
    $ patch < vpnclient-linux-2.6.22.diff
  6. Next we actually build the Cisco VPN client, issue this command:
    $ sudo ./vpn_install
    Just hit enter for everything it asks you, the defaults are all OK. You may see lots of warnings, but those are OK.
  7. The VPN client is installed, now we need to start it:
    $ sudo /etc/init.d/vpnclient_init start
  8. Place your .pcf configuration files in /etc/opt/cisco-vpnclient/Profiles/
  9. If your .pcf file is called myVPN.pcf, you’ll connect to the VPN with the following command:
    $ sudo vpnclient connect myVPN


That’s it! You should now be able to connect to your Cisco VPN with the official Cisco VPN client on Linux. This will probably work on pretty much any linux setup, not just Ubuntu.

UPDATE (8/18/2007): Alexander Griesser released a new patch that works with kernel versions 2.6.22 and greater. The new patch is backwards compatible, so it also works with older kernels as well, such as 2.6.10 and 2.6.21. All the download links above point to the newest release of the patch. I’ll continue to update this how-to as he releases new patches.

UPDATE (10/04/2007): Cisco has finally released a new version of their vpn client for Linux. This new version compiles on all the new 2.6.xx kernels without the need for patching! You can download it from Alexander’s site or you can get it right here.

UPDATE (12/29/2007): Alexander Griesser has a new project page for his Cisco VPN client patches. It contains basic usage information and will most likely always have the latest and greatest patch available for download. In addition to that, Alexander has a new patch to make version 4.8.01.0640-k9 of the Cisco VPN Client compile on 64bit systems. Again, you can download the latest Cisco VPN Client for linux from the following link:
http://www.longren.org/downloads/vpnclient-linux-x86_64-4.8.01.0640-k9.tar.gz

Ubuntu is a far cry from the Microsoft Windows OS that you’re used to. No need to pass the 70-270 or 70-649 exam to understand what’s going on. The Cisco 646-204 and 642-901 exams on the other would get more use with the open source format of this Linux release. Ubuntu is a 220-601 PC builder’s dream come true.

Popularity: 100% [?]

Slackware 11.0 Release Candidate 5

Published
by
Tyler
on September 18, 2006
in Internet, Linux, Open Source and Personal
. 0 Comments Tags: , , , , .

Slackware 11.0 Release Candidate 5 is here. Lots of updates to existing packages. Not many packages were upgraded. Patrick is giving the scouts honor that this will be the last RC before 11.0 final.

Head on over to the Slackware Blog to have a look at the full changelog entry. Hopefully we will see Slackware 11.0 released sometime next week or maybe even by the end of the week since we’ve seen such a long RC cycle. I don’t think we’ve seen anything greater than RC2 since Slackware 9.0 or so. It’s been a while since we’ve seen this many release candidates.

Popularity: 6% [?]

Performancing For Firefox 1.3

Published
by
Tyler
on August 9, 2006
in Internet, Open Source and Personal
. 0 Comments Tags: , , , , , , , , , .

Performancing For Firefox 1.3 has been released. Lots and lots of changes are included in this release. There’s now support for themes and addons. The performancing team has also open sourced Performancing For Firefox, which means anyone can get the source code and modify it as they please.

Some of the new features are listed below:

I’m writing this post with this new version of Performancing. So far nothing unusual. The addons and themes API additions are sweet, hopefully some worthy developers will hack together some neat addons. I’m excited about this new version, it’s opened a lot more doors for Performancing.

Popularity: 4% [?]

Ubuntu Billboard

Published
by
Tyler
on August 3, 2006
in Linux, Open Source and Personal
. 0 Comments Tags: , , , , , , , , , .

Look at the beautiful Ubuntu Billboard WildBill got a photo of as he was driving by.
Ubuntu Billboard
Pretty neat huh? I’m not a huge Ubuntu fan, but I do appreciate it. If I wasn’t such an avid Slackware user, Ubuntu would be my distro of choice. In fact, I just used the Ubuntu LiveCd yesterday at work to get some needed files off a dying hard drive. Pretty neat, I expect Microsoft billboards, but not Ubuntu. Wonder what it’d take to get a Slackware billboard put up somewhere?

Oh, and as you’d expect, the Ubuntu Blog author is pretty excited about the billboard too.

Popularity: 5% [?]

cheap xbox 360 games - buy from zavvi
cheap xbox 360 games - zavvi

mobile phones - Web Design - Savings - Car Insurance - Mortgage - Secured Loans
Mobile Phone - Bike Insurance - Landlords Insurance - Search Engine Marketing - Mobile Phone