[Phpgroupware-users] Registration module email confirmation failing

[Daniel Kelley]

I'm trying to get the Registration module running in the following
environment. I don't know if this is particular to Registration, or
if I have a more general problem (but I haven;t tried everything yet):

  phpgw Version-0_9_14-branch
  Red Hat Linux release 7.2 (Enigma) (x86)
  postgresql 7.1.3

Everything works fine up to the point of sending confirmation mail, but
clicking on the link sent in the email gives me

  "Sorry, we are having a problem activating your account..."

It looks like the phpgw_reg_accounts table is not getting filled in
by function step2() in registration/class.soreg.inc.php ($account_lid
is empty).

It looks to me like the update and query of phpgw_app_sessions is mismatched,
because the sessionid changes between the session update and select:

(sorry for the long lines)
--log--
2002-09-12 22:27:51 DEBUG:  query: UPDATE phpgw_app_sessions SET 
content='stanley'WHERE sessionid = '7c7ac02d07c1706da01f19276755484c'AND 
loginid = '12' AND app = 'registration'AND location = 'loginid'

...deleted...

2002-09-12 22:29:10 DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE 
sessionid='8d9620133ac88299d1197778165a15d3' AND loginid='12' AND app = 
'registration' AND location='loginid'

2002-09-12 22:29:10 DEBUG:  query: update phpgw_reg_accounts set 
reg_id='76892d9d81a9b5aacd63df378a46ccd9', reg_dla='1031894950', 
reg_info='YTo3OntzOjY6InBhc3N3ZCI7czo2OiJjb3RhdGkiO3M6MTQ6InBhc3N3ZF9jb25maXJtIjtzOjY6ImNvdGF0aSI7czo3OiJuX2dpdmVuIjtzOjc6IlN0YW5sZXkiO3M6ODoibl9mYW1pbHkiO3M6NjoiTW9yZ2FuIjtzOjU6ImVtYWlsIjtzOjI5OiJka2VsbGV5QGxvY2FsaG9zdC5sb2NhbGRvbWFpbiI7czo5OiJ0b3NfYWdyZWUiO3M6Mjoib24iO3M6NToiY2xhc3MiO3M6NToibXU2NjYiO30='
 where reg_lid=''

--db--
select * from phpgw_reg_accounts;
 reg_id | reg_lid | reg_info |  reg_dla   
--------+---------+----------+------------
        | stanley |          | 1031894871
(1 row)

SELECT content FROM phpgw_app_sessions
WHERE sessionid='7c7ac02d07c1706da01f19276755484c'
AND loginid='12' AND app = 'registration' AND location='loginid';
 content 
---------
 stanley
(1 row)



SELECT content FROM phpgw_app_sessions
WHERE sessionid='8d9620133ac88299d1197778165a15d3'
AND loginid='12' AND app = 'registration' AND location='loginid';
 content 
---------
(0 rows)

anybody have any ideas where I can look?

d.k.