On 25 Feb 2008, at 19:05, Cyrus Daboo wrote: > Hi Jaco, > > --On February 23, 2008 1:54:35 PM +0000 Jaco Engelbrecht <[EMAIL PROTECTED] > > 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 -- [EMAIL PROTECTED] the faculty of making fortunate discoveries _______________________________________________ calendarserver-users mailing list calendarserver-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/calendarserver-users