This is from my config. Comments stripped to save space:

;========================================================================
; Part Three: User Authentication
;========================================================================

ALLOW_ANON_USER = false
ALLOW_ANON_EDIT = false
ALLOW_BOGO_LOGIN = false
ALLOW_USER_PASSWORDS = true
USER_AUTH_ORDER = "Db"
PASSWORD_LENGTH_MINIMUM = 0
USER_AUTH_POLICY = first-only
 
;Haven't managed to get group auth working otherwise this would be DB. However group auth config below
GROUP_METHOD = WIKIPAGE
CATEGORY_GROUP_PAGE = CategoryGroup

DBAUTH_AUTH_DSN = "mysql://pwiki_user:pwiki_pass@localhost /pwiki_db"
DBAUTH_AUTH_USER_EXISTS = "SELECT userid FROM pref WHERE userid='$userid'"
DBAUTH_AUTH_CHECK = "SELECT IF(TRIM(passwd)='$password',1,0) AS ok FROM pref WHERE TRIM(userid)='$userid'"
DBAUTH_AUTH_CHECK = "SELECT IF(TRIM(passwd)=PASSWORD('$password'),1,0) AS ok FROM pref WHERE TRIM(userid)='$userid'"
DBAUTH_AUTH_UPDATE = "UPDATE pref SET passwd=PASSWORD('$password') WHERE userid='$userid'"
DBAUTH_PREF_SELECT = "SELECT prefs FROM pref WHERE userid='$userid'"
DBAUTH_PREF_UPDATE = "UPDATE pref SET prefs='$pref_blob' WHERE userid='$userid'"
DBAUTH_PREF_INSERT = "INSERT INTO pref (userid,prefs) VALUES ('$userid','$pref_blob')"
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'"

I then did an insert through phpMyAdmin to create a new user called TestUser. When creating the password select PASSWORD from the drop down menu. If you want to use MD5 or SHA1 you'll have to change your queries above and.
 
Hope that helps
 
Alastair

On 11/10/2007, Marek Lukasik <Marek.Lukasik@aotconsulting.com> wrote:
> Hi Alastair,
> How did you solve the user issue?
>
>
> Regards,
> Marek
>
> -----Original Message-----
> From: phpwiki-talk-bounces@lists.sourceforge.net
> [mailto: phpwiki-talk-bounces@lists.sourceforge.net] On Behalf Of
> Alastair Weller
> Sent: Thursday, 11 October 2007 4:55 PM
> To: Discussion on PhpWiki features, bugs, development.
> Subject: Re: [Phpwiki-talk] User Authentication
>
> I've solved the user issue - however I now can't get my head around the
> groups issue.
>
> Alastair
>
> On 11/10/2007, Marek Lukasik < Marek.Lukasik@aotconsulting.com> wrote:
> > Hi All,
> >
> > Same here, I can't access the WIKI using the admin credentials
> anymore.
> >
> >
> > Regards,
> > Marek
> >
> > -----Original Message-----
> > From: phpwiki-talk-bounces@lists.sourceforge.net
> > [mailto:phpwiki-talk-bounces@lists.sourceforge.net] On Behalf Of
> > Alastair Weller
> > Sent: Wednesday, 10 October 2007 11:55 PM
> > To: phpwiki-talk@lists.sourceforge.net
> > Subject: [Phpwiki-talk] User Authentication
> >
> > Hi Guys
> >
> > Just setup phpwiki and loving it so far.
> >
> > However one thing I would like to add is user authentication so that
> > only authenticatated users can login and view/edit/created pages and
> > ideally only pages in the groups/categorys there are members of ie if
> > they are in ProjectGroup they only have access to pages under
> > wikiurl/ProjectGroup if they are in ProjectGroup and ClientDetails
> > they have access to wikiurl/ProjectGroup and wikiurl/ClientDetails.
> >
> > I've had a look at the authentication options and tried turning on Db
> > user and group authentication - but it then doesn't let me login as
> > the Admin user. I've also tried to work out how to create users when
> > using the following configuration, to no avail.
> >
> > ALLOW_ANON_USER = false
> > ALLOW_ANON_EDIT = false
> > ALLOW_BOGO_LOGIN = false,
> > ALLOW_USER_PASSWORDS = true.
> >
> > I'm running this on a cpanel server with Apache Apache/1.3.37, PHP
> > 4.4.7 and MYSQL 4.1.22.
> >
> > Many thanks for any help and/or pointers.
> >
> > Alastair
> >
> > --
> > P Before you print think about the ENVIRONMENT
> >
> > ----------------------------------------------------------------------
> > --
> > -
> > This SF.net email is sponsored by: Splunk Inc.
> > Still grepping through log files to find problems?  Stop.
> > Now Search log events and configuration files using AJAX and a
> browser.
> > Download your FREE copy of Splunk now >> http://get.splunk.com/
> > _______________________________________________
> > Phpwiki-talk mailing list
> > Phpwiki-talk@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
> >
> > ----------------------------------------------------------------------
> > --- This SF.net email is sponsored by: Splunk Inc.
> > Still grepping through log files to find problems?  Stop.
> > Now Search log events and configuration files using AJAX and a
> browser.
> > Download your FREE copy of Splunk now >> http://get.splunk.com/
> > _______________________________________________
> > Phpwiki-talk mailing list
> > Phpwiki-talk@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
> >
>
>
> --
> P Before you print think about the ENVIRONMENT
>
> ------------------------------------------------------------------------
> -
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Phpwiki-talk mailing list
> Phpwiki-talk@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Phpwiki-talk mailing list
> Phpwiki-talk@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>


--
P Before you print think about the ENVIRONMENT