RT 3.0.1 to 3.latest user and mysql db import possible?

Folks,

I have been very happily running RT 3.0.1 on a Redhat 7.3 server for
several years. I plan to keep this machine in service as long as possible
but am starting to think about what to do when the hardware finally dies.

I’m planning on building a new Redhat ES 4.0 server and building the latest
RT code onto it. My question is:

I would very much like to be able to import/migrate all of the current RT
user account info and trouble ticket databases from my existing system to
the new one.

Is this even possible? What advice would you have?

TIA!

I have been very happily running RT 3.0.1 on a Redhat 7.3 server for
several years. I plan to keep this machine in service as long as possible
but am starting to think about what to do when the hardware finally dies.

I’m planning on building a new Redhat ES 4.0 server and building the latest
RT code onto it. My question is:

I would very much like to be able to import/migrate all of the current RT
user account info and trouble ticket databases from my existing system to
the new one.

You should be able to ‘mysqldump --opt rt3 >rt301.sql’ on the old
system, copy the file over and 'mysqladmin create rt3; mysql <rt301.sql’
on the new one to get the database copy, then follow the instructions
in the current rt README about upgrading the database from earlier
versions.

Les Mikesell
les@futuresource.com

I have RT 3.4.4 on RHEL4 about 98% built. I can’t tell if I have a
SearchBuilder not installed problem or a /opt/rt3/etc/RT_SiteConfig.pm
error. If I do a make install, I get a success message (shown below). I
apologize for the length of this e-mail but I wanted to have as much debug
output available as possible so as to keep the number of needed replies
down. Thanks very much in advance! Follows are relevant outputs

/opt/rt3/etc/RT_SiteConfig.pm:
Line 71 = Set($DatabaseType , ‘mysql’);

#The name of the database user (inside the database)
Set($DatabaseUser , ‘rt_user’);

Password the DatabaseUser should use to access the database

Set($DatabasePassword , ‘rt_pass’);

(The above has never been set up…)

[root@frankie rt-3.4.4]# ps -ef |grep sql
root 14968 1 0 15:06 ? 00:00:00 /bin/sh
/usr/bin/safe_mysqld --d
efaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid
mysql 14997 14968 0 15:06 ? 00:00:00 /usr/libexec/mysqld
–defaults-f
ile=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql --user=mysql
–pid-file=
/var/run/mysqld/mysqld.pid --skip-locking
root 29684 29232 0 17:59 pts/1 00:00:00 grep sql
[root@frankie rt-3.4.4]#

[root@frankie rt-3.4.4]# perl sbin/rt-test-dependencies --with-mysql
–with-fastcgi --verbose | grep MISSING
DBIx::SearchBuilder 1.26…MISSING
SOMETHING WAS MISSING!
[root@frankie rt-3.4.4]#

[root@frankie rt-3.4.4]# perl -MCPAN -e ‘install DBIx::SearchBuilder’


t/00.load…ok
1/12 skipped: DBD::Oracle is not installed


Failed Test Stat Wstat Total Fail Failed List of Failed
t/01basics.t 255 65280 ?? ?? % ??
t/01records.t 255 65280 ?? ?? % ??
t/01searches.t 255 65280 ?? ?? % ??
t/02records_object.t 255 65280 ?? ?? % ??
t/03rebless.t 255 65280 ?? ?? % ??
t/11schema_records.t 255 65280 ?? ?? % ??
1 subtest skipped.
Failed 6/10 test scripts, 40.00% okay. 0/32 subtests failed, 100.00% okay.
make: *** [test_dynamic] Error 255
/usr/bin/make test – NOT OK
Running make install
make test had returned bad status, won’t install without force
[root@frankie rt-3.4.4]#

No other errors…

[root@frankie rt-3.4.4]#make install


Congratulations. RT has been installed.

You must now configure RT by editing /opt/rt3/etc/RT_SiteConfig.pm.

(You will definitely need to set RT’s database password in
/opt/rt3/etc/RT_SiteConfig.pm before continuing. Not doing so could be
very dangerous. Note that you do not have to manually add a
database user or set up a database for RT. These actions will be
taken care of in the next step.)

After that, you need to initialize RT’s database by running
’make initialize-database’
[root@frankie rt-3.4.4]#make initialize-database


