Problems after a RT1->RT2 install

RT Users
1

So I finally went thru and updated our RT1 install to RT2 (pgsql), and
while the conversion seems to have went well, I can’t seem to add a
new ticket to the converted database either via web or email. What’s more
unnerving is that I have a wholly seperate RT2 install on this same server,
that’s has had no problems whatsoever. It’s 3am and I am at my wits end at
this point…

Here is the output from rt-mailgate:

Apr 1 10:31:51 stick postfix/local[4840]: 437105FA2A:
to=ops@isc.org, relay=local, delay=4, status=bounced
(Command died with status 255: “/u2/rt2/bin/rt-mailgate --queue ops
–action correspond”. Command output: RT::Ticket=HASH(0x8802318) ->Create
couldn’t set EffectiveId: No value sent to _Set! The ‘message’ parameter
to Log::Dispatch::Output::log was an ‘undef’, which is not one of the
allowed types: scalar Params::Validate::ANON(‘The 'message'
parameter to Log::Dispatch::Output::log was an .…’) called at
/usr/local/lib/perl5/site_perl/5.6.1/Params/Validate.pm line 379
Params::Validate::_validate_one_param(undef, ‘HASH(0x881c944)’, ‘The
'message'
parameter’) called at /usr/local/lib/perl5/site_perl/5.6.1/Params/Validate.pm
line 289 Params::Validate::validate(‘ARRAY(0x850843c)’, ‘HASH(0x881cbd8)’)
called at /usr/local/lib/perl5/site_perl/5.6.1/Log/Dispatch/Output.pm line
32 Log::Dispatch::Output::log(undef, ‘level’, ‘crit’, ‘message’, undef,
‘name’, ‘screen’) called at /usr/

And from /tmp/rt.log65534

[Tue Apr 1 10:31:48 2003] [err]: RT::Ticket=HASH(0x8820180) ->Create
couldn’t set EffectiveId: No value sent to _Set!
[Tue Apr 1 10:31:48 2003] [err]: RT::Ticket=HASH(0x881e204) ->Create
couldn’t set EffectiveId: No value sent to _Set!
[Tue Apr 1 10:31:49 2003] [crit]: Permission Denied
[Tue Apr 1 10:31:49 2003] [crit]: Permission Denied
[Tue Apr 1 10:31:51 2003] [err]: RT::Ticket=HASH(0x8802318) ->Create
couldn’t set EffectiveId: No value sent to _Set!
[Tue Apr 1 10:31:51 2003] [err]: RT::Ticket=HASH(0x880527c) ->Create
couldn’t set EffectiveId: No value sent to _Set!
[Tue Apr 1 10:31:51 2003] [crit]: Permission Denied
[Tue Apr 1 10:31:51 2003] [crit]: Permission Denied
[Tue Apr 1 10:31:53 2003] [crit]: Permission Denied

Any ideas on what this might be?; I followed the conversion instructions to
the letter (perhaps I need to run the ‘SELECT setval(‘tickets_id_seq’,
(select max(id) from tickets));’ command in psql again after running the
conversion script?), and I wish I knew what was throwing up those
“Permission Denied” errors.

Thanks in advance - Peter
Peter_Losher@isc.org | ISC | OpenPGP 0xE8048D08 | “The bits must flow”

2

In reference to my earlier problem w/ my converted RT1->RT2 db, here is
what Apache’s error log says. (note that it’s still looking for the RT1
webrt.cgi?)

RT::Ticket=HASH(0x8f4ba1c) ->Create couldn’t set EffectiveId: No value sent
to _Set!

WebRT: ()[Tue Apr 1 14:34:41 2003] [error] [Mason] File does not exist:
/u2/rt2/WebRT/html/rt/webrt.cgi
RT::Ticket=HASH(0x9099784) ->Create couldn’t set EffectiveId: No value sent
to _Set!

WebRT: ()

Any pointers on a fix or how to debug this further?

Thanks! - Peter
Peter_Losher@isc.org | ISC | OpenPGP 0xE8048D08 | “The bits must flow”

3

Any ideas on what this might be?; I followed the conversion instructions to
the letter (perhaps I need to run the ‘SELECT setval(‘tickets_id_seq’,
(select max(id) from tickets));’ command in psql again after running the
conversion script?)

That’s what did it… I followed the instructions too closely and ran that
sql statement before running the conversion script which is useless because
it updates null. :slight_smile: Perhaps that instruction should be moved one line
down after the conversion script. :slight_smile:

-Peter
Peter_Losher@isc.org | ISC | OpenPGP 0xE8048D08 | “The bits must flow”