Re: [web2py] Re: Trying to create a DAL connection and getting some errors...

[Jason Brower]

I made the change and I was able to get the connection.
I noticed the comment in the shell. I was trying to make the connection 
and it was one possible reason why it was not working.
BR,
J
On 05/24/2012 08:53 PM, Massimo Di Pierro wrote:
?
where are you reading that? You can create tables dynamically. Your 
problem is the bug discussed here:

 self.driver = drivers.get('pg8000')

should be

 self.driver = self.drivers.get('pg8000')

This is a known bug fixed in trunk some time ago.

On Wednesday, 23 May 2012 11:14:01 UTC-5, encompass wrote:

    And I just noticed the comment here:
    "Creating new tables dynamically is not allowed."
    Isn't this just what I am about to do?
    ---
    BR,
    Jason Brower

    On 05/23/2012 07:04 PM, Massimo Di Pierro wrote:
    This has been fixed in trunk some time ago

     self.driver = drivers.get('pg8000')

    should be

     self.driver = self.drivers.get('pg8000')

    On Wednesday, 23 May 2012 11:01:59 UTC-5, encompass wrote:

        In the console I type this:
        db2 =
        DAL('postgres://postgres:********@localhost:5432/postgres')
        And I get this:
        In [7] : print "hi"
        hi

        In [8] : db2 =
        DAL('postgres://postgres:********@localhost:5432/postgres')
        DEBUG: connect attempt 0, connection error:
        Traceback (most recent call last):
           File "/home/www-data/web2py/gluon/dal.py", line 5955, in
        __init__
             self._adapter = ADAPTERS[self._dbname](*args)
           File "/home/www-data/web2py/gluon/dal.py", line 1999, in
        __init__
             self.driver = drivers.get('pg8000')
        AttributeError: 'list' object has no attribute 'get'
        DEBUG: connect attempt 1, connection error:
        Traceback (most recent call last):
           File "/home/www-data/web2py/gluon/dal.py", line 5955, in
        __init__
             self._adapter = ADAPTERS[self._dbname](*args)
           File "/home/www-data/web2py/gluon/dal.py", line 1999, in
        __init__
             self.driver = drivers.get('pg8000')
        AttributeError: 'list' object has no attribute 'get'
        DEBUG: connect attempt 2, connection error:
        Traceback (most recent call last):
           File "/home/www-data/web2py/gluon/dal.py", line 5955, in
        __init__
             self._adapter = ADAPTERS[self._dbname](*args)
           File "/home/www-data/web2py/gluon/dal.py", line 1999, in
        __init__
             self.driver = drivers.get('pg8000')
        AttributeError: 'list' object has no attribute 'get'
        DEBUG: connect attempt 3, connection error:
        Traceback (most recent call last):
           File "/home/www-data/web2py/gluon/dal.py", line 5955, in
        __init__
             self._adapter = ADAPTERS[self._dbname](*args)
           File "/home/www-data/web2py/gluon/dal.py", line 1999, in
        __init__
             self.driver = drivers.get('pg8000')
        AttributeError: 'list' object has no attribute 'get'
        DEBUG: connect attempt 4, connection error:
        Traceback (most recent call last):
           File "/home/www-data/web2py/gluon/dal.py", line 5955, in
        __init__
             self._adapter = ADAPTERS[self._dbname](*args)
           File "/home/www-data/web2py/gluon/dal.py", line 1999, in
        __init__
             self.driver = drivers.get('pg8000')
        AttributeError: 'list' object has no attribute 'get'
        Traceback (most recent call last):
           File "/home/www-data/web2py/gluon/contrib/shell.py", line
        233, in run
             exec compiled in statement_module.__dict__
           File "<string>", line 1, in <module>
           File "/home/www-data/web2py/gluon/dal.py", line 5968, in
        __init__
             raise RuntimeError, "Failure to connect, tried %d
        times:\n%s" %
        (attempts, tb)
        RuntimeError: Failure to connect, tried 5 times:
        Traceback (most recent call last):
           File "/home/www-data/web2py/gluon/dal.py", line 5955, in
        __init__
             self._adapter = ADAPTERS[self._dbname](*args)
           File "/home/www-data/web2py/gluon/dal.py", line 1999, in
        __init__
             self.driver = drivers.get('pg8000')
        AttributeError: 'list' object has no attribute 'get'

        The server is located locally on an amazon system running
        ubuntu.  I
        created the postres user and it seems to be open and
        connectable.  I
        have also created the database postgres.
        Any ideas why it wouldn't work?
        BR,
        Jason Brower