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 -~----------~----~----~----~------~----~------~--~---