logo       

how to do mysql user authentication with phpwiki 1.3.6?: msg#00047

web.wiki.phpwiki.talk

Subject: how to do mysql user authentication with phpwiki 1.3.6?

Hello, I just installed (this morning, now it's 22:00) phpwiki 1.3.6 and am
trying to figure out how to use mysql authentication.
I used the AllUsers (?pagename=AllUsers) plugin to check if it sees my users.
The 'root' user got visible after creating a page named 'root' and changing
root's preferences. I see no change to wiki 'user' and 'member' tables so I
added some users by hand, created their 'home pages', tryed diferent
'auth_crypt_method's and so on with no luck - users can not login with or
without separate DB User Authentication.

my config:
--- cut ---
$DBParams = array(
'dbtype' => 'SQL',
'dsn' =>
'mysql://<phpwikiuser>:<phpwikipass>@unix(/var/lib/mysql/mysql.sock)/<phpwikitable>',
'db_session_table' => 'session',
'timeout' => 20
);
define('USE_DB_SESSION',true);
......
if (!defined('ALLOW_HTTP_AUTH_LOGIN')) define('ALLOW_HTTP_AUTH_LOGIN', false);
if (!defined('ALLOW_USER_LOGIN')) define('ALLOW_USER_LOGIN', true);
if (!defined('ALLOW_BOGO_LOGIN')) define('ALLOW_BOGO_LOGIN', true);
if (!defined('REQUIRE_SIGNIN_BEFORE_EDIT'))
define('REQUIRE_SIGNIN_BEFORE_EDIT', true);
@ini_set('session.use_trans_sid', 0);
if (!defined('ALLOW_LDAP_LOGIN')) define('ALLOW_LDAP_LOGIN', false);
if (!defined('ALLOW_IMAP_LOGIN')) define('ALLOW_IMAP_LOGIN', false);
$DBAuthParams = array(
'auth_dsn'
'mysql://<phpwikiuser>:<phpwikipass>@unix(/var/lib/mysql/mysql.sock)/<phpwikitable>',
'auth_check' => 'SELECT password FROM wiki_user WHERE userid="$userid"',
'auth_crypt_method' => 'plain',
'auth_update' => 'UPDATE wiki_user SET password="$password" WHERE
userid="$userid"',
'pref_select' => 'SELECT preferences from wiki_user WHERE userid="$userid"',
'pref_update' => 'UPDATE wiki_user SET preferences="$pref_blob" WHERE
userid="$userid"',
'group_members' => 'SELECT userid FROM wiki_group WHERE user_group="$group"',
'user_groups' => 'SELECT user_group FROM wiki_group WHERE userid="$userid"',
'dummy' => false
);
--- cut ---
* I don't have <phpwikiuser> as username, I replaced the real values this way.

MySQL tables wiki_user and wiki_grop are:
--- cut ---
CREATE TABLE `wiki_user` (
`userid` varchar(48) binary NOT NULL default '',
`preferences` text,
`password` varchar(48) binary default '*',
PRIMARY KEY (`userid`),
UNIQUE KEY `userid` (`userid`)
) TYPE=MyISAM;
CREATE TABLE `wiki_group` (
`userid` char(48) NOT NULL default '',
`user_group` char(48) NOT NULL default 'users',
PRIMARY KEY (`userid`),
KEY `user_group` (`user_group`)
) TYPE=MyISAM;
--- cut ---

So far no user except the admin user defined in index.php can login. All pages
are stored in my mysql server. The 'auth_dsn' for 'DBAuthParams' is just the
same as 'dsn' for 'DBParams'.
Can someone tell me how to do MySQL user authentication? Is it supported?
(I would prefer not to have any user 'home pages' at all if possible)

--
Regards,
Doncho N. Gunchev


-------------------------------------------------------
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive? Does it
help you create better code? SHARE THE LOVE, and help us help
YOU! Click Here: http://sourceforge.net/donate/


<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise