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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
