PostgreSQL

 Ubuntu 10.10, Ubuntu 9.10  No Responses »
Mar 072011
 

http://www.postgresql.org/
documentation with user comments: http://www.postgresql.org/docs/8.4/interactive/index.html

install on Ubuntu

http://wiki.ubuntuusers.de/PostgreSQL (German)
https://help.ubuntu.com/community/PostgreSQL

sudo apt-get install postgresql

pgAdmin III is a handy GUI for PostgreSQL, it is essential to beginners. To install it, type at the command line:

sudo apt-get install pgadmin3

Setup: Now you have to set the password for the admin user postgres:

sudo -u postgres psql template1

This opens a PostgreSQL environment (looks like template1=#). Now do

ALTER ROLE postgres WITH PASSWORD 'new password';

if all worked you get ALTER ROLE as response. To quit the postgres environment do \q.

Read the full post (333 words, estimated 1:20 mins reading time)

Install Picasa (by Google)

 Ubuntu 9.10  No Responses »
Apr 292010
 

http://wiki.ubuntuusers.de/picasa
http://picasa.google.com/intl/de/linux/download.html#picasa30
http://www.google.com/linuxrepositories/testrepo.html
http://www.google.com/linuxrepositories/apt.html

add the following entry to /etc/apt/sources.list

# Google software repository
deb http://dl.google.com/linux/deb/ stable non-free main

or if you want to access newer software use the following lines ( http://www.google.com/linuxrepositories/testrepo.html ) :

# Google repository
deb http://dl.google.com/linux/deb/ stable non-free
# Google testing repository
deb http://dl.google.com/linux/deb/ testing non-free


wget -q -O - https://dl-ssl.google.com/linux/linux_signing_key.pub | sudo apt-key add -
sudo aptitude update
sudo aptitude install picasa
VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
Permanent link to this post (74 words, estimated 18 secs reading time)

HowTo generate secure passwords using pwgen

 Ubuntu 9.10  No Responses »
Apr 272010
 

http://wiki.ubuntuusers.de/Shell/pwgen

sudo aptitude install pwgen

pwgen can generate safe passwords for you. It is a command line tool and can be used like this:

pwgen -s -y 8 1

-s means create a secure password, -y means it should contain at least one special character, 8 means it should be 8 characters long, and 1 means generate only one password. The output is (as an example):

nH6<^q*X
VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
Permanent link to this post (74 words, estimated 18 secs reading time)

digiKam

 Ubuntu 9.10  No Responses »
Apr 252010
 

digiKam is a great software to manage your digital photographs. I like it especially because it does not depend that much on a database / proprietary ways to store information about the photos as it saves most information directly to the files.

sudo aptitude install digikam digikam-doc

To install it on Mac OS X using the Macports system as found here:

sudo port install digikam

resources

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
Permanent link to this post (83 words, estimated 20 secs reading time)

Mount T-Online Mediencenter via WebDAV

 Mac OS X 10.7 Lion, Ubuntu 10.10, Ubuntu 9.10  2 Responses »
Apr 242010
 

This blog post describes how to mount the T-Online Mediencenter via WebDAV on Ubuntu Linux and on Windows 7 (64bit).

Resources

How To for Mac OS X

  1. Open Finder.
  2. Press [⌘]-[k].
  3. Connect to https://webdav.mediencenter.t-online.de
  4. Enter email address and password.

How To for Ubuntu Linux

First, install the required package davfs2:

sudo apt-get install davfs2

SUID bit for mount.davfs to be able to mount as non-root user and add your user to the group davfs2:

Read the full post (383 words, estimated 1:32 mins reading time)

Mount a GMail account as Filesystem using gmailfs

 Ubuntu 9.10  1 Response »
Apr 222010
 

Warning: my experience with gmailfs was not excellent! It was a bit slow and you always risk to lose data you stored on that account.

based on IMAP: http://sr71.net/projects/gmailfs/
(it used to be http://richard.jones.name/google-hacks/gmail-filesystem/gmail-filesystem.html but this was based on the Webinterface and that changed often)

gmailfs works with FUSE. So make sure Fuse is installed and works: http://wiki.ubuntuusers.de/fuse

Add user philipp to group fuse, install the python-fuse Ubuntu package and get the gmailfs code:

sudo usermod -aG fuse philipp
sudo aptitude install python-fuse
cd ~/Downloads
git clone git://git.sr71.net/gmailfs.git

you also need lgconstants.py from libgmail. See http://libgmail.cvs.sourceforge.net/viewvc/libgmail/libgmail/

Read the full post (239 words, estimated 57 secs reading time)

POV-Ray

 Ubuntu 9.10  No Responses »
Apr 212010
 

http://wiki.ubuntuusers.de/POV-ray

installation of povray itself:

sudo aptitude install povray povray-includes povray-examples povray-doc

as well as the graphical modeler:

sudo aptitude install kpovmodeler

usage

A file created by POV-Ray: http://de.wikipedia.org/wiki/Datei:Mug_and_Torus_morph.gif
http://gist.github.com/376217

General command line to render a scene (still has to be adopted for the file in question):

povray Width=800 Height=600 +V +Iscene.pov +Oscene.png +P +SP4 +Q9 +A0.2
VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
Permanent link to this post (64 words, estimated 15 secs reading time)

Apply a Lowpass Filter to an mp3 Audio File

 Ubuntu 9.10  No Responses »
Apr 162010
 

A lowpass filter can be applied using the command line tool sox. It tool can be installed like this on Ubuntu:

sudo aptitude install pacpl sox

Convert the audiofile to wave first (using Perl Audio Converter as sox has no mp3 support compiled in on Ubuntu systems):

pacpl --to wav basstest.mp3

Now apply the lowpass filter using sox:

sox basstest.wav basstest_low-freq.wav lowpass 100

if you want to see the filter you just applied, then use the plot option:

sudo aptitude install octave3.2
sox  --plot octave basstest.wav basstest_low-freq.wav lowpass 100 > lowpass.plt
octave lowpass.plt

resources

Read the full post (110 words, estimated 26 secs reading time)
 Older Entries