In running BIRT at the client end I'm assuming your running it on a
different machine than DSpace? It actually has little to do with
DSpace and is focused on how your exposing your postgres cluster port
for remote access.
If so you have two options...
1.) Configure Postgres to be exposed over a specific port on the
server side. This can be found in the Postgres documentation on their
site.
2.) ssh tunnel a local port on your machine to forward the 5432
Postgres port on you server and then point your BIRT client at that.
I've done both in the past... the issue is security and assuring your
only read accessing your production system. In such a case as wanting
to not be exposing the production system in such a way I highly
recommend dumping a backup of your production postgres DB and running
a copy locally on your machine to work on, not that I'm too worried
about BIRT, I just don't like to touch or put load on production
resources when doing development.
Kudos on experimenting with using BIRT, I've played with it in the
past against DSpace and thought it a tool possibilities if put in the
right hands.
Cheers,
Mark
On Oct 26, 2008, at 8:30 PM, Steve Thomas wrote:
Hi.
Can anyone enlighten me as to how I configure postgresql to allow
access to a BIRT client? (BIRT is an SQL reporting tool.) And also
how to config BIRT at the client end?
Cheers!
Steve
--
Stephen Thomas,
Senior Systems Analyst,
University of Adelaide Library
UNIVERSITY OF ADELAIDE SA 5005 AUSTRALIA
Phone: +61 8 830 35190
Fax: +61 8 830 34369
Email: [EMAIL PROTECTED]
URL: http://www.adelaide.edu.au/directory/stephen.thomas
CRICOS Provider Number 00123M
P please consider the environment before printing.
This email message is intended only for the addressee(s) and
contains information that may be confidential and/or copyright. If
you are not the intended recipient please notify the sender by reply
email and immediately delete this email. Use, disclosure or
reproduction of this email by anyone other than the intended
recipient(s) is strictly prohibited. No representation is made that
this email or any attachments are free of viruses. Virus scanning is
recommended and is the responsibility of the recipient.
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge
Build the coolest Linux based applications with Moblin SDK & win
great prizes
Grand prize is a trip for two to an Open Source event anywhere in
the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
