[CalendarServer-users] CalendarServer 1.1 and Account information not found - HTTP/1.1 500 Internal Server Error

Mon Feb 25 15:22:10 PST 2008

On 25 Feb 2008, at 19:05, Cyrus Daboo wrote:

> Hi Jaco,
>
> --On February 23, 2008 1:54:35 PM +0000 Jaco Engelbrecht <bje at 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 at serendipity.org.za
the faculty of making fortunate discoveries