On 25 Feb 2008, at 19:05, Cyrus Daboo wrote:
Hi Jaco,
--On February 23, 2008 1:54:35 PM +0000 Jaco Engelbrecht <bje@serendipity.org.za
wrote:
Any ideas? Is it a problem with CalendarServer or Twisted?
This is a problem with your pysqlite installation:
exceptions.AttributeError: 'pysqlite2.dbapi2.Connection' object has no attribute 'execute'
Looks like you might have an old version of that installed. What version of Python are you using? Can you locate your pysqlite install and see what version it is? We normally use v2.3.2 on Python 2.4 installs. sqlite is now included in Python 2.5 so is not used there.
Brilliant! Upgrading the py-pysqlite23 package on FreeBSD has fixed my problem. Should I worry about the following traceback - I can create calendar entries fine by the looks of things ... (will start testing more thoroughly in the morning). 2008-02-26 01:07:01+0200 [-] [caldav-8008] [-] Setting up service 2008-02-26 01:07:01+0200 [-] [caldav-8008] [-] Configuring log observer: <twistedcaldav.logging.AMPCommonAccessLoggingObserver object at 0x8ad6fac> 2008-02-26 01:07:01+0200 [-] [caldav-8008] [-] Adding server at :8008 2008-02-26 01:07:01+0200 [-] [caldav-8008] [-] Adding SSL server at : 8443 2008-02-26 01:07:01+0200 [-] [caldav-8008] [-] twisted.web2.channel.http.HTTPFactory starting on 8008 2008-02-26 01:07:01+0200 [-] [caldav-8008] [-] Starting factory <twisted.web2.channel.http.HTTPFactory instance at 0x8ad706c> 2008-02-26 01:07:01+0200 [-] [caldav-8008] [-] twisted.web2.channel.http.HTTPFactory starting on 8443 2008-02-26 01:07:01+0200 [twistedcaldav.logging.AMPLoggingFactory] AMPLoggingProtocol connection established (HOST:UNIXSocket('logs/ caldavd.sock') PEER:UNIXSocket('')) 2008-02-26 01:07:01+0200 [-] [caldav-8008] [-] AMP connection established (HOST:UNIXSocket(None) PEER:UNIXSocket('logs/caldavd.sock')) 2008-02-26 01:07:40+0200 [-] [caldav-8008] [HTTPChannel, 0,78.86.167.16] PROPFIND / HTTP/1.1 2008-02-26 01:07:48+0200 [-] [caldav-8008] [HTTPChannel, 1,78.86.167.16] "Directory service <SudoDirectoryService 'Test Realm': FilePath('/data/src/new/CalendarServer-1.1/conf/sudoers.plist')> has no GUID; generating service GUID from realm name." 2008-02-26 01:07:48+0200 [-] [caldav-8008] [HTTPChannel, 1,78.86.167.16] PROPFIND /principals/users/admin/ HTTP/1.1 2008-02-26 01:07:49+0200 [-] [caldav-8008] [HTTPChannel, 2,78.86.167.16] PROPFIND /principals/users/admin/ HTTP/1.1 2008-02-26 01:07:49+0200 [-] [caldav-8008] [-] Provisioning file: <CalendarHomeTypeProvisioningFile: /data/src/new/CalendarServer-1.1/ twistedcaldav/test/data/calendars/users> 2008-02-26 01:07:49+0200 [-] [caldav-8008] [-] Provisioning file: <CalendarHomeFile: /data/src/new/CalendarServer-1.1/twistedcaldav/test/ data/calendars/users/admin> 2008-02-26 01:07:49+0200 [-] [caldav-8008] [-] Initializing database / data/src/new/CalendarServer-1.1/twistedcaldav/test/data/calendars/ users/admin/calendar/.db.sqlite 2008-02-26 01:07:49+0200 [-] [caldav-8008] [-] "Directory service <XMLDirectoryService 'Test Realm': FilePath('/data/src/new/ CalendarServer-1.1/conf/accounts-test.xml')> has no GUID; generating service GUID from realm name." 2008-02-26 01:07:49+0200 [-] [caldav-8008] [-] Unhandled error in Deferred: 2008-02-26 01:07:49+0200 [-] [caldav-8008] [-] Unhandled Error 2008-02-26 01:07:49+0200 [-] [caldav-8008] Traceback (most recent call last): 2008-02-26 01:07:49+0200 [-] [caldav-8008] File "/data/src/new/ CalendarServer-1.1/twistedcaldav/directory/calendar.py", line 241, in provisionDefaultCalendars 2008-02-26 01:07:49+0200 [-] [caldav-8008] d = child.createCalendarCollection() 2008-02-26 01:07:49+0200 [-] [caldav-8008] File "/data/src/new/ CalendarServer-1.1/twistedcaldav/static.py", line 143, in createCalendarCollection 2008-02-26 01:07:49+0200 [-] [caldav-8008] d.addCallback(onCalendarCollection) 2008-02-26 01:07:49+0200 [-] [caldav-8008] File "/data/src/new/ Twisted/twisted/internet/defer.py", line 191, in addCallback 2008-02-26 01:07:49+0200 [-] [caldav-8008] callbackKeywords=kw) 2008-02-26 01:07:49+0200 [-] [caldav-8008] File "/data/src/new/ Twisted/twisted/internet/defer.py", line 182, in addCallbacks 2008-02-26 01:07:49+0200 [-] [caldav-8008] self._runCallbacks() 2008-02-26 01:07:49+0200 [-] [caldav-8008] --- <exception caught here> --- 2008-02-26 01:07:49+0200 [-] [caldav-8008] File "/data/src/new/ Twisted/twisted/internet/defer.py", line 317, in _runCallbacks 2008-02-26 01:07:49+0200 [-] [caldav-8008] self.result = callback(self.result, *args, **kw) 2008-02-26 01:07:49+0200 [-] [caldav-8008] File "/data/src/new/ CalendarServer-1.1/twistedcaldav/static.py", line 138, in onCalendarCollection 2008-02-26 01:07:49+0200 [-] [caldav-8008] self.index().create() 2008-02-26 01:07:49+0200 [-] [caldav-8008] File "/data/src/new/ CalendarServer-1.1/twistedcaldav/index.py", line 107, in create 2008-02-26 01:07:49+0200 [-] [caldav-8008] self._db() 2008-02-26 01:07:49+0200 [-] [caldav-8008] File "/data/src/new/ CalendarServer-1.1/twistedcaldav/sql.py", line 121, in _db 2008-02-26 01:07:49+0200 [-] [caldav-8008] self._db_init(db_filename, q) 2008-02-26 01:07:49+0200 [-] [caldav-8008] File "/data/src/new/ CalendarServer-1.1/twistedcaldav/sql.py", line 157, in _db_init 2008-02-26 01:07:49+0200 [-] [caldav-8008] q.execute("commit") 2008-02-26 01:07:49+0200 [-] [caldav-8008] pysqlite2.dbapi2.OperationalError: cannot commit - no transaction is active 2008-02-26 01:07:49+0200 [-] [caldav-8008] 2008-02-26 01:07:50+0200 [-] [caldav-8008] [HTTPChannel, 3,78.86.167.16] Provisioning file: <ScheduleInboxFile (calendar inbox collection): /data/src/new/CalendarServer-1.1/twistedcaldav/test/data/ calendars/users/admin/inbox> 2008-02-26 01:07:50+0200 [-] [caldav-8008] [HTTPChannel, 3,78.86.167.16] PROPFIND /calendars/users/admin/inbox/ HTTP/1.1 2008-02-26 01:07:50+0200 [-] [caldav-8008] [HTTPChannel, 4,78.86.167.16] PROPFIND /principals/users/admin/ HTTP/1.1 2008-02-26 01:07:51+0200 [-] [caldav-8008] [HTTPChannel, 5,78.86.167.16] PROPFIND /calendars/users/admin/inbox/ HTTP/1.1 2008-02-26 01:07:51+0200 [-] [caldav-8008] [-] Provisioning file: (users) admin [calendar-proxy-read] 2008-02-26 01:07:51+0200 [-] [caldav-8008] [-] Provisioning file: (users) admin 2008-02-26 01:07:51+0200 [-] [caldav-8008] [-] Provisioning file: (users) admin [calendar-proxy-read] 2008-02-26 01:07:51+0200 [-] [caldav-8008] [-] Initializing database / data/src/new/CalendarServer-1.1/twistedcaldav/test/data/ principals/.db.calendaruserproxy 2008-02-26 01:07:51+0200 [-] [caldav-8008] [-] Provisioning file: (users) admin [calendar-proxy-write] 2008-02-26 01:07:51+0200 [-] [caldav-8008] [-] Provisioning file: (users) admin 2008-02-26 01:07:51+0200 [-] [caldav-8008] [-] Provisioning file: (users) admin [calendar-proxy-write] 2008-02-26 01:07:51+0200 [-] [caldav-8008] [HTTPChannel, 6,78.86.167.16] PROPFIND /principals/users/admin/ HTTP/1.1 2008-02-26 01:07:52+0200 [-] [caldav-8008] [HTTPChannel, 7,78.86.167.16] PROPFIND /calendars/users/admin/ HTTP/1.1 2008-02-26 01:07:52+0200 [-] [caldav-8008] [HTTPChannel, 8,78.86.167.16] PROPFIND /calendars/users/admin/calendar/ HTTP/1.1 2008-02-26 01:07:54+0200 [-] [caldav-8008] [HTTPChannel, 9,78.86.167.16] PROPFIND /calendars/users/admin/calendar/ HTTP/1.1 2008-02-26 01:07:55+0200 [-] [caldav-8008] [HTTPChannel, 10,78.86.167.16] PROPFIND /calendars/users/admin/inbox/ HTTP/1.1 2008-02-26 01:07:55+0200 [-] [caldav-8008] [HTTPChannel, 11,78.86.167.16] PROPFIND /calendars/users/admin/inbox/ HTTP/1.1 2008-02-26 01:08:00+0200 [-] [caldav-8008] [HTTPChannel, 12,78.86.167.16] PROPFIND /principals/users/admin/ HTTP/1.1 2008-02-26 01:08:01+0200 [-] [caldav-8008] [HTTPChannel, 13,78.86.167.16] PROPFIND /principals/users/admin/ HTTP/1.1 2008-02-26 01:08:06+0200 [-] [caldav-8008] [HTTPChannel, 14,78.86.167.16] PROPFIND /principals/users/admin/ HTTP/1.1 2008-02-26 01:08:22+0200 [-] [caldav-8008] [HTTPChannel, 15,78.86.167.16] PROPPATCH /calendars/users/admin/inbox/ HTTP/1.1 2008-02-26 01:08:46+0200 [-] [caldav-8008] [HTTPChannel, 16,78.86.167.16] PROPFIND /principals/users/admin/ HTTP/1.1 2008-02-26 01:08:47+0200 [-] [caldav-8008] [HTTPChannel, 17,78.86.167.16] PROPFIND /principals/users/admin/ HTTP/1.1 2008-02-26 01:09:08+0200 [-] [caldav-8008] [HTTPChannel, 18,78.86.167.16] PUT /calendars/users/admin/calendar/ 41DBCF04-335A-424D-8AB7-7C00BA4A0E00.ics HTTP/1.1 2008-02-26 01:09:09+0200 [-] [caldav-8008] [-] Writing to file /data/ src/new/CalendarServer-1.1/twistedcaldav/test/data/calendars/users/ admin/calendar/41DBCF04-335A-424D-8AB7-7C00BA4A0E00.ics 2008-02-26 01:09:11+0200 [-] [caldav-8008] [HTTPChannel, 19,78.86.167.16] PUT /calendars/users/admin/calendar/ 41DBCF04-335A-424D-8AB7-7C00BA4A0E00.ics HTTP/1.1 2008-02-26 01:09:11+0200 [-] [caldav-8008] [-] Writing to file /data/ src/new/CalendarServer-1.1/twistedcaldav/test/data/calendars/users/ admin/calendar/41DBCF04-335A-424D-8AB7-7C00BA4A0E00.ics 2008-02-26 01:09:37+0200 [-] [caldav-8008] [HTTPChannel, 20,78.86.167.16] PUT /calendars/users/admin/calendar/E1E92F1D- B251-4D50-86E6-E448433B85E3.ics HTTP/1.1 2008-02-26 01:09:37+0200 [-] [caldav-8008] [-] Writing to file /data/ src/new/CalendarServer-1.1/twistedcaldav/test/data/calendars/users/ admin/calendar/E1E92F1D-B251-4D50-86E6-E448433B85E3.ics 2008-02-26 01:09:41+0200 [-] [caldav-8008] [HTTPChannel, 21,78.86.167.16] PUT /calendars/users/admin/calendar/E1E92F1D- B251-4D50-86E6-E448433B85E3.ics HTTP/1.1 2008-02-26 01:09:41+0200 [-] [caldav-8008] [-] Writing to file /data/ src/new/CalendarServer-1.1/twistedcaldav/test/data/calendars/users/ admin/calendar/E1E92F1D-B251-4D50-86E6-E448433B85E3.ics Jaco -- bje@serendipity.org.za the faculty of making fortunate discoveries