Is it Knoppix or PCLinuxOS time?

September 19, 2006

Not yet tired of windows? Well, read on to find out the next gen O/S out there…

* New capabilities – creating a remastered custom Live CD/DVD and booting from a USB flash

Let’s see where do I start…

Well, my machine crashed – it’s a new Acer – http://global.acer.com/4152 NLCI (4150 or 4650 series) laptop- and the problem was maybe some virus, because the ntoskrnl.exe was corrupted, and the drivers just stopped loading after a few seconds of boot time, bringing the hard disc to a halt and the screen to a frozen white screen (talk about the old blue screen being upgraded by MS!!!)

Time to look around for a boot-able and repair kit right! I tried – got an XP cd and installed XP onto a different partition – but the next day – that too went into the same loop like the above.

Then, I found out that maybe the hard disc may have got some permanent damage – thanks to all the travel lately.

I look around for a solution other than DOS obviously and I find the best free O/S ever!

Knoppix — the free open source Linux O/S that boots and runs from a CD/DVD (like PCLinuxOS 2007), with automatic hardware detection, recognizing all the devices – Graphics Card, Sound Card, USB, CD, DVD, RAID, Modem, Lan Card, printer-scanner(hp all-in-one), pcmcia cards, sd card(gateway works with PCLinuxOS), bluetooth(works with PCLinuxOS), wireless(works with PCLinuxOS),modem, external camera, webcam – you name it and its a solid system that detects, installs and boots fast (PCLinuxOS 2007 boots in 30 seconds), and runs quickly on ordinary hardware! It can even mount my NTFS hard disc in read mode (ntfs-3g driver supports read and write of NTFS files) to copy files to my USB so my critical files are saved in no time. Of course, part of the recovery process is being able to write CD and DVD’s which Knoppix (and PCLinuxOS) supports with a right click menu.

Knoppix – a flavor of Debian Linux – http://www.knopper.net/knoppix/index-en.html or http://www.knoppix.net/ – is a 640MB bootable Live CD with a collection of GNU/Linux s/w, which brings up a Windows like user interface, connects to the internet (after a minor config) through a DSL or Cable modem and voila – I’m online via Mozilla, Opera or Konqueror. Knoppix 5.1.1+ is a debian flavour of the Linux O/s with the Linux kernel 2.6.19+ , KDE 3.5.5+/GNOME 2.16+, ntfs-3g and it has all the flavours of a true windows system with OpenOffice2.1+ – (Word-documents,Excel-spreadsheets,PPT-presentations) , PDF reader, kaffeine (media player) and GIMP (for those mspaint users), picasa from google, a host of ntfs data recovery tools and good card games!

PCLinuxOS 2007 TR4is a free open source Linux O/S (flavor of Mandrake/Mandriva Linux with Linux kernel 2.6.22.10+, KDE 3.5.7+/GNOME 2.16+, Open Office 2.3+, 3D windows support), has all the above software modules, and it is much better than the Knoppix version as of PCLinuxOS 2007 TR4 versus Knoppix 5.1.1 – since PCLOS can be remastered and installed on a usb flash drive very easily.

Live CD Knoppix (like Live CD PCLinuxOS) uses on-the-fly decompression to load into memory, the required modules, from bootable CD/DVD, so the CD is locked by knoppix and you can’t use it for writing or DVD viewing although they have the CD/DVD writer software and the movie viewer software and I can use an external DVD/CD writer/reader to perform CD/DVD burns/reads. You can install the PCLinuxOS 2007 TR4 Live CD to a USB flash drive The other pluses to these Live CDs are: There is already an available messenger – thanks to secure GAIM (now Pidgin) – which can connect to Yahoo, Google Chat, AOL, etc. among others. Kopete is better than other messengers due to WebCam support, but need Knoppix/PCLinux installed to the hard disc. You can also create custom bootable CD/DVDs/USB flash, since the default live CDs are built for a read-only O/s (from the CD) with default options.

Want to listen to quality music? – using StreamTuner on Linux you can listen to live internet streamed (128 to 256kbps) quality radio on xmms, from around the World for free!!!

Security – you can install the necessary Mozilla addon’s and the shorewall or firestarter firewall to boost your experience.
VLC, Gxine, Amarok and Mplayer are very good multimedia programs covering all the needed experience.

Acrobat 8 is available for Linux for the pdf community.

Open Office or Star Office are not perfect but are decent Linux office solutions.

If you are wondering about install time – there is none – since the OS just boots of a CD/USB, you can use all the features of a full fledged O/S, and if you need, you may install the O/S to hard disc in 10 minutes.

So what are the minimum requirements of this new O/s (Vista beware!)

· Intel-compatible CPU (i486 or later),
· 32 MB of RAM for text mode, at least 96 MB for graphics mode with KDE (at least 128 MB of RAM is recommended to use the various office products),
· boot-able CD-ROM drive, or a boot floppy and standard CD-ROM (IDE/ATAPI or SCSI),
· standard SVGA-compatible graphics card,
· serial or PS/2 standard mouse or IMPS/2-compatible USB-mouse.

Before you comment, please note:

  • I know I could have called Acer – http://global.acer.com/ support – since my laptop is within warranty – well, I didn’t call because I needed internet connectivity – not further delays and postal issues with mailing my hard disc out.
  • Knoppix and PCLinuxOS have very good multi-session KDE3.5+/GNOME 2.16+ windows environment which I wanted compared to a lite-r environment like DSL Linux (http://www.damnsmalllinux.org/ – that’s another topic – 50MB linux – usb/mini-cd boot) – another reason not to go for a usb boot was the laptop bios was not upgraded by the manufacturer and the way to upgrade bios is only through a working Windows XP !! Latest: I finally got a usb floppy drive and got my BIOS upgraded, also I created a custom Live CD of PCLinuxOS 2007 TR4 and copied it to a USB flash which is now bootable (don’t forget to install th MBR) and working for Acer 4152 and Gateway MX 6124 laptops.
  • I downloaded Knoppix 3.6 from a friends cable connection and burnt the CD in 10 minutes and was online on my Acer 4152 NLCI laptop in 15 minutes: Latest: I downloaded Knoppix 5.1.1 Live DVD and PCLinuxOS 2007 TR4 Live DVD – PCLinuxOS rates better with custom Live DVD/USB flash boot support.
  • All of the needed drivers and software including Gaim, Office(Word,Excel,PPT), PDF viewer, printer-scanner drivers, rss reader, were on the CD so nothing to install – unlike ms windows, where a plain o/s is useless!!!

Knoppix 3.6 Problems and PCLinuxOS 2007 TR4 Advantages:

  • The laptop CD/DVD drive is being fully used/locked and I cannot eject it – when I log into the Knoppix Live O/s. This is by design, since the modules are dynamically loaded from the CD. You can burn custom CD’s by downloading the necessary softwares by apt-get
  • I downloaded PCLinuxOS 0.93 and later upgraded to PCLinuxOS 2007 TR4 and they install to hard disc easily with a single click, also they have a neat way to create a custom Live CD/DVD, which can be created in 20 minutes flat using mklivecd/k3b
  • Webcam with messenger is an issue with gaim – PCLinuxOS 2007 fixed this problem with a new version of Kopete and many more web camera tools.
  • WPA Wireless security is not supported with default ndiswrapper, you may still have to use the windows wireless card drivers – otherwise PCLinuxOS 2007 makes secure wireless a breeze, with support for secured 128 bit WEP.
  • The apt-get feature (combined with Synaptic of PCLinuxOS) of most Linux flavors (yast in OpenSuse) is great to keep your specific O/S features upto-date and remove broken packages. The control you have over your custom machine software is simply great.
  • I can’t access the SD Card inserted in the proprietary Acer Laptop Texas Instruments SD/MMC Card Reader – but I can connect the Kodak digital camera via USB and the photos can be uploaded. Latest: PCLinuxOS 2007 TR4 has a fix for many Gateway laptop SD card reader issues in their support forums for most SD cards and multi card readers.
  • I can’t read MS Visio documents (but this in development and I will use visio converted to jpegs till then).
  • Open Office is not yet a very mature software and cannot reasonably compare to MS Office 2003 in either features or printing of Excel documents.
  • PCLinuxOS 2007 has Beryl which is a decent 3D windows manager with nice 3D windows effects – but 3D windows is still not a very refined concept and I would suggest uninstalling the compiz and beryl 3D software.

Well, that’s it from me, see ya… Keep your Knoppix CD/DVD or PCLinuxOS CD/DVD/USB ready…. as we say in Linux there is true consumer choice even though I personally vote for PCLinuxOS 2007 TR4

Oh ya.. Knoppix supports clusters and a multi-computer version is out called “ParallelKnoppix” which converts a host of windows machines into a Linux Cluster Farm. Descriptions are here – http://idea.uab.es/mcreel/ParallelKnoppix/ http://www.knoppix.net/wiki/Cluster_Live_CD

Howto? – Another useful site to learn to use Linux – http://www.linux.ie/articles/tutorials/

Some more flavors that receive good desktop Linux reviews are

Other good sites with helpful linux links:

Advertisements

Simple SQL Server/MSDE Database Installation through osql

October 13, 2004

Here, a MSDE database is dropped, attached, and a user is given rights on the db
With minor changes to the osql parameters a Server name can be provided and this script will work for an SQL 2000 database.

–drop old db
osql -E -S -Q “DROP DATABASE [dbname]”

–copy the mdf to the target loc
copy “c:\installtemp\dbname*.?df” “C:\program Files\Microsoft SQL Server\MSSQL\Data”

–make sure the db file is not read only
attrib -r “C:\program Files\Microsoft SQL Server\MSSQL\Data\dbname*.?df”

–attach the db to the target instance/server
osql -E -S -Q “EXEC sp_attach_db @dbname = ‘dbname’, @filename1 = N’C:\Program Files\Microsoft SQL Server\MSSQL\Data\dbname_Log.LDF’, @filename2 = N’C:\Program Files\Microsoft SQL Server\MSSQL\Data\dbname_Data.MDF'”

use dbname
–add a user to access this db apart from default db admin user
EXEC sp_grantdbaccess “domain\user”, “domain\user”
GO

–grant read access to this user
exec sp_addrolemember N’db_datareader’, “domain\user”
GO

–grant write access to this user
exec sp_addrolemember N’db_datawriter’, “domain\user”
GO

–security script to make sure sps and fns have exec priv.
osql -E -S -Q -i “c:\installtemp\dbnameSecuritySetup.sql”

–Security script is below — dbnameSecuritySetup.sql
–recurively grant exec priv to all sps and fns in db.
USE dbname
DECLARE @sExecQry sysname
DECLARE EXEC_SPS CURSOR LOCAL FOR
select ‘grant exec on ‘ + QUOTENAME(name) + ‘ to “domain\user” ‘ from sysobjects where (type = ‘P’ or type=’FN’) and objectproperty(id,’IsMSShipped’)=0
OPEN EXEC_SPS
FETCH NEXT FROM EXEC_SPS INTO @sExecQry
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC(@sExecQry)
–PRINT @sExecQry — debug only
FETCH NEXT FROM EXEC_SPS INTO @sExecQry
END
CLOSE EXEC_SPS
GO

–Perform checks on the database
DBCC CHECKCONSTRAINTS WITH ALL_CONSTRAINTS
GO

DBCC CHECKDB
GO

DBCC CHECKALLOC
GO

DBCC CONCURRENCYVIOLATION
GO

DBCC DROPCLEANBUFFERS
GO

DBCC FREEPROCCACHE
GO

DBCC UPDATEUSAGE(0)
GO