[rt-devel] Mysql DBI error on make install

[Shaun Hedges]

Sorry again,

That error comes after this error:

This error is reported on make install:
/usr/bin/perl /opt/webrt2/etc/insertdata
RT::Handle=HASH(0x85bb414) no row id returned on row creation at
/usr/lib/perl5/site_perl/5.005/DBIx/SearchBuilder/Handle/mysql.pm line 34.
Creating system user...Could not create user

and the previous error was reported when running insertdata

Sorry for all the questions, anymore ideas?



-----Original Message-----
From: rt-devel-admin at lists.fsck.com
[mailto:rt-devel-admin at lists.fsck.com]On Behalf Of Alex Krohn
Sent: Wednesday, May 16, 2001 10:49 AM
To: Shaun Hedges
Cc: rt-devel at lists.fsck.com
Subject: Re: [rt-devel] Mysql DBI error on make install


Hi,

> YvrS-DAT02-LI:/opt/src/webrt/rt2 # /usr/bin/perl
/opt/webrt2/etc/insertdata
> DBD::mysql::st execute failed: Duplicate entry 'RT_System' for key 2 at
> /usr/lib/perl5/site_perl/5.005/DBIx/SearchBuilder/Handle.pm line 297.
> RT::Handle=HASH(0x85bb540) couldn't execute the query 'INSERT INTO Users
> (Created, Creator, Name, LastUpdated, Privileged, RealName, LastUpdatedBy,
> Comments) VALUES (?, ?, ?, ?, ?, ?, ?, ?)'Duplicate entry 'RT_System' for
> key 2
> Creating system user...Could not create user
>
> I see this error now on make install and when running the insertdata
script
> arbitrarily.  Any ideas?

Jesse, these were the sort of errors I got. If anything goes wrong
during the install, you are forced to manually remove the user, and/or
drop and recreate the database. Putting prompts in whether this should
be done would be very useful.

Shaun, basically RT has already added the rt user to mysql, and now when
trying to reinstall it's dying. You can delete it manually from the
mysql.User table and you should be fine.

Cheers,

Alex

--------------------  Gossamer Threads Inc.  ----------------------
Alex Krohn                        Email: alex at gossamer-threads.com
Internet Consultant               Phone: (604) 687-5804
http://www.gossamer-threads.com   Fax  : (604) 687-5806


_______________________________________________
Rt-devel mailing list
Rt-devel at lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel