[rt-devel] Access problems with rt

Jesse jesse at fsck.com
Fri Jan 12 14:51:25 EST 2001


[for those playing along at home, 1.3.34 fixes this issue]


On Fri, Jan 12, 2001 at 10:03:18AM -0000, eOk wrote:
> no it happens when I try and create a user and click basic
> 
> heres the error
> 
> System error
> 
> while serving rt.e-merge.ie /Admin/Users/Modify.html
> error while executing /Admin/Users/Modify.html:
> DBD::mysql::st execute failed: Column 'UserId' cannot be null at
> /usr/local/lib/perl5/site_perl/5.005/DBIx/SearchBuilder/Handle.pm line 236,
> <GEN3> chunk 137.
> 	HTML::Mason::Request::__ANON__('DBD::mysql::st execute failed: Column
> \'UserId\' cannot be null ...') called at
> /usr/local/lib/perl5/site_perl/5.005/DBIx/SearchBuilder/Handle.pm line 236
> 	DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x96d8884)',
> 'INSERT INTO Users (Creator, Created, Privileged, Password, UserI...')
> called at /usr/local/lib/perl5/site_perl/5.005/DBIx/SearchBuilder/Handle.pm
> line 94
> 	DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x96d8884)', 'Users',
> 'Creator', 3, 'Created', '2001-01-12 10:02:28', 'Privileged', 0, ...) called
> at /usr/local/lib/perl5/site_perl/5.005/DBIx/SearchBuilder/Handle/mysql.pm
> line 22
> 	DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0x96d8884)',
> 'Users', 'Creator', 3, 'Created', '2001-01-12 10:02:28', 'Privileged', 0,
> ...) called at
> /usr/local/lib/perl5/site_perl/5.005/DBIx/SearchBuilder/Record.pm line 484
> 	DBIx::SearchBuilder::Record::Create('RT::User=HASH(0x975d908)', 'Password',
> '*NO-PASSWORD*', 'Privileged', 0, 'UserId', undef, 'Created', ...) called at
> /local/rt/lib/RT/Record.pm line 80
> 	RT::Record::Create('Password', '*NO-PASSWORD*', 'Privileged', 0, 'UserId',
> undef, 'Created', '2001-01-12 10:02:28', ...) called at
> /local/rt/lib/RT/User.pm line 141
> 	RT::User::Create('RT::User=HASH(0x975d908)', 'UserId', undef) called at
> /local/rt/WebRT/data/obj/Admin/Users/Modify.html line 57
> 
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x977539
> 0)', 'id', 'new') called at
> /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm line 657
> 
> HTML::Mason::Request::comp1('HTML::Mason::Request::ApacheHandler=HASH(0x9737
> eac)', 'HTML::Mason::Component::FileBased=HASH(0x9775390)', 'id', 'new')
> called at /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm line
> 576
> 
> HTML::Mason::Request::comp('HTML::Mason::Request::ApacheHandler=HASH(0x9737e
> ac)', 'HTML::Mason::Component::FileBased=HASH(0x9775390)', 'id', 'new')
> called at /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm line
> 310
> 
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x971fe6
> 4)', 'id', 'new') called at
> /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm line 657
> 
> HTML::Mason::Request::comp1('HTML::Mason::Request::ApacheHandler=HASH(0x9737
> eac)', 'HASH(0x975d114)',
> 'HTML::Mason::Component::FileBased=HASH(0x971fe64)', 'id', 'new') called at
> /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm line 582
> 
> HTML::Mason::Request::comp('HTML::Mason::Request::ApacheHandler=HASH(0x9737e
> ac)', 'HASH(0x975d114)',
> 'HTML::Mason::Component::FileBased=HASH(0x971fe64)', 'id', 'new') called at
> /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm line 152
> 	eval {...} called at
> /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm line 152
> 
> HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x9737e
> ac)', '/Admin/Users/Modify.html', 'id', 'new') called at
> /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/ApacheHandler.pm line 651
> 
> HTML::Mason::ApacheHandler::handle_request_1('HTML::Mason::ApacheHandler=HAS
> H(0x96d8514)', 'Apache=SCALAR(0x96d88a8)',
> 'HTML::Mason::Request::ApacheHandler=HASH(0x9737eac)', undef) called at
> /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/ApacheHandler.pm line 322
> 	eval {...} called at
> /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/ApacheHandler.pm line 322
> 
> HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(
> 0x96d8514)', 'Apache=SCALAR(0x96d88a8)') called at /local/rt/bin/webmux.pl
> line 138
> 	RT::Mason::handler('Apache=SCALAR(0x96d88a8)') called at /dev/null line 0
> 	eval {...} called at /dev/null line 0
> 
> backtrace: /Admin/Users/Modify.html <= /autohandler
> 
> also when going directly to a ticket the following comes up
> System error
> 
> while serving rt.e-merge.ie /SelfService/Details.html
> error while executing /SelfService/Details.html:
> Can't locate object method "Next" via package "Permission Denied" at
> /local/rt/WebRT/data/obj/SelfService/Details.html line 169, <FH> chunk 1.
> 	HTML::Mason::Request::__ANON__('Can\'t locate object method "Next" via
> package "Permission Denie...') called at
> /local/rt/WebRT/data/obj/SelfService/Details.html line 169
> 
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x980088
> 4)', 'id', 1) called at
> /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm line 657
> 
> HTML::Mason::Request::comp1('HTML::Mason::Request::ApacheHandler=HASH(0x982f
> d08)', 'HTML::Mason::Component::FileBased=HASH(0x9800884)', 'id', 1) called
> at /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm line 576
> 
> HTML::Mason::Request::comp('HTML::Mason::Request::ApacheHandler=HASH(0x982fd
> 08)', 'HTML::Mason::Component::FileBased=HASH(0x9800884)', 'id', 1) called
> at /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm line 310
> 
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x971eaa
> c)', 'id', 1) called at
> /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm line 657
> 
> HTML::Mason::Request::comp1('HTML::Mason::Request::ApacheHandler=HASH(0x982f
> d08)', 'HASH(0x98006a0)',
> 'HTML::Mason::Component::FileBased=HASH(0x971eaac)', 'id', 1) called at
> /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm line 582
> 
> HTML::Mason::Request::comp('HTML::Mason::Request::ApacheHandler=HASH(0x982fd
> 08)', 'HASH(0x98006a0)',
> 'HTML::Mason::Component::FileBased=HASH(0x971eaac)', 'id', 1) called at
> /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm line 152
> 	eval {...} called at
> /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm line 152
> 
> HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x982fd
> 08)', '/SelfService/Details.html', 'id', 1) called at
> /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/ApacheHandler.pm line 651
> 
> HTML::Mason::ApacheHandler::handle_request_1('HTML::Mason::ApacheHandler=HAS
> H(0x96d8514)', 'Apache=SCALAR(0x97d6b3c)',
> 'HTML::Mason::Request::ApacheHandler=HASH(0x982fd08)', undef) called at
> /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/ApacheHandler.pm line 322
> 	eval {...} called at
> /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/ApacheHandler.pm line 322
> 
> HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(
> 0x96d8514)', 'Apache=SCALAR(0x97d6b3c)') called at /local/rt/bin/webmux.pl
> line 138
> 	RT::Mason::handler('Apache=SCALAR(0x97d6b3c)') called at /dev/null line 0
> 	eval {...} called at /dev/null line 0
> 
> backtrace: /SelfService/Details.html <= /autohandler
> 
> regards
> 
> 
> -----Original Message-----
> From: Jesse [mailto:jesse at fsck.com]
> Sent: 11 January 2001 19:27
> To: eOk
> Subject: Re: [rt-devel] Access problems with rt
> 
> 
> 
> Does it happen only for the reminder page or for all pages?
> 
> On Thu, Jan 11, 2001 at 11:10:21AM -0000, eOk wrote:
> > Hey
> >
> > Once I got rt2 installed I get the followiong errors
> >
> > while serving rt.e-merge.ie /NoAuth/Reminder.html
> > error while executing /NoAuth/Reminder.html:
> > could not find component for path '/Elements/Head'
> > 	HTML::Mason::Request::__ANON__('could not find component for path
> > \'/Elements/Head\'^J') called at
> > /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm line 602
> >
> >
> HTML::Mason::Request::comp1('HTML::Mason::Request::ApacheHandler=HASH(0x989c
> > 538)', '/Elements/Head', 'title', 'Password Reminder') called at
> > /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm line 576
> >
> >
> HTML::Mason::Request::comp('HTML::Mason::Request::ApacheHandler=HASH(0x989c5
> > 38)', '/Elements/Head', 'title', 'Password Reminder') called at
> > /local/rt/WebRT/data/obj/NoAuth/Reminder.html line 13
> >
> >
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x98a1c0
> > c)') called at /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm
> > line 657
> >
> >
> HTML::Mason::Request::comp1('HTML::Mason::Request::ApacheHandler=HASH(0x989c
> > 538)', 'HTML::Mason::Component::FileBased=HASH(0x98a1c0c)') called at
> > /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm line 576
> >
> >
> HTML::Mason::Request::comp('HTML::Mason::Request::ApacheHandler=HASH(0x989c5
> > 38)', 'HTML::Mason::Component::FileBased=HASH(0x98a1c0c)') called at
> > /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm line 310
> >
> >
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x971d15
> > 0)') called at /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm
> > line 657
> >
> >
> HTML::Mason::Request::comp1('HTML::Mason::Request::ApacheHandler=HASH(0x989c
> > 538)', 'HASH(0x98a1670)',
> > 'HTML::Mason::Component::FileBased=HASH(0x971d150)') called at
> > /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm line 582
> >
> >
> HTML::Mason::Request::comp('HTML::Mason::Request::ApacheHandler=HASH(0x989c5
> > 38)', 'HASH(0x98a1670)',
> > 'HTML::Mason::Component::FileBased=HASH(0x971d150)') called at
> > /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm line 152
> > 	eval {...} called at
> > /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/Request.pm line 152
> >
> >
> HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x989c5
> > 38)', '/NoAuth/Reminder.html') called at
> > /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/ApacheHandler.pm line 651
> >
> >
> HTML::Mason::ApacheHandler::handle_request_1('HTML::Mason::ApacheHandler=HAS
> > H(0x96dcd14)', 'Apache=SCALAR(0x9765dd4)',
> > 'HTML::Mason::Request::ApacheHandler=HASH(0x989c538)', undef) called at
> > /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/ApacheHandler.pm line 322
> > 	eval {...} called at
> > /usr/local/lib/perl5/site_perl/5.005/HTML/Mason/ApacheHandler.pm line 322
> >
> >
> HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(
> > 0x96dcd14)', 'Apache=SCALAR(0x9765dd4)') called at /local/rt/bin/webmux.pl
> > line 138
> > 	RT::Mason::handler('Apache=SCALAR(0x9765dd4)') called at /dev/null line 0
> > 	eval {...} called at /dev/null line 0
> >
> > backtrace: /NoAuth/Reminder.html <= /autohandler
> >
> >
> > any ideas ?
> >
> > -----Original Message-----
> > From: Jesse [mailto:jesse at fsck.com]
> > Sent: 03 January 2001 18:38
> > To: eOk
> > Cc: rt-devel at lists.fsck.com
> > Subject: Re: [rt-devel] RE: [rt-users] Installing 1.3.29
> >
> >
> > Very simple. You're running Mysql 3.22.  RT 2.0 _requires_ Mysql 3.23
> >
> >
> > On Wed, Jan 03, 2001 at 11:35:59AM -0000, eOk wrote:
> > > An answer to youre DBD question I installed
> > > Msql-Mysql-modules-1.2215
> > > and tried to make install rt2 again, and got this message
> > >
> > > mkdir -p /export/rt2/bin
> > > mkdir -p /export/rt2/WebRT/data
> > > mkdir -p /export/rt2/etc
> > > mkdir -p /export/rt2/lib
> > > mkdir -p /export/rt2/WebRT/html
> > > # We don't need to do this anymore. all we want to copy is config.pm
> > > # That gets done elsewhere
> > > #cp -rp ./etc/* /export/rt2/etc
> > > /usr/bin/perl   tools/initdb 'mysql' '/usr' 'localhost' 'root' 'rt2'
> 'rt'
> > > Enter the mysql password for root:
> > >
> > > Database creation parameters:
> > >
> > > DB_TYPE         = mysql
> > > DB_HOME         = /usr
> > > DB_HOST         = localhost
> > > DB_DBA          = root
> > > DB_DBA_PASSWORD = <hidden>
> > > DB_DATABASE     = rt2
> > >
> > > About to drop mysql database rt2.
> > > WARNING: This will erase all data in rt2.
> > > If you have an existing RT 2.x installation, this will destory all your
> > > data.
> > > Proceed [y/N]:y
> > > dsn: dbi:mysql:dbname=rt2;host=localhost
> > >
> > > Dropping mysql database rt2.
> > >
> > > Creating mysql database rt2.
> > >
> > > Creating database schema.
> > > CREATE TABLE Groups (
> > >   id INTEGER NOT NULL  AUTO_INCREMENT,
> > >   Name varchar(16) NULL  ,
> > >   Description varchar(64) NULL  ,
> > >   Pseudo integer NULL  ,
> > >   PRIMARY KEY (id),
> > >   UNIQUE (Name)
> > > )
> > > DBD::mysql::st execute failed: Column 'Name' is used with UNIQUE or
> INDEX
> > > but is not defined as NOT NULL at tools/initdb line 67, <STDIN> chunk 2.
> > > Column 'Name' is used with UNIQUE or INDEX but is not defined as NOT
> NULL
> > at
> > > tools/initdb line 67, <STDIN> chunk 2.
> > > Issuing rollback() for database handle being DESTROY'd without explicit
> > > disconnect(), <STDIN> chunk 2.
> > > make: *** [database] Error 255
> > >
> > > any more help ?
> > >
> > > -----Original Message-----
> > > From: Jesse [mailto:jesse at fsck.com]
> > > Sent: 02 January 2001 18:01
> > > To: eOk
> > > Cc: rt-users at lists.fsck.com; rt-devel at lists.fsck.com
> > > Subject: Re: [rt-users] Installing 1.3.29
> > >
> > >
> > > [followups to rt-devel, where the 1.3 series is best talked about]
> > >
> > > What version of Mysql and DBD::Mysql are you running?
> > > Have your run bin/testdeps -fix lately?
> > >
> > >         -j
> > >
> > > On Tue, Jan 02, 2001 at 05:17:08PM -0000, eOk wrote:
> > > > When trying out new rt
> > > >
> > > > the following error occur
> > > >
> > > > Creating mysql database rt2.
> > > > DBI->connect(dbname=;host=localhost) failed: No Database Selected at
> > > > /usr/lib/perl5/site_perl/5.005/DBIx/DataSource/Driver.pm line 74
> > > > No Database Selected at
> > > > /usr/lib/perl5/site_perl/5.005/DBIx/DataSource/Driver.pm line 74,
> > <STDIN>
> > > > chunk 2.
> > > >
> > > > it doesnt seem to be passing a dbname variable ?
> > > >
> > > > any clues ?
> > > >
> > > > Eok
> > > >
> > > >
> > > > _______________________________________________
> > > > rt-users mailing list
> > > > rt-users at lists.fsck.com
> > > > http://lists.fsck.com/mailman/listinfo/rt-users
> > > >
> > >
> > > --
> > > jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com
> > > 70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90
> > >
> > > "If IBM _wanted_ to make clones, we could make them cheaper and faster
> > than
> > > anyone else!"  - An IBM Rep. visiting Vassar College's Comp Sci
> > Department.
> > >
> > >
> > > _______________________________________________
> > > Rt-devel mailing list
> > > Rt-devel at lists.fsck.com
> > > http://lists.fsck.com/mailman/listinfo/rt-devel
> > >
> >
> > --
> > jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com
> > 70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90
> >
> > There are no supercomputer applications that are solvable that cannot be
> > solved
> > in finite time using a fucking TRS-80 with approprite disk/tape drives.
> > Zero.
> > 									-Tanj
> >
> >
> > _______________________________________________
> > Rt-devel mailing list
> > Rt-devel at lists.fsck.com
> > http://lists.fsck.com/mailman/listinfo/rt-devel
> >
> 
> --
> jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com
> 70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90
> 
> There are no supercomputer applications that are solvable that cannot be
> solved
> in finite time using a fucking TRS-80 with approprite disk/tape drives.
> Zero.
> 									-Tanj
> 
> 

-- 
jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com 
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

"If IBM _wanted_ to make clones, we could make them cheaper and faster than
anyone else!"  - An IBM Rep. visiting Vassar College's Comp Sci Department.




More information about the Rt-devel mailing list