[rt-users] Eeek! RT is unable to connect to database

Jerrad Pierce jpierce at cambridgeenergyalliance.org
Tue Feb 10 13:38:04 EST 2009


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.



More information about the rt-users mailing list