RedHat Datasource.pm Installation Problem

All,

I’m installing RT for the first time and am having a problem with the
initial installation. I’ve tried the installation with both mysql and
Pg but get the same error in Datasource.pm.

I’m running Redhat 7 and I’ve installed Apache mod_perl. I’ve installed
all of the mysql modules, etc. and ‘make testdeps’ runs cleanly. When
I try to reinstall the Datasource modules it tells me that everything is
up-to-date. How do I get past this??

make install produces the following output:

[root@netsaint rttmp]# make install
mkdir -p //usr/rt/bin
mkdir -p //usr/rt/WebRT/data
mkdir -p //usr/rt/WebRT/sessiondata
mkdir -p //usr/rt/etc
mkdir -p //usr/rt/lib
mkdir -p //usr/rt/WebRT/html
mkdir -p //usr/rt/local/WebRT/html
/usr/bin/perl tools/initdb 'mysql ’ ‘/usr/bin’ ‘localhost’ ‘’
‘root’ ‘rt2’ create
Now creating a database for RT.
Enter the mysql password for root:
Creating mysql database rt2.
can’t parse data source: dbi:mysql : at
/usr/lib/perl5/site_perl/5.6.0/DBIx/DataSource.pm line 70, line
1.
make: *** [createdb] Error 255
[root@netsaint rttmp]#

Here’s the configurable portion of the Makefile that I’m using:

[root@netsaint rttmp]# cat Makefile

$Header: /raid/cvsroot/rt/Makefile,v 1.90.2.262.4.2 2001/10/31

22:38:40 jesse Exp $

Request Tracker is Copyright 1996-2001 Jesse Vincent

<jessebestpractical.com>

RT is distributed under the terms of the GNU General Public License,

version 2

PERL = /usr/bin/perl

RT_VERSION_MAJOR = 2
RT_VERSION_MINOR = 0
RT_VERSION_PATCH = 8_02

RT_VERSION =
$(RT_VERSION_MAJOR).$(RT_VERSION_MINOR).$(RT_VERSION_PATCH)
TAG =
rt-$(RT_VERSION_MAJOR)-$(RT_VERSION_MINOR)-$(RT_VERSION_PATCH)

RTGROUP = rt

User which should own rt binaries

BIN_OWNER = rt

User that should own all of RT’s libraries. generally root.

LIBS_OWNER = root

Group that should own all of RT’s libraries. generally root.

LIBS_GROUP = root

{{{ Files and directories

DESTDIR allows you to specify that RT be installed somewhere other

than

where it will eventually reside

DESTDIR = /usr/rttmp

RT_PATH is the name of the directory you want make to install RT in

RT must be installed in its own directory (don’t set this to

/usr/local)

RT_PATH = /usr/rt

The rest of these paths are all configurable, but you probably don’t

want to

put them elsewhere

RT_LIB_PATH = $(RT_PATH)/lib
RT_ETC_PATH = $(RT_PATH)/etc
RT_BIN_PATH = $(RT_PATH)/bin
RT_MAN_PATH = $(RT_PATH)/man
MASON_HTML_PATH = $(RT_PATH)/WebRT/html

RT allows sites to overlay the default web ui with

local customizations Those files can be placed in

MASON_LOCAL_HTML_PATH

MASON_LOCAL_HTML_PATH = $(RT_PATH)/local/WebRT/html

RT needs to be able to write to MASON_DATA_PATH and MASON_SESSION_PATH

RT will create and chown these directories. Don’t just set them to

/tmp
MASON_DATA_PATH = $(RT_PATH)/WebRT/data
MASON_SESSION_PATH = $(RT_PATH)/WebRT/sessiondata

RT_LOG_PATH = $(RT_PATH)/tmp

RT_READABLE_DIR_MODE is the mode of directories that are generally

meant to be

accessable

RT_READABLE_DIR_MODE = 0755

The location of your rt configuration file

RT_CONFIG = $(RT_ETC_PATH)/config.pm

RT_MODPERL_HANDLER is the mason handler script for mod_perl

RT_MODPERL_HANDLER = $(RT_BIN_PATH)/webmux.pl

RT_FASTCGI_HANDLER is the mason handler script for FastCGI

THIS HANDLER IS NOT CURRENTLY SUPPORTED

RT_FASTCGI_HANDLER =
$(RT_BIN_PATH)/mason_handler.fcgi

RT_SPEEDYCGI_HANDLER is the mason handler script for SpeedyCGI

THIS HANDLER IS NOT CURRENTLY SUPPORTED

RT_SPEEDYCGI_HANDLER =
$(RT_BIN_PATH)/mason_handler.scgi

The following are the names of the various binaries which make up RT

RT_CLI_BIN = $(RT_BIN_PATH)/rt
RT_CLI_ADMIN_BIN = $(RT_BIN_PATH)/rtadmin
RT_MAILGATE_BIN = $(RT_BIN_PATH)/rt-mailgate

}}}

