Yes, i tested connection by psql . I also put password for db connection into .pgpass file, so it doesn't ask password.
[sipxcha...@sip /]# psql -h postgres.local -U sipxdbuser -d SIPXCONFIG Welcome to psql 8.3.5, the PostgreSQL interactive terminal. Type: [bla-bla] SIPXCONFIG=# All databases are created by startup scripts, data is ok. I even write jdbc connection string at both files (database.xml and sipxconfig.properties.in) like this: jdbc:postgresql://postgres.local:5432/SIPXCONFIG?user=sipxdbuser&password=sipxdbpass as written in jdbc docs http://jdbc.postgresql.org/documentation/83/connect.html It doesn't work :( sipxpbx version is: sipxconfig.i386 3.11.9-014372 2008/12/24 Damian Krzeminski <[email protected]> > Oleg petol wrote: > > Hi everybody! > > > > I need to run postgres db on different host than sipxpbx run. > > I've looked over all sturtup scripts and configs and change data or add > > code for different postgres hostname, including > > /etc/sipxpbx/database/database.xml and sipxconfig.properties.in > > <http://sipxconfig.properties.in/>. > > > > sipxconfig.log: > > > > "2008-12-24 14:01:06,897": INFO:DynamicSessionFactoryBean:743:Building > > new Hibernate SessionFactory > > "2008-12-24 14:01:36,089": > > > WARN:BasicResourcePool:1841:com.mchange.v2.resourcepool.basicresourcepool$acquiret...@199f443 > > -- Acquisition Attempt Failed!!! Cle > > aring pending acquires. While trying to acquire a needed new resource, > > we failed to succeed more than the maximum number of allowed acquisition > > attempts (30) > > . Last acquisition attempt exception: > > org.postgresql.util.PSQLException: Connection refused. Check that the > > hostname and port are correct and that the postmaster is accepting > > TCP/IP connections. > > [...] > > Did you configure postgres DB on postgres.local to be accessible remotely? > Check if you can connect to it from machine on which sipXconfig is running > using psql tool. > Something like: > > psql -h postgres.local -U postgres -d SIPXCONFIG > > > _______________________________________________ > sipx-users mailing list > [email protected] > List Archive: http://list.sipfoundry.org/archive/sipx-users > Unsubscribe: http://list.sipfoundry.org/mailman/listinfo/sipx-users > -- /petol http://kab.tv/rus
_______________________________________________ sipx-users mailing list [email protected] List Archive: http://list.sipfoundry.org/archive/sipx-users Unsubscribe: http://list.sipfoundry.org/mailman/listinfo/sipx-users
