David Gidwani schrieb:
> 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?
Did you verify this, using e.g. telnet? Can you connect using pure
psycopg(2)?
> ; 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.
SA or not has nothing to do with this.
Diez
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
