[rt-devel] RE: [rt-users] Installing 1.3.29

[eOk]

An answer to youre DBD question I installed
Msql-Mysql-modules-1.2215
and tried to make install rt2 again, and got this message

mkdir -p /export/rt2/bin
mkdir -p /export/rt2/WebRT/data
mkdir -p /export/rt2/etc
mkdir -p /export/rt2/lib
mkdir -p /export/rt2/WebRT/html
# We don't need to do this anymore. all we want to copy is config.pm
# That gets done elsewhere
#cp -rp ./etc/* /export/rt2/etc
/usr/bin/perl   tools/initdb 'mysql' '/usr' 'localhost' 'root' 'rt2' 'rt'
Enter the mysql password for root:

Database creation parameters:

DB_TYPE         = mysql
DB_HOME         = /usr
DB_HOST         = localhost
DB_DBA          = root
DB_DBA_PASSWORD = <hidden>
DB_DATABASE     = rt2

About to drop mysql database rt2.
WARNING: This will erase all data in rt2.
If you have an existing RT 2.x installation, this will destory all your
data.
Proceed [y/N]:y
dsn: dbi:mysql:dbname=rt2;host=localhost

Dropping mysql database rt2.

Creating mysql database rt2.

Creating database schema.
CREATE TABLE Groups (
  id INTEGER NOT NULL  AUTO_INCREMENT,
  Name varchar(16) NULL  ,
  Description varchar(64) NULL  ,
  Pseudo integer NULL  ,
  PRIMARY KEY (id),
  UNIQUE (Name)
)
DBD::mysql::st execute failed: Column 'Name' is used with UNIQUE or INDEX
but is not defined as NOT NULL at tools/initdb line 67, <STDIN> chunk 2.
Column 'Name' is used with UNIQUE or INDEX but is not defined as NOT NULL at
tools/initdb line 67, <STDIN> chunk 2.
Issuing rollback() for database handle being DESTROY'd without explicit
disconnect(), <STDIN> chunk 2.
make: *** [database] Error 255

any more help ?

-----Original Message-----
From: Jesse [mailto:jesse at fsck.com]
Sent: 02 January 2001 18:01
To: eOk
Cc: rt-users at lists.fsck.com; rt-devel at lists.fsck.com
Subject: Re: [rt-users] Installing 1.3.29


[followups to rt-devel, where the 1.3 series is best talked about]

What version of Mysql and DBD::Mysql are you running?
Have your run bin/testdeps -fix lately?

        -j

On Tue, Jan 02, 2001 at 05:17:08PM -0000, eOk wrote:
> When trying out new rt
>
> the following error occur
>
> Creating mysql database rt2.
> DBI->connect(dbname=;host=localhost) failed: No Database Selected at
> /usr/lib/perl5/site_perl/5.005/DBIx/DataSource/Driver.pm line 74
> No Database Selected at
> /usr/lib/perl5/site_perl/5.005/DBIx/DataSource/Driver.pm line 74, <STDIN>
> chunk 2.
>
> it doesnt seem to be passing a dbname variable ?
>
> any clues ?
>
> Eok
>
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
>

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

"If IBM _wanted_ to make clones, we could make them cheaper and faster than
anyone else!"  - An IBM Rep. visiting Vassar College's Comp Sci Department.