[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