Installation problems

Hi,

As much as I would like to install and use this package it failed to do me
any good no matter what I try. I followed the instructions to install all
the necessary perl modules which work as expected.

Checking for DBI…found
Checking for Digest::MD5…found
Checking for CGI 2.71 …found
Checking for CGI::Cookie 1.16 …found

Tried rt-1.0.6 and rt-1.0.7, to no avail.

I have a user

rt:x:402:402:Request Tracker:/export/home/rt:/bin/bash

ls /opt/rt
bin etc lib transactions

ls /opt/rt/bin/
admin-webrt.cgi rt rtadmin rtmux.pl.orig suid_wrapper
cgi rt-mailgate rtmux.pl rtq webrt.cgi

ls /export/home/httpd/cgi-bin/rt/
admin-webrt.cgi auth.pm manipulate.pm webrt.cgi
admin.pm forms.pm support.pm

RT_BIN_PATH = $(RT_PATH)/bin
RT_LIB_PATH = $(RT_PATH)/lib
RT_ETC_PATH = $(RT_PATH)/etc
RT_BIN_PATH = $(RT_PATH)/bin
RT_CGI_PATH = /export/home/httpd/cgi-bin/rt

Apache log:

[Fri Feb 9 18:33:55 2001] [error] [client 192.168.10.37] Premature end of
script headers: /export/home/httpd/cgi-bin/rt/admin-webrt.cgi
Mysql->connect(database=rt;host=helpdesk) failed: Access denied for user:
‘rt@helpdesk.networks.com’ (Using password: YES) at /opt/rt/lib/rt/database.pm line 24
[connectdb] Database connect failed: Access denied for user: ‘rt@helpdesk.networks.com’ (Using password: YES)
[Fri Feb 9 18:33:58 2001] [error] [client 192.168.13.7] Premature end of
script headers: /export/home/httpd/cgi-bin/rt/admin-webrt.cgi

What a heck I’m doing wrong here?

Thanks,

Rafael Skodlar

Sounds like you’ve got some sort of mysql permissions problem.
Sometimes this happens if you try to use odd metacharacters in your
mysql password, like ! " \ etc…

are you getting any mysql errors during install?On Thu, Mar 01, 2001 at 12:35:28AM -0800, Rafael wrote:

Hi,

As much as I would like to install and use this package it failed to do me
any good no matter what I try. I followed the instructions to install all
the necessary perl modules which work as expected.

Checking for DBI…found
Checking for Digest::MD5…found
Checking for CGI 2.71 …found
Checking for CGI::Cookie 1.16 …found

Tried rt-1.0.6 and rt-1.0.7, to no avail.

I have a user

rt:x:402:402:Request Tracker:/export/home/rt:/bin/bash

ls /opt/rt
bin etc lib transactions

ls /opt/rt/bin/
admin-webrt.cgi rt rtadmin rtmux.pl.orig suid_wrapper
cgi rt-mailgate rtmux.pl rtq webrt.cgi

ls /export/home/httpd/cgi-bin/rt/
admin-webrt.cgi auth.pm manipulate.pm webrt.cgi
admin.pm forms.pm support.pm

RT_BIN_PATH = $(RT_PATH)/bin
RT_LIB_PATH = $(RT_PATH)/lib
RT_ETC_PATH = $(RT_PATH)/etc
RT_BIN_PATH = $(RT_PATH)/bin
RT_CGI_PATH = /export/home/httpd/cgi-bin/rt

Apache log:

[Fri Feb 9 18:33:55 2001] [error] [client 192.168.10.37] Premature end of
script headers: /export/home/httpd/cgi-bin/rt/admin-webrt.cgi
Mysql->connect(database=rt;host=helpdesk) failed: Access denied for user:
‘rt@helpdesk.networks.com’ (Using password: YES) at /opt/rt/lib/rt/database.pm line 24
[connectdb] Database connect failed: Access denied for user: ‘rt@helpdesk.networks.com’ (Using password: YES)
[Fri Feb 9 18:33:58 2001] [error] [client 192.168.13.7] Premature end of
script headers: /export/home/httpd/cgi-bin/rt/admin-webrt.cgi

What a heck I’m doing wrong here?

Thanks,

Rafael Skodlar


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

jesse reed vincent – root@eruditorum.orgjesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

T’waS br|ll1G 4|||> 7#e sl1T#Y T0v3s D1|> gYR3 4nd Gimb@1 1|| 7#E //A83
all |/|1|/|53Y W3R3 d4 60r0GR0V3s @|||> |>4 M0MES wr47H oUTGR4b3.

Sounds like you’ve got some sort of mysql permissions problem.
Sometimes this happens if you try to use odd metacharacters in your
mysql password, like ! " \ etc…

I think I used only alphanumeric characters and did edit passwd before
make install.

are you getting any mysql errors during install?

No, there were no errors that I can recall. The install script created rt
table the first time. I don’t have time to deal with this right now, the
firewall and a few other issues are more critical but I’ll revisit RT
hopefuly next week.

As other email suggested I most likely have problem with permissions in
mysql. However, I was able to see the rt table with webmin. I could also
edit it if I new what I was doing :slight_smile:

I will revisit this in a few days and probably need to pick a book or
something to learn about mysql. The GUI that is available is not very
clear if you are not familiar with mysql.

Thanks guys,

Hi,

As much as I would like to install and use this package it failed to do me
any good no matter what I try. I followed the instructions to install all
the necessary perl modules which work as expected.

Checking for DBI…found
Checking for Digest::MD5…found
Checking for CGI 2.71 …found
Checking for CGI::Cookie 1.16 …found

Tried rt-1.0.6 and rt-1.0.7, to no avail.

I have a user

rt:x:402:402:Request Tracker:/export/home/rt:/bin/bash

ls /opt/rt
bin etc lib transactions

ls /opt/rt/bin/
admin-webrt.cgi rt rtadmin rtmux.pl.orig suid_wrapper
cgi rt-mailgate rtmux.pl rtq webrt.cgi

ls /export/home/httpd/cgi-bin/rt/
admin-webrt.cgi auth.pm manipulate.pm webrt.cgi
admin.pm forms.pm support.pm

RT_BIN_PATH = $(RT_PATH)/bin
RT_LIB_PATH = $(RT_PATH)/lib
RT_ETC_PATH = $(RT_PATH)/etc
RT_BIN_PATH = $(RT_PATH)/bin
RT_CGI_PATH = /export/home/httpd/cgi-bin/rt

Apache log:

[Fri Feb 9 18:33:55 2001] [error] [client 192.168.10.37] Premature end of
script headers: /export/home/httpd/cgi-bin/rt/admin-webrt.cgi
Mysql->connect(database=rt;host=helpdesk) failed: Access denied for user:
‘rt@helpdesk.networks.com’ (Using password: YES) at /opt/rt/lib/rt/database.pm line 24
[connectdb] Database connect failed: Access denied for user: ‘rt@helpdesk.networks.com’ (Using password: YES)
[Fri Feb 9 18:33:58 2001] [error] [client 192.168.13.7] Premature end of
script headers: /export/home/httpd/cgi-bin/rt/admin-webrt.cgi

What a heck I’m doing wrong here?

Thanks,

Rafael Skodlar


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users


jesse reed vincent – root@eruditorum.orgjesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

T’waS br|ll1G 4|||> 7#e sl1T#Y T0v3s D1|> gYR3 4nd Gimb@1 1|| 7#E //A83
all |/|1|/|53Y W3R3 d4 60r0GR0V3s @|||> |>4 M0MES wr47H oUTGR4b3.

Rafael

I’m having an issue at the tail end of the RT2 installation, everything installed fine, however when I try to bring up the Admin web interface or login using an account I created at command line, I end up with a 500 server error…

The Apache logs show the following:

[Fri Jun 29 19:25:31 2001] [error] Function CGI::Object::unescape does not exist at /usr/local/lib/perl5/5.6.1/CGI.pm line 112
[Fri Jun 29 19:41:58 2001] [error] Can’t call method “unescape” on an undefined value at /usr/local/lib/perl5/5.6.1/CGI.pm line 112.
[Fri Jun 29 19:42:05 2001] [error] Can’t call method “unescape” on an undefined value at /usr/local/lib/perl5/5.6.1/CGI.pm line 112.
[Fri Jun 29 19:42:06 2001] [error] Function CGI::Object::unescape does not exist at /usr/local/lib/perl5/5.6.1/CGI.pm line 112
[Fri Jun 29 19:42:13 2001] [error] Function CGI::Object::unescape does not exist at /usr/local/lib/perl5/5.6.1/CGI.pm line 112

RT log in /tmp shows the following as well:

Attempt to free unreferenced scalar.
Attempt to free unreferenced scalar.
Attempt to free unreferenced scalar.
Attempt to free unreferenced scalar.
Attempt to free unreferenced scalar.
Attempt to free unreferenced scalar.
Attempt to free unreferenced scalar.
Attempt to free unreferenced scalar.
Attempt to free unreferenced scalar.
Attempt to free unreferenced scalar.
Attempt to free unreferenced scalar.

Any suggestions as to what I have missed?

Regards,

Derek Buttineau
Internet Systems Administrator
Compu-SOLVE Internet Services

hrm. What happens if you run
perl -MCPAN -e’install CGI’

    -jOn Fri, Jun 29, 2001 at 03:57:03PM -0400, Derek Buttineau wrote:

I’m having an issue at the tail end of the RT2 installation, everything installed fine, however when I try to bring up the Admin web interface or login using an account I created at command line, I end up with a 500 server error…

The Apache logs show the following:

[Fri Jun 29 19:25:31 2001] [error] Function CGI::Object::unescape does not exist at /usr/local/lib/perl5/5.6.1/CGI.pm line 112
[Fri Jun 29 19:41:58 2001] [error] Can’t call method “unescape” on an undefined value at /usr/local/lib/perl5/5.6.1/CGI.pm line 112.
[Fri Jun 29 19:42:05 2001] [error] Can’t call method “unescape” on an undefined value at /usr/local/lib/perl5/5.6.1/CGI.pm line 112.
[Fri Jun 29 19:42:06 2001] [error] Function CGI::Object::unescape does not exist at /usr/local/lib/perl5/5.6.1/CGI.pm line 112
[Fri Jun 29 19:42:13 2001] [error] Function CGI::Object::unescape does not exist at /usr/local/lib/perl5/5.6.1/CGI.pm line 112

RT log in /tmp shows the following as well:

Attempt to free unreferenced scalar.
Attempt to free unreferenced scalar.
Attempt to free unreferenced scalar.
Attempt to free unreferenced scalar.
Attempt to free unreferenced scalar.
Attempt to free unreferenced scalar.
Attempt to free unreferenced scalar.
Attempt to free unreferenced scalar.
Attempt to free unreferenced scalar.
Attempt to free unreferenced scalar.
Attempt to free unreferenced scalar.

Any suggestions as to what I have missed?

Regards,

Derek Buttineau
Internet Systems Administrator
Compu-SOLVE Internet Services

jesse reed vincent – root@eruditorum.orgjesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

This is scary. I’m imagining tracerouting you and seeing links like “Route
84” and “Route 9, Exit 14”. Obviously, this is illness induced.
–Cana McCoy

If I’m asking in the wrong place please let me know.

I’ve installed RT and so far everything looks good. I have not yet
setup my mail gateway because it requires some upstream mail server
changes that are not my department. I assumed, however, that outbound
mail from RT would work. I’ve created a test ticket in the system, and
tried to add a requestor/email address to the ticket and recieve the
following error. It’s possible this is a bug but with so many moving
pieces of RT I’m willing to bet I did something wrong.

Quantifier follows nothing in regex; marked by <-- HERE in m/* <–
HERE @rt.censored.com/ at
/www/php5/rt.censored.com/rt/bin/…/lib/RT/EmailParser.pm line 331.

Any help would be greatly appreciated.

-Nynex

Quantifier follows nothing in regex; marked by<-- HERE in m/*<–
HERE @rt.censored.com/ at
/www/php5/rt.censored.com/rt/bin/…/lib/RT/EmailParser.pm line 331.

Can we see your RT_SiteConfig.pm? Also, what version of RT? It looks
like you might have configured $RTAddressRegexp with an invalid regular
expression.

Thomas

This is for RT 3.8.8

I was actually pretty confused about what the RTAddressRegexp should
look like, and how it should be written (in quotes, in //'s, etc).

Set( $rtname, ‘rt.censored.com’);
Set($Timezone , ‘US/Pacific’);

Set($DatabaseHost , ‘services’);
Set($DatabaseRTHost , ‘localhost’);
Set($DatabaseUser , ‘rt’);
Set($DatabasePassword , ‘censored’);
Set($DatabaseName , ‘rt’);

Set($OwnerEmail , ‘censored’);

Set($CorrespondAddress , ‘rt@censored.com’);
Set($CommentAddress , ‘rt@censored.com’);

Set( $WebDomain, ‘rt.censored.com’ );
Set($RTAddressRegexp , ‘*@censored.com’);

This is my first stab at RT so I’m not sure if I’m missing any other
essential config values, but this is all I have in that file.On Fri, Aug 6, 2010 at 5:17 PM, Thomas Sibley trs@bestpractical.com wrote:

On 08/06/2010 05:03 PM, Victor Victrolla wrote:

Quantifier follows nothing in regex; marked by<-- HERE in m/*<–
HERE @rt.censored.com/ at
/www/php5/rt.censored.com/rt/bin/…/lib/RT/EmailParser.pm line 331.

Can we see your RT_SiteConfig.pm? Also, what version of RT? It looks like
you might have configured $RTAddressRegexp with an invalid regular
expression.

Thomas

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

-Nynex

I was actually pretty confused about what the RTAddressRegexp should
look like, and how it should be written (in quotes, in //'s, etc).

Set($RTAddressRegexp , ‘*@censored.com’);

Quotes are fine. The problem is indeed that *@censored.com isn’t a
valid regex. It’s also unlikely what you actually want.
$RTAddressRegexp should match only the addresses that RT uses, not any
of your users’ addresses. As perldoc etc/RT_Config.pm says:

“C<$RTAddressRegexp> is used to make sure RT doesn’t add itself as a
ticket CC if the setting above is enabled. It is important that you set
this to a regular expression that matches all addresses used by your RT.
This lets RT avoid sending mail to itself.”

Given these settings:

Set($CorrespondAddress , ‘rt@censored.com’);
Set($CommentAddress , ‘rt@censored.com’);

You likely want: Set($RTAddressRegexp, ‘^rt@censored.com$’);

If you’ve configured other queue addresses already, you should add them
as well, like so:

Set($RTAddressRegexp, ‘^(?:rt|other|athird)@censored.com$’);

Hope that helps,
Thomas