'make initialize-database' giving error while installation

RT Users
1

Hi all,

I am trying to configure RT in my system but it fails when I run the
"make initialize-database’ command.

I did the following steps:

[root@example rt-3.4.1]#./configure -prefix=/usr/local/rt_dev/rt
–with-fastcgi -with-oracle

And then ran the following commands:

perl sbin/rt-test-dependencies --with-oracle --with-fastcgi --verbose

perl sbin/rt-test-dependencies --with-oracle --with-fastcgi --install

perl sbin/rt-test-dependencies --with-oracle --with-fastcgi --verbose |
grep MISSING

perl -MCPAN -e ‘install MIME::Base64’

perl -MCPAN -e ‘install MIME::Entity’

perl -MCPAN -e ‘install Log::Dispatch’

perl sbin/rt-test-dependencies --with-oracle --with-fastcgi --install

perl sbin/rt-test-dependencies --with-oracle --with-fastcgi --verbose |
grep MISSING

make install

This installs RT in the directory specified but when I run the make
initialize-database command it gives an error:

root@example rt-3.4.1]#make initialize-database

[root@example rt-3.4.1]# Please specify that user’s database password
below. If the user has no database

password, just press return.

Password:

DSN component ‘example’ is not in ‘name=value’ format at
/usr/local/lib/perl5/site_perl/5.8.6/i686-linux/DBI.pm line 598

DBI connect(‘example;port=1522’,‘root’,…) failed: Can’t connect
using this syntax without specifying a HOST and a SID at
//usr/local/rt_dev/rt/sbin/rt-setup-database line 101

-bash: Please: command not found

-bash: connect: command not found

[root@webtlh01 rt-3.4.1]# Failed to connect to
dbi:Oracle:example;port=1522 as root: Can’t connect using this syntax
without specifying a HOST and a SID at
//usr/local/rt_dev/rt/sbin/rt-setup-database line 101, line 1.

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

I did make changes to the RT_SiteConfig.pm to give the database type,
user,password, database, port( I am giving 1522 since 1521 is in use).
Could someone tell me what I am doing wrong.

Ahalya Nathan
Senior Programmer / Analyst
Information Technology, Metropolitan Utilities District
(402) 449-8218 phone
(402) 449-8131 fax

2

When I tried to get a way around my problem by giving different
parameters in the configure script, I get the error.

[root@example rt-3.4.1]# ./configure --prefix=/usr/local/rt_dev/rt
–with-db-type=Oracle --with-db-dba=** \

–with-db-database=example --with-db-rt-user=** --with-db-rt-pass=**
–with-fastcgi --with-oracle

checking for a BSD-compatible install… /usr/bin/install -c

checking for perl… /usr/local/bin/perl

checking for chosen layout… RT3

configure: error: Please declare the ORACLE_HOME environment variable

[root@example rt-3.4.1]# Please declare the ORACLE_HOME environment
variable

Could someone tell me what I am doing wrong. Thanks in advance.

Regards,

AhalyaFrom: Nathan, Ahalya
Sent: Monday, August 29, 2005 9:18 AM
To: ‘rt-users@lists.bestpractical.com’
Subject: ‘make initialize-database’ giving error while installation

Hi all,

I am trying to configure RT in my system but it fails when I run the
"make initialize-database’ command.

I did the following steps:

[root@example rt-3.4.1]#./configure -prefix=/usr/local/rt_dev/rt
–with-fastcgi -with-oracle

And then ran the following commands:

perl sbin/rt-test-dependencies --with-oracle --with-fastcgi --verbose

perl sbin/rt-test-dependencies --with-oracle --with-fastcgi --install

perl sbin/rt-test-dependencies --with-oracle --with-fastcgi --verbose |
grep MISSING

perl -MCPAN -e ‘install MIME::Base64’

perl -MCPAN -e ‘install MIME::Entity’

perl -MCPAN -e ‘install Log::Dispatch’

perl sbin/rt-test-dependencies --with-oracle --with-fastcgi --install

perl sbin/rt-test-dependencies --with-oracle --with-fastcgi --verbose |
grep MISSING

make install

This installs RT in the directory specified but when I run the make
initialize-database command it gives an error:

root@example rt-3.4.1]#make initialize-database

[root@example rt-3.4.1]# Please specify that user’s database password
below. If the user has no database

password, just press return.

Password:

DSN component ‘example’ is not in ‘name=value’ format at
/usr/local/lib/perl5/site_perl/5.8.6/i686-linux/DBI.pm line 598

DBI connect(‘example;port=1522’,‘root’,…) failed: Can’t connect
using this syntax without specifying a HOST and a SID at
//usr/local/rt_dev/rt/sbin/rt-setup-database line 101

-bash: Please: command not found

-bash: connect: command not found

[root@webtlh01 rt-3.4.1]# Failed to connect to
dbi:Oracle:example;port=1522 as root: Can’t connect using this syntax
without specifying a HOST and a SID at
//usr/local/rt_dev/rt/sbin/rt-setup-database line 101, line 1.

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

I did make changes to the RT_SiteConfig.pm to give the database type,
user,password, database, port( I am giving 1522 since 1521 is in use).
Could someone tell me what I am doing wrong.

Ahalya Nathan
Senior Programmer / Analyst
Information Technology, Metropolitan Utilities District
(402) 449-8218 phone
(402) 449-8131 fax

3

You need to declare the ORACLE_HOME environment variable. If you
become the oracle user you can look at its environment using
set/setenv to show you what you have setup for this.

–falzOn 8/29/05, Nathan, Ahalya Ahalya_Nathan@mudnebr.com wrote:

When I tried to get a way around my problem by giving different parameters
in the configure script, I get the error.

[root@example rt-3.4.1]# ./configure --prefix=/usr/local/rt_dev/rt
–with-db-type=Oracle --with-db-dba=** \

–with-db-database=example --with-db-rt-user=** --with-db-rt-pass=**
–with-fastcgi --with-oracle

checking for a BSD-compatible install… /usr/bin/install -c

checking for perl… /usr/local/bin/perl

checking for chosen layout… RT3

configure: error: Please declare the ORACLE_HOME environment variable

[root@example rt-3.4.1]# Please declare the ORACLE_HOME environment variable

Could someone tell me what I am doing wrong. Thanks in advance.

Regards,

Ahalya

From: Nathan, Ahalya
Sent: Monday, August 29, 2005 9:18 AM
To: ‘rt-users@lists.bestpractical.com’
Subject: ‘make initialize-database’ giving error while installation

Hi all,

I am trying to configure RT in my system but it fails when I run the "make
initialize-database’ command.

I did the following steps:

[root@example rt-3.4.1]#./configure –prefix=/usr/local/rt_dev/rt
–with-fastcgi –with-oracle

And then ran the following commands:

perl sbin/rt-test-dependencies --with-oracle --with-fastcgi --verbose

perl sbin/rt-test-dependencies --with-oracle --with-fastcgi --install

perl sbin/rt-test-dependencies --with-oracle --with-fastcgi --verbose | grep
MISSING

perl -MCPAN -e ‘install MIME::Base64’

perl -MCPAN -e ‘install MIME::Entity’

perl -MCPAN -e ‘install Log::Dispatch’

perl sbin/rt-test-dependencies --with-oracle --with-fastcgi --install

perl sbin/rt-test-dependencies --with-oracle --with-fastcgi --verbose | grep
MISSING

make install

This installs RT in the directory specified but when I run the make
initialize-database command it gives an error:

root@example rt-3.4.1]#make initialize-database

[root@example rt-3.4.1]# Please specify that user’s database password below.
If the user has no database

password, just press return.

Password:

DSN component ‘example’ is not in ‘name=value’ format at
/usr/local/lib/perl5/site_perl/5.8.6/i686-linux/DBI.pm line
598

DBI connect(‘example;port=1522’,‘root’,…) failed: Can’t
connect using this syntax without specifying a HOST and a SID at
//usr/local/rt_dev/rt/sbin/rt-setup-database line 101

-bash: Please: command not found

-bash: connect: command not found

[root@webtlh01 rt-3.4.1]# Failed to connect to dbi:Oracle:example;port=1522
as root: Can’t connect using this syntax without specifying a HOST and a SID
at //usr/local/rt_dev/rt/sbin/rt-setup-database line 101,
line 1.

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

I did make changes to the RT_SiteConfig.pm to give the database type,
user,password, database, port( I am giving 1522 since 1521 is in use). Could
someone tell me what I am doing wrong.

Ahalya Nathan
Senior Programmer / Analyst
Information Technology, Metropolitan Utilities District
(402) 449-8218 phone
(402) 449-8131 fax

The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from
http://rtbook.bestpractical.com