Fwd: Changing customers table
Hi, I need to integrate another web system with OTRS using only one login. The first system is in one Linux server and the Otrs in a Windows 2000 Advanced Server. The idea is the users starts in the first system and then use OTRS with the same login, I think in pass the login variables in the URL whe I call OTRS, but I need to authenticate OTRS with the Mysql tables of the first system. My question is: I can do that in a easy way? How? thank you for your time and your answers best regards Adrián -- NEU : GMX Internet.FreeDSL Ab sofort DSL-Tarif ohne Grundgebühr: http://www.gmx.net/info
Hi Adrian, On Fri, Apr 16, 2004 at 11:13:25PM +0200, Deccico Adrian wrote:
I need to integrate another web system with OTRS using only one login.
The first system is in one Linux server and the Otrs in a Windows 2000 Advanced Server.
The idea is the users starts in the first system and then use OTRS with the same login, I think in pass the login variables in the URL whe I call OTRS, but I need to authenticate OTRS with the Mysql tables of the first system.
My question is: I can do that in a easy way? How?
OTRS can handle SSO! .-) For example the HTTPBasicAuth auth module -=> http://doc.otrs.org/1.2/en/html/user-auth-backend.html#AEN743 This module takes the $ENV{REMOTE_USER} from your system and if the agent exists in OTRS then the agent is authenticated (no extra auth with uid and pw needed). PS: You also can write/modify the HTTPBasicAuth to use other SSO auth functions.
Adrián
Martin Edenhofer -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication!
Thanks for your answer I was working all the weekend on other otrs problem. I have few questions. How do I set the $ENV{REMOTE_USER} for using SSO?, my idea is to have multiple users in OTRS but with only one login. Sorry if my question is not a good one but although I develop in many languages I 'm still a newbie untill now in Perl and PHP. Best regards Adrián -----Mensaje original----- De: dev-bounces@otrs.org [mailto:dev-bounces@otrs.org] En nombre de Martin Edenhofer Enviado el: Saturday, April 17, 2004 9:53 AM Para: Development community of OTRS Asunto: Re: [dev] Fwd: Changing customers table Hi Adrian, On Fri, Apr 16, 2004 at 11:13:25PM +0200, Deccico Adrian wrote:
I need to integrate another web system with OTRS using only one login.
The first system is in one Linux server and the Otrs in a Windows 2000
Advanced Server.
The idea is the users starts in the first system and then use OTRS with the same login, I think in pass the login variables in the URL whe I call OTRS, but I need to authenticate OTRS with the Mysql tables of the first system.
My question is: I can do that in a easy way? How?
OTRS can handle SSO! .-) For example the HTTPBasicAuth auth module -=> http://doc.otrs.org/1.2/en/html/user-auth-backend.html#AEN743 This module takes the $ENV{REMOTE_USER} from your system and if the agent exists in OTRS then the agent is authenticated (no extra auth with uid and pw needed). PS: You also can write/modify the HTTPBasicAuth to use other SSO auth functions.
Adrián
Martin Edenhofer -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication! _______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
Thanks for your answer I was working all the weekend on other otrs problem. I have a question. How do I set the $ENV{REMOTE_USER} for using SSO?, my idea is to have multiple users in OTRS but with only one login that became for other web system, that has multiple users. Sorry if my question is not a good one but although I develop in many languages I 'm still a newbie in Perl until now. Best regards Adrián -----Mensaje original----- De: dev-bounces@otrs.org [mailto:dev-bounces@otrs.org] En nombre de Martin Edenhofer Enviado el: Saturday, April 17, 2004 9:53 AM Para: Development community of OTRS Asunto: Re: [dev] Fwd: Changing customers table Hi Adrian, On Fri, Apr 16, 2004 at 11:13:25PM +0200, Deccico Adrian wrote:
I need to integrate another web system with OTRS using only one login.
The first system is in one Linux server and the Otrs in a Windows 2000 Advanced Server.
The idea is the users starts in the first system and then use OTRS with the same login, I think in pass the login variables in the URL whe I call OTRS, but I need to authenticate OTRS with the Mysql tables of the first system.
My question is: I can do that in a easy way? How?
OTRS can handle SSO! .-) For example the HTTPBasicAuth auth module -=> http://doc.otrs.org/1.2/en/html/user-auth-backend.html#AEN743 This module takes the $ENV{REMOTE_USER} from your system and if the agent exists in OTRS then the agent is authenticated (no extra auth with uid and pw needed). PS: You also can write/modify the HTTPBasicAuth to use other SSO auth functions.
Adrián
Martin Edenhofer -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication! _______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
On Mon, Apr 19, 2004 at 10:36:08AM -0300, Adrián Deccico wrote:
Thanks for your answer I was working all the weekend on other otrs problem.
I have a question.
How do I set the $ENV{REMOTE_USER} for using SSO?, my idea is to have multiple users in OTRS but with only one login that became for other web system, that has multiple users.
Sorry if my question is not a good one but although I develop in many languages I 'm still a newbie in Perl until now.
Adrián, http-basic-auth was just an example. :) The $ENV{REMOTE_USER} will be set from apache after an user is autenticated by apache via http-basic-auth.
Adrián
Martin -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication!
Ok, but now I am more confuse than in the beginning. I am thinking for my double login problem to: 1- Read login variables from the URL. The first system pass OTRS the user and pass in the URL. 2- Use SSO.. but how? I put the code in the .pm module, then the login call the page that I set but it not seems to works with the multiple users that are in the first System. The first system has it own users in other mysql table than the Otrs and the idea is to add a menu to access OTRS functions with the same user and password. Please, what is the best way? best regards Adrián
On Mon, Apr 19, 2004 at 10:36:08AM -0300, Adrián Deccico wrote:
Thanks for your answer I was working all the weekend on other otrs problem.
I have a question.
How do I set the $ENV{REMOTE_USER} for using SSO?, my idea is to have multiple users in OTRS but with only one login that became for other web system, that has multiple users.
Sorry if my question is not a good one but although I develop in many languages I 'm still a newbie in Perl until now.
Adrián, http-basic-auth was just an example. :) The $ENV{REMOTE_USER} will be set from apache after an user is autenticated by apache via http-basic-auth.
Adrián
Martin
-- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication!
_______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
-- NEU : GMX Internet.FreeDSL Ab sofort DSL-Tarif ohne Grundgebühr: http://www.gmx.net/dsl
Hi Adrian, On Mon, Apr 19, 2004 at 09:15:14PM +0200, Deccico Adrian wrote:
Ok, but now I am more confuse than in the beginning. I am thinking for my double login problem to:
1- Read login variables from the URL. The first system pass OTRS the user and pass in the URL.
2- Use SSO.. but how? I put the code in the .pm module, then the login call the page that I set but it not seems to works with the multiple users that are in the first System.
The first system has it own users in other mysql table than the Otrs and the idea is to add a menu to access OTRS functions with the same user and password.
Please, what is the best way?
IMO to create a own OTRS-SSO module (like Kernel/System/Auth/HTTPBasicAuth.pm). But (of course) you need to implement your own SSO mechanism into this module. (Just the point of my view)
best regards
Adrián
Martin Edenhofer -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication!
ok, thanks for your answer. If I want to read the customers table from another server what is the best option? 1. To move all the OTRS tables in the location of the other database 2. To keep both databases separated and only modify OTRS to read customers table of the other database. I think that the first is the best, but I don't know if I am wrong ("hacer lío" as we tell it in Argentina) again, really thank you best regards Adrián I have another question, it is possible to the customers
Hi Adrian,
On Mon, Apr 19, 2004 at 09:15:14PM +0200, Deccico Adrian wrote:
Ok, but now I am more confuse than in the beginning. I am thinking for my double login problem to:
1- Read login variables from the URL. The first system pass OTRS the user and pass in the URL.
2- Use SSO.. but how? I put the code in the .pm module, then the login call the page that I set but it not seems to works with the multiple users that are in the first System.
The first system has it own users in other mysql table than the Otrs and the idea is to add a menu to access OTRS functions with the same user and password.
Please, what is the best way?
IMO to create a own OTRS-SSO module (like Kernel/System/Auth/HTTPBasicAuth.pm).
But (of course) you need to implement your own SSO mechanism into this module.
(Just the point of my view)
best regards
Adrián
Martin Edenhofer
-- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication!
_______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
-- NEU : GMX Internet.FreeDSL Ab sofort DSL-Tarif ohne Grundgebühr: http://www.gmx.net/dsl
On Monday, April 19, 2004 10:36 PM
Deccico Adrian
If I want to read the customers table from another server what is the best option?
1. To move all the OTRS tables in the location of the other database
2. To keep both databases separated and only modify OTRS to read customers table of the other database.
I think that the first is the best, but I don't know if I am wrong ("hacer lío" as we tell it in Argentina)
2. Leave the tables where they are, and set in Config.pm: $Self->{CustomerUser} = { Name => 'Database', Module => 'Kernel::System::CustomerUser::DB', Params => { Table => 'customer_user', # to use an external database DSN => 'DBI:odbc:yourdsn', DSN => 'DBI:mysql:database=customerdb;host=customerdbhost', User => '', Password => '', }, # [...] more settings follow }, As long as you point OTRS to the outside, there's no need to destroy those "sleeping" tables. hth, Robert Kehl -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Tel. +49 (0)6172 4832388
participants (4)
-
Adrián Deccico -
Deccico Adrian
-
Martin Edenhofer -
Robert Kehl