LINUX ADMINISTRATION NOTES & CODE SNIPPETS

Simple perl to postgresql examples:
#!/usr/bin/perl
#load perl postgresql module
use DBI;
$postgresql_database=yourpostgresdatabase;
$postgresql_user=yourpostgresuser;
$postgresql_password=yourpostgrespass;
$postgresql_host=localhost;
# connect to perl to postgresql database
my $dbh = DBI->connect(”DBI:Pg:dbname=$postgresql_database;
host=$postgresql_host”, “$postgresql_user”, “$postgresql_password”);
# EXAMPLE PERL and POSTGRESQL
# CREATE TABLE EXAMPLE
$sth = $dbh->prepare(”CREATE TABLE perl_postgres
( language varchar(40), version integer);”);
$sth->execute();
# EXAMPLE PERL and POSTGRESQL
# INSERT DATA INTO TABLE
$dbh->do(”INSERT INTO perl_postgres(language, version)
VALUES (?, ?)”, undef, (’perl’, 5)) or die (”Cannot INSERT”);
# [...]

Filed under: Administration, Database, Linux, Perl | No Comments »

Instead of burning all images to cd / dvd disks is sometimes better and quicker to just mount row iso 9660 file system to your Linux. Lets say that we want to mount myiso9660.iso image.
First create mount point:
mkdir /mnt/myiso
Then mount iso with linux mount command:
mount -t iso9660 myiso9660.iso /mnt/myiso -o loop
All files can be accessed [...]

Filed under: Administration, Commands, Linux | No Comments »

This link can be very useful for someone starting with Linux administration. This guide / tutorial covers all basic Linux commands and examples on command line using bash shell ( BASH ). It can also be use as a Linux command reference.
Linux Commands
enjoy your Linux commands training ..

Filed under: Administration, Bash, Commands, Linux | No Comments »