Thank you, so this would be working if i'm correct:
EDIT: It's still not working
Table:users
id |user_name | display_name | password | email |
------------------------------------------------------------
1 |testuser | Test User | 234085... | test.user@test.de |
$conf['plugin']['authpdo']['dsn'] = 'mysql:host=localhost;dbname=fsys';
$conf['plugin']['authpdo']['user'] = 'usernamegoeshere';
$cong['plugin']['authpdo']['pass'] = 'passwordfordb';
$conf['plugin']['authpdo']['select-user'] = 'SELECT `id` AS `uid`,
`user_name` AS `user`,
`display_name` AS `name`,
`password` AS `hash`,
`email` AS `email`
FROM `users`
WHERE `user_name` = :user';
$conf['plugin']['authpdo']['check-pass'] = 'SELECT `uid` AS `id`
FROM users
WHERE `user_name` = :USER
AND `password` = CONCAT( LEFT(hash,25), SHA1(CONCAT(LEFT(hash,25), :clear)) )';
But do i really need to adjust insert and update? I would like the Add the User from the other system. So the only thing i need is DokuWiki to check if the user exists and authenticate against the System. The Group Information should still come from the DokuWiki. User Management would be still in the old system, except the group and namespace permissions...
Best Regards,
phpCrow