raspberry pi starting browser xdg-open issue and error ticket postgreSQL

[Annet]

Since I am  not able to run web2py on mac os x Catalina I installed

PostgreSQL and web2py on a raspberry  pi 4.

When I start web2py using the built in server I get the following error:

Database drivers available: sqlite3, imaplib, pymysql, pg8000
please visit:
    http://127.0.0.1:8000/
starting browser...
/usr/bin/xdg-open: 801: /usr/bin/xdg-open: : Permission denied

Furthermore I get an error ticket:

Traceback (most recent call last):
  File "/home/pi/web2py/gluon/restricted.py", line 227, in restricted
    exec ccode in environment
  File "/home/pi/web2py/applications/init/models/00_init_db.py", line 42, in <module>
    ignore_field_case = myconf.get('db.ignore_field_case'))
  File "/home/pi/web2py/gluon/packages/dal/pydal/base.py", line 174, in __call__
    obj = super(MetaDAL, cls).__call__(*args, **kwargs)
  File "/home/pi/web2py/gluon/packages/dal/pydal/base.py", line 473, in __init__
    "Failure to connect, tried %d times:\n%s" % (attempts, tb)
RuntimeError: Failure to connect, tried 5 times:
Traceback (most recent call last):
  File "/home/pi/web2py/gluon/packages/dal/pydal/base.py", line 446, in __init__
    self._adapter = ADAPTERS[self._dbname](**kwargs)
  File "/home/pi/web2py/gluon/packages/dal/pydal/adapters/base.py", line 60, in __call__
    obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
  File "/home/pi/web2py/gluon/packages/dal/pydal/adapters/postgres.py", line 155, in __init__
    self.reconnect()
  File "/home/pi/web2py/gluon/packages/dal/pydal/connection.py", line 104, in reconnect
    self.connection = f()
  File "/home/pi/web2py/gluon/packages/dal/pydal/adapters/postgres.py", line 152, in connector
    return self.driver.connect(**driver_args)
  File "/home/pi/web2py/gluon/contrib/pg8000/__init__.py", line 336, in connect
    user, host, unix_sock, port, database, password, ssl)
  File "/home/pi/web2py/gluon/contrib/pg8000/core.py", line 1282, in __init__
    raise self.error
ProgrammingError: ('FATAL', '28P01', 'password authentication failed for user "posgres"')

I hope you can help me solve the issues

Kind regards,

Annet

[Dave S]

On Thursday, February 6, 2020 at 2:35:44 AM UTC-8, Annet wrote:

Since I am  not able to run web2py on mac os x Catalina I installed

PostgreSQL and web2py on a raspberry  pi 4.

When I start web2py using the built in server I get the following error:

Database drivers available: sqlite3, imaplib, pymysql, pg8000
please visit:
    http://127.0.0.1:8000/
starting browser...
/usr/bin/xdg-open: 801: /usr/bin/xdg-open: : Permission denied

Furthermore I get an error ticket:

[...]

 

File "/home/pi/web2py/gluon/contrib/pg8000/core.py", line 1282, in __init__

    raise self.error
ProgrammingError: ('FATAL', '28P01', 'password authentication failed for user "posgres"')

I hope you can help me solve the issues

2 comments .. first, you're using pg8000.  Is psycopg2 available for rasPi?  If so, use it!

Second, did you check your connection string (in private/appconfig.ini, likely) and verify the username and password?

/dps