Restore root password

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 :frowning:

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