SoupToNuts: articles and software / News: Recent posts

If you have a Google Gmail account, you can relay mail from your home linux system. It's a good exercise in configuring Postfix with TLS and SASL. Plus, you will learn how to bring down the mail safely, using fetchmail with the sslcertck option. That is after you have verify and copied the necessary certificates. You'll learn all that from this tutorial, http://souptonuts.sourceforge.net/postfix_tutorial.html, and you'll have Gmail running on your local Postfix MTA.

If the system administrator deliberately filters out all traffic except port 22 (ssh), to a single server, it is very likely that you can still gain access other computers behind the firewall.

This article http://souptonuts.sourceforge.net/sshtips.htm shows how remote Linux and Windows users can gain access to firewalled samba, mail, and http servers. In essence, it shows how openSSH and Putty can be used as a VPN solution for your home or work place.

These steps will show you how to create a functioning Linux system, with the latest 2.6 kernel compiled from source, and how to integrate the BusyBox utilities including the installation of DHCP. Plus, how to compile in the OpenSSH package on this CD based system. On system boot-up a filesystem will be created and the contents from the CD will be uncompressed and completely loaded into RAM -- the CD could be removed at this point for boot-up on a second computer. The remaining functioning system will have full ssh capabilities. You can take over any PC assuming, of course, you have configured the kernel with the appropriate drivers and the PC can boot from a CD.

SQLite Tutorial [ http://prdownloads.sourceforge.net/souptonuts/README_sqlite_tutorial.html?download ] This article explores the power and simplicity of sqlite3, first by starting with common commands and triggers, then the attach statement with the union operation is introduced in a way that allows multiple tables, in separate databases, to be combined as one virtual table, without the overhead of copying or moving data. Next, the simple sign function and the amazingly powerful trick of using this function in SQL select statements to solve complex queries with a single pass through the data is demonstrated, after making a brief mathematical case for how the sign function defines the absolute value and IF conditions.

How to Compile 2.6 kernel for RedHat 9 and 8.0 and get Fedora Updates Upgrading Redhat 9 or 8.0 to the 2.6.x kernel. [ http://prdownloads.sourceforge.net/souptonuts/README_26.txt?download ] This is a step by step approach on how to compile the kernel from source, then, get yum updates for all your other packages. There is also information and examples on writing a 2.6 kernel module.
MySQL Tips and Tricks Find out who is doing what in MySQL and how to kill the process, create binary log files, connect, create and select with Perl and Java, remove duplicates in a table with the index command, rollback and how to apply, merging several tables into one, updating foreign keys, monitor port 3306 with the tcpdump command, creating a C API, complex selects, and much more. ... read more