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
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_ubuntu.gpg| sudo apt-key add -
echo "deb http://ftp.ntua.gr/pub/databases/postgresql/pgadmin3/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 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:
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
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
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
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';
--add a user like this
CREATE USER user WITH PASSWORD 'pass';
--grant permission to creat db
ALTER USER username CREATEDB;
4. change again pg_hba.conf
set up md5 autentication for postgres and all other users
local all postgres md5
local all all md5
5. reload service.
sudo /etc/init.d/postgresql-8.3 reload
===================================================
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 usedif 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..
1.Go to portal_skins -> plone_portlets
2.Customize the portlet_recent portlet.
3.Here is the lines that we will change
<div metal:define-macro="portlet"
tal:condition="python:not isAnon and template.getId()!='recently_published'">
<tal:recentlist tal:define="last_login_time python:member.getProperty('last_login_time', DateTime());
typesToShow python:putils.getUserFriendlyTypes();
results python:request.get('items',
here.portal_catalog.searchResults(sort_on='modified',
portal_type=typesToShow,
sort_order='reverse')[:5]);">
4.Change to
<div metal:define-macro="portlet">
<tal:recentlist tal:define="typesToShow python:putils.getUserFriendlyTypes();
results python:request.get('items',
here.portal_catalog.searchResults(sort_on='created',
portal_type=typesToShow,
sort_order='reverse')[:5]);">
How to set up the Broadcom BCM4318 wireless card that comes with Amilo 1655g laptop on SuSE Linux 10.1 and linx mint Daryna 4.0 (ubuntu gutsy based)
( Broadcom BCM4318 [AirForce One 54g] 802.11g Wireless LAN Controller ) .
The card was said not to work with linux on various forums I 've read.
Here are the steps I took in order to make it work on SuSE 10.1 x86_64.
1. Install ndiswrapper from Yast.
Go Yast->Software Management , Search for ndiswrapper , tick , and press Accept to Install.
More Details here http://www.tuxmagazine.com/node/1000167
2. Download the windows driver from here http://www.linuxant.com/driverloader/drivers.php
It's the "Airforce One" Broadcom devices with PCI ID 14E4:4318 ( ftp://ftp.support.acer-euro.com/notebook/ferrari_4000/driver/winxp64bit/80211g.zip ).
3. Extract the zip and run as root
from where the .inf file is located.
next
ndiswrapper -lyou should see something like that:
Installed drivers:
bcmwl5 driver installed, hardware present
please read http://www.tuxmagazine.com/node/1000167
4. On Yast -> Network Devices -> Network Card , I have selected
Traditional method with ifup.
But I suppose network manager will be ok too.
5. Add a wireless network interface if you dont already have.
Set the module name to ndiswrapper. This should load the ndiswrapper kernel module at boot.
6. Set the other details of your wireless card like Ip (static or via DHCP if you use it) , Gateway (routing).
These are on the Address tab.On general tab I have Device Activation On hotplug and User Controlled checked.I dont think other setups would make any trouble .
The key points of this setup are :
- first to load the ndiswrapper on kernel,
- set up the address , ssid ,encryption of your wireless card,
- and finally install a second kernel module that I ll refer later as ndiswrapper can't start/stop the hardware.
7. press next and Set the details of your wlan
press next and finish.Download the fsaa1655g source from http://www.marvec.org/amilo/
Everything is ok but the wireless card is not started!
This module can start/stop the card.
Extract the fsaa1655g source and run make && make install
Update 20071109
I had to comment out this line (line 32) on fsaa1655g.c
before running make :
/*#include <linux/config.h>*/
there is no config.h nowadays, I think it's deprecated.
9. Reboot .
10. Check if ndiswrapper module is loaded.
To see if the ndiswrapper kernel module is loaded after boot� , issue as root :
lsmod
this command lists the loaded modules of the kernel and you should see somewhere ndiswrapper.
(it's a great possibility that if ndiswrapper module wont load after reboot you should issue ndiswrapper -m and reboot )
11. Now the point is to load fsaa1655g module into the kernel , and restart network
Issue as root
modprobe fsaa1655g
ifdown wlan0
ifup wlan0
This little script I wrote starts / stops wireless card and interface depending on whether it is started or stopped.
I found it useful as I dont like my wireless to start automatically.I put it on /usr/local/bin.
Update - 20071109
Updated the script for my new installation linux mint celena on my laptop (it is based on ubuntu feisty).
I have the same ip on both interfaces (wireless and ethernet) set static and I noticed problems when having both
interfaces up.
I think I also noticed problems even when having different ips on the interfaces.
So i stop the ethernet interface before bringing up the wireless and vice versa.
I also had to put some sleep delays after stopping each interface in the script.
The whole installation at mint/celena is more or less the same.
Here are the steps I followed :
http://ubuntuforums.org/showthread.php?t=285809
I used wep-encryption on the router and on gnome network I set my wep ascii key .
I remember that using wpa encryption needed the wpa-supplicant script to run
so I went with wep.
I also removed various scripts in /etc/network that delayed the starting / stopping script
and decided I didn't need them
here is my /etc/network listing now:
root@turion:/home/thk# ls -l /etc/network
total 8
drwxr-xr-x 6 root root� 168 2007-11-09 15:52 bak
drwxr-xr-x 2 root root�� 48 2007-11-09 16:01 if-down.d
drwxr-xr-x 2 root root�� 80 2007-11-09 16:01 if-post-down.d
drwxr-xr-x 2 root root� 112 2007-11-09 16:01 if-pre-up.d
drwxr-xr-x 2 root root�� 48 2007-11-09 16:01 if-up.d
-rw-r----- 1 root admin 366 2007-11-09 16:29 interfaces
-rw-r----- 1 root admin 366 2007-11-09 16:19 interfaces~
root@turion:/home/thk# ls -lR /etc/network
/etc/network:
total 8
drwxr-xr-x 6 root root� 168 2007-11-09 15:52 bak
drwxr-xr-x 2 root root�� 48 2007-11-09 16:01 if-down.d
drwxr-xr-x 2 root root�� 80 2007-11-09 16:01 if-post-down.d
drwxr-xr-x 2 root root� 112 2007-11-09 16:01 if-pre-up.d
drwxr-xr-x 2 root root�� 48 2007-11-09 16:01 if-up.d
-rw-r----- 1 root admin 366 2007-11-09 16:29 interfaces
-rw-r----- 1 root admin 366 2007-11-09 16:19 interfaces~
/etc/network/bak:
total 0
drwxr-xr-x 2 root root 112 2007-04-29 18:27 if-down.d
drwxr-xr-x 2 root root 144 2007-04-29 15:25 if-post-down.d
drwxr-xr-x 2 root root 144 2007-11-09 15:50 if-pre-up.d
drwxr-xr-x 2 root root 192 2007-04-29 18:27 if-up.d
/etc/network/bak/if-down.d:
total 4
-rwxr-xr-x 1 root root 988 2007-03-27 21:40 avahi-autoipd
lrwxrwxrwx 1 root root� 32 2007-11-09 15:52 wpasupplicant -> ../../wpa_supplicant/ifupdown.sh
/etc/network/bak/if-post-down.d:
total 4
lrwxrwxrwx 1 root root� 23 2007-11-09 15:52 avahi-daemon -> ../if-up.d/avahi-daemon
-rwxr-xr-x 1 root root 997 2006-08-23 12:18 wireless-tools
lrwxrwxrwx 1 root root� 32 2007-11-09 15:52 wpasupplicant -> ../../wpa_supplicant/ifupdown.sh
/etc/network/bak/if-pre-up.d:
total 8
-rwxr-xr-x 1 root root 2391 2007-11-09 15:50 wireless-tools
-rw-r--r-- 1 root root 2358 2006-12-21 07:57 wireless-tools~
lrwxrwxrwx 1 root root�� 32 2007-11-09 15:52 wpasupplicant -> ../../wpa_supplicant/ifupdown.sh
/etc/network/bak/if-up.d:
total 16
-rwxr-xr-x 1 root root� 894 2007-03-27 21:40 avahi-autoipd
-rwxr-xr-x 1 root root 2005 2007-03-27 21:40 avahi-daemon
-rwxr-xr-x 1 root root 3190 2006-10-06 14:34 mountnfs
-rwxr-xr-x 1 root root� 462 2007-03-07 22:43 ntpdate
lrwxrwxrwx 1 root root�� 32 2007-11-09 15:52 wpasupplicant -> ../../wpa_supplicant/ifupdown.sh
/etc/network/if-down.d:
total 0
/etc/network/if-post-down.d:
total 4
-rwxr-xr-x 1 root root 997 2006-08-23 12:18 wireless-tools
/etc/network/if-pre-up.d:
total 8
-rwxr-xr-x 1 root root 2391 2007-11-09 15:50 wireless-tools
-rw-r--r-- 1 root root 2358 2006-12-21 07:57 wireless-tools~
/etc/network/if-up.d:
total 0
bak directory stores the backups of the if-up.d e.t.c. directories.
Update 20071126
On Linux mint 4.0 that is based on ubuntu 7.10
I was able to use WPA-PSK encryption since it is supported.
On the network tool i chose wpa-psk encryption.
Don't forget to blacklist the bcm module that is loaded in kernel
Blacklist native bcm43xx drivers
Issue: sudo gedit /etc/modprobe.d/blacklist
Add the line: blacklist bcm43xx
After saving type at the terminal: sudo rmmod bcm43xx
See also http://ubuntuforums.org/showthread.php?t=285809
#!/bin/bash
# By Thimios Katsoulis 2006-2007
# email: thk@kaotonik.net
# Feel free to copy , modify distribute.
# Starts wireless network and stops wired
# or vice versa.
# Made for my Fujitsu Siemens Amilo 1655g laptop with
# Broadcom Wireless
ethernet_interface=eth0
wireless_interface=eth1
#-- functions ------
function stop_interface
{
echo "bringing down interface $1"
ifdown --force $1
sleep 1
}
function start_interface
{
echo "starting interface $1"
ifup --force $1
}
function restart_interface
{
stop_interface $1
start_interface $1
}
function turn_off_radio
{
echo "turning off broadcom wireless card"
echo "0" > /proc/fsaa1655g/radio
}
function turn_on_radio
{
echo "turning on broadcom wireless card"
echo "1" > /proc/fsaa1655g/radio
}
function load_module
{
if [ $# -eq 1 ]
then
module=$1
if ! lsmod|grep $module
then
echo "loading module $module"
modprobe $module
else
echo "module $module is already loaded"
fi
else
echo "Usage is: load_module <module name>"
fi
}
function load_necessary_modules
{
#driver for the wireless card
load_module ndiswrapper
#this module turns on and off the wireless hardware
load_module fsaa1655g
}
#---- main ---------------
load_necessary_modules
sleep 1
if grep 0 /proc/fsaa1655g/radio
then
# Wireless is closed. Open it and stop wired
turn_on_radio
stop_interface $ethernet_interface
start_interface $wireless_interface
xmessage -center "Wireless started"
else
# Wireless is open. Close it and start wired
turn_off_radio
stop_interface $wireless_interface
start_interface $ethernet_interface
xmessage -center "Wireless stopped"
fi
You can add it to your kde or gnome menu , and set it to run as root.
Don't forget after you copy paste the above code to a text file , to make this text file executable:
Right click on the file and change it's permissions or in the console type: chmod +x <script's file name>
12. Now you should have wireless if everything went Ok.
Check with the ifconfig and iwconfig commands .
Disconnect your wired ethernet adapter and ping an ip on your local Lan.
Does it pong?
Good luck..
Update 20080628On linux mint elyssaa which is based on ubuntu hardy.
Every time the installation of this card becomes different.
This time :
sudo apt-get install bc43-fwcutter
if it doesn't find it google a little bit to find the correct repository for this
package. bc43-fwcutter will install the correct driver during installation. Run above command from console.
Follow the steps (number 8) described above to install fsaa1655g .
Uninstall ndiswrapper if you had installed it .
the script is modified this way with just deletion of the loading of ndiswrapper in
load_necessary_modules
.#!/bin/bash
# By Thimios Katsoulis 2006-2007
# thk@kaotonik.net
# Feel free to copy , modify destribute.
# Starts wireless network and stops wired
# or vice versa
# Made for my Fujitsu Siemens Amilo 1655g laptop with
# Broadcom Wireless
ethernet_interface=eth0
wireless_interface=wlan0
#-- functions ------
function stop_interface
{
echo "bringing down interface $1"
ifdown --force $1
sleep 1
}
function start_interface
{
echo "starting interface $1"
ifup --force $1
}
function restart_interface
{
stop_interface $1
start_interface $1
}
function turn_off_radio
{
echo "turning off broadcom wireless card"
echo "0" > /proc/fsaa1655g/radio
}
function turn_on_radio
{
echo "turning on broadcom wireless card"
echo "1" > /proc/fsaa1655g/radio
}
function load_module
{
if [ $# -eq 1 ]
then
module=$1
if ! lsmod|grep $module
then
echo "loading module $module"
modprobe $module
else
echo "module $module is already loaded"
fi
else
echo "Usage is: load_module <module name>"
fi
}
function load_necessary_modules
{
#this module turns on and off the wireless hardware
load_module fsaa1655g
}
#---- main ---------------
load_necessary_modules
sleep 1
if grep 0 /proc/fsaa1655g/radio
then
# Wireless is closed. Open it and stop wired
turn_on_radio
stop_interface $ethernet_interface
start_interface $wireless_interface
xmessage -center "Wireless started"
else
# Wireless is open. Close it and start wired
turn_off_radio
stop_interface $wireless_interface
start_interface $ethernet_interface
xmessage -center "Wireless stopped"
fi
Links I found useful :
http://www.tuxmagazine.com/node/1000167
http://www.linuxant.com/driverloader/drivers.php
http://www-net.cs.umass.edu/uprm/uprm_wireless-tools.ppt