Re: [rt-users] New cert breaks mailgate
Hi Tim Thanks for the response. We tried that and could not get it to work either. Turns out our CA is pretty old and still running on a 2003 box. We were going to roll out RT to our staff first who all use domain machines that include our root CA cert already. The web portion worked fine. We were going to let our students eventually start sending requests and planned to get a commercial cert. This just pushed the time up a few months. So now we have a new project, upgrade our CA. On Tue, Feb 3, 2015 at 3:26 PM, Tim Wiley wrote: > On 02/03/2015 12:09 PM, mkyser wrote: > >> Well we finally figured out that the mailgate did not like our local CA. >> Went and bought a Thawte cert for RT and now everything is working as it >> should. The lesson here is spend the money and get a real cert! >> > > I wish I had gotten to this earlier. There's a better option in > rt-mailgate. What we've done is add --ca-file to the rt-mailgate command > in our postfix aliases. > > my-queue-address: "|/path/to/rt/bin/rt-mailgate --queue 'My Queue' > --action correspond --ca-file /path/to/your/root.crt --url > https://rt.example.com"; > > This of course means that you have to ship your root CA certificate with > the application, but that shouldn't be a big deal. > -- Mitch Kyser Network Administrator Albion.College mky...@albion.edu
[rt-users] New cert breaks mailgate
Hi, We just updated the cert from the default self signed cert to one from our local CA. We have the web server side working via https but now incoming email will not generate a new ticket or comment on an old one. Looking at the mail log it shows a 500 error, Can't connect to rt.x.x:443 (certificate verify failed). We are using the --no-verify-ssl flag in the aliases file for all the queues. Any suggestions on where to go from here? Thanks -- Mitch Kyser Network Administrator Albion.College mky...@albion.edu
Re: [rt-users] New error while importing assets
Thanks Kevin The Custom Field did apply to the relevant Catalogs. I sort of by-passed the issue. It seems the Unique CF I called ID Number or the column in the CSV I mapped to it (named ID and in the first column) might have had something to do with it. As I checked each error which gave a row number, I checked the rows around it to see if the record existed in the Catalog, The ones that didn't all had an ID Number under 40. So I edited the CSV by adding 1 to the ID field in the CSV. Those that I had edited were imported. I kept repeating this until all the records made it into the Catalog. It wasn't ideal but the job got done. On the other hand where can I get the newest Import Extension. I tried the Get Repository but that extracted to a folder numbered 1.1 Thanks again On Tue, Nov 11, 2014 at 2:16 PM, Kevin Falcone wrote: > On Mon, Nov 10, 2014 at 11:46:45AM -0500, Mitch Kyser wrote: > > After creating several Catalogs and successfully importing Assets into > them > > from CSV files, I am now getting an error I can't seem to figure out. > The > > error I am seeing looks like this; > > I'm guessing that maybe you forgot to apply one of your Custom Fields > across all the catalogs. > > > [1933] [Mon Nov 10 16:16:09 2014] [error]: Failed to set CF Model to > > GCS3-651-120-150A-5 for row 3: Custom field 13 does not apply to this > object (/ > > > opt/rt4/local/plugins/RT-Extension-Assets-Import-CSV/lib/RT/Extension/Assets/ > > Import/CSV.pm:167) > > If you navigate to Admin -> Custom Fields confirm that CF # 13 is an > Asset custom field then click into it and check that the Applies To > link in the upper right corner shows this custom field applied either > globally or to all the relevant Catalogs. > > RT-Extension-Assets-Import-CSV 1.4 was released but it doesn't touch > any of the relevant code. > > -kevin > -- Mitch Kyser Network Administrator Albion.College mky...@albion.edu
[rt-users] New error while importing assets
After creating several Catalogs and successfully importing Assets into them from CSV files, I am now getting an error I can't seem to figure out. The error I am seeing looks like this; [1933] [Mon Nov 10 16:16:09 2014] [error]: Failed to set CF Model to GCS3-651-120-150A-5 for row 3: Custom field 13 does not apply to this object (/opt/rt4/local/plugins/RT-Extension-Assets-Import-CSV/lib/RT/Extension/Assets/Import/CSV.pm:167) The data shown is the correct information that is supposed to go into the custom field named Model. I am also seeing this for other custom fields for and for multiple rows. I have compared the various rows that don't generate any errors and do not see any pattern. I did just upgrade to version 4.2.9 and add the CommandByMail extension. My system consists of the following running on Ubuntu Server 14.04. rt-4.2.9 RT-Authen-ExternalAuth-0.23.tar.gz RT-Extension-LDAPImport-0.35.tar.gz RT-Extension-Assets-1.01.tar.gz RT-Extension-Assets-Import-CSV-1.3.tar.gz with Text-CSV_XS-1.11 added RT-Extension-RepeatTicket-0.07.tar.gz RT-Extension-CommandByMail-0.17.tar.gz Any suggestions on how to resolve this would be appreciated. Mitch -- Mitch Kyser Network Administrator Albion.College mky...@albion.edu
Re: [rt-users] Assigning HeldBy users during Asset Import
Ok, after double checking my csv file and running a few more tests; If there is no user in the HeldBy field then the import will add the user in the csv file. If the user in the csv file is different from the user already in HeldBy then the import will add the user so you end up with multiple users in the HeldBy field. If the csv user is the same as the user already in HeldBy then no change is made. Thanks On Thu, Sep 18, 2014 at 11:21 AM, Kevin Falcone wrote: > On Thu, Sep 18, 2014 at 10:09:52AM -0400, Mitch Kyser wrote: > > role from my csv file. There were a few exceptions and any asset that > already > > had a HeldBy entry did not get updated. Thanks, that will get me by for > now. > > It should only be skipping this if the same user is specified as > HeldBy. You're seeing this even if it's a different user? > > > > > As for the issue with the Bulk Update, I was poking around and saw that > > somebody else had already sent in a bug report for it. > > Great. > > -kevin > > -- > RT Training November 4 & 5 Los Angeles > http://bestpractical.com/training > > -- Mitch Kyser Network Administrator Albion.College mky...@albion.edu -- RT Training November 4 & 5 Los Angeles http://bestpractical.com/training
Re: [rt-users] Assigning HeldBy users during Asset Import
After taking a little while to figure out just what the patch was (I've
never programmed in PERL before) I applied it to the CSV.pm along with the
lines I commented out above and I was able to use the import to populate
the HeldBy role from my csv file. There were a few exceptions and any
asset that already had a HeldBy entry did not get updated. Thanks, that
will get me by for now.
As for the issue with the Bulk Update, I was poking around and saw that
somebody else had already sent in a bug report for it.
On Wed, Sep 17, 2014 at 4:03 PM, Kevin Falcone
wrote:
> On Wed, Sep 17, 2014 at 02:27:57PM -0400, Mitch Kyser wrote:
> > Thanks for the response. I took a look at /opt/rt4/local/plugins/
> > RT-Extension-Assets-Import-CSV/lib/RT/Extension/Assets/Import/[1]CSV.PM
> and
> > removed the check you suggested by commenting out lines 64 thru 67;
> >
> > #if ( not RT::Asset->Role($fieldname)->{Single}) {
> > #RT->Logger->warning( "Role name $fieldname must be single-value for
> > "._column($field2csv->{$fieldname}).", skipping");
> > #delete $field2csv->{$fieldname};
> > #}
> >
> > Instead of the single warning I got one for each asset I tried to update
> that
> > had a username to be placed in the HeldBy field;
> >
> > [error]: Failed to set HeldBy to mkyser for row 5408: No valid Type
> specified
> >
> (/opt/rt4/local/plugins/RT-Extension-Assets-Import-CSV/lib/RT/Extension/Assets/
> > Import/CSV.pm:178)
> >
> > When I tried using 'Owner' instead of 'HeldBy' I got the same results.
>
> Try applying the change from the attached patch
>
> > I will see what it takes to submit a bug report like you suggested, then
> submit
> > one.
>
> I moved your bug report into the assets queue (rather than the general
> RT queue).
>
> > I am seeing similar things when I try to use the Bulk Update feature with
> > HeldBy, no error message but no change in HeldBy either.
>
> This should be a separate bug report.
>
> -kevin
>
> --
> RT Training - Boston, September 9-10
> http://bestpractical.com/training
>
--
Mitch Kyser
Network Administrator
Albion.College
mky...@albion.edu
--
RT Training November 4 & 5 Los Angeles
http://bestpractical.com/training
Re: [rt-users] Assigning HeldBy users during Asset Import
Hi Kevin
Thanks for the response. I took a look at
/opt/rt4/local/plugins/RT-Extension-Assets-Import-CSV/lib/RT/Extension/Assets/Import/
CSV.PM and removed the check you suggested by commenting out lines 64 thru
67;
#if ( not RT::Asset->Role($fieldname)->{Single}) {
#RT->Logger->warning( "Role name $fieldname must be single-value for
"._column($field2csv->{$fieldname}).", skipping");
#delete $field2csv->{$fieldname};
#}
Instead of the single warning I got one for each asset I tried to update
that had a username to be placed in the HeldBy field;
[error]: Failed to set HeldBy to mkyser for row 5408: No valid Type
specified
(/opt/rt4/local/plugins/RT-Extension-Assets-Import-CSV/lib/RT/Extension/Assets/Import/CSV.pm:178)
When I tried using 'Owner' instead of 'HeldBy' I got the same results.
I will see what it takes to submit a bug report like you suggested, then
submit one.
I am seeing similar things when I try to use the Bulk Update feature with
HeldBy, no error message but no change in HeldBy either.
Thanks again.
Mitch
On Wed, Sep 17, 2014 at 11:44 AM, Kevin Falcone
wrote:
> On Fri, Sep 12, 2014 at 10:15:19AM -0700, mkyser wrote:
> > 'Role name HeldBy must be single-value for column Username, skipping'
>
> For no particular reason, the code requires that you assign to a
> single-value Role and disallows roles that could contain multiple
> people.
>
> In the case of Assets, this means you could set Owner, but not Held
> By. This seems like an oversight. You can probably safely delete
> that check from CSV.pm and try importing, but it'll only allow a
> single Held By user to be added. We'd need to define a convention for
> having multiple people in that single column, possibly doing it by
> email address which is easily parseable with tools, but right now that
> column only goes by username (or user id).
>
> Try tweaking the code and definitely file a bug about this because it
> feels like an accidental oversight.
>
> -kevin
>
> --
> RT Training - Boston, September 9-10
> http://bestpractical.com/training
>
--
Mitch Kyser
Network Administrator
Albion.College
mky...@albion.edu
--
RT Training - Boston, September 9-10
http://bestpractical.com/training
