CalendarServer 1.1 and Account information not found - HTTP/1.1 500 Internal Server Error
Hi, I am trying to get Calendar Server 1.1 (http://svn.calendarserver.org/repository/calendarserver/CalendarServer/tags/... - also checked out trunk - same problem) to work on FreeBSD 6. When setting up my iCal account on MacOSX Leopard 10.5.1 using iCal, I get - "Account information not found - Request for http://<myhost>: 8008/principals/users/admin/ failed. The server responded with "HTTP/ 1.1 500 Internal Server Error": 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] Log opened. 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] twistd 2.5.0+rUnknown (/usr/local/bin/python 2.4.4) starting up 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] reactor class: <class 'twisted.internet.selectreactor.SelectReactor'> 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] Configuring directory service of type: twistedcaldav.directory.xmlfile.XMLDirectoryService 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] Configuring SudoDirectoryService with file: conf/sudoers.plist 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] Setting up document root at: twistedcaldav/test/data/ 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] Setting up principal collection: <class 'twistedcaldav .directory.principal.DirectoryPrincipalProvisioningResource'> 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] Setting up calendar collection: <class 'twistedcaldav.static.CalendarHomeProvisioningFile'> 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] Setting up root resource: <class 'twistedcaldav.root.RootResource'> 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] Setting up default ACEs on root resource 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] Setting up AdminPrincipals 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] Added /principals/ __uids__/admin/ as admin principal 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] Setting root ACL 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] Configuring authentication for realm: Test Realm 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] Setting up scheme: kerberos 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] Kerberos support not available 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] Setting up scheme: digest 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] Setting up scheme: basic 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] Configuring authentication wrapper 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] Setting up service 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] Configuring log observer: <twistedcaldav.logging.AMPCommonAccessLoggingObserver object at 0x8ad9c0c> 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] Adding server at :8008 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] Adding SSL server at : 8443 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] twisted.web2.channel.http.HTTPFactory starting on 8008 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] Starting factory <twisted.web2.channel.http.HTTPFactory instance at 0x8ad9cac> 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] twisted.web2.channel.http.HTTPFactory starting on 8443 2008-02-23 15:34:01+0200 [twistedcaldav.logging.AMPLoggingFactory] AMPLoggingProtocol connection established (HOST:UNIXSocket('logs/ caldavd.sock') PEER:UNIXSocket('')) 2008-02-23 15:34:01+0200 [-] [caldav-8008] [-] AMP connection established (HOST:UNIXSocket(None) PEER:UNIXSocket('logs/caldavd.sock')) 2008-02-23 15:34:08+0200 [-] [caldav-8008] [HTTPChannel, 0,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-23 15:34:08+0200 [-] [caldav-8008] [HTTPChannel, 0,78.86.167.16] PROPFIND /principals/users/admin/ HTTP/1.1 2008-02-23 15:34:08+0200 [-] [caldav-8008] [HTTPChannel, 0,78.86.167.16] Exception rendering: 2008-02-23 15:34:08+0200 [-] [caldav-8008] [HTTPChannel, 0,78.86.167.16] Unhandled Error 2008-02-23 15:34:08+0200 [-] [caldav-8008] Traceback (most recent call last): 2008-02-23 15:34:08+0200 [-] [caldav-8008] File "/data/src/new/ Twisted/twisted/web2/static.py", line 124, in renderHTTP 2008-02-23 15:34:08+0200 [-] [caldav-8008] d = maybeDeferred(super(StaticRenderMixin, self).renderHTTP, request) 2008-02-23 15:34:08+0200 [-] [caldav-8008] File "/data/src/new/ Twisted/twisted/internet/defer.py", line 107, in maybeDeferred 2008-02-23 15:34:08+0200 [-] [caldav-8008] result = f(*args, **kw) 2008-02-23 15:34:08+0200 [-] [caldav-8008] File "/data/src/new/ Twisted/twisted/web2/resource.py", line 88, in renderHTTP 2008-02-23 15:34:08+0200 [-] [caldav-8008] return method(request) 2008-02-23 15:34:08+0200 [-] [caldav-8008] File "/data/src/new/ Twisted/twisted/internet/defer.py", line 677, in unwindGenerator 2008-02-23 15:34:08+0200 [-] [caldav-8008] return _deferGenerator(f(*args, **kwargs), Deferred()) 2008-02-23 15:34:08+0200 [-] [caldav-8008] --- <exception caught here> --- 2008-02-23 15:34:08+0200 [-] [caldav-8008] File "/data/src/new/ Twisted/twisted/internet/defer.py", line 576, in _deferGenerator 2008-02-23 15:34:08+0200 [-] [caldav-8008] result = g.next() 2008-02-23 15:34:08+0200 [-] [caldav-8008] File "/data/src/new/ Twisted/twisted/web2/dav/method/propfind.py", line 55, in http_PROPFIND 2008-02-23 15:34:08+0200 [-] [caldav-8008] x.getResult() 2008-02-23 15:34:08+0200 [-] [caldav-8008] File "/data/src/new/ Twisted/twisted/internet/defer.py", line 555, in getResult 2008-02-23 15:34:08+0200 [-] [caldav-8008] self.result.raiseException() 2008-02-23 15:34:08+0200 [-] [caldav-8008] File "/data/src/new/ Twisted/twisted/python/failure.py", line 303, in raiseException 2008-02-23 15:34:08+0200 [-] [caldav-8008] raise self.type, self.value, self.tb 2008-02-23 15:34:08+0200 [-] [caldav-8008] exceptions.AttributeError: 'pysqlite2.dbapi2.Connection' object has no attribute 'execute' 2008-02-23 15:34:08+0200 [-] [caldav-8008] Any ideas? Is it a problem with CalendarServer or Twisted? Jaco -- bje@serendipity.org.za the faculty of making fortunate discoveries
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. -- Cyrus Daboo
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
On Mon, Feb 25, 2008 at 11:22:10PM +0000, Jaco Engelbrecht wrote:
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 I'm seeing the same here with the 1.2 branch on Linux. Cheers, -- Guido
participants (3)
-
Cyrus Daboo
-
Guido Günther
-
Jaco Engelbrecht