[rt-users] Restore root password
Alberto Villanueva
alberto.villanueva at altran.es
Fri Feb 20 03:49:38 EST 2009
Hii all!!
If I want to restore the root password with the next sentence:
perl -I/opt/rt3/lib -MRT -MRT::User -e'RT::LoadConfig;RT::Init; my $u =
RT::User->new($RT::SystemUser); $u->Load("root"); $u->SetPassword("secret")'
I get the next errors:
DBD::mysql::st execute failed: SELECT command denied to user
'vtd_rt_dbuser'@'localhost' for table 'Users' at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Handle.pm line 505.
RT::Handle=HASH(0x1e91af0) couldn't execute the query 'SELECT * FROM Users
WHERE Name = ?' at /usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Handle.pm
line 518
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x1e91af0)',
'SELECT * FROM Users WHERE Name = ?', 'RT_System') called at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record.pm line 1207
DBIx::SearchBuilder::Record::_LoadFromSQL('RT::CurrentUser=HASH(0x1f481a8)',
'SELECT * FROM Users WHERE Name = ?', 'RT_System') called at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record.pm line 1126
DBIx::SearchBuilder::Record::LoadByCols('RT::CurrentUser=HASH(0x1f481a8)',
'Name', 'RT_System') called at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record/Cachable.pm line 119
DBIx::SearchBuilder::Record::Cachable::LoadByCols('RT::CurrentUser=HASH(0x1f481a
8)', 'Name', 'RT_System') called at /opt/rt3/lib/RT/Record.pm line 350
RT::Record::LoadByCols('RT::CurrentUser=HASH(0x1f481a8)', 'Name',
'RT_System') called at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record.pm line 1071
DBIx::SearchBuilder::Record::LoadByCol('RT::CurrentUser=HASH(0x1f481a8)',
'Name', 'RT_System') called at /opt/rt3/lib/RT/CurrentUser.pm line 203
RT::CurrentUser::LoadByName('RT::CurrentUser=HASH(0x1f481a8)',
'RT_System') called at /opt/rt3/lib/RT.pm line 480
RT::InitSystemObjects() called at /opt/rt3/lib/RT.pm line 187
RT::Init() called at -e line 1
DBD::mysql::st execute failed: SELECT command denied to user
'vtd_rt_dbuser'@'localhost' for table 'Users' at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Handle.pm line 505.
RT::Handle=HASH(0x1e91af0) couldn't execute the query 'SELECT * FROM Users
WHERE Name = ?' at /usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Handle.pm
line 518
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x1e91af0)',
'SELECT * FROM Users WHERE Name = ?', 'Nobody') called at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record.pm line 1207
DBIx::SearchBuilder::Record::_LoadFromSQL('RT::CurrentUser=HASH(0x1f22428)',
'SELECT * FROM Users WHERE Name = ?', 'Nobody') called at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record.pm line 1126
DBIx::SearchBuilder::Record::LoadByCols('RT::CurrentUser=HASH(0x1f22428)',
'Name', 'Nobody') called at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record/Cachable.pm line 119
DBIx::SearchBuilder::Record::Cachable::LoadByCols('RT::CurrentUser=HASH(0x1f2242
8)', 'Name', 'Nobody') called at /opt/rt3/lib/RT/Record.pm line 350
RT::Record::LoadByCols('RT::CurrentUser=HASH(0x1f22428)', 'Name',
'Nobody') called at /usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record.pm
line 1071
DBIx::SearchBuilder::Record::LoadByCol('RT::CurrentUser=HASH(0x1f22428)',
'Name', 'Nobody') called at /opt/rt3/lib/RT/CurrentUser.pm line 203
RT::CurrentUser::LoadByName('RT::CurrentUser=HASH(0x1f22428)', 'Nobody')
called at /opt/rt3/lib/RT.pm line 484
RT::InitSystemObjects() called at /opt/rt3/lib/RT.pm line 187
RT::Init() called at -e line 1
[Fri Feb 20 08:42:23 2009] [warning]: DBD::mysql::st execute failed: SELECT
command denied to user 'vtd_rt_dbuser'@'localhost' for table 'Users' at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Handle.pm line 505.
(/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Handle.pm:505)
[Fri Feb 20 08:42:23 2009] [warning]: RT::Handle=HASH(0x1e91af0) couldn't
execute the query 'SELECT * FROM Users WHERE Name = ?' at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Handle.pm line 518
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x1e91af0)',
'SELECT * FROM Users WHERE Name = ?', 'root') called at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record.pm line 1207
DBIx::SearchBuilder::Record::_LoadFromSQL('RT::User=HASH(0x393a730)',
'SELECT * FROM Users WHERE Name = ?', 'root') called at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record.pm line 1126
DBIx::SearchBuilder::Record::LoadByCols('RT::User=HASH(0x393a730)',
'Name', 'root') called at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record/Cachable.pm line 119
DBIx::SearchBuilder::Record::Cachable::LoadByCols('RT::User=HASH(0x393a730)',
'Name', 'root') called at /opt/rt3/lib/RT/Record.pm line 350
RT::Record::LoadByCols('RT::User=HASH(0x393a730)', 'Name', 'root')
called at /usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record.pm line 1071
DBIx::SearchBuilder::Record::LoadByCol('RT::User=HASH(0x393a730)',
'Name', 'root') called at /opt/rt3/lib/RT/User_Overlay.pm line 439
RT::User::Load('RT::User=HASH(0x393a730)', 'root') called at -e line 1
(/usr/lib/perl5/5.10.0/Carp.pm:47)
[Fri Feb 20 08:42:23 2009] [error]: Couldn't get principal for not loaded object
(/opt/rt3/lib/RT/User_Overlay.pm:1113)
[Fri Feb 20 08:42:23 2009] [crit]: Can't call method "HasRight" on an undefined
value at /opt/rt3/lib/RT/User_Overlay.pm line 1209. (/opt/rt3/lib/RT.pm:377)
Can't call method "HasRight" on an undefined value at
/opt/rt3/lib/RT/User_Overlay.pm line 1209.
vtdrt:~ # perl -I/opt/rt3/lib -MRT -MRT::User -e'RT::LoadConfig;RT::Init; my $u
= RT::User->new($RT::SystemUser); $u->Load("root"); $u->SetPassword("secret")'
DBD::mysql::st execute failed: SELECT command denied to user
'vtd_rt_dbuser'@'localhost' for table 'Users' at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Handle.pm line 505.
RT::Handle=HASH(0x1e91af0) couldn't execute the query 'SELECT * FROM Users
WHERE Name = ?' at /usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Handle.pm
line 518
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x1e91af0)',
'SELECT * FROM Users WHERE Name = ?', 'RT_System') called at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record.pm line 1207
DBIx::SearchBuilder::Record::_LoadFromSQL('RT::CurrentUser=HASH(0x1f481a8)',
'SELECT * FROM Users WHERE Name = ?', 'RT_System') called at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record.pm line 1126
DBIx::SearchBuilder::Record::LoadByCols('RT::CurrentUser=HASH(0x1f481a8)',
'Name', 'RT_System') called at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record/Cachable.pm line 119
DBIx::SearchBuilder::Record::Cachable::LoadByCols('RT::CurrentUser=HASH(0x1f481a
8)', 'Name', 'RT_System') called at /opt/rt3/lib/RT/Record.pm line 350
RT::Record::LoadByCols('RT::CurrentUser=HASH(0x1f481a8)', 'Name',
'RT_System') called at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record.pm line 1071
DBIx::SearchBuilder::Record::LoadByCol('RT::CurrentUser=HASH(0x1f481a8)',
'Name', 'RT_System') called at /opt/rt3/lib/RT/CurrentUser.pm line 203
RT::CurrentUser::LoadByName('RT::CurrentUser=HASH(0x1f481a8)',
'RT_System') called at /opt/rt3/lib/RT.pm line 480
RT::InitSystemObjects() called at /opt/rt3/lib/RT.pm line 187
RT::Init() called at -e line 1
DBD::mysql::st execute failed: SELECT command denied to user
'vtd_rt_dbuser'@'localhost' for table 'Users' at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Handle.pm line 505.
RT::Handle=HASH(0x1e91af0) couldn't execute the query 'SELECT * FROM Users
WHERE Name = ?' at /usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Handle.pm
line 518
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x1e91af0)',
'SELECT * FROM Users WHERE Name = ?', 'Nobody') called at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record.pm line 1207
DBIx::SearchBuilder::Record::_LoadFromSQL('RT::CurrentUser=HASH(0x1f22428)',
'SELECT * FROM Users WHERE Name = ?', 'Nobody') called at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record.pm line 1126
DBIx::SearchBuilder::Record::LoadByCols('RT::CurrentUser=HASH(0x1f22428)',
'Name', 'Nobody') called at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record/Cachable.pm line 119
DBIx::SearchBuilder::Record::Cachable::LoadByCols('RT::CurrentUser=HASH(0x1f2242
8)', 'Name', 'Nobody') called at /opt/rt3/lib/RT/Record.pm line 350
RT::Record::LoadByCols('RT::CurrentUser=HASH(0x1f22428)', 'Name',
'Nobody') called at /usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record.pm
line 1071
DBIx::SearchBuilder::Record::LoadByCol('RT::CurrentUser=HASH(0x1f22428)',
'Name', 'Nobody') called at /opt/rt3/lib/RT/CurrentUser.pm line 203
RT::CurrentUser::LoadByName('RT::CurrentUser=HASH(0x1f22428)', 'Nobody')
called at /opt/rt3/lib/RT.pm line 484
RT::InitSystemObjects() called at /opt/rt3/lib/RT.pm line 187
RT::Init() called at -e line 1
[Fri Feb 20 08:45:41 2009] [warning]: DBD::mysql::st execute failed: SELECT
command denied to user 'vtd_rt_dbuser'@'localhost' for table 'Users' at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Handle.pm line 505.
(/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Handle.pm:505)
[Fri Feb 20 08:45:42 2009] [warning]: RT::Handle=HASH(0x1e91af0) couldn't
execute the query 'SELECT * FROM Users WHERE Name = ?' at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Handle.pm line 518
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x1e91af0)',
'SELECT * FROM Users WHERE Name = ?', 'root') called at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record.pm line 1207
DBIx::SearchBuilder::Record::_LoadFromSQL('RT::User=HASH(0x393a730)',
'SELECT * FROM Users WHERE Name = ?', 'root') called at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record.pm line 1126
DBIx::SearchBuilder::Record::LoadByCols('RT::User=HASH(0x393a730)',
'Name', 'root') called at
/usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record/Cachable.pm line 119
DBIx::SearchBuilder::Record::Cachable::LoadByCols('RT::User=HASH(0x393a730)',
'Name', 'root') called at /opt/rt3/lib/RT/Record.pm line 350
RT::Record::LoadByCols('RT::User=HASH(0x393a730)', 'Name', 'root')
called at /usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record.pm line 1071
DBIx::SearchBuilder::Record::LoadByCol('RT::User=HASH(0x393a730)',
'Name', 'root') called at /opt/rt3/lib/RT/User_Overlay.pm line 439
RT::User::Load('RT::User=HASH(0x393a730)', 'root') called at -e line 1
(/usr/lib/perl5/5.10.0/Carp.pm:47)
[Fri Feb 20 08:45:42 2009] [error]: Couldn't get principal for not loaded object
(/opt/rt3/lib/RT/User_Overlay.pm:1113)
[Fri Feb 20 08:45:42 2009] [crit]: Can't call method "HasRight" on an undefined
value at /opt/rt3/lib/RT/User_Overlay.pm line 1209. (/opt/rt3/lib/RT.pm:377)
Can't call method "HasRight" on an undefined value at
/opt/rt3/lib/RT/User_Overlay.pm line 1209.
Any idea??
Thanks a lot!, and I'm sorry :-(
Regards,
ALBERTO VILLANUEVA VAL
Consultor
____________________________________________
Altran
ParqueEmpresarial Las Mercedes, Edificio 1
C/ Campezo, 1. 28022 Madrid
Tel : + 34 91 744 46 00
Fax: + 34 91 415 24 57
<http://www.altran.es> www.altran.es
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090220/6dbf7ac0/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 3874 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090220/6dbf7ac0/attachment.jpg>
More information about the rt-users
mailing list