Mailing List Archive: DAViCal: General

Problems getting davical to run (or reinstall)

Index | Next | Previous | View Threaded

john at klam

Jun 13, 2013, 1:35 PM

Post #1 of 3 (127 views)
Permalink

Problems getting davical to run (or reinstall)

Up until recently I had a nicely running davical setup. something
happened, I have checked the logs and I can only assume that there was
an automatic upadte to my Debian testing setup.
As a result my davical stopped working, all sorts of errors on the
davical log. I backed out of the update that might have had some
relevance (a php5 update).
No change so being dumb I purge davical and its dependecies from the
system and reinstalled.
Now I get: the following errors when I try to setup DB. /please can I
have my davical back!!/

postgres [at] bilb:/home/postgres$ /usr/share/davical/dba/create-database.sh

psql:/usr/share/davical/dba/davical.sql:39: ERROR: language "PlPgSQL"
does not exist
psql:/usr/share/davical/dba/davical.sql:65: ERROR: language "PlPgSQL"
does not exist
psql:/usr/share/davical/dba/davical.sql:190: ERROR: function
privilege_to_bits(text[]) does not exist
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
psql:/usr/share/davical/dba/davical.sql:200: ERROR: function
privilege_to_bits(text[]) does not exist
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.

Supported locales updated.
Updated view: dav_principal.sql applied.
CalDAV functions updated.
RRULE functions updated.
DBD::Pg::db do failed: ERROR: relation "relationship" does not exist at
/usr/share/davical/dba/update-davical-database line 400, <PERMS> line 23.
DBD::Pg::db do failed: ERROR: relation "relationship" does not exist at
/usr/share/davical/dba/update-davical-database line 410, <PERMS> line 23.
DBD::Pg::db do failed: ERROR: relation "relationship_type" does not
exist at /usr/share/davical/dba/update-davical-database line 400,
<PERMS> line 35.
DBD::Pg::db do failed: ERROR: relation "relationship_type" does not
exist at /usr/share/davical/dba/update-davical-database line 410,
<PERMS> line 35.
DBD::Pg::db do failed: ERROR: relation "relationship_type_rt_id_seq"
does not exist at /usr/share/davical/dba/update-davical-database line
400, <PERMS> line 53.
DBD::Pg::db do failed: ERROR: relation "relationship_type_rt_id_seq"
does not exist at /usr/share/davical/dba/update-davical-database line
410, <PERMS> line 53.
Database permissions updated.
psql:/usr/share/davical/dba/base-data.sql:30: ERROR: relation
"relationship_type" does not exist
LINE 1: INSERT INTO relationship_type ( rt_id, rt_name, confers, bit...
^
psql:/usr/share/davical/dba/base-data.sql:33: ERROR: relation
"relationship_type" does not exist
LINE 1: INSERT INTO relationship_type ( rt_id, rt_name, confers, bit...
^
psql:/usr/share/davical/dba/base-data.sql:36: ERROR: relation
"relationship_type" does not exist
LINE 1: INSERT INTO relationship_type ( rt_id, rt_name, confers, bit...
^
psql:/usr/share/davical/dba/base-data.sql:39: ERROR: relation
"relationship_type" does not exist
LINE 1: INSERT INTO relationship_type ( rt_id, rt_name, confers, bit...
^
psql:/usr/share/davical/dba/base-data.sql:43: ERROR: relation
"relationship_type" does not exist
LINE 1: ...pe_rt_id_seq', (SELECT 10 UNION SELECT rt_id FROM relationsh...
^
NOTE
====
* The password for the 'admin' user has been set to 'tTALQipU'

Thanks for trying DAViCal! Check in /usr/share/doc/davical/examples/ for
some configuration examples. For help, visit #davical on irc.oftc.net.

postgres [at] bilb:/home/postgres$

rdk at krupczak

Jun 13, 2013, 2:30 PM

Post #2 of 3 (119 views)
Permalink

Re: Problems getting davical to run (or reinstall) [In reply to]

Hi!

I ran into similar problems; I got davical working on a test system
and by the time I went to install on a production system, all was
broken.

I traced the errors back to an "upgrade" in Postgres and
case-sensitivity changes they made (in their infinite wisdom). That
is, starting with Postgres 9.2, they no longer downcase quoted
language expressions and it broke a lot of the DAVIcal code. I've
emailed the mailing list to say what the fix is and which versions of
postgres.

I found this item in the postgres 9.2 release notes:

No longer forcibly lowercase procedural language names in CREATE
FUNCTION (Robert Haas)

While unquoted language identifiers are still lowercased, strings
and quoted identifiers are no longer forcibly down-cased. Thus for
example CREATE FUNCTION ... LANGUAGE 'C' will no longer work; it
must be spelled 'c', or better omit the quotes.

http://www.postgresql.org/docs/9.2/interactive/release-9-2.html

Changing all instances of LANGUAGE 'SQL' to LANGUAGE 'sql' did the
trick and now davical works with my postgres 9.2.x DB.

Yuck! I'm guessing Postgres guys broke a lot of code with this subtle
change.

Bobby

> Up until recently I had a nicely running davical setup. something
> happened, I have checked the logs and I can only assume that there was
> an automatic upadte to my Debian testing setup.
> As a result my davical stopped working, all sorts of errors on the
> davical log. I backed out of the update that might have had some
> relevance (a php5 update).
> No change so being dumb I purge davical and its dependecies from the
> system and reinstalled.
> Now I get: the following errors when I try to setup DB. please can I
> have my davical back!!
> postgres [at] bilb:/home/postgres$
> /usr/share/davical/dba/create-database.sh
> psql:/usr/share/davical/dba/davical.sql:39: ERROR: language "PlPgSQL"
> does not exist
> psql:/usr/share/davical/dba/davical.sql:65: ERROR: language "PlPgSQL"
> does not exist

------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
_______________________________________________
Davical-general mailing list
Davical-general [at] lists
https://lists.sourceforge.net/lists/listinfo/davical-general

john at klam

Jun 13, 2013, 8:58 PM

Post #3 of 3 (123 views)
Permalink

Re: Problems getting davical to run (or reinstall) [In reply to]

Thank you, I backed out of the PostgreSQL-9.3 to PostgreSQL-9.1 and that
fixed the problem.

It would have been nice if they had provided a "compatibility" switch of
some sort.
How much work is involved in bring davical in line with the latest
PostgreSQL,?
Do you know if its already being worked on?

Once again for the help!!
John A

> Hi!
>
> I ran into similar problems; I got davical working on a test system
> and by the time I went to install on a production system, all was
> broken.
>
> I traced the errors back to an "upgrade" in Postgres and
> case-sensitivity changes they made (in their infinite wisdom). That
> is, starting with Postgres 9.2, they no longer downcase quoted
> language expressions and it broke a lot of the DAVIcal code. I've
> emailed the mailing list to say what the fix is and which versions of
> postgres.
>
> I found this item in the postgres 9.2 release notes:
>
> No longer forcibly lowercase procedural language names in CREATE
> FUNCTION (Robert Haas)
>
> While unquoted language identifiers are still lowercased, strings
> and quoted identifiers are no longer forcibly down-cased. Thus for
> example CREATE FUNCTION ... LANGUAGE 'C' will no longer work; it
> must be spelled 'c', or better omit the quotes.
>
> http://www.postgresql.org/docs/9.2/interactive/release-9-2.html
>
> Changing all instances of LANGUAGE 'SQL' to LANGUAGE 'sql' did the
> trick and now davical works with my postgres 9.2.x DB.
>
> Yuck! I'm guessing Postgres guys broke a lot of code with this subtle
> change.
>
> Bobby
>
>> Up until recently I had a nicely running davical setup. something
>> happened, I have checked the logs and I can only assume that there was
>> an automatic upadte to my Debian testing setup.
>> As a result my davical stopped working, all sorts of errors on the
>> davical log. I backed out of the update that might have had some
>> relevance (a php5 update).
>> No change so being dumb I purge davical and its dependecies from the
>> system and reinstalled.
>> Now I get: the following errors when I try to setup DB. please can I
>> have my davical back!!
>> postgres [at] bilb:/home/postgres$
>> /usr/share/davical/dba/create-database.sh
>> psql:/usr/share/davical/dba/davical.sql:39: ERROR: language "PlPgSQL"
>> does not exist
>> psql:/usr/share/davical/dba/davical.sql:65: ERROR: language "PlPgSQL"
>> does not exist

------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
_______________________________________________
Davical-general mailing list
Davical-general [at] lists
https://lists.sourceforge.net/lists/listinfo/davical-general

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads