Mountain Climbing Journal (MCJ) is a journal application that includes a SQL Tool to query the database using an embedded SQLite database engine. In Part 1 we created an initial database. Now, let’s add some records. The empty cup-like icon that is yellow, below, is what is used to add a blank record. It turns […]
Using MCJ to Practice SQL Commands – Part 2 – Creating Some Records
Using MCJ to Practice SQL Commands – Part 3 – Some Queries
Mountain Climbing Journal (MCJ) is a journal application that includes a SQL Tool to query the database using an embedded SQLite database engine. In Part 2 we created some records. Now, let’s do some queries. Our first query will be to select all fields in all records in the journal table: select * from journal […]
Importing a CSV file to a SQLite Database
SQLite has a build in import command for importing records from text files. We used a tab for a field separator: $ sqlite3 database.db SQLite version 3.1.3 Enter “.help” for instructions sqlite> .separator “\t” Now that we have set our field separator, we can import: sqlite> .import ex.txt tablename sqlite>
Setting MySQL System Variables on the Fly
Many MySQL system variables can be set on the fly at the command line, without restarting the server. This is a great thing at times, like when that new code which was so thoroughly “tested” winds up consuming five times the database connections as the old version. Oops! Well, within the limits of the resources […]
Updating Tables with SQL
As we mentioned in Using MCJ to Practice SQL Commands, the MCJ has the ability to run queries directly. We had a bunch of configuration and compile options that now should run with type for the build tab2. We can change all of the chroot types to prechroot with the SQL command: update journal set […]
IPStor SAN/NAS
If you are considering any kind of SAN or NAS check out IPStor software by FalconStor. IPStor can be loaded on two Linux servers. These servers communicate with eachother and will failover automatically. They communicate via fibre channel or SCSI with storage devices (RAID cabinets, tape libraries, etc). They communicate with other servers (NT, Linux, […]
Managing Files With FileRunner
There are many filemanagers available for GNU/Linux; however, the one filemanager that has the most power for managing tons of files is the humble FileRunner. The fancy ones on KDE and Gnome aren’t entirely reliable, mainly, because they aren’t simple. They try and compete with XP by providing icons, previews, etc. That may be cool […]
Point and Print in Samba
If you’re using a samba server to provide print services to Windows clients, why not take it one step further by offering point and print functionality. If you set this up, users *might* even be able to install printers themselves! At the very least it will save you time when you slave over their workstations […]
Default Admin Page for CUPS
Agatha broke her CUPS configuration when upgrading her Gentoo workstation. Simply deleting the old printer and creating a new one works. The thing about CUPS is that it just rocks, and only breaks, to our memory, during an upgrade. The configuration for the daemon is in /etc/cups/cupsd.conf. The cool web-based admin tool makes it really […]
Creating a SAN with iSCSI – Part 1 – Setting up the Target on GNU/Linux
[See This article for a newer procedure.] An iSCSI target is the server piece of an iSCSI SAN. The client piece/driver is called the initiator. We will be running the target on a GNU/Linux box with a 2.4.27 kernel, and will run the initiator on a Windows 2000 server. For our iSCSI target, we will […]
Creating a SAN with iSCSI – Part 2 – Setting up a Windows Initiator – Initial Install
We are going to create a drive that appears to the Windows 2000 operating system as a regular hard disk drive; however, this drive is actually a filesystem on a GNU/Linux box that is exported via TCP/IP using the iSCSI protocol. We created the server to do this in this article. Now, we need to […]
Creating a SAN with iSCSI – Part 3 – Setting up a Windows Initiator – Finish Install
You will see another license agreement box: If you agree, click Agree. You will be notified that the iSCSI initiator is installing: A box regarding the digital signature of the package will pop up: Click Yes if you wish to continue. If the iSCSI initiator installs successfully, you will see this box: A box with […]
Creating a SAN with iSCSI – Part 6 – Setting up a Windows Initiator – Finishing Up
Our drive is detected properly now, and we have 3 gigs of unallocated space: Format the disk: If you want the drive to automatically be available at boot, check the box: Let’s copy a file over to our iSCSI drive: This drive is treated just like a hardware drive would be, but it is all […]
Configuring Print Margins With Alignmargins
There is a cool utility available from LinuxPrinting.org that can help align your margins. Below is how we configured our HP Laserjet 1200: [root@srv-1 usr-1]# cd /tmp [root@srv-1 tmp]# wget http://www.linuxprinting.org/download/printing/align.ps –07:04:32– http://www.linuxprinting.org/download/printing/align.ps => `align.ps’ Resolving www.linuxprinting.org… 216.129.135.176 Connecting to www.linuxprinting.org[216.129.135.176]:80… connected. HTTP request sent, awaiting response… 200 OK Length: 5,352 [application/postscript] 100%[====================================>] 5,352 28.10K/s […]
UNIX and Outlook Express Interoperability
The MIME on Outlook Express seems to be broken. We have seen several instances where Outlook Express users cannot read Email sent by UNIX Email clients. The message is garbled with lots of question marks and other random characters. We have had this problem here at netadmintools.com, since we use Linux Office Suite 99 for […]
IMAP Installation and Initial Configuration
First, we grab the source from the UW distribution link on here: [root@srv-33 src]# ls imap.tar.Z imap-utils.tar.Z [root@srv-33 src]# tar -xzf imap.tar.Z [root@srv-33 src]# ls imap-2001.BETA.SNAP-0105251616 imap.tar.Z imap-utils.tar.Z [root@srv-33 src]# mkdir imaputils (We will deal with imaputils in a different section.) [root@srv-33 src]# mv *util* imaputils mv: cannot move `imaputils’ to a subdirectory of itself, […]
Sendmail Installation and Initial Configuration
First, we want to remove all the RPM stuff. A general note here. We are removing the RPMs, because we want to write all of the articles from the perspective of a generic Linux distribution as much as possible. True, we rely on the default file structure and general layout of Red Hat; however, by […]
Automated email of attachments
It is quite easy to email security or traffic reports automatically. We will use mpack, sendmail, and cron, but certainly the techniques could be combined with other utilities. The challenge with emailing files is that you have to encode the attachments into the email message using MIME. For the nitty gritty on MIME, see http://www.nacs.uci.edu/indiv/ehood/MIME/MIME.html. […]
Clean up spam with Pine
Outlook is nice and all, particularly when dealing with, oh, 90 percent of the email clients out there. The same thing that makes it nice, also makes it insecure. Some of the email accounts we monitor have been quite public, and receive not only a lot of spam, but also a lot of viruses. If […]
Masquerading with Sendmail
If you have a sendmail server that has a hostname that isn’t resolvable, you may need to masquerade as a different host. This is often the case if you are running sendmail on your internal workstation. We also ran into this while bringing up a Squirrel Mail web based mail system. Simply add these lines […]
