Mailing List Archive: freebsd install issue

freebsd install issue

Aug 31, 2010, 3:14 AM

Post #1 of 3 (272 views)

FreeBSD test42.psg.com 8.1-STABLE FreeBSD 8.1-STABLE #10: Sun Aug 8 01:05:24 UTC 2010 root at test42.psg.com:/usr/obj/usr/src/sys/TEST42 amd64
postgresql-client-8.2.17_1
postgresql-server-8.2.17_1
davical-0.9.9

trying to follow the recipe at http://wiki.davical.org/w/FreeBSD

[pgsql at test42 /usr/local/www/davical]$ sh /usr/local/share/doc/davical/dba/create-database.sh
CREATE DATABASE
Supported locales updated.
Updated view: dav_principal.sql applied.
CalDAV functions updated.
RRULE functions updated.
Database permissions updated.
NOTE
====
* You will need to edit the PostgreSQL pg_hba.conf to allow the
'davical_dba' database user access to the 'davical' database.

* You will need to edit the PostgreSQL pg_hba.conf to allow the
'davical_app' database user access to the 'davical' database.

* The password for the 'admin' user has been set to 'foux'"

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

[pgsql at test42 /usr/local/www/davical]$ exit

test42.psg.com:/usr/local/www/davical# psql -U pgsql davical -c "grant all on \
> awl_db_revision, caldav_data, calendar_item, collection, \
> dav_resource, dav_resource_type, freebusy_ticket, \
> group_member, locks, principal, principal_type, privilege, \
> property, relationship, relationship_type, role_member, \
> roles, session, supported_locales, time_zone, tmp_password, \
> usr, usr_setting, dav_id_seq, dav_resource_type_resource_type_id_seq, \
> principal_principal_id_seq, principal_type_principal_type_id_seq, \
> relationship_type_rt_id_seq, roles_role_no_seq, \
> session_session_id_seq, usr_user_no_seq \
> to general;"
ERROR: relation "dav_resource" does not exist

clue bat, please?

randy

Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
rscds-general mailing list
rscds-general at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rscds-general

freebsd install issue [ In reply to ]

andrew at morphoss

Aug 31, 2010, 4:13 AM

Post #2 of 3 (274 views)

Permalink

On Tue, 2010-08-31 at 19:14 +0900, Randy Bush wrote:
> FreeBSD test42.psg.com 8.1-STABLE FreeBSD 8.1-STABLE #10: Sun Aug 8 01:05:24 UTC 2010 root at test42.psg.com:/usr/obj/usr/src/sys/TEST42 amd64
> postgresql-client-8.2.17_1
> postgresql-server-8.2.17_1
> davical-0.9.9
>
> trying to follow the recipe at http://wiki.davical.org/w/FreeBSD
>
> [pgsql at test42 /usr/local/www/davical]$ sh /usr/local/share/doc/davical/dba/create-database.sh
> CREATE DATABASE
> Supported locales updated.
> Updated view: dav_principal.sql applied.
> CalDAV functions updated.
> RRULE functions updated.
> Database permissions updated.
> NOTE
> ====
> * You will need to edit the PostgreSQL pg_hba.conf to allow the
> 'davical_dba' database user access to the 'davical' database.
>
> * You will need to edit the PostgreSQL pg_hba.conf to allow the
> 'davical_app' database user access to the 'davical' database.
>
> * The password for the 'admin' user has been set to 'foux'"
>
> Thanks for trying DAViCal! Check in /usr/share/doc/davical/examples/ for
> some configuration examples. For help, visit #davical on irc.oftc.net.
>
> [pgsql at test42 /usr/local/www/davical]$ exit
>
> test42.psg.com:/usr/local/www/davical# psql -U pgsql davical -c "grant all on \
> > awl_db_revision, caldav_data, calendar_item, collection, \
> > dav_resource, dav_resource_type, freebusy_ticket, \
> > group_member, locks, principal, principal_type, privilege, \
> > property, relationship, relationship_type, role_member, \
> > roles, session, supported_locales, time_zone, tmp_password, \
> > usr, usr_setting, dav_id_seq, dav_resource_type_resource_type_id_seq, \
> > principal_principal_id_seq, principal_type_principal_type_id_seq, \
> > relationship_type_rt_id_seq, roles_role_no_seq, \
> > session_session_id_seq, usr_user_no_seq \
> > to general;"
> ERROR: relation "dav_resource" does not exist
>
> clue bat, please?

Hi Randy,

The dav_resource table was dropped from the database a few versions ago.

I thought there was a port for DAViCal? The instruction to 'grant all
on ...... to general' is pretty dated / scattergun. The create-database
script should do a better job of granting permissions, especially if you
edit the pg_hba.conf file and reload PostgreSQL before you run it.

Cheers,
Andrew.

--
------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
You now have Asian Flu.
------------------------------------------------------------------------

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 836 bytes
Desc: This is a digitally signed message part
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100831/bb518acc/attachment.pgp>
-------------- next part --------------

Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
-------------- next part --------------
_______________________________________________
rscds-general mailing list
rscds-general at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rscds-general

freebsd install issue [ In reply to ]

randy at psg

Aug 31, 2010, 5:51 AM

Post #3 of 3 (269 views)

Permalink

hi andrew,

> The dav_resource table was dropped from the database a few versions
> ago.

so ignore the diagnostic

> I thought there was a port for DAViCal?

yes, that is what i installed per http://wiki.davical.org/w/FreeBSD

> The instruction to 'grant all on ...... to general' is pretty dated /
> scattergun. The create-database script should do a better job of
> granting permissions, especially if you edit the pg_hba.conf file and
> reload PostgreSQL before you run it.

oops! http://wiki.davical.org/w/FreeBSD had it in the opposite order.
so too late.

but ignoring the diag and then applying the shotgun

psql -U pgsql davical -c "grant all on database davical to general;"

got me to the pretty web page!

now to understand groups and users and mac ical calendars and how they
all work together.

thank you!

randy

Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
rscds-general mailing list
rscds-general at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rscds-general