Manually creating a user in RT's db (MySQL)

Guys,

I am new to RT and a novice on MySQL. Currently, we do not allow auto
create for external senders to any of our Q’s, but one of our departments
want to use RT to start receiving emails (tickets) from an external source.
My questions is, if I create this external entity in the RT database, would
RT accept that, and if so, how in the heck do I create that entry in MySQL,
with the right permissions?

Many thanks …

Guys,
I am new to RT and a novice on MySQL. Currently, we do not allow auto create for external
senders to any of our Q’s, but one of our departments want to use RT to start receiving emails
(tickets) from an external source.
My questions is, if I create this external entity in the RT database, would RT accept that,
and if so, how in the heck do I create that entry in MySQL, with the right permissions?

You should be able to do this from Configuration → Users → Create

-kevin

Thank you Sir, I will give it a try. I was under the impression that this
is for users with the need to access RT, since this external just needs to
be able to send an email to RT and get a ticket create.

I will give a shot and see if it does the trick. I will let you know how it
tuns out.

AlbertoOn Wed, Jan 19, 2011 at 3:44 PM, Kevin Falcone falcone@bestpractical.comwrote:

On Wed, Jan 19, 2011 at 03:05:22PM -0800, Alberto Vazquez wrote:

Guys,
I am new to RT and a novice on MySQL. Currently, we do not allow auto
create for external
senders to any of our Q’s, but one of our departments want to use RT
to start receiving emails
(tickets) from an external source.
My questions is, if I create this external entity in the RT database,
would RT accept that,
and if so, how in the heck do I create that entry in MySQL, with the
right permissions?

You should be able to do this from Configuration → Users → Create

-kevin

Alberto Vazquez-Dzul
Email: betovaz@gmail.com
Mobile: (805) 444-0835
GVoice: (805) 768-4798

We usually setup our RT mail server to accept emails only from domain/user that are allowed to.
In exim, we have an acl looking like this :

drop
!senders = ·*@mydomain.com:my_allowed_used@hisdomain.comOn Thu, 20 Jan 2011 08:49:50 -0800 Alberto Vazquez wrote:

Thank you Sir, I will give it a try. I was under the impression that
this is for users with the need to access RT, since this external
just needs to be able to send an email to RT and get a ticket create.

I will give a shot and see if it does the trick. I will let you know
how it tuns out.

Alberto

On Wed, Jan 19, 2011 at 3:44 PM, Kevin Falcone falcone@bestpractical.comwrote:

On Wed, Jan 19, 2011 at 03:05:22PM -0800, Alberto Vazquez wrote:

Guys,
I am new to RT and a novice on MySQL. Currently, we do not
allow auto
create for external
senders to any of our Q’s, but one of our departments want to
use RT
to start receiving emails
(tickets) from an external source.
My questions is, if I create this external entity in the RT
database,
would RT accept that,
and if so, how in the heck do I create that entry in MySQL,
with the
right permissions?

You should be able to do this from Configuration → Users → Create

-kevin

Nicolas GUIOT
Risc Group - Service Production Exploitation
Alcatel/CTI - Av. du Gal de Gaulle
45140 ORMES - FRANCE
Tel : (+33) 2 38 71 84 98
Fax : (+33) 2 38 75 76 92

Cool, quick question. Which file do I need to modify?

Thanks,

AlbertoOn Thu, Jan 20, 2011 at 8:54 AM, Nicolas GUIOT <nicolas.guiot@risc-group.com wrote:

We usually setup our RT mail server to accept emails only from domain/user
that are allowed to.
In exim, we have an acl looking like this :

drop
!senders = ·*@mydomain.com:my_allowed_used@hisdomain.com

On Thu, 20 Jan 2011 08:49:50 -0800 Alberto Vazquez wrote:

Thank you Sir, I will give it a try. I was under the impression that
this is for users with the need to access RT, since this external
just needs to be able to send an email to RT and get a ticket create.

I will give a shot and see if it does the trick. I will let you know
how it tuns out.

Alberto

On Wed, Jan 19, 2011 at 3:44 PM, Kevin Falcone falcone@bestpractical.comwrote:

On Wed, Jan 19, 2011 at 03:05:22PM -0800, Alberto Vazquez wrote:

Guys,
I am new to RT and a novice on MySQL. Currently, we do not
allow auto
create for external
senders to any of our Q’s, but one of our departments want to
use RT
to start receiving emails
(tickets) from an external source.
My questions is, if I create this external entity in the RT
database,
would RT accept that,
and if so, how in the heck do I create that entry in MySQL,
with the
right permissions?

You should be able to do this from Configuration → Users → Create

-kevin


Nicolas GUIOT
Risc Group - Service Production Exploitation
Alcatel/CTI - Av. du Gal de Gaulle
45140 ORMES - FRANCE
Tel : (+33) 2 38 71 84 98
Fax : (+33) 2 38 75 76 92

Alberto Vazquez-Dzul
Email: betovaz@gmail.com
Mobile: (805) 444-0835
GVoice: (805) 768-4798

Thank you Sir, I will give it a try. I was under the impression that this is for users with
the need to access RT, since this external just needs to be able to send an email to RT and
get a ticket create.

Anyone who sends mail to RT gets a user account. If you’re limiting
ticket creation to existing accounts, you will need to create a user
that doesn’t have a password and isn’t allowed to be granted rights
but does have an email address.

-kevin

This worked, but I had to check the “Allow access to RT” option, otherwise
it would not work.

Thanks,

AlbertoOn Thu, Jan 20, 2011 at 9:00 AM, Kevin Falcone falcone@bestpractical.comwrote:

On Thu, Jan 20, 2011 at 08:49:50AM -0800, Alberto Vazquez wrote:

Thank you Sir, I will give it a try. I was under the impression that
this is for users with
the need to access RT, since this external just needs to be able to
send an email to RT and
get a ticket create.

Anyone who sends mail to RT gets a user account. If you’re limiting
ticket creation to existing accounts, you will need to create a user
that doesn’t have a password and isn’t allowed to be granted rights
but does have an email address.

-kevin

I will give a shot and see if it does the trick. I will let you know
how it tuns out.
Alberto

On Wed, Jan 19, 2011 at 3:44 PM, Kevin Falcone <[1] falcone@bestpractical.com> wrote:

 On Wed, Jan 19, 2011 at 03:05:22PM -0800, Alberto Vazquez wrote:
 > Guys,
 > I am new to RT and a novice on MySQL. Currently, we do not allow

auto create for external

 > senders to any of our Q's, but one of our departments want to use

RT to start receiving

 emails
 > (tickets) from an external source.
 > My questions is, if I create this external entity in the RT

database, would RT accept

 that,
 > and if so, how in the heck do I create that entry in MySQL, with

the right permissions?

 You should be able to do this from Configuration -> Users -> Create
 -kevin

Alberto Vazquez-Dzul
Email: betovaz@gmail.com
Mobile: (805) 444-0835
GVoice: (805) 768-4798

This worked, but I had to check the “Allow access to RT” option, otherwise it would not work.

Yes, otherwise you would disable the user, but they cannot log in without a password.

-kevin> On Thu, Jan 20, 2011 at 9:00 AM, Kevin Falcone <[1]falcone@bestpractical.com> wrote:

 On Thu, Jan 20, 2011 at 08:49:50AM -0800, Alberto Vazquez wrote:
 > Thank you Sir, I will give it a try. I was under the impression that this is for users
 with
 > the need to access RT, since this external just needs to be able to send an email to RT
 and
 > get a ticket create.

 Anyone who sends mail to RT gets a user account. If you're limiting
 ticket creation to existing accounts, you will need to create a user
 that doesn't have a password and isn't allowed to be granted rights
 but does have an email address.
 -kevin
 > I will give a shot and see if it does the trick. I will let you know how it tuns out.
 > Alberto
 >
 > On Wed, Jan 19, 2011 at 3:44 PM, Kevin Falcone <[1][2]falcone@bestpractical.com> wrote:
 >
 > On Wed, Jan 19, 2011 at 03:05:22PM -0800, Alberto Vazquez wrote:
 > > Guys,
 > > I am new to RT and a novice on MySQL. Currently, we do not allow auto create for
 external
 > > senders to any of our Q's, but one of our departments want to use RT to start receiving
 > emails
 > > (tickets) from an external source.
 > > My questions is, if I create this external entity in the RT database, would RT accept
 > that,
 > > and if so, how in the heck do I create that entry in MySQL, with the right permissions?
 >
 > You should be able to do this from Configuration -> Users -> Create
 > -kevin


Alberto Vazquez-Dzul
Email: [3]betovaz@gmail.com
Mobile: (805) 444-0835
GVoice: (805) 768-4798

References

Visible links

  1. mailto:falcone@bestpractical.com
  2. mailto:falcone@bestpractical.com
  3. mailto:betovaz@gmail.com