[rt-users] make install

[Barnaby Puttick]

Hi,

I am having trouble installing RT-2-0-8

I got the attached error after running make install, I looked through the
archives and found that I was running the wrong version of MYSQL.

I am now running 3.23.42

juniper:[/usr/local/src/rt-2-0-8]:# mysqld -V
mysqld  Ver 3.23.42 for unknown-freebsdelf4.3 on i386

And I am still having problems.

Any help would be appreciated  :)

Regards

Barnaby Puttick


--

juniper:[/usr/local/src/rt-2-0-8]:# make install
mkdir -p //home/rt/rt2/bin
mkdir -p //home/rt/rt2/WebRT/data
mkdir -p //home/rt/rt2/WebRT/sessiondata
mkdir -p //home/rt/rt2/etc
mkdir -p //home/rt/rt2/lib
mkdir -p //home/rt/rt2/WebRT/html
mkdir -p //home/rt/rt2/local/WebRT/html
/usr/bin/perl   tools/initdb 'mysql' '/usr/local/mysql' 'localhost' ''
'root' 'rt2' create
Now creating a database for RT.
Enter the mysql password for root:
Creating mysql database rt2.
cp etc/acl.mysql '//home/rt/rt2/etc/acl.mysql'
/usr/bin/perl -p -i -e " s'!!DB_TYPE!!'"mysql"'g;
s'!!DB_HOST!!'"localhost"'g; s'!!DB_RT_PASS!!'"uniadmin22"'g;
s'!!DB_RT_HOST!!'"localhost"'g; s'!!DB_RT_USER!!'"rt_user"'g;
s'!!DB_DATABASE!!'"rt2"'g;" //home/rt/rt2/etc/acl.mysql
bin/initacls.mysql '/usr/local/mysql' 'localhost' '' 'root' '' 'rt2'
'//home/rt/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/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 163, <SCHEMA>
chunk 263.
Problem with statement:
 CREATE INDEX KeywordSelects1 ON KeywordSelects (Keyword)

Column 'Keyword' is used with UNIQUE or INDEX but is not defined as NOT
NULL at tools/initdb line 165, <SCHEMA> chunk 263.
*** Error code 255