Florent Aide wrote:
> On Thu, Oct 2, 2008 at 1:39 AM, David Gidwani <[EMAIL PROTECTED]> wrote:
> >
> > Using latest pgSql with all dependencies, and TG 1.0.7, but I keep
> > getting connection errors when running tg-admin sql create. After
> > googling around I found out this seems to be similar to an issue back
> > in 2005 with a bad version of setuptools. Postgres IS listening, I did
> > specify password, and I can access my databases in pgAdmin. Any ideas?
>
> More info needed. Really :)
Full traceback:
$ tg-admin sql create
Using database URI postgres://mini-man:[EMAIL PROTECTED]/endgame
Traceback (most recent call last):
File "C:\Dev\Scripting\Python25\Scripts\tg-admin-script.py", line 8,
in <module>
load_entry_point('TurboGears==1.1b1', 'console_scripts', 'tg-
admin')()
File "c:\dev\scripting\python25\lib\site-packages\TurboGears-1.1b1-
py2.5.egg\turbogears\command\base.py", line 378, in main
command.run()
File "c:\dev\scripting\python25\lib\site-packages\TurboGears-1.1b1-
py2.5.egg\turbogears\command\base.py", line 127, in run
command.the_runner.run(sys.argv)
File "c:\dev\scripting\python25\lib\site-packages\SQLObject-0.10.2-
py2.5.egg\sqlobject\manager\command.py", line 101, in run
runner.run()
File "c:\dev\scripting\python25\lib\site-packages\SQLObject-0.10.2-
py2.5.egg\sqlobject\manager\command.py", line 307, in run
self.command()
File "c:\dev\scripting\python25\lib\site-packages\SQLObject-0.10.2-
py2.5.egg\sqlobject\manager\command.py", line 644, in command
exists = soClass._connection.tableExists(soClass.sqlmeta.table)
File "c:\dev\scripting\python25\lib\site-packages\SQLObject-0.10.2-
py2.5.egg\sqlobject\postgres\pgconnection.py", line 173, in
tableExists
% self.sqlrepr(tableName))
File "c:\dev\scripting\python25\lib\site-packages\SQLObject-0.10.2-
py2.5.egg\sqlobject\dbconnection.py", line 380, in queryOne
return self._runWithConnection(self._queryOne, s)
File "c:\dev\scripting\python25\lib\site-packages\SQLObject-0.10.2-
py2.5.egg\sqlobject\dbconnection.py", line 248, in _runWithConnection
conn = self.getConnection()
File "c:\dev\scripting\python25\lib\site-packages\SQLObject-0.10.2-
py2.5.egg\sqlobject\dbconnection.py", line 259, in getConnection
conn = self.makeConnection()
File "c:\dev\scripting\python25\lib\site-packages\SQLObject-0.10.2-
py2.5.egg\sqlobject\postgres\pgconnection.py", line 115, in
makeConnection
raise self.module.OperationalError("%s; used connection string %r"
% (e, self.dsn))
psycopg2.OperationalError: could not connect to server: Connection
refused (0x0000274D/10061)
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?
; used connection string 'dbname=endgame user=mini-man
password=******* host=localhost'
I've tried many things, including adding a third forward slash, the
port number, etc etc... None worked.
As for SQLAlchemy, I am messing around with it in the TG betas, but I
really have no time to migrate all my code from SQLObj to alchemy, and
I just began to move things around for production, which is when I ran
into this problem.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" 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/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
