Login | Register
My pages Projects Community openCollabNet

Discussions > users > Beginning 'howto' for Debian Sarge

openpsa
Discussion topic

Back to topic list

Beginning 'howto' for Debian Sarge

Author Shane Lazarus <lazarus at techinfo dot co dot nz>
Full name Shane Lazarus <lazarus at techinfo dot co dot nz>
Date 2005-06-13 23:25:29 PDT
Message Hi All

Please assist.


I'm an end user wishing to evaluate OpenPSA for my clients.
Can log in to the online demo, but that does not help me understand
configuration and installation.

Have documented basic 'howto' below as a start for building the
underlying server requirement for OpenPSA prior to configuration of
OpenPSA.

Document does not assume a production environment.
Instead assumes someone else like myself keen to understand the basic
installation procedures.

Have used basic building blocks of Debian Sarge, Apache2, MySQL4.1, PHP4
to evaluate.


This Document:
This document is a work in progress.
This document is intended to be used as a teaching method for myself.

I'm hoping that some input from the list will allow me to finish this
document.




OpenPSA/Midgard Install:
Using;
Linux Debian Sarge (3.1r0a)
Apache 2 2.0.54-4
MySQL 4.1 4.1.11a-4
PHP 4 4.3.10-1
Midgard 1.3.6
OpenPSA 1.12.1



Broken Things:

Linux Debian
Note that while the install process asks you to remove the install CDRom
before rebooting during installation, you will need it in the drive
after the reboot to complete the installation.

MySQL
Debian MySQL Maintainer has created separate Package for MySQL 4.1
compared to MySQL 4.0
This results in Apt Dependencies not considering MySQL 4.1 as a
substitute/upgrade for MySQL 4.0
An acceptable alternative is for the Midgard Maintainer to alter the
Midgard dependencies to either package.

Midgard
Midgard has not caught up to Debian yet.
As a result, the 1.6.3-1 Debs are still under 'testing' rather than
'stable'.
Of course, this might not be an error as;
Midgard wants to use '/usr/lib/php4/20020​429/midgard.so', but actually
installs 'midgard.so' in '/usr/lib/php4/20020​429-zts/midgard.so',​
leaving '/usr/lib/php4/20020429/' empty.
Midgard package 'midgard-data' requires dependency fix/testing to
support MySQL 4.1
Midgard still wants to use MySQL 4.0, when 4.1 is available in Stable.
'php_flag register_globals' gets reset to Off after some iterations of
Datagard.

The default Aegir screen has very bad formatting problems.
This results in not being able to read and use the 'messagebox'
containing 'Please Select Details and change the administrators
password'.
(Firefox and Internet Explorer, so probably not a browser issue...)
This assumes you didn't just get hit by a screen full of PHP-Script
errors.

OpenPSA
The online documentation needs to be updated to reflect that the
installation procedure no longer functions as written on the relevant
page of the web site.
Having some idea of what the successful conclusion of installing OpenPSA
via Datagard looks like would help immensely in determining if what I
see is what I should be seeing.



Installing:

Useful Debian Apt commands:
'apt-cache search <string>' to find what the package might be called.
'apt-cache show <package>' to get a description of the package and learn
it's dependencies.
'apt-cache depends <package>' to gather more information about what else
might be installed.
'apt-get install -d <package>' to know for sure without accidentally
installing/removing anything.
    (although this last might download the relevant files if you hit
<enter> by accident, so)
'apt-get install -s <package>' to dummy run the install without
modifying or downloading anything.

(Refer 'http://www.debian.or​g/doc/manuals/apt-ho​wto/index.en.html' to
learn more.)

The instructions below assume you are installing Debian for the first
time for this purpose.
The use of the '/home/apt' directory structure is included for two
reasons.
First, you might want to reuse some of the debs when reinstalling
individual applications.
Second, you might want to use all of the debs when reinstalling from
scratch.
    (The second assumes a CD writer somewhere on your network.)



Install Linux;
Used 'debian-31r0a-i386-netinst.iso' and installed base system only.
(Add any other utilities you might want.)
Run 'apt-get install -d ssh bzip2'
Copy the cached install .debs from '/var/cache/apt/archives/' to
'/home/apt/.'
Run 'apt-get install ssh bzip2'
Run 'apt-get clean' to clear the cached install .debs from
'/var/cache/apt/archives/'



Install Apache2;
Run 'apt-get install -d apache2'
Copy the cached install .debs from '/var/cache/apt/archives/' to
'/home/apt/apache2/.'
Run 'apt-get install apache2'
Run 'apt-get clean' to clear the cached install .debs from
'/var/cache/apt/archives/'



Install MySQL;
Run 'apt-get install -d mysql-server-4.1'
Copy the cached install .debs from '/var/cache/apt/archives/' to
'/home/apt/mysql41/.'
Run 'apt-get install mysql-server-4.1'
Run 'apt-get clean' to clear the cached install .debs from
'/var/cache/apt/archives/'
The following MySQL Database Users are created by default:
    'root'@'localhost' {No Password}
    'root'@'%SHORT HOSTNAME%' {No Password}
    'debian-sys-maint'@'localhost' {No Password}

Do not change these or create any other users at this point.
Do not create, delete or alter any tables at this point.



