EffectiveId

I keep getting the following error, would someone please tell me what it
means.

Thanks,
Walter.

----- The following addresses had permanent fatal errors -----
|“/home/rt2/bin/rt-mailgate --queue helpdesk --action correspond”
(reason: 255)
(expanded from: rt@babylon)

----- Transcript of session follows -----
RT::Ticket=HASH(0x87fc6bc) ->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/lib/perl5/site_perl/5.6.1/Params/Validate.pm line
379
Params::Validate::_validate_one_param(undef, ‘HASH(0x87e1fd0)’,
‘The 'message' parameter’)
called at /usr/lib/perl5/site_perl/5.6.1/Params/Validate.pm line 289
Params::Validate::validate(‘ARRAY(0x84f8d3c)’, ‘HASH(0x87fca64)’)
called at
/usr/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/lib/perl5/site_perl/5.6.1/Log/Dispatch.pm line 97
Log::Dispatch::_log_to(‘Log::Dispatch=HASH(0x87dc9bc)’, ‘level’,
‘crit’, ‘message’, undef,
‘name’, ‘screen’) called at /usr/lib/perl5/site_perl/5.6.1/Log/Dispatch.pm
line 74
Log::Dispatch::log(‘Log::Dispatch=HASH(0x87dc9bc)’, ‘level’,
‘crit’, ‘message’, undef)
called at /home/rt2/lib/RT/Interface/Email.pm line 299
RT::Interface::email::MailError(‘To’,
‘root@babylon.ee.washington.edu’, ‘Subject’, ‘Ticket
creation failed’, ‘Explanation’, undef, ‘MIMEObj’,
‘MIME::Entity=HASH(0x87e148c)’) called at
/etc/smrsh/rt-mailgate line 249
554 5.3.0 unknown mailer error 255

Walter Marchuk Senior Computer Specialist
marchuk@ee.washington.edu University of Washington
http://darkstar.ee.washington.edu Electrical Engineering
PGP Key: http://darkstar.ee.washington.edu/pgp.txt
5DC5 2DF3 DC38 6DBD FCD2 4CFF 2A28 0679 5980 FB31 ICQ: 125310148

I keep getting the following error, would someone please tell me what it
means.

Thanks,
Walter.

----- The following addresses had permanent fatal errors -----
|“/home/rt2/bin/rt-mailgate --queue helpdesk --action correspond”
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

I would expect the pipe (|) to be inside the quotes. On Exim I can do without the
quotes. So what does

“|/home/rt2/bin/rt-mailgate --queue helpdesk --action correspond”

give you??

That’s my 1st suspicion. There could be more problems

    cheers
   - wash 

Odhiambo Washington, wash@wananchi.com . WANANCHI ONLINE LTD (Nairobi, KE)
http://ns2.wananchi.com/~wash/ . 1ere Etage, Loita Hse, Loita St.,
GSM: (254) 722 743 223 . # 10286, 00100 NAIROBI
“Oh My God! They killed init! You Bastards!”
–from a /. post

``That Ariel Sharon. Boy, he sure is controversial.
Most Western countries would have to have a military coup
before they enjoyed a leader of that caliber.‘’ (Sydney Webb)

I dont think it was the pipe(using sendmail) because that
setup worked with RT 2.0.2.

Walter.On Thu, 1 Aug 2002, Odhiambo Washington wrote:

I keep getting the following error, would someone please tell me what it
means.

Thanks,
Walter.

----- The following addresses had permanent fatal errors -----
|“/home/rt2/bin/rt-mailgate --queue helpdesk --action correspond”
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

I would expect the pipe (|) to be inside the quotes. On Exim I can do without the
quotes. So what does

“|/home/rt2/bin/rt-mailgate --queue helpdesk --action correspond”

give you??

That’s my 1st suspicion. There could be more problems

    cheers
   - wash 

----------------------------------±----------------------------------------
Odhiambo Washington, wash@wananchi.com . WANANCHI ONLINE LTD (Nairobi, KE)
http://ns2.wananchi.com/~wash/ . 1ere Etage, Loita Hse, Loita St.,
GSM: (254) 722 743 223 . # 10286, 00100 NAIROBI
----------------------------------±----------------------------------------
“Oh My God! They killed init! You Bastards!”
–from a /. post

++
``That Ariel Sharon. Boy, he sure is controversial.
Most Western countries would have to have a military coup
before they enjoyed a leader of that caliber.‘’ (Sydney Webb)

Walter Marchuk Senior Computer Specialist
marchuk@ee.washington.edu University of Washington
http://darkstar.ee.washington.edu Electrical Engineering
PGP Key: http://darkstar.ee.washington.edu/pgp.txt
5DC5 2DF3 DC38 6DBD FCD2 4CFF 2A28 0679 5980 FB31 ICQ: 125310148

What does this mean?
Create couldn’t set EffectiveId: No value sent to _Set!

Walter Marchuk Senior Computer Specialist
marchuk@ee.washington.edu University of Washington
http://darkstar.ee.washington.edu Electrical Engineering
PGP Key: http://darkstar.ee.washington.edu/pgp.txt
5DC5 2DF3 DC38 6DBD FCD2 4CFF 2A28 0679 5980 FB31 ICQ: 125310148

What does this mean?
Create couldn’t set EffectiveId: No value sent to _Set!

Firstly, I don’t believe that you have stated which version of RT you are
using, nor which version of (presumably) MySQL.

Secondly, the error text comes from RT::Ticket->Create(), which seems to
indicate that RT didn’t get an id value back from SQL (ie, its a SQL
problem, not immediately RT).

I’d look through the query log on your SQL server to see what the insert
command supplied was, and any other debug information supplied by your SQL
server concerning this.


Walter Marchuk Senior Computer Specialist

Might want to fix that line wrapping there.

Regards,

                         Bruce Campbell                            RIPE
               Systems/Network Engineer                             NCC
             www.ripe.net - PGP562C8B1B             Operations/Security

I am upgrading from RT 2.0.4 to RT 2.0.14. I too believe it is an SQL
issue, because if I install from scratch everything then works.
The problem is that I need to retain the old data otherwise there is
no upgrade.

RT works except for new ticket creation. Looking through mysql logs
here is what I see:
mysql> INSERT INTO Tickets (Creator, Due, Status, LastUpdatedBy, Resolved,
Type, TimeWorked, LastUpdated, Subject, FinalPriority, Queue, Created,
TimeLeft, InitialPriority, Owner, Priority, Starts) VALUES (‘5’,
‘1970-01-01 00:00:00’, ‘new’, ‘5’, NULL, ‘ticket’, ‘’, ‘2002-08-01
18:10:56’, ‘test’, ‘0’, ‘8’, ‘2002-08-01 18:10:56’, ‘’, ‘0’, ‘5’, ‘0’,
‘1970-01-01 00:00:00’);
ERROR 1062: Duplicate entry ‘4485’ for key 1

I only see one insert in the logs and then it quits…probably because of
the error?
I’ve ran insertdata 2.0.4 and it doesnt seem to do much.

Thank You,
Walter.On Thu, 1 Aug 2002, Bruce Campbell wrote:

On Thu, 1 Aug 2002, Walter Marchuk wrote:

What does this mean?
Create couldn’t set EffectiveId: No value sent to _Set!

Firstly, I don’t believe that you have stated which version of RT you are
using, nor which version of (presumably) MySQL.

Secondly, the error text comes from RT::Ticket->Create(), which seems to
indicate that RT didn’t get an id value back from SQL (ie, its a SQL
problem, not immediately RT).

I’d look through the query log on your SQL server to see what the insert
command supplied was, and any other debug information supplied by your SQL
server concerning this.


Walter Marchuk Senior Computer Specialist

Might want to fix that line wrapping there.

Regards,


Bruce Campbell RIPE
Systems/Network Engineer NCC
www.ripe.net - PGP562C8B1B Operations/Security


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

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

I am upgrading from RT 2.0.4 to RT 2.0.14. I too believe it is an SQL
issue, because if I install from scratch everything then works.
The problem is that I need to retain the old data otherwise there is
no upgrade.

Ok, so at a rough guess the id field in the Tickets table is somehow not
auto-incrementing. Its late here :wink:

RT works except for new ticket creation. Looking through mysql logs
here is what I see:
mysql> INSERT INTO Tickets (Creator, Due, Status, LastUpdatedBy, Resolved,
Type, TimeWorked, LastUpdated, Subject, FinalPriority, Queue, Created,
TimeLeft, InitialPriority, Owner, Priority, Starts) VALUES (‘5’,
‘1970-01-01 00:00:00’, ‘new’, ‘5’, NULL, ‘ticket’, ‘’, ‘2002-08-01
18:10:56’, ‘test’, ‘0’, ‘8’, ‘2002-08-01 18:10:56’, ‘’, ‘0’, ‘5’, ‘0’,
‘1970-01-01 00:00:00’);
ERROR 1062: Duplicate entry ‘4485’ for key 1

Hrm. Personally I’d install from scratch to a new database to insure that
all of the tables are created correctly. If the tables are the same as
etc/schema.mysql in the tarball, then you might be having oddities with
auto_increment. Try:

mysql --user=rt_user --pass=PASSWORD rt2
-e “ALTER TABLE Tickets AUTO_INCREMENT = someval;”

where someval is your highest ticket number plus 5 or 10.

I only see one insert in the logs and then it quits…probably because of
the error?

Yes, as it doesn’t know which ticket id it just has, it cannot create any
other aspects of the transaction (well, it can create them, it just
doesn’t know which ticket they’re for).

I’ve ran insertdata 2.0.4 and it doesnt seem to do much.

Regards,

                         Bruce Campbell                            RIPE
               Systems/Network Engineer                             NCC
             www.ripe.net - PGP562C8B1B             Operations/Security