Installation checking script

[Steve D. <sd...@sw...>]

Keld J=F8rn Simonsen wrote:

> Maybe we should make a script to detect if there are any problems i=
n the
> installation, and then report ways to remedy them
>
> keld

This is a really good idea, but neither Keld nor I has much time to w=
ork on
something like this.  I hacked this script together (quickly) from th=
e
zelerate/allcommerce project (http://allcommerce.sourceforge.net/), w=
hich will
check for valid drivers and available databases.  It's based on their=
 configure.pl,
which checks for drivers/dbs, allows db port/document root to be set,=
 and can write
Apache's config for you.

Not much on remedies, but it might help you narrow down the problem. =
 Maybe
somebody else can hack zelerate's configuration script more completel=
y for
sql-ledger.

If perl isn't there it won't run.  If dbi is missing, you'll get a pa=
ckage not
available error.  If the Pg driver is not available it will tell you.=
  If Postgres
is installed and everything else is ok, you should get at least templ=
ate1 as a db
available.  If you get no database available, postgres isn't installe=
d.

save the attached script and run it from where it's located like this=
:

bash-2.03$ perl  dbi_check.pl

Drivers available - Pg

Databases Available:
dbi:Pg:dbname=3Ddemo
dbi:Pg:dbname=3Dosallcommerce
dbi:Pg:dbname=3Dsqltest
dbi:Pg:dbname=3Dtemplate1