Mailing List Archive

I have installed awl 0.42 and davical 0.9.8.4. I followed the installation instructions, but when I load the website, I get nothing but a blank page.
So far I have found it neccassary to comment out the line
"local all all ident"
in addition of adding the user entries in pg_hba.conf.

Are there any things I can try to troubleshoot what exactly is going wrong?



This is the apache log file:

[Sat Apr 03 01:05:37 2010] [error] [client 10.8.0.122] davical: LOG: :==========> method =GET= =http://192.168.10.246/upgrade.php= == == =/usr/share/davical=
[Sat Apr 03 01:05:37 2010] [error] [client 10.8.0.122] davical: ALL: I18N:Set locale to =de_DE=


This is the postgres log file after running the create-database.sh script:

2010-04-03 00:54:28 CEST davical davical_dba ERROR: function rename_davical_user(text, text) does not exist
2010-04-03 00:54:28 CEST davical davical_dba STATEMENT: DROP FUNCTION rename_davical_user( TEXT, TEXT );
2010-04-03 00:54:28 CEST davical davical_dba ERROR: trigger "usr_modified" for table "usr" does not exist
2010-04-03 00:54:28 CEST davical davical_dba STATEMENT: DROP TRIGGER usr_modified ON usr CASCADE;
2010-04-03 00:54:28 CEST davical davical_dba ERROR: trigger "collection_modified" for table "collection" does not exist
2010-04-03 00:54:28 CEST davical davical_dba STATEMENT: DROP TRIGGER collection_modified ON collection CASCADE;
2010-04-03 00:54:28 CEST davical davical_dba ERROR: trigger "caldav_data_modified" for table "caldav_data" does not exist
2010-04-03 00:54:28 CEST davical davical_dba STATEMENT: DROP TRIGGER caldav_data_modified ON caldav_data CASCADE;
2010-04-03 00:54:28 CEST davical davical_dba ERROR: trigger "calendar_item_sync_dav_id" for table "calendar_item" does not exist
2010-04-03 00:54:28 CEST davical davical_dba STATEMENT: DROP TRIGGER calendar_item_sync_dav_id ON calendar_item CASCADE;
2010-04-03 00:54:28 CEST davical davical_dba ERROR: trigger "principal_modified" for table "principal" does not exist
2010-04-03 00:54:28 CEST davical davical_dba STATEMENT: DROP TRIGGER principal_modified ON principal CASCADE;
2010-04-03 00:54:28 CEST davical davical_dba ERROR: trigger "grants_modified" for table "grants" does not exist
2010-04-03 00:54:28 CEST davical davical_dba STATEMENT: DROP TRIGGER grants_modified ON grants CASCADE;
2010-04-03 00:54:28 CEST davical davical_dba ERROR: type "rrule_parts" does not exist
2010-04-03 00:54:28 CEST davical davical_dba STATEMENT: /**
* PostgreSQL Functions for RRULE handling
*
* @package rscds
* @subpackage database
* @author Andrew McMillan <andrew at morphoss.com>
* @copyright Morphoss Ltd - http://www.morphoss.com/
* @license http://gnu.org/copyleft/gpl.html GNU GPL v2 or later
*
* Coverage of this function set
* - COUNT & UNTIL are handled, generally
* - DAILY frequency, including BYDAY, BYMONTH, BYMONTHDAY, BYWEEKNO, BYMONTHDAY
* - WEEKLY frequency, including BYDAY, BYMONTH, BYMONTHDAY, BYWEEKNO, BYSETPOS
* - MONTHLY frequency, including BYDAY, BYMONTH, BYSETPOS
* - YEARLY frequency, including BYMONTH, BYMONTHDAY, BYSETPOS, BYDAY
*
* Not covered as yet
* - DAILY: BYYEARDAY, BYSETPOS*
* - WEEKLY: BYYEARDAY
* - MONTHLY: BYYEARDAY, BYMONTHDAY, BYWEEKNO
* - YEARLY: BYYEARDAY
* - SECONDLY
* - MINUTELY
* - HOURLY
*
*/

