Hi Devs!
i recently found a problem in DaviCal 0.9.9.4 on Debian Lenny when i try
to add my first user(principal) to a all new fresh database. Then
DaviCal throws out a SQL Error on its Webinterface (details later).
I searched Internet already and asked IRC for that, but no luck yet. i
also did not found any bugreporting tool somewhere.
So i guess the DEV Mailing list should be a good start to report in.
The Problem is ALWAYS reproducable. The Error-Message thrown is always
the same. However the Results within the database seems to be not always
the same. Here is what ive done:
1. installed fresh debian lenny, followed all the instructions on the
Davical website for a debian installation.
2. where it comes to the point to creat the davical database by entering
"su postgres -c /usr/share/davical/dba/create-database.sh" it works fine
and i retrieve my admins password.
3. i then log in to the webinterface as "admin" using that password.
Anything looks fine yet.
4. trying to add my first principal(user) to the database using the
webinterface: i enter a username like "testuser1", password "1234",
Displayname "testuser1" , entering some email Adress, defining some
permissions to "All Users" (BTW: the ALL button is NOT WORKING AT ALL!
Any other preset-Button seems to work as expected). So i klick on
READ/WRITE and add view more permissions as i want them. Then i click on
CREATE and receive the following Error Screen in some BROWN block near
top of the screen:
* ERROR: SQL error "23505" - ERROR: duplicate key value violates
unique constraint "principal_pkey""
* Home calendar added.
The User HAS NOT BEEN CREATED! Nothing will be displayed in "list users"
, "list groups", "list resources".
5. i now repeat the same thing at 4. and this time IT WILL WORK. But as
you can see within the database itself, it somehow "skipped" an user-id
in some tables.
Also i once had a case where in some tables it created some strange
"half baked entry" with no username in it, but registered an ID and
password. realy strange!
btw: this is my config file atm:
<?php
$c->admin_email = 'mail at awerner.homeip.net';
$c->system_name = "10.230.20.80 - TEST AW DAViCal CalDAV Server";
$c->enable_row_linking = true;
$c->default_locale = de_DE.UTF-8;
$c->pg_connect[] = 'dbname=davical user=davical_app';
6. i can reproduce this by dropping the davical database and recreating
it. appears every time!
So again in short: this may be TWO SEPERATE BUGS. The Problem with the
ALL Button at Permissions, and the Problem adding the first user to the
database.
Hope this helps.
best regards
Axel
i recently found a problem in DaviCal 0.9.9.4 on Debian Lenny when i try
to add my first user(principal) to a all new fresh database. Then
DaviCal throws out a SQL Error on its Webinterface (details later).
I searched Internet already and asked IRC for that, but no luck yet. i
also did not found any bugreporting tool somewhere.
So i guess the DEV Mailing list should be a good start to report in.
The Problem is ALWAYS reproducable. The Error-Message thrown is always
the same. However the Results within the database seems to be not always
the same. Here is what ive done:
1. installed fresh debian lenny, followed all the instructions on the
Davical website for a debian installation.
2. where it comes to the point to creat the davical database by entering
"su postgres -c /usr/share/davical/dba/create-database.sh" it works fine
and i retrieve my admins password.
3. i then log in to the webinterface as "admin" using that password.
Anything looks fine yet.
4. trying to add my first principal(user) to the database using the
webinterface: i enter a username like "testuser1", password "1234",
Displayname "testuser1" , entering some email Adress, defining some
permissions to "All Users" (BTW: the ALL button is NOT WORKING AT ALL!
Any other preset-Button seems to work as expected). So i klick on
READ/WRITE and add view more permissions as i want them. Then i click on
CREATE and receive the following Error Screen in some BROWN block near
top of the screen:
* ERROR: SQL error "23505" - ERROR: duplicate key value violates
unique constraint "principal_pkey""
* Home calendar added.
The User HAS NOT BEEN CREATED! Nothing will be displayed in "list users"
, "list groups", "list resources".
5. i now repeat the same thing at 4. and this time IT WILL WORK. But as
you can see within the database itself, it somehow "skipped" an user-id
in some tables.
Also i once had a case where in some tables it created some strange
"half baked entry" with no username in it, but registered an ID and
password. realy strange!
btw: this is my config file atm:
<?php
$c->admin_email = 'mail at awerner.homeip.net';
$c->system_name = "10.230.20.80 - TEST AW DAViCal CalDAV Server";
$c->enable_row_linking = true;
$c->default_locale = de_DE.UTF-8;
$c->pg_connect[] = 'dbname=davical user=davical_app';
6. i can reproduce this by dropping the davical database and recreating
it. appears every time!
So again in short: this may be TWO SEPERATE BUGS. The Problem with the
ALL Button at Permissions, and the Problem adding the first user to the
database.
Hope this helps.
best regards
Axel