Initialize-database error

Hello,

I am running trying to install rt-3-0-1 on a redhat 7.3 box. When I run
make initialize-database I get this output:

/usr/bin/perl //usr/local/rt3/sbin/rt-setup-database --action init --dba
root --prompt-for-dba-password
In order to create a new database and grant RT access to that database,
this script needs to connect to your mysql instance on localhost as
root.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password: Now creating a database for RT.
Creating mysql database rt3.
Now populating database schema.
Creating database schema.
schema sucessfully inserted
Now inserting database ACLs
Now inserting RT core system objects
Checking for existing system user…not found. This appears to be a new
installation.
Creating system user…Can’t locate object method “begin_work” via
package “DBI::db” (perhaps you forgot to load “DBI::db”?) at
/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 497,
line 416.
make: *** [initialize-database] Error 255

Has anybody seen this before, or know what is wrong? Any info would be
appreciated. Thanks.

  • Benjamin

Benjamin Herbert wrote:

Creating system user…Can’t locate object method “begin_work” via
package “DBI::db” (perhaps you forgot to load “DBI::db”?) at
/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 497,
line 416.

http://lists.fsck.com/pipermail/rt-users/2003-April/013000.html

�|� Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

This is the error I get when I try to install RT:

Now creating a database for RT.
Creating mysql database rt3.
Now populating database schema.
Creating database schema.
Problem with statement:

CREATE UNIQUE INDEX Links1 ON Links (Base, Target, Type)
Specified key was too long. Max key length is 1024 at
/usr/local/rt3/sbin/rt-setup-database line 163.

make: *** [initialize-database] Error 255

RT host is Redhat 9.0
MySQL host is a remote Redhat 9.0 running MySQL 4.1.1-alpha*

*Any suggestions? A co-worker tells me its probably a UTF8 issue?

RT host is Redhat 9.0
MySQL host is a remote Redhat 9.0 running MySQL 4.1.1-alpha*

*Any suggestions? A co-worker tells me its probably a UTF8 issue?

I’d strongly suggest trying some version of mysql that’s not a six month
old alpha release.

In setting up brand new RT3 instance Im getting the following error in
localhost email after a mail goes through rt-mailgate:

"RT could not load a valid user, and RT’s configuration does not allow
for the creation of a new user for this email (root@mydomain.cisco.com).

You might need to grant ‘Everyone’ the right ‘CreateTicket’ for the
queue testqueue."

I have browsed through allthe queue and user menus and don’t see an
“Everyone” user to give this right to?

-Charles

You might need to grant ‘Everyone’ the right ‘CreateTicket’ for the
queue testqueue."

I have browsed through allthe queue and user menus and don’t see an
“Everyone” user to give this right to?

It’s a group.

I have got perl 5.8.3 working but still can not initialize the database

/usr/local/bin/perl //opt/rt3/sbin/rt-setup-database -action init -dba root
-prompt-for-dba-password

Can’t locate Locale/maketext/lexicon.pm in @INC <@INC contains: /opt/rt3/lib
/usr/local/lib/perl5/5.8.3/i686-linux /usr/local/lib/perl5/5.8.3

At /opt/rt3/lib/RT/I18n.pm line 34.

BEGIN failed-compilation aborted at /opt/rt3/lib/RT/I18n.pm line 34.

Compilation failed in require at /opt/rt3/lib/RT.pm line 29

BEGIN failed

Compilation failed in require at //opt/rt3/sbin/rt-setup-database line 36

Make:*** [initialize-database] Error 2

Thanks in advance for any help, I am ready to pay the $2,000.00 to Best
Practical and get this thing setup.

Scott Morehead

Network Administrator

Pliant Corp

W - 757-820-0163

F - 757-888-6032

Did you run ‘rt-test-dependencies’ script?

Scott Morehead wrote:

Hello,

I am running the make initialize-database script on a FreeBSD 5.3 box with Apache
2.0.54 Mysql-4.1.11 I get this error when I run it.

scout# make initialize-database
/usr/bin/perl //usr/local/rt-3.4.2/sbin/rt-setup-database --action init --dba root --prompt-
for-dba-password
Can’t open perl script “//usr/local/rt-3.4.2/sbin/rt-setup-database”: No such file or
directory
*** Error code 2

I can browse to that script that it says doesn’t exist.

Thanks

Jerad Hampton
Network Administrator
The King’s University College

Hello,

scout# make initialize-database
/usr/bin/perl //usr/local/rt-3.4.2/sbin/rt-setup-database --action init --dba root --prompt-
for-dba-password
Can’t open perl script “//usr/local/rt-3.4.2/sbin/rt-setup-database”: No such file or
directory
*** Error code 2

I can browse to that script that it says doesn’t exist.

Check the first line of that script and see what it’s executing:

#!/usr/bin/perl -w

make sure that exists.

Graham