Thread: Re: Re: ongoing holy grail thread - VICTORY!!!

On 12 Apr 2001 22:40:56 +1000, Justin Clift wrote:

> When we installed Tomcat and PostgreSQL, I just copied the
> postgresql.jar file into the /lib directory inside the tomcat
> installation directory...

Justin wins the case of champagne (virtual for the time being)

The secret is there - where the jdbc .jar file goes.

> By default, no-one on your network has permission to touch your
> PostgreSQL database.  If you've opened it up by specifying something
> like :
>
> host all <network IP address> <netmask> trust
>
> then your users should be able to connect with a username of
'postgres'
> from what I remember (if that's the PostgreSQL superuser on your
server
> that is).

Does not work, must be "host db_name IP user ident"

Maybe this has something to do with java security???

> >     - Ultradev is running on NT and connecting via "LAN" thus is
using
> >     SMB and not TCP/IP is this an issue?

Had to connect via ftp (thus tcp/ip) to get it to work. Had to set up
ftp just right because Ultradev wants to write over the connection files
as it uses them.

Please bear with me on this one people: I'll try to write up a sort of
HOWTO to document for this. But it has taken me a week full time so far
and I have to get back to looking after my clients.

For now the secret was a clean install of _everything_ on a developpment
server. Everything meaning RedHat 7.0 on down to the Apache module...

I think that we should maybe get this info out to Macromedia to
supplement the MySQL stuff that is already in Ultradev.

Cheers

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html

Hi Tony,

That's great to hear.  :-)

You need a saying like "'twas a long hard battle, but in the end we
emerged victorious" about now.  Heh Heh Heh

Tony Grant wrote:

> Does not work, must be "host db_name IP user ident"
>
> Maybe this has something to do with java security???

Dunno.  Errr... could be.

> Please bear with me on this one people: I'll try to write up a sort of
> HOWTO to document for this. But it has taken me a week full time so far
> and I have to get back to looking after my clients.

Weekend is afoot too.  Relax, have fun.  :-)


> For now the secret was a clean install of _everything_ on a developpment
> server. Everything meaning RedHat 7.0 on down to the Apache module...
>
> I think that we should maybe get this info out to Macromedia to
> supplement the MySQL stuff that is already in Ultradev.

I agree.  If you can get the info to the rest of us too, we can make it
available for people cruising part the mailing list archives, techdocs
website, etc.

From memory Macromedia has their Macromedia Exchange area where people
can share and contribe extensions for Dreamweaver, Ultradev, etc.  They
also have a newsletter.

Wonder how you would get a mention that PostgreSQL works with it in
their monthly newsletter?  Probably be quite a few people interested in
hearing that.

Regards and best wishes,

Justin Clift


> Cheers
>
> Tony Grant
>
> --
> RedHat Linux on Sony Vaio C1XD/S
> http://www.animaproductions.com/linux2.html
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
     - Indira Gandhi