[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