Here’s the tail end of strace httpd -X
Doesn’t say much, but it obviously segfaults.

The httpd server runs perfectly without the virtual host block in the
config file.

Don.

you may want to try rebuilding mod_perl or reinstalling DBI. it looks
like there may be issues with your DBI module not playing well with mod_perl.On Wed, Mar 14, 2001 at 12:06:15PM -0800, Don Lafontaine wrote:

Here’s the tail end of strace httpd -X
Doesn’t say much, but it obviously segfaults.

The httpd server runs perfectly without the virtual host block in the
config file.

Don.

Date: Wed, 14 Mar 2001 12:26:09 -0500 (EST)
From: root root@grizzly.cn.ca
To: lafont02@cn.ca
Subject: stack trace of httpd -X

read(6, “orter ();\n\nBEGIN {\n@ISA = qw(Exp”…, 4096) = 4096
rt_sigprocmask(SIG_BLOCK, NULL, , 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, , 8) = 0
brk(0x8b7c000) = 0x8b7c000
rt_sigprocmask(SIG_BLOCK, NULL, , 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, , 8) = 0
brk(0x8b7d000) = 0x8b7d000
stat(“/usr/lib/perl5/5.00503/i386-linux/auto/DBI”, 0xbfffad6c) = -1 ENOENT
(No such file or directory)
stat(“/usr/lib/perl5/5.00503/auto/DBI”, 0xbfffad6c) = -1 ENOENT (No such
file or directory)
stat(“/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI”,
{st_mode=S_IFDIR|0755, st_size=4096, …}) = 0
stat(“/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI/DBI.so”,
{st_mode=S_IFREG|0555, st_size=60674, …}) = 0
stat(“/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI/DBI.bs”,
{st_mode=S_IFREG|0444, st_size=0, …}) = 0
— SIGSEGV (Segmentation fault) —
+++ killed by SIGSEGV +++

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

that’s security the same way that asking for directions to topeka and
being told that a seal is a mammal is informative
-robin@apocalypse.org

anyone any kind of suggestions ?

thanks in advance,
geri

-------- Ursprüngliche Nachricht --------Betreff: 2-1-79 questions
Von: “Gerald Fehringer” gerald.fehringer@openadvice.de
Datum: Wed, 5.03.2003, 20:38
An: rt-devel@lists.fsck.com

hi guys,

how can i add a unprivileged user to a group ?
(it doesn’t appear in the user list, only if the user has more rights)

because i wanna have this basic view for all our
customers, so they can see only their queue and nothing else.

at the moment i can only define global rights for every queue, so
all unprivileged user can see the whole queues.

when will be the final rt3 released ?

thanks,
geri

anyone any kind of suggestions ?

reposting won’t make people answer faster, it only annoys people.

how can i add a unprivileged user to a group ?
(it doesn’t appear in the user list, only if the user has more rights)

by definition, you can only add privledged users to
groups. “privledged” means “can be granted rights” it alone doesn’t
confer rights. (though you might have other rights assigned to the
group of all provledged users)

seph

Hello,

Sorry for the off-topic.

I’ve got following problem: when receiving email with accented
characters in the Subject, they’re displayed ok in emails and
web interface but in the body of the ticket, every accented
character is displayed as garbage, even those created in the
web interface.

I’ve the following config. in RT_SiteConfig.pm:

Set($EmailOutputEncoding , ‘iso-8859-1’);

(Already tried the same with ‘ISO-8859-1’ and ‘utf-8’ parameters).

Any suggestions where to look for the fix? Maybe a perl module
need recompiling?

[Fri Dec 5 09:01:46 2003] [error] [client 200.17.63.71] FastCGI: server
"/usr/local/rt3/bin/mason_handler.fcgi" stderr: Malformed UTF-8
character (unexpected non-continuation byte 0x73, immediately after
start byte 0xf3) in substitution iterator at
/usr/local/lib/perl5/site_perl/5.8.1/Devel/StackTrace.pm line 290.

[Fri Dec 5 09:03:47 2003] [error] [client 200.17.63.51] FastCGI: server
"/usr/local/rt3/bin/mason_handler.fcgi" stderr: Use of uninitialized
value in concatenation (.) or string at
/usr/local/rt3/lib/RT/Tickets_Overlay_SQL.pm line 336.

Environment: FreeBSD 4.9-stable:

apache+mod_ssl-1.3.29+2.8.16
expat-1.95.6_1
mod_perl-1.28
mysql-client-4.0.16
openssl-0.9.7c
p5-Apache-DBI-0.92
p5-Apache-Session-1.54_2
p5-Authen-SASL-2.06
p5-CGI.pm-3.00,1
p5-Cache-Cache-1.02
p5-Carp-Assert-0.17
p5-Class-Container-0.10
p5-Class-Data-Inheritable-0.02
p5-Class-Fields-0.201
p5-Class-ReturnValue-0.51
p5-DBD-mysql-2.9003
p5-DBI-1.38
p5-DBIx-SearchBuilder-0.94
p5-Devel-StackTrace-1.04
p5-Digest-MD5-2.30
p5-Digest-SHA1-2.06
p5-Error-0.15
p5-Exception-Class-1.16
p5-File-Temp-0.12_1
p5-Font-AFM-1.18
p5-FreezeThaw-0.43
p5-Getopt-Long-2.32
p5-HTML-Format-2.03
p5-HTML-Mason-1.23
p5-HTML-Parser-3.34
p5-HTML-Tagset-3.03
p5-HTML-Tree-3.17
p5-I18N-LangTags-0.29
p5-IO-Socket-SSL-0.92
p5-IO-stringy-2.108
p5-IPC-ShareLite-0.09
p5-Locale-Maketext-1.06
p5-Locale-Maketext-Fuzzy-0.02
p5-Locale-Maketext-Lexicon-0.32
p5-Log-Dispatch-2.03
p5-MIME-Base64-2.21
p5-MIME-Tools-5.411a_3,1
p5-MLDBM-2.01
p5-Mail-Tools-1.60
p5-Net-1.17,1
p5-Net-SSLeay-1.23
p5-Params-Validate-0.69
p5-PodParser-1.24
p5-Regexp-Common-2.113
p5-Storable-2.08
p5-Term-ReadKey-2.21
p5-Test-Harness-2.30
p5-Test-Inline-0.15
p5-Test-Simple-0.47_1
p5-Text-Autoformat-1.12
p5-Text-Quoted-1.3
p5-Text-Reform-1.11
p5-Text-Template-1.44
p5-Text-Wrapper-1.000
p5-Time-HiRes-1.51,1
p5-Time-modules-2003.0211
p5-URI-1.27
p5-WWW-Mechanize-0.61
p5-base-2.01
p5-libapreq-1.3
p5-libwww-5.75

TIA,
Alex

-------- Исходное сообщение --------
Тема: Custom field
Дата: Fri, 10 Dec 2004 14:02:15 +0200
От: Andrew Kornilov andy@eva.dp.ua
Кому: rt-users@lists.fsck.com

I’ve add new Custom field (Select multiple values), link it with Queue
and try to add new ticket.
When i select one of customfield values and try to save ticket i get error:

Can’t locate object method “Id” via package “No object mapping for
field” (perhaps you forgot to load “No object mapping for field”?) at
/usr/lib/rt/RT/Record.pm line 1464.

1460: my $method = “${class}Obj”;
1461: $self = $self->$method;
1462: }
1463:
1464: return $self->Id;
1465: }
1466:
1467: sub LookupTypes { ref($[0]) }
1468:

Where is my mistake?

P.S. RT 3.3.14.

This is bug in DBIx::SB
Patch with tests is attached.

			Best regards. Ruslan.

Andrew Kornilov wrote:

object_mapping.patch (3.26 KB)

Oops, looks like your problem and patch are unrelaited to each other.
Sorry.

Ruslan U. Zakirov wrote:

Rangarajan Radhakrishnan wrote:

I have some custom field that I am trying to query as follows:
rt list "Queue = ‘TestQueue’ and owner = ‘nobody’ AND (‘CF.{My
Field1}’ = ‘My Value1’)
(This works).

However, when I add another condition:
rt list "Queue = ‘TestQueue’ and owner = ‘nobody’ AND (‘CF.{My
Field1}’ = ‘My Value1’ OR ‘CF.{My Field1}’ = ‘My Value2’)

It never returns any row. This has been tried from the graphical
interface too.

Details:
Using RT 3.6.0pre0. Using 1.43 for DBIx::SearchBuilder. Have tried it
with 1.39 of SearchBuilder.pm too.
Database is Oracle 10g (10.1)

Actual query used with “rt list” command is given below:

Queue = ‘Assay Development’ AND (‘CF.{Assay Stage}’ = ‘Assay
Request’ OR ‘CF.{Assay Stage}’ = ‘Feasibility’ OR ‘CF.{Assay Stage}’ =
‘Assay Development’ OR ‘CF.{Assay Stage}’ = ‘Assay Validation’ OR
‘CF.{Assay Stage}’ = ‘Sample Analysis’ OR ‘CF.{Assay Stage}’ = ‘Data
Loading’ )

It seems to breaks down even if I just use two clauses involving same
customfield within parenthesis.

This results in QueryString (Select) as printed from within
DBIx::SearchBuilder is:

