Hi Massimo,

on a fresh VM with Windows 10 and Python 3.7.3 I've got traceback errors
starting the _dashboard:

RuntimeError: Failure to connect, tried 5 times:
[...]
sqlite3.OperationalError: unable to open database file
[...]


(see attachment for details)


Nico

Il giorno dom 7 lug 2019 alle ore 05:57 Massimo Di Pierro <
[email protected]> ha scritto:

> Let's test the dashboard today:
>
> # download web2py from pypi
>
> python3 -m pip install web3py
>
> # start it:
>
> web3py-start myapps
>
> (pick a one time password  and answer yes when it wants to create
> something, it will create myapps folder and a temp .web3py-service folder)
>
> # open browser
>
> http://127.0.0.1:8000/_dashboard
>
> Now create a new app by cloning scaffold
>
> Does it work?
> How does it flow?
> What explanations should be necessary?
> Can you write a brief documentation of your experience for other users?
>
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/2a42c89f-cb28-4672-8f3a-f56ff883ccc4%40googlegroups.com
> <https://groups.google.com/d/msgid/web2py/2a42c89f-cb28-4672-8f3a-f56ff883ccc4%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAAE8D_CahCEH2CKVBG%3DGTCrtZMNMy-C1qur2TAjnbSukT3JcpA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
web3py


C:\Users\nico>python3
'python3' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\nico>python
Python 3.7.3 (v3.7.3:ef4ec6ed12, Mar 25 2019, 22:22:05) [MSC v.1916 64 bit 
(AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> quit()

C:\Users\nico>python -m pip install web3py
Collecting web3py
  Downloading 
https://files.pythonhosted.org/packages/27/55/adcea773312e32bb62dfa05ad58af3b2b6dccf5910df5eb4264b2fec48b6/web3py-0.1.20190705.1.tar.gz
 (2.9MB)
    100% |████████████████████████████████| 2.9MB 2.2MB/s
Collecting bottle (from web3py)
  Downloading 
https://files.pythonhosted.org/packages/69/d1/efdd0a5584169cdf791d726264089ce5d96846a8978c44ac6e13ae234327/bottle-0.12.17-py3-none-any.whl
 (89kB)
    100% |████████████████████████████████| 92kB 2.0MB/s
Collecting gunicorn (from web3py)
  Downloading 
https://files.pythonhosted.org/packages/8c/da/b8dd8deb741bff556db53902d4706774c8e1e67265f69528c14c003644e6/gunicorn-19.9.0-py2.py3-none-any.whl
 (112kB)
    100% |████████████████████████████████| 122kB 932kB/s
Collecting gevent (from web3py)
  Downloading 
https://files.pythonhosted.org/packages/8a/dd/417aad4e69fa7f8882534b778c46cb28eb0421ffa1e924ec3b4efcfcc81f/gevent-1.4.0-cp37-cp37m-win_amd64.whl
 (3.0MB)
    100% |████████████████████████████████| 3.0MB 595kB/s
Collecting threadsafevariable (from web3py)
  Downloading 
https://files.pythonhosted.org/packages/91/ea/ad8695699677955b68bf08fbe88a73a35ceca1515befc10cb071a527868b/threadsafevariable-1.0.tar.gz
Collecting pydal (from web3py)
  Downloading 
https://files.pythonhosted.org/packages/65/1e/ad330385bf45ee280cd2d33ed086e11224658863ab851f9d1a8421656424/pydal-19.5.11.tar.gz
 (390kB)
    100% |████████████████████████████████| 399kB 3.3MB/s
Collecting pyjwt (from web3py)
  Downloading 
https://files.pythonhosted.org/packages/87/8b/6a9f14b5f781697e51259d81657e6048fd31a113229cf346880bb7545565/PyJWT-1.7.1-py2.py3-none-any.whl
Collecting yatl (from web3py)
  Downloading 
https://files.pythonhosted.org/packages/a7/a2/d4b38d0b550117b4af7f814542fcbd9a2fac26be100e6a57bb5c0998ed3a/yatl-1.0.7.tar.gz
Collecting reloader (from web3py)
  Downloading 
https://files.pythonhosted.org/packages/64/19/12089757f2f50f3aa81e05cf07089e3e82f260260362d4d9da6c8cf43f90/reloader-0.6.tar.gz
Collecting tornado (from web3py)
  Downloading 
https://files.pythonhosted.org/packages/4e/f8/86ab848da5c79715f901e22bc23d2dc467b8672fe1eda8d3e1f48cba130c/tornado-6.0.3-cp37-cp37m-win_amd64.whl
 (415kB)
    100% |████████████████████████████████| 419kB 1.1MB/s
Collecting pluralize (from web3py)
  Downloading 
https://files.pythonhosted.org/packages/7a/99/3e6891ed8b848729cace60182b9dae00c1ac3e3220c7e92176bcd357c87d/pluralize-0.1.3.tar.gz
Collecting requests (from web3py)
  Downloading 
https://files.pythonhosted.org/packages/51/bd/23c926cd341ea6b7dd0b2a00aba99ae0f828be89d72b2190f27c11d4b7fb/requests-2.22.0-py2.py3-none-any.whl
 (57kB)
    100% |████████████████████████████████| 61kB 827kB/s
Collecting greenlet>=0.4.14; platform_python_implementation == "CPython" (from 
gevent->web3py)
  Downloading 
https://files.pythonhosted.org/packages/90/a3/da8593df08ee2efeb86ccf3201508a1fd2a3749e2735b7cadb7dd00416c6/greenlet-0.4.15-cp37-cp37m-win_amd64.whl
Collecting cffi>=1.11.5; sys_platform == "win32" and 
platform_python_implementation == "CPython" (from gevent->web3py)
  Downloading 
https://files.pythonhosted.org/packages/2f/ad/9722b7752fdd88c858be57b47f41d1049b5fb0ab79caf0ab11407945c1a7/cffi-1.12.3-cp37-cp37m-win_amd64.whl
 (171kB)
    100% |████████████████████████████████| 174kB 1.1MB/s
Collecting chardet<3.1.0,>=3.0.2 (from requests->web3py)
  Downloading 
https://files.pythonhosted.org/packages/bc/a9/01ffebfb562e4274b6487b4bb1ddec7ca55ec7510b22e4c51f14098443b8/chardet-3.0.4-py2.py3-none-any.whl
 (133kB)
    100% |████████████████████████████████| 143kB 844kB/s
Collecting certifi>=2017.4.17 (from requests->web3py)
  Downloading 
https://files.pythonhosted.org/packages/69/1b/b853c7a9d4f6a6d00749e94eb6f3a041e342a885b87340b79c1ef73e3a78/certifi-2019.6.16-py2.py3-none-any.whl
 (157kB)
    100% |████████████████████████████████| 163kB 820kB/s
Collecting urllib3!=1.25.0,!=1.25.1,<1.26,>=1.21.1 (from requests->web3py)
  Downloading 
https://files.pythonhosted.org/packages/e6/60/247f23a7121ae632d62811ba7f273d0e58972d75e58a94d329d51550a47d/urllib3-1.25.3-py2.py3-none-any.whl
 (150kB)
    100% |████████████████████████████████| 153kB 2.1MB/s
Collecting idna<2.9,>=2.5 (from requests->web3py)
  Downloading 
https://files.pythonhosted.org/packages/14/2c/cd551d81dbe15200be1cf41cd03869a46fe7226e7450af7a6545bfc474c9/idna-2.8-py2.py3-none-any.whl
 (58kB)
    100% |████████████████████████████████| 61kB 358kB/s
Collecting pycparser (from cffi>=1.11.5; sys_platform == "win32" and 
platform_python_implementation == "CPython"->gevent->web3py)
  Downloading 
https://files.pythonhosted.org/packages/68/9e/49196946aee219aead1290e00d1e7fdeab8567783e83e1b9ab5585e6206a/pycparser-2.19.tar.gz
 (158kB)
    100% |████████████████████████████████| 163kB 653kB/s
Installing collected packages: bottle, gunicorn, greenlet, pycparser, cffi, 
gevent, threadsafevariable, pydal, pyjwt, yatl, reloader, tornado, pluralize, 
chardet, certifi, urllib3, idna, requests, web3py
  Running setup.py install for pycparser ... done
  Running setup.py install for threadsafevariable ... done
  Running setup.py install for pydal ... done
  Running setup.py install for yatl ... done
  Running setup.py install for reloader ... done
  Running setup.py install for pluralize ... done
  Running setup.py install for web3py ... done
Successfully installed bottle-0.12.17 certifi-2019.6.16 cffi-1.12.3 
chardet-3.0.4 gevent-1.4.0 greenlet-0.4.15 gunicorn-19.9.0 idna-2.8 
pluralize-0.1.3 pycparser-2.19 pydal-19.5.11 pyjwt-1.7.1 reloader-0.6 
requests-2.22.0 threadsafevariable-1.0 tornado-6.0.3 urllib3-1.25.3 
web3py-0.1.20190705.1 yatl-1.0.7
You are using pip version 19.0.3, however version 19.1.1 is available.
You should consider upgrading via the 'python -m pip install --upgrade pip' 
command.

C:\Users\nico>
C:\Users\nico>pip list
Package            Version
------------------ --------------
altgraph           0.16.1
bottle             0.12.17
certifi            2019.6.16
cffi               1.12.3
chardet            3.0.4
future             0.17.1
gevent             1.4.0
greenlet           0.4.15
gunicorn           19.9.0
idna               2.8
macholib           1.11
pefile             2018.8.8
pip                19.0.3
pluralize          0.1.3
psycopg2           2.7.7
pyasn1             0.4.5
pyasn1-modules     0.2.4
pycparser          2.19
pydal              19.5.11
PyInstaller        3.4
PyJWT              1.7.1
pyodbc             4.0.26
python-ldap        3.2.0
pywin32            224
pywin32-ctypes     0.2.0
reloader           0.6
requests           2.22.0
setuptools         41.0.0
threadsafevariable 1.0
tornado            6.0.3
urllib3            1.25.3
web3py             0.1.20190705.1
yatl               1.0.7
You are using pip version 19.0.3, however version 19.1.1 is available.
You should consider upgrading via the 'python -m pip install --upgrade pip' 
command.

C:\Users\nico>
C:\Users\nico>web3py-start myapps

 _______  ____________  ____  ______  __
|  ____/ / / ____/ __ |/___ \/ __ \ \/ /
| |     / / /_  / /_/ /___/ / /_/ /\  /
| | /| / / __/ / __  //__  / ____/ / /
| |/ |/ / /___/ /_/ /___/ / / ____/ /
|___/|_/_____/_____/_____/_/ /_____/
It is still experimental...

Choose a one-time dashboad password:
Create .web3py-service (y/n)? y
[ ] Unzipping app web3py.app._dashboard.zip
[X]
Dashboard is at: http://127.0.0.1:8000/_dashboard
[ ] loading _dashboard ...
[FAILED] loading _dashboard
Traceback (most recent call last):
  File 
"C:\Users\nico\AppData\Local\Programs\Python\Python37\lib\site-packages\web3py\core.py",
 line 632, in import_apps
    module = importlib.machinery.SourceFileLoader(module_name, 
init).load_module()
  File "<frozen importlib._bootstrap_external>", line 407, in 
_check_name_wrapper
  File "<frozen importlib._bootstrap_external>", line 907, in load_module
  File "<frozen importlib._bootstrap_external>", line 732, in load_module
  File "<frozen importlib._bootstrap>", line 265, in _load_module_shim
  File "<frozen importlib._bootstrap>", line 696, in _load
  File "<frozen importlib._bootstrap>", line 677, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 728, in exec_module
  File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
  File "C:\Users\nico\myapps\_dashboard\__init__.py", line 24, in <module>
    error_storage = ErrorStorage()
  File 
"C:\Users\nico\AppData\Local\Programs\Python\Python37\lib\site-packages\web3py\core.py",
 line 549, in __init__
    self.db = DAL(uri, folder=folder)
  File 
"C:\Users\nico\AppData\Local\Programs\Python\Python37\lib\site-packages\pydal\base.py",
 line 171, in __call__
    obj = super(MetaDAL, cls).__call__(*args, **kwargs)
  File 
"C:\Users\nico\AppData\Local\Programs\Python\Python37\lib\site-packages\pydal\base.py",
 line 477, 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 
"C:\Users\nico\AppData\Local\Programs\Python\Python37\lib\site-packages\pydal\base.py",
 line 457, in __init__
    self._adapter = adapter(**kwargs)
  File 
"C:\Users\nico\AppData\Local\Programs\Python\Python37\lib\site-packages\pydal\adapters\__init__.py",
 line 39, in __call__
    obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
  File 
"C:\Users\nico\AppData\Local\Programs\Python\Python37\lib\site-packages\pydal\adapters\base.py",
 line 369, in __init__
    super(SQLAdapter, self).__init__(*args, **kwargs)
  File 
"C:\Users\nico\AppData\Local\Programs\Python\Python37\lib\site-packages\pydal\adapters\base.py",
 line 53, in __init__
    self.reconnect()
  File 
"C:\Users\nico\AppData\Local\Programs\Python\Python37\lib\site-packages\pydal\connection.py",
 line 154, in reconnect
    self.connection = self.connector()
  File 
"C:\Users\nico\AppData\Local\Programs\Python\Python37\lib\site-packages\pydal\adapters\sqlite.py",
 line 42, in connector
    return self.driver.Connection(self.dbpath, **self.driver_args)
sqlite3.OperationalError: unable to open database file



Bottle v0.12.17 server starting up (using TornadoServer())...
Listening on http://127.0.0.1:8000/
Hit Ctrl-C to quit.

WARNING:tornado.access:404 GET /_dashboard (127.0.0.1) 0.00ms




Reply via email to