Re: [rt-users] Unable to connect to MySQL during RT upgrade

2016-10-10 Thread Matt Zagrabelny
Hi Alex, On Mon, Oct 10, 2016 at 5:07 PM, Alex Hall wrote: > After a few more repeats of some of the below steps, suddenly things worked. > I'm embarrassed to say I may have forgotten to specify rt441.* when granting > privileges, instead only entering rt441. In any case, the upgrade finally > ra

[rt-users] Asset Search handling/customization

2016-10-10 Thread TBecker
Hello All, we run RT Verion 4.4.1 and try to manage our assets with the system. We created custom fields and work with them to track the internal id of an asset. I now run into two problems/questions: 1. If we search for assets we get the standard table of results. Is there a way to change the

Re: [rt-users] Unable to connect to MySQL during RT upgrade

2016-10-10 Thread Bill Cole
On 10 Oct 2016, at 19:56, Alex Hall wrote: On Oct 10, 2016, at 18:18, Keith Edmunds wrote: The 'update-rt-siteconfig' command still seems to be working on the 4.2.8 install, not the new 4.4.1. update-alternatives(8) Typing the (8) exactly as shown gives me a syntax error, while leaving

Re: [rt-users] Bad characters in names loaded from LDAP (AD)

2016-10-10 Thread Bill Cole
On 10 Oct 2016, at 16:26, Jan Burian wrote: Hi all, we have RT 4.4.0 on CentOS 7 and Perl v5.22.1. And we are starting to use RT in production. We configured RT to authenticate users via LDAP (RT::Authen::ExternalAuth::LDAP). Our LDAP server is MS AD (Win 2008 R2). [...] Authentication is w

Re: [rt-users] Unable to connect to MySQL during RT upgrade

2016-10-10 Thread Alex Hall
> On Oct 10, 2016, at 18:18, Keith Edmunds wrote: > >> The 'update-rt-siteconfig' command still seems to be working on the 4.2.8 >> install, not the new 4.4.1. > > update-alternatives(8) Typing the (8) exactly as shown gives me a syntax error, while leaving it off offers options that don't ap

[rt-users] create transaction record

2016-10-10 Thread Bryon Baker
Hello List I have created a custom scrip the will respond to an email via a web service call. I would like to create a transaction with the return message. Can someone give me a little code snippet or some direction on how to create the transaction? With our creating or updating a custom fiel

Re: [rt-users] Unable to connect to MySQL during RT upgrade

2016-10-10 Thread Keith Edmunds
> The 'update-rt-siteconfig' command still seems to be working on the 4.2.8 > install, not the new 4.4.1. update-alternatives(8) Or, use the full command name. Try this: # update-rt-siteconfig -- "Soccer is one of those things that the rest of world cares about more than Americans do - you kno

Re: [rt-users] Unable to connect to MySQL during RT upgrade

2016-10-10 Thread Alex Hall
After a few more repeats of some of the below steps, suddenly things worked. I'm embarrassed to say I may have forgotten to specify rt441.* when granting privileges, instead only entering rt441. In any case, the upgrade finally ran, and I appear to be okay, save one thing: those RT_SiteConfig.d fil

[rt-users] Bad characters in names loaded from LDAP (AD)

2016-10-10 Thread Jan Burian
Hi all, we have RT 4.4.0 on CentOS 7 and Perl v5.22.1. And we are starting to use RT in production. We configured RT to authenticate users via LDAP (RT::Authen::ExternalAuth::LDAP). Our LDAP server is MS AD (Win 2008 R2). Our config of LDAP ExternalAuth in RT: Set($ExternalSettings, { '

[rt-users] Unable to connect to MySQL during RT upgrade

2016-10-10 Thread Alex Hall
Hello list, I'm upgrading from the Debian RT 4.2.8 package to the source 4.4.1, and am stuck at the 'make upgrade-database' step. When I enter the root password, my version, and 'y' to have it begin, it immediately says it can't connect and exits with code 255. Here's what I've tried thus far, in n

[rt-users] Having an issue trying to grant rights to back to root

2016-10-10 Thread Lori Welch
Ran into an issue, where I was trying to modify permissions on a user, and it changed root. Now my root is not a super user. I ran this command: perl -I /opt/rt4/lib -MRT -e' RT::LoadConfig(); RT::Init(); my $u = RT::User->new($RT::Systemuser); $u->Load("root"); print $u->PrincipalObj->GrantRigh

Re: [rt-users] Connecting RT to IBM iSeries and/or MSSQL databases?

2016-10-10 Thread Emmanuel Lacour
Le 10/10/2016 à 17:15, Alex Hall a écrit : > > > * Can Perl code in scripts talk to an external database as I've described? > yes, scrips run any kind of perl code, you can include needed modules. There is perl libs to talk to almost any kind of databases, even proprietary ones ;) A quick internet

Re: [rt-users] Connecting RT to IBM iSeries and/or MSSQL databases?

2016-10-10 Thread Martin Wheldon
Hi Alex, Sounds like you may be looking for the external custom fields functionality, please see the link below for details: https://docs.bestpractical.com/rt/4.4.1/extending/external_custom_fields.html Best Regards Martin On 2016-10-10 15:15, Alex Hall wrote: Hello list, Another day, anot

[rt-users] Connecting RT to IBM iSeries and/or MSSQL databases?

2016-10-10 Thread Alex Hall
Hello list, Another day, another proposed RT modification for me to investigate. Our company has six remote representatives who each have a few hundred customers they visit in person. The customer support team works locally, and is the group who actually enters all the tickets. We want reps to be a

[rt-users] List of assets in SelfService

2016-10-10 Thread Dimitris Maniadakis via rt-users
--- Begin Message --- Hello everyone, I have RT 4.4.1rc1 installed and need your help on the appearance of Assets in SelfService. Thus far, I have selected that a user in SelfService can see the Assets menu and can also see the listing of Assets he/she is: a.Owner b.Held By c.Contact. There appe

[rt-users] Create linked ticket to asset

2016-10-10 Thread Dimitris Maniadakis via rt-users
--- Begin Message --- Dear all, I have installed RT 4.4.1rc1 and need some help on the Assets part. In the SelfService (unprivileged user) a user can choose an asset and then "Create linked ticket" from "Actions". This gives the options to set as ticket Requestor either the asset Owner (if set) o