Horton
Menu

Thread

  1. ongoing holy grail thread

    tony <tony@animaproductions.com> — 2001-04-09T13:42:53Z

    I hope that I have the correct e-mail address configured now..

--

In my quest to connect Dreamweaver Ultradev to postgresql I have changed
my application server in order to have easier access to the .conf files.
Now running Tomcat/Apache.

Ultradev connects to the application server but the JDBC connection
times out. I am running 7.0.3 and have
/usr/java/jdk1.3/jre/lib/ext/jdbc7.0-1.2.jar

TIA for any usefull tips

Cheers

Tony Grant


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

  2. Re: ongoing holy grail thread

    Dave Smith <dave.smith@candata.com> — 2001-04-09T16:58:55Z

    Tony Grant wrote:

> I hope that I have the correct e-mail address configured now..
> 
> --
> 
> In my quest to connect Dreamweaver Ultradev to postgresql I have changed
> my application server in order to have easier access to the .conf files.
> Now running Tomcat/Apache.
> 
> Ultradev connects to the application server but the JDBC connection
> times out. I am running 7.0.3 and have
> /usr/java/jdk1.3/jre/lib/ext/jdbc7.0-1.2.jar
> 
> TIA for any usefull tips
> 
> Cheers
> 
> Tony Grant

Did you start the database server with the -i option?

  3. Re: ongoing holy grail thread

    tony <tony@animaproductions.com> — 2001-04-09T17:48:13Z

    On 09 Apr 2001 12:58:55 -0400, Dave Smith wrote:

> Did you start the database server with the -i option?

Redhat scripts started the database. From vague memory there was an -i
in there.

I am now using this as an excuse to move up to 7.1RC4. So startup is on
the list of things to do. I'm tired, I've been working on this all day
so I think I'll go home soon.

I am very happy it is the first time I have managed to compile postgres
for years. With ant and java support no less!! Good word developpers!

Cheers

Tony Grant
 

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

  4. JDBC compile

    tony <tony@animaproductions.com> — 2001-04-10T16:02:39Z

    Can someone please point me to a precompiled jdbc driver for 7.1RC4 and
JDK1.3

I just don't have the patience to figure out what is going wrong here.

/usr/share/ant

Ant install made a /usr/share/java withe the jar files in it. 

Java is installed on the machine as /usr/java/jdk1.3 

    [javac] Note: Some input files use or override a deprecated API.
    [javac] Note: Recompile with -deprecation for details.
    [javac] 4 errors

is all that this gives me.

Hey guys it has to be easier than this the rest of the compile went
really well...


Cheers

Tony Grant

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

  5. Re: JDBC compile

    Homayoun Yousefi'zadeh <homayounyz@home.com> — 2001-04-10T17:01:54Z

    
Tony Grant wrote:

> Can someone please point me to a precompiled jdbc driver for 7.1RC4 and
> JDK1.3
> 
> I just don't have the patience to figure out what is going wrong here.
> 
> /usr/share/ant
> 
> Ant install made a /usr/share/java withe the jar files in it. 
> 
> Java is installed on the machine as /usr/java/jdk1.3 
> 
>     [javac] Note: Some input files use or override a deprecated API.
>     [javac] Note: Recompile with -deprecation for details.
>     [javac] 4 errors
> 
> is all that this gives me.
> 
> Hey guys it has to be easier than this the rest of the compile went
> really well...

 From what you are describing, you should have warnings
rather than errors. You may actually be OK.

You need to copy the file
postgresql.jar to JAVA_HOME/jre/lib/ext/ if it has
been created. Simply ignore the deprecation msg's
and see whether you can connect to a sample database
using the driver.

Check the content of the jar file w/ jar tvf postgresql.jar
if the driver file is there but the connection fails.

Thanks,
HY

  6. Re: ongoing holy grail thread

    tony <tony@animaproductions.com> — 2001-04-12T08:48:27Z

    > In my quest to connect Dreamweaver Ultradev to postgresql I have changed
> my application server in order to have easier access to the .conf files.
> Now running Tomcat/Apache.

Update:

    - I have managed to compile my very own JDBC!!! I don't have a clue
    what I did right this time... Maybe the fact that I rebooted the
    server has something to do with it???

    - Ultradev sees and recognizes the org.postgresql.Driver in the
    local Macromedia folder but is still refusing to connect to the one
    on the application server. Running "test" locks up the Ultradev
    application.

Todays questions:

    - what should I be looking for to see if the Tomcat application
    server is correctly loading the jdbc driver?

    - how do I know that I have all the correct permissions set in order
    to connect to the database (pg_hba.conf is set to "trust"
    "everybody" on local network.

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

I am persisting as you see here. Next week I'll have to move on to other
things because this problem must be solved.

Cheers

Tony Grant


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

  7. Re: [GENERAL] Re: ongoing holy grail thread

    Justin Clift <jclift@iprimus.com.au> — 2001-04-12T12:40:56Z

    Hi Tony,

<snip>
> Todays questions:
> 
>     - what should I be looking for to see if the Tomcat application
>     server is correctly loading the jdbc driver?

When we installed Tomcat and PostgreSQL, I just copied the
postgresql.jar file into the /lib directory inside the tomcat
installation directory.  I installed tomcat in /usr/local/tomcat from
memory, so that would make it /usr/local/tomcat/lib

When tomcat starts, it has a logfile directory.  I'm not a java guy, but
I think the tomcat only notices that the PostgreSQL driver isn't loaded
properly when someone actually tries to use it (the PostgreSQL driver
that is).  Can't remember whether it reports the error message to its
logfiles or to the application trying to use PostgreSQL though.

> 
>     - how do I know that I have all the correct permissions set in order
>     to connect to the database (pg_hba.conf is set to "trust"
>     "everybody" on local network.

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).


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

If it's connecting via SMB, then does that means it's trying to use a
socket file?  Don't know if that's gunna work (never heard of it being
tried before).  Good luck.

You'd have better luck using TCP though, as we know NT can talk to
PostgreSQL with TCP.  We do it every day.

Regards and best wishes,

Justin Clift

-- 
"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

  8. Re: [GENERAL] Re: ongoing holy grail thread - VICTORY!!!

    tony <tony@animaproductions.com> — 2001-04-13T14:19:15Z

    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