Everything to set up ubuntu server 6.10 , with mod_python 3.3.1 compiled from source,postgresql,cheetah,psycopg and php and more more..

apt-get install apache2

apt-get install  apache2-threaded-dev

(includes apxs2 for mod_python)

apt-get install python2.4-dev

(or

apt-get install python2.5-dev

for newer releases)

apt-get install make

compile  mod_python

vi mod_python.load

LoadModule python_module /usr/lib/apache2/modules/mod_python.so

enable the module : a2enmod mod_python

a2ensite to enable each virtual host
a2dissite to disable

install postgresql and postgresql-dev
(on newer releases:
apt-get install  postgresql-8.2 postgresql-server-dev-8.2 pgadmin3
)
search on packages for the right names
aptitude search postgresql

also install php after searching

install psycopg, cheetah from source . Download - follow instructions.

one liner in ubuntu > 7.04
apt get install apache2 apache2-threaded-dev postgresql-8.2 postgresql-server-dev-8.2

To install the latest pgadmin3 1.8.0
On ubuntu 7.10 gutsy
choose a mirror here:
http://www.postgresql.org/download/mirrors-ftp

 I live in greece so :

wget -q -O - http://www.pgadmin.org/pgp/archive_key_debian_ubun​tu.gpg| sudo apt-key add -

echo "deb http://ftp.ntua.gr/pub/databases/postgresql/pgadmi​n3/release/ubuntugutsy pgadmin" | sudo tee -a /etc/apt/sources.list

sudo apt-get update
sudo apt-get install pgadmin3

But again no line numbers in SQL editor ... shit.

brief memo for installing xfce 4.2 with graphical installer on ubuntu 7.10..

Hello fellow linuxers.

I am using Linux Mint Daryna 4.0 which uses the same packages as ubuntu 7.10.

I have installed xfce-desktop package which install the default xfce desktop version 4.1

for ubuntu 7.10.

On December 02 2007 was released version 4.2 of xfce.

From the few days that I have used xfce 4.1  I must say I am impressed by it's speed and responsiveness.

I 've never seen windows - file managers opening up so quick not with gnome nor with kde!

An besides I find it more user friendly too!

So yes there there is hope for Linux desktop with xfce.

So I am writing this memo because I plan to install xfce on all my pc's

(and other people pc's too!) .

So let's see the steps I took to install xfce 4.2.

1. Downloaded xfce 4.2 graphical installer from here http://www.xfce.org/download/

2. Basically I am writing this  for this command : (All requirements xfce4.2 installer needs to have)
So install:

sudo apt-get install libstartup-notification0-dev libvte-dev libhal-storage-dev libdbus-glib-1-dev libasound2-dev libxml2-dev libjpeg-dev

Hopefully after that all installer's requirements will be satisfied.

3. So start the installer as root.

su

chmod +x xfce4-4.4.2-installer.run

./xfce4-4.4.2-installer.run

Check if all requirements are met.

Press Next to choose over some features.

4. Options

libasound2-dev needs if you want to use alsa for the mixer .
This is an option in the first screen of the installer.




I also chose the option Extensive Optimizations and setup Display Managers.
Press Next

5. Enjoy while it's getting build





See also:
http://www.xfce.org/documentation/installers/xfce/​index.html

for other steps you have to take maybe to make xfce work.
Especially the sections for gdm or kdm.
If you have preinstalled xubuntu-desktop
I believe the xsession for the new xcfe desktop is added by the installer.

memo to tune up xfce 4.2

Add another language to xfce.

Modify /etc/X11/xorg.conf

the section for keyboard and set

Option        "XkbLayout"

Option  "XkbOptions"

In the example below I am using us , and gr ( greek ) layouts.

Section "InputDevice"
    Identifier    "Generic Keyboard"
    Driver        "kbd"
    Option        "CoreKeyboard"
    Option        "XkbRules"    "xorg"
    Option        "XkbModel"    "pc105"
    Option        "XkbLayout"    "us,gr"
    Option  "XkbOptions"  "grp:ctrl_shift_toggle"
EndSection

Option  "XkbOptions"  "grp:ctrl_shift_toggle"
allows me to switch layouts with ctrl + shift

A short memo for configuring postgresql to use password (md5) authentication.

by thk — last modified 2007-03-06 02:18

settings for postgresql 8.3 are at folder

/etc/postgresql/8.3/main/

1. modify pg_hba.conf to enter as postgres user in the database without password (this is the default so probably you won't have to change anything)

local   all        ​postgres       ​        ​        ​  trust sameuser

reload service

sudo /etc/init.d/postgresql-8.3 reload

2. then su to user postgres (you have to be root) and login to  postgresql

su postgres
psql -U postgres -d template1
3. change postgres user  password:

ALTER USER postgres with encrypted password 'pass';

4. change again pg_hba.conf

set up md5 autentication for postgres and all other users

local   all        ​postgres       ​        ​        ​  md5 sameuser

local   all        ​all       ​        ​        ​  md5 sameuser

5. reload service.

sudo /etc/init.d/postgresql-8.3 reload

6. Install pgadmin3 and login as postgres

sudo apt-get install pgadmin3

enter the password you put in step 3

Now you can create new users from the Login Roles - > right click New Login Role in the menu

==================================================​=

show tables

SELECT table_name FROM information_schema.tables ;

SHOW DATABASES (l) = SELECT datname FROM pg_database;

SHOW COLUMNS FROM table (d table) = SELECT column_name FROM information_schema.columns WHERE table_name ='table';

== Open tcp Connections =============

1. at pg_hba.conf

 IPv4 local connections:
host    all        ​all         192.168.1.0/24      ​        password

# IPv6 local connections:
host    all        ​all         192.168.1.0/24      ​        password

-- this open postgres to your local lan only (modify accordingly..)

maybe some other athentication method -more secure-  may be used
if you want to operate in network mode permanently and not temporarily.

2. postgresql server settings

a) On Suse 10.1 at /etc/sysconfig/postgresql

POSTGRES_OPTIONS="-i"

b) On Ubuntu Server 6.06 at /etc/postgresql/8.1/main/postgresql.conf

listen_addresses = '192.168.1.33'

if you want to listen only to your local lan (modify to your local lan ip address) ,
 '*'  if you want  to  listen at all network interfaces.

CREATE USER

create role user_name with password 'pass' createdb createrole login;

backup

pg_dump -Ft dbname -U username -f backup.tar

restore

pg_restore -d dbname -U username -v backup.tar

(This is an old plone howto I wrote)

by thk — last modified 2006-05-15 12:14

by default recent portlet doesn't show up to non - members.. Here is how to modify this behavior..