{{{ Database setup

DB_TYPE defines what sort of database RT trys to talk to

“mysql” is known to work.

“Pg” is known to work

“Oracle” is in the early stages of working.

DB_TYPE = mysql

DB_HOME is where the Database’s commandline tools live

Note: $DB_HOME/bin is where the database binary tools are installed.

DB_HOME = /usr/bin

Set DBA to the name of a unix account with the proper permissions and

environment to run your commandline SQL tools

Set DB_DBA to the name of a DB user with permission to create new

databases

Set DB_DBA_PASSWORD to that user’s password (if you don’t, you’ll be

prompted

later)

For mysql, you probably want ‘root’

For Pg, you probably want ‘postgres’

For oracle, you want ‘system’

DB_DBA = root
DB_DBA_PASSWORD = password

Set this to the Fully Qualified Domain Name of your database server.

If the database is local, rather than on a remote host, using

“localhost”

will greatly enhance performance.

DB_HOST = localhost

If you’re not running your database server on its default port,

specifiy the port the database server is running on below.

It’s generally safe to leave this blank

DB_PORT =

Set this to the canonical name of the interface RT will be talking to

the

database on. # If you said that the RT_DB_HOST above was “localhost,”

this

should be too. This value will be used to grant rt access to the

database.

If you want to access the RT database from multiple hosts, you’ll need

to grant those database rights by hand.

DB_RT_HOST = localhost

set this to the name you want to give to the RT database in

your database server. For Oracle, this should be the name of your sid

DB_DATABASE = rt2

Set this to the name of the rt database user

DB_RT_USER = rt

Set this to the password used by the rt database user

*** Change This Before Installation***

DB_RT_PASS = password

}}}

{{{ Web configuration

The user your webserver runs as. needed so that webrt can cache mason

objectcode

WEB_USER = apache
WEB_GROUP = nobody

}}}

I’m betting you’ve got an extraneous tab after the ‘mysql’ in the makefile.

-jOn Thu, Dec 06, 2001 at 02:48:18PM -0500, Fred Reimers wrote:

All,

I’m installing RT for the first time and am having a problem with the
initial installation. I’ve tried the installation with both mysql and
Pg but get the same error in Datasource.pm.

I’m running Redhat 7 and I’ve installed Apache mod_perl. I’ve installed
all of the mysql modules, etc. and ‘make testdeps’ runs cleanly. When
I try to reinstall the Datasource modules it tells me that everything is
up-to-date. How do I get past this??

make install produces the following output:

[root@netsaint rttmp]# make install
mkdir -p //usr/rt/bin
mkdir -p //usr/rt/WebRT/data
mkdir -p //usr/rt/WebRT/sessiondata
mkdir -p //usr/rt/etc
mkdir -p //usr/rt/lib
mkdir -p //usr/rt/WebRT/html
mkdir -p //usr/rt/local/WebRT/html
/usr/bin/perl tools/initdb 'mysql ’ ‘/usr/bin’ ‘localhost’ ‘’
‘root’ ‘rt2’ create
Now creating a database for RT.
Enter the mysql password for root:
Creating mysql database rt2.
can’t parse data source: dbi:mysql : at
/usr/lib/perl5/site_perl/5.6.0/DBIx/DataSource.pm line 70, line
1.
make: *** [createdb] Error 255
[root@netsaint rttmp]#

Here’s the configurable portion of the Makefile that I’m using:

[root@netsaint rttmp]# cat Makefile

$Header: /raid/cvsroot/rt/Makefile,v 1.90.2.262.4.2 2001/10/31

22:38:40 jesse Exp $

Request Tracker is Copyright 1996-2001 Jesse Vincent

<jessebestpractical.com>

RT is distributed under the terms of the GNU General Public License,

version 2

PERL = /usr/bin/perl

RT_VERSION_MAJOR = 2
RT_VERSION_MINOR = 0
RT_VERSION_PATCH = 8_02

RT_VERSION =
$(RT_VERSION_MAJOR).$(RT_VERSION_MINOR).$(RT_VERSION_PATCH)
TAG =
rt-$(RT_VERSION_MAJOR)-$(RT_VERSION_MINOR)-$(RT_VERSION_PATCH)

RTGROUP = rt