DROP TYPE rrule_parts CASCADE;
2010-04-03 00:54:28 CEST davical davical_dba ERROR: type "rrule_instance" does not exist
2010-04-03 00:54:28 CEST davical davical_dba STATEMENT: DROP TYPE rrule_instance CASCADE;
2010-04-03 00:57:12 CEST postgres postgres ERROR: database "davical" already exists
2010-04-03 00:57:12 CEST postgres postgres STATEMENT: CREATE DATABASE davical OWNER davical_dba ENCODING 'UTF8' TEMPLATE template0;

On 03.04.2010, at 01:26, Michael Rasmussen wrote:

> On Sat, 3 Apr 2010 00:46:59 +0200
> Michael Thalmann <michael.thalmann at pxmimages.com> wrote:
>
>>
>> Are there any things I can try to troubleshoot what exactly is going wrong?
>>
> Have you created the database schema?
> You must run the following script: create-database.sh


Yes, and this is what I get from the postgres logfile:

2010-04-03 02:14:57 CEST davical davical_dba ERROR: view "dav_principal" does not exist
2010-04-03 02:14:57 CEST davical davical_dba STATEMENT: DROP VIEW dav_principal CASCADE;
2010-04-03 02:14:57 CEST davical davical_dba ERROR: function rename_davical_user(text, text) does not exist
2010-04-03 02:14:57 CEST davical davical_dba STATEMENT: DROP FUNCTION rename_davical_user( TEXT, TEXT );
2010-04-03 02:14:57 CEST davical davical_dba ERROR: trigger "usr_modified" for table "usr" does not exist
2010-04-03 02:14:57 CEST davical davical_dba STATEMENT: DROP TRIGGER usr_modified ON usr CASCADE;
2010-04-03 02:14:57 CEST davical davical_dba ERROR: trigger "collection_modified" for table "collection" does not exist
2010-04-03 02:14:57 CEST davical davical_dba STATEMENT: DROP TRIGGER collection_modified ON collection CASCADE;
2010-04-03 02:14:57 CEST davical davical_dba ERROR: trigger "caldav_data_modified" for table "caldav_data" does not exist
2010-04-03 02:14:57 CEST davical davical_dba STATEMENT: DROP TRIGGER caldav_data_modified ON caldav_data CASCADE;
2010-04-03 02:14:57 CEST davical davical_dba ERROR: trigger "calendar_item_sync_dav_id" for table "calendar_item" does not exist
2010-04-03 02:14:57 CEST davical davical_dba STATEMENT: DROP TRIGGER calendar_item_sync_dav_id ON calendar_item CASCADE;
2010-04-03 02:14:57 CEST davical davical_dba ERROR: trigger "principal_modified" for table "principal" does not exist
2010-04-03 02:14:57 CEST davical davical_dba STATEMENT: DROP TRIGGER principal_modified ON principal CASCADE;
2010-04-03 02:14:57 CEST davical davical_dba ERROR: trigger "grants_modified" for table "grants" does not exist
2010-04-03 02:14:57 CEST davical davical_dba STATEMENT: DROP TRIGGER grants_modified ON grants CASCADE;
2010-04-03 02:14:57 CEST davical davical_dba ERROR: type "rrule_parts" does not exist
2010-04-03 02:14:57 CEST davical davical_dba STATEMENT: /**
* PostgreSQL Functions for RRULE handling
*
* @package rscds
* @subpackage database
* @author Andrew McMillan <andrew at morphoss.com>
* @copyright Morphoss Ltd - http://www.morphoss.com/
* @license http://gnu.org/copyleft/gpl.html GNU GPL v2 or later
*
* Coverage of this function set
* - COUNT & UNTIL are handled, generally
* - DAILY frequency, including BYDAY, BYMONTH, BYMONTHDAY, BYWEEKNO, BYMONTHDAY
* - WEEKLY frequency, including BYDAY, BYMONTH, BYMONTHDAY, BYWEEKNO, BYSETPOS
* - MONTHLY frequency, including BYDAY, BYMONTH, BYSETPOS
* - YEARLY frequency, including BYMONTH, BYMONTHDAY, BYSETPOS, BYDAY
*
* Not covered as yet
* - DAILY: BYYEARDAY, BYSETPOS*
* - WEEKLY: BYYEARDAY
* - MONTHLY: BYYEARDAY, BYMONTHDAY, BYWEEKNO
* - YEARLY: BYYEARDAY
* - SECONDLY
* - MINUTELY
* - HOURLY
*
*/

DROP TYPE rrule_parts CASCADE;
2010-04-03 02:14:57 CEST davical davical_dba ERROR: type "rrule_instance" does not exist
2010-04-03 02:14:57 CEST davical davical_dba STATEMENT: DROP TYPE rrule_instance CASCADE;

After investigating more, I found that at least this is where the php stumbles:

In always.php the function init_gettext of AWL is called. The code stops by the line:

....
bindtextdomain( $domain, $location );
....

I am a little bit stuck, because this semms to be a standard php function. Even replacing this by
...
bindtextdomain( "davical", "/usr/share/davical/locale" );
...
has no efffect. I dont see any output of in the webbrowser.


Again, this is the apache logfile:

[Sat Apr 03 03:10:35 2010] [error] [client 10.8.0.122] davical: LOG: :==========> method =GET= =http://192.168.10.246= == == =/usr/share/davical=
[Sat Apr 03 03:10:35 2010] [error] [client 10.8.0.122] davical: ALL: I18N:Set locale to =de_DE=

Any suggestions?

On Sat, 3 Apr 2010 02:16:45 +0200
Michael Thalmann <michael.thalmann at pxmimages.com> wrote:

> After investigating more, I found that at least this is where the php stumbles:
>
> In always.php the function init_gettext of AWL is called. The code stops by the line:
>
> ...
> bindtextdomain( $domain, $location );
> ...
>
> Any suggestions?
what is the state of your php-cli installation?
Can you run a php script from the command line?

--
Hilsen/Regards
Michael Rasmussen

Get my public GnuPG keys:
michael <at> rasmussen <dot> cc
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xD3C9A00E
mir <at> datanom <dot> net
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE501F51C
mir <at> miras <dot> org
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE3E80917
--------------------------------------------------------------
Make it clear before you make it faster.
- The Elements of Programming Style (Kernighan & Plaugher)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100403/4dc788d1/attachment.pgp>
-------------- next part --------------

On 03.04.2010, at 02:31, Michael Rasmussen wrote:

> On Sat, 3 Apr 2010 02:16:45 +0200
> Michael Thalmann <michael.thalmann at pxmimages.com> wrote:
>
>> After investigating more, I found that at least this is where the php stumbles:
>>
>> In always.php the function init_gettext of AWL is called. The code stops by the line:
>>
>> ...
>> bindtextdomain( $domain, $location );
>> ...
>>
>> Any suggestions?
> what is the state of your php-cli installation?
> Can you run a php script from the command line?


I am not sure what you meant, but phpinfo is giving me some output. Actually I tested where the page stopped by inserting phpinfo() into the code.
I installed nearly all php5 modules which are available by SuSE, and now it works. At least the admin interface is working.

So here are some additions to the install doc for SuSE users:

a) Install all php modules.
b) run make after unpacking awl and davical in their directory - although quite obvious, I didnt expect that for an php script.
c) Comment out the line
"local all all ident"
in addition of adding the user entries in pg_hba.conf.


Thanks, Michael for your help!

On Sat, 2010-04-03 at 02:16 +0200, Michael Thalmann wrote:
> After investigating more, I found that at least this is where the php stumbles:
>
> In always.php the function init_gettext of AWL is called. The code stops by the line:
>
> ....
> bindtextdomain( $domain, $location );
> ....
>
> I am a little bit stuck, because this semms to be a standard php function. Even replacing this by
> ...
> bindtextdomain( "davical", "/usr/share/davical/locale" );
> ...
> has no efffect. I dont see any output of in the webbrowser.

Is it possible that your PHP was built without gettext support? Or that
the gettext module was not loaded by php.ini ?

Also, regarding your need to remove a line from pg_hba.conf: it sounds
like you may have added your line to the bottom of pg_hba.conf, rather
than at the top, as the documentation states.

When processing pg_hba.conf, PostgreSQL starts at the top and when it
finds an applicable rule it stops processing. This means that broad
catch-all rules should be at the bottom, and narrow specific case rules
should be above them.

Regards,
Andrew.

------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
Artistic ventures highlighted. Rob a museum.
------------------------------------------------------------------------

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

