[rt-users] Problems with Centos 6.2, apache and publish RT and PHPmyadmin sites with mod_fcgid

2012-03-14 Thread Juanjo 
Hello.

First saludate to all, and sorry for my bad english.

I have one question.


I have two virtual host, one for RT and one for phpmyadmin.
I have a conf file for each in /etc/httpd/conf.d/ directory



# phpmyadmin.conf
# Web application to manage MySQL
#


# Order Deny,Allow
# Deny from all
# Allow from 127.0.0.1
Allow from All


Alias /phpmyadmin /usr/share/phpmyadmin
Alias /phpMyAdmin /usr/share/phpmyadmin
Alias /mysqladmin /usr/share/phpmyadmin



# rt4.conf

### Optional apache logs for RT
# Ensure that your log rotation scripts know about these files
# ErrorLog /opt/rt4/var/log/apache2.error
# TransferLog /opt/rt4/var/log/apache2.access
# LogLevel debug
AddDefaultCharset UTF-8
Alias /NoAuth/images/ /opt/rt4/share/html/NoAuth/images/
ScriptAlias / /opt/rt4/sbin/rt-server.fcgi/
DocumentRoot "/opt/rt4/share/html"

Order allow,deny
Allow from all
Options +ExecCGI
AddHandler fcgid-script fcgi



But when i try to access i get an empty page with "not found" message.
I see my /var/log/httpd/error_log file and i get this:

[Tue Mar 13 15:07:46 2012] [error] [client 182.186.5.39] File does not
exist: /opt/rt4/sbin/rt-server.fcgi/phpmyadmin/index.php
[Tue Mar 13 15:17:11 2012] [error] [client 182.186.5.39] File does not
exist: /opt/rt4/sbin/rt-server.fcgi/

Any help?
Kindest Regards.

[rt-users] Problems installing RT 4.0.5 with mod_fcgid

2012-03-14 Thread Juanjo 
Hi to all.

Im trying to install  a CentOS
6.2 machine with the Request Tracker Software (RT).
Its a web-perl app to manage support tickets.

I see that is recomended use mod_fcgid and install the server with centos
6.2, mysql , apache and the
requeriments to run RT.

I installed  all (mod_fcgid from
rpm from last tar.gz sources).

The server works fibne. I can get running the Apache test page, and
myphpadmin.

 Code:

yum install httpd-devel
Download source mod_fcgid.
wget http://www.apache.org/dist/httpd/mod_fcgid/mod_fcgid-2.3.6.tar.gz

Install mod_fcgid.
tar -zxvf src/mod_fcgid-2.3.6.tar.gz
cd mod_fcgid-2.3.6
./configure.apxs
make
make install
Configure FCGID populating the conf file.
nano -w /etc/httpd/conf.d/php-fcgid.conf


DefaultInitEnv PHPRC=/etc
AddHandler php-fcgi .php
FcgidConnectTimeout 20
MaxRequestLen 210
Action php-fcgi /fcgi-bin/php-fcgi-wrapper
AddType application/x-httpd-php .php
Alias /fcgi-bin/ /var/www/fcgi-bin.d/default/

SetHandler fcgid-script
Options +ExecCGI


FcgidIOTimeout 2000
IdleScanInterval 5
BusyScanInterval 5
DefaultMinClassProcessCount 0
DefaultMaxClassProcessCount 10
IPCCommTimeout 60
IPCConnectTimeout 60
IdleTimeout 5

Nex try to restart httpd and get this.

[root@rt2 conf.d]# /etc/init.d/httpd restart
Stopping httpd: [FAILED]
Starting httpd: Syntax error on line 19 of /etc/httpd/conf.d/php-fcgid.conf:
Invalid command 'IdleScanInterval', perhaps misspelled or defined by a
module not included in the server
configuration
[FAILED]

doesn´t accept any line under "" in the
/etc/httpd/conf.d/php-fcgid.conf file.


Any help, please??

Thanks.
Kindest regards.

Re: [rt-users] Invalid username

2012-03-14 Thread Mario Giammarco 
Kevin Falcone  bestpractical.com> writes:


> Where do you try to add them, in what text box.
> Also, it isn't clear what you mean by adding them to a custom field.

Many places, example:

tools->configuration->queue->select->"general">user rights->
now on the left you can input an user name. Then I click on checkbox 
"view custom fields value" and immediately "invalid user" appears.


> Do you see the custom field as you expect if you log in as root?

Root user sees custom field

[rt-users] Internal Server error, when trying to acces RT4.0.5

2012-03-14 Thread Juanjo 
Hello.

Sorry for all the messages. I´m very frustraring with this installation.

I install all the system, and install and initialize the database.
Configure /opt/rt4/etc/RT_SiteConfig.pm, reload Apache.
And get and 500 Interal Server Error.

This is my /var/log/httpd/error_log output.

[Wed Mar 14 12:20:20 2012] [crit]: Could not create
'/opt/rt4/var/mason_data/obj/.__obj_create_marker': Permission denied
Stack:
  [/usr/local/share/perl5/HTML/Mason/Interp.pm:222]
  [/usr/local/share/perl5/HTML/Mason/Interp.pm:169]
  [/usr/local/share/perl5/HTML/Mason/Interp.pm:155]
  [/usr/local/share/perl5/Class/Container.pm:329]
  [/usr/local/share/perl5/Class/Container.pm:53]
  [/usr/local/share/perl5/HTML/Mason/CGIHandler.pm:48]
  [/usr/local/share/perl5/HTML/Mason/PSGIHandler.pm:14]
  [/opt/rt4/sbin/../lib/RT/Interface/Web/Handler.pm:111]
  [/opt/rt4/sbin/../lib/RT/Interface/Web/Handler.pm:220]
  [/opt/rt4/sbin/rt-server.fcgi:144] (/opt/rt4/sbin/../lib/RT.pm:341)
Died at /opt/rt4/sbin/../lib/RT.pm line 343.
[Wed Mar 14 13:20:20 2012] [warn] [client 172.16.5.39] (104)Connection
reset by peer: mod_fcgid: error reading data from FastCGI server
[Wed Mar 14 13:20:20 2012] [error] [client 172.16.5.39] Premature end of
script headers: rt-server.fcgi

Any help will be appreciated.
Kindest regards.

Re: [rt-users] Problems installing RT 4.0.5 with mod_fcgid

2012-03-14 Thread Juanjo 
Solved.

The error are mod_fcgid. I installed it manually but doesn´t works. Y use
the EPEL respository  and install it with YUM. Now works, i have another
problems, but works.

Kindest regards.

El 14 de marzo de 2012 09:56, Juanjo  escribió:

> Hi to all.
>
> Im trying to install  a CentOS
> 6.2 machine with the Request Tracker Software (RT).
> Its a web-perl app to manage support tickets.
>
> I see that is recomended use mod_fcgid and install the server with centos
> 6.2, mysql , apache and the
> requeriments to run RT.
>
> I installed  all (mod_fcgid
> from rpm from last tar.gz sources).
>
> The server works fibne. I can get running the Apache test page, and
> myphpadmin.
>
>  Code:
>
> yum install httpd-devel
> Download source mod_fcgid.
>   wget http://www.apache.org/dist/httpd/mod_fcgid/mod_fcgid-2.3.6.tar.gz
>   
> Install mod_fcgid.
>   tar -zxvf src/mod_fcgid-2.3.6.tar.gz
>   cd mod_fcgid-2.3.6
>   ./configure.apxs
>   make
>   make install
> Configure FCGID populating the conf file.
>   nano -w /etc/httpd/conf.d/php-fcgid.conf
>
>   
>   DefaultInitEnv PHPRC=/etc
>   AddHandler php-fcgi .php
>   FcgidConnectTimeout 20
>   MaxRequestLen 210
>   Action php-fcgi /fcgi-bin/php-fcgi-wrapper
>   AddType application/x-httpd-php .php
>   Alias /fcgi-bin/ /var/www/fcgi-bin.d/default/
>   
>   SetHandler fcgid-script
>   Options +ExecCGI
>   
>   
>   FcgidIOTimeout 2000
>   IdleScanInterval 5
>   BusyScanInterval 5
>   DefaultMinClassProcessCount 0
>   DefaultMaxClassProcessCount 10
>   IPCCommTimeout 60
>   IPCConnectTimeout 60
>   IdleTimeout 5
>
> Nex try to restart httpd and get this.
>
> [root@rt2 conf.d]# /etc/init.d/httpd restart
> Stopping httpd: [FAILED]
> Starting httpd: Syntax error on line 19 of
> /etc/httpd/conf.d/php-fcgid.conf:
> Invalid command 'IdleScanInterval', perhaps misspelled or defined by a
> module not included in the server 
> configuration
> [FAILED]
>
> doesn´t accept any line under "" in the
> /etc/httpd/conf.d/php-fcgid.conf file.
>
>
> Any help, please??
>
> Thanks.
> Kindest regards.




-- 
Un saludo.
Juanjo Corral

Re: [rt-users] Problems with Centos 6.2, apache and publish RT and PHPmyadmin sites with mod_fcgid

2012-03-14 Thread Juanjo 
Solved.

The error are mod_fcgid. I installed it manually but doesn´t works. Y use
the EPEL respository  and install it with YUM. Now works, i have another
problems, but works.

Kindest regards

El 14 de marzo de 2012 09:55, Juanjo  escribió:

> Hello.
>
> First saludate to all, and sorry for my bad english.
>
> I have one question.
>
>
> I have two virtual host, one for RT and one for phpmyadmin.
> I have a conf file for each in /etc/httpd/conf.d/ directory
>
>
>
> # phpmyadmin.conf
> # Web application to manage MySQL
> #
>
> 
> # Order Deny,Allow
> # Deny from all
> # Allow from 127.0.0.1
> Allow from All
> 
>
> Alias /phpmyadmin /usr/share/phpmyadmin
> Alias /phpMyAdmin /usr/share/phpmyadmin
> Alias /mysqladmin /usr/share/phpmyadmin
>
>
>
> # rt4.conf
> 
> ### Optional apache logs for RT
> # Ensure that your log rotation scripts know about these files
> # ErrorLog /opt/rt4/var/log/apache2.error
> # TransferLog /opt/rt4/var/log/apache2.access
> # LogLevel debug
> AddDefaultCharset UTF-8
> Alias /NoAuth/images/ /opt/rt4/share/html/NoAuth/images/
> ScriptAlias / /opt/rt4/sbin/rt-server.fcgi/
> DocumentRoot "/opt/rt4/share/html"
> 
> Order allow,deny
> Allow from all
> Options +ExecCGI
> AddHandler fcgid-script fcgi
> 
> 
>
> But when i try to access i get an empty page with "not found" message.
> I see my /var/log/httpd/error_log file and i get this:
>
> [Tue Mar 13 15:07:46 2012] [error] [client 182.186.5.39] File does not
> exist: /opt/rt4/sbin/rt-server.fcgi/phpmyadmin/index.php
> [Tue Mar 13 15:17:11 2012] [error] [client 182.186.5.39] File does not
> exist: /opt/rt4/sbin/rt-server.fcgi/
>
> Any help?
> Kindest Regards.




-- 
Un saludo.
Juanjo Corral

Re: [rt-users] Internal Server error, when trying to acces RT4.0.5

2012-03-14 Thread Thomas Sibley 
On 03/14/2012 08:24 AM, Juanjo wrote:
> I install all the system, and install and initialize the database.
> Configure /opt/rt4/etc/RT_SiteConfig.pm, reload Apache.
> And get and 500 Interal Server Error.
> 
> This is my /var/log/httpd/error_log output.
> 
> [Wed Mar 14 12:20:20 2012] [crit]: Could not create
> '/opt/rt4/var/mason_data/obj/.__obj_create_marker': Permission denied

The mailing list contains many examples of this problem.  You need to
make sure /opt/rt4/var/mason_data/ and everything under it is
readable/writeable by the user/group the webserver runs as.

This isn't generally a problem unless you've run a standalone server by
hand as root before running apache.

Re: [rt-users] Sending emails issue

2012-03-14 Thread Wiktor Cetera 
> Hi
> I have a problem with mail sending from Request Tracker (version 4.05).
> My server is running on Unix. Msmtp is configured properly (I am able to
> send an email from server on gmail).
> The issue is that RT can`t send email to gmail (for example i have no
> information about ticket update).
> Of course I`ve configured all like is on this document:
> http://requesttracker.wikia.com/wiki/Msmtp
>
> I`ve also tried MailX with the same result.
>
> Can you give me a solution?
>
> Best Regards
> Victor
> Poland
>

Re: [rt-users] Sending emails issue

2012-03-14 Thread Alberto Villanueva 

Have you looked the error message into the log files?




Hi
I have a problem with mail sending from Request Tracker (version 4.05).
My server is running on Unix. Msmtp is configured properly (I am
able to send an email from server on gmail).
The issue is that RT can`t send email to gmail (for example i have
no information about ticket update).
Of course I`ve configured all like is on this document:
http://requesttracker.wikia.com/wiki/Msmtp

I`ve also tried MailX with the same result.

Can you give me a solution?

Best Regards
Victor
Poland




--
Alberto Villanueva
Industria
__

C/Campezo, 1, Edificio 1
28022 Madrid, Spain
Tel : + 34 91 550 41 00
Fax: + 34 91 415 61 53

www.altran.es
www.altran360.es

Antes de imprimir este mensaje, asegúrate de que es necesario. Proteger 
el medio ambiente está también en tu mano.
En cumplimiento de la Ley Orgánica 15/1999, con fecha 13 de diciembre, 
de Protección de Datos de Carácter Personal, y la Ley 34/2002, con fecha 
11 de julio, de Servicios de la Sociedad de la Información y de comercio 
electrónico, le comunicamos que su dirección de correo electrónico forma 
parte de un fichero del que es responsable Altran España, y que 
garantiza la confidencialidad y seguridad de sus datos. Tiene usted 
derecho al acceso, rectificación y cancelación de sus datos en los 
términos establecidos en la Ley Orgánica 15/1999 de Protección de Datos 
de Carácter Personal y demás normativa concordante, dirigiéndose a 
nuestra dirección anteriormente señalada o por medio de correo 
electrónico: comunicac...@altran.es.


AVISO LEGAL: Este mensaje, junto con cualquier fichero adjunto, está 
dirigido a su destinatario y es confidencial. Cualquier distribución, 
uso o reproducción sin consentimiento del remitente está estrictamente 
prohibido. Si ha recibido este mensaje por error, por favor proceda a 
ponerlo en conocimiento del remitente por e-mail y a borrarlo de su 
sistema sin realizar copias.

Re: [rt-users] Internal Server error, when trying to acces RT4.0.5

2012-03-14 Thread Thomas Sibley 
On 03/14/2012 09:46 AM, Juanjo wrote:
> Sorry Selinux is the problem.
> 
> Disable it, restarted and works :D

I believe there are solutions less drastic than disabling selinux in the
list archives, if you're interested.

[rt-users] User stats

2012-03-14 Thread Yan Seiner 
Is there some way to pull the transactions a user has made from the database?

I'd like to be able to compile all of the statistics on a per-user basis. 
Things like # of tickets created, modified, etc.  We don't use time
worked.

The BP website shows two "Activity Reports" extensions but they seem to be
unmaintained or gone.

Anyone know of a maintained extension?

--Yan


-- 
On two occasions I have been asked,—"Pray, Mr. Babbage, if you put into
the machine wrong figures, will the right answers come out?" ... I am not
able rightly to apprehend the kind of confusion of ideas that could
provoke such a question.
—Charles Babbage, Inventor of the computer, 1864

Re: [rt-users] User stats

2012-03-14 Thread Kevin Falcone 
On Wed, Mar 14, 2012 at 10:21:51AM -0700, Yan Seiner wrote:
> Is there some way to pull the transactions a user has made from the database?
> 
> I'd like to be able to compile all of the statistics on a per-user basis. 
> Things like # of tickets created, modified, etc.  We don't use time
> worked.
> 
> The BP website shows two "Activity Reports" extensions but they seem to be
> unmaintained or gone.

The homepage link for Activity Reports links to the module on
search.cpan.org, and most of the changes for the development release
of 1.01_01 are 4.0 compatibility fixes.

Did installing 1.01_01 fail in some way?

Other than custom code, this is the best way to start seeing the data
you want.

-kevin


pgpjL3QPKrvTL.pgp
Description: PGP signature

Re: [rt-users] User stats

2012-03-14 Thread Yan Seiner 

On Wed, March 14, 2012 10:29 am, Kevin Falcone wrote:

>
> The homepage link for Activity Reports links to the module on
> search.cpan.org, and most of the changes for the development release
> of 1.01_01 are 4.0 compatibility fixes.
>
> Did installing 1.01_01 fail in some way?
>
> Other than custom code, this is the best way to start seeing the data
> you want.

Cool.  I went by the homepage link stating that it's for 3.8 and assumed
it was not out for 4.0 yet

I'll try it now.

-- 
On two occasions I have been asked,—"Pray, Mr. Babbage, if you put into
the machine wrong figures, will the right answers come out?" ... I am not
able rightly to apprehend the kind of confusion of ideas that could
provoke such a question.
—Charles Babbage, Inventor of the computer, 1864

Re: [rt-users] rt-mailgate 302 Error. No, not Plack.

2012-03-14 Thread Jourdan Perla 

> Please - keep list replies on the list.

Sorry, will do.

Thought I had this licked, but now as I build a *clean* production image, I'm 
running into the same error again..

$ cat mbox | /usr/bin/rt-mailgate --queue general --action correspond --url 
http://rt.myserver.com /rt -debug
/usr/bin/rt-mailgate: temp file is '/tmp/Dm_pceG62x'
/usr/bin/rt-mailgate: connecting to 
http://rt.myserver.com/rt/REST/1.0/NoAuth/mail-gateway
An Error Occurred
=

302 Found

/usr/bin/rt-mailgate: undefined server error

Grep all my logs for what happens at the same time and
apache2/access.log:
rt.myserver.com - - [14/Mar/2012:14:05:33 -0700] "POST 
/rt/REST/1.0/NoAuth/mail-gateway HTTP/1.1" 302 715 "-" "libwww-perl/6.04"
mail.info:
Mar 14 14:05:33 RT-PROD-SVR postfix/qmgr[4393]: 17286120B94: 
from=, size=7604, nrcpt=1 (queue active)
mail.info:
Mar 14 14:05:33 RT-PROD-SVR postfix/local[29538]: 88DCB1207CF: 
to=http://rt.myserver.com/REST/1.0/NoAuth/mail-gateway An Error 
Occurred =  302 Found  /usr/bin/rt-mailgate: undefined server 
error )

rt3.log shows nothing but:
[Wed Mar 14 15:56:08 2012] [error]: gpg: error reading key: secret key not 
available (/usr/share/request-tracker3.8/lib/RT/Crypt/GnuPG.pm:2078)
Which is from earlier.

/etc/aliases:
# See man 5 aliases for format
postmaster:myroot
help:  "|/usr/bin/rt-mailgate --queue general --action correspond --url 
http://rt.myserver.com/rt -debug"
comment: "|/usr/bin/rt-mailgate --queue general --action comment --url 
http://rt.myserver.com/rt -debug"


I've got the following in my httpd.conf


   AllowOverRide None
   Satisfy Any


   AllowOverRide None
   Allow from all
   Satisfy Any


   Order allow,deny
   Allow from all
   Satisfy Any


   Order allow,deny
   Allow from all
   Satisfy Any


Logging options in RT_SiteConfig.d
## Logging Options
# From lowest to highest priority, the levels are:
#  debug info notice warning error critical alert emergency
Set($LogToSyslog, 'info');
Set($LogToScreen, 'warning');
# log to /var/log/rt3.log
Set($LogToFile, 'debug');
Set($LogDir, '/var/log');
Set($LogToFileNamed , "rt3.log");


On Fri, Feb 24, 2012 at 10:24:52PM +, Jourdan Perla wrote:
> Fixed it. I was missing an Auth exclusion for the /REST/1.0/NoAuth 
> directory
> 
> As for the RT logs, can't find them. And can't find out where they're 
> configured.

Search in RT_Config.pm for the various Log config options and check their 
documentation.  Then see what you have in your RT_SiteConfig.pm

-kevin

