How to post a blog entry via e-mail?
Strange Postgres / Tomcat log on error.
Hello Guest
  
  • Login
• Register…
• Start blog
  • Who, Where, When
• What can I do?
• What to Read?
  • Polls
• Avatars
• Interests
  • Cities and Countries
• Random blog
• Users search
  • Search
• Games
• Tests
• QAIX
  • Сообщества
• Talxy Chat
• Horoscope
• Online
 
Зарегистрируйся!

QAIX > PostgreSQL database development > Strange Postgres / Tomcat log on error. 28 April 2006 20:21:33

  Recent blog posts: 
  They have birthday today: 
  Forums:   
  Discuss: 
  Recent forum topics: 
  Recent forum comments:
  Moderators:

Strange Postgres / Tomcat log on error.

Jason Porter 28 April 2006 20:21:33
 Here's my situation: I've installed Postgres 8.1.3 and tomcat 5.5.16
and all the dependencies, I'm on a Win 2k3 box. I can connect using the
postgres Admin program just find and there are no problems. I can run
my web app on a different box and everything connects just fine.
However, when I run the web app on the same box that contains the
database I get a connection refused error.

Here's my context.xml:
<?xml version="1.0" encoding="UTF-8"?>
<Context crossContext="true"­ debug="1" docBase="NeuView" path="/Neuview"
reloadable="true">
<Resource auth="Container" driverClassName="or­g.postgresql.Driver"­
maxActive="20" maxIdle="10" maxWait="-1" name="jdbc/postgres­"
password="..." type="javax.sql.Dat­aSource"
url="jdbc:p­ostgresq­l://192.168.27.40:54­32/neuview" username="..."/>
</Context>

I've tried using 127.0.0.1, localhost and the actual IP (above) in the
url, but that doesn't seem to help. I've also tried different users and
passwords, still no go.

Here's the postgres.conf file (relating to tcp/ip):
listen_addresses = '*'# what IP address(es) to listen on;
# comma-separated list of
addresses;
# defaults to 'localhost', '*' =
all
port = 5432
...

authentication_time­out = 60# 1-600, in seconds
ssl = off
password_encryption­ = on
...

tcp_keepalives_idle­ = 0# TCP_KEEPIDLE, in seconds;
# 0 selects the system default
tcp_keepalives_inte­rval = 0# TCP_KEEPINTVL, in seconds;
# 0 selects the system default
tcp_keepalives_coun­t = 0# TCP_KEEPCNT;
# 0 selects the system default

Here's the pg_hba.conf as well:

# TYPE DATABASE USER CIDR-ADDRESS METHOD
hostall all0.0.0.0/0md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
#host all all ::1/128 md5

This problem really baffles me, and is getting a little frustrating.
Any one have any ideas?

-Jason Porter


-------------------­--------(end of broadcast)---------­------------------
TIP 6: explain analyze is your friend

Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.


QAIX > PostgreSQL database development > Strange Postgres / Tomcat log on error. 28 April 2006 20:21:33

see also:
JBoss 3.0 directory structure
Where to store parameter names/values?
JBoss 3.0.0 - CMR and composite primary…
пройди тесты:
see also:
About
Hello
So....I am good girl

  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .