I'm new to phpwiki and am looking at deploying it for internal documentation.
I have installed the wiki and have it all setup and the admin user works fine. However, we run Postgresql for our database and I cannot work out how the DBAUTH parameters should be set. I don't think that Postgres can do things like:
DBAUTH_AUTH_CHECK = "SELECT passwd AS password FROM users where userid='$userid'"
although I could quite easily be wrong. I couldn't really work out which auth method I should be using for Postgres either. Does crypt work? At the moment I would be happy with plain text but I can't get that working either. Does anyone have DBAUTH working with Postgres?
BTW user appears to be a reserved name in Postgres and you don't appear to be able to call a table by that name.
I also wasn't sure what AUTH_SESS_USER should be set to when using a database.
Any help would be really appreciated. I'm running phpwiki 1.3.11 on PHP4.4.
Thank, Hugh
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi All,
I'm new to phpwiki and am looking at deploying it for internal documentation.
I have installed the wiki and have it all setup and the admin user works fine. However, we run Postgresql for our database and I cannot work out how the DBAUTH parameters should be set. I don't think that Postgres can do things like:
DBAUTH_AUTH_CHECK = "SELECT passwd AS password FROM users where userid='$userid'"
although I could quite easily be wrong. I couldn't really work out which auth method I should be using for Postgres either. Does crypt work? At the moment I would be happy with plain text but I can't get that working either. Does anyone have DBAUTH working with Postgres?
BTW user appears to be a reserved name in Postgres and you don't appear to be able to call a table by that name.
I also wasn't sure what AUTH_SESS_USER should be set to when using a database.
Any help would be really appreciated. I'm running phpwiki 1.3.11 on PHP4.4.
Thank, Hugh