[rt-users] RT farming management?

2014-01-15 Thread Marc Chantreux
hello everyone, 

first, and as it is my first post, let me introduce myself:

I'm working as computer engineer at Strasbourg University (fr) where i'm
in charge of RT, sympa and Sogo. I'm a old perl monger (since '97) and
the author of few cpan modules (https://metacpan.org/author/MARCC), i
also am a former Koha ILS contributor and patched occasionally other oss
softwares as well as CPAN modules and tools (like dh-make-perl). 

Strasbourg university needs to provide more than one RTs to its large
community so we plan to use (and maybe write) a farm manager to ease the
process of deploying and updating lot of RT instances.

an instance would be a rt fcgid server (one per instance) started with fine
environment variables (CONFIG, local::lib, ...) behind nginx as a
dispatcher.

this tool must be capable to

* be installed and setup easlisy from CPAN
* install multiple versions and patches of RT codebase (running cpanm)
* easily setup, start, stop, and show the status rt instances
* easily archive an instance
* easily share extension to many instances

this tool must be capable to

the configuration of every instance could be tested (can access to DB,
local::lib is fully populated, ...) and easily backuped.

everything must be done via cli (optionnally, a little web app to
control the whole thing).

I don't see another simple solution (please don't tell me about the
configuration management systems) but maybe i'm wrong so any feedback
(or existing code, experiments,...) is welcomed.

If there is none, i'll start my project by next week.

regards
-- 
Marc Chantreux
Université de Strasbourg, Direction Informatique
14 Rue René Descartes,
67084  STRASBOURG CEDEX
☎: 03.68.85.57.40
http://unistra.fr
Don't believe everything you read on the Internet
-- Abraham Lincoln


Re: [rt-users] Kanban / agile workflows?

2014-03-04 Thread Marc Chantreux
On Tue, Mar 04, 2014 at 05:49:58AM +, Biju Chacko wrote:
 https://github.com/botsie/dirt 

thanks for sharing! i wish it would be a place on the web to 
collect those knid of links.


regards

-- 
Marc Chantreux
Université de Strasbourg, Direction Informatique
14 Rue René Descartes,
67084  STRASBOURG CEDEX
☎: 03.68.85.57.40
http://unistra.fr
Don't believe everything you read on the Internet
-- Abraham Lincoln
-- 
RT Training London, March 19-20 and Dallas May 20-21
http://bestpractical.com/training

[rt-users] RT::Client to list Status, Queues and so on

2014-03-11 Thread Marc Chantreux
hello rt users, 

as i more and more rely on mutt+vim+commandByMail, i would like
omnicompletion to complete the names of queues, status and categories
when i fill the ticket.

the only way i saw to get those list remotely is to scrap the
queryBuilder (/rt/Search/Build.html) which isn't that elegant and can be
boring. 

anyone with a best solution? 

regards
-- 
Marc Chantreux
Université de Strasbourg, Direction Informatique
14 Rue René Descartes,
67084  STRASBOURG CEDEX
☎: 03.68.85.57.40
http://unistra.fr
Don't believe everything you read on the Internet
-- Abraham Lincoln
-- 
RT Training London, March 19-20 and Dallas May 20-21
http://bestpractical.com/training

[rt-users] i use vim as rt client, so do you?

2014-06-26 Thread Marc Chantreux
hello, 

I wrote a vim wrapper to rt client so i can use it directly in vim  

https://github.com/eiro/vim-rt-client

which became my primary interface for RT. it's easy to send mail,
extend, sort tickets, create a set of tickets to share with other
people in a team.  

before improving this client, i would like to know if someone else
already have some related stuff to share. 

regards
-- 
Marc Chantreux
Université de Strasbourg, Direction Informatique
14 Rue René Descartes,
67084  STRASBOURG CEDEX
☎: 03.68.85.57.40
http://unistra.fr
Don't believe everything you read on the Internet
-- Abraham Lincoln
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

[rt-users] Faster RT via nginx? (Re: NoAuth CSS redirected ...)

2014-10-02 Thread Marc Chantreux
hello,

Kevin, you made my day! thank you! 

