#127 Asking for user login on EVERY page reload or page transitio

1.3.x
open
nobody
None
5
2014-08-16
2005-07-15
aantonop
No

v1.3.11_rc3

This is an intranet wiki, so it's all authenticated
users, no access without a pre-existing account. While
the login works and I can do what is expected, each
time I click on anything and load a new page I have to
log in again. It is like the system forgets the
session, as if I am coming in on a direct URL without
authentication. I click on HomePage, new login request,
click on preferences, new login, click on submit
preferences, new login, go back to homepage, new login,
refresh the page, new login. etc...

Here are the settings:

ALLOW_ANON_USER = false
ALLOW_ANON_EDIT = false
ALLOW_BOGO_LOGIN = false
ALLOW_USER_PASSWORDS = true
USER_AUTH_ORDER = "Db"
PASSWORD_LENGTH_MINIMUM = 6

USER_AUTH_POLICY = strict
AUTH_SESS_USER = userid
AUTH_SESS_LEVEL = 2
GROUP_METHOD = DB
DBAUTH_AUTH_USER_EXISTS = "SELECT userid FROM user
WHERE userid='$userid'"
DBAUTH_AUTH_CHECK = "SELECT
IF(passwd=PASSWORD('$password'),1,0) AS ok FROM user
WHERE userid='$userid'"
DBAUTH_AUTH_CRYPT_METHOD = plain
DBAUTH_AUTH_UPDATE = "UPDATE user SET
passwd=PASSWORD('$password') WHERE userid='$userid'"
DBAUTH_PREF_SELECT = "SELECT prefs FROM pref WHERE
userid='$userid'"
DBAUTH_PREF_UPDATE = "REPLACE INTO pref SET
prefs='$pref_blob',userid='$userid'"
DBAUTH_IS_MEMBER = "SELECT userid FROM member WHERE
userid='$userid' AND groupname='$groupname'"
DBAUTH_GROUP_MEMBERS = "SELECT DISTINCT userid FROM
member WHERE groupname='$groupname'"
DBAUTH_USER_GROUPS = "SELECT groupname FROM member
WHERE userid='$userid'"
THEME = default
CHARSET = iso-8859-1
DEFAULT_LANGUAGE = ""

Discussion

  • Reini Urban

    Reini Urban - 2005-07-26

    Logged In: YES
    user_id=13755

    well, your php sessions are not working.
    I see no config option regarding sessions.

    USE_DBSESSION
    if false:
    SESSION_SAVE_PATH

     
  • Jakob Stćrk

    Jakob Stćrk - 2005-08-28

    Logged In: YES
    user_id=926810

    I have the same problem with 1.3.11_rc3.
    I use MySQL for both data and user. I start with clearing
    the session table to ensure a "clean" result. Loading the
    wiki homepage in a browser window create 1 row in the
    session table, the sess_data is 1.2 kb. I click "sign in" an
    get the sign in page. The sess_data is now 1.3 kb. If i
    enter a wrong password, the sess_data remains at 1.3 kb, but
    when i enter the correct password the sess_data grows to 6.3
    kb. Inspection of sess_data shows that several sql
    statements is appended to the original data. It seems to be
    the sql statements in config/config.ini for accessing the
    mysql database that is appended. This result in a
    lib/WikiDB/backend/PearDB.php:1014: Error:
    wikidb_backend_peardb_mysql: fatal database error

    * DB Error: already exists
    * (INSERT INTO gyldenrowiki_session (sess_id, sess_data,
    

    sess_date, sess_ip) VALUES
    ('831f86bb9a6e31746f9d83fec27b328f',
    'wiki_user|O:15:\"_peardbpassuser\":15:{s:7:\"_userid\";s:11:\"JakobStaerk\";s:6:\"_level\";i:2;s:6:\"_prefs\";O:15:\"userpreferences\":4:{s:6:\"_prefs\";a:13:{s:6:\"userid\";O:15:\"_userpreference\":3:{s:13:\"default_value\";s:0:\"\";s:5:\"_init\";b:0;s:6:\"userid\";s:11:\"JakobStaerk\";}s:6:\"passwd\";O:15:\"_userpreference\":3:{s:13:\"default_value\";s:0:\"\";s:5:\"_init\";b:0;s:6:\"passwd\";s:34:\"Actual
    text
    Removed";}s:9:\"autologin\";O:20:\"_userpreference_bool\":2:{s:13:\"default_value\";b:0;s:5:\"_init\";b:0;}s:5:\"email\";O:21:\"_userpreference_email\":2:{s:13:\"default_value\";s:0:\"\";s:5:\"_init\";b:0;}s:11:\"notifyPages\";O:22:\"_userpreference_notify\":2:{s:13:\"default_value\";s:0:\"\";s:5:\"_init\";b:0;}s:5:\"theme\";O:21:\"_userpreference_theme\":2:{s:13:\"default_value\";s:6:\"MacO

    Regards Jakob Staerk

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks