roller-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <zah...@ntlworld.com>
Subject Re: ACTIVATE user account link email
Date Thu, 01 Jan 1970 00:00:00 GMT
This resultset  shows that the activation code in the roller_user table is held in unreadable
form.
Query SELECT r.`id`, r.`passphrase`, r.`activationcode`, r.`datecreated`, r.`locale`, r.`timezone`,
r.`isenabled` FROM rolleruser r

id passphrase activationcode datecreated locale timezone isenabled 
0a190954-b588-45f4-bdf9-422635b080fb 805bf1f69650146b587f4e2b08325a94d199b29b b11b88c4-f22b-40ba-8d4e-496667af3f06
2009-02-23 03:33:25 en_GB Europe/London 0 
168095fe-6893-4a7d-9d0c-8841f569f57a 05c974aeaa6257a1bf1481eadda6ac6de7d97003 f1a8f8fa-0d29-4d82-a4b6-eae18404e7e2
2009-02-23 08:12:58 en_GB Europe/London 0 
1cdcf018-c90a-431f-aa27-c7d8c92440b2 cf60d19e237041c6bd43a181f51f5b8b9b66fa67 e47e0f73-25c5-4097-85ca-7ff33b44cb8b
2009-02-23 13:09:56 en_GB Europe/London 0 
2005dc4c-1699-4b81-bf87-846c790f3be8 7d112681b8dd80723871a87ff506286613fa9cf6 a9fb364d-3ea3-4e98-84e0-09815052a58b
2009-02-23 04:35:05 en_GB Europe/London 0 
30f249cb-e8b1-4ca9-b3fb-91204664780a 8908acc0f7fd1b7413e44ce8d2dc8c312e4fedc2 a00c28b7-f9d4-4d28-b9ce-9b273caf921f
2009-02-23 08:13:58 en_GB Europe/London 0 
369d30b5-03a0-4e9f-8a2b-d1040dc72aff b7a875fc1ea228b9061041b7cec4bd3c52ab3ce3  2009-02-23
00:55:11 en_GB Europe/London 1 
3be4526f-d21f-4c19-a07a-41172cf246b4 2b5c240e6abd88e71ffc225b0459016e4cba9bda 1cd2da19-51c4-4693-9b8a-e91750d2f689
2009-02-23 03:01:55 en_GB Europe/London 0 
3cb09e45-221c-4d62-bd47-b7ed009cb917 b7a875fc1ea228b9061041b7cec4bd3c52ab3ce3 399bdf04-36e5-41be-807b-7f55e43dafa8
2009-02-23 10:35:03 en_GB Europe/London 0 
5f25b5f1-1518-4893-bcae-3a8e8ce82334 b7a875fc1ea228b9061041b7cec4bd3c52ab3ce3 2f182765-a6e3-470b-afad-6468961fa65b
2009-02-23 08:34:24 en_GB Europe/London 0 
653665bb-40b7-4bbf-b246-f49547f71065 cd1bfe55cbb2b0b989cac86391e5100c933ffe7e 38483d82-6358-49de-8124-59969e28977c
2009-02-23 03:49:37 en_GB Europe/London 0 
7deec05b-c6fd-43dd-b306-58a786d9e7bd b7a875fc1ea228b9061041b7cec4bd3c52ab3ce3 e569c5f1-2baa-4406-8340-8bd328e176ce
2009-02-23 01:06:34 en_GB Europe/London 0 
83a27d12-0f12-4a65-9358-c491bfde8c7d 9bd054924e5cbbfd8a3db8fbefafcffbcf04d0ea a92da200-5eac-403a-9310-65bd816276f1
2009-02-23 03:53:13 en_GB Europe/London 0 
886c037e-a9ee-4cf0-adcb-cb97ed73606f 069f27ccdb9dab4b93aa6cc8a6b34fd429015a4b 1ef27fea-8e94-4f96-bf1b-44bdb0e82f47
2009-02-23 12:40:21 en_GB Europe/London 0 
893d45b0-dfb2-48dd-82b7-715470211c64 3507ee429f0bf21344817eaaef3a328f3d70863c 8a1e95cb-ba5e-4cb1-9514-8fd5cc2f6681
2009-02-23 03:00:36 en_GB Europe/London 0 
8a90ae4a-dc3b-4b66-8ed6-2ddb1f39ec77 988b8b7647ee7aba87deb60391ea8173f4389f83 870f7e9b-e701-47c4-9f4e-4618e7e66a19
2009-02-23 12:54:17 en_GB Europe/London 0 
ab1002f6-a908-4552-8ff9-5ddb450d494b 1dae309550336fc37c9c844d6a61a2bcf8dd1fdf  2009-02-23
13:21:43 en_GB Europe/London 1 
acaa6550-33d0-486f-a72e-a692490f5741 b7a875fc1ea228b9061041b7cec4bd3c52ab3ce3 c0ac784e-66be-4595-a61d-b3a46e86212b
2009-02-23 02:58:49 en_GB Europe/London 0 
c3aec4e2-dd98-41f8-b794-c3b36062fbbb fc707fc0b8c62cfeeafffde7273978d29d6d2374 0122b3ea-dfe9-42ef-8551-328c40ed2ce8
2009-02-23 01:07:26 en_GB Europe/London 0 
c47b5255-a74d-4bcf-95da-3c3c8544fda8 b7a875fc1ea228b9061041b7cec4bd3c52ab3ce3 930312af-e82c-48ee-a44f-593ffdb2bcb6
2009-02-23 12:58:44 en_GB Europe/London 0 
d5321d71-4692-43a9-88f9-8c4d0ebb782e 16bf33a51044593afd0fbb33127ad9d392acee8d 7b606d74-414d-4985-8cb5-c9f677383fd8
2009-02-23 03:59:14 en_GB Europe/London 0 
dd3085a7-1320-40b4-a1e1-646117fa7b9a 05c974aeaa6257a1bf1481eadda6ac6de7d97003 b676236b-ab94-444b-8bf9-e4e56a29698a
2009-02-23 08:11:56 en_GB Europe/London 0 
f95c85e1-22ca-4b2d-ba02-77a941191601 2d2e938d65234672e2a66f88c2bc1eccafa8ffad c4f791f6-e5e0-4b1d-ba09-ae85dc989a94
2009-02-23 08:22:24 en_GB Europe/London 0 
ffa24bf4-f295-400d-afdc-75573e9dbe3d cf60d19e237041c6bd43a181f51f5b8b9b66fa67 18c7b2af-c5a5-4400-beb4-b271b902ecb6
2009-02-23 13:07:14 en_GB Europe/London 0 

 

---- Dave <snoopdave@gmail.com> wrote: 
> On Mon, Feb 23, 2009 at 11:46 AM,  <zahidr@ntlworld.com> wrote:
> > Roller 4.0.1
> > tomcat 6.0.18
> > MYSQL 5.0.67_win32
> > jdk1.6.0_12
> > WindowsXP (HP Pavilion DV6000) Notebook
> > Internet Explorer 7.0.5730.13
> >
> > Yes you are right I did have the enable email activation of new
> > accounts option set  when I created a new blog. I have turned it off now in the
ADMIN settings.
> >
> > I was also trying to use a test server called TestMailServerTool but that was NOT
generating the email in its dump file.
> >
> > I also looked in the rollerdb to find out the generated email but couldn't find
it.
> >
> > I would like this option set just to find out if it works.
> 
> Best way to do that is to setup a proper email server.
> The only place we put he activation link is in the email.
> 
> Activation codes are stored in the 'rolleruser' table and the
> activation URLs are of the form:
> 
>    <ROLLER-CONTEXT-URL>/roller-ui/register!activate.rol?activationCode=<ACTIVATION-CODE>
> 
> Hope that helps...
> 
> - Dave


Mime
View raw message