Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: DAViCal: General

relation "time_zone" does not exist on upgrade

 

 

DAViCal general RSS feed   Index | Next | Previous | View Threaded


richm at oldelvet

Sep 28, 2011, 2:41 AM

Post #1 of 1 (368 views)
Permalink
relation "time_zone" does not exist on upgrade

Hi,

I just upgraded to davical 0.9.9.6-1 on Ubuntu and got the following
error message.

WARNING: no privileges were granted for "dav_id_seq"
DBD::Pg::db do failed: ERROR: relation "time_zone" does not exist at
/usr/share/davical/dba/update-davical-database line 400, <PERMS> line 63.

I did a few experiments and is seems to be related to the following
lines in /usr/share/davical/dba/appuser_permissions.txt

GRANT SELECT,INSERT
ON time_zone

The latest database update removes that table but it seems that
appuser_permissions.txt has not been modified to match.

I think that the correct way to fix this is to just remove those lines
from appuser_permissions.txt (or prepend the 2 lines with # to turn them
into non-executable comments).
I tried this and re-ran the database upgrade scripts and it worked for me.

I checked in the project git repository and it doesn't look like that
has been fixed yet
http://repo.or.cz/w/davical.git/blob/HEAD:/dba/appuser_permissions.txt

Obviously please take my "information" with a pinch of salt until
someone who knows the code/database in depth can confirm or suggest an
alternative resolution.

Regards

Richard

P.S. I can see a few similar messages in the davical-general archives
but I can't see a solution in there (I was not subscribed to the list
prior to today so apologies if I missed something).




------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
_______________________________________________
Davical-general mailing list
Davical-general [at] lists
https://lists.sourceforge.net/lists/listinfo/davical-general

DAViCal general RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.