Re: DBD::Informix -- Error Installing On Mac OSX

InDeep wrote:
Jonathan Leffler wrote:

It would be good to see DBD::Informix set up with the following defaults or
a prompt or at least some doc to tell you to do this before running cpan:
DBD::Informix will not prompt for anything while I'm its guardian.

I hate the modules that prompt for things - they are a complete
nuisance. I don't mind modules being verbose; that's OK. I don't
mind things failing because I've not read the documentation and set
the environment correctly, as long as the module reasonably clearly
diagnoses the issue. I believe the DBD::Informix is reasonably clear
about needing to read the README file -- let me know if you disagree.


As smart as you are, at the level that you are, I am surprised at your
arrogance and petulance. The user should be considered your goal, not
how maligned you feel and how annoyed you are about the user actually
having to actually use your program. How dare they attempt to even
come to your alter. Kneel before me and beg for your life user! What
say ye! Speak or die!
As arrogant as you are I'm surprised at your crass stupidity -
if you don't like the tools provided, for FREE, for you - then write your own.

(I take it as read that if I try something from CPAN and it fails to
install but does tell me to read the README file, there are some
complex pre-requisites that I need to know about.)


Your assumption is weak, arrogant, out of touch with the user,
and, to boot, narrow-minded. Good programmers rise to the occasion and
perfect their programs, not castigate the user for not reading the
instructions. Geez how lame Jonathan, how lame can you get.


Your assumption that anyone gives a flying f**k about you opinions is lame.
Before running /usr/local/bin/perl -MCPAN -e 'install Bundle::DBD::Informix'
set your environment to something like this:
Yes, you need a working Informix environment, including a stores
database that you can both connect to and use with DBA (minimum,
RESOURCE) privileges without supplying user name or password, or you
need to set the environment variables to use it. This is part of the
README that you are emphatically encouraged to read when anything goes
wrong.

Even Mac users are expected to read the README. Sorry, but if you
don't know what the pre-requisites are, you are on a hiding to
nothing.

DBD::Informix does its best to deal with you. You have to take a
minimal step in the right direction.

export INFORMIXSERVER=demo_on
export INFORMIXDIR="/Applications/IBM/informix"
export ONCONFIG=onconfig.demo_on
export INFORMIXSQLHOSTS="/Applications/IBM/informix/etc/sqlhosts.demo_on"
export PATH=${INFORMIXDIR}/bin:${PATH}
export INFORMIXTERM=terminfo
export TERMCAP=/opt/informix/etc/termcap
export DYLD_LIBRARY_PATH=$INFORMIXDIR/lib/esql/:$INFORMIXDIR/lib/
DBD::Informix does not need ONCONFIG, INFORMIXTERM or TERMCAP set.
INFORMIXSQLHOSTS is only needed if you aren't using the standard
location ($INFORMIXDIR/etc/sqlhosts) -- that's the same everywhere.
INFORMIXDIR is only needed if you aren't using the standard location
-- that too is the same on Unix machines (/usr/informix).
INFORMIXSERVER is mandatory - period.


Thanks for that, I know the basics. But it's ok to provide hints and
directions. I think you're pretty lazy not to provide some kind of
usage instructions right in the installation,

Do you know the basics? I see no evidence.
DYLD_LIBRARY_PATH is the analog of SHLIB_PATH or LD_LIBRARY_PATH or
LIBPATH or ... and does need to be set. Again, there is nothing
unusual in this. If you can't compile and run ESQL/C programs with
the environment you have set, you are not going to be able to compile
the Perl module, which is, when all is said and done, an ESQL/C
program.


You should be able to set the $ENV['whatever'} variable in a typical
program without having to source in an additional shell environment
variable. I want to run programs that are portable and self-contained,
without requiring the user to 'dot in' an environment variable from an
additional shell file. This ain't rocket surgery.


Then fix it smart arse
I suppose it might be possible to detect that the variable isn't set,
but there are circumstances under which it does not have to be set
(appropriate settings in /etc/ld.so.conf on Linux, for example). So,
it is better, from my perspective, to require that people have a
working Informix environment than to test for things that might not be
needed. If you want more diagnostics after a failure to test, then
provide a patch. Do not provide a patch that is interactive; I will
not accept it.

DBD install variables:

export DBI_DBNAME=sysmaster
I've only ever used that as a last resort - if none of the more
specific DBD_INFORMIX_* environment variables are set.

export DBD_INFORMIX_DATABASE=sysmaster
export DBD_INFORMIX_USERNAME=informix
export DBD_INFORMIX_PASSWORD=informix
There is no way on earth that I am ever going to encourage anyone to
use either the sysmaster database or the informix user to install
DBD::Informix.

Absolutely none.

If anything, I would add a proscription from attempting it -- or any
sys* database.


That's pretty gay. The Developer Edition download creates the sysmaster
database by fiat, any other database is optional. After I install IDS
I go and install DBD::Informix, I haven't created any other databases
yet.

Sorry - I thought you said you know the basics - you need a database so create one.
Maybe you don't know that there is no stores database after the IDS
installation?

And maybe JL does.
Your install program should go for the least common denominator,
and like I said have a prompt for database, user, and password. Sheesh.


Or how about a prompt? 8o/
No.

This way it work better since there is no stores database
installed with the IDS Developers' Edition.
It doesn't have to be a stores database -- you get to select the database.

If you read the README file.


WEAK. YOU'RE FIRED. Stop by HR and pick up your check.

And you are on your own now pal.

--
Clive
.

Relevant Pages

  • Re: DBD::Informix -- Error Installing On Mac OSX
    ... the environment correctly, as long as the module reasonably clearly ... working Informix environment than to test for things that might not be ... use either the sysmaster database or the informix user to install ...
    (comp.databases.informix)
  • Re: DBD::Informix -- Error Installing On Mac OSX
    ... And don't install it in the system locations. ... Has anyone successfully built a 64 bit perl on OSX? ... the environment correctly, as long as the module reasonably clearly ... Yes, you need a working Informix environment, including a stores ...
    (comp.databases.informix)
  • Re: DBSpace Use by Database
    ... Yesterday I just happened to install Informix on Ubuntu x86_64. ... failed looking for the stores database. ... If you want it be by dbspace either save the results into a temp table and select grouped by dbspace or use this query as a derived table. ...
    (comp.databases.informix)
  • Re: Deleting from multiple tables
    ... database. ... The underlying issue is one that *all* developers of database centric ... The solution that I proposed is based on a Java / JUnit environment, ... Why is this important for Informix? ...
    (comp.databases.informix)
  • Install MS Office in clustered environment
    ... How can I install the MS Office in a clustered ... We have got 2 clustered servers with ... database on a RAID drive. ...
    (microsoft.public.windows.server.clustering)