Is it possible apache is using a different python version (one has sqlite and one no)?
On Monday, 5 August 2013 11:33:36 UTC-5, mweissen wrote: > > ok. but the interactive console was only for testing. > why does "welcome" not work? it's a new, clean installation. > i am working since some hours, but i did not find an answer. > > > 2013/8/5 Massimo Di Pierro <[email protected] <javascript:>> > >> db.commit() >> >> >> On Monday, 5 August 2013 10:39:50 UTC-5, mweissen 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] <javascript:>. >> 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.
