pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedongoing holy grail thread
5+ messages / 3 participants
[nested] [flat]
* ongoing holy grail thread
@ 2001-04-09 13:42 Tony Grant <tony@animaproductions.com>
2001-04-09 16:58 ` Re: ongoing holy grail thread Dave Smith <dave.smith@candata.com>
2001-04-12 08:48 ` Re: ongoing holy grail thread Tony Grant <tony@animaproductions.com>
0 siblings, 2 replies; 5+ messages in thread
From: Tony Grant @ 2001-04-09 13:42 UTC (permalink / raw)
To: pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: ongoing holy grail thread
2001-04-09 13:42 ongoing holy grail thread Tony Grant <tony@animaproductions.com>
@ 2001-04-09 16:58 ` Dave Smith <dave.smith@candata.com>
2001-04-09 17:48 ` Re: ongoing holy grail thread Tony Grant <tony@animaproductions.com>
1 sibling, 1 reply; 5+ messages in thread
From: Dave Smith @ 2001-04-09 16:58 UTC (permalink / raw)
To: Tony Grant <tony@animaproductions.com>; +Cc: pgsql-general@postgresql.org
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?
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: ongoing holy grail thread
2001-04-09 13:42 ongoing holy grail thread Tony Grant <tony@animaproductions.com>
2001-04-09 16:58 ` Re: ongoing holy grail thread Dave Smith <dave.smith@candata.com>
@ 2001-04-09 17:48 ` Tony Grant <tony@animaproductions.com>
0 siblings, 0 replies; 5+ messages in thread
From: Tony Grant @ 2001-04-09 17:48 UTC (permalink / raw)
To: pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: ongoing holy grail thread
2001-04-09 13:42 ongoing holy grail thread Tony Grant <tony@animaproductions.com>
@ 2001-04-12 08:48 ` Tony Grant <tony@animaproductions.com>
2001-04-12 12:40 ` Re: [GENERAL] Re: ongoing holy grail thread Justin Clift <jclift@iprimus.com.au>
1 sibling, 1 reply; 5+ messages in thread
From: Tony Grant @ 2001-04-12 08:48 UTC (permalink / raw)
To: pgsql-general@postgresql.org
> 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [GENERAL] Re: ongoing holy grail thread
2001-04-09 13:42 ongoing holy grail thread Tony Grant <tony@animaproductions.com>
2001-04-12 08:48 ` Re: ongoing holy grail thread Tony Grant <tony@animaproductions.com>
@ 2001-04-12 12:40 ` Justin Clift <jclift@iprimus.com.au>
0 siblings, 0 replies; 5+ messages in thread
From: Justin Clift @ 2001-04-12 12:40 UTC (permalink / raw)
To: Tony Grant <tony@animaproductions.com>; pgsql-docs
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2001-04-12 12:40 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-04-09 13:42 ongoing holy grail thread Tony Grant <tony@animaproductions.com>
2001-04-09 16:58 ` Dave Smith <dave.smith@candata.com>
2001-04-09 17:48 ` Tony Grant <tony@animaproductions.com>
2001-04-12 08:48 ` Tony Grant <tony@animaproductions.com>
2001-04-12 12:40 ` Justin Clift <jclift@iprimus.com.au>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox