[rt-users] make install

[Jesse Vincent]

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  :)
> 
> 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
> 
> 
> 
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 

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