RE: [SQLObject] Acces postgresql...

[Ahmed M. A. <ahm...@wa...>]

Hi,
I had the same problem.
To access to different database i modified the PostgresConnection.py file.

#MODIFICATION du fichier PostgresConnection.py#
class   :PostgresConnection
methode :__init__
modification : add parameter port=5432  to __init__

def __init__(self, dsn=None, host=None, db=None,
                 user=None, passwd=None, autoCommit=1,
                 usePygresql=False,port=5432,
                 **kw):

To access the database with the standard port :

postgres://perso:se...@my...chine/testdb

To access a database with port 5435 :

postgres://perso:se...@my...chine/testdb?port=5435'

Best regards,
Ahmed MOHAMED ALI
Edigram,Directeur informatique.




-----Message d'origine-----
De : sql...@li...
[mailto:sql...@li...]De la part de
Philippe Bouige
Envoye : mercredi 9 fevrier 2005 14:45
A : sql...@li...
Objet : [SQLObject] Acces postgresql...



Hello,

  I have two machine with postgresql, but the first with the
  port 5432 and the other with the port 5435 (I'm not
  database administrator)

  How to do modify the port in connectionForUri.. ??

  Thank you very much for your help.

  I try this :
  'postgres://perso:se...@my...chine:5435/testdb'
   but it is  the same error...


  with the potsgresql port 5432 no problem :

>>> from sqlobject import *

>>> conn =
    connectionForURI('postgres://perso:se...@my...chine/testdb')
>>>
>>> conn.getConnection()
<connection object at 0x140542030>
>>>
>>> class Person(SQLObject):
...     _connection = conn
...     name = StringCol()
...
>>>
>>> Person.createTable()

    It's Ok :-)


    but with postgresql port 5435 I have this error :


>>> from sqlobject import *

...etc..

>>> conn.getConnection()
------------------------------------------------------------
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File
  "/home/python/lib/python2.3/site-packages/sqlobject/dbconnection.py", line
134, in getConnection
    newConn = self.makeConnection()
  File

"/home/python/lib/python2.3/site-packages/sqlobject/postgres/pgconnection.py
", line 65, in makeConnection
    raise self.module.OperationalError("%s; used connection
    string %r" % (e, self.dsn))
OperationalError: could not connect to server: Connection refused
        Is the server running on host "my.second.machine" and
        accepting
        TCP/IP connections on port 5432?
; used connection string 'dbname=testdb user=perso
password=secret host=my.second.machine'



-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
sqlobject-discuss mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss