Previous 1 2 3 4 5 6 Next 88 Replies Latest reply: Mar 26, 2012 5:25 PM by elgringito Go to original post
  • aef5023 Level 1 Level 1 (5 points)

    sudo -u calendar psql -U _postgres caldav

    psql: FATAL:  database "caldav" does not exist

  • aef5023 Level 1 Level 1 (5 points)

    The other commands you asked before show now

    ps aux | grep postgres

    _postgres        727   0.0  0.0  2441124    444   ??  Ss   10:35PM   0:00.01 postgres: stats collector process                          

    _postgres        726   0.0  0.0  2478340   1520   ??  Ss   10:35PM   0:00.01 postgres: autovacuum launcher process                          

    _postgres        725   0.0  0.0  2478208    520   ??  Ss   10:35PM   0:00.03 postgres: wal writer process                          

    _postgres        724   0.0  0.0  2478208    768   ??  Ss   10:35PM   0:00.05 postgres: writer process                          

    _postgres        722   0.0  0.0  2441124    332   ??  Ss   10:35PM   0:00.02 postgres: logger process                          

    _postgres        720   0.0  0.1  2478208   4796   ??  Ss   10:35PM   0:00.15 /usr/bin/postgres_real -D /var/pgsql -c listen_addresses= -c log_connections=on -c log_directory=/Library/Logs -c log_filename=PostgreSQL.log -c log_line_prefix=%t  -c log_lock_waits=on -c log_statement=ddl -c logging_collector=on -c unix_socket_directory=/var/pgsql_socket -c unix_socket_group=_postgres -c unix_socket_permissions=0770

    sharkmin        1016   0.0  0.0  2434892    468 s000  R+   10:41PM   0:00.00 grep postgres

     

    ps aux | grep caldavd

    sharkmin        1018   0.0  0.0  2434892    528 s000  S+   10:41PM   0:00.00 grep caldavd

     

    sudo ls -l /var/pgsql_socket/

    total 8

    srwxrwx---  1 _postgres  _postgres   0 Oct 20 22:35 .s.PGSQL.5432

    -rw-------  1 _postgres  _postgres  15 Oct 20 22:35 .s.PGSQL.5432.lock

     

    => caldavd is still not running

  • mappler Level 1 Level 1 (0 points)

    who can help?

  • Cyrus Daboo Level 2 Level 2 (230 points)

    What do permissions on /var/pgsql and its contents look like?

     

    Clearly postgres is running but not seeing your previous data.

  • mappler Level 1 Level 1 (0 points)

    ls -al /var/pgsql

    total 80

    drwx------  18 _postgres  _postgres    612 Oct 20 22:12 .

    drwxr-xr-x  42 root       wheel       1428 Oct 12 22:56 ..

    -rw-------   1 _postgres  _postgres      4 Oct 12 22:56 PG_VERSION

    drwx------   5 _postgres  _postgres    170 Oct 12 22:57 base

    drwx------  42 _postgres  _postgres   1428 Oct 20 22:13 global

    drwx------   3 _postgres  _postgres    102 Oct 12 22:56 pg_clog

    -rw-------   1 _postgres  _postgres   3939 Oct 12 22:56 pg_hba.conf

    -rw-------   1 _postgres  _postgres   1636 Oct 12 22:56 pg_ident.conf

    drwx------   4 _postgres  _postgres    136 Oct 12 22:56 pg_multixact

    drwx------   3 _postgres  _postgres    102 Oct 20 22:12 pg_notify

    drwx------   3 _postgres  _postgres    102 Oct 21 20:29 pg_stat_tmp

    drwx------   3 _postgres  _postgres    102 Oct 12 22:56 pg_subtrans

    drwx------   2 _postgres  _postgres     68 Oct 12 22:56 pg_tblspc

    drwx------   2 _postgres  _postgres     68 Oct 12 22:56 pg_twophase

    drwx------   4 _postgres  _postgres    136 Oct 12 22:56 pg_xlog

    -rw-------   1 _postgres  _postgres  17935 Oct 12 22:56 postgresql.conf

    -rw-------   1 _postgres  _postgres    385 Oct 20 22:12 postmaster.opts

    -rw-------   1 _postgres  _postgres     37 Oct 20 22:12 postmaster.pid

  • aef5023 Level 1 Level 1 (5 points)

    Yesterday, looking at permissions around postgres and caldavd I found that some of the permissions look really odd (but then I have no experience with Mac OsX system permissions). With subsequent other error messages around caldevd running, I had the hunch that all might be caused by faulty permissions. I am going to run repair permissions and then see what happens.

  • aef5023 Level 1 Level 1 (5 points)

    The permission repair fixed a number of permissions, but things still do not work (even though there are some changes, see below)

     

    Permissions differ on “Library/Server/Calendar and Contacts”; should be drwxr-xr-x ; they are drwxr-x--x .

    Repaired “Library/Server/Calendar and Contacts”

     

    Permissions differ on “private/etc/apache2/httpd.conf”; should be -r--r--r-- ; they are -rw-r--r-- .

    Repaired “private/etc/apache2/httpd.conf”

     

    Nothing remarakble. The Calendar I caused myself to test

     

    caldavd still does not run and aborts with same errors as before

  • mappler Level 1 Level 1 (0 points)

    "repair permissions" does not help.

  • aef5023 Level 1 Level 1 (5 points)

    no, neither with me

  • aef5023 Level 1 Level 1 (5 points)

    my ls -l /var/pgsql looks absolutely identical with mappler's list

  • aef5023 Level 1 Level 1 (5 points)

    subdirectories

     

    /var/pgsql/base:

    total 0

    drwx------  213 _postgres  _postgres  7242 Oct 20 22:20 1

    drwx------  213 _postgres  _postgres  7242 Sep  4 14:37 11866

    drwx------  214 _postgres  _postgres  7276 Oct 21 21:28 11874

     

     

    /var/pgsql/base/1:

    total 10560

    -rw-------  1 _postgres  _postgres  106496 Sep  4 14:37 11581

    -rw-------  1 _postgres  _postgres   24576 Sep  4 14:37 11581_fsm

    .....

    .....

    -rw-------  1 _postgres  _postgres     512 Sep  4 14:37 pg_filenode.map

     

     

    /var/pgsql/base/11866:

    total 10560

    -rw-------  1 _postgres  _postgres  106496 Sep  4 14:37 11581

    ....

    ....

    -rw-------  1 _postgres  _postgres   98532 Oct 21 21:28 pg_internal.init

     

     

    /var/pgsql/global:

    total 880

    -rw-------  1 _postgres  _postgres   8192 Sep  4 14:37 11601

    ....

    ....

    etc., all follow the same scheme. Nowhere is caldav mentioned as name

  • Cyrus Daboo Level 2 Level 2 (230 points)

    Please both of you file bugs on bugreporter.apple.com and include the following:

     

    /var/log/system.log

    /Library/Logs/PostgreSQL.log

    /var/log/caldavd/*

     

    Report back the bug number here.

     

    Also, if you have backups of /var/pgsql from before the upgrade, please compare that (permissions, file sizes etc) with what you currently have.

  • Cyrus Daboo Level 2 Level 2 (230 points)

    Please also check to see if there are other /var/pgsql* directories present.

  • mappler Level 1 Level 1 (0 points)

    /var/pgsql*

     

    drwx------   18 _postgres     _postgres      612 Oct 20 22:12 pgsql

    drwx------   17 _postgres     _postgres      578 Jul 22 01:39 pgsql.pre-restore-2011-07-22_01:39:10_CEST

    drwx------   17 _postgres     _postgres      578 Sep 30 20:10 pgsql.pre-restore-2011-09-30_20:10:02_CEST

    drwx------   17 _postgres     _postgres      578 Oct 12 22:56 pgsql.pre-restore-2011-10-12_22:56:38_CEST

    drwxr-x---    4 _postgres     _postgres      136 Oct 20 22:12 pgsql_socket

  • mappler Level 1 Level 1 (0 points)

    Problem ID: 10296885 

     

    (sorry, posted wrong ID first)

     

    Message was edited by: mappler