Home
Reading
Searching
Subscribe
Sponsors
Statistics
Posting
Contact
Spam
Lists
Links
About
Hosting
Filtering
Features Download
Marketing
Archives
FAQ
Blog
 
Gmane
From: Chris Bennett <chris-86bi167hAaZd27BlJj9ntjupjusI36kg <at> public.gmane.org>
Subject: OpenBSD and 1.3
Newsgroups: gmane.comp.finance.ledger.smb.devel
Date: Wednesday 28th December 2011 19:57:32 UTC (over 5 years ago)
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 <&1 |
unchatter
+cat <&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


------------------------------------------------------------------------------
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
infrastructure or vast IT resources to deliver seamless, secure access to
virtual desktops. With this all-in-one solution, easily deploy virtual 
desktops for less than the cost of PCs and save 60% on VDI infrastructure 
costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
 
CD: 3ms