BEGIN failed–compilation aborted at /opt/rt3/lib/RT/SearchBuilder.pm line 71.
Compilation failed in require at /opt/rt3/lib/RT/Principals.pm line 72.
BEGIN failed–compilation aborted at /opt/rt3/lib/RT/Principals.pm line 72.
Compilation failed in require at /opt/rt3/lib/RT/User_Overlay.pm line 80.
BEGIN failed–compilation aborted at /opt/rt3/lib/RT/User_Overlay.pm line 80.
Compilation failed in require at (eval 43) line 3.
Compilation failed in require at /opt/rt3/lib/RT/Record.pm line 69.
BEGIN failed–compilation aborted at /opt/rt3/lib/RT/Record.pm line 69.
Compilation failed in require at /opt/rt3/lib/RT/CurrentUser.pm line 73.
BEGIN failed–compilation aborted at /opt/rt3/lib/RT/CurrentUser.pm line 73.
Compilation failed in require at /opt/rt3/lib/RT.pm line 49.
BEGIN failed–compilation aborted at /opt/rt3/lib/RT.pm line 49.
Compilation failed in require at //opt/rt3/sbin/rt-setup-database line 57.
BEGIN failed–compilation aborted at //opt/rt3/sbin/rt-setup-database line 57.
make: *** [initialize-database] Error 2
[root@frankie rt-3.4.4]#

You can force DBIx::SearchBuilder and install it without tests, or
install DBD::SQLite and rerun with tests.On 9/1/05, Frank Saxton frankie@easyrider.com wrote:

I have RT 3.4.4 on RHEL4 about 98% built. I can’t tell if I have a
SearchBuilder not installed problem or a /opt/rt3/etc/RT_SiteConfig.pm
error. If I do a make install, I get a success message (shown below). I
apologize for the length of this e-mail but I wanted to have as much debug
output available as possible so as to keep the number of needed replies
down. Thanks very much in advance! Follows are relevant outputs

/opt/rt3/etc/RT_SiteConfig.pm:
Line 71 = Set($DatabaseType , ‘mysql’);

#The name of the database user (inside the database)
Set($DatabaseUser , ‘rt_user’);

Password the DatabaseUser should use to access the database

Set($DatabasePassword , ‘rt_pass’);

(The above has never been set up…)

[root@frankie rt-3.4.4]# ps -ef |grep sql
root 14968 1 0 15:06 ? 00:00:00 /bin/sh
/usr/bin/safe_mysqld --d
efaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid
mysql 14997 14968 0 15:06 ? 00:00:00 /usr/libexec/mysqld
–defaults-f
ile=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql --user=mysql
–pid-file=
/var/run/mysqld/mysqld.pid --skip-locking
root 29684 29232 0 17:59 pts/1 00:00:00 grep sql
[root@frankie rt-3.4.4]#

[root@frankie rt-3.4.4]# perl sbin/rt-test-dependencies --with-mysql
–with-fastcgi --verbose | grep MISSING
DBIx::SearchBuilder 1.26…MISSING
SOMETHING WAS MISSING!
[root@frankie rt-3.4.4]#

[root@frankie rt-3.4.4]# perl -MCPAN -e ‘install DBIx::SearchBuilder’


t/00.load…ok
1/12 skipped: DBD::Oracle is not installed


Failed Test Stat Wstat Total Fail Failed List of Failed

t/01basics.t 255 65280 ?? ?? % ??
t/01records.t 255 65280 ?? ?? % ??
t/01searches.t 255 65280 ?? ?? % ??
t/02records_object.t 255 65280 ?? ?? % ??
t/03rebless.t 255 65280 ?? ?? % ??
t/11schema_records.t 255 65280 ?? ?? % ??
1 subtest skipped.
Failed 6/10 test scripts, 40.00% okay. 0/32 subtests failed, 100.00% okay.
make: *** [test_dynamic] Error 255
/usr/bin/make test – NOT OK
Running make install
make test had returned bad status, won’t install without force
[root@frankie rt-3.4.4]#

No other errors…

[root@frankie rt-3.4.4]#make install


Congratulations. RT has been installed.

You must now configure RT by editing /opt/rt3/etc/RT_SiteConfig.pm.

(You will definitely need to set RT’s database password in
/opt/rt3/etc/RT_SiteConfig.pm before continuing. Not doing so could be
very dangerous. Note that you do not have to manually add a
database user or set up a database for RT. These actions will be
taken care of in the next step.)

After that, you need to initialize RT’s database by running
’make initialize-database’
[root@frankie rt-3.4.4]#make initialize-database


BEGIN failed–compilation aborted at /opt/rt3/lib/RT/SearchBuilder.pm line 71.
Compilation failed in require at /opt/rt3/lib/RT/Principals.pm line 72.
BEGIN failed–compilation aborted at /opt/rt3/lib/RT/Principals.pm line 72.
Compilation failed in require at /opt/rt3/lib/RT/User_Overlay.pm line 80.
BEGIN failed–compilation aborted at /opt/rt3/lib/RT/User_Overlay.pm line 80.
Compilation failed in require at (eval 43) line 3.
Compilation failed in require at /opt/rt3/lib/RT/Record.pm line 69.
BEGIN failed–compilation aborted at /opt/rt3/lib/RT/Record.pm line 69.
Compilation failed in require at /opt/rt3/lib/RT/CurrentUser.pm line 73.
BEGIN failed–compilation aborted at /opt/rt3/lib/RT/CurrentUser.pm line 73.
Compilation failed in require at /opt/rt3/lib/RT.pm line 49.
BEGIN failed–compilation aborted at /opt/rt3/lib/RT.pm line 49.
Compilation failed in require at //opt/rt3/sbin/rt-setup-database line 57.
BEGIN failed–compilation aborted at //opt/rt3/sbin/rt-setup-database line 57.
make: *** [initialize-database] Error 2
[root@frankie rt-3.4.4]#


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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

Best regards, Ruslan.

Thanks. How do I install without tests?

At 05:25 AM 9/1/2005 +0400, Ruslan Zakirov wrote:

Am I going to run into trouble here? I have this file (RT_SiteConfig.pm)
set pretty much to the defaults, per the example file, I set the
mysaqladmin password because that’s what the instructions said to do :frowning:

The README instructions for upgrading old databases seems to relate to
upgrading an existing RT install, not importing an old database to use in a
new install. /etc/upgrade on the new machine is empty…

I presume I should skip the make initialize-database step, yes?

README sez:

(You will definitely need to set RT’s database password in
/opt/rt3/etc/RT_SiteConfig.pm before continuing. Not doing so could be
very dangerous. Note that you do not have to manually add a
database user or set up a database for RT. These actions will be
taken care of in the next step.)

After that, you need to initialize RT’s database by running
’make initialize-database’
[root@frankie rt-3.4.4]#

Am I going to run into trouble here? I have this file (RT_SiteConfig.pm)
set pretty much to the defaults, per the example file, I set the
mysaqladmin password because that’s what the instructions said to do :frowning:

The README instructions for upgrading old databases seems to relate to
upgrading an existing RT install, not importing an old database to use in a
new install. /etc/upgrade on the new machine is empty…

You should treat the database like you were upgrading from the
old version (because you are…). Your rt’s etc/updgrade
directory should have subdirectories for at least:
3.1.0 3.1.15 3.1.17 3.3.0 3.3.11
and you need to do the steps in the README for the ones
that have schema changes.

I presume I should skip the make initialize-database step, yes?

Yes - do the upgrade steps instead.

README sez:

(You will definitely need to set RT’s database password in
/opt/rt3/etc/RT_SiteConfig.pm before continuing. Not doing so could be
very dangerous. Note that you do not have to manually add a
database user or set up a database for RT. These actions will be
taken care of in the next step.)

I think the rt user/password/permissions will come over with
the old database, but if not you can can fix it by
finding the GRANT statments in the initialize-database
script an running them by hand in mysql. You can do the
upgrade steps as root so it won’t matter until that is
done and you try to run RT.

Les Mikesell
les

Oh… it’s actually ./etc/upgrades… :slight_smile:

I get the same errors as another forum query I posted tonight:

Someone suggested installing SearchBuilder without doing the tests but
didn’t say how…

perl -MCPAN -eshell
force install DBIx::SearchBuilder

or you can:
look DBIx::SearchBuilder
and be dropped into a shell with the unpacked tarball where
you might:
perl Makefile.PL
make
make install
(skipping the ‘make test’) or do any tweaking needed to
make the install work. When you ‘exit’ from this shell
you’ll be back at the CPAN prompt.

Les Mikesell
les@futuresource.com

Oh… it’s actually ./etc/upgrades… :slight_smile:

I get the same errors as another forum query I posted tonight having to do
with DBIx::SearchBuilder 1.26…MISSING. Looks like it’s failing the
Oracle test, of all things…:

Someone suggested installing SearchBuilder without doing the tests but
didn’t say how…

BEGIN failed–compilation aborted at /opt/rt3/lib/RT/SearchBuilder.pm line 71.
Compilation failed in require at /opt/rt3/lib/RT/Principals.pm line 72.
BEGIN failed–compilation aborted at /opt/rt3/lib/RT/Principals.pm line 72.
Compilation failed in require at /opt/rt3/lib/RT/User_Overlay.pm line 80.
BEGIN failed–compilation aborted at /opt/rt3/lib/RT/User_Overlay.pm line 80.
Compilation failed in require at (eval 43) line 3.
Compilation failed in require at /opt/rt3/lib/RT/Record.pm line 69.
BEGIN failed–compilation aborted at /opt/rt3/lib/RT/Record.pm line 69.
Compilation failed in require at /opt/rt3/lib/RT/CurrentUser.pm line 73.
BEGIN failed–compilation aborted at /opt/rt3/lib/RT/CurrentUser.pm line 73.
Compilation failed in require at /opt/rt3/lib/RT.pm line 49.
BEGIN failed–compilation aborted at /opt/rt3/lib/RT.pm line 49.
Compilation failed in require at /opt/rt3/sbin/rt-setup-database line 57.
BEGIN failed–compilation aborted at /opt/rt3/sbin/rt-setup-database line 57.
[root@frankie rt-3.4.4]#

At 10:18 PM 8/31/2005 -0500, Les Mikesell wrote:>On Wed, 2005-08-31 at 22:02, Frank Saxton wrote:

Am I going to run into trouble here? I have this file (RT_SiteConfig.pm)
set pretty much to the defaults, per the example file, I set the
mysaqladmin password because that’s what the instructions said to do :frowning:

The README instructions for upgrading old databases seems to relate to
upgrading an existing RT install, not importing an old database to use
in a
new install. /etc/upgrade on the new machine is empty…

You should treat the database like you were upgrading from the
old version (because you are…). Your rt’s etc/updgrade
directory should have subdirectories for at least:
3.1.0 3.1.15 3.1.17 3.3.0 3.3.11
and you need to do the steps in the README for the ones
that have schema changes.

I presume I should skip the make initialize-database step, yes?

Yes - do the upgrade steps instead.

README sez:

(You will definitely need to set RT’s database password in
/opt/rt3/etc/RT_SiteConfig.pm before continuing. Not doing so could be
very dangerous. Note that you do not have to manually add a
database user or set up a database for RT. These actions will be
taken care of in the next step.)

I think the rt user/password/permissions will come over with
the old database, but if not you can can fix it by
finding the GRANT statments in the initialize-database
script an running them by hand in mysql. You can do the
upgrade steps as root so it won’t matter until that is
done and you try to run RT.


Les Mikesell
les

I get the same errors as another forum query I posted tonight having to do
with DBIx::SearchBuilder 1.26…MISSING. Looks like it’s failing the
Oracle test, of all things…:

It’s probably really failing because you followed the instructions
to add a root password to mysql and now it can’t connect to
any database for the tests.

Les Mikesell
les@futuresource.com

[root@frankie rt-3.4.4]# perl -MCPAN -eshell force install DBIx::SearchBuilder
Undefined value assigned to typeglob at (eval 16) line 15, line 11.
Warning [/etc/inputrc line 11]:
Invalid variable `mark-symlinked-directories’

cpan shell – CPAN exploration and modules installation (v1.7601)
ReadLine support enabled

cpan>

Also tried:

perl -MCPAN -e force ‘install DBIx::SearchBuilder’

and:

[root@frankie rt-3.4.4]# look DBIx::SearchBuilder
[root@frankie rt-3.4.4]# perl -MCPAN -eshell look DBIx::SearchBuilder
Undefined value assigned to typeglob at (eval 16) line 15, line 11.
Warning [/etc/inputrc line 11]:
Invalid variable `mark-symlinked-directories’

