[rt-devel] RT 1.3.100 installation from scratch

[Greg Boug]

Hi all,

Have attempted an installation of RT2 from scratch (ie. all Perl modules, 
database, etc.) and have hit a snag at the 'make install' stage. 

Attached is the output from the make install command. It appears to be an
SQL query fault, but I'm not 100% sure... 

Suggestions on what I should be poking at would be appreciated :) 

thanks,

Greg
-------------- next part --------------
hostname:/usr/src/apps/rt-1-3-100# make install
mkdir -p /opt/rt2/bin
mkdir -p /opt/rt2/WebRT/data
mkdir -p /opt/rt2/WebRT/sessiondata
mkdir -p /opt/rt2/etc
mkdir -p /opt/rt2/lib
mkdir -p /opt/rt2/WebRT/html
mkdir -p /opt/rt2/local/WebRT/html
/usr/bin/perl   tools/initdb 'mysql' '/usr' 'localhost' 'root' 'rt2' create
Now creating a database for RT.
Enter the mysql password for root:
Creating mysql database rt2.
cp etc/acl.mysql '/opt/rt2/etc/acl.mysql'
/usr/bin/perl -p -i -e " s'!!DB_TYPE!!'mysql'g;\
                        s'!!DB_HOST!!'localhost'g;\
                        s'!!DB_RT_PASS!!'rt_pass'g;\
                        s'!!DB_RT_HOST!!'localhost'g;\
                        s'!!DB_RT_USER!!'rt_user'g;\
                        s'!!DB_DATABASE!!'rt2'g;" /opt/rt2/etc/acl.mysql
bin/initacls.mysql '/usr' 'localhost' 'root' '' 'rt2' '/opt/rt2/etc/acl.mysql'
Enter the mysql administrator's database password to create a new user for RT
Enter password:
Enter the mysql administrator's database password to nondestructively reload the
 database
Enter password:
/usr/bin/perl   tools/initdb 'mysql' '/usr' '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, <SCHEMA> chunk 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, <SCHEMA> chunk 258.
Database handle destroyed without explicit disconnect, <SCHEMA> chunk 258.
make: *** [initdb.rtuser] Error 255