Mailing List Archive: users duplicating themselves?

users duplicating themselves?

Jul 19, 2010, 2:37 AM

Post #1 of 4 (328 views)

I've run into an interesting problem with my davical 0.9.9 (centos 5, users
via ldap) server in the last week. Users are somehow getting
duplicated and in some cases I've seen 200+ entries for a single username
occur. I've deleted that principal and manually cleaned up the database
as best I could but it then starts occurring with another user. (always
seems to be users logging in for the first time and having their ldap
settings imported but then davical continues to import them again and
again). So I get a bunch of principals with different ids but the same
username and other details

The most relevant thing I've managed to find in the logs is;
(for privacy reasons I've replaced the real username with bsmith etc)

[Mon Jul 19 18:27:54 2010] [error] [client 192.168.117.112] DAViCal: LOG:
Login: Query: Error: QF in '/usr/share/davical/inc/auth-functions.php' on
line 119
[Mon Jul 19 18:27:54 2010] [error] [client 192.168.117.112] DAViCal: LOG:
Login: Query: QF: SQL error "23505" - ERROR: duplicate key value violates
unique constraint "usr_sk1_unique_username""
[Mon Jul 19 18:27:54 2010] [error] [client 192.168.117.112] DAViCal: LOG:
Login: Query: Error: QF in '/usr/share/davical/inc/auth-functions.php' on
line 119
[Mon Jul 19 18:27:54 2010] [error] [client 192.168.117.112] DAViCal: LOG:
Login: Query: QF: INSERT INTO usr (user_no, updated, username, fullname,
email) VALUES( 3184, '2009-04-14 02:22:53'::timestamptz, 'bsmith', 'Bob
Smith', 'bsmith at example.com <csprenger at wetafx.co.nz>' );
[Mon Jul 19 18:27:54 2010] [error] [client 192.168.117.112] PHP Notice:
Trying to get property of non-object in
/usr/share/davical/inc/auth-functions.php on line 42
[Mon Jul 19 18:27:54 2010] [error] [client 192.168.117.112] PHP Notice:
Trying to get property of non-object in
/usr/share/davical/inc/auth-functions.php on line 46
[Mon Jul 19 18:27:54 2010] [error] [client 192.168.117.112] PHP Notice:
Trying to get property of non-object in
/usr/share/davical/inc/auth-functions.php on line 50
[Mon Jul 19 18:27:54 2010] [error] [client 192.168.117.112] PHP Notice:
Undefined property: HTTPAuthSession::$principal_id in
/usr/share/davical/inc/DAVResource.php on line 322
[Mon Jul 19 18:27:54 2010] [error] [client 192.168.117.112] PHP Notice:
Undefined property: HTTPAuthSession::$principal_id in
/usr/share/davical/inc/DAVResource.php on line 322
[Mon Jul 19 18:27:54 2010] [error] [client 192.168.117.112] PHP Notice:
Undefined property: HTTPAuthSession::$principal_id in
/usr/share/davical/inc/DAVResource.php on line 322
[Mon Jul 19 18:27:54 2010] [error] [client 192.168.117.112] DAViCal: LOG:
Login: Query: Error: QF in '/usr/share/davical/inc/auth-functions.php' on
line 119
[Mon Jul 19 18:27:54 2010] [error] [client 192.168.117.112] DAViCal: LOG:
Login: Query: QF: SQL error "23505" - ERROR: duplicate key value violates
unique constraint "usr_sk1_unique_username""
[Mon Jul 19 18:27:54 2010] [error] [client 192.168.117.112] DAViCal: LOG:
Login: Query: Error: QF in '/usr/share/davical/inc/auth-functions.php' on
line 119
[Mon Jul 19 18:27:54 2010] [error] [client 192.168.117.112] DAViCal: LOG:
Login: Query: QF: INSERT INTO usr (user_no, updated, username, fullname,
email) VALUES( 3185, '2009-04-14 02:22:53'::timestamptz, 'bsmith', 'Bob
Smith', 'bsmith at example.com' );
[Mon Jul 19 18:27:54 2010] [error] [client 192.168.117.112] PHP Notice:
Trying to get property of non-object in
/usr/share/davical/inc/auth-functions.php on line 42
[Mon Jul 19 18:27:54 2010] [error] [client 192.168.117.112] PHP Notice:
Trying to get property of non-object in
/usr/share/davical/inc/auth-functions.php on line 46
[Mon Jul 19 18:27:54 2010] [error] [client 192.168.117.112] PHP Notice:
Trying to get property of non-object in
/usr/share/davical/inc/auth-functions.php on line 50

(you can see with the inserts there, the same username has been added again
each time with a newer id number. This was account 50 or so for this user
when I found this in the log.)

Has anybody seen anything like this before? I'm rather confused as to how
the code is adding a duplicate entry with the same username if it's
violating a unique field, I would have thought the database would prevent
that? If there is a particular bit of information from the database that
would help or another bit of logging I could provide let me know. Any
suggestions welcome.

Thanks
Jason

p.s. This wasn't occurring a few weeks ago, I was on 0.8.3 then but
upgrading to 0.9.9 didn't help. At the time the issue started we had just
moved from a debian stable server to the centos 5.4 server to host davical
(same backend postgres server), at the same time we deployed thunderbird 3.1
+ lightning 1.0b2 network wide which increased the number of users logging
into the davical server 80%+ So it's hard to be sure if the move to
centos is what started this or the lightning 1.0b2 rollout. Particular
hard as I've found no way to replicate it on demand so I can't try to
isolate it.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100719/2908327e/attachment.htm>
-------------- next part --------------

users duplicating themselves? [ In reply to ]

keith.smith at keiths-place

Jul 19, 2010, 3:17 AM

Post #2 of 4 (314 views)

Permalink

You wouldn't happen to be running PHP v5.3 would you?

Regards,
Keith.

On 19 Jul 2010, at 10:37, Jason alavaliant wrote:

> I've run into an interesting problem with my davical 0.9.9 (centos 5, users via ldap) server in the last week. Users are somehow getting duplicated and in some cases I've seen 200+ entries for a single username occur. I've deleted that principal and manually cleaned up the database as best I could but it then starts occurring with another user. (always seems to be users logging in for the first time and having their ldap settings imported but then davical continues to import them again and again). So I get a bunch of principals with different ids but the same username and other details
>
[cut]

> p.s. This wasn't occurring a few weeks ago, I was on 0.8.3 then but upgrading to 0.9.9 didn't help. At the time the issue started we had just moved from a debian stable server to the centos 5.4 server to host davical (same backend postgres server), at the same time we deployed thunderbird 3.1 + lightning 1.0b2 network wide which increased the number of users logging into the davical server 80%+ So it's hard to be sure if the move to centos is what started this or the lightning 1.0b2 rollout. Particular hard as I've found no way to replicate it on demand so I can't try to isolate it.

users duplicating themselves? [ In reply to ]

alavaliant at gmail

Jul 19, 2010, 2:48 PM

Post #3 of 4 (316 views)

Permalink

Nope, according to both the rpms and the phpinfo on the setup page it's
php 5.1.6

On Mon, Jul 19, 2010 at 10:17 PM, Keith Smith
<keith.smith at keiths-place.com>wrote:

> You wouldn't happen to be running PHP v5.3 would you?
>
>
> Regards,
> Keith.
>
>
> On 19 Jul 2010, at 10:37, Jason alavaliant wrote:
>
> > I've run into an interesting problem with my davical 0.9.9 (centos 5,
> users via ldap) server in the last week. Users are somehow getting
> duplicated and in some cases I've seen 200+ entries for a single username
> occur. I've deleted that principal and manually cleaned up the database
> as best I could but it then starts occurring with another user. (always
> seems to be users logging in for the first time and having their ldap
> settings imported but then davical continues to import them again and
> again). So I get a bunch of principals with different ids but the same
> username and other details
> >
> [cut]
>
> > p.s. This wasn't occurring a few weeks ago, I was on 0.8.3 then but
> upgrading to 0.9.9 didn't help. At the time the issue started we had just
> moved from a debian stable server to the centos 5.4 server to host davical
> (same backend postgres server), at the same time we deployed thunderbird 3.1
> + lightning 1.0b2 network wide which increased the number of users logging
> into the davical server 80%+ So it's hard to be sure if the move to
> centos is what started this or the lightning 1.0b2 rollout. Particular
> hard as I've found no way to replicate it on demand so I can't try to
> isolate it.
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100720/a31768f4/attachment-0001.htm>
-------------- next part --------------

users duplicating themselves? [ In reply to ]

alavaliant at gmail

Jul 21, 2010, 3:54 PM

Post #4 of 4 (314 views)

Permalink

Interestingly it did turn out to be a php problem though - I installed some
php 5.2.10 rpms and they problem has gone away. Also at the same time a
person that was getting odd errors in iCal stopped getting them (I was
initially thinking it was just their iCal prefs being bad but now I wonder
if it was again something slightly odd with davical and php 5.1.6 on
centos).

On Tue, Jul 20, 2010 at 9:48 AM, Jason alavaliant <alavaliant at gmail.com>wrote:

> Nope, according to both the rpms and the phpinfo on the setup page it's
> php 5.1.6
>
>
> On Mon, Jul 19, 2010 at 10:17 PM, Keith Smith <
> keith.smith at keiths-place.com> wrote:
>
>> You wouldn't happen to be running PHP v5.3 would you?
>>
>>
>> Regards,
>> Keith.
>>
>>
>> On 19 Jul 2010, at 10:37, Jason alavaliant wrote:
>>
>> > I've run into an interesting problem with my davical 0.9.9 (centos 5,
>> users via ldap) server in the last week. Users are somehow getting
>> duplicated and in some cases I've seen 200+ entries for a single username
>> occur. I've deleted that principal and manually cleaned up the database
>> as best I could but it then starts occurring with another user. (always
>> seems to be users logging in for the first time and having their ldap
>> settings imported but then davical continues to import them again and
>> again). So I get a bunch of principals with different ids but the same
>> username and other details
>> >
>> [cut]
>>
>> > p.s. This wasn't occurring a few weeks ago, I was on 0.8.3 then but
>> upgrading to 0.9.9 didn't help. At the time the issue started we had just
>> moved from a debian stable server to the centos 5.4 server to host davical
>> (same backend postgres server), at the same time we deployed thunderbird 3.1
>> + lightning 1.0b2 network wide which increased the number of users logging
>> into the davical server 80%+ So it's hard to be sure if the move to
>> centos is what started this or the lightning 1.0b2 rollout. Particular
>> hard as I've found no way to replicate it on demand so I can't try to
>> isolate it.
>>
>>
>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100722/b9a12251/attachment.htm>
-------------- next part --------------