User Authentication

Hello,
I am running RT 4.2.9 on centos release 6.6 (final). I have tried many, many times to get RT::Authen::ExternalAuth to work and I am unsuccessful. Active directory 2008 R2. I have looked at almost every web page I can find on the subject, and have tried multiple configurations. I have made it to the point of giving up on the extension, and just having a separate username and password. I want all users except myself and one other to be unprivileged, which I have already setup permissions for unprivileged users to create and comment on their tickets. I was disappointed to learn that RT does not have a self-registration page, or a bulk input for users.

What I would like to do is, create CVS file with username and password, then import into mysql database. Can anyone point me in the direction of know what tables and fields need to be populated to create a user in mysql that the user will use to log into web interface of RT?

We will not be utilizing the mail function and it is not an option.
Jeremy Wilson
MIS Manager
540.217.4100 ext 257
Mobile: 540.333.1418
www.androsna.com http://www.androsna.com
[androsnortha]
The content of this e-mail (including any attachments) is strictly confidential and may be commercially sensitive. If you are not, or believe you may not be, the intended recipient, please advise the sender immediately by return e-mail, delete this e-mail and destroy any copies.

Hello,
I am running RT 4.2.9 on centos release 6.6 (final). I have tried many, many times to get RT::Authen::ExternalAuth to work and I am unsuccessful. Active directory 2008 R2. I have looked at almost every web page I can find on the subject, and have tried multiple configurations. I have made it to the point of giving up on the extension, and just having a separate username and password. I want all users except myself and one other to be unprivileged, which I have already setup permissions for unprivileged users to create and comment on their tickets. I was disappointed to learn that RT does not have a self-registration page, or a bulk input for users.

What I would like to do is, create CVS file with username and password, then import into mysql database. Can anyone point me in the direction of know what tables and fields need to be populated to create a user in mysql that the user will use to log into web interface of RT?

We will not be utilizing the mail function and it is not an option.

Why not just create users using the bin/rt utility?

Example:
/opt/rt4/bin/rt create -t users add Name=userName EmailAddress=email@address.com Password=password

More information can be found here:
http://requesttracker.wikia.com/wiki/CLI http://requesttracker.wikia.com/wiki/CLI

Landon Stewart : lstewart@iweb.com
Lead Specialist, Abuse and Security Management
Spécialiste principal, gestion des abus et sécurité
http://iweb.com : +1 (888) 909-4932

signature.asc (271 Bytes)

Yep, completely missed that. Looks like I could use the command tool to accomplish what I need. Thank you.On Apr 16, 2015, at 5:49 PM, Landon Stewart <lstewart@iweb.commailto:lstewart@iweb.com> wrote:

On Apr 16, 2015, at 1:28 PM, Jeremy Wilson <jwilson@androsna.commailto:jwilson@androsna.com> wrote:

Hello,
I am running RT 4.2.9 on centos release 6.6 (final). I have tried many, many times to get RT::Authen::ExternalAuth to work and I am unsuccessful. Active directory 2008 R2. I have looked at almost every web page I can find on the subject, and have tried multiple configurations. I have made it to the point of giving up on the extension, and just having a separate username and password. I want all users except myself and one other to be unprivileged, which I have already setup permissions for unprivileged users to create and comment on their tickets. I was disappointed to learn that RT does not have a self-registration page, or a bulk input for users.

What I would like to do is, create CVS file with username and password, then import into mysql database. Can anyone point me in the direction of know what tables and fields need to be populated to create a user in mysql that the user will use to log into web interface of RT?

We will not be utilizing the mail function and it is not an option.

Why not just create users using the bin/rt utility?

Example:
/opt/rt4/bin/rt create -t users add Name=userName EmailAddress=email@address.commailto:EmailAddress=email@address.com Password=password

More information can be found here:

Landon Stewart : lstewart@iweb.commailto:lstewart@iweb.com
Lead Specialist, Abuse and Security Management
Sp?cialiste principal, gestion des abus et s?curit?
http://iweb.com : +1 (888) 909-4932
Jeremy Wilson
MIS Manager
540.217.4100 ext 257
Mobile: 540.333.1418
www.androsna.com http://www.androsna.com
[androsnortha]
The content of this e-mail (including any attachments) is strictly confidential and may be commercially sensitive. If you are not, or believe you may not be, the intended recipient, please advise the sender immediately by return e-mail, delete this e-mail and destroy any copies.

Yep, completely missed that. Looks like I could use the command tool to accomplish what I need. Thank you.

You’re welcome. I should mention that at one place I worked at there was no way to let RT authenticate against an LDAP servce so instead I used perl to grab user data from the LDAP service to generate a “diff”. The perl script used the bin/rt utility to add or remove users depending on what the diff said. If there were no new or deleted users in the diff output then there was nothing to do. Just an idea that might help…

Landon Stewart : lstewart@iweb.com
Lead Specialist, Abuse and Security Management
Spécialiste principal, gestion des abus et sécurité
http://iweb.com : +1 (888) 909-4932

signature.asc (271 Bytes)