Install PHP4;
Run 'apt-get install -d php4 php4-pear php4-cgi php4-gd'
Copy the cached install .debs from '/var/cache/apt/archives/' to
'/home/apt/php4/.'
Run 'apt-get install php4 php4-pear php4-cgi php4-gd'
Run 'apt-get clean' to clear the cached install .debs from
'/var/cache/apt/archives/'


Run 'pear install HTML_Common'
Run 'pear install HTML_QuickForm'
Run 'pear install HTML_TreeMenu'
Run 'pear install Mail'
Run 'pear install Mail_Mime'
Run 'pear install PHP_Compat'



Install Other Dependencies;
Run 'apt-get install -d imagemagick'
Copy the cached install .debs from '/var/cache/apt/archives/' to
'/home/apt/other/.'
Run 'apt-get install imagemagick'
Run 'apt-get clean' to clear the cached install .debs from
'/var/cache/apt/archives/'

Run 'apt-get install -d rcs'
Copy the cached install .debs from '/var/cache/apt/archives/' to
'/home/apt/other/.'
Run 'apt-get install rcs'
Run 'apt-get clean' to clear the cached install .debs from
'/var/cache/apt/archives/'




Install Midgard;
Add the following to '/etc/apt/sources.list'

deb http://www.midgard-p​roject.org/debian/di​sts/testing/main/bin​ary-i386
./

Run 'apt-get update'
Run 'apt-get install -d libapache2-mod-php4-midgard'
Run 'apt-get install -d dialog'
Run 'apt-get install -d repligard'



Copy the cached install .debs from '/var/cache/apt/archives/' to
'/home/apt/midgard163/.'
Run 'apt-get install libapache2-mod-php4-midgard'
Run 'apt-get install dialog'
Run 'apt-get install repligard'

At this point, the only package left to install is midgard-data. **See
Broken Things**

Run 'apt-get install -d midgard-data'
Copy the cached install .debs from '/var/cache/apt/archives/' to
'/home/apt/midgard163/.'


Your options are as follows:

Unpack the .deb file, alter the dependencies, repack the .deb file.

Force the install, but leave Apt claiming the package is broken.
'dpkg -i --force-depends
/home/apt/midgard136​/midgard-data_1.6.3_​i386.deb'

(I forced the install.)

Run 'apt-get clean' to clear the cached install .debs from
'/var/cache/apt/archives/'


You should now have installed all the packages required to run Midgard.

Run 'datagard'

Leave the hostname selection field empty to use localhost.
Choose 'Install New Database'
Name the Database 'midgard'
Name the Database User 'admin'
Set the Database User Password 'password'
Confirm creation of a virtual host
Choose a database, make sure you are using the 'midgard' database rather
than the 'test' database.
User name for database 'midgard' is 'admin'
Password for user name 'admin' is 'password'
Use a Fully Qualified Domain Name (FQDN) as the virtual site name, along
the lines of
    HOST.DOMAIN.TLD:8001
Make sure you add the '8001' port number.
The install finishes.

Run 'ln -s /usr/lib/php4/200204​29-zts/midgard.so
/usr/lib/php4/200204​29/midgard.so' **See Broken Things**
Edit '/etc/php4/apache/php.ini' and alter 'php_flag register_globals'
from 'Off' to 'On' **See Broken Things**

Run '/etc/init.d/apache2 restart'

Browse to 'http://HOST.DOMAIN.T​LD:8001/midgard' to verify success.

Click on the Aegir 'administrative interface' link to get the login
screen for Aegir.
Log in using 'admin' for user name, and 'password' for the password.
If you get several bad scripting errors scrolling up the screen, wander
off into 'http://HOST.DOMAIN.T​LD:8001/spider-admin​' for a while and
then go back to Aegir.
Now you should have the bad formatting issues. **See Broken Things**



Install OpenPSA;
Download the OpenPSA XML Template from
'http://www.openpsa.o​rg/download'
Unpack 'openpsa-1.12.1.tar.bz2' to '/home/apt/.'
Copy '/home/apt/openpsa-1​.12.1/openpsa.xml.gz​' to
'/usr/share/midgard/data/.'

Run 'datagard'
Leave the hostname selection field empty to use localhost.
Choose 'import selected application'
Select the 'midgard' database
User name for 'midgard' database is 'admin'
Password for user 'admin' is 'password'
Scroll down and select openpsa
Sitegroups admin user name is 'admin'
Sitegroups admin user 'admin' has a password of 'password'
The Datagard application returns a command line with no visible error
messages. **See Broken Things**
Edit '/etc/php4/apache/php.ini' and alter 'php_flag register_globals'
from 'Off' to 'On' **See Broken Things**


None of 'http://HOST.DOMAIN.T​LD:8001/openpsa_mana​ger' ,
'http://localhost/ope​npsa_manager' or
'http://localhost:810​0/openpsa_manager' are available.



Conclusion:
Insufficient documentation on the OpenPSA site lead to the creation of
this document.




Shane Lazarus
Technology Liaison

+64 21 529278

shane at techinfo dot co dot nz
Attachments

« Previous message in topic | 1 of 1 | Next message in topic »

Messages

Show all messages in topic

Beginning 'howto' for Debian Sarge Shane Lazarus <lazarus at techinfo dot co dot nz> Shane Lazarus <lazarus at techinfo dot co dot nz> 2005-06-13 23:25:29 PDT
Messages per page: