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