On Thu, Oct 02, 2014 at 11:00:47AM -0400, Kevin Falcone wrote:
 Have you tried the nginx config documented in RT first, before moving
 on to the custom one?
 
 http://bestpractical.com/docs/rt/latest/web_deployment.html#nginx

I have to admit i didn't ... but ...  comparing the 2 configs helped me
to catch the problem:

In my file, i wrote:

fastcgi_param SCRIPT_NAME ;
include fastcgi_params;

But fastcgi_params (as provided by debian) set fastcgi_param to
$fastcgi_script_name. this must be overwritten. 

include fastcgi_params;
fastcgi_param SCRIPT_NAME ;

works fine! 

 However, nginx is not my specialty, so I'm unlikely to be able to help
 debug further.

you did it so well. please note that my version use unix domains sockets
so there is no TCP overhead (it's faster and i do believe it spare
ressources).

also, i use upstream so i can add workers in the row:

upstream acme {
server unix:/tmp/rt.acme.sock.1;
server unix:/tmp/rt.acme.sock.2;
server unix:/tmp/rt.acme.sock.3;
}

however, i don't know if RT can handle more than one server of the
same instance in the same machine. also, i don't know if it could help
to serve more page.

experimenting this is on my todolist but every comment is welcome.

again, thanks for helping  

regards
-- 
Marc Chantreux,
Mes coordonnées: http://annuaire.unistra.fr/chercher?n=chantreux
Direction Informatique, Université de Strasbourg (http://unistra.fr) 
Service Métiers, Pôle Outils Collaboratifs
Don't believe everything you read on the Internet
-- Abraham Lincoln
-- 
RT Training November 4  5 Los Angeles
http://bestpractical.com/training


Re: [rt-users] is Disable 2 a typo?

2015-01-20 Thread Marc Chantreux
On Tue, Jan 20, 2015 at 11:27:04AM -0500, Kevin Falcone wrote:
 ___Approvals is a very special queue, so it gets a special Disabled
 value.  It's there to stop people breaking it by accident (something
 which happened quite frequently in 4.0 and earlier). 

thanks for answering, Kevin

