[rt-devel] RT 1.3.100 installation from scratch

[Jesse]

Greg: looks like you're using mysql 3.22.  RT needs 3.23


On 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 :) 
> 
> 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, <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
> 


-- 
jesse reed vincent -- root at eruditorum.org -- jesse at 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"]