quarta-feira, 23 de maio de 2007

Erro em Transações Distribuidas com Oracle Client 9.2.0.1

COM+/Enterprise Services, Distributed Transactions and Oracle - Problem Solved: oramts.dll

Continuing the saga, I was able to find someone at Oracle who could duplicate the problem we had been having, and it definitely was the MTS proxy file from Oracle. In particular, its the oramts.dll file, part of the Oracle Services for MTS 9.2.0.4 package. I found Oracle had noted it internally as a bug back in December, but it hasn't been updated in the above package. I was pointed to a zipped version of the oramts.dll to download and install. After installing (actually, replacing the old oramts.dll file with the new oramts.dll file), all of my distributed transactions using COM+, ES, ODP.NET, and Microsoft's Oracle Provider worked!

Updated: A patch is available on MetaLink as patch #3252645. Download the p3252645_9204_WINNT.zip file which contains oramts.dll and oramts.dbg, marked as version 9.2.0.4.1, fixing the following issue: BRANCH IN TX GIVES: NEW TRANSACTION CANNOT ENLIST IN THE SPECIFIED COORDINATOR. Obtain the patch if you are using Oracle Services for MTS 9.2.0.4 with OraOLEDB, ODP.NET, and/or Microsoft's System.Data.OracleClient .NET provider.

domingo, 20 de maio de 2007

How to Tunnel Remote Desktop Through SSH on a Windows Computer

How to Tunnel Remote Desktop

Through SSH on a Windows Computer


Why me and why now?

CAE has been charged to implement the College of Engineering Network Security Policy . As part of the security measures, the College has set up a firewall, which blocks access to the College's network on certain ports.

Those wishing to access their office (or lab) computer can do so via "Windows Remote Desktop", although not directly. The method described below provides a secure (encrypted via SSH) method to gain access to a remote desktop (computer) behind the College's firewall. This procedure is called tunneling. For details on how to remotely connect to a CAE Desktop, see the CAE Remote Desktop page on the CAE web site.

What you need

Setting up PuTTY

  1. Start PuTTY (double-click on putty.exe). You will see a window similar to this one:


  2. Next, enable compression. Select SSH protocol level 2 as the default in the SSH subcategory for better security:


  3. To configure the "tunneling". In the example below, we are tunneling the remote desktop port on the local machine, through the gateway to the Remote Desktop port on the fictitious remote server "remotedesktop.engr.wisc.edu" (enter the name or IP address of your computer in place of this name). The name is resolved from the remote gateway machine, so it can be a hostname not visible to the user machine. Depending on your operating system, what you enter into "Source Port" may be different from the example shown:
    • Windows XP 127.0.0.2:3389
    • Other Windows Platforms: 3389
    For more information on why this is necessary, see this page


    • The source port is the port on the user machine to which you will address connections that you intend to have tunneled.
    • The destination defines a host and a port to which the remote gateway's sshd will connect incoming traffic from the user machine. When you click on
    • Add, the results are displayed like this:


  4. Go back to the Session subcategory, identify the gateway host's IP address or name (in the example below we used sun-10.cae.wisc.edu as the gateway, although it could be any computer with ssh allowed through the firewall), make sure that the SSH button is filled, name your session (in this case "Tunnel to my Remote Desktop") and save it:


    Whenever you need the tunnel to appear, you can start PuTTY and double-click that session.

