Juni 20, 2009 Archives

Sa 20. Jun 03:38:59 CEST 2009

Automatic security updates for Debian based systems

unattend-upgrades is a debian package providing automatic security upgrades.

To use it, just install unattended-upgrades, modify /etc/apt/apt.conf.d/50unattended-upgrades to your needs like:

Unattended-Upgrade::Allowed-Origins { "Debian stable"; };
To automatically and unattended install security updates you also have to set
APT::Periodic::Update-Package-Lists "1";
APT::Periodic::Unattended-Upgrade "1";
in /etc/apt/apt.conf or in a file located in /etc/apt/apt.conf.d/ (I use /etc/apt/apt.conf.d/60security)
For further details have a look at /usr/share/doc/unattended-upgrades/README or https://wiki.ubuntu.com/AutomaticUpdates

Just setup unattended-upgrades and life becomes more easy as you dont have to remember to upgrade each of your machines.

Posted by Ulrich Dangel | Permanent Link | Categories: Shell stuff

Sa 20. Jun 03:10:56 CEST 2009

One command line interface for multiple RDBMS systems

sqlline a java based console program allows you to connect to any database with existing jdbc drivers replacing the original programs like mysql, sqlplus or psql.

Example to connect to an oracle database with sqlline:

$ java -cp ~/path/classpath/classes12.jar:/usr/share/java/sqlline.jar sqlline.SqlLine
sqlline version 1.0.2 by Marc Prud'hommeaux                
sqlline> !connect jdbc:oracle:thin:@hostname:1521:xe USER PASS
Connecting to jdbc:oracle:thin:@hostname:1521:xe
Connected to: Oracle (version Oracle Database 10g Express Edition Release -
2: jdbc:oracle:thin:@hostname:1521:xe> 

Posted by Ulrich Dangel | Permanent Link | Categories: Shell stuff, Stuff