technology

technology

Switching desktops

I switched my desktop back to gnome (think Ubuntu not Kubutnu), mostly because of AWN which is a cool menu with nice applets that extend the functionality (I have a system monitor, a weather applet, desktop switcher, file stacker, etc) (many examples can be seen on YouTube. AWN is still in heavy development so a few of the applets don't work and there are some minor bugs, but very cool.

Copy DVD in Kubuntu (Ubuntu)

I have been struggling with copying a DVD in Linux. I like to copy the ones I purchase in case they get damaged.

In any case, copying a dvd in kubuntu (or ubuntu) requires the installation of libdvdcss2, which isn't easily found.

I finally found the answer here:

https://help.ubuntu.com/community/DVD::Rip

Using the following lines, the library is installed and K3b (and other applications) can read an encrypted DVD.

sudo apt-get install libdvdread3 debhelper fakeroot

AWStats On IIS 6.0

After setting up AWStats On IIS, I wanted to use awstats.pl instead of the static pages. I configured it according to what I found on the internet, but there was a problem. I would go to the awstats.pl and I would get the html on the page rather than the rendered html. I found the problem, but it requires editing awstats.pl.

On line 550, there is a function called http_head. In line 553, the following line:

else { print "Content-type: text/html; charset=$PageCode\n"; }

should be changed to:

else { print "HTTP/1.0 200 OK Content-type: text/html"}

Vista, IE 7 And Secure Certificates

I ran into a strange problem at work today. We have a web server on which is installed a self-generated SSL certificate. This page has worked fine as far as I know for several years. The certificate, however, was not generated for the URL and is therefore not valid. This is something we were going to get around to fix, but it looks like we'll have to do it sooner than later.

Normally, in Windows XP with Internet Explorer 7 and 6, Firefox on Windows and Linux and many other browsers and platforms I assume, a prompt is shown to the user asking if they want to connect to the website anyway.

Linux Tips: Rip A CD

Why is Linux so cool and fun? Because many of the things people do with their computers are very easy to do in Linux. Like ripping a CD.

Using Kubuntu 7.04, go to the KDE menu and click system settings. Click on the advanced tab. Click on audio encoding and finally the MP3 Encoder. This is where the MP3 settings are located at (quality, bit rate).

Now, put a CD into your CD-ROM drive. You should see an icon that looks like this on your desktop.

MS SQL: Insert Multiple Rows With One Query

Just figured this out. Using Microsoft SQl Server 2000, you can insert multiple rows into a table with one query as in the following examples:

Single Column:

CREATE TABLE test
(
val1 INTEGER NOT NULL
)

INSERT INTO test
SELECT 62
UNION
SELECT 91
UNION
SELECT 95
UNION
SELECT 98
UNION
SELECT 99

This will insert 5 rows into the table. To do multiple columns, use the following:

CREATE TABLE test
(
val1 VARCHAR(10),
val2 VARCHAR(10),
val3 VARCHAR(10),
val4 VARCHAR(10)
)
GO

INSERT INTO test
(val1, val2, val3, val4)

Linux Tips: FTP with gFTP

gFTP is an open source graphical FTP client. It has a nice user interface and is easy to use. I've had problems with it doing large ftp transfers, so in those cases or cases where I want to transfer server to server, I use kasablanca. The GUI is a bit clunkier and is lacking some features, but it is best for certain situations.

Linux Tips: Image Editing With The Gimp

The Gimp, or GNU Image Manipulation Program, is an excellent, free image editing software package for Linux, and Windows. As far as I can tell, it does everything the big name programs do, except allow the creation of shapes. Coming from Fireworks, it was tough to get used to. But you can create vectors and areas, and then fill them. While I am not a professional, I did create this graphic using The Gimp.

Linux Tips: Installing And Updating

One of the reasons the average person complains about Linux is the perceived or rumored difficulty in installing software, or performing updates. It is true that it is somewhat difficult if you have to compile your application or driver, as I do with vmware (the only way to run Windows) and my video card driver, but installing and updating a Kubuntu system is not difficult and automatic most of the time.

Linux Tips: Move, Shade Window

In Kubuntu or KDE (I think...at least with Beryl), a window can get positioned so that you can't grab the title bar (the bar up top that has the menus on the left and right). To move it, hold down ALT and click anywhere on the window and drag.

Shading a window will collapse it into the title bar. To do this, double click on the title bar on top. You will be able to fit a ton of windows on a desktop and not have to go to the task bar, or use the ALT + TAB combination to cycle them. Simply double click them to "unshade??" them.