custom users database in mysql
Hi, I currently have custom php based system which keeps whole users database in mysql. I'm trying to make otrs use the same database (read-only) but the problem is that users are not keept in one table... there are multiple tables which contain information about users. From what I see otrs wants one table with all fields in it (at least that's how it looks on example http://doc.otrs.org/1.2/en/html/customer-user-backend.html) Is it possible to define my own SQL queries or better force otrs to get all data from some page like http://xyz.pl/users.php (so I could write all SQL magic into users.php and return proper entries). http-link in CustomerUser is for this purpose or something else? Thanks for hints, -- Arkadiusz Miśkiewicz CS at FoE, Wroclaw University of Technology arekm.pld-linux.org, 1024/3DB19BBD, JID: arekm.jabber.org, PLD/Linux
On Sunday, March 21, 2004 3:40 PM
Arkadiusz Miskiewicz
I currently have custom php based system which keeps whole users database in mysql. I'm trying to make otrs use the same database (read-only) but the problem is that users are not keept in one table... there are multiple tables which contain information about users.
What about creating a read-only view?
Is it possible to define my own SQL queries or better force otrs to get all data from some page like http://xyz.pl/users.php (so I could write all SQL magic into users.php and return proper entries). http-link in CustomerUser is for this purpose or something else?
You'd have a need for a html parser module than. Neat to have, though... I'd suggest you try it with a view. Best wishes, Robert Kehl -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Tel. +49 (0)6172 4832388
Dnia Sunday 21 of March 2004 15:46, Robert Kehl napisał:
I currently have custom php based system which keeps whole users database in mysql. [...] What about creating a read-only view? views in mysql are supported only in version 5 which is currently under early development so it's not a option unfortunately
Is it possible to define my own SQL queries or better force otrs to get all data from some page like http://xyz.pl/users.php (so I could write all SQL magic into users.php and return proper entries). http-link in CustomerUser is for this purpose or something else?
You'd have a need for a html parser module than. Neat to have, though... Some SOAP thing...
Robert Kehl
-- Arkadiusz Miśkiewicz CS at FoE, Wroclaw University of Technology arekm.pld-linux.org, 1024/3DB19BBD, JID: arekm.jabber.org, PLD/Linux
On Sunday, March 21, 2004 3:49 PM
Arkadiusz Miskiewicz
Dnia Sunday 21 of March 2004 15:46, Robert Kehl napisał:
I currently have custom php based system which keeps whole users database in mysql. [...] What about creating a read-only view? views in mysql are supported only in version 5 which is currently under early development so it's not a option unfortunately
Didn't know that. Switch to Oracle. ;-) jk.
http-link in CustomerUser is for this purpose or something else?
What do you mean ex.?
You'd have a need for a html parser module than. Neat to have, though...
Some SOAP thing...
Probably. Then you got MySQL, Apache, PHP, mod_perl _and_ SOAP running. Hm... What about writing a nice little script running every 5 minutes or so, which simply pumps the desired data into the system_user table? I guess it's more work if you try to get OTRS to use two or more tables at a time where it now expects one. hth, Robert Kehl -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Tel. +49 (0)6172 4832388
participants (2)
-
Arkadiusz Miskiewicz -
Robert Kehl