Homepage | Products | OX Knowledge Base | Support | Try Now | Contact | Company
OX Logo
Results 1 to 2 of 2
  1. #1
    Join Date
    May 2013
    Posts
    3

    Default Authenticate against OpenXchange Database

    Hi@all,

    I'm trying to authenticate a newly installed Dokuwiki against the OpenXchange database using the dokuwiki acl feature. Unfortunately I'm always getting an access denied. Is there a way to check the password manually? For debugging purposes for instance? User table is saying that the password should be sha encrypted, but when I try
    Code:
    select * from user where userPassword=sha('myPassword');
    I'm not getting the corresponding user. At the moment I've no Idea on how to check the PW against this table, and would be thankful if someone could give me a hint.

    thanks
    mobi

  2. #2

    Default

    Hi,

    We are also authenticating against the ox mysql database. The hash is indeed sha. We did construct the following sql statement:
    SELECT uid as user, userPassword as password \
    FROM user u \
    INNER JOIN login2user l \
    on u.id = l.id \
    WHERE uid = '%n';

    I realize this is the other way around (get password for user instead of get user for password) but I hope this is any help.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •