yes

in postgresql.conf

postgresql 7.4
tcpip_socket = true

postgresql 8.X
listen_addresses = '*'

best regards

johnson

----- Original Message ----- From: "Olivier" <[EMAIL PROTECTED]>
To: <users@cocoon.apache.org>
Sent: Wednesday, February 08, 2006 3:52 AM
Subject: Re: tomcat and postgresql database integration


Is postmaster listening on socket (jdbc need it)? - cf postgresql.conf
On Mon, 2006-02-06 at 19:38 +0700, zulhisham abu nawar wrote:
hi...
now i'm trying to integrate cocoon 2.1.8 with postgressql 7.4.11 with
tomcat 5.0.28...My application can run without any errors but it not
select any data from database...Below is my application details..

file:cocoon.xconf
<datasources>

    <!--+
        | -ej
        | postgres
        +-->
    <jdbc name="mytestdb" logger="core.datasources.mytestdb">
      <pool-controller min="5" max="10"/>
      <dburl>jdbc:postgresql://127.0.0.1:5432/mytestdb</dburl>
      <user>postgres</user>
      <password/>
    </jdbc>

file:web.xml
 -->
    <init-param>
      <param-name>load-class</param-name>
      <param-value>        <!-- For parent ComponentManager sample:
        org.apache.cocoon.samples.parentcm.Configurator -->
        <!-- For IBM WebSphere:
        com.ibm.servlet.classloader.Handler -->

        <!-- For Database Driver: -->
        org.hsqldb.jdbcDriver

       org.postgresql.Driver

      </param-value>
    </init-param>


file:pg_hba.conf
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD

local   all         all                                             trust
# IPv4-style local connections:
host    all         all         127.0.0.1         255.255.255.255   trust
# IPv6-style local connections:
host    all         all         ::1
ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff        trust


any idea??

--
::)- mister ijoi

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]