I've installed phpwiki 1.3.11 and it is working fine besides the auth. I've chosen mysql as database and until now all edits have been stored correctly besides user-data entered on 'UserPreferences'. I get the following error:
Hi stefan,
you need to set DBAUTH_PREF_UPDATE in config.ini.
This is the SQL-string performed. When you look at the table definitions in schema, prefs is in a table pref and not in user. Change query and it should work.
Jens.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
thanks for your advice on my problem. yes, i've already set DBAUTH_PREF_UPDATE, though this didn't solve my problem.
but i found a different - quite mysterious - way to solve the problem: i configured config.ini as recommended in doc/README.security and everything seems to be fine now, though still no userid and password gets stored in the table 'user' in the database. yet i do not use 'PersonalPage' for authentification passwords get stored correctly - only i do not know where (but i do not really care at the moment).
conclusion: read doc/README.security.
good luck, stefan
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
hello,
I've installed phpwiki 1.3.11 and it is working fine besides the auth. I've chosen mysql as database and until now all edits have been stored correctly besides user-data entered on 'UserPreferences'. I get the following error:
lib/WikiDB/backend/PearDB.php (In template 'body' < 'html'):1014: Error: wikidb_backend_peardb_mysql: fatal database error
what's the trick in using the mysql-database for auth? can anyone explain?
any help highly appreciated.
stefan
Hi stefan,
you need to set DBAUTH_PREF_UPDATE in config.ini.
This is the SQL-string performed. When you look at the table definitions in schema, prefs is in a table pref and not in user. Change query and it should work.
Jens.
hello jens,
thanks for your advice on my problem. yes, i've already set DBAUTH_PREF_UPDATE, though this didn't solve my problem.
but i found a different - quite mysterious - way to solve the problem: i configured config.ini as recommended in doc/README.security and everything seems to be fine now, though still no userid and password gets stored in the table 'user' in the database. yet i do not use 'PersonalPage' for authentification passwords get stored correctly - only i do not know where (but i do not really care at the moment).
conclusion: read doc/README.security.
good luck, stefan