Re: [rt-users] What's huge RT/Mysql

[Matt Zagrabelny]

On Wed, Nov 4, 2015 at 3:23 PM, Albert Shih  wrote:
> Hi everyone,
>
> I would like to know without any customisation how can a RT instance with
> mysql backend can goes.

We use Pg, but there are places using MySQL that have many tickets.

>
> As I understand it's the number of tickets who can be a issue.

Perhaps at some very large scale.

> Sowhen it's can become a problem ? 50 000 ? 100 000 ? 500 000 ?

We run a small instance: ~100,000 tickets in the last 6 or so years.

-m

[rt-users] What's huge RT/Mysql

[Albert Shih]

Hi everyone,

I would like to know without any customisation how can a RT instance with
mysql backend can goes.

As I understand it's the number of tickets who can be a issue.

Sowhen it's can become a problem ? 50 000 ? 100 000 ? 500 000 ?

And same question with specific hardware (like mysql on SSD).

Regards.

JAS
--
Albert SHIH
DIO bâtiment 15
Observatoire de Paris
5 Place Jules Janssen
92195 Meudon Cedex
France
Téléphone : +33 1 45 07 76 26/+33 6 86 69 95 71
xmpp: j...@obspm.fr
Heure local/Local time:
mer 4 nov 2015 22:20:59 CET

Re: [rt-users] What's huge RT/Mysql

[Albert Shih]

 Le 04/11/2015 à 23:27:53+0100, Torsten Brumm a écrit
> Ok, we do around 800.000-1.000.000 Tickets a day. The DB is running since 14 
> years now. Don't See Any Problems with such small amount of Tickets.

What ? 1 000 000 tickets per day ? How that's possible ? from 14 years ?

that's mean close to 5 billions tickets ? Hard to belive...

Or do you mean you have 1 000 000 tickets inside your system.

Thanks for your answer.

Regards.

JAS
--
Albert SHIH
DIO bâtiment 15
Observatoire de Paris
5 Place Jules Janssen
92195 Meudon Cedex
France
Téléphone : +33 1 45 07 76 26/+33 6 86 69 95 71
xmpp: j...@obspm.fr
Heure local/Local time:
jeu 5 nov 2015 00:09:59 CET

Re: [rt-users] What's huge RT/Mysql

[Torsten Brumm]

Ok, we do around 800.000-1.000.000 Tickets a day. The DB is running since 14 
years now. Don't See Any Problems with such small amount of Tickets.

Von meinem iPhone gesendet

> Am 04.11.2015 um 22:23 schrieb Albert Shih :
> 
> Hi everyone,
> 
> I would like to know without any customisation how can a RT instance with
> mysql backend can goes.
> 
> As I understand it's the number of tickets who can be a issue.
> 
> Sowhen it's can become a problem ? 50 000 ? 100 000 ? 500 000 ?
> 
> And same question with specific hardware (like mysql on SSD).
> 
> Regards.
> 
> JAS
> --
> Albert SHIH
> DIO bâtiment 15
> Observatoire de Paris
> 5 Place Jules Janssen
> 92195 Meudon Cedex
> France
> Téléphone : +33 1 45 07 76 26/+33 6 86 69 95 71
> xmpp: j...@obspm.fr
> Heure local/Local time:
> mer 4 nov 2015 22:20:59 CET

[rt-users] Populate Custom Field with autocomplete

[Mattias Eriksson]

I have set up small incident tracking system with RT 4.2.

Custom fields with autocomplete is used to document at what site the
incident occurred and when resolved what pice of hardware was the cause.

Setting up the fields only lets me add possible sites and units in a static
list, in my view this should be a dynamic list based on the values earlyer
used for this field.

Shouldn't this be a simple choise in the setup?
Do you have to write your own module just for this?

I have started the modules, but my perl skills and google fail to deliver a
concrete answer, so I turn to you :)

Based on the example with the Groups.pm file I get it to use the group list
as suggestions, but changing that code to get values from the fields beats
me...

Hacking away guided by google has brougth me to changing:

my $groups = RT::Groups->new( $self->CurrentUser );
$groups->LimitToUserDefinedGroups;

to:

my $groups = RT::CustomFieldValues->new( $self->CurrentUser );
$groups->LimitToCustomField;

But I get no elemets back from this.
So, how far off am I?

Regards



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Populate-Custom-Field-with-autocomplete-tp60871.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.

Re: [rt-users] Ticket not created from external email using external auth

[Peter Viskup]

Hello,
thank you, Christian, that solved our issue.
Not sure how I could overlooked that option.

-- 
Peter

On Wed, Nov 4, 2015 at 5:44 PM, Christian Loos  wrote:

> Hi,
>
> I think you should add
> Set( $AutoCreateNonExternalUsers, 1 );
>
> See
>
> https://github.com/bestpractical/rt-authen-externalauth/blob/master/lib/RT/Authen/ExternalAuth.pm#L118
>
> Chris
>
> Am 04.11.2015 um 17:30 schrieb Peter Viskup:
> > Dear all,
> > would like to ask you for an expert view on our issue.
> >
> > We have RT 4.2 with ExternalAuth to LDAP (Microsoft AD) installed. All
> > seems to work fine. Except the ticket is not created when sending emails
> > from external email address.
> > All permissions were setup correctly based on how-to
> > http://requesttracker.wikia.com/wiki/ItsFinallyInstalledNowWhat .
> > Thank you for all your help in advance.
> >
> > These are relevant RT_SiteConfig.pm entries (LDAP auth is working and
> > LDAP users are created in RT):
> >
> > Plugin('RT::Authen::ExternalAuth');
> > Set( $ExternalAuthPriority, ["My_LDAP"] );
> > Set( $ExternalInfoPriority, ["My_LDAP"] );
> > Set( $WebRemoteUserAutocreate, 1 );
> > Set( $UserAutocreateDefaultsOnLogin, { Privileged => 0 } );
>
>

[rt-users] Ticket not created from external email using external auth

[Peter Viskup]

Dear all,
would like to ask you for an expert view on our issue.

We have RT 4.2 with ExternalAuth to LDAP (Microsoft AD) installed. All
seems to work fine. Except the ticket is not created when sending emails
from external email address.
All permissions were setup correctly based on how-to
http://requesttracker.wikia.com/wiki/ItsFinallyInstalledNowWhat .
Thank you for all your help in advance.

These are relevant RT_SiteConfig.pm entries (LDAP auth is working and LDAP
users are created in RT):

Plugin('RT::Authen::ExternalAuth');
Set( $ExternalAuthPriority, ["My_LDAP"] );
Set( $ExternalInfoPriority, ["My_LDAP"] );
Set( $WebRemoteUserAutocreate, 1 );
Set( $UserAutocreateDefaultsOnLogin, { Privileged => 0 } );

We see these messages:

Nov  4 16:13:10 rt-server RT: [30252] Going to create user with address '
skupko...@gmail.com'
(/opt/rt4/sbin/../lib/RT/Interface/Email/Auth/MailFrom.pm:100)
Nov  4 16:13:10 rt-server RT: [30252]
RT::Authen::ExternalAuth::CanonicalizeUserInfo called by
RT::Authen::ExternalAuth
/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm
885 with: Comments: Autocreated on ticket submission, Disabled: ,
EmailAddress: skupko...@gmail.com, Name: skupko...@gmail.com, Password: ,
Privileged: , RealName: Peter Viskup
(/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:792)
Nov  4 16:13:10 rt-server RT: [30252] Attempting to get user info using
this external service: My_LDAP
(/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:800)
Nov  4 16:13:10 rt-server RT: [30252] Attempting to use this
canonicalization key: Name
(/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:809)
Nov  4 16:13:10 rt-server RT: [30252] LDAP Search ===  Base:
dc=company,dc=com == Filter: (&(ObjectClass=*)(sAMAccountName=
skupko...@gmail.com)) == Attrs:
cn,mail,sAMAccountName,displayName,sAMAccountName
(/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:357)
Nov  4 16:13:10 rt-server RT: [30252] Attempting to use this
canonicalization key: EmailAddress
(/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:809)
Nov  4 16:13:10 rt-server RT: [30252] LDAP Search ===  Base:
dc=company,dc=com == Filter: (&(ObjectClass=*)(mail=skupko...@gmail.com))
== Attrs: cn,mail,sAMAccountName,displayName,sAMAccountName
(/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:357)
Nov  4 16:13:10 rt-server RT: [30252]
RT::Authen::ExternalAuth::CanonicalizeUserInfo returning Comments:
Autocreated on ticket submission, Disabled: , EmailAddress:
skupko...@gmail.com, Name: skupko...@gmail.com, Password: , Privileged: ,
RealName: Peter Viskup
Nov  4 16:13:10 rt-server RT: [30252] User could not be created: User
creation failed in mailgateway: Could not set user info
Nov  4 16:13:10 rt-server RT: [30252] Couldn't load user '
skupko...@gmail.com'.giving up
Nov  4 16:13:10 rt-server RT: [30252] User could not be loaded: User  '
skupko...@gmail.com' could not be loaded in the mail gateway
Nov  4 16:13:10 rt-server RT: [30252] Could not load a valid user: RT could
not load a valid user, and RT's configuration does not allow#012for the
creation of a new user for this email (skupko...@gmail.com).#012#012You
might need to grant 'Everyone' the right 'CreateTicket' for the#012queue
Whitehat.
Nov  4 16:13:10 rt-server RT: [30252] Could not load a valid user: RT could
not load a valid user, and RT's configuration does not allow#012for the
creation of a new user for your email.
Nov  4 16:13:10 rt-server RT: [30252] Could not record email: Could not
load a valid user

-- 
Peter Viskup

[rt-users] RT 4.2.6 Set Priority Via Mobile Interface

[Daniel Moore]

Hello,

I am still new to RT and I know that we have the Mobile Interface now and I've 
seen in multiple places where you cannot set the Priority or change other 
"Basic" information using the Mobile version.

I just wandering if anyone had an extension or scrip that would us change that 
information via the mobile application.


V/R,

Daniel Moore
IT Systems Technician
Osborne Wood Products, Inc.
[http://hosting-source.bm23.com/9241/public/OsborneLogo111.jpg]
P: 706.282.5764
F: 888.777.4304
http://www.osbornewood.com

Re: [rt-users] Ticket not created from external email using external auth

[Christian Loos]

Hi,

I think you should add
Set( $AutoCreateNonExternalUsers, 1 );

See
https://github.com/bestpractical/rt-authen-externalauth/blob/master/lib/RT/Authen/ExternalAuth.pm#L118

Chris

Am 04.11.2015 um 17:30 schrieb Peter Viskup:
> Dear all,
> would like to ask you for an expert view on our issue.
> 
> We have RT 4.2 with ExternalAuth to LDAP (Microsoft AD) installed. All
> seems to work fine. Except the ticket is not created when sending emails
> from external email address.
> All permissions were setup correctly based on how-to
> http://requesttracker.wikia.com/wiki/ItsFinallyInstalledNowWhat .
> Thank you for all your help in advance.
> 
> These are relevant RT_SiteConfig.pm entries (LDAP auth is working and
> LDAP users are created in RT):
> 
> Plugin('RT::Authen::ExternalAuth');
> Set( $ExternalAuthPriority, ["My_LDAP"] );
> Set( $ExternalInfoPriority, ["My_LDAP"] );
> Set( $WebRemoteUserAutocreate, 1 );
> Set( $UserAutocreateDefaultsOnLogin, { Privileged => 0 } );

Re: [rt-users] RT::Extension::LDAPImport and nested groups in Active Directory

[Benjamin Klier]

That looks promising, but unfortunately my perl isn't that good - maybe 
you could give me a small code example how to add my groups from AD and 
populate them with the AD users.


Re
Benjamin

Am 03.11.2015 um 19:04 schrieb Jeffrey Pilant:

Benjamin Klier writes:

I'm trying to import my users and groups from Active Directory. Getting
in the users works just fine, but importing the groups (with a
$LDAPGroupFilter like (|(CN=MY_RT_USERS_*)) ) is giving some errors.




The problem seems to be that in our AD the main groups norally just
concatenate other subgroups so that they doesn't include users but just
other groups, for example

MY_RT_USERS_AGENTS
   +
   +-> SOME_SUBGROUP
   |   +
   |   +> USER_1
   |   |
   |   +> USER_2
   |   |
   |   +> USER_3
   |
   +-> ANOTHER_SUBGROUP
   +
   +> USER_4
   |
   +> USER_5
   |
   +> ...

Unfortunately it's not an option to rework our AD group structure :-(

Crawling the rt-users archive didn't get me anywhat closer to find a
solution to that problem.

I'm using RT::Extension::LDAPImport v0.36

Maybe anyone has some experience with a configuration like that and
would be able to give me the missing hint :-)

Why flatten the AD structure?  You should be able to recreate it entirely with 
RT groups.

Psuedocode:
   Sub AddAGroup(SomeGroup)
   Obj = LDAP(SomeGroup)
   RT->AddGroiupName(Obj->Name)
   For each member in Obj:
 If member is a group then AddAGroup(member)
 RT->AddUserToGroup(Obj->Name, member)
   next.

This recursive algorithm should duplicate the AD layout below a node if you 
give it an AD node.

/jeff

The information contained in this e-mail is for the exclusive use of the
intended recipient(s) and may be confidential, proprietary, and/or
legally privileged.  Inadvertent disclosure of this message does not
constitute a waiver of any privilege.  If you receive this message in
error, please do not directly or indirectly use, print, copy, forward,
or disclose any part of this message.  Please also delete this e-mail
and all copies and notify the sender.  Thank you.

For alternate languages please go to http://bayerdisclaimer.bayerweb.com




--

Benjamin Klier
Systemadministration

Max-Planck-Institut für die Physik des Lichts
Guenther-Scharowsky-Str. 1/Bau 24
D-91058 Erlangen

Tel.: 09131-6877-511
Fax : 09131-6877-199

eMail : benjamin.kl...@mpl.mpg.de
http://www.mpl.mpg.de




smime.p7s
Description: S/MIME Cryptographic Signature