Make install

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

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,
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, chunk 263.
*** Error code 255

I suspect you’re still running both versions of mysql. or that the new
tools are installed, but mysql 3.22 is still running.On Mon, Oct 22, 2001 at 12:53:58PM +0100, Barnaby Puttick wrote:

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

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,
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, chunk 263.
*** Error code 255


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

http://www.bestpractical.com/products/rt – Trouble Ticketing. Free.