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