-- 
Marc Chantreux,
Mes coordonnées: http://annuaire.unistra.fr/chercher?n=chantreux
Direction Informatique, Université de Strasbourg (http://unistra.fr) 
Don't believe everything you read on the Internet
-- Abraham Lincoln


[rt-users] is Disable 2 a typo?

2015-01-20 Thread Marc Chantreux
hello, 

in the etc/initialdata sample from the rt distrib, i can read

@Queues = ({ Name  = 'General',  
 Description   = 'The default queue',
 CorrespondAddress = , 
 CommentAddress= , },  
   { Name= '___Approvals',   
 Lifecycle   = 'approvals',  
 Description = 'A system-internal queue for the approvals system',
 Disabled= 2, } ); 

But there is only 2 documented values (by documented, i meant
https://bestpractical.com/docs/rt/latest/RT/Queue.html#SetDisabled). 

so my question is: is there a point to use different values that the documented 
ones? what is it? 

regards.
-- 
Marc Chantreux,
Mes coordonnées: http://annuaire.unistra.fr/chercher?n=chantreux
Direction Informatique, Université de Strasbourg (http://unistra.fr) 
Don't believe everything you read on the Internet
-- Abraham Lincoln


Re: [rt-users] RT Installation

2015-01-27 Thread Marc Chantreux
On Tue, Jan 27, 2015 at 09:31:26PM +0100, Rainer Duffner wrote:
 Why RT and RTIR are so hard to install and work properlly? I dont know
 perl  
 Here’s your problem ;-)
 Most people probably stopped reading right there.  

seriously? assuming that the sysop is comming with a basic admin skill
(knowing what make do and how to setup an nginx to communicate with
fcgi), perl programs are quiet easy to install when someone pointed you
on the good ressources:  

https://bestpractical.com/docs/rt/4.2/ 

especially 
https://bestpractical.com/docs/rt/4.2/initialdata.html

and 
https://bestpractical.com/docs/rt/4.2/rt-server.fcgi.html 

and when it comes to perl dependecies: 

https://metacpan.org/release/App-cpanminus
https://metacpan.org/pod/local::lib 

and if you're using a debian derrivative; apt-get install dh-make-perl
and run your own debian repo.

I really think that the perl ecosystem makes perl applications the
easiest to install (comparing to other dynamic langages like python or
ruby... not to mention npm)

The problem is not to have a running RT but frankly, i have very hard
time to figure out how to set it up correctly. the missing documentation 
is something that explain the general philosophy of RT for
administrators and some step by step tutorials (for example: installing
a notification or a basic ticket routing).

I guess that's what we learn from the best practical trainings but
comming from a french university, london wasn't that affordable.  

regards

-- 
Marc Chantreux,
Mes coordonnées: http://annuaire.unistra.fr/chercher?n=chantreux
Direction Informatique, Université de Strasbourg (http://unistra.fr) 
Don't believe everything you read on the Internet
-- Abraham Lincoln


Re: [rt-users] Login in unix

2015-03-05 Thread Marc Chantreux
On Mon, Mar 02, 2015 at 12:44:16PM +1300, Aaron Guise wrote:
 You cannot.  The users created in the Web UI are only for RT.  To login to 
 *NIX
 you need to create the user at the OS level.  

 Of course you could do the user creation with a scrip once the user is
 created.  Not sure I would though as personally I prefer to closely control
 whom gets access to my systems.

you should consider investiguating some PAM/NSS solutions to use the RT
table users to provide de passwd database.

# aptitude search '~npam ~nsql' -F '%p %d' 

libpam-mysql   Module PAM permettant l'authentification depu
libpam-mysql:i386  Module PAM permettant l'authentification depu
libpam-pgsql   Module PAM pour  l'authentification depuis un
libpam-pgsql:i386  Module PAM pour  l'authentification depuis un


-- 
Marc Chantreux,
Mes coordonnées: http://annuaire.unistra.fr/chercher?n=chantreux
Direction Informatique, Université de Strasbourg (http://unistra.fr) 
Don't believe everything you read on the Internet
-- Abraham Lincoln


[rt-users] store data in flat files

2015-05-06 Thread Marc Chantreux
hello people,  

i would like to store (or sync from) the scrips, conditions and
templates into files instead of databases. is there a way to do that? 

regards 
-- 
Marc Chantreux,
Mes coordonnées: http://annuaire.unistra.fr/chercher?n=chantreux
Direction Informatique, Université de Strasbourg (http://unistra.fr) 
Don't believe everything you read on the Internet
-- Abraham Lincoln


Re: [rt-users] XLS export balks

2015-09-11 Thread Marc Chantreux
> you would better use a branch for upstream and one for your (or many if
> you have prod/staging/...).

i really would like but i don't know how to run RT from the sources
(it seems you need to install it somewhere and run it from this place).

> It's easier when you need to upgrade RT or compare your patches with
> upstream...

i patch the installed versions and maintain my own repos :( this is sad
and i would be really happy to change it.  

regards 

-- 
Marc Chantreux,
Mes coordonnées: http://annuaire.unistra.fr/chercher?n=chantreux
Direction Informatique, Université de Strasbourg (http://unistra.fr) 
"Don't believe everything you read on the Internet"
-- Abraham Lincoln


[rt-users] External module publication on CPAN?

2015-09-11 Thread Marc Chantreux
Hello,

I wrote a script to supply initial datas to RT from an spreadsheet
(excel and libreoffice are repported as working). if some advices
can be given about publishing it (on CPAN), it would be appreciated
(a good name for the module, a place to register it...). 

my module is on gh:


https://github.com/eiro/p5-rtx-provision-read-speadsheet/blob/master/bin/rt-provision-spreadsheet
 

and my cpan account is:

https://metacpan.org/author/MARCC


-- 
Marc Chantreux,
Mes coordonnées: http://annuaire.unistra.fr/chercher?n=chantreux
Direction Informatique, Université de Strasbourg (http://unistra.fr) 
"Don't believe everything you read on the Internet"
-- Abraham Lincoln