> 
> On 2/24/12 2:15 PM, "Kevin Falcone"  wrote:
> 
> >On Fri, Feb 24, 2012 at 08:54:00PM +, Jourdan Perla wrote:
> >>Install of RT3.8 on Ubuntu 10.4 LTS.
> >>I'm getting that pesky "302 Found" error as I'm trying to push 
> >>mail into my queues using
> >>rt-mailqueue.
> >>I've done the usual Googling and wiki hunts, and I've run out of 
> >>options.
> >>- Aliases are working fine, it's a rt-mailgate error.
> >>- Plack is up to date (0.9985).
> >>- There's no extra '/'. It's finding rt-mailgate fine.
> >>- Not configured for SSL. That's on my to-do list, and if I need 
> >>to bump that up, I will.
> >>Command : /usr/bin/rt-mailgate --queue myqueue --action 
> >>correspond --url
> >>http://myserver.com/rt -debug < test.msg
> >>Output:
> >>/usr/bin/rt-mailgate: temp file is '/tmp/TykSIIvN17'
> >>/usr/bin/rt-mailgate: connecting to 
> >>http://myserver.com/rt/REST/1.0/NoAuth/mail-gateway
> >>An Error Occurred
> >>=
> >>302 Found
> >>/usr/bin/rt-mailgate: undefined server error
> >>Thoughts?
> >
> >What's in the RT logs.
> >
> >What's your test.msg.
> >
> >Also, Plack is only used in RT4
> >
> >-kevin
> >
> >RT Training Sessions 
> >(http://bestpractical.com/services/training.html)
> >* Boston — March 5 & 6, 2012
>

Re: [rt-users] Invalid username

2012-03-14 Thread Kevin Falcone 
On Wed, Mar 14, 2012 at 10:40:52AM +, Mario Giammarco wrote:
> Kevin Falcone  bestpractical.com> writes:
> > Where do you try to add them, in what text box.
> > Also, it isn't clear what you mean by adding them to a custom field.
> 
> Many places, example:
> 
> tools->configuration->queue->select->"general">user rights->
> now on the left you can input an user name. Then I click on checkbox 
> "view custom fields value" and immediately "invalid user" appears.

You shouldn't be granting user rights, put the user in a group and
grant group rights.

I believe the autocompleter for user rights may restrict to Privileged
users which may be the problem you're having.  Go search for the user
you're trying to use and ensure that they are Privileged.

If you want to give Unprivileged users the ability to see/edit CFs,
you can grant to Unprivileged directly, or to Requestors of tickets.

-kevin


pgpCkJ19i6X9N.pgp
Description: PGP signature

Re: [rt-users] rt-mailgate 302 Error. No, not Plack.

2012-03-14 Thread Kevin Falcone 
On Wed, Mar 14, 2012 at 09:43:47PM +, Jourdan Perla wrote:
> 
> An Error Occurred
> =
> 
> 302 Found
> 
> /usr/bin/rt-mailgate: undefined server error

This is Apache issuing a 302 before it gets to RT

> Grep all my logs for what happens at the same time and
> apache2/access.log:
> rt.myserver.com - - [14/Mar/2012:14:05:33 -0700] "POST 
> /rt/REST/1.0/NoAuth/mail-gateway HTTP/1.1" 302 715 "-" "libwww-perl/6.04"
> 
> I've got the following in my httpd.conf
> 
> 
>AllowOverRide None
>Satisfy Any
> 
> 
>AllowOverRide None
>Allow from all
>Satisfy Any
> 
> 
>Order allow,deny
>Allow from all
>Satisfy Any
> 
> 
>Order allow,deny
>Allow from all
>Satisfy Any
> 

What else do you have in apache.  Are you redirecting from http to
https?  Since you're using the debian packages, what else is going on
there.  Also, this is where I feel compelled to ask why you're using
3.8 rather than 4.0 for a new install.

-kevin


pgp3svR3MHFCf.pgp
Description: PGP signature

[rt-users] Open ticket VIA URL (Create.html) without authentication

2012-03-14 Thread Seann 

All,

I am running the latest version of RT.

I am researching a method that I can use to open a ticket from a web 
page not hosted on the RT system I have set up. I would rather not use 
email unless I absolutely have to.


The interface I am working on is an Ajax enabled content filter block 
page. It has an option to request that a site be unblocked in line to 
the page. I want that unblock request to drop into a ticket without the 
user interacting with the RT system.


I am using jquery as the core of my JavaScript, which intercepts the 
submit button click, and posts the data to RT. Everything works 
perfectly, except RT issuing a 302 back to my script, which is due to 
authentication (this was validated through a packet capture).


I have two options, to push this create ticket request without 
authentication or to figure out how RT expects authentication in 
relation to ticket creation requests.



Regards,
Seann