I have made a new web2py installation on Ubuntu, using the script
setup-web2py-ubuntu.sh
web2py can be opened and admin shows:
Version
2.5.1-stable+timestamp.2013.06.06.15.39.19
(L?uft auf Apache/2.2.22 (Ubuntu))
When I try to open the "Welcome" application I get:
Error ticket for "welcome" Ticket ID
178.190.67.157.2013-08-05.17-24-49.9c9dbd34-b526-41aa-a6f2-b56eabf219df
<type 'exceptions.RuntimeError'> Failure to connect, tried 5 times:
Traceback (most recent call last): File
"/home/www-data/web2py/gluon/dal.py", line 7413, in __init__ self._adapter
= ADAPTERS[self._dbname](**kwargs) File
"/home/www-data/web2py/gluon/dal.py", line 2192, in __init__ if do_connect:
self.find_driver(adapter_args) File "/home/www-data/web2py/gluon/dal.py",
line 733, in find_driver raise RuntimeError("no driver available %s" %
str(self.drivers)) RuntimeError: no driver available ('sqlite2', 'sqlite3')
Version web2py™Version 2.5.1-stable+timestamp.2013.06.06.15.39.19PythonPython
2.7.4: /usr/local/bin/python (prefix: /usr/local)
I have tried to use sqlite from Python:
Python 2.7.5 (default, Aug 5 2013, 06:36:44)
[GCC 4.7.3] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> print sqlite3.version
2.6.0
>>> print sqlite3.sqlite_version
3.7.15.2
Seems to be ok.
Now I have tried to open an interactive console:
root@mw:/home/www-data/web2py# python web2py.py -M -S welcome
web2py Web Framework
Created by Massimo Di Pierro, Copyright 2007-2013
Version 2.5.1-stable+timestamp.2013.06.06.15.39.19
Database drivers available: SQLite(sqlite3), MySQL(pymysql),
PostgreSQL(pg8000), IMAP(imaplib)
WARNING:web2py:import IPython error; use default python shell
Python 2.7.5 (default, Aug 5 2013, 06:36:44)
[GCC 4.7.3] on linux2
Type "help", "copyright", "credits" or "license" for more information.
(InteractiveConsole)
>>> db=DAL("sqlite://storage.sqlite")
>>> db.tables
[]
>>> db.define_table("test", Field("x"))
<Table test (id,x)>
>>> db.tables
['test']
>>>
Looks good, but this table will not be saved. After closing and opening the
table list is empty again.
Any ideas?
Do I need both sqlite2 and sqlite3?
Regards, Martin
--
---
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].
For more options, visit https://groups.google.com/groups/opt_out.
