Author Topic: Davical and calendar  (Read 4614 times)

Offline pvassalli

  • Newbie
  • *
  • Posts: 2
Davical and calendar
« on: August 17, 2012, 11:17:05 AM »
Hi everybody. I'm trying to implement the calendar plugin inside my roundcube server.
The backend I'm using is davical, since for a long time we've been using it as our cal server.
Right now, i've installed the plugin, copyed the default conf from config.inc.php.dist and executed the SQL script from SQL dir of calendar.
Well, the first thing is that I get a lot of errors in SQL:
Code: [Select]
psql:/var/www/plugins/calendar/SQL/postgres.sql:33: NOTICE:  CREATE TABLE will create implicit sequence "events_event_id_seq" for serial column "events.event_id"
psql:/var/www/plugins/calendar/SQL/postgres.sql:33: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "events_pkey" for table "events"
psql:/var/www/plugins/calendar/SQL/postgres.sql:33: ERROR:  relation "users" does not exist
psql:/var/www/plugins/calendar/SQL/postgres.sql:34: ERROR:  relation "events" does not exist
psql:/var/www/plugins/calendar/SQL/postgres.sql:67: NOTICE:  CREATE TABLE will create implicit sequence "events_cache_event_id_seq" for serial column "events_cache.event_id"
psql:/var/www/plugins/calendar/SQL/postgres.sql:67: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "events_cache_pkey" for table "events_cache"
psql:/var/www/plugins/calendar/SQL/postgres.sql:67: ERROR:  relation "users" does not exist
psql:/var/www/plugins/calendar/SQL/postgres.sql:68: ERROR:  relation "events_cache" does not exist
psql:/var/www/plugins/calendar/SQL/postgres.sql:101: NOTICE:  CREATE TABLE will create implicit sequence "events_caldav_event_id_seq" for serial column "events_caldav.event_id"
psql:/var/www/plugins/calendar/SQL/postgres.sql:101: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "events_caldav_pkey" for table "events_caldav"
psql:/var/www/plugins/calendar/SQL/postgres.sql:101: ERROR:  relation "users" does not exist
psql:/var/www/plugins/calendar/SQL/postgres.sql:102: ERROR:  relation "events_caldav" does not exist
psql:/var/www/plugins/calendar/SQL/postgres.sql:114: NOTICE:  CREATE TABLE will create implicit sequence "reminders_reminder_id_seq" for serial column "reminders.reminder_id"
psql:/var/www/plugins/calendar/SQL/postgres.sql:114: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "reminders_pkey" for table "reminders"
psql:/var/www/plugins/calendar/SQL/postgres.sql:114: ERROR:  relation "users" does not exist
The second is that I get an error connection to database.
I use davical version 1.1.1-1, postgresql 8.4.12-0ubuntu10.04.
In calendar preferences everything is properly configured. If I try to access to the calendar caldav backend I get the ics file.
What should I do?
In the end I can't find any kind of log for the calendar and I can't enable it...  ::)

Offline pvassalli

  • Newbie
  • *
  • Posts: 2
Re: Davical and calendar
« Reply #1 on: September 03, 2012, 09:57:42 AM »
Ok, I've understood: the SQL script must be executed on mysql roundcube installation and not on davical/postgres db.
It's not so clear in the documentation.
Please add this over there.