First you don't need to write you connection string like this:
db = DAL('postgres:psycopg2://postgres:password@localhost/testbank')
You can use this:
db = DAL('postgres://postgres:password@localhost/testbank')
I always set pg_hba.conf (this is on my development box not my live server)
# Database administrative login by Unix domain socket
local all postgres peer
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
Besides that if your username and password is correct you shouldn't have
any problems.
On Wed, Jul 11, 2012 at 2:29 PM, lucas <sjluk...@gmail.com> wrote:
> ok, i installed the rpm version of psycopg2 and web2py recognizes it when
> i run "python web2py.py". i then added a very simple application under the
> admin interface and added only:
>
> db = DAL('postgres:psycopg2://postgres:password@localhost/testbank')
>
> to the db.py file. when i run the "database administration" button, i get
> the error:
>
> Traceback (most recent call last):
> File "/opt/web-apps/web2py/gluon/dal.py", line 5955, in __init__
> self._adapter = ADAPTERS[self._dbname](*args
> )
> File "/opt/web-apps/web2py/gluon/dal.py", line 2010, in __init__
> self.pool_connection(connect)
> File "/opt/web-apps/web2py/gluon/dal.py", line 465, in pool_connection
> self.connection = f()
> File "/opt/web-apps/web2py/gluon/dal.py", line 2009, in connect
> return self.driver.connect(msg,**driver_args)
> File "/usr/lib64/python2.6/site-packages/psycopg2/__init__.py", line 179,
> in connect
> connection_factory=connection_factory, async=async)
> OperationalError: FATAL: Ident authentication failed for user "postgres"
>
>
> BUT, BUTTE, psql is totally working and accessing the postgresql service and
> testbank database for the "postgres" user with "trust" or "md5" set to the
> local under pg_hba.conf file and using the proper password.
>
>
> also under python native:
>
> import psycopg2
> conn = psycopg2.connect('dbname=testbank user=postgres password=password')
>
> works fine also with no issues and conn shows a proper connection object.
> so damn, even the psycopg2 driver is working either.
>
> lucas
>
--
--
Regards,
Bruce Wade
http://ca.linkedin.com/in/brucelwade
http://www.wadecybertech.com
http://www.fittraineronline.com - Fitness Personal Trainers Online
http://www.warplydesigned.com