SELECT * FROM ( SELECT limitquery.,rownum limitrownum FROM ( SELECT
main.
FROM ( SELECT DISTINCT main.id FROM (((Tickets main LEFT JOIN
ObjectCustomFields ObjectCustomFields_1 ON
((ObjectCustomFields_1.ObjectId = ‘0’)) OR (
ObjectCustomFields_1.ObjectId = main.Queue)) LEFT JOIN CustomFields
CustomFields_2 ON ( CustomFields_2.id =
ObjectCustomFields_1.CustomField)) LEFT JOIN ObjectCustomFieldValues
ObjectCustomFieldValues_3 ON ((ObjectCustomFieldValues_3.ObjectId =
main.id)) AND ( ObjectCustomFieldValues_3.CustomField =
CustomFields_2.id) AND ( (ObjectCustomFieldValues_3.Disabled = ‘0’))
AND ( (ObjectCustomFieldValues_3.ObjectType = ‘RT::Ticket’))) WHERE
((CustomFields_2.name = ‘Assay Stage’)) AND ((main.EffectiveId =
main.id)) AND ((main.Status != ‘deleted’)) AND ((main.Type =
‘ticket’)) AND ((main.name = ‘Assay Stage’)AND(main.name = ‘Assay
Stage’)AND(main.name = ‘Assay Stage’)AND(main.name = ‘Assay
Stage’)AND(main.name = ‘Assay Stage’)) AND ((main.Queue = ‘3’)AND ( (
(ObjectCustomFieldValues_3.Content = ‘Assay Request’) ) OR (
(ObjectCustomFieldValues_3.Content = ‘Feasibility’) ) OR (
(ObjectCustomFieldValues_3.Content = ‘Assay Development’) ) OR (
(ObjectCustomFieldValues_3.Content = ‘Assay Validation’) ) OR (
(ObjectCustomFieldValues_3.Content = ‘Sample Analysis’) ) OR (
(ObjectCustomFieldValues_3.Content = ‘Data Loading’) ) ) ) )
distinctquery, Tickets main WHERE (main.id = distinctquery.id) ORDER
BY main.id ASC ) limitquery WHERE rownum <= 50 ) WHERE limitrownum >= 1

On running this query using SQLPLUS
ERROR at line 1:
ORA-00904: “MAIN”.“NAME”: invalid identifier

Has anybody seen this before? Thanks in advance for your help.

It appears that the generated query has
“(main.name = ‘Assay Stage’)AND(main.name = ‘Assay Stage’)AND(main.name
= ‘Assay Stage’)AND(main.name = ‘Assay Stage’)AND(main.name = ‘Assay
Stage’)”
repeating multiple times.

each “main.name” should instead be “CustomFields_2.name”

Is anybody else facing this problem …? Thanks.

Command line query involving Custom Fields (3.29 KB)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

I’m having some trouble installing rt-remind on the RT machine as cronjob.

The program is running fine if I execute it from my shell, however if I
put it as a cronjob it doesn’t run.

I’ve checked the cron logs, and added some debug statement in the
program, so I am sure cron did run the job.

However, it seems the RT library couldn’t access the queue to access
information.

Does anyone have any ideas? or if there are some permission I need to
set to make sure cronjob can be run?

Regards,

Tommy

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFE9TPbGrFcL8PXPP4RAhM4AKC1r2kd/vrmGLXCyvjiEsMR8EONEgCeIUxV
sCWNW73bysRivpd1ZAns4kM=
=+7JX
-----END PGP SIGNATURE-----

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Jesse! Thanks for your response.

When we will have available the RT version 3.8, therefore taste very to
use the RT for my necessary CSIRT and very to use PGP keys and currently
I am using version 3.4.6. Use the same RT without the RTIR.

Exists some work-around for use of keys with this version that I have?

Best Regards,

Suender Oliveira

-----BEGIN PGP SIGNATURE-----

iD8DBQFGGjWzXVXX0tl3w6YRAlVQAJ49UC7CnENzkgB6AcOV0Dmk3VSSSQCfXxHF
cm/sCEXa07c7cYJA6FPerlE=
=10Y1
-----END PGP SIGNATURE-----

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Jesse! Thanks for your response.

When we will have available the RT version 3.8, therefore taste
very to
use the RT for my necessary CSIRT and very to use PGP keys and
currently
I am using version 3.4.6. Use the same RT without the RTIR.

Exists some work-around for use of keys with this version that I have?

It’d need to be custom development. If you need that, I’d be happy to
chat off list.

Best,
Jesse

PGP.sig (186 Bytes)

Hi,

Could u please respond on this issue…

Thanks
Annadurai

Hi,

Could u please help me on the following problem.

my fetchmail keep on retrieves all the mails from the server and creates
requests on RT again and again… it’s not deleting the retrieved mails…
after querying the mail server, my error log says:

reading message 1 of 3 (1131 octets) Insecure $ENV{BASH_ENV} while
running with -T switch at /opt/rt/lib/rt/support/mail.pm line 103.
fetchmail: MDA exited abnormally or returned nonzero status
fetchmail: not flushed

my .fetchmailrc contains:

poll mail.domain_name proto pop3:
username rt password ***** mda "/opt/rt/bin/rt-mailgate rt correspond

trailing quote in your .fetchmailrc
otherwise try forcing fetchmail to delete the mail from the server
after reading it using the --nokeep flag.

–clark

We’re about to deploy RT 1.0.5 for a customer support solution in our
organization. Sometimes we’ll get in requests via voicemail or fax. I’ve
been able to have a new ticket generated, with the body of the original
message including a URL to the message to be listened to or viewed.

The URL shows up as just plain text, and we have to copy and paste it into
another browser window to get to the file. Is there any way I can have the
URL display at a link when viewing the ticket?

Greg Trotter
greg@ussnomad.org

| The URL shows up as just plain text, and we have to copy and paste it
| into another browser window to get to the file. Is there any way I can
| have the URL display at a link when viewing the ticket?
±–>8

In lib/rt/ui/web/support.pm, replace the print_html sub with:

sub print_html{
my ($value) = shift;
my %map = (‘<’ => ‘<’, ‘>’ => ‘>’, ‘&’ => ‘&’);
$value =~ s/([<>&])/$map{$1}/ge;
$value =~ s!(?:^|\b)
((?:https?|ftp|mailto)://[^\s"'/]+/[^\s():"']+)
!<A HREF="$1">$1!gx;
print $value;
}

(I hope RT 1.0.x has that; my source has diverged so far from Jesse’s that
it’s not funny.)

brandon s. allbery [os/2][linux][solaris][japh] allbery@kf8nh.apk.net
system administrator [WAY too many hats] allbery@ece.cmu.edu
electrical and computer engineering KF8NH
carnegie mellon university [“better check the oblivious first” -ke6sls]

You should remove the keep command from the .fetchmailrc. It causes
fetchail to leave the mails in the server, so you get the same mails
again next time. Or read the fetchail documents, maybe you need to add a
nokeep keyword if you have set a default of keep somewhere.

If you have the fetchmailconfig -program, use that to create the
.fetchmailrc for the user that does the fetchmail command.

anna@kesmai.com wrote:


Part 1.2Type: Microsoft MHTML Document 5.0 (message/rfc822)

Tapio Lehtonen tel: +358 9 4131 2206

Tellabs Oy fax: +358 9 4131 2030

Sinim�entie 6 email: Tapio.Lehtonen@Tellabs.COM

FIN-02630 ESPOO URL http://www.Tellabs.com/

Finland Senior Design Engineer

tapio.lehtonen.vcf (348 Bytes)

I’m letting all ticket requestors access the Web UI to submit trouble tickets. How can I modify Group Rights to let ticket Requestors respond to replies through the Web UI?

Currently I have assigned Requestors these rights:
ShowTicket
ReplyToTicket
ModifyTicket

Thanks,

Tom

p.s.: Running RT v2.0.0

Hi Jesse,

I’m running on a brand new install of RT2.0.1 now. It has only the initial
users setup (root, RT_System, etc. ). When I try to send email into the
system as a new user (not in the user list of RT2) it complains that I don’t
have permission to create tickets in the “general” queue. I have both
CreateTicket and SeeQueue set for Everyone in the “general” queue. The
response is attached to this email. What am I missing? The system used to
auto-create a new user by the email address and create the ticket when
I used the 1.3.x versions. I’m obviously missing something here.

Thanks.
-Robert

have you set up permissions per the config recommended in the install guide
at www.helgrim.com/rtdocs/On Fri, Jul 20, 2001 at 12:07:53PM -0700, Robert Shaw wrote:

Hi Jesse,

I’m running on a brand new install of RT2.0.1 now. It has only the initial
users setup (root, RT_System, etc. ). When I try to send email into the
system as a new user (not in the user list of RT2) it complains that I don’t
have permission to create tickets in the “general” queue. I have both
CreateTicket and SeeQueue set for Everyone in the “general” queue. The
response is attached to this email. What am I missing? The system used to
auto-create a new user by the email address and create the ticket when
I used the 1.3.x versions. I’m obviously missing something here.

Thanks.
-Robert

Subject: Ticket creation failed
From: rt@mxim.com
X-Mailer: Perl5 Mail::Internet v1.33
To: rshaw@mxim.com
Date: Fri, 20 Jul 2001 11:56:31 -0700 (PDT)

No permission to create tickets in the queue ‘general’.

yat1156


Robert Shaw Email: rshaw@mxim.com
Maxim Integrated Products Office: (503)547-2360
High Frequency CAD Engineering Fax: (503)547-0810

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

Any e-mail sent to the SLA will immediately become the intellectual property
of the SLA and the author of said message will enter into a period of
indentured servitude which will last for a period of time no less than seven
years.