On Sat, 03 Apr 2010 16:51:15 +1300
Andrew McMillan <andrew at morphoss.com> wrote:

>
> Is it possible that your PHP was built without gettext support? Or that
> the gettext module was not loaded by php.ini ?
>
spot on.
http://rpm.pbone.net/index.php3/stat/3/srodzaj/1/search/php-gettext
php5-gettext-5.3.0-2.4.3.x86_64.rpm
php5-gettext-5.3.0-2.4.3.i586.rpm

In Suse's php5 gettext is an optional install. Most other distributions
has gettext support built-in as part of the basic installation.

There is two ways to design a system, Suse's way and the rest:-)

--
Hilsen/Regards
Michael Rasmussen

Get my public GnuPG keys:
michael <at> rasmussen <dot> cc
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xD3C9A00E
mir <at> datanom <dot> net
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE501F51C
mir <at> miras <dot> org
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE3E80917
--------------------------------------------------------------
Few things are harder to put up with than the annoyance of a good
example. -- "Mark Twain, Pudd'nhead Wilson's Calendar"
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100403/3809f134/attachment.pgp>
-------------- next part --------------

On 04/03/2010 10:48 AM, Michael Rasmussen wrote:
> On Sat, 03 Apr 2010 16:51:15 +1300
> Andrew McMillan <andrew at morphoss.com> wrote:
>
>>
>> Is it possible that your PHP was built without gettext support? Or that
>> the gettext module was not loaded by php.ini ?
>>
> spot on.
> http://rpm.pbone.net/index.php3/stat/3/srodzaj/1/search/php-gettext
> php5-gettext-5.3.0-2.4.3.x86_64.rpm
> php5-gettext-5.3.0-2.4.3.i586.rpm
>
> In Suse's php5 gettext is an optional install. Most other distributions
> has gettext support built-in as part of the basic installation.
>
> There is two ways to design a system, Suse's way and the rest:-)
>

It's not the exclusive openSUSE's way. Each modern distro (debina,ubuntu,fedora,mandriva,etc), have made each php extension as
an extension and a separated package, with it's own .ini.
So you have to choose and install only what you need. afterall it's your admin job.

The big question is why didn't you use the rpm available and made by Andrew.
They are working like a charm ( using davical from 3 years now on differents openSUSE version 10.3 to 11.2 )
Plus normally, using your package manager would resolve dependencies.
(Not yet the case for php5 & modules like gettext, pgsql, pdo )
but list correctly for perl)



--

Bruno Friedmann

Ioda-Net S?rl
2830 Vellerat - Switzerland
www.ioda-net.ch

On Sat, 03 Apr 2010 11:10:08 +0200
Bruno Friedmann <bruno at ioda-net.ch> wrote:

>
> It's not the exclusive openSUSE's way. Each modern distro (debina,ubuntu,fedora,mandriva,etc), have made each php extension as
> an extension and a separated package, with it's own .ini.
> So you have to choose and install only what you need. afterall it's your admin job.
True for most extensions, but not for gettext. At least not for Debian,
Ubuntu, Mint, Arch, Redhat, Fedora, Slackware, Open Solaris and CentOS,
but it is true for *BSD.

In that light I would say that Suse has chosen another path than all
other GNU/Linux distributions. It could seem like Suse is more BSD like
while the rest are following the SYSV way.

--
Hilsen/Regards
Michael Rasmussen

Get my public GnuPG keys:
michael <at> rasmussen <dot> cc
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xD3C9A00E
mir <at> datanom <dot> net
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE501F51C
mir <at> miras <dot> org
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE3E80917
--------------------------------------------------------------
Take care to branch the right way on equality.
- The Elements of Programming Style (Kernighan & Plaugher)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100403/47fd11b3/attachment-0001.pgp>
-------------- next part --------------

On 03.04.2010, at 11:10, Bruno Friedmann wrote:
>
> The big question is why didn't you use the rpm available and made by
> Andrew.
> They are working like a charm ( using davical from 3 years now on
> differents openSUSE version 10.3 to 11.2 )


Actually, I used the RPM's in the first place. Only after not working
as expected, I read that the rpm-packages were converted from deb
packages, so I gave the tarballs a try.

Thanks again for the help to all of you.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100405/f7b0d69e/attachment.htm>
-------------- next part --------------