[rt-users] Fwd: RT CLI login
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 wrote: > > -- Forwarded message ------ > From: Dave Florek > Date: Wed, May 4, 2016 at 1:00 PM > Subject: Re: [rt-users] RT CLI login > To: Dustin Graves > 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 > 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 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
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 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 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
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
Re: [rt-users] Importing ticketing data into the RT SQL database
Hi Brent, Thanks for the heads up. Does Best Practical keep any updated documentation on the RT CLI syntax somewhere as the RT versions change? I have the Essentials book and the Wikia has some useful information, but I'd like something that provides in-depth coverage. I made several custom fields, so I'm not sure how that would change the CLI inputs. This is going to be a fun expedition. Sincerely, Dave On Wed, Apr 27, 2016 at 1:05 PM, Parish, Brent wrote: > Hi Dave > > > > I would strongly recommend against importing ticket data directly into the > RT database, I sincerely doubt you will end up with anything usable! > > There are a myriad of internal references (very normalized table > structure, as I’m sure you saw). > > > > There may be better ways to do it, but when I had to shift tickets from > two different support tools into RT I wrote an importer to do it. > > The importer used RT’s command line interface to push the old systems into > RT, one ticket at a time. > > That way, RT creates all the requisite references, objects, etc. > > > > As to adding your own fields to the RT database, I cannot answer that, > sorry! > > > > - Brent > > > > > > > > *From:* rt-users [mailto:rt-users-boun...@lists.bestpractical.com] *On > Behalf Of *Dave Florek > *Sent:* Wednesday, April 27, 2016 12:31 PM > *To:* rt-users@lists.bestpractical.com > *Subject:* [rt-users] Importing ticketing data into the RT SQL database > > > > 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] Importing ticketing data into the RT SQL database
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?
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
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
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