309692 - Unable to create calendars and events as non-privileged user.

Status: RESOLVED INVALID

(Calendar :: Provider: Local Storage, defect)

Description

[Andy Spencer]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8b4) Gecko/20050908 Firefox/1.4
Build Identifier: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9a1) Gecko/20050920 Mozilla Sunbird/0.2+

Sunbird starts and works fine as root, but as an unpriviledged user it starts,
but no calendars are created and no events or calenders can be added once in the
GUI. I think this is a problem with sqlite but I'm not sure. It should no be a
file premission problem because I chmod'd my ~/.mozilla/sunbird and the sunbird
install  directories to 777. 

Reproducible: Always

Steps to Reproduce:
Start sunbird as an unpriviledged user.
(note: I'm new to sunbird so initially I did not have a ~/.mozilla/sunbird
directory, and the install directory is just the extracted developer build
tarball. I also did a cvs build and ran it from the objects/dist/bin directory
and had the same problem).
Actual Results:  
Sunbird starts normally but I am unable to add calendars or events.

Expected Results:  
Let me add stuff. 

A screenshot of the javascript console is avaliable here
http://137.112.142.179/other_files/sunbird_error.png.

Comment 1

[Andy Spencer]

==More information==
I checked out the cvs for sunbird and compiled it myself. I also went through
trying to debug it to see if I could figure out what was wrong with it myself.
Obvisouly I was unsuccessful but I did get some information that should save you
guys some time.

The probelem initially seemed to be comming from

mozStorageConnection.cpp 184: mozStorageConnection::CreateStatement

I looked there and traced it to 
   mozStorageConnection.cpp 194: nsresult rv = statement->Initialize (this,
aSQLStatement);
      (NS_FAILED(rv) returnes true and causes an error)

then from 
   mozStorageStatement.cpp 92: mozStorageStatement::Initialize.. 
to
   prepare.c 117: srv = sqlite3_prepare (...
      ((srv != SQLITE_SCHEMA && srv != SQLITE_OK) returns true)

then from
   prepare.c 412: int sqlite3_prepare(
to 
   prepare.c 435: sqlite3RunParser(&sParse, zSql, &zErrMsg);
      (sqlite3RunParser sets zErrMsg to "database is locked")

then from 
   tokenize.c 330: int sqlite3RunParser
to
   tokenize.c 387: sqlite3Parser( 
      (sqlite3Parser sets pParse->rc to != SQLITE_OK, this causes it to 'goto
abort_parse;')

After that it went to 
   parse.c 3226: void sqlite3Parser(
and I got confused with all the yy stuff so I decided to post here and see if
anyone else knows how to fix it. 

Comment 2

[Calum Mackay]

No problem when using current trunk build, at least for me.

Have you tried *not* running it as root, first? I'm wondering if, when the first run is done as root, it will break for normal users after. I've seen this before with mozilla years ago.

Comment 3

[Andy Spencer]

I think it was a mount problem, After I tryed installing it on a different partition it seemed to work, I'm not sure why though.