OpenBSD and 1.3

[Chris Bennett <..hidden..>]

Overall, I find 1.3 installs very nicely, with the problems I note below
I found no problem using OpenBSD's version of Apache Apache/1.3.29.
This version is highly customized, so I don't know if regular Apache 1.3x
would also work.
Except for the few fixable problems I had, I think this installs easier than 1.2

I actually did a lot of work a while back to get the missing perl modules
into the ports tree, but it was too close to ports lock for the next release.
Then I had to have shoulder surgery which successful but not fun.
I am going to try again to get these modules official soon.
Most of these modules are optional, Config::Std and Locale::Maketext::Lexicon need to be added
and/or updated.
Template::Plugin::LaTeX is not in ports and seems pretty necessary to me.
Working ports are at the website noted below.
There ARE ISSUES with using the version of Locale::Maketext::Lexicon offered up on CPAN.
Version 0.79 is the last version which is compatible with OpenBSD base perl!


I could not get setup.pl to work.
It could recognize an existing database, but not create one.

I like to use command line stuff more than GUI stuff for setup, anyway.

prepare-company-database.sh asked me many times for ledgersmb password. Ugh.

I decided it was easier to install from command line after I set up a .pgpass
file with both postgres and new ledgersmb users.
This will eliminate needing to enter passwords multiple times.
This file can be kept, edited or discarded after installation.
This file must have mode 0600.

localhost:*:*:postgres:POSTGRESPASS
localhost:*:*:ledgersmb:LEDGERSMBINITIAL

########################################################
I had 3 problems with prepare-company-database.sh

-if ! options=$( getopt -u -l company:,coa:,gifi:,srcdir:,dstdir:,password:,host:,port:,help,progress,pgsql-contrib: '' "$@" )
+if ! options=$( getopt company:,coa:,gifi:,srcdir:,dstdir:,password:,host:,port:,help,progress,pgsql-contrib: '' "$@" )

For OpenBSD, bash has to be added. sh/ksh is standard.
This fails in sh and bash for me.
If we drop the -u -l, will that work OK for others?



-cat <<EOF | su -c "psql -U postgres -d postgres "  postgres 2>&1 | unchatter
+cat <<EOF | psql -U postgres -d postgres 2>&1 | unchatter

I even tried changing this to OpenBSD's user _postgresql and reordering it, but I couldn't get this to work with su -c
It works fine for me like second one.
Is there any need for su -c for others to use psql?



 ERROR:  language \"plpgsql\" already exists|\
 [[:space:]0-9-]*$|\
 \([0-9[:space:]]+rows?\)\
-)/d" -
+)/d"
 }

In unclutter, dropping the dash at the end lets it work with OpenBSD's sed which is different than GNU sed.
Why is there a dash there?
With the dash, it would be necessary to use gsed instead of sed.

I also added to INSTALL for OpenBSD.

#################################################

--- INSTALL     Fri Dec 23 09:57:25 2011
+++ INSTALL-NEW Sat Dec 24 18:43:51 2011
@@ -56,6 +56,12 @@

  $ yum install postgresql postgresql-server postgresql-contrib

+On OpenBSD systems use:
+
+# pkg_add -i postgresql-server
+Follow instructions in /usr/local/share/doc/pkg-readmes/postgresql-server.X.X
+to set up an initial database.
+
 On other systems, the steps to follow may differ.  Please submit
 instructions for your system for inclusion here.

@@ -212,6 +218,35 @@
 as well through the command:

  $ aptitude install libxml-twig-perl
+
+>>> Perl module dependencies for OpenBSD
+
+# pkg_add -i p5-DBI p5-DBD-Pg p5-MIME-Lite p5-Class-Std p5-HTML-Tagset \
+ p5-Data-Dump p5-Test-Tester p5-HTML-Parser p5-Test-Trap p5-CGI-Simple \
+ p5-File-MimeInfo p5-DateTime p5-Log-Log4perl texlive_base
+
+# pkg_add -i  p5-Config-Std Use CPAN if unavailable, this is required
+
+# pkg_add -i p5-Locale-Maketext-Lexicon Must be 0.62 - 0.79
+DO NOT install a version of Locale::Maketext::Lexicon greater than 0.79,
+Later versions are not compatible with Locale::Maketext used in base perl!
+
+# pkg_add -i  p5-Template-Plugin-Latex Use CPAN if unavailable, this is
+required for PDF and Postscript output.
+
+Optional Items:
+p5-LaTeX-Driver
+p5-LaTeX-Encode
+p5-LaTeX-Table
+p5-MooseX-FollowPBP
+p5-MooseX-Param
+p5-Excel-Template
+p5-Excel-Template-Plus
+p5-Net_TCLink
+
+I have provided ports at http://64.85.161.47:8081/ports/index.html for building the missing
+packages. This is a preferred method to using CPAN directly, since packages
+can be deleted and upgraded.


 Initializing a company database

#################################################
Thanks,
Chris Bennett