Here what DAL try to import from pysqlite2 import dbapi2 as sqlite2 from sqlite3 import dbapi2 as sqlite3
On Mon, Aug 5, 2013 at 11:39 AM, Martin Weissenboeck <[email protected]>wrote: > 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. > > > -- --- 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.
