We upgraded out postgresql server from 8.1.9 to 8.2.4 and since then
have been unable to establish a connection to our trac website due to
the following error: (/var/log/httpd/trac_error.log)
<---
[Fri Jul 13 11:22:41 2007] [error] [client 216.185.71.30]
PythonHandler trac.web.modpython_frontend: File "/usr/lib/python2.3/
site-packages/trac/web/main.py", line 391, in dispatch_request\n
env = _open_environment(env_path, run_once=run_once)
[Fri Jul 13 11:22:41 2007] [error] [client 216.185.71.30]
PythonHandler trac.web.modpython_frontend: File "/usr/lib/python2.3/
site-packages/trac/web/main.py", line 58, in _open_environment\n
env_cache[env_path] = open_environment(env_path)
[Fri Jul 13 11:22:41 2007] [error] [client 216.185.71.30]
PythonHandler trac.web.modpython_frontend: File "/usr/lib/python2.3/
site-packages/trac/env.py", line 463, in open_environment\n if
env.needs_upgrade():
[Fri Jul 13 11:22:41 2007] [error] [client 216.185.71.30]
PythonHandler trac.web.modpython_frontend: File "/usr/lib/python2.3/
site-packages/trac/env.py", line 341, in needs_upgrade\n db =
self.get_db_cnx()
[Fri Jul 13 11:22:41 2007] [error] [client 216.185.71.30]
PythonHandler trac.web.modpython_frontend: File "/usr/lib/python2.3/
site-packages/trac/env.py", line 203, in get_db_cnx\n return
DatabaseManager(self).get_connection()
[Fri Jul 13 11:22:41 2007] [error] [client 216.185.71.30]
PythonHandler trac.web.modpython_frontend: File "/usr/lib/python2.3/
site-packages/trac/db/api.py", line 76, in get_connection\n return
self._cnx_pool.get_cnx(self.timeout or None)
[Fri Jul 13 11:22:41 2007] [error] [client 216.185.71.30]
PythonHandler trac.web.modpython_frontend: File "/usr/lib/python2.3/
site-packages/trac/db/pool.py", line 101, in get_cnx\n cnx =
self._connector.get_connection(**self._kwargs)
[Fri Jul 13 11:22:41 2007] [error] [client 216.185.71.30]
PythonHandler trac.web.modpython_frontend: File "/usr/lib/python2.3/
site-packages/trac/db/postgres_backend.py", line 40, in get_connection
\n return PostgreSQLConnection(path, user, password, host, port,
params)
[Fri Jul 13 11:22:41 2007] [error] [client 216.185.71.30]
PythonHandler trac.web.modpython_frontend: File "/usr/lib/python2.3/
site-packages/trac/db/postgres_backend.py", line 112, in __init__\n
cnx = psycopg.connect(' '.join(dsn))
[Fri Jul 13 11:22:41 2007] [error] [client 216.185.71.30]
PythonHandler trac.web.modpython_frontend: OperationalError: could not
connect to server: Connection refused\n\tIs the server running on host
"216.185.71.25" and accepting\n\tTCP/IP connections on port 5432?\n
-->
Checking the pg_log/logfile we see this repeated numerous times:
<---
<[unknown] 2007-07-13 11:24:36 EDT [unknown] > LOG: connection
received: host=[local]
<trac_db 2007-07-13 11:24:36 EDT postgres [local]> LOG: connection
authorized: user=postgres database=trac_db
<trac_db 2007-07-13 11:24:36 EDT postgres [local]> LOG: duration:
0.202 ms
<trac_db 2007-07-13 11:24:36 EDT postgres [local]> LOG: duration:
4.965 ms
<trac_db 2007-07-13 11:24:36 EDT postgres [local]> LOG: duration:
0.110 ms
<trac_db 2007-07-13 11:24:36 EDT postgres [local]> LOG:
disconnection: session time: 0:00:00.012 user=postgres
database=trac_db host=[local]
...
<[unknown] 2007-07-13 11:24:36 EDT [unknown] > LOG: connection
received: host=[local]
<trac_db 2007-07-13 11:24:36 EDT postgres [local]> LOG: connection
authorized: user=postgres database=trac_db
<trac_db 2007-07-13 11:24:36 EDT postgres [local]> LOG: duration:
0.202 ms
<trac_db 2007-07-13 11:24:36 EDT postgres [local]> LOG: duration:
4.965 ms
<trac_db 2007-07-13 11:24:36 EDT postgres [local]> LOG: duration:
0.110 ms
<trac_db 2007-07-13 11:24:36 EDT postgres [local]> LOG:
disconnection: session time: 0:00:00.012 user=postgres
database=trac_db host=[local]
--->
The trac data is there and the connection info in trac.ini has not
changed. We have verified the connection string info by successfully
connecting directly to trac_db using the configured userid and
password. It appears that the connection from the trac backend is
being made but is not being recognized. This is somewhat urgent so if
you have any ideas about what is going on then please let me know.
Sincerely - and somewhat desperately,
Jim
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---
