Roundup Tracker - Issues

Message3943

Author linuxpoet
Recipients linuxpoet
Date 2009-12-22.22:56:16
Message-id <1261522576.87.0.972927570068.issue2550616@psf.upfronthosting.co.za>
In-reply-to
I have two machines:

(1) Web server
(1) Database server (PostgreSQL)

Initialize runs correctly but I can never get the thing to let the basic
user login (admin). Here is my _users table:

roundup=# select * from _user;
-[ RECORD 1 ]--------+----------------------------------------------
_activity            | 2009-12-22 22:51:30.148
_actor               | 1
_address             | admins@lists.commandprompt.com
_alternate_addresses | 
_creation            | 2009-12-22 22:51:30.148
_creator             | 1
_organisation        | 
_password            | {SHA}2c2dcf44f1bc9aa15d180db1d30d26a50922272d
_phone               | 
_realname            | 
_roles               | Admin
_timezone            | 
_username            | admin
id                   | 1
__retired__          | 0


The web interface loads but when I try to login in, it doesn't even
post. For example:

75.142.151.77 - - [22/Dec/2009 14:55:51] "POST / HTTP/1.1" 302 -
75.142.151.77 - - [22/Dec/2009 22:55:51] "GET /support/index HTTP/1.1" 200 -
2009-12-22 22:55:51,230 INFO open database 'roundup'
2009-12-22 22:55:51,246 INFO commit
2009-12-22 22:55:51,253 DEBUG SQL 'select id from _user where
_username=%s and __retired__=%s' ('anonymous', 0)
2009-12-22 22:55:51,255 DEBUG SQL 'select id from _user where
_username=%s and __retired__=%s' ('anonymous', 0)
2009-12-22 22:55:51,258 DEBUG SQL 'select
_activity,_actor,_address,_alternate_addresses,_creation,_creator,_organisation,_password,_phone,_realname,_roles,_timezone,_username
from _user where id=%s' ('2',)
2009-12-22 22:55:51,260 DEBUG SQL 'select linkid from user_queries where
nodeid=%s' ('2',)
2009-12-22 22:55:51,270 DEBUG SQL 'select
_issue.id,_priority3._order,(_priority3._order is not
NULL),_issue._activity,(_issue._activity is not NULL) from _issue LEFT
OUTER JOIN _priority as _priority3 on _issue._priority=_priority3.id 
where (_issue._status is NULL or (_issue._status in
(%s,%s,%s,%s,%s,%s,%s))) and _issue.__retired__=0 order by
(_priority3._order is not NULL),_priority3._order,(_issue._activity is
not NULL) desc,_issue._activity desc,_issue.id' ('1', '3', '2', '5',
'4', '7', '6')
2009-12-22 22:55:51,280 INFO close

Notice... no mention of user admin when trying to connect.
History
Date User Action Args
2009-12-22 22:56:16linuxpoetsetmessageid: <1261522576.87.0.972927570068.issue2550616@psf.upfronthosting.co.za>
2009-12-22 22:56:16linuxpoetsetrecipients: + linuxpoet
2009-12-22 22:56:16linuxpoetlinkissue2550616 messages
2009-12-22 22:56:16linuxpoetcreate