User which should own rt binaries

BIN_OWNER = rt

User that should own all of RT’s libraries. generally root.

LIBS_OWNER = root

Group that should own all of RT’s libraries. generally root.

LIBS_GROUP = root

{{{ Files and directories

DESTDIR allows you to specify that RT be installed somewhere other

than

where it will eventually reside

DESTDIR = /usr/rttmp

RT_PATH is the name of the directory you want make to install RT in

RT must be installed in its own directory (don’t set this to

/usr/local)

RT_PATH = /usr/rt

The rest of these paths are all configurable, but you probably don’t

want to

put them elsewhere

RT_LIB_PATH = $(RT_PATH)/lib
RT_ETC_PATH = $(RT_PATH)/etc
RT_BIN_PATH = $(RT_PATH)/bin
RT_MAN_PATH = $(RT_PATH)/man
MASON_HTML_PATH = $(RT_PATH)/WebRT/html

RT allows sites to overlay the default web ui with

local customizations Those files can be placed in

MASON_LOCAL_HTML_PATH

MASON_LOCAL_HTML_PATH = $(RT_PATH)/local/WebRT/html

RT needs to be able to write to MASON_DATA_PATH and MASON_SESSION_PATH

RT will create and chown these directories. Don’t just set them to

/tmp
MASON_DATA_PATH = $(RT_PATH)/WebRT/data
MASON_SESSION_PATH = $(RT_PATH)/WebRT/sessiondata

RT_LOG_PATH = $(RT_PATH)/tmp

RT_READABLE_DIR_MODE is the mode of directories that are generally

meant to be

accessable

RT_READABLE_DIR_MODE = 0755

The location of your rt configuration file

RT_CONFIG = $(RT_ETC_PATH)/config.pm

RT_MODPERL_HANDLER is the mason handler script for mod_perl

RT_MODPERL_HANDLER = $(RT_BIN_PATH)/webmux.pl

RT_FASTCGI_HANDLER is the mason handler script for FastCGI

THIS HANDLER IS NOT CURRENTLY SUPPORTED

RT_FASTCGI_HANDLER =
$(RT_BIN_PATH)/mason_handler.fcgi

RT_SPEEDYCGI_HANDLER is the mason handler script for SpeedyCGI

THIS HANDLER IS NOT CURRENTLY SUPPORTED

RT_SPEEDYCGI_HANDLER =
$(RT_BIN_PATH)/mason_handler.scgi

The following are the names of the various binaries which make up RT

RT_CLI_BIN = $(RT_BIN_PATH)/rt
RT_CLI_ADMIN_BIN = $(RT_BIN_PATH)/rtadmin
RT_MAILGATE_BIN = $(RT_BIN_PATH)/rt-mailgate

}}}

{{{ Database setup

DB_TYPE defines what sort of database RT trys to talk to

“mysql” is known to work.

“Pg” is known to work

“Oracle” is in the early stages of working.

DB_TYPE = mysql

DB_HOME is where the Database’s commandline tools live

Note: $DB_HOME/bin is where the database binary tools are installed.

DB_HOME = /usr/bin

Set DBA to the name of a unix account with the proper permissions and

environment to run your commandline SQL tools

Set DB_DBA to the name of a DB user with permission to create new

databases

Set DB_DBA_PASSWORD to that user’s password (if you don’t, you’ll be

prompted

later)

For mysql, you probably want ‘root’

For Pg, you probably want ‘postgres’

For oracle, you want ‘system’

DB_DBA = root
DB_DBA_PASSWORD = password

Set this to the Fully Qualified Domain Name of your database server.

If the database is local, rather than on a remote host, using

“localhost”

will greatly enhance performance.

DB_HOST = localhost

If you’re not running your database server on its default port,

specifiy the port the database server is running on below.

It’s generally safe to leave this blank

DB_PORT =

Set this to the canonical name of the interface RT will be talking to

the

database on. # If you said that the RT_DB_HOST above was “localhost,”

this

should be too. This value will be used to grant rt access to the

database.

If you want to access the RT database from multiple hosts, you’ll need

to grant those database rights by hand.

DB_RT_HOST = localhost

set this to the name you want to give to the RT database in

your database server. For Oracle, this should be the name of your sid

DB_DATABASE = rt2

Set this to the name of the rt database user

DB_RT_USER = rt

Set this to the password used by the rt database user

*** Change This Before Installation***

DB_RT_PASS = password

}}}

{{{ Web configuration

The user your webserver runs as. needed so that webrt can cache mason

objectcode

WEB_USER = apache
WEB_GROUP = nobody

}}}


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

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