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
<<image001.jpg>>
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com