What is RT trying to do, that is should fail when this debug script works?
use EZDBI;
use Data::Dumper;
Connect ‘mysql:rt’, ‘rt_user’, ‘PASSWORD’;
my $r = Select ‘* From Users LIMIT 2’;
print Dumper $_ while( $_ = $r->({}) );
END
$VAR1 = {
‘WebEncoding’ => undef,
‘AuthSystem’ => undef,
‘PGPKey’ => undef,
‘Password’ => ‘NO-PASSWORD’,
‘MobilePhone’ => undef,
‘WorkPhone’ => undef,
‘id’ => ‘1’,
‘LastUpdated’ => ‘2008-08-02 14:59:35’,
‘PagerPhone’ => undef,
‘ExternalContactInfoId’ => undef,
‘ContactInfoSystem’ => undef,
‘Creator’ => ‘1’,
‘LastUpdatedBy’ => ‘1’,
‘HomePhone’ => undef,
‘Address1’ => undef,
‘Created’ => ‘2008-08-02 14:59:35’,
‘ExternalAuthId’ => undef,
‘Comments’ => ‘Do not delete or modify this user. It is
integral to RT’s internal database structures’,
‘NickName’ => undef,
‘Address2’ => undef,
‘Timezone’ => undef,
‘FreeformContactInfo’ => undef,
‘RealName’ => ‘The RT System itself’,
‘City’ => undef,
‘EmailAddress’ => undef,
‘EmailEncoding’ => undef,
‘State’ => undef,
‘Signature’ => undef,
‘Zip’ => undef,
‘Organization’ => undef,
‘Lang’ => undef,
‘Gecos’ => undef,
‘Country’ => undef,
‘Name’ => ‘RT_System’
};
$VAR1 = {
‘WebEncoding’ => undef,
‘AuthSystem’ => undef,
‘PGPKey’ => undef,
‘Password’ => ‘NO-PASSWORD’,
‘MobilePhone’ => undef,
‘WorkPhone’ => undef,
‘id’ => ‘6’,
‘LastUpdated’ => ‘2008-08-02 14:59:35’,
‘PagerPhone’ => undef,
‘ExternalContactInfoId’ => undef,
‘ContactInfoSystem’ => undef,
‘Creator’ => ‘1’,
‘LastUpdatedBy’ => ‘1’,
‘HomePhone’ => undef,
‘Address1’ => undef,
‘Created’ => ‘2008-08-02 14:59:35’,
‘ExternalAuthId’ => undef,
‘Comments’ => ‘Do not delete or modify this user. It is
integral to RT’s internal data structures’,
‘NickName’ => undef,
‘Address2’ => undef,
‘Timezone’ => undef,
‘FreeformContactInfo’ => undef,
‘RealName’ => ‘Nobody in particular’,
‘City’ => undef,
‘EmailAddress’ => ‘’,
‘EmailEncoding’ => undef,
‘State’ => undef,
‘Signature’ => undef,
‘Zip’ => undef,
‘Organization’ => undef,
‘Lang’ => undef,
‘Gecos’ => undef,
‘Country’ => undef,
‘Name’ => ‘Nobody’
};
Cambridge Energy Alliance: Save money. Save the planet.