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

[aantonop]

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 = ""

[Reini Urban]

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]

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