Starting Remote Desktop

  1. Start PuTTY and then click on the session that you saved earlier; this will start the SSH connection.

  2. Login to the gateway computer when prompted (in this case, the gateway computer is 'sun-10.cae.wisc.edu') and when the login process is done, you can minimze the active PuTTY session (you don't need to type anything more, but you need to keep the program running).

  3. Start your Remote Desktop program as usual. Instead of entering the name of the computer that you want to connect to, you must type in the address and port that Putty is forwarding to. Depending on your operating system, this may be different from what is shown in the example:
    • Windows XP: 127.0.0.2
    • Other Windows Platforms: 127.0.0.1
    This will connect you to the computer that was specified in PuTTY (in this case, the fictional computer remotedesktop.engr.wisc.edu).

  4. Viola! You are now connected to your Remote Desktop computer through an SSH tunnel!

  5. After you are done using Remote Desktop, exit from the program as normal and then you may close the PuTTY program.

terça-feira, 15 de maio de 2007

Install Qnext on linux

We will never share your email address with any other company.

How to Install

1. Download Qnext by pressing the "Download Now" button above, and save it in a folder where you have full read, write and executable permissions on your system.

2. Decompress the downloaded archive and launch the application


bunzip2 qnextsetup.tar.bz2
tar -xf qnextsetup.tar
cd qnext
./qnext

That's it! Thanks again for downloading Qnext.

domingo, 13 de maio de 2007

Install Beryl - http://wiki.beryl-project.org/index.php/Install/Ubuntu/Edgy/AiGLX

Install Beryl on Ubuntu Edgy with AIGLX

From Beryl Wiki

(Redirected from Install/Ubuntu/Edgy/AiGLX)
Jump to: navigation, search

Contents

[hide]

Note

More documentation is available at https://help.ubuntu.com/community/CompositeManager/AIGLX


nVidia cards require the non-free drivers to be installed, as the default "nv" driver does not support acceleration.


Please note: ATI Cards : Depending on your card you may find that you can use the ati/radeon driver with AIGLX. If you experience problems then you may need to use Xgl with the fglrx Driver. 51292763791928900314235

How-to install Beryl with AIGLX on Edgy Eft

Add repositories

Edit the sources.list file, e.g. by opening a terminal and typing:

gksudo gedit /etc/apt/sources.list

Add this line:

deb http://ubuntu.beryl-project.org/ edgy main
deb-src http://ubuntu.beryl-project.org edgy main

For the GPG key (to ensure that the packages are authentic):

wget http://ubuntu.beryl-project.org/root@lupine.me.uk.gpg -O - | sudo apt-key add -


For EXPERIMENTAL svn packages, which are UNSUPPORTED (although bug-reports are most welcome :) ):

# Treviño's Beryl-SVN Ubuntu Repository
# GPG key: 81836EBF
deb http://download.tuxfamily.org/3v1deb edgy beryl-svn

GPG key for Treviño's repository:

wget http://3v1n0.tuxfamily.org/DD800CD9.gpg -O - | sudo apt-key add -

Update the package list before installing

sudo apt-get update

Install Beryl

First we must update

sudo apt-get update

then, simply type

sudo apt-get install beryl

That's too easy !

You'll also need themes for the decorations

sudo apt-get install emerald-themes

Beryl is a metapackage that will install all the dependencies (beryl-core, beryl-plugins, beryl-manager, beryl-settings) and also the decoration themes (emerald but not emerald-themes). Make sure you have all!

(or simply use:

sudo aptitude install beryl

since aptitude installs "recommended" packages as well as required and emerald-themes is recommended one of the other packages)

Starting Beryl

To start Beryl, you might just type beryl, but it is more useful to use the manager instead, so type

beryl-manager

If all goes well, Beryl should throw out a splash screen, and your window borders will change to an Emerald theme and the windows will become wobbly when you move them! Also note that there is a new Emerald icon in your system tray - this allows you to control Beryl, run BSM (the Beryl settings manager) or Emerald (the theme manager). It also provides fallback to another window manager, in case Beryl crashes.

If you don't get a splash screen immediately, you may need to tell the manager to load Beryl - click on the red gem, go to Select Window Manager and choose Beryl. If that doesn't work, there's a problem somewhere! Hopefully, useful debugging output will be in the terminal session; Ubuntu users can ask for help at #ubuntu-effects, or the stock #xgl channel on irc://irc.freenode.net/ or search the Beryl forums; others have probably had the same problem.

some common resolutions to try first are:

  • right clicking on the gem icon and setting the render path in advanced beryl options to "copy"
  • adding "Option "AddARGBGLXVisuals" "true"" to your graphics cards device section.

Configuring Beryl

Now that Beryl and AIGLX are installed, you need a way to start them up automatically. It is best to have a separate session (in GDM or KDM) for AIGLX, as some applications don't run properly with it (such as OpenGL games or remote sessions), and because it is experimental software that may be unstable and buggy. That way you can always log out or restart the X server and log into a regular session.

We will need to create two new files: A startup script and an X session file.

To create the session shell script, open up your favourite text editor (eg gedit or kwrite) as Root and create a new script named startberyl.sh:

 gksudo gedit /usr/bin/startberyl.sh
 kdesu kwrite /usr/bin/startberyl.sh

You can also save it to /usr/local/bin or ~/bin, changing the instructions below to suit.

Note: In Gnome it is handy to set up an Application Menu entry for Gedit as Root using System > Preferences > Menu Layout, using the command gksu "gedit %U", and Nautilus as Root using gksu nautilus.

Depending on your configuration, use one of the following scripts:

GNOME

#!/bin/sh
beryl-manager
sleep 4
exec gnome-session

KDE

#!/bin/sh
export KDEWM="/usr/bin/beryl-manager"
exec startkde

XFCE

#!/bin/sh
beryl-manager
sleep 4
exec xfce4-session

Alternatively, the last line can read

exec dbus-launch --exit-with-session gnome-session

for Gnome, and for KDE substituting gnome-session with startkde

Now you need to make the script executable; this can be done in Nautilus or Konqueror (running as Root) by right-clicking the file and choosing Properties, or in the terminal:

sudo chmod a+x /usr/bin/startberyl.sh


To create the session, create the file /usr/share/xsessions/Beryl.desktop, and give it the following contents in a text editor (again, as root or using gksudo/kdesu):

[Desktop Entry]
Encoding=UTF-8
Name=Beryl
Exec=/usr/bin/startberyl.sh
Icon=
Type=Application

Now when GDM or KDM starts, you should have a session called Beryl available for selection; if you log into this session, Beryl will run (via the startberyl.sh script) and load GNOME or KDE for you. Logging into your normal session will give you a standard, un-accelerated desktop for troubleshooting or running programs which don't play nicely with AIGLX.


You may find when loading this session that the Ubuntu splash screen freezes on Window Manager for a few minutes. If you wait this screen will disappear and all will be well. If you find this wait unacceptable (as I did) then follow the instructions below that explain how to start Beryl in the gnome session. If you want to tidy up your session selection screen then delete the file you just created by running the following command:

sudo rm /usr/share/xsessions/Beryl.desktop




Alternatively, you can set up Beryl Manager to start up every time you log in:

GNOME

  • Go to System > Preferences > Sessions
  • Go to the Startup Programs tab
  • Click the Add button and type in beryl-manager
  • Repeat the previous step, adding beryl
  • Exit

KDE

Simpler - but less graphical. In a terminal:

ln -s /usr/bin/beryl-manager ~/.kde/Autostart/beryl-manager

In case you have trouble starting up after adding beryl-manager to the Session startup (such as getting the White Cube/blank screen after the Beryl logo), and hence can't get to the GUI to remove them, you can do the following to remove it:

Press Ctrl-Alt-F2 to get to a console, log in, and type:

Gnome:

rm ~/.config/autostart/beryl-manager.desktop


KDE:

rm ~/.kde/Autostart/beryl-manager

Now you should be able to log back in by either pressing Ctrl-Alt-F7 (to get back to the display) followed by Ctrl-Alt-Backspace (to restart the X server), or by typing sudo /etc/init.d/gdm restart (kdm start for KDE) in the terminal followed by Ctrl-Alt-F7.

Using Beryl

If you find it too slow then open up Beryl Settings Manager and remove (or tweak) the blur effect -- some combinations of settings are really slow on some graphics cards.

sábado, 12 de maio de 2007

Deixe seu desktop mais bonito com o screenlets - http://dicasdenerd.wordpress.com/tag/ubuntu/

Deixe seu desktop mais bonito com o screenlets

Testei e funcionou muito bem com o beryl, sem ele não funciona muito bem não.

Ubuntu (Feisty)

Pressione Alt + F2 e digite:

gksudo gedit /etc/apt/sources.list

adicione os repositórios no final do arquivo:

# Screenlets
deb http://hendrik.kaju.pri.ee/ubuntu feisty screenlets
deb-src http://hendrik.kaju.pri.ee/ubuntu feisty screenlets

Ubuntu (Edgy)

Pressione Alt + F2 e digite:

gksudo gedit /etc/apt/sources.list

adicione os repositórios no final do arquivo:

# Screenlets
deb http://hendrik.kaju.pri.ee/ubuntu edgy all
deb-src http://hendrik.kaju.pri.ee/ubuntu edgy all

Agora no terminal digite o comando abaixo para baixar, importar a chave e atualizar sua lista de repositórios:

sudo apt-get update && wget http://hendrik.kaju.pri.ee/ubuntu/F854AFD7.gpg -O- | sudo apt-key add -

e para instalar digite:

sudo apt-get install screenlets

Para iniciar pressione Alt + F2 e digite:

screenlets-tray

ou então clique emAplicações > Acessórios > Screenlets

Firefox mais rápido

Firefox mais rápido

Edite o about:config

network.http.pipelining true Requests em Threads
network.http.pipelining.maxrequests 8 Aumenta os requests máximos em paralelo
network.http.proxy.pipelining true Requests em Threads com proxy
network.dns.disableIPv6 true Desabilitando IPv6
plugin.expose_full_path true Mostra o path completo dos plugins no about:plugins
nglayout.initialpaint.delay 0 Tempo de espera antes do rendering
content.notify.backoffcount 5 Número de recargas do processo de rendering
ui.submenuDelay 0 Zera o tempo para aparecer o submenu
config.trim_on_minimize false Evita liberar memória ao minimizar
network.http.max-connections 40 Número máximo de conexões (Banda larga)
network.http.max-connections-per-server 16 Número de conexões por servidor
network.http.pipelining.firstrequest true Usa o pipeline já no primeiro request

Softwares Equivalentes (Linux x Windows) - http://www.linuxeq.com/

Welcome to the Linux Equivalent Project. The goal is to provide an informational and available website for all linux users. The website is currently in beta form. I will be periodically updating the database with Windows software and the Linux equivalents and alternatives.

Windows Software Linux Equivalent/Alternative
3D Studio Max
K-3D ( http://www.k-3d.org/ )
Wings 3D ( http://www.wings3d.com/ )
Art of Illusion ( http://www.artofillusion.org/ )
Blender ( http://www.blender.org/ )
Adobe Acrobat Reader
Xpdf ( http://www.foolabs.com/xpdf/ )
Evince ( http://www.gnome.org/projects/evince/ )
ePDFView ( http://trac.emma-soft.com/epdfview/ )
KPDF ( http://kpdf.kde.org/ )
Adobe Audition
Audacity ( http://audacity.sourceforge.net/ )
Adobe Illustrator
Inkscape ( http://www.inkscape.org/ )
Karbon14 ( http://www.koffice.org/karbon/ )
Xara Xtreme for Linux ( http://www.xaraxtreme.org/ )
Adobe PageMaker
Scribus ( http://www.scribus.net/ )
Adobe PhotoAlbum
F-Spot ( http://f-spot.org/Main_Page )
digiKam ( http://www.digikam.org/ )
Adobe Photoshop
CinePaint ( http://www.cinepaint.org/ )
Krita ( http://www.koffice.org/krita/ )
GIMP ( http://www.gimp.org/ )
Adobe Premier
PiTiVi ( http://www.pitivi.org/wiki/Main_Page )
LiVES ( http://lives.sourceforge.net/ )
Kino ( http://www.kinodv.org/ )
Cinelerra ( http://cvs.cinelerra.org/ )
kdenlive ( http://kdenlive.sourceforge.net/ )
AOL Instant Messenger (AIM)
Kopete ( http://kopete.kde.org/ )
Gaim ( http://gaim.sourceforge.net )
APC PowerChute
Network UPS Tools ( http://www.networkupstools.org/ )
Apcupsd ( http://www.apcupsd.com/ )
PowerD ( http://power.sourceforge.net/ )
CDex
Sound Juicer ( http://www.burtonini.com/blog/computers/sound-juicer )
Rubyripper ( http://wiki.hydrogenaudio.org/index.php?title=Rubyripper )
ripperX ( http://ripperx.sourceforge.net/ )
Grip ( http://nostatic.org/grip/ )
KAudioCreator ( http://www.icefox.net/programs/?program=KAudioCreator )
Collectorz
aviManager ( http://avimanager.sourceforge.net/ )
GCstar ( http://www.gcstar.org/ )
Tellico ( http://periapsis.org/tellico/ )
Alexandria ( http://alexandria.rubyforge.org/ )
Griffith ( http://griffith.vasconunes.net/ )
vMovieDB ( http://vmoviedb.sourceforge.net/ )
Katalog ( http://salvaste.altervista.org/ )
Dreamweaver
Quanta Plus ( http://quanta.kdewebdev.org/ )
Geany ( http://geany.uvena.de )
Nvu ( http://www.nvu.com/index.php )
Screem ( http://www.screem.org/ )
Bluefish ( http://bluefish.openoffice.nl/index.html )
DVDShrink
k9copy ( http://k9copy.sourceforge.net/ )
OGMRip ( http://ogmrip.sourceforge.net/ )
Thoggen ( http://thoggen.net/ )
xdvdshrink ( http://dvdshrink.sourceforge.net/ )
DVD Rip-O-Matic ( http://dvdripomatic.sourceforge.net )
qVamps ( http://vamps.sourceforge.net/ )
dvd::rip ( http://www.exit1.org/dvdrip/ )
AcidRip ( http://untrepid.com/acidrip/ )
Everest
HardInfo ( http://hardinfo.berlios.de/web/HomePage )
Finale
Lilypond ( http://www.lilypond.org )
Rosegarden ( http://www.rosegardenmusic.com/ )
Forte Agent
Pan ( http://pan.rebelbase.com/ )
FruityLoops
LMMS ( http://lmms.sourceforge.net/ )
Hydrogen ( http://www.hydrogen-music.org/ )
Google Desktop Search
Beagle ( http://beagle-project.org/ )
iTunes
Banshee ( http://banshee-project.org/Main_Page )
Listen ( http://listengnome.free.fr/ )
Quod Libet ( http://www.sacredchao.net/quodlibet )
SongBird ( http://www.songbirdnest.com )
Exaile ( http://www.exaile.org/ )
Amarok ( http://amarok.kde.org/ )
gtkpod ( http://www.gtkpod.org/ )
Legacy Family Tree
GRAMPS ( http://gramps-project.org/ )
LimeWire
FrostWire ( http://www.frostwire.com/ )
Meal Master
Gourmet Recipe Manager ( http://grecipe-manager.sourceforge.net/ )
Microsoft Frontpage
Quanta Plus ( http://quanta.kdewebdev.org/ )
Nvu ( http://www.nvu.com/index.php )
Bluefish ( http://bluefish.openoffice.nl/index.html )
Microsoft HyperTerminal
minicom ( http://alioth.debian.org/projects/minicom/ )
GtkTerm ( http://freshmeat.net/projects/gtkterm/ )
Microsoft Internet Explorer
Epiphany ( http://www.gnome.org/projects/epiphany/ )
Opera ( http://www.opera.com/download/ )
Firefox ( http://www.mozilla.com/firefox/ )
Konqueror ( http://www.konqueror.org/ )
Microsoft Office
KOffice ( http://www.koffice.org/ )
OpenOffice ( http://www.openoffice.org/ )
Microsoft Outlook (Express)
Thunderbird ( http://www.mozilla.com/thunderbird/ )
Evolution ( http://www.gnome.org/projects/evolution/ )
Microsoft Project
KPlato ( http://www.koffice.org/kplato/ )
GanttProject ( http://ganttproject.sourceforge.net/ )
Planner ( http://live.gnome.org/Planner )
TaskJuggler ( http://www.taskjuggler.org/ )
Microsoft Visio
Dia ( http://www.gnome.org/projects/dia/ )
Kivio ( http://www.koffice.org/kivio/ )
Microsoft Windows Media Center
Freevo ( http://freevo.sourceforge.net/ )
Elisa Media Center ( http://www.fluendo.com/elisa/ )
MythTV ( http://www.mythtv.org )
mIRC
KVIrc ( http://www.kvirc.net/ )
BitchX ( http://www.bitchx.org/ )
Xchat ( http://www.xchat.org/ )
ChatZilla! ( http://chatzilla.hacksrus.com/ )
irssi ( http://www.irssi.org/ )
Gaim ( http://gaim.sourceforge.net )
Mp3tag
Kid3 ( http://kid3.sourceforge.net/ )
Pinkytagger ( http://pinkytagger.sourceforge.net/ )
EasyTAG ( http://easytag.sourceforge.net/ )
Cowbell ( http://more-cowbell.org/ )
Audio Tag Tool ( http://pwp.netcabo.pt/paol/tagtool/ )
MSN messenger
Mercury Messenger ( http://www.mercury.to/ )
Kopete ( http://kopete.kde.org/ )
aMSN ( http://amsn-project.net/ )
Gaim ( http://gaim.sourceforge.net )
Mudbox
SharpConstruct ( http://sharp3d.sourceforge.net )
Nero Burning Rom
X-CD-Roast ( http://www.xcdroast.org/ )
Brasero ( http://perso.orange.fr/bonfire/index.htm )
GnomeBaker ( http://gnomebaker.sourceforge.net/ )
Graveman! ( http://graveman.tuxfamily.org/ )
K3b ( http://www.k3b.org/ )
NetMeeting
Ekiga ( http://www.gnomemeeting.org/ )
NetStumbler
Kismet ( http://www.kismetwireless.net/ )
SWScanner ( http://www.swscanner.org/ )
Notepad
leafpad ( http://tarot.freeshell.org/leafpad/ )
NEdit ( http://www.nedit.org/ )
Kate ( http://kate-editor.org/ )
gedit ( http://www.gnome.org/projects/gedit/ )
Scribes ( http://scribes.sourceforge.net/ )
tpad ( http://tclpad.sourceforge.net/ )
Origin
SciGraphica ( http://scigraphica.sourceforge.net/ )
Partition Magic
GParted ( http://gparted.sourceforge.net/ )
QtParted ( http://qtparted.sourceforge.net )
Pro Tools
Ardour ( http://www.ardour.org )
Quicken
KMyMoney ( http://kmymoney2.sourceforge.net/ )
GNUcash ( http://www.gnucash.org/ )
Gnofin ( http://gnofin.sourceforge.net/ )
Grisbi ( http://www.grisbi.org/ )
SoulSeek
Nicotine ( http://nicotine.thegraveyard.org/ )
Nicotine-Plus ( http://nicotine-plus.sourceforge.net/ )
Total Commander
GNOME Commander ( http://www.nongnu.org/gcmd/ )
xfe ( http://roland65.free.fr/xfe/ )
Tux Commander ( http://tuxcmd.sourceforge.net/ )
Midnight Commander ( http://www.ibiblio.org/mc/ )
Krusader ( http://krusader.sourceforge.net/ )
Videora
thin liquid film ( http://thinliquidfilm.org/ )
Winamp
Amarok ( http://amarok.kde.org/ )
XMMS ( http://www.xmms.org/ )
Windows Media Player
KPlayer ( http://kplayer.sourceforge.net/ )
VideoLAN ( http://www.videolan.org/ )
xine ( http://xinehq.de/ )
mplayer ( http://www.mplayerhq.hu/design7/news.html )
Windows Movie Maker
PiTiVi ( http://www.pitivi.org/wiki/Main_Page )
LiVES ( http://lives.sourceforge.net/ )
Avidemux ( http://fixounet.free.fr/avidemux/ )
Cinelerra ( http://cvs.cinelerra.org/ )
kdenlive ( http://kdenlive.sourceforge.net/ )
WinIso
KIso ( http://kiso.sourceforge.net/ )
WinTV
tvtime ( http://tvtime.sourceforge.net/ )
WS_FTP
gFTP ( http://gftp.seul.org/ )
FireFTP ( http://fireftp.mozdev.org/ )
Zbrush
SharpConstruct ( http://sharp3d.sourceforge.net )
ZoneAlarm
Guarddog ( http://www.simonzone.com/software/guarddog/ )
Firestarter ( http://www.fs-security.com/ )

sexta-feira, 11 de maio de 2007

PostgreSQL on Ubuntu Linux - How To (updated) - http://hocuspok.us/journal/postgresql-on-ubuntu-linux-how-to-updated

PostgreSQL on Ubuntu Linux - How To (updated)

This 'How To' has now been replaced with an update. Check there for slightly better instructions. :D

Following on from my last post about PostgreSQL, i've found a couple of things were 'off' with the setup, so this is a quick re-write and update... on with the show!

So, if the last guide worked, what's different with this set-up...

  • We now enable and use the default 'postgres' user account to administrate our database server (saves creating a new one)!
  • We also fix a couple of issues with the networking set-up.
  • We now use the latest build of PostgreSQL - v8.1.
  • This set-up is less of a 'hack', than the last guide (i've been reading since then).

Before we move on, this guide was tested on (and intended for) the current stable build of Ubuntu (5.04 - Breezy Badger), but it should also work fine on any other build of Ubuntu/Debian (6.06 - Dapper Drake etc).

First off, PostgreSQL 8.1 isn't in the main repositories in Breezy, you'll need to have backports enabled to get hold of the latest packages. Once you've done that, let's move on.

Right, now let's install the database server. At the command-line, enter the following (Or you can do all this in Synaptic - just search for and install the packages listed in the commands):

> sudo apt-get install postgresql-8.1 postgresql-client-8.1
> sudo apt-get install pgadmin3 pgadmin3-data

This installs the database server, and the pgAdmin administration application (If you don't really get on with the pgAdmin GUI, there is an alternative in the form of phpPgAdmin - a web-based administration interface. A quick 'How To' on getting this up will be coming shortly! ;) ).

Now we need to reset the password for the 'postgres' admin account for the server, so we can use this for all of the system administration tasks. Type the following at the command-line (substitute in the password you want to use for your administrator account):

> sudo su postgres -c psql template1
template1=# ALTER USER postgres WITH PASSWORD '*password*';
template1=# \q

Then, from here on in we can use pgAdmin to run the database server. To get a menu entry for pgAdmin do the following...

> sudo gedit /usr/share/applications/pgadmin.desktop

Then paste the following into the file:

[Desktop Entry] Comment= PostgreSQL Administrator III
Name=pgAdmin III
Encoding=UTF-8
Exec=pgadmin3
Terminal=false
Comment[en_GB]=PostgreSQL Administrator III
Icon=/usr/share/pixmaps/pgadmin3.xpm
Type=Application
Categories=GNOME;Application;Database;System;
Name[en_GB]=pgAdmin III

Then save the file and exit gedit. You should find the launcher in the System Tools section of the Applications menu. Alternatively, you could just type 'pgadmin3' at the shell. The wizards to connect to the database should be pretty simple to figure out.

Finally, we need to open up the server so that we can access and use it remotely - unless you only want to access the database on the local machine (The guidelines here are for opening up your server on a secure LAN - if you are not on a secure LAN you may want to look into adding SSL authentication before proceeding with these steps).

To do this, first, we need to edit the postgresql.conf file:

> sudo gedit /etc/postgresql/8.1/main/postgresql.conf

Now, to edit a couple of lines in the 'Connections and Authentication' section...

Change the line:

#listen_addresses = 'localhost'

to

listen_addresses = '*'

and also change the line:

#password_encryption = on

to

password_encryption = on

Then save the file and close gedit.

Now for the final step, we must define who can access the server. This is all done using the pg_hba.conf file.

> sudo gedit /etc/postgresql/8.1/main/pg_hba.conf

Now add the following lines to the file:

# Allow any user on the local system to connect to any database under
# any user name using Unix-domain sockets (the default for local
# connections).
#
# Database administrative login by UNIX sockets
local all all trust

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all md5

# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5

# Connections for all PCs on the subnet
#
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
host all all [ip address] [subnet mask] md5

and in the last line, add in your subnet mask (i.e. 255.255.255.0) and the IP address of the machine that you would like to access your server (i.e. 138.250.192.115). However, if you would like to enable access to a range of IP addresses, just substitute the last number for a zero and all machines within that range will be allowed access (i.e. 138.250.192.0 would allow all machines with an IP address 138.250.192.x to use the database server).

That's it, now all you have to do is restart the server and all should be working!

> sudo /etc/init.d/postgresql-8.1 restart