| Running the app_server [message #15469] |
Sat, 30 May 2009 23:34  |
Eclipse User |
|
|
|
I am trying to get the app server running on a Windows Xp box. I am using
the method MarkDB has shown. All components are on one box but I am
running it as a remote server.
The xml file has the port as 5432 but the pg_log says 4120 and says the
target machine actively refuses connection.
The xml connection file is:
<DbConnection>
<DatabaseInfo id="postgresqlInfo">
<DatabaseHome key="#DBHOME#"/>
<DatabaseName key="#DBNAME#" value="OSEE" />
<DatabaseType key="#TYPE#" value="postgresql" />
<Prefix key="#PREFIX#" value="jdbc:postgresql" />
<UserName key="#USERNAME#" value="osee" />
<Password key="#PASSWORD#" value="osee" />
<Host key="#HOST#" value="@AvailableDbServices.hostAddress" />
<Port key="#PORT#" value="@AvailableDbServices.port" />
</DatabaseInfo>
<ConnectionDescription id="postgresql" >
<Driver>org.postgresql.Driver</Driver>
<Url>#PREFIX#://#HOST#:#PORT#/#DBHOME##DBNAME#</Url>
</ConnectionDescription>
<AvailableDbServices>
<Server id="OSEE" dbInfo="postgresqlInfo"
hostAddress="127.0.0.1" port="5432"
connectsWith="postgresql" isProduction="false" />
</AvailableDbServices>
</DbConnection>
The pg_log file is:
LOG: connection received: host=127.0.0.1 port=4120
LOG: connection authorized: user=osee database=OSEE
ERROR: relation "osee_join_artifact" does not exist
STATEMENT: DELETE FROM osee_join_artifact WHERE insert_time < $1
LOG: could not receive data from client: No connection could be made
because the target machine actively refused it.
LOG: unexpected EOF on client connection
LOG: disconnection: session time: 0:15:17.069 user=osee database=OSEE
host=127.0.0.1 port=4120
The reported port number changes each time script is run.
Any suggestions on how to proceed?
Ray
|
|
|
|
| Re: Running the app_server [message #15566 is a reply to message #15534] |
Mon, 01 June 2009 16:58  |
| Eclipse User |
|
|
|
Mark,
I belive I have the local IP covered. The existing configuration is
below.
The pg_hba.conf file includes the following lines:
host all all 127.0.0.1/32 trust
host all all xx.xx.xx.x/32 trust (my IP address)
host all all Mycomp trust (my computer's name on the
network)
The postgresql.conf file has:
listen_address = '*'
The Windows host file has:
127.0.0.1 localhost
127.0.0.1 Mycomp
Any idea what else I might look at?
I have been trying this on three different machines. On the one I am on
right now, I can not find the Eclipse OSEE log file. On my other
machines, it shows up in osee/app_svr/configuration/xx.log. Any idea how
I can locate/force the log?
Ray
|
|
|
| Re: Running the app_server [message #574012 is a reply to message #15469] |
Mon, 01 June 2009 14:49 |
| Eclipse User |
|
|
|
Hi Ray,
I'm looking at this from home at the moment, so don't have access to my
notes. I think I got something similar to this if I didn't add 127.0.0.1
to the list of permitted machines in PGAdmin. There's a file with a name
which I've forgotten which determines the list of machines that can
connect. By default, it only allows the local machine to connect and the
remote clients are treated as external even if running on the same
machine. Click on the OSEE database in PGAdmin and then go to the tools
menu. There is an option on there to edit the access control file and you
need to open up 127.0.0.1.
This may be a red herring as it was a month or so ago that I had the
similar problem.
|
|
|
| Re: Running the app_server [message #574037 is a reply to message #15534] |
Mon, 01 June 2009 16:58 |
| Eclipse User |
|
|
|
Mark,
I belive I have the local IP covered. The existing configuration is
below.
The pg_hba.conf file includes the following lines:
host all all 127.0.0.1/32 trust
host all all xx.xx.xx.x/32 trust (my IP address)
host all all Mycomp trust (my computer's name on the
network)
The postgresql.conf file has:
listen_address = '*'
The Windows host file has:
127.0.0.1 localhost
127.0.0.1 Mycomp
Any idea what else I might look at?
I have been trying this on three different machines. On the one I am on
right now, I can not find the Eclipse OSEE log file. On my other
machines, it shows up in osee/app_svr/configuration/xx.log. Any idea how
I can locate/force the log?
Ray
|
|
|
Powered by
FUDForum. Page generated in 0.10087 seconds
Home