hi guys,
i’m getting the following error during a make install of rt-2.0.0:
Creating mysql database rt2.
cp etc/acl.mysql ‘/usr/local/rt/etc/acl.mysql’
/usr/local/bin/perl -p -i -e " s’!!DB_TYPE!!‘mysql’g;
s’!!DB_HOST!!‘localhost’g;
s’!!DB_RT_PASS!!‘My!word%z0t’g;
s’!!DB_RT_HOST!!‘localhost’g;
s’!!DB_RT_USER!!‘rt_user’g;
s’!!DB_DATABASE!!‘rt2’g;" /usr/local/rt/etc/acl.mysql
bin/initacls.mysql ‘/usr/local/mysql’ ‘localhost’ ‘root’ ‘O4Peace’ ‘rt2’
’/usr/local/rt/etc/acl.mysql’
Enter the mysql administrator’s database password to create a new user for RT
Enter the mysql administrator’s database password to nondestructively
reload the database
/usr/local/bin/perl tools/initdb ‘mysql’ ‘/usr/local/mysql’ ‘localhost’
‘rt_user’ ‘rt2’ insert
Now populating database schema.
Enter the mysql password for rt_user:
Creating database schema.
DBD::mysql::st execute failed: Column ‘Keyword’ is used with UNIQUE or
INDEX but is not defined as NOT NULL at tools/initdb line 160,
line 258.
Problem with statement:
CREATE TABLE KeywordSelects (
id INTEGER NOT NULL AUTO_INCREMENT,
Name varchar(255) NULL ,
Keyword integer NULL ,
Single integer NULL ,
Depth integer NOT NULL DEFAULT 0 ,
ObjectType varchar(32) NOT NULL ,
ObjectField varchar(32) NULL ,
ObjectValue varchar(255) NULL ,
Disabled int2 NOT NULL DEFAULT 0 ,
PRIMARY KEY (id),
INDEX (Keyword),
INDEX (ObjectType, ObjectField, ObjectValue)
)
Column ‘Keyword’ is used with UNIQUE or INDEX but is not defined as NOT
NULL at tools/initdb line 162, line 258.
make: *** [initdb.rtuser] Error 255
i’ve just installed mod_perl (as a DSO, built apache ages ago and couldn’t be
bothered doing it again), and make testdeps says nothing out of the ordinary.
rt-1.0.7 continues to work fine… any ideas?
cheers,
Chris
RT 2.0 requires mysql 3.23. You’re running mysql 3.22On Thu, Jul 05, 2001 at 02:45:42PM +0800, Chris Waltham wrote:
hi guys,
i’m getting the following error during a make install of rt-2.0.0:
Creating mysql database rt2.
cp etc/acl.mysql ‘/usr/local/rt/etc/acl.mysql’
/usr/local/bin/perl -p -i -e " s’!!DB_TYPE!!‘mysql’g;
s’!!DB_HOST!!‘localhost’g;
s’!!DB_RT_PASS!!‘My!word%z0t’g;
s’!!DB_RT_HOST!!‘localhost’g;
s’!!DB_RT_USER!!‘rt_user’g;
s’!!DB_DATABASE!!'rt2’g;" /usr/local/rt/etc/acl.mysql
bin/initacls.mysql ‘/usr/local/mysql’ ‘localhost’ ‘root’ ‘O4Peace’ ‘rt2’
‘/usr/local/rt/etc/acl.mysql’
Enter the mysql administrator’s database password to create a new user for RT
Enter the mysql administrator’s database password to nondestructively
reload the database
/usr/local/bin/perl tools/initdb ‘mysql’ ‘/usr/local/mysql’ ‘localhost’
‘rt_user’ ‘rt2’ insert
Now populating database schema.
Enter the mysql password for rt_user:
Creating database schema.
DBD::mysql::st execute failed: Column ‘Keyword’ is used with UNIQUE or
INDEX but is not defined as NOT NULL at tools/initdb line 160,
line 258.
Problem with statement:
CREATE TABLE KeywordSelects (
id INTEGER NOT NULL AUTO_INCREMENT,
Name varchar(255) NULL ,
Keyword integer NULL ,
Single integer NULL ,
Depth integer NOT NULL DEFAULT 0 ,
ObjectType varchar(32) NOT NULL ,
ObjectField varchar(32) NULL ,
ObjectValue varchar(255) NULL ,
Disabled int2 NOT NULL DEFAULT 0 ,
PRIMARY KEY (id),
INDEX (Keyword),
INDEX (ObjectType, ObjectField, ObjectValue)
)
Column ‘Keyword’ is used with UNIQUE or INDEX but is not defined as NOT
NULL at tools/initdb line 162, line 258.
make: *** [initdb.rtuser] Error 255
–
i’ve just installed mod_perl (as a DSO, built apache ages ago and couldn’t be
bothered doing it again), and make testdeps says nothing out of the ordinary.
rt-1.0.7 continues to work fine… any ideas?
cheers,
Chris
rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users
jesse reed vincent – root@eruditorum.org – jesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90
pretty soon we’re going to HAVE to have hypertext mail!
–Tim Berners Lee. (8 Jan 1993 on www-talk)
RT 2.0 requires mysql 3.23. You’re running mysql 3.22
Oh, whoops. Didn’t realise. Thanks!
Chris, who promises to RTFM in the future