cpan shell – CPAN exploration and modules installation (v1.7601)
ReadLine support enabled

cpan>

At 10:49 PM 8/31/2005 -0500, Les Mikesell wrote:>On Wed, 2005-08-31 at 22:38, Cosmopolis Jones wrote:

Oh… it’s actually ./etc/upgrades… :slight_smile:

I get the same errors as another forum query I posted tonight:

Someone suggested installing SearchBuilder without doing the tests but
didn’t say how…

perl -MCPAN -eshell
force install DBIx::SearchBuilder

or you can:
look DBIx::SearchBuilder
and be dropped into a shell with the unpacked tarball where
you might:
perl Makefile.PL
make
make install
(skipping the ‘make test’) or do any tweaking needed to
make the install work. When you ‘exit’ from this shell
you’ll be back at the CPAN prompt.


Les Mikesell
les@futuresource.com

[root@frankie rt-3.4.4]# perl -MCPAN -eshell force install DBIx::SearchBuilder
Undefined value assigned to typeglob at (eval 16) line 15, line 11.
Warning [/etc/inputrc line 11]:
Invalid variable `mark-symlinked-directories’

cpan shell – CPAN exploration and modules installation (v1.7601)
ReadLine support enabled

cpan>

That’s
perl -MCPAN -eshell

cpan> force install DBIx::SearchBuilder

or
cpan> look DBIx::SearchBuilder
(and at the shell prompt do the steps you would do for
a tarball perl module install).

Les Mikesell
les@futuresource.com

Well… that was really swell being given an instruction that will cause
the installation to fail :frowning:

I think I’ve managed to null out the root password…

[root@frankie rt-3.4.4]# perl sbin/rt-test-dependencies --with-mysql
–with-fast
cgi --verbose | grep MISSING
DBIx::SearchBuilder 1.26…MISSING
SOMETHING WAS MISSING!
[root@frankie rt-3.4.4]#

root@frankie rt-3.4.4]# perl -MCPAN -e ‘install DBIx::SearchBuilder’|more
CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
Database was generated on Wed, 31 Aug 2005 09:58:57 GMT
Running install for module DBIx::SearchBuilder
Running make for J/JE/JESSE/DBIx-SearchBuilder-1.31.tar.gz
CPAN: Digest::MD5 loaded ok
CPAN: Compress::Zlib loaded ok
Checksum for
/root/.cpan/sources/authors/id/J/JE/JESSE/DBIx-SearchBuilder-1.31.t
ar.gz ok
Scanning cache /root/.cpan/build for sizes
DBIx-SearchBuilder-1.31/
DBIx-SearchBuilder-1.31/SearchBuilder/
DBIx-SearchBuilder-1.31/SearchBuilder/Handle.pm
DBIx-SearchBuilder-1.31/SearchBuilder/Handle/
DBIx-SearchBuilder-1.31/SearchBuilder/Handle/Sybase.pm
DBIx-SearchBuilder-1.31/SearchBuilder/Handle/mysqlPP.pm
DBIx-SearchBuilder-1.31/SearchBuilder/Handle/Oracle.pm
DBIx-SearchBuilder-1.31/SearchBuilder/Handle/mysql.pm
DBIx-SearchBuilder-1.31/SearchBuilder/Handle/Informix.pm
DBIx-SearchBuilder-1.31/SearchBuilder/Handle/SQLite.pm
DBIx-SearchBuilder-1.31/SearchBuilder/Handle/ODBC.pm
DBIx-SearchBuilder-1.31/SearchBuilder/Handle/Pg.pm
DBIx-SearchBuilder-1.31/SearchBuilder/Unique.pm
DBIx-SearchBuilder-1.31/SearchBuilder/Union.pm
DBIx-SearchBuilder-1.31/SearchBuilder/Record.pm
DBIx-SearchBuilder-1.31/SearchBuilder/SchemaGenerator.pm
DBIx-SearchBuilder-1.31/SearchBuilder/Record/
DBIx-SearchBuilder-1.31/SearchBuilder/Record/Cachable.pm
DBIx-SearchBuilder-1.31/SearchBuilder.pm
DBIx-SearchBuilder-1.31/inc/
DBIx-SearchBuilder-1.31/inc/Module/
DBIx-SearchBuilder-1.31/inc/Module/Install.pm
DBIx-SearchBuilder-1.31/inc/Module/Install/
DBIx-SearchBuilder-1.31/inc/Module/Install/AutoInstall.pm
DBIx-SearchBuilder-1.31/inc/Module/Install/Makefile.pm
DBIx-SearchBuilder-1.31/inc/Module/Install/Metadata.pm
DBIx-SearchBuilder-1.31/inc/Module/Install/Base.pm
DBIx-SearchBuilder-1.31/t/
DBIx-SearchBuilder-1.31/t/testmodels.pl
DBIx-SearchBuilder-1.31/t/01records.t
DBIx-SearchBuilder-1.31/t/11schema_records.t
DBIx-SearchBuilder-1.31/t/10schema.t
DBIx-SearchBuilder-1.31/t/02records_object.t
DBIx-SearchBuilder-1.31/t/00.load.t
-You said to run 0 tests! You’ve got to run something.

Looks like your test died before it could output anything.

You said to run 0 tests! You’ve got to run something.

Looks like your test died before it could output anything.

You said to run 0 tests! You’ve got to run something.

Looks like your test died before it could output anything.

You said to run 0 tests! You’ve got to run something.

Looks like your test died before it could output anything.

You said to run 0 tests! You’ve got to run something.

Looks like your test died before it could output anything.

You said to run 0 tests! You’ve got to run something.

Looks like your test died before it could output anything.

Failed 6/10 test scripts, 40.00% okay. 0/32 subtests failed, 100.00% okay.
make: *** [test_dynamic] Error 255
DBIx-SearchBuilder-1.31/t/pod.t
DBIx-SearchBuilder-1.31/t/01searches.t
DBIx-SearchBuilder-1.31/t/03rebless.t
DBIx-SearchBuilder-1.31/t/01basics.t
DBIx-SearchBuilder-1.31/t/utils.pl
DBIx-SearchBuilder-1.31/t/01nocap_api.t
DBIx-SearchBuilder-1.31/Changes
DBIx-SearchBuilder-1.31/MANIFEST
DBIx-SearchBuilder-1.31/ex/
DBIx-SearchBuilder-1.31/ex/Example/
DBIx-SearchBuilder-1.31/ex/Example/Model/
DBIx-SearchBuilder-1.31/ex/Example/Model/Employee.pm
DBIx-SearchBuilder-1.31/ex/Example/Model/Address.pm
DBIx-SearchBuilder-1.31/ex/create_tables.pl
DBIx-SearchBuilder-1.31/META.yml
DBIx-SearchBuilder-1.31/ROADMAP
DBIx-SearchBuilder-1.31/README
DBIx-SearchBuilder-1.31/Makefile.PL
DBIx-SearchBuilder-1.31/SIGNATURE
Removing previously used /root/.cpan/build/DBIx-SearchBuilder-1.31

CPAN.pm: Going to build J/JE/JESSE/DBIx-SearchBuilder-1.31.tar.gz
*** ExtUtils::AutoInstall version 0.62
*** Checking for dependencies…
[Core Features]

  • Test::More …loaded. (0.6 >= 0.52)
  • DBI …loaded. (1.40)
  • Want …loaded. (0.09)
  • Encode …loaded. (2.01)
  • Class::ReturnValue …loaded. (0.53 >= 0.4)
  • Cache::Simple::TimedExpiry …loaded. (0.23 >= 0.21)
    [Lower case API]
  • capitalization …loaded. (0.03 >= 0.03)
    [Schema generation]
  • DBIx::DBSchema …loaded. (0.27)
  • Class::Accessor …loaded. (0.19)
    *** ExtUtils::AutoInstall configuration finished.
    Checking if your kit is complete…
    Looks good
    Writing Makefile for DBIx::SearchBuilder
    cp SearchBuilder.pm blib/lib/DBIx/SearchBuilder.pm
    cp SearchBuilder/Handle.pm blib/lib/DBIx/SearchBuilder/Handle.pm
    cp SearchBuilder/Handle/mysql.pm blib/lib/DBIx/SearchBuilder/Handle/mysql.pm
    cp SearchBuilder/Handle/mysqlPP.pm
    blib/lib/DBIx/SearchBuilder/Handle/mysqlPP.pm
    cp SearchBuilder/Handle/Sybase.pm blib/lib/DBIx/SearchBuilder/Handle/Sybase.pm
    cp SearchBuilder/Unique.pm blib/lib/DBIx/SearchBuilder/Unique.pm
    cp SearchBuilder/Union.pm blib/lib/DBIx/SearchBuilder/Union.pm
    cp SearchBuilder/Record/Cachable.pm
    blib/lib/DBIx/SearchBuilder/Record/Cachable.
    pm
    cp SearchBuilder/Handle/Oracle.pm blib/lib/DBIx/SearchBuilder/Handle/Oracle.pm
    cp SearchBuilder/Handle/SQLite.pm blib/lib/DBIx/SearchBuilder/Handle/SQLite.pm
    cp SearchBuilder/Handle/Informix.pm
    blib/lib/DBIx/SearchBuilder/Handle/Informix.
    pm
    cp SearchBuilder/Handle/ODBC.pm blib/lib/DBIx/SearchBuilder/Handle/ODBC.pm
    cp SearchBuilder/Handle/Pg.pm blib/lib/DBIx/SearchBuilder/Handle/Pg.pm
    cp SearchBuilder/SchemaGenerator.pm
    blib/lib/DBIx/SearchBuilder/SchemaGenerator.
    pm
    cp SearchBuilder/Record.pm blib/lib/DBIx/SearchBuilder/Record.pm
    Manifying blib/man3/DBIx::SearchBuilder::Handle::mysqlPP.3pm
    Manifying blib/man3/DBIx::SearchBuilder::Handle::mysql.3pm
    Manifying blib/man3/DBIx::SearchBuilder::Handle.3pm
    Manifying blib/man3/DBIx::SearchBuilder.3pm
    Manifying blib/man3/DBIx::SearchBuilder::Handle::Sybase.3pm
    Manifying blib/man3/DBIx::SearchBuilder::Union.3pm
    Manifying blib/man3/DBIx::SearchBuilder::Unique.3pm
    Manifying blib/man3/DBIx::SearchBuilder::Handle::Oracle.3pm
    Manifying blib/man3/DBIx::SearchBuilder::Record::Cachable.3pm
    Manifying blib/man3/DBIx::SearchBuilder::Handle::Informix.3pm
    Manifying blib/man3/DBIx::SearchBuilder::Handle::SQLite.3pm
    Manifying blib/man3/DBIx::SearchBuilder::Handle::Pg.3pm
    Manifying blib/man3/DBIx::SearchBuilder::Handle::ODBC.3pm
    Manifying blib/man3/DBIx::SearchBuilder::Record.3pm
    Manifying blib/man3/DBIx::SearchBuilder::SchemaGenerator.3pm
    /usr/bin/make – OK
    Running make test
    PERL_DL_NONLAZY=1 /usr/bin/perl “-MExtUtils::Command::MM” “-e” “test_harness(0,
    ‘inc’, ‘blib/lib’, ‘blib/arch’)” t/00.load.t t/01basics.t t/01nocap_api.t
    t/01re
    cords.t t/01searches.t t/02records_object.t t/03rebless.t t/10schema.t
    t/11schem
    a_records.t t/pod.t
    t/00.load…ok
    1/12 skipped: DBD::Oracle is not installed
    t/01basics…dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/01nocap_api…ok
    t/01records…dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/01searches…dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/02records_object…dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/03rebless…dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/10schema…ok
    t/11schema_records…dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/pod…ok
    Failed Test Stat Wstat Total Fail Failed List of Failed
    t/01basics.t 255 65280 ?? ?? % ??
    t/01records.t 255 65280 ?? ?? % ??
    t/01searches.t 255 65280 ?? ?? % ??
    t/02records_object.t 255 65280 ?? ?? % ??
    t/03rebless.t 255 65280 ?? ?? % ??
    t/11schema_records.t 255 65280 ?? ?? % ??
    1 subtest skipped.
    /usr/bin/make test – NOT OK
    Running make install
    make test had returned bad status, won’t install without force
    [root@frankie rt-3.4.4]#

At 10:57 PM 8/31/2005 -0500, Les Mikesell wrote:>On Wed, 2005-08-31 at 22:51, Frank Saxton wrote:

I get the same errors as another forum query I posted tonight having to do
with DBIx::SearchBuilder 1.26…MISSING. Looks like it’s failing the
Oracle test, of all things…:

It’s probably really failing because you followed the instructions
to add a root password to mysql and now it can’t connect to
any database for the tests.


Les Mikesell
les@futuresource.com

Looks like I’m mighty close… I was able to upgrade the 3.0.1 db through
the various increments (I think).

I get a RT login screen. When I log in, I get:

You haven’t yet configured your webserver to run RT. You appear to have
installed RT’s web interface correctly, but haven’t yet configured your web
server to “run” the RT server which powers the web interface. The next step
is to edit your webserver’s configuration file to instruct it to use RT’s
mod_perl, fastcgi or speedycgi handler. If you need commercial support,
please contact us at sales@bestpractical.com.

/etc/groups:

rt:x:501:apache

I’m guessing the problem is a mistake here:

NameVirtualHost frankie.vigilancemonitoring.com:80

ServerAdmin Frankie@Easyrider.com
ServerName frankie.vigilancemonitoring.com
DocumentRoot /opt/rt3/share/html/
AddDefaultCharset UTF-8
AddHandler fastcgi-script fcgi
<Directory “/opt/rt3/share/html”>
Options FollowSymLinks ExecCGI
AllowOverride None

Pass through requests to for noauth

 Alias /NoAuth/ /opt/rt3/share/html/NoAuth/
 ScriptAlias /rt /opt/rt3/bin/mason_handler.fcgi/
FastCgiIpcDir /tmp FastCgiServer /opt/rt3/bin/mason_handler.fcgi -idle-timeout 120 -processes 4

Looks like I’m mighty close… I was able to upgrade the 3.0.1 db through
the various increments (I think).

I get a RT login screen. When I log in, I get:

You haven’t yet configured your webserver to run RT.

Are you going to:
http://frankie.vigilancemonitoring.com/rt/
or
http://frankie.vigilancemonitoring.com

Les Mikesell
les@futuresource.com

I think I’m working OK now :slight_smile:

Thanks very, very much for all of your help Les.

There are several sets of instructions and each conflict with the others to
some degree. The one that works with the least amount of fiddling is at
http://wiki.bestpractical.com/index.cgi?FastCGIConfiguration

The 3.0.1 mysql database stuff migrated over like a dream after I ran the
scrips per the README file.

Need to test it by waiting for a new ticket to come in and seeing if the
old and new RT instances handle it properly. I added a procmail command to
forward new ticket e-mails to the new server I just built. Even if it
doesn’t work as I am planning, I think any new problems should be fairly
minor to correct.

Every time I build RT it goes a little smoother than the last one. The
folks at BP have obviously put some attention into making the install
process friendlier…very much appreciated!

At 11:48 PM 8/31/2005 -0500, Les Mikesell wrote:>On Wed, 2005-08-31 at 23:29, Frank Saxton wrote:

Looks like I’m mighty close… I was able to upgrade the 3.0.1 db through
the various increments (I think).

I get a RT login screen. When I log in, I get:

You haven’t yet configured your webserver to run RT.

Are you going to:
http://frankie.vigilancemonitoring.com/rt/
or
http://frankie.vigilancemonitoring.com


Les Mikesell
les@futuresource.com

You appear to have
installed RT’s web interface correctly, but haven’t yet configured your
web
server to “run” the RT server which powers the web interface. The next
step
is to edit your webserver’s configuration file to instruct it to use RT’s
mod_perl, fastcgi or speedycgi handler. If you need commercial support,
please contact us at sales@bestpractical.com.

/etc/groups:

rt:x:501:apache

I’m guessing the problem is a mistake here:

NameVirtualHost frankie.vigilancemonitoring.com:80

ServerAdmin Frankie@Easyrider.com
ServerName frankie.vigilancemonitoring.com
DocumentRoot /opt/rt3/share/html/
AddDefaultCharset UTF-8
AddHandler fastcgi-script fcgi
<Directory “/opt/rt3/share/html”>
Options FollowSymLinks ExecCGI
AllowOverride None

Pass through requests to for noauth

 Alias /NoAuth/ /opt/rt3/share/html/NoAuth/
 ScriptAlias /rt /opt/rt3/bin/mason_handler.fcgi/
FastCgiIpcDir /tmp FastCgiServer /opt/rt3/bin/mason_handler.fcgi -idle-timeout 120

-processes 4