Forum OpenACS Q&A: Response to Security related errors?

Collapse
3: Response to Security related errors? (response to 1)
Posted by Peter McDermott on 04/24/00 03:57 AM
After some twiddling around with my config files, that one seems to have disappeared. Only to be replaced by something that I suspect to be somehow related.

Basically, I keep on getting bounced back to the registration page. When I register, my data gets entered into the users table, but for some reason the system won't let me in.

From the logs again...

------ start quote -----

24/Apr/2000:03:46:56][13147.1026][-sched-] Notice: Registered partner cookie: ad
[24/Apr/2000:03:46:56][13147.1026][-sched-] Notice: Done running scheduled proc ad_partner_initialize.
[24/Apr/2000:03:47:06][13147.4100][-conn0-] Notice: starting: waiting for connections
[24/Apr/2000:03:47:06][13147.4100][-conn0-] Notice: Querying 'select first_names || ' ' || last_name as name from users where user_id = 1 and user_state <> 'deleted';'
[24/Apr/2000:03:47:06][13147.4100][-conn0-] Notice: nsd.db: sql(localhost::acspg):  select first_names || ' ' || last_name as name from users where user_id = 1 and user_state <> 'deleted'
[24/Apr/2000:03:47:06][13147.4100][-conn0-] Notice: Querying '
select section_url_stub, section_pretty_name
from content_sections
where scope='public' and enabled_p = 't'
order by sort_key, upper(section_pretty_name);'
[24/Apr/2000:03:47:06][13147.4100][-conn0-] Notice: nsd.db: sql(localhost::acspg):
select section_url_stub, section_pretty_name
from content_sections
where scope='public' and enabled_p = 't'
order by sort_key, upper(section_pretty_name)
[24/Apr/2000:03:47:08][13147.4100][-conn0-] Notice: nsd.db: opening:  postgres:localhost::acspg
[24/Apr/2000:03:47:08][13147.4100][-conn0-] Notice: Opening acspg on localhost
[24/Apr/2000:03:47:08][13147.4100][-conn0-] Notice: Ns_PgOpenDb(postgres):  Openned connection to localhost::acspg.
[24/Apr/2000:03:47:08][13147.4100][-conn0-] Notice: Querying 'set datestyle to 'ISO';'
[24/Apr/2000:03:47:08][13147.4100][-conn0-] Notice: Querying '
        select user_id, token, secure_token,
              last_ip, last_hit from sec_sessions
        where session_id = 2;'
[24/Apr/2000:03:47:08][13147.4100][-conn0-] Notice: nsd.db: sql(localhost::acspg):
        select user_id, token, secure_token,
              last_ip, last_hit from sec_sessions
        where session_id = 2

[24/Apr/2000:03:47:08][13147.5125][-conn1-] Notice: starting: waiting for connections
[24/Apr/2000:03:47:27][13147.4100][-conn0-] Notice: Querying 'select user_id, user_state, converted_p from users where upper(email)=upper('system');'
[24/Apr/2000:03:47:27][13147.4100][-conn0-] Notice: nsd.db: sql(localhost::acspg):  select user_id, user_state, converted_p from users where upper(email)=upper('system')
[24/Apr/2000:03:47:27][13147.4100][-conn0-] Notice: Querying '
        select password
        from users
        where user_id = 1
        and user_state='authorized';'
[24/Apr/2000:03:47:27][13147.4100][-conn0-] Notice: nsd.db: sql(localhost::acspg):
        select password
        from users
        where user_id = 1
        and user_state='authorized'

[24/Apr/2000:03:47:27][13147.4100][-conn0-] Notice: Querying '
        update sec_sessions
        set user_id = 1
        where session_id = 2;'
[24/Apr/2000:03:47:27][13147.4100][-conn0-] Notice: nsd.db: sql(localhost::acspg):
        update sec_sessions
        set user_id = 1
        where session_id = 2

[24/Apr/2000:03:47:27][13147.4100][-conn0-] Notice: Querying 'select password from users where user_id = 1;'
[24/Apr/2000:03:47:27][13147.4100][-conn0-] Notice: nsd.db: sql(localhost::acspg):  select password from users where user_id = 1
[24/Apr/2000:03:47:29][13147.4100][-conn0-] Notice: Querying 'update users
set last_visit = sysdate(),
    second_to_last_visit = last_visit,
    n_sessions = n_sessions + 1
where user_id = 1;'
[24/Apr/2000:03:47:29][13147.4100][-conn0-] Notice: nsd.db: sql(localhost::acspg):  update users
set last_visit = sysdate(),
    second_to_last_visit = last_visit,
    n_sessions = n_sessions + 1
where user_id = 1
[24/Apr/2000:03:47:29][13147.4100][-conn0-] Notice: Querying 'update session_statistics
set repeat_count = repeat_count + 1
where entry_date = trunc(sysdate());'
[24/Apr/2000:03:47:29][13147.4100][-conn0-] Notice: nsd.db: sql(localhost::acspg):  update session_statistics
set repeat_count = repeat_count + 1
where entry_date = trunc(sysdate())
[24/Apr/2000:03:47:33][13147.5125][-conn1-] Notice: Querying '
        select user_id, token, secure_token,
              last_ip, last_hit from sec_sessions
        where session_id = 2;'
[24/Apr/2000:03:47:33][13147.5125][-conn1-] Notice: nsd.db: sql(localhost::acspg):
        select user_id, token, secure_token,
              last_ip, last_hit from sec_sessions
        where session_id = 2

[24/Apr/2000:03:49:33][13147.5125][-conn1-] Notice: exiting: no waiting connections
[24/Apr/2000:03:49:33][13147.4100][-conn0-] Notice: exiting: no waiting connections

--- End quote ---