[rt-users] Fwd: RT CLI login

2016-05-23 Thread Dave Florek
Hi,

So, I created the .rtrc file as requested but I'm still receiving the
following:

rt: Server error: Can't connect to localhost:443 (certificate verify
failed) (500)

How do I allow the RT CLI program to accept https connection certificates
and/or what would be the easiest way to drop https to login via RTCLI?

Thanks,

On Mon, May 9, 2016 at 2:26 PM, Dave Florek <dave.a.flo...@gmail.com> wrote:

>
> -- Forwarded message ------
> From: Dave Florek <dave.a.flo...@gmail.com>
> Date: Wed, May 4, 2016 at 1:00 PM
> Subject: Re: [rt-users] RT CLI login
> To: Dustin Graves <dus...@bestpractical.com>
> Cc: rt-users@lists.bestpractical.com
>
>
> Good afternoon,
>
> Thanks for the response. I'm not seeing the .rtrc file in my home
> directory. I added the username, password and URL via environment variables
> and I'm now receiving the following new error message:
>
> Server error: Can't connect to :443 (certificate
> verify failed)
>
>   (500)
>
>
> On Fri, Apr 29, 2016 at 2:02 PM, Dustin Graves <dus...@bestpractical.com>
> wrote:
>
>> Hi Dave,
>>
>> There are two ways to authenticate for the RT CLI.
>>
>> The first is environment variables RTUSER and RTPASSWD
>>
>> The second is an RT Config file .rtrc in your user’s home directory:
>>
>> server http://your.rt4.installation
>> user your.rtusername
>> passwd your rt password
>>
>>
>> I would verify that you can login to RT with your credentials before
>> using the CLI if you have doubts as to their validity. You can use any user
>> with the CLI, but you will be limited by their permissions. Generally it is
>> recommended to make a user specifically for use with the CLI so you can
>> grant only the permissions that you need.
>>
>> You can take a look at the wiki here for more information:
>> http://requesttracker.wikia.com/wiki/CLI
>>
>> Thank you,
>> Dustin
>>
>> On Apr 29, 2016, at 1:20 PM, Dave Florek <dave.a.flo...@gmail.com> wrote:
>>
>> Hi,
>>
>> I'm trying to use RT CLI to issue several commands however it asks for a
>> password and none of the ones I initially generated are working. Does the
>> rt cli program use the root password to work? I get an error (302) found
>> each time I attempt a login.
>>
>> Sincerely,
>> -
>> RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
>> * Washington DC - May 23 & 24, 2016
>>
>>
>>
>
>
-
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Los Angeles - September, 2016


Re: [rt-users] RT CLI login

2016-05-04 Thread Dave Florek
Good afternoon,

Thanks for the response. I'm not seeing the .rtrc file in my home
directory. I added the username, password and URL via environment variables
and I'm now receiving the following new error message:

Server error: Can't connect to :443 (certificate
verify failed)

  (500)


On Fri, Apr 29, 2016 at 2:02 PM, Dustin Graves <dus...@bestpractical.com>
wrote:

> Hi Dave,
>
> There are two ways to authenticate for the RT CLI.
>
> The first is environment variables RTUSER and RTPASSWD
>
> The second is an RT Config file .rtrc in your user’s home directory:
>
> server http://your.rt4.installation
> user your.rtusername
> passwd your rt password
>
>
> I would verify that you can login to RT with your credentials before using
> the CLI if you have doubts as to their validity. You can use any user with
> the CLI, but you will be limited by their permissions. Generally it is
> recommended to make a user specifically for use with the CLI so you can
> grant only the permissions that you need.
>
> You can take a look at the wiki here for more information:
> http://requesttracker.wikia.com/wiki/CLI
>
> Thank you,
> Dustin
>
> On Apr 29, 2016, at 1:20 PM, Dave Florek <dave.a.flo...@gmail.com> wrote:
>
> Hi,
>
> I'm trying to use RT CLI to issue several commands however it asks for a
> password and none of the ones I initially generated are working. Does the
> rt cli program use the root password to work? I get an error (302) found
> each time I attempt a login.
>
> Sincerely,
> -
> RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
> * Washington DC - May 23 & 24, 2016
>
>
>
-
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Washington DC - May 23 & 24, 2016


[rt-users] RT CLI login

2016-04-29 Thread Dave Florek
Hi,

I'm trying to use RT CLI to issue several commands however it asks for a
password and none of the ones I initially generated are working. Does the
rt cli program use the root password to work? I get an error (302) found
each time I attempt a login.

Sincerely,
-
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Washington DC - May 23 & 24, 2016


[rt-users] Importing ticketing data into the RT SQL database

2016-04-27 Thread Dave Florek
Hi,

I'm about to import a large amount of ticketing data into the RT SQL
database. I spotted three sections in the SQL db (objectcustomfieldvalues,
attachments, tickets) to import the data to. Since I'm unfamiliar with the
db backend, can I generate any of my own set of identifiers as long as they
aren't duplicate of the identifiers that are already present in the SQL db?

Thanks in advance,
-
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Washington DC - May 23 & 24, 2016


[rt-users] Easy way to import a CSV file into ticketing?

2016-03-31 Thread Dave Florek
Good afternoon,

If I have a CSV file full of information that I need to import into RT
that's not an asset, is there an easy way to do this? I'm looking at the
information posted in Postgresql for the database, and it looks doable,
however I'm not sure if I can do it with the UIDs that RT generates.

Any ideas?

Sincerely,
-
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Washington DC - May 23 & 24, 2016


[rt-users] RT backup and restore WebUI settings during an upgrade

2016-03-24 Thread Dave Florek
I'm noticing there's no easy way to backup and restore any Request Tracker
system settings such as accounts created, ticket custom fields, theme
settings, etc...

This might be more of a feature request, but can we have a way to backup
the specific files in an archived file for easy backup and restore?

The information here doesn't really cover specific files and folders within
/opt/rt to backup, so I'm not really sure where to go to backup and restore
these settings during a version upgrade.

https://docs.bestpractical.com/rt/4.2.12/backups.html
-
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Washington DC - May 23 & 24, 2016


[rt-users] RT 4.4.0 upgrade questions

2016-03-22 Thread Dave Florek
Hi,

I'm using RT 4.2 and I'm looking to upgrade to 4.4.0. I'm opting for a
complete wipe and reinstall because I added about 40 modules to RT 4.2 that
RT 4.4.0 integrated a few. If I do a backup of the PostGRESQL database I'm
using, would that data be compatible or easily restored in RT 4.4.0? I
don't know if the MySQL or PostGRESQL data changes formats in minor
releases. Could someone clarify?

Thanks,
-
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Washington DC - May 23 & 24, 2016