RT 1.3.100 installation from scratch

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

thanks,

Greg

failure.txt (2.03 KB)

Greg: looks like you’re using mysql 3.22. RT needs 3.23On Fri, Jun 15, 2001 at 01:50:43PM +1000, Greg Boug wrote:

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

thanks,

Greg
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, 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, chunk 258.
Database handle destroyed without explicit disconnect, chunk 258.
make: *** [initdb.rtuser] Error 255

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

And I’m told we do share some common rituals. Our “flame war” is apparently
held in person in their land and called “project meeting”.
-Alan Cox [on “Suits”]