You are right, there are two different Python versions, but both are in /usr/local/bin:
The error ticket contains these lines: Version web2py™ Version 2.5.1-stable+timestamp.2013.06.06.15.39.19 Python *Python 2.7.4: /usr/local/bin/python (prefix: /usr/local)* But calling Python from the command line gives: mweissen@mweissen:/$ */usr/local/bin/python* *Python 2.7.5* (default, Aug 5 2013, 06:36:44) [GCC 4.7.3] on linux2 Sorry - I do not understand this behavior! Which line of code starts the Python interpreter of web2py when using Apache? 2013/8/5 Massimo Di Pierro <[email protected]> > 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]> >> >>> 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-**2**4-49.9c9dbd34-b526-41aa-a6f2-**b** >>>> 56eabf219df >>>> <type 'exceptions.RuntimeError'> Failure to connect, tried 5 times: >>>> Traceback (most recent call last): File "/home/www-data/web2py/gluon/** >>>> d**al.py", line 7413, in __init__ self._adapter = >>>> ADAPTERS[self._dbname](****kwarg**s) File "/home/www-data/web2py/gluon/ >>>> **d**al.py", line 2192, in __init__ if do_connect: >>>> self.find_driver(adapter_args) File >>>> "/home/www-data/web2py/gluon/**d**al.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.19 >>>> PythonPython 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.**sqlit**e") >>>> >>> 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 web2py+un...@**googlegroups.com. >>> >>> For more options, visit >>> https://groups.google.com/**groups/opt_out<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. > > -- --- 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.

