Techniq ha scritto:
>
> On Jun 7, 9:24 am, Techniq <[EMAIL PROTECTED]> wrote:
>   
>> On Jun 7, 3:10 am, Karsten Hilbert <[EMAIL PROTECTED]> wrote:
>>
>>
>>
>>     
>>> On Thu, Jun 07, 2007 at 12:20:46AM -0000, Techniq wrote:
>>>       
>>>> Any reason why I can auth with psql and not the sqlachemy.dburi in
>>>> Pylons?
>>>>         
>>> Yes, likely.
>>>       
>>>> I can see that the user, password, host, port are all passed
>>>> correctly.  These are the same parameters I use with psql to connect.
>>>> I'm connecting from the same machine in both cases.
>>>>         
>>>> psql -U username -h <ip address> <databasename>
>>>> Works.
>>>>         
>>>> sqlachemy.dburi = postgrs://username:password@<ip address>:5432/
>>>> databasename
>>>> Doesn't work.
>>>>         
>>> How ?
>>>       
>>> Karsten
>>> --
>>> GPG key ID E4071346 @ wwwkeys.pgp.net
>>> E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346
>>>       
>> initpsycopg: module initialization complete
>> psyco_connect: dsn = 'dbname=csvpn_syslog host=X.X.X.X port=5432
>> user=guest password=,<scrubbed>'
>> connection_setup: init connection object at 0x22d02f0, refcnt = 1
>> conn_connect: new postgresql connection at 0x1b4ac00
>> conn_connect: PQconnectdb(dbname=csvpn_syslog host=X.X.X.X port=5432
>> user=guest password=xxxxxxxxx) returned BAD
>> connection_init: FAILED
>> connection_dealloc: deleted connection object at 0x22d02f0, refcnt = 0
>> Traceback ...
>>
>> $ psql -U guest -h 192.168.1.50 -p 5432 csvpn_syslog
>> Password for user guest:
>> Welcome to psql 8.1.0 (server 8.1.3), the PostgreSQL interactive
>> terminal.
>>
>> Type:  \copyright for distribution terms
>>        \h for help with SQL commands
>>        \? for help with psql commands
>>        \g or terminate with semicolon to execute query
>>        \q to quit
>>
>> csvpn_syslog=>
>>     
>
> BTW: I meant for the subject to read "Postgres MD5 Auth"
>   

I've done a lot of try, but finally i've used trust auth  with some 
other restriction


Gla


-- 
+------------------------------------------------------------+
                                  Glauco Uri - Programmatore
                                    glauco(at)allevatori.com 
                               
  Sfera Carta Software(r)      [EMAIL PROTECTED]
  Via Bazzanese,69  Casalecchio di Reno(BO) - Tel. 051591054 
+------------------------------------------------------------+



--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to