RT-Users Digest, Vol 57, Issue 56

schraml · December 22, 2008, 4:56pm

Hallo,

ich bin ab dem 7. Januar wieder f�r Sie da.

Freundliche Gr��e,
besinnliche Feiertage und
einen Guten Rutsch ins Jahr 2009

J�rg Schraml

Joseph_Spenner · December 22, 2008, 6:57pm

Would it be possible to have a totally canned RT, perhaps with its own perl with all the modules needed, and installed via some sort of web based installer? Consider the following scenario: I have a web/domain provider who handles my storage needs, such as godaddy.com. I have tons of web space, but no control over the perl modules. However, if everything were installed in my web space such that the canned RT cgi knew where to find its own perl, everything should work. I can create aliases to point to queues as well, via my web providers’ control panel tools.

A similar type of installer exists for a wonderful piece of free forums software called SMF ( http://www.simplemachines.org/ ). It has a couple initial manual steps: create a database on some mysql/postgress system, create a database user with admin rights on that database. That info is then entered that into a field of the web installer along with the location of the database, and hit GO. It builds everything, lets you configure everything via a web interface, etc.

Perhaps I’m over simplifying the installation, so please feel free to point out the flaws. The idea just popped into my head as I was taking a walk, spacing off.

Stuart_Browne · December 22, 2008, 10:01pm

It would be possible to have your own perl installed into its own structure, with all its own localized modules, with its own library path pointing to where it was installed.

What would be difficult with a canned install however would be the web server configuration required / mod_perl stuff.From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Joseph Spenner
Sent: Tuesday, 23 December 2008 05:58
To: rt-users@lists.bestpractical.com
Subject: [rt-users] RT installation - theoretical installer

Would it be possible to have a totally canned RT, perhaps with its own perl with all the modules needed, and installed via some sort of web based installer? Consider the following scenario: I have a web/domain provider who handles my storage needs, such as godaddy.com. I have tons of web space, but no control over the perl modules. However, if everything were installed in my web space such that the canned RT cgi knew where to find its own perl, everything should work. I can create aliases to point to queues as well, via my web providers’ control panel tools.

A similar type of installer exists for a wonderful piece of free forums software called SMF ( http://www.simplemachines.org/ ). It has a couple initial manual steps: create a database on some mysql/postgress system, create a database user with admin rights on that database. That info is then entered that into a field of the web installer along with the location of the database, and hit GO. It builds everything, lets you configure everything via a web interface, etc.

Perhaps I’m over simplifying the installation, so please feel free to point out the flaws. The idea just popped into my head as I was taking a walk, spacing off.

Jesse_Vincent · December 23, 2008, 4:18pm

As it happens, RT 3.8 has this web installer built into it. Just run
./bin/standalone_httpd after downloading and untarring RT

And ‘shipwright’, a tool we’ve been working on can do that bundling.On Mon, Dec 22, 2008 at 10:57:40AM -0800, Joseph Spenner wrote:

Would it be possible to have a totally canned RT, perhaps with its own perl with all the modules needed, and installed via some sort of web based installer? Consider the following scenario: I have a web/domain provider who handles my storage needs, such as godaddy.com. I have tons of web space, but no control over the perl modules. However, if everything were installed in my web space such that the canned RT cgi knew where to find its own perl, everything should work. I can create aliases to point to queues as well, via my web providers’ control panel tools.

A similar type of installer exists for a wonderful piece of free forums software called SMF ( http://www.simplemachines.org/ ). It has a couple initial manual steps: create a database on some mysql/postgress system, create a database user with admin rights on that database. That info is then entered that into a field of the web installer along with the location of the database, and hit GO. It builds everything, lets you configure everything via a web interface, etc.

Perhaps I’m over simplifying the installation, so please feel free to point out the flaws. The idea just popped into my head as I was taking a walk, spacing off.

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Joseph_Spenner · December 30, 2008, 7:33pm

I’m trying to install the latest/greatest RT (3.8.1) on a new slackware 12.2 system.

The ‘make fixdeps’ will fail due to dependencies:

DBIx::SearchBuilder >= 1.54…MISSING

I believe this might be due to a related missing requirement which shows up earlier before the final failure:

DBD::SQLite

I tried manually installing both, but the installation still fails.

When trying to manually install DBD::SQLite, I see:

MSERGEANT/DBD-SQLite-1.14.tar.gz
/usr/bin/make test – NOT OK

Any help would be great.

Thanks!

Jesse_Vincent · December 30, 2008, 7:35pm

When trying to manually install DBD::SQLite, I see:

MSERGEANT/DBD-SQLite-1.14.tar.gz
/usr/bin/make test – NOT OK

Can you perhaps send the list the actual errors you got?

Joseph_Spenner · December 30, 2008, 8:41pm

When trying to manually install DBD::SQLite, I see:

MSERGEANT/DBD-SQLite-1.14.tar.gz
/usr/bin/make test – NOT OK

Can you perhaps send the list the actual errors you got?

Yes. Here is the total output:

root@tuxtrack:/space/rt-packages/rt-3.8.1#
root@tuxtrack:/space/rt-packages/rt-3.8.1# make fixdeps
/usr/bin/perl ./sbin/rt-test-dependencies --verbose --install --with-mysql --with-fastcgi
perl:
>=5.8.3(5.10.0)…found
users:
rt group (apache)…found
bin owner (root)…found
libs owner (root)…found
libs group (bin)…found
web owner (apache)…found
web group (apache)…found
CLI dependencies:
Term::ReadKey…found
Getopt::Long >= 2.24…found
HTTP::Request::Common…found
Term::ReadLine…found
Text::ParseWords…found
LWP…found
CORE dependencies:
Class::ReturnValue >= 0.40…found
Text::Quoted >= 2.02…found
CSS::Squish >= 0.06…found
Encode >= 2.13…found
Module::Versions::Report >= 1.05…found
MIME::Entity >= 5.425…found
DBI >= 1.37…found
Locale::Maketext::Lexicon >= 0.32…found
Devel::StackTrace >= 1.19…found
Digest::base…found
Time::ParseDate…found
File::Temp >= 0.18…found
Locale::Maketext >= 1.06…found
Tree::Simple >= 1.04…found
Text::Template…found
Scalar::Util…found
HTML::Scrubber >= 0.08…found
File::Spec >= 0.8…found
Calendar::Simple…found
DBIx::SearchBuilder >= 1.54…MISSING
Mail::Mailer >= 1.57…found
File::ShareDir…found
Regexp::Common…found
Digest::MD5 >= 2.27…found
HTML::Entities…found
Cache::Simple::TimedExpiry…found
File::Glob…found
Locale::Maketext::Fuzzy…found
Time::HiRes…found
Text::Wrapper…found
Log::Dispatch >= 2.0…found
UNIVERSAL::require…found
Email::Address…found

Install module DBIx::SearchBuilder
Going to read /root/.cpan/Metadata
Database was generated on Tue, 30 Dec 2008 16:26:51 GMT
Running install for module ‘DBIx::SearchBuilder’
‘YAML’ not installed, falling back to Data::Dumper and Storable to read prefs ‘/root/.cpan/prefs’
Running make for J/JE/JESSE/DBIx-SearchBuilder-1.54.tar.gz
CPAN: Digest::SHA loaded ok (v5.45)
CPAN: Compress::Zlib loaded ok (v2.008)
Checksum for /root/.cpan/sources/authors/id/J/JE/JESSE/DBIx-SearchBuilder-1.54.tar.gz ok
DBIx-SearchBuilder-1.54/
DBIx-SearchBuilder-1.54/Changes
DBIx-SearchBuilder-1.54/ex/
DBIx-SearchBuilder-1.54/ex/create_tables.pl
DBIx-SearchBuilder-1.54/ex/Example/
DBIx-SearchBuilder-1.54/ex/Example/Model/
DBIx-SearchBuilder-1.54/ex/Example/Model/Address.pm
DBIx-SearchBuilder-1.54/ex/Example/Model/Employee.pm
DBIx-SearchBuilder-1.54/inc/
DBIx-SearchBuilder-1.54/inc/Module/
DBIx-SearchBuilder-1.54/inc/Module/AutoInstall.pm
DBIx-SearchBuilder-1.54/inc/Module/Install/
DBIx-SearchBuilder-1.54/inc/Module/Install/AutoInstall.pm
DBIx-SearchBuilder-1.54/inc/Module/Install/Base.pm
DBIx-SearchBuilder-1.54/inc/Module/Install/Include.pm
DBIx-SearchBuilder-1.54/inc/Module/Install/Makefile.pm
DBIx-SearchBuilder-1.54/inc/Module/Install/Metadata.pm
DBIx-SearchBuilder-1.54/inc/Module/Install.pm
DBIx-SearchBuilder-1.54/Makefile.PL
DBIx-SearchBuilder-1.54/MANIFEST
DBIx-SearchBuilder-1.54/META.yml
DBIx-SearchBuilder-1.54/README
DBIx-SearchBuilder-1.54/ROADMAP
DBIx-SearchBuilder-1.54/SearchBuilder/
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/Informix.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/mysql.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/mysqlPP.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/ODBC.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/Oracle.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/Pg.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/SQLite.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/Sybase.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Record/
DBIx-SearchBuilder-1.54/SearchBuilder/Record/Cachable.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Record.pm
DBIx-SearchBuilder-1.54/SearchBuilder/SchemaGenerator.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Union.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Unique.pm
DBIx-SearchBuilder-1.54/SearchBuilder.pm
DBIx-SearchBuilder-1.54/SIGNATURE
DBIx-SearchBuilder-1.54/t/
DBIx-SearchBuilder-1.54/t/00.load.t
DBIx-SearchBuilder-1.54/t/01basics.t
DBIx-SearchBuilder-1.54/t/01nocap_api.t
DBIx-SearchBuilder-1.54/t/01records.t
DBIx-SearchBuilder-1.54/t/01searches.t
DBIx-SearchBuilder-1.54/t/02order_outer.t
DBIx-SearchBuilder-1.54/t/02records_cachable.t
DBIx-SearchBuilder-1.54/t/02records_integers.t
DBIx-SearchBuilder-1.54/t/02records_object.t
DBIx-SearchBuilder-1.54/t/02searches_joins.t
DBIx-SearchBuilder-1.54/t/03rebless.t
DBIx-SearchBuilder-1.54/t/03transactions.t
DBIx-SearchBuilder-1.54/t/03versions.t
DBIx-SearchBuilder-1.54/t/10schema.t
DBIx-SearchBuilder-1.54/t/11schema_records.t
DBIx-SearchBuilder-1.54/t/pod.t
DBIx-SearchBuilder-1.54/t/testmodels.pl
DBIx-SearchBuilder-1.54/t/utils.pl
Warning (usually harmless): ‘YAML’ not installed, will not store persistent state

CPAN.pm: Going to build J/JE/JESSE/DBIx-SearchBuilder-1.54.tar.gz

Cannot determine perl version info from SearchBuilder.pm
*** Module::AutoInstall version 1.03
*** Checking for Perl dependencies…
[Core Features]

Test::More …loaded. (0.72 >= 0.52)
DBD::SQLite …missing.
File::Temp …loaded. (0.18)
DBI …loaded. (1.607)
Want …loaded. (0.18)
Encode …loaded. (2.23 >= 1.99)
Class::ReturnValue …loaded. (0.55 >= 0.4)
Cache::Simple::TimedExpiry …loaded. (0.27 >= 0.21)
Clone …loaded. (0.30)
==> Auto-install the 1 mandatory module(s) from CPAN? [y]
[Lower case API]
capitalization …loaded. (0.03 >= 0.03)
[Schema generation]
DBIx::DBSchema …loaded. (0.36)
Class::Accessor …loaded. (0.31)

*** Since we’re running under CPANPLUS, I’ll just let it take care
of the dependency’s installation later.
*** Module::AutoInstall configuration finished.
Checking if your kit is complete…
Looks good
Warning: prerequisite DBD::SQLite 0 not found.
Writing Makefile for DBIx::SearchBuilder
Could not read ‘/root/.cpan/build/DBIx-SearchBuilder-1.54-mDfU3Y/META.yml’. Falling back to other methods to determine prerequisites
---- Unsatisfied dependencies detected during ----
---- JESSE/DBIx-SearchBuilder-1.54.tar.gz ----
DBD::SQLite [requires]
Shall I follow them and prepend them to the queue
of modules we are processing right now? [yes]
Running make test
Delayed until after prerequisites
Running make install
Delayed until after prerequisites
Running install for module ‘DBD::SQLite’
‘YAML’ not installed, falling back to Data::Dumper and Storable to read prefs ‘/root/.cpan/prefs’
Running make for M/MS/MSERGEANT/DBD-SQLite-1.14.tar.gz
Checksum for /root/.cpan/sources/authors/id/M/MS/MSERGEANT/DBD-SQLite-1.14.tar.gz ok
DBD-SQLite-1.14/
DBD-SQLite-1.14/alter.c
DBD-SQLite-1.14/analyze.c
DBD-SQLite-1.14/attach.c
DBD-SQLite-1.14/auth.c
DBD-SQLite-1.14/btree.c
DBD-SQLite-1.14/btree.h
DBD-SQLite-1.14/btreeInt.h
DBD-SQLite-1.14/build.c
DBD-SQLite-1.14/callback.c
DBD-SQLite-1.14/Changes
DBD-SQLite-1.14/complete.c
DBD-SQLite-1.14/date.c
DBD-SQLite-1.14/dbdimp.c
DBD-SQLite-1.14/dbdimp.h
DBD-SQLite-1.14/delete.c
DBD-SQLite-1.14/expr.c
DBD-SQLite-1.14/fts2.c
DBD-SQLite-1.14/fts2.h
DBD-SQLite-1.14/fts2_hash.c
DBD-SQLite-1.14/fts2_hash.h
DBD-SQLite-1.14/fts2_icu.c
DBD-SQLite-1.14/fts2_porter.c
DBD-SQLite-1.14/fts2_tokenizer.c
DBD-SQLite-1.14/fts2_tokenizer.h
DBD-SQLite-1.14/fts2_tokenizer1.c
DBD-SQLite-1.14/func.c
DBD-SQLite-1.14/getsqlite.pl
DBD-SQLite-1.14/hash.c
DBD-SQLite-1.14/hash.h
DBD-SQLite-1.14/insert.c
DBD-SQLite-1.14/keywordhash.h
DBD-SQLite-1.14/legacy.c
DBD-SQLite-1.14/lib/
DBD-SQLite-1.14/lib/DBD/
DBD-SQLite-1.14/lib/DBD/SQLite.pm
DBD-SQLite-1.14/loadext.c
DBD-SQLite-1.14/main.c
DBD-SQLite-1.14/Makefile.PL
DBD-SQLite-1.14/malloc.c
DBD-SQLite-1.14/MANIFEST
DBD-SQLite-1.14/MANIFEST.SKIP
DBD-SQLite-1.14/META.yml
DBD-SQLite-1.14/opcodes.c
DBD-SQLite-1.14/opcodes.h
DBD-SQLite-1.14/os.c
DBD-SQLite-1.14/os.h
DBD-SQLite-1.14/os_common.h
DBD-SQLite-1.14/os_os2.c
DBD-SQLite-1.14/os_os2.h
DBD-SQLite-1.14/os_unix.c
DBD-SQLite-1.14/os_win.c
DBD-SQLite-1.14/pager.c
DBD-SQLite-1.14/pager.h
DBD-SQLite-1.14/parse.c
DBD-SQLite-1.14/parse.h
DBD-SQLite-1.14/ppport.h
DBD-SQLite-1.14/pragma.c
DBD-SQLite-1.14/prepare.c
DBD-SQLite-1.14/printf.c
DBD-SQLite-1.14/random.c
DBD-SQLite-1.14/README
DBD-SQLite-1.14/select.c
DBD-SQLite-1.14/SQLite.xs
DBD-SQLite-1.14/sqlite3.h
DBD-SQLite-1.14/sqlite3ext.h
DBD-SQLite-1.14/sqliteInt.h
DBD-SQLite-1.14/sqliteLimit.h
DBD-SQLite-1.14/SQLiteXS.h
DBD-SQLite-1.14/t/
DBD-SQLite-1.14/t/00basic.t
DBD-SQLite-1.14/t/01logon.t
DBD-SQLite-1.14/t/02cr_table.t
DBD-SQLite-1.14/t/03insert.t
DBD-SQLite-1.14/t/04select.t
DBD-SQLite-1.14/t/05tran.t
DBD-SQLite-1.14/t/06error.t
DBD-SQLite-1.14/t/07busy.t
DBD-SQLite-1.14/t/08create_function.t
DBD-SQLite-1.14/t/09create_aggregate.t
DBD-SQLite-1.14/t/10dsnlist.t
DBD-SQLite-1.14/t/11unicode.t
DBD-SQLite-1.14/t/20createdrop.t
DBD-SQLite-1.14/t/30insertfetch.t
DBD-SQLite-1.14/t/40bindparam.t
DBD-SQLite-1.14/t/40blobs.t
DBD-SQLite-1.14/t/40blobtext.t
DBD-SQLite-1.14/t/40listfields.t
DBD-SQLite-1.14/t/40nulls.t
DBD-SQLite-1.14/t/40numrows.t
DBD-SQLite-1.14/t/40prepcached.t
DBD-SQLite-1.14/t/50chopblanks.t
DBD-SQLite-1.14/t/50commit.t
DBD-SQLite-1.14/t/60metadata.t
DBD-SQLite-1.14/t/70schemachange.t
DBD-SQLite-1.14/t/90cppcomments.t
DBD-SQLite-1.14/t/99cleanup.t
DBD-SQLite-1.14/t/ak-dbd.t
DBD-SQLite-1.14/t/dbdadmin.t
DBD-SQLite-1.14/t/lib.pl
DBD-SQLite-1.14/t/SQLite.dbtest
DBD-SQLite-1.14/table.c
DBD-SQLite-1.14/tokenize.c
DBD-SQLite-1.14/trigger.c
DBD-SQLite-1.14/update.c
DBD-SQLite-1.14/utf.c
DBD-SQLite-1.14/util.c
DBD-SQLite-1.14/vacuum.c
DBD-SQLite-1.14/vdbe.c
DBD-SQLite-1.14/vdbe.h
DBD-SQLite-1.14/vdbeapi.c
DBD-SQLite-1.14/vdbeaux.c
DBD-SQLite-1.14/vdbeblob.c
DBD-SQLite-1.14/vdbefifo.c
DBD-SQLite-1.14/vdbeInt.h
DBD-SQLite-1.14/vdbemem.c
DBD-SQLite-1.14/vtab.c
DBD-SQLite-1.14/where.c
Warning (usually harmless): ‘YAML’ not installed, will not store persistent state

CPAN.pm: Going to build M/MS/MSERGEANT/DBD-SQLite-1.14.tar.gz

Checking installed SQLite version…
Looks good
Checking if your kit is complete…
Looks good
Using DBI 1.607 (for perl 5.010000 on i486-linux-thread-multi) installed in /usr/lib/perl5/vendor_perl/5.10.0/i486-linux-thread-multi/auto/DBI/
Writing Makefile for DBD::SQLite
Could not read ‘/root/.cpan/build/DBD-SQLite-1.14-6O4X44/META.yml’. Falling back to other methods to determine prerequisites
make[1]: Entering directory `/root/.cpan/build/DBD-SQLite-1.14-6O4X44’
cp lib/DBD/SQLite.pm blib/lib/DBD/SQLite.pm
/usr/bin/perl5.10.0 -p -e “s/~DRIVER~/SQLite/g” /usr/lib/perl5/vendor_perl/5.10.0/i486-linux-thread-multi/auto/DBI/Driver.xst > SQLite.xsi
/usr/bin/perl5.10.0 /usr/lib/perl5/5.10.0/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.10.0/ExtUtils/typemap SQLite.xs > SQLite.xsc && mv SQLite.xsc SQLite.c
cc -c -I. -I/usr/lib/perl5/vendor_perl/5.10.0/i486-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION="1.14" -DXS_VERSION="1.14" -fPIC “-I/usr/lib/perl5/5.10.0/i486-linux-thread-multi/CORE” -DSQLITE_CORE -DSQLITE_ENABLE_FTS2 -DNDEBUG=1 -DSQLITE_PTR_SZ=4 -DHAVE_USLEEP=1 SQLite.c
cc -c -I. -I/usr/lib/perl5/vendor_perl/5.10.0/i486-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION="1.14" -DXS_VERSION="1.14" -fPIC “-I/usr/lib/perl5/5.10.0/i486-linux-thread-multi/CORE” -DSQLITE_CORE -DSQLITE_ENABLE_FTS2 -DNDEBUG=1 -DSQLITE_PTR_SZ=4 -DHAVE_USLEEP=1 dbdimp.c
Running Mkbootstrap for DBD::SQLite ()
chmod 644 SQLite.bs
rm -f blib/arch/auto/DBD/SQLite/SQLite.so
LD_RUN_PATH=“/usr/lib” cc -shared -O2 -march=i486 -mtune=i686 -L/usr/local/lib SQLite.o dbdimp.o -o blib/arch/auto/DBD/SQLite/SQLite.so
-lsqlite3 \

chmod 755 blib/arch/auto/DBD/SQLite/SQLite.so
cp SQLite.bs blib/arch/auto/DBD/SQLite/SQLite.bs
chmod 644 blib/arch/auto/DBD/SQLite/SQLite.bs
Manifying blib/man3/DBD::SQLite.3
make[1]: Leaving directory /root/.cpan/build/DBD-SQLite-1.14-6O4X44' MSERGEANT/DBD-SQLite-1.14.tar.gz /usr/bin/make -- OK Warning (usually harmless): 'YAML' not installed, will not store persistent state Running make test make[1]: Entering directory /root/.cpan/build/DBD-SQLite-1.14-6O4X44’
PERL_DL_NONLAZY=1 /usr/bin/perl5.10.0 “-MExtUtils::Command::MM” “-e” “test_harness(0, ‘blib/lib’, ‘blib/arch’)” t/*.t
t/00basic…Name “DBD::SQLite::sqlite_version” used only once: possible typo at /usr/lib/perl5/5.10.0/i486-linux-thread-multi/DynaLoader.pm line 226.
t/00basic…ok
t/01logon…ok
t/02cr_table…ok
t/03insert…ok
t/04select…ok
t/05tran…ok
t/06error…dubious
Test returned status 0 (wstat 11, 0xb)
DIED. FAILED test 2
Failed 1/2 tests, 50.00% okay
t/07busy…dubious
Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 5-8
Failed 4/8 tests, 50.00% okay
t/08create_function…ok
t/09create_aggregate…ok
t/10dsnlist…ok
t/11unicode…ok
t/20createdrop…ok
t/30insertfetch…ok
t/40bindparam…ok
t/40blobs…ok
t/40blobtext…ok
t/40listfields…ok
t/40nulls…ok
t/40numrows…ok
t/40prepcached…ok
t/50chopblanks…ok
t/50commit…ok
t/60metadata…ok
t/70schemachange…ok
t/90cppcomments…ok
t/99cleanup…ok
t/ak-dbd…ok
t/dbdadmin…ok
Failed Test Stat Wstat Total Fail List of Failed
t/06error.t 0 11 2 2 2
t/07busy.t 0 11 8 8 5-8
Failed 2/29 test scripts. 5/463 subtests failed.
Files=29, Tests=463, 7 wallclock secs ( 1.48 cusr + 1.45 csys = 2.93 CPU)
Failed 2/29 test programs. 5/463 subtests failed.
make[1]: *** [test_dynamic] Error 255
make[1]: Leaving directory `/root/.cpan/build/DBD-SQLite-1.14-6O4X44’
MSERGEANT/DBD-SQLite-1.14.tar.gz
/usr/bin/make test – NOT OK
//hint// to see the cpan-testers results for installing this module, try:
reports MSERGEANT/DBD-SQLite-1.14.tar.gz
Warning (usually harmless): ‘YAML’ not installed, will not store persistent state
Running make install
make test had returned bad status, won’t install without force
Running make for J/JE/JESSE/DBIx-SearchBuilder-1.54.tar.gz
Has already been unwrapped into directory /root/.cpan/build/DBIx-SearchBuilder-1.54-mDfU3Y

CPAN.pm: Going to build J/JE/JESSE/DBIx-SearchBuilder-1.54.tar.gz

Warning: Prerequisite ‘DBD::SQLite => 0’ for ‘J/JE/JESSE/DBIx-SearchBuilder-1.54.tar.gz’ failed when processing ‘M/MS/MSERGEANT/DBD-SQLite-1.14.tar.gz’ with ‘make_test => NO’. Continuing, but chances to succeed are limited.
make[1]: Entering directory `/root/.cpan/build/DBIx-SearchBuilder-1.54-mDfU3Y’
/usr/bin/perl5.10.0 “-Iinc” Makefile.PL --config= --installdeps=DBD::SQLite,0
Cannot determine perl version info from SearchBuilder.pm

*** Since we’re running under CPANPLUS, I’ll just let it take care
of the dependency’s installation later.
cp SearchBuilder.pm blib/lib/DBIx/SearchBuilder.pm
cp SearchBuilder/Handle.pm blib/lib/DBIx/SearchBuilder/Handle.pm
cp SearchBuilder/Handle/mysqlPP.pm blib/lib/DBIx/SearchBuilder/Handle/mysqlPP.pm
cp SearchBuilder/Handle/mysql.pm blib/lib/DBIx/SearchBuilder/Handle/mysql.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/Handle/Oracle.pm blib/lib/DBIx/SearchBuilder/Handle/Oracle.pm
cp SearchBuilder/Record/Cachable.pm blib/lib/DBIx/SearchBuilder/Record/Cachable.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/Pg.pm blib/lib/DBIx/SearchBuilder/Handle/Pg.pm
cp SearchBuilder/Handle/ODBC.pm blib/lib/DBIx/SearchBuilder/Handle/ODBC.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::mysql.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::mysqlPP.3
Manifying blib/man3/DBIx::SearchBuilder::Handle.3
Manifying blib/man3/DBIx::SearchBuilder.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::Sybase.3
Manifying blib/man3/DBIx::SearchBuilder::Union.3
Manifying blib/man3/DBIx::SearchBuilder::Unique.3
Manifying blib/man3/DBIx::SearchBuilder::Record::Cachable.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::Oracle.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::Informix.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::SQLite.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::ODBC.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::Pg.3
Manifying blib/man3/DBIx::SearchBuilder::Record.3
Manifying blib/man3/DBIx::SearchBuilder::SchemaGenerator.3
make[1]: Leaving directory /root/.cpan/build/DBIx-SearchBuilder-1.54-mDfU3Y' JESSE/DBIx-SearchBuilder-1.54.tar.gz /usr/bin/make -- OK Warning (usually harmless): 'YAML' not installed, will not store persistent state Running make test make[1]: Entering directory /root/.cpan/build/DBIx-SearchBuilder-1.54-mDfU3Y’
/usr/bin/perl5.10.0 “-Iinc” Makefile.PL --config= --installdeps=DBD::SQLite,0
Cannot determine perl version info from SearchBuilder.pm

*** Since we’re running under CPANPLUS, I’ll just let it take care
of the dependency’s installation later.
PERL_DL_NONLAZY=1 /usr/bin/perl5.10.0 “-MExtUtils::Command::MM” “-e” “test_harness(0, ‘inc’, ‘blib/lib’, ‘blib/arch’)” t/00.load.t t/01basics.t t/01nocap_api.t t/01records.t t/01searches.t t/02order_outer.t t/02records_cachable.t t/02records_integers.t t/02records_object.t t/02searches_joins.t t/03rebless.t t/03transactions.t t/03versions.t t/10schema.t t/11schema_records.t t/pod.t
t/00.load…ok
1/12 skipped: various reasons
t/01basics…ok
t/01nocap_api…ok
t/01records…ok
65/65 skipped: various reasons
t/01searches…ok
76/76 skipped: various reasons
t/02order_outer…ok
98/98 skipped: various reasons
t/02records_cachable…ok
16/16 skipped: various reasons
t/02records_integers…ok
33/33 skipped: various reasons
t/02records_object…ok
11/11 skipped: various reasons
t/02searches_joins…ok
47/47 skipped: various reasons
t/03rebless…ok
4/4 skipped: various reasons
t/03transactions…ok
42/42 skipped: various reasons
t/03versions…ok
6/6 skipped: various reasons
t/10schema…ok
14/17 skipped: various reasons
t/11schema_records…ok
63/63 skipped: various reasons
t/pod…ok
All tests successful, 476 subtests skipped.
Files=16, Tests=511, 4 wallclock secs ( 2.42 cusr + 1.55 csys = 3.97 CPU)
make[1]: Leaving directory `/root/.cpan/build/DBIx-SearchBuilder-1.54-mDfU3Y’
JESSE/DBIx-SearchBuilder-1.54.tar.gz
Tests succeeded but one dependency not OK (DBD::SQLite)
Warning (usually harmless): ‘YAML’ not installed, will not store persistent state
JESSE/DBIx-SearchBuilder-1.54.tar.gz
[dependencies] – NA
Running make install
make test had returned bad status, won’t install without force
DASHBOARDS dependencies:
HTML::RewriteAttributes >= 0.02…found
MIME::Types…found
FASTCGI dependencies:
CGI::Fast…found
CGI >= 3.38…found
FCGI…found
GD dependencies:
GD::Text…found
GD…found
GD::Graph…found
GPG dependencies:
PerlIO::eol…found
GnuPG::Interface…found
ICAL dependencies:
Data::ICal…MISSING

Install module Data::ICal
Data::ICal is up to date (0.13).
MAILGATE dependencies:
Pod::Usage…found
HTML::TreeBuilder…found
Getopt::Long…found
HTML::FormatText…found
LWP::UserAgent…found
MASON dependencies:
Storable >= 2.08…found
CSS::Squish >= 0.06…found
Apache::Session >= 1.53…found
Errno…found
Devel::StackTrace >= 1.19…found
CGI::Cookie >= 1.20…found
Text::WikiFormat >= 0.76…found
XML::RSS >= 1.05…found
HTML::Mason >= 1.36…found
Digest::MD5 >= 2.27…found
MYSQL dependencies:
DBD::mysql >= 2.1018…found
SMTP dependencies:
Net::SMTP…found
STANDALONE dependencies:
Net::Server::PreFork…found
Net::Server…found
HTTP::Server::Simple >= 0.34…found
HTTP::Server::Simple::Mason >= 0.09…found

SOME DEPENDENCIES WERE MISSING.
ICAL missing dependencies:
Data::ICal…MISSING
CORE missing dependencies:
DBIx::SearchBuilder >= 1.54…MISSING
make: *** [fixdeps] Error 1
root@tuxtrack:/space/rt-packages/rt-3.8.1#

Richard_Foley · December 31, 2008, 11:01am

Hi Joseph,

It looks like DBD::SQLite is your problem - try installing that by hand first.
It’s not really RT’s fault that a dependency module breaks on your particular
system, and installing everything via CPAN is the most generic way to go.
Once DBD::SQLite is succesfully installed then, and only then, try the ‘make
fixdeps’ command again.

Failed Test Stat Wstat Total Fail List of Failed
t/06error.t 0 11 2 2 2
t/07busy.t 0 11 8 8 5-8
Failed 2/29 test scripts. 5/463 subtests failed.
Files=29, Tests=463, 7 wallclock secs ( 1.48 cusr + 1.45 csys = 2.93 CPU)
Failed 2/29 test programs. 5/463 subtests failed.
make[1]: *** [test_dynamic] Error 255
make[1]: Leaving directory `/root/.cpan/build/DBD-SQLite-1.14-6O4X44’
MSERGEANT/DBD-SQLite-1.14.tar.gz
/usr/bin/make test – NOT OK

Richard Foley
Ciao - shorter than aufwiedersehen

From: Jesse Vincent jesse@bestpractical.com
Subject: Re: [rt-users] fixdeps errors: DBD::SQLite and DBIx::SearchBuilder
To: “Joseph Spenner” joseph85750@yahoo.com
Cc: rt-users@lists.bestpractical.com
Date: Tuesday, December 30, 2008, 12:35 PM

When trying to manually install DBD::SQLite, I see:

MSERGEANT/DBD-SQLite-1.14.tar.gz
/usr/bin/make test – NOT OK

Can you perhaps send the list the actual errors you got?

Yes. Here is the total output:

root@tuxtrack:/space/rt-packages/rt-3.8.1#
root@tuxtrack:/space/rt-packages/rt-3.8.1# make fixdeps
/usr/bin/perl ./sbin/rt-test-dependencies --verbose --install --with-mysql --with-fastcgi
perl:
>=5.8.3(5.10.0)…found
users:
rt group (apache)…found
bin owner (root)…found
libs owner (root)…found
libs group (bin)…found
web owner (apache)…found
web group (apache)…found
CLI dependencies:
Term::ReadKey…found
Getopt::Long >= 2.24…found
HTTP::Request::Common…found
Term::ReadLine…found
Text::ParseWords…found
LWP…found
CORE dependencies:
Class::ReturnValue >= 0.40…found
Text::Quoted >= 2.02…found
CSS::Squish >= 0.06…found
Encode >= 2.13…found
Module::Versions::Report >= 1.05…found
MIME::Entity >= 5.425…found
DBI >= 1.37…found
Locale::Maketext::Lexicon >= 0.32…found
Devel::StackTrace >= 1.19…found
Digest::base…found
Time::ParseDate…found
File::Temp >= 0.18…found
Locale::Maketext >= 1.06…found
Tree::Simple >= 1.04…found
Text::Template…found
Scalar::Util…found
HTML::Scrubber >= 0.08…found
File::Spec >= 0.8…found
Calendar::Simple…found
DBIx::SearchBuilder >= 1.54…MISSING
Mail::Mailer >= 1.57…found
File::ShareDir…found
Regexp::Common…found
Digest::MD5 >= 2.27…found
HTML::Entities…found
Cache::Simple::TimedExpiry…found
File::Glob…found
Locale::Maketext::Fuzzy…found
Time::HiRes…found
Text::Wrapper…found
Log::Dispatch >= 2.0…found
UNIVERSAL::require…found
Email::Address…found

Install module DBIx::SearchBuilder
Going to read /root/.cpan/Metadata
Database was generated on Tue, 30 Dec 2008 16:26:51 GMT
Running install for module ‘DBIx::SearchBuilder’
‘YAML’ not installed, falling back to Data::Dumper and Storable to read
prefs ‘/root/.cpan/prefs’
Running make for J/JE/JESSE/DBIx-SearchBuilder-1.54.tar.gz
CPAN: Digest::SHA loaded ok (v5.45)
CPAN: Compress::Zlib loaded ok (v2.008)
Checksum
for /root/.cpan/sources/authors/id/J/JE/JESSE/DBIx-SearchBuilder-1.54.tar.gz
ok
DBIx-SearchBuilder-1.54/
DBIx-SearchBuilder-1.54/Changes
DBIx-SearchBuilder-1.54/ex/
DBIx-SearchBuilder-1.54/ex/create_tables.pl
DBIx-SearchBuilder-1.54/ex/Example/
DBIx-SearchBuilder-1.54/ex/Example/Model/
DBIx-SearchBuilder-1.54/ex/Example/Model/Address.pm
DBIx-SearchBuilder-1.54/ex/Example/Model/Employee.pm
DBIx-SearchBuilder-1.54/inc/
DBIx-SearchBuilder-1.54/inc/Module/
DBIx-SearchBuilder-1.54/inc/Module/AutoInstall.pm
DBIx-SearchBuilder-1.54/inc/Module/Install/
DBIx-SearchBuilder-1.54/inc/Module/Install/AutoInstall.pm
DBIx-SearchBuilder-1.54/inc/Module/Install/Base.pm
DBIx-SearchBuilder-1.54/inc/Module/Install/Include.pm
DBIx-SearchBuilder-1.54/inc/Module/Install/Makefile.pm
DBIx-SearchBuilder-1.54/inc/Module/Install/Metadata.pm
DBIx-SearchBuilder-1.54/inc/Module/Install.pm
DBIx-SearchBuilder-1.54/Makefile.PL
DBIx-SearchBuilder-1.54/MANIFEST
DBIx-SearchBuilder-1.54/META.yml
DBIx-SearchBuilder-1.54/README
DBIx-SearchBuilder-1.54/ROADMAP
DBIx-SearchBuilder-1.54/SearchBuilder/
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/Informix.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/mysql.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/mysqlPP.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/ODBC.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/Oracle.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/Pg.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/SQLite.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/Sybase.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Record/
DBIx-SearchBuilder-1.54/SearchBuilder/Record/Cachable.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Record.pm
DBIx-SearchBuilder-1.54/SearchBuilder/SchemaGenerator.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Union.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Unique.pm
DBIx-SearchBuilder-1.54/SearchBuilder.pm
DBIx-SearchBuilder-1.54/SIGNATURE
DBIx-SearchBuilder-1.54/t/
DBIx-SearchBuilder-1.54/t/00.load.t
DBIx-SearchBuilder-1.54/t/01basics.t
DBIx-SearchBuilder-1.54/t/01nocap_api.t
DBIx-SearchBuilder-1.54/t/01records.t
DBIx-SearchBuilder-1.54/t/01searches.t
DBIx-SearchBuilder-1.54/t/02order_outer.t
DBIx-SearchBuilder-1.54/t/02records_cachable.t
DBIx-SearchBuilder-1.54/t/02records_integers.t
DBIx-SearchBuilder-1.54/t/02records_object.t
DBIx-SearchBuilder-1.54/t/02searches_joins.t
DBIx-SearchBuilder-1.54/t/03rebless.t
DBIx-SearchBuilder-1.54/t/03transactions.t
DBIx-SearchBuilder-1.54/t/03versions.t
DBIx-SearchBuilder-1.54/t/10schema.t
DBIx-SearchBuilder-1.54/t/11schema_records.t
DBIx-SearchBuilder-1.54/t/pod.t
DBIx-SearchBuilder-1.54/t/testmodels.pl
DBIx-SearchBuilder-1.54/t/utils.pl
Warning (usually harmless): ‘YAML’ not installed, will not store persistent
state

CPAN.pm: Going to build J/JE/JESSE/DBIx-SearchBuilder-1.54.tar.gz

Cannot determine perl version info from SearchBuilder.pm
*** Module::AutoInstall version 1.03
*** Checking for Perl dependencies…
[Core Features]

Test::More …loaded. (0.72 >= 0.52)

DBD::SQLite …missing.

File::Temp …loaded. (0.18)

DBI …loaded. (1.607)

Want …loaded. (0.18)

Encode …loaded. (2.23 >= 1.99)

Class::ReturnValue …loaded. (0.55 >= 0.4)

Cache::Simple::TimedExpiry …loaded. (0.27 >= 0.21)

Clone …loaded. (0.30)
==> Auto-install the 1 mandatory module(s) from CPAN? [y]
[Lower case API]

capitalization …loaded. (0.03 >= 0.03)
[Schema generation]

DBIx::DBSchema …loaded. (0.36)

Class::Accessor …loaded. (0.31)

*** Since we’re running under CPANPLUS, I’ll just let it take care
of the dependency’s installation later.
*** Module::AutoInstall configuration finished.
Checking if your kit is complete…
Looks good
Warning: prerequisite DBD::SQLite 0 not found.
Writing Makefile for DBIx::SearchBuilder
Could not read ‘/root/.cpan/build/DBIx-SearchBuilder-1.54-mDfU3Y/META.yml’.
Falling back to other methods to determine prerequisites
---- Unsatisfied dependencies detected during ----
---- JESSE/DBIx-SearchBuilder-1.54.tar.gz ----
DBD::SQLite [requires]
Shall I follow them and prepend them to the queue
of modules we are processing right now? [yes]
Running make test
Delayed until after prerequisites
Running make install
Delayed until after prerequisites
Running install for module ‘DBD::SQLite’
‘YAML’ not installed, falling back to Data::Dumper and Storable to read
prefs ‘/root/.cpan/prefs’
Running make for M/MS/MSERGEANT/DBD-SQLite-1.14.tar.gz
Checksum
for /root/.cpan/sources/authors/id/M/MS/MSERGEANT/DBD-SQLite-1.14.tar.gz ok
DBD-SQLite-1.14/
DBD-SQLite-1.14/alter.c
DBD-SQLite-1.14/analyze.c
DBD-SQLite-1.14/attach.c
DBD-SQLite-1.14/auth.c
DBD-SQLite-1.14/btree.c
DBD-SQLite-1.14/btree.h
DBD-SQLite-1.14/btreeInt.h
DBD-SQLite-1.14/build.c
DBD-SQLite-1.14/callback.c
DBD-SQLite-1.14/Changes
DBD-SQLite-1.14/complete.c
DBD-SQLite-1.14/date.c
DBD-SQLite-1.14/dbdimp.c
DBD-SQLite-1.14/dbdimp.h
DBD-SQLite-1.14/delete.c
DBD-SQLite-1.14/expr.c
DBD-SQLite-1.14/fts2.c
DBD-SQLite-1.14/fts2.h
DBD-SQLite-1.14/fts2_hash.c
DBD-SQLite-1.14/fts2_hash.h
DBD-SQLite-1.14/fts2_icu.c
DBD-SQLite-1.14/fts2_porter.c
DBD-SQLite-1.14/fts2_tokenizer.c
DBD-SQLite-1.14/fts2_tokenizer.h
DBD-SQLite-1.14/fts2_tokenizer1.c
DBD-SQLite-1.14/func.c
DBD-SQLite-1.14/getsqlite.pl
DBD-SQLite-1.14/hash.c
DBD-SQLite-1.14/hash.h
DBD-SQLite-1.14/insert.c
DBD-SQLite-1.14/keywordhash.h
DBD-SQLite-1.14/legacy.c
DBD-SQLite-1.14/lib/
DBD-SQLite-1.14/lib/DBD/
DBD-SQLite-1.14/lib/DBD/SQLite.pm
DBD-SQLite-1.14/loadext.c
DBD-SQLite-1.14/main.c
DBD-SQLite-1.14/Makefile.PL
DBD-SQLite-1.14/malloc.c
DBD-SQLite-1.14/MANIFEST
DBD-SQLite-1.14/MANIFEST.SKIP
DBD-SQLite-1.14/META.yml
DBD-SQLite-1.14/opcodes.c
DBD-SQLite-1.14/opcodes.h
DBD-SQLite-1.14/os.c
DBD-SQLite-1.14/os.h
DBD-SQLite-1.14/os_common.h
DBD-SQLite-1.14/os_os2.c
DBD-SQLite-1.14/os_os2.h
DBD-SQLite-1.14/os_unix.c
DBD-SQLite-1.14/os_win.c
DBD-SQLite-1.14/pager.c
DBD-SQLite-1.14/pager.h
DBD-SQLite-1.14/parse.c
DBD-SQLite-1.14/parse.h
DBD-SQLite-1.14/ppport.h
DBD-SQLite-1.14/pragma.c
DBD-SQLite-1.14/prepare.c
DBD-SQLite-1.14/printf.c
DBD-SQLite-1.14/random.c
DBD-SQLite-1.14/README
DBD-SQLite-1.14/select.c
DBD-SQLite-1.14/SQLite.xs
DBD-SQLite-1.14/sqlite3.h
DBD-SQLite-1.14/sqlite3ext.h
DBD-SQLite-1.14/sqliteInt.h
DBD-SQLite-1.14/sqliteLimit.h
DBD-SQLite-1.14/SQLiteXS.h
DBD-SQLite-1.14/t/
DBD-SQLite-1.14/t/00basic.t
DBD-SQLite-1.14/t/01logon.t
DBD-SQLite-1.14/t/02cr_table.t
DBD-SQLite-1.14/t/03insert.t
DBD-SQLite-1.14/t/04select.t
DBD-SQLite-1.14/t/05tran.t
DBD-SQLite-1.14/t/06error.t
DBD-SQLite-1.14/t/07busy.t
DBD-SQLite-1.14/t/08create_function.t
DBD-SQLite-1.14/t/09create_aggregate.t
DBD-SQLite-1.14/t/10dsnlist.t
DBD-SQLite-1.14/t/11unicode.t
DBD-SQLite-1.14/t/20createdrop.t
DBD-SQLite-1.14/t/30insertfetch.t
DBD-SQLite-1.14/t/40bindparam.t
DBD-SQLite-1.14/t/40blobs.t
DBD-SQLite-1.14/t/40blobtext.t
DBD-SQLite-1.14/t/40listfields.t
DBD-SQLite-1.14/t/40nulls.t
DBD-SQLite-1.14/t/40numrows.t
DBD-SQLite-1.14/t/40prepcached.t
DBD-SQLite-1.14/t/50chopblanks.t
DBD-SQLite-1.14/t/50commit.t
DBD-SQLite-1.14/t/60metadata.t
DBD-SQLite-1.14/t/70schemachange.t
DBD-SQLite-1.14/t/90cppcomments.t
DBD-SQLite-1.14/t/99cleanup.t
DBD-SQLite-1.14/t/ak-dbd.t
DBD-SQLite-1.14/t/dbdadmin.t
DBD-SQLite-1.14/t/lib.pl
DBD-SQLite-1.14/t/SQLite.dbtest
DBD-SQLite-1.14/table.c
DBD-SQLite-1.14/tokenize.c
DBD-SQLite-1.14/trigger.c
DBD-SQLite-1.14/update.c
DBD-SQLite-1.14/utf.c
DBD-SQLite-1.14/util.c
DBD-SQLite-1.14/vacuum.c
DBD-SQLite-1.14/vdbe.c
DBD-SQLite-1.14/vdbe.h
DBD-SQLite-1.14/vdbeapi.c
DBD-SQLite-1.14/vdbeaux.c
DBD-SQLite-1.14/vdbeblob.c
DBD-SQLite-1.14/vdbefifo.c
DBD-SQLite-1.14/vdbeInt.h
DBD-SQLite-1.14/vdbemem.c
DBD-SQLite-1.14/vtab.c
DBD-SQLite-1.14/where.c
Warning (usually harmless): ‘YAML’ not installed, will not store persistent
state

CPAN.pm: Going to build M/MS/MSERGEANT/DBD-SQLite-1.14.tar.gz

Checking installed SQLite version…
Looks good
Checking if your kit is complete…
Looks good
Using DBI 1.607 (for perl 5.010000 on i486-linux-thread-multi) installed
in /usr/lib/perl5/vendor_perl/5.10.0/i486-linux-thread-multi/auto/DBI/
Writing Makefile for DBD::SQLite
Could not read ‘/root/.cpan/build/DBD-SQLite-1.14-6O4X44/META.yml’. Falling
back to other methods to determine prerequisites
make[1]: Entering directory `/root/.cpan/build/DBD-SQLite-1.14-6O4X44’
cp lib/DBD/SQLite.pm blib/lib/DBD/SQLite.pm
/usr/bin/perl5.10.0 -p -e “s/~DRIVER~/SQLite/g” /usr/lib/perl5/vendor_perl/5.10.0/i486-linux-thread-multi/auto/DBI/Driver.xst
SQLite.xsi
/usr/bin/perl5.10.0 /usr/lib/perl5/5.10.0/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.10.0/ExtUtils/typemap
SQLite.xs > SQLite.xsc && mv SQLite.xsc SQLite.c

cc -c -I. -I/usr/lib/perl5/vendor_perl/5.10.0/i486-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION="1.14" -DXS_VERSION="1.14" -fPIC “-I/usr/lib/perl5/5.10.0/i486-linux-thread-multi/CORE” -DSQLITE_CORE -DSQLITE_ENABLE_FTS2 -DNDEBUG=1 -DSQLITE_PTR_SZ=4 -DHAVE_USLEEP=1
SQLite.c

cc -c -I. -I/usr/lib/perl5/vendor_perl/5.10.0/i486-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION="1.14" -DXS_VERSION="1.14" -fPIC “-I/usr/lib/perl5/5.10.0/i486-linux-thread-multi/CORE” -DSQLITE_CORE -DSQLITE_ENABLE_FTS2 -DNDEBUG=1 -DSQLITE_PTR_SZ=4 -DHAVE_USLEEP=1
dbdimp.c

Running Mkbootstrap for DBD::SQLite ()
chmod 644 SQLite.bs
rm -f blib/arch/auto/DBD/SQLite/SQLite.so
LD_RUN_PATH=“/usr/lib”
cc -shared -O2 -march=i486 -mtune=i686 -L/usr/local/lib SQLite.o
dbdimp.o -o blib/arch/auto/DBD/SQLite/SQLite.so
-lsqlite3 \

chmod 755 blib/arch/auto/DBD/SQLite/SQLite.so
cp SQLite.bs blib/arch/auto/DBD/SQLite/SQLite.bs
chmod 644 blib/arch/auto/DBD/SQLite/SQLite.bs
Manifying blib/man3/DBD::SQLite.3
make[1]: Leaving directory /root/.cpan/build/DBD-SQLite-1.14-6O4X44' MSERGEANT/DBD-SQLite-1.14.tar.gz /usr/bin/make -- OK Warning (usually harmless): 'YAML' not installed, will not store persistent state Running make test make[1]: Entering directory /root/.cpan/build/DBD-SQLite-1.14-6O4X44’

PERL_DL_NONLAZY=1 /usr/bin/perl5.10.0 “-MExtUtils::Command::MM” “-e” “test_harness(0, ‘blib/lib’, ‘blib/arch’)”
t/*.t

t/00basic…Name “DBD::SQLite::sqlite_version” used only once:
possible typo at /usr/lib/perl5/5.10.0/i486-linux-thread-multi/DynaLoader.pm
line 226.
t/00basic…ok
t/01logon…ok
t/02cr_table…ok
t/03insert…ok
t/04select…ok
t/05tran…ok
t/06error…dubious
Test returned status 0 (wstat 11, 0xb)
DIED. FAILED test 2
Failed 1/2 tests, 50.00% okay
t/07busy…dubious
Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 5-8
Failed 4/8 tests, 50.00% okay
t/08create_function…ok
t/09create_aggregate…ok
t/10dsnlist…ok
t/11unicode…ok
t/20createdrop…ok
t/30insertfetch…ok
t/40bindparam…ok
t/40blobs…ok
t/40blobtext…ok
t/40listfields…ok
t/40nulls…ok
t/40numrows…ok
t/40prepcached…ok
t/50chopblanks…ok
t/50commit…ok
t/60metadata…ok
t/70schemachange…ok
t/90cppcomments…ok
t/99cleanup…ok
t/ak-dbd…ok
t/dbdadmin…ok
Failed Test Stat Wstat Total Fail List of Failed

t/06error.t 0 11 2 2 2
t/07busy.t 0 11 8 8 5-8
Failed 2/29 test scripts. 5/463 subtests failed.
Files=29, Tests=463, 7 wallclock secs ( 1.48 cusr + 1.45 csys = 2.93 CPU)
Failed 2/29 test programs. 5/463 subtests failed.
make[1]: *** [test_dynamic] Error 255
make[1]: Leaving directory `/root/.cpan/build/DBD-SQLite-1.14-6O4X44’
MSERGEANT/DBD-SQLite-1.14.tar.gz
/usr/bin/make test – NOT OK
//hint// to see the cpan-testers results for installing this module, try:
reports MSERGEANT/DBD-SQLite-1.14.tar.gz
Warning (usually harmless): ‘YAML’ not installed, will not store persistent
state
Running make install
make test had returned bad status, won’t install without force
Running make for J/JE/JESSE/DBIx-SearchBuilder-1.54.tar.gz
Has already been unwrapped into
directory /root/.cpan/build/DBIx-SearchBuilder-1.54-mDfU3Y

CPAN.pm: Going to build J/JE/JESSE/DBIx-SearchBuilder-1.54.tar.gz

Warning: Prerequisite ‘DBD::SQLite => 0’
for ‘J/JE/JESSE/DBIx-SearchBuilder-1.54.tar.gz’ failed when
processing ‘M/MS/MSERGEANT/DBD-SQLite-1.14.tar.gz’ with ‘make_test => NO’.
Continuing, but chances to succeed are limited.
make[1]: Entering directory
`/root/.cpan/build/DBIx-SearchBuilder-1.54-mDfU3Y’
/usr/bin/perl5.10.0 “-Iinc”
Makefile.PL --config= --installdeps=DBD::SQLite,0
Cannot determine perl version info from SearchBuilder.pm

*** Since we’re running under CPANPLUS, I’ll just let it take care
of the dependency’s installation later.
cp SearchBuilder.pm blib/lib/DBIx/SearchBuilder.pm
cp SearchBuilder/Handle.pm blib/lib/DBIx/SearchBuilder/Handle.pm
cp SearchBuilder/Handle/mysqlPP.pm
blib/lib/DBIx/SearchBuilder/Handle/mysqlPP.pm
cp SearchBuilder/Handle/mysql.pm blib/lib/DBIx/SearchBuilder/Handle/mysql.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/Handle/Oracle.pm
blib/lib/DBIx/SearchBuilder/Handle/Oracle.pm
cp SearchBuilder/Record/Cachable.pm
blib/lib/DBIx/SearchBuilder/Record/Cachable.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/Pg.pm blib/lib/DBIx/SearchBuilder/Handle/Pg.pm
cp SearchBuilder/Handle/ODBC.pm blib/lib/DBIx/SearchBuilder/Handle/ODBC.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::mysql.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::mysqlPP.3
Manifying blib/man3/DBIx::SearchBuilder::Handle.3
Manifying blib/man3/DBIx::SearchBuilder.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::Sybase.3
Manifying blib/man3/DBIx::SearchBuilder::Union.3
Manifying blib/man3/DBIx::SearchBuilder::Unique.3
Manifying blib/man3/DBIx::SearchBuilder::Record::Cachable.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::Oracle.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::Informix.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::SQLite.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::ODBC.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::Pg.3
Manifying blib/man3/DBIx::SearchBuilder::Record.3
Manifying blib/man3/DBIx::SearchBuilder::SchemaGenerator.3
make[1]: Leaving directory
/root/.cpan/build/DBIx-SearchBuilder-1.54-mDfU3Y' JESSE/DBIx-SearchBuilder-1.54.tar.gz /usr/bin/make -- OK Warning (usually harmless): 'YAML' not installed, will not store persistent state Running make test make[1]: Entering directory /root/.cpan/build/DBIx-SearchBuilder-1.54-mDfU3Y’
/usr/bin/perl5.10.0 “-Iinc”
Makefile.PL --config= --installdeps=DBD::SQLite,0
Cannot determine perl version info from SearchBuilder.pm

*** Since we’re running under CPANPLUS, I’ll just let it take care
of the dependency’s installation later.

PERL_DL_NONLAZY=1 /usr/bin/perl5.10.0 “-MExtUtils::Command::MM” “-e” “test_harness(0, ‘inc’, ‘blib/lib’, ‘blib/arch’)”
t/00.load.t t/01basics.t t/01nocap_api.t t/01records.t t/01searches.t
t/02order_outer.t t/02records_cachable.t t/02records_integers.t
t/02records_object.t t/02searches_joins.t t/03rebless.t t/03transactions.t
t/03versions.t t/10schema.t t/11schema_records.t t/pod.t

t/00.load…ok
1/12 skipped: various reasons
t/01basics…ok
t/01nocap_api…ok
t/01records…ok
65/65 skipped: various reasons
t/01searches…ok
76/76 skipped: various reasons
t/02order_outer…ok
98/98 skipped: various reasons
t/02records_cachable…ok
16/16 skipped: various reasons
t/02records_integers…ok
33/33 skipped: various reasons
t/02records_object…ok
11/11 skipped: various reasons
t/02searches_joins…ok
47/47 skipped: various reasons
t/03rebless…ok
4/4 skipped: various reasons
t/03transactions…ok
42/42 skipped: various reasons
t/03versions…ok
6/6 skipped: various reasons
t/10schema…ok
14/17 skipped: various reasons
t/11schema_records…ok
63/63 skipped: various reasons
t/pod…ok
All tests successful, 476 subtests skipped.
Files=16, Tests=511, 4 wallclock secs ( 2.42 cusr + 1.55 csys = 3.97 CPU)
make[1]: Leaving directory
`/root/.cpan/build/DBIx-SearchBuilder-1.54-mDfU3Y’
JESSE/DBIx-SearchBuilder-1.54.tar.gz
Tests succeeded but one dependency not OK (DBD::SQLite)
Warning (usually harmless): ‘YAML’ not installed, will not store persistent
state

Ruslan_Zakirov · December 31, 2008, 1:19pm

It’s ok to force install DBD::SQLite, I saw this errors too. This
module is required to test DBIx::SearchBuilder functionality only.On Wed, Dec 31, 2008 at 2:01 PM, Richard Foley Richard.Foley@rfi.net wrote:

Hi Joseph,

It looks like DBD::SQLite is your problem - try installing that by hand first.
It’s not really RT’s fault that a dependency module breaks on your particular
system, and installing everything via CPAN is the most generic way to go.
Once DBD::SQLite is succesfully installed then, and only then, try the ‘make
fixdeps’ command again.

Failed Test Stat Wstat Total Fail List of Failed

t/06error.t 0 11 2 2 2
t/07busy.t 0 11 8 8 5-8
Failed 2/29 test scripts. 5/463 subtests failed.
Files=29, Tests=463, 7 wallclock secs ( 1.48 cusr + 1.45 csys = 2.93 CPU)
Failed 2/29 test programs. 5/463 subtests failed.
make[1]: *** [test_dynamic] Error 255
make[1]: Leaving directory `/root/.cpan/build/DBD-SQLite-1.14-6O4X44’
MSERGEANT/DBD-SQLite-1.14.tar.gz
/usr/bin/make test – NOT OK

–
Richard Foley
Ciao - shorter than aufwiedersehen

http://www.rfi.net/

On Tuesday 30 December 2008 21:41:58 Joseph Spenner wrote:

— On Tue, 12/30/08, Jesse Vincent jesse@bestpractical.com wrote:
From: Jesse Vincent jesse@bestpractical.com
Subject: Re: [rt-users] fixdeps errors: DBD::SQLite and DBIx::SearchBuilder
To: “Joseph Spenner” joseph85750@yahoo.com
Cc: rt-users@lists.bestpractical.com
Date: Tuesday, December 30, 2008, 12:35 PM

When trying to manually install DBD::SQLite, I see:

MSERGEANT/DBD-SQLite-1.14.tar.gz
/usr/bin/make test – NOT OK

Can you perhaps send the list the actual errors you got?

Yes. Here is the total output:

root@tuxtrack:/space/rt-packages/rt-3.8.1#
root@tuxtrack:/space/rt-packages/rt-3.8.1# make fixdeps
/usr/bin/perl ./sbin/rt-test-dependencies --verbose --install --with-mysql --with-fastcgi
perl:
>=5.8.3(5.10.0)…found
users:
rt group (apache)…found
bin owner (root)…found
libs owner (root)…found
libs group (bin)…found
web owner (apache)…found
web group (apache)…found
CLI dependencies:
Term::ReadKey…found
Getopt::Long >= 2.24…found
HTTP::Request::Common…found
Term::ReadLine…found
Text::ParseWords…found
LWP…found
CORE dependencies:
Class::ReturnValue >= 0.40…found
Text::Quoted >= 2.02…found
CSS::Squish >= 0.06…found
Encode >= 2.13…found
Module::Versions::Report >= 1.05…found
MIME::Entity >= 5.425…found
DBI >= 1.37…found
Locale::Maketext::Lexicon >= 0.32…found
Devel::StackTrace >= 1.19…found
Digest::base…found
Time::ParseDate…found
File::Temp >= 0.18…found
Locale::Maketext >= 1.06…found
Tree::Simple >= 1.04…found
Text::Template…found
Scalar::Util…found
HTML::Scrubber >= 0.08…found
File::Spec >= 0.8…found
Calendar::Simple…found
DBIx::SearchBuilder >= 1.54…MISSING
Mail::Mailer >= 1.57…found
File::ShareDir…found
Regexp::Common…found
Digest::MD5 >= 2.27…found
HTML::Entities…found
Cache::Simple::TimedExpiry…found
File::Glob…found
Locale::Maketext::Fuzzy…found
Time::HiRes…found
Text::Wrapper…found
Log::Dispatch >= 2.0…found
UNIVERSAL::require…found
Email::Address…found

Install module DBIx::SearchBuilder
Going to read /root/.cpan/Metadata
Database was generated on Tue, 30 Dec 2008 16:26:51 GMT
Running install for module ‘DBIx::SearchBuilder’
‘YAML’ not installed, falling back to Data::Dumper and Storable to read
prefs ‘/root/.cpan/prefs’
Running make for J/JE/JESSE/DBIx-SearchBuilder-1.54.tar.gz
CPAN: Digest::SHA loaded ok (v5.45)
CPAN: Compress::Zlib loaded ok (v2.008)
Checksum
for /root/.cpan/sources/authors/id/J/JE/JESSE/DBIx-SearchBuilder-1.54.tar.gz
ok
DBIx-SearchBuilder-1.54/
DBIx-SearchBuilder-1.54/Changes
DBIx-SearchBuilder-1.54/ex/
DBIx-SearchBuilder-1.54/ex/create_tables.pl
DBIx-SearchBuilder-1.54/ex/Example/
DBIx-SearchBuilder-1.54/ex/Example/Model/
DBIx-SearchBuilder-1.54/ex/Example/Model/Address.pm
DBIx-SearchBuilder-1.54/ex/Example/Model/Employee.pm
DBIx-SearchBuilder-1.54/inc/
DBIx-SearchBuilder-1.54/inc/Module/
DBIx-SearchBuilder-1.54/inc/Module/AutoInstall.pm
DBIx-SearchBuilder-1.54/inc/Module/Install/
DBIx-SearchBuilder-1.54/inc/Module/Install/AutoInstall.pm
DBIx-SearchBuilder-1.54/inc/Module/Install/Base.pm
DBIx-SearchBuilder-1.54/inc/Module/Install/Include.pm
DBIx-SearchBuilder-1.54/inc/Module/Install/Makefile.pm
DBIx-SearchBuilder-1.54/inc/Module/Install/Metadata.pm
DBIx-SearchBuilder-1.54/inc/Module/Install.pm
DBIx-SearchBuilder-1.54/Makefile.PL
DBIx-SearchBuilder-1.54/MANIFEST
DBIx-SearchBuilder-1.54/META.yml
DBIx-SearchBuilder-1.54/README
DBIx-SearchBuilder-1.54/ROADMAP
DBIx-SearchBuilder-1.54/SearchBuilder/
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/Informix.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/mysql.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/mysqlPP.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/ODBC.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/Oracle.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/Pg.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/SQLite.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle/Sybase.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Handle.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Record/
DBIx-SearchBuilder-1.54/SearchBuilder/Record/Cachable.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Record.pm
DBIx-SearchBuilder-1.54/SearchBuilder/SchemaGenerator.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Union.pm
DBIx-SearchBuilder-1.54/SearchBuilder/Unique.pm
DBIx-SearchBuilder-1.54/SearchBuilder.pm
DBIx-SearchBuilder-1.54/SIGNATURE
DBIx-SearchBuilder-1.54/t/
DBIx-SearchBuilder-1.54/t/00.load.t
DBIx-SearchBuilder-1.54/t/01basics.t
DBIx-SearchBuilder-1.54/t/01nocap_api.t
DBIx-SearchBuilder-1.54/t/01records.t
DBIx-SearchBuilder-1.54/t/01searches.t
DBIx-SearchBuilder-1.54/t/02order_outer.t
DBIx-SearchBuilder-1.54/t/02records_cachable.t
DBIx-SearchBuilder-1.54/t/02records_integers.t
DBIx-SearchBuilder-1.54/t/02records_object.t
DBIx-SearchBuilder-1.54/t/02searches_joins.t
DBIx-SearchBuilder-1.54/t/03rebless.t
DBIx-SearchBuilder-1.54/t/03transactions.t
DBIx-SearchBuilder-1.54/t/03versions.t
DBIx-SearchBuilder-1.54/t/10schema.t
DBIx-SearchBuilder-1.54/t/11schema_records.t
DBIx-SearchBuilder-1.54/t/pod.t
DBIx-SearchBuilder-1.54/t/testmodels.pl
DBIx-SearchBuilder-1.54/t/utils.pl
Warning (usually harmless): ‘YAML’ not installed, will not store persistent
state

CPAN.pm: Going to build J/JE/JESSE/DBIx-SearchBuilder-1.54.tar.gz

Cannot determine perl version info from SearchBuilder.pm
*** Module::AutoInstall version 1.03
*** Checking for Perl dependencies…
[Core Features]

Test::More …loaded. (0.72 >= 0.52)

DBD::SQLite …missing.

File::Temp …loaded. (0.18)

DBI …loaded. (1.607)

Want …loaded. (0.18)

Encode …loaded. (2.23 >= 1.99)

Class::ReturnValue …loaded. (0.55 >= 0.4)

Cache::Simple::TimedExpiry …loaded. (0.27 >= 0.21)

Clone …loaded. (0.30)
==> Auto-install the 1 mandatory module(s) from CPAN? [y]
[Lower case API]

capitalization …loaded. (0.03 >= 0.03)
[Schema generation]

DBIx::DBSchema …loaded. (0.36)

Class::Accessor …loaded. (0.31)

*** Since we’re running under CPANPLUS, I’ll just let it take care
of the dependency’s installation later.
*** Module::AutoInstall configuration finished.
Checking if your kit is complete…
Looks good
Warning: prerequisite DBD::SQLite 0 not found.
Writing Makefile for DBIx::SearchBuilder
Could not read ‘/root/.cpan/build/DBIx-SearchBuilder-1.54-mDfU3Y/META.yml’.
Falling back to other methods to determine prerequisites
---- Unsatisfied dependencies detected during ----
---- JESSE/DBIx-SearchBuilder-1.54.tar.gz ----
DBD::SQLite [requires]
Shall I follow them and prepend them to the queue
of modules we are processing right now? [yes]
Running make test
Delayed until after prerequisites
Running make install
Delayed until after prerequisites
Running install for module ‘DBD::SQLite’
‘YAML’ not installed, falling back to Data::Dumper and Storable to read
prefs ‘/root/.cpan/prefs’
Running make for M/MS/MSERGEANT/DBD-SQLite-1.14.tar.gz
Checksum
for /root/.cpan/sources/authors/id/M/MS/MSERGEANT/DBD-SQLite-1.14.tar.gz ok
DBD-SQLite-1.14/
DBD-SQLite-1.14/alter.c
DBD-SQLite-1.14/analyze.c
DBD-SQLite-1.14/attach.c
DBD-SQLite-1.14/auth.c
DBD-SQLite-1.14/btree.c
DBD-SQLite-1.14/btree.h
DBD-SQLite-1.14/btreeInt.h
DBD-SQLite-1.14/build.c
DBD-SQLite-1.14/callback.c
DBD-SQLite-1.14/Changes
DBD-SQLite-1.14/complete.c
DBD-SQLite-1.14/date.c
DBD-SQLite-1.14/dbdimp.c
DBD-SQLite-1.14/dbdimp.h
DBD-SQLite-1.14/delete.c
DBD-SQLite-1.14/expr.c
DBD-SQLite-1.14/fts2.c
DBD-SQLite-1.14/fts2.h
DBD-SQLite-1.14/fts2_hash.c
DBD-SQLite-1.14/fts2_hash.h
DBD-SQLite-1.14/fts2_icu.c
DBD-SQLite-1.14/fts2_porter.c
DBD-SQLite-1.14/fts2_tokenizer.c
DBD-SQLite-1.14/fts2_tokenizer.h
DBD-SQLite-1.14/fts2_tokenizer1.c
DBD-SQLite-1.14/func.c
DBD-SQLite-1.14/getsqlite.pl
DBD-SQLite-1.14/hash.c
DBD-SQLite-1.14/hash.h
DBD-SQLite-1.14/insert.c
DBD-SQLite-1.14/keywordhash.h
DBD-SQLite-1.14/legacy.c
DBD-SQLite-1.14/lib/
DBD-SQLite-1.14/lib/DBD/
DBD-SQLite-1.14/lib/DBD/SQLite.pm
DBD-SQLite-1.14/loadext.c
DBD-SQLite-1.14/main.c
DBD-SQLite-1.14/Makefile.PL
DBD-SQLite-1.14/malloc.c
DBD-SQLite-1.14/MANIFEST
DBD-SQLite-1.14/MANIFEST.SKIP
DBD-SQLite-1.14/META.yml
DBD-SQLite-1.14/opcodes.c
DBD-SQLite-1.14/opcodes.h
DBD-SQLite-1.14/os.c
DBD-SQLite-1.14/os.h
DBD-SQLite-1.14/os_common.h
DBD-SQLite-1.14/os_os2.c
DBD-SQLite-1.14/os_os2.h
DBD-SQLite-1.14/os_unix.c
DBD-SQLite-1.14/os_win.c
DBD-SQLite-1.14/pager.c
DBD-SQLite-1.14/pager.h
DBD-SQLite-1.14/parse.c
DBD-SQLite-1.14/parse.h
DBD-SQLite-1.14/ppport.h
DBD-SQLite-1.14/pragma.c
DBD-SQLite-1.14/prepare.c
DBD-SQLite-1.14/printf.c
DBD-SQLite-1.14/random.c
DBD-SQLite-1.14/README
DBD-SQLite-1.14/select.c
DBD-SQLite-1.14/SQLite.xs
DBD-SQLite-1.14/sqlite3.h
DBD-SQLite-1.14/sqlite3ext.h
DBD-SQLite-1.14/sqliteInt.h
DBD-SQLite-1.14/sqliteLimit.h
DBD-SQLite-1.14/SQLiteXS.h
DBD-SQLite-1.14/t/
DBD-SQLite-1.14/t/00basic.t
DBD-SQLite-1.14/t/01logon.t
DBD-SQLite-1.14/t/02cr_table.t
DBD-SQLite-1.14/t/03insert.t
DBD-SQLite-1.14/t/04select.t
DBD-SQLite-1.14/t/05tran.t
DBD-SQLite-1.14/t/06error.t
DBD-SQLite-1.14/t/07busy.t
DBD-SQLite-1.14/t/08create_function.t
DBD-SQLite-1.14/t/09create_aggregate.t
DBD-SQLite-1.14/t/10dsnlist.t
DBD-SQLite-1.14/t/11unicode.t
DBD-SQLite-1.14/t/20createdrop.t
DBD-SQLite-1.14/t/30insertfetch.t
DBD-SQLite-1.14/t/40bindparam.t
DBD-SQLite-1.14/t/40blobs.t
DBD-SQLite-1.14/t/40blobtext.t
DBD-SQLite-1.14/t/40listfields.t
DBD-SQLite-1.14/t/40nulls.t
DBD-SQLite-1.14/t/40numrows.t
DBD-SQLite-1.14/t/40prepcached.t
DBD-SQLite-1.14/t/50chopblanks.t
DBD-SQLite-1.14/t/50commit.t
DBD-SQLite-1.14/t/60metadata.t
DBD-SQLite-1.14/t/70schemachange.t
DBD-SQLite-1.14/t/90cppcomments.t
DBD-SQLite-1.14/t/99cleanup.t
DBD-SQLite-1.14/t/ak-dbd.t
DBD-SQLite-1.14/t/dbdadmin.t
DBD-SQLite-1.14/t/lib.pl
DBD-SQLite-1.14/t/SQLite.dbtest
DBD-SQLite-1.14/table.c
DBD-SQLite-1.14/tokenize.c
DBD-SQLite-1.14/trigger.c
DBD-SQLite-1.14/update.c
DBD-SQLite-1.14/utf.c
DBD-SQLite-1.14/util.c
DBD-SQLite-1.14/vacuum.c
DBD-SQLite-1.14/vdbe.c
DBD-SQLite-1.14/vdbe.h
DBD-SQLite-1.14/vdbeapi.c
DBD-SQLite-1.14/vdbeaux.c
DBD-SQLite-1.14/vdbeblob.c
DBD-SQLite-1.14/vdbefifo.c
DBD-SQLite-1.14/vdbeInt.h
DBD-SQLite-1.14/vdbemem.c
DBD-SQLite-1.14/vtab.c
DBD-SQLite-1.14/where.c
Warning (usually harmless): ‘YAML’ not installed, will not store persistent
state

CPAN.pm: Going to build M/MS/MSERGEANT/DBD-SQLite-1.14.tar.gz

Checking installed SQLite version…
Looks good
Checking if your kit is complete…
Looks good
Using DBI 1.607 (for perl 5.010000 on i486-linux-thread-multi) installed
in /usr/lib/perl5/vendor_perl/5.10.0/i486-linux-thread-multi/auto/DBI/
Writing Makefile for DBD::SQLite
Could not read ‘/root/.cpan/build/DBD-SQLite-1.14-6O4X44/META.yml’. Falling
back to other methods to determine prerequisites
make[1]: Entering directory `/root/.cpan/build/DBD-SQLite-1.14-6O4X44’
cp lib/DBD/SQLite.pm blib/lib/DBD/SQLite.pm
/usr/bin/perl5.10.0 -p -e “s/~DRIVER~/SQLite/g” /usr/lib/perl5/vendor_perl/5.10.0/i486-linux-thread-multi/auto/DBI/Driver.xst
SQLite.xsi
/usr/bin/perl5.10.0 /usr/lib/perl5/5.10.0/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.10.0/ExtUtils/typemap
SQLite.xs > SQLite.xsc && mv SQLite.xsc SQLite.c

cc -c -I. -I/usr/lib/perl5/vendor_perl/5.10.0/i486-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION="1.14" -DXS_VERSION="1.14" -fPIC “-I/usr/lib/perl5/5.10.0/i486-linux-thread-multi/CORE” -DSQLITE_CORE -DSQLITE_ENABLE_FTS2 -DNDEBUG=1 -DSQLITE_PTR_SZ=4 -DHAVE_USLEEP=1
SQLite.c

cc -c -I. -I/usr/lib/perl5/vendor_perl/5.10.0/i486-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION="1.14" -DXS_VERSION="1.14" -fPIC “-I/usr/lib/perl5/5.10.0/i486-linux-thread-multi/CORE” -DSQLITE_CORE -DSQLITE_ENABLE_FTS2 -DNDEBUG=1 -DSQLITE_PTR_SZ=4 -DHAVE_USLEEP=1
dbdimp.c

Running Mkbootstrap for DBD::SQLite ()
chmod 644 SQLite.bs
rm -f blib/arch/auto/DBD/SQLite/SQLite.so
LD_RUN_PATH=“/usr/lib”
cc -shared -O2 -march=i486 -mtune=i686 -L/usr/local/lib SQLite.o
dbdimp.o -o blib/arch/auto/DBD/SQLite/SQLite.so
-lsqlite3 \

chmod 755 blib/arch/auto/DBD/SQLite/SQLite.so
cp SQLite.bs blib/arch/auto/DBD/SQLite/SQLite.bs
chmod 644 blib/arch/auto/DBD/SQLite/SQLite.bs
Manifying blib/man3/DBD::SQLite.3
make[1]: Leaving directory /root/.cpan/build/DBD-SQLite-1.14-6O4X44' MSERGEANT/DBD-SQLite-1.14.tar.gz /usr/bin/make -- OK Warning (usually harmless): 'YAML' not installed, will not store persistent state Running make test make[1]: Entering directory /root/.cpan/build/DBD-SQLite-1.14-6O4X44’

PERL_DL_NONLAZY=1 /usr/bin/perl5.10.0 “-MExtUtils::Command::MM” “-e” “test_harness(0, ‘blib/lib’, ‘blib/arch’)”
t/*.t

t/00basic…Name “DBD::SQLite::sqlite_version” used only once:
possible typo at /usr/lib/perl5/5.10.0/i486-linux-thread-multi/DynaLoader.pm
line 226.
t/00basic…ok
t/01logon…ok
t/02cr_table…ok
t/03insert…ok
t/04select…ok
t/05tran…ok
t/06error…dubious
Test returned status 0 (wstat 11, 0xb)
DIED. FAILED test 2
Failed 1/2 tests, 50.00% okay
t/07busy…dubious
Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 5-8
Failed 4/8 tests, 50.00% okay
t/08create_function…ok
t/09create_aggregate…ok
t/10dsnlist…ok
t/11unicode…ok
t/20createdrop…ok
t/30insertfetch…ok
t/40bindparam…ok
t/40blobs…ok
t/40blobtext…ok
t/40listfields…ok
t/40nulls…ok
t/40numrows…ok
t/40prepcached…ok
t/50chopblanks…ok
t/50commit…ok
t/60metadata…ok
t/70schemachange…ok
t/90cppcomments…ok
t/99cleanup…ok
t/ak-dbd…ok
t/dbdadmin…ok
Failed Test Stat Wstat Total Fail List of Failed

t/06error.t 0 11 2 2 2
t/07busy.t 0 11 8 8 5-8
Failed 2/29 test scripts. 5/463 subtests failed.
Files=29, Tests=463, 7 wallclock secs ( 1.48 cusr + 1.45 csys = 2.93 CPU)
Failed 2/29 test programs. 5/463 subtests failed.
make[1]: *** [test_dynamic] Error 255
make[1]: Leaving directory `/root/.cpan/build/DBD-SQLite-1.14-6O4X44’
MSERGEANT/DBD-SQLite-1.14.tar.gz
/usr/bin/make test – NOT OK
//hint// to see the cpan-testers results for installing this module, try:
reports MSERGEANT/DBD-SQLite-1.14.tar.gz
Warning (usually harmless): ‘YAML’ not installed, will not store persistent
state
Running make install
make test had returned bad status, won’t install without force
Running make for J/JE/JESSE/DBIx-SearchBuilder-1.54.tar.gz
Has already been unwrapped into
directory /root/.cpan/build/DBIx-SearchBuilder-1.54-mDfU3Y

CPAN.pm: Going to build J/JE/JESSE/DBIx-SearchBuilder-1.54.tar.gz

Warning: Prerequisite ‘DBD::SQLite => 0’
for ‘J/JE/JESSE/DBIx-SearchBuilder-1.54.tar.gz’ failed when
processing ‘M/MS/MSERGEANT/DBD-SQLite-1.14.tar.gz’ with ‘make_test => NO’.
Continuing, but chances to succeed are limited.
make[1]: Entering directory
`/root/.cpan/build/DBIx-SearchBuilder-1.54-mDfU3Y’
/usr/bin/perl5.10.0 “-Iinc”
Makefile.PL --config= --installdeps=DBD::SQLite,0
Cannot determine perl version info from SearchBuilder.pm

*** Since we’re running under CPANPLUS, I’ll just let it take care
of the dependency’s installation later.
cp SearchBuilder.pm blib/lib/DBIx/SearchBuilder.pm
cp SearchBuilder/Handle.pm blib/lib/DBIx/SearchBuilder/Handle.pm
cp SearchBuilder/Handle/mysqlPP.pm
blib/lib/DBIx/SearchBuilder/Handle/mysqlPP.pm
cp SearchBuilder/Handle/mysql.pm blib/lib/DBIx/SearchBuilder/Handle/mysql.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/Handle/Oracle.pm
blib/lib/DBIx/SearchBuilder/Handle/Oracle.pm
cp SearchBuilder/Record/Cachable.pm
blib/lib/DBIx/SearchBuilder/Record/Cachable.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/Pg.pm blib/lib/DBIx/SearchBuilder/Handle/Pg.pm
cp SearchBuilder/Handle/ODBC.pm blib/lib/DBIx/SearchBuilder/Handle/ODBC.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::mysql.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::mysqlPP.3
Manifying blib/man3/DBIx::SearchBuilder::Handle.3
Manifying blib/man3/DBIx::SearchBuilder.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::Sybase.3
Manifying blib/man3/DBIx::SearchBuilder::Union.3
Manifying blib/man3/DBIx::SearchBuilder::Unique.3
Manifying blib/man3/DBIx::SearchBuilder::Record::Cachable.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::Oracle.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::Informix.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::SQLite.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::ODBC.3
Manifying blib/man3/DBIx::SearchBuilder::Handle::Pg.3
Manifying blib/man3/DBIx::SearchBuilder::Record.3
Manifying blib/man3/DBIx::SearchBuilder::SchemaGenerator.3
make[1]: Leaving directory
/root/.cpan/build/DBIx-SearchBuilder-1.54-mDfU3Y' JESSE/DBIx-SearchBuilder-1.54.tar.gz /usr/bin/make -- OK Warning (usually harmless): 'YAML' not installed, will not store persistent state Running make test make[1]: Entering directory /root/.cpan/build/DBIx-SearchBuilder-1.54-mDfU3Y’
/usr/bin/perl5.10.0 “-Iinc”
Makefile.PL --config= --installdeps=DBD::SQLite,0
Cannot determine perl version info from SearchBuilder.pm

*** Since we’re running under CPANPLUS, I’ll just let it take care
of the dependency’s installation later.

PERL_DL_NONLAZY=1 /usr/bin/perl5.10.0 “-MExtUtils::Command::MM” “-e” “test_harness(0, ‘inc’, ‘blib/lib’, ‘blib/arch’)”
t/00.load.t t/01basics.t t/01nocap_api.t t/01records.t t/01searches.t
t/02order_outer.t t/02records_cachable.t t/02records_integers.t
t/02records_object.t t/02searches_joins.t t/03rebless.t t/03transactions.t
t/03versions.t t/10schema.t t/11schema_records.t t/pod.t

t/00.load…ok
1/12 skipped: various reasons
t/01basics…ok
t/01nocap_api…ok
t/01records…ok
65/65 skipped: various reasons
t/01searches…ok
76/76 skipped: various reasons
t/02order_outer…ok
98/98 skipped: various reasons
t/02records_cachable…ok
16/16 skipped: various reasons
t/02records_integers…ok
33/33 skipped: various reasons
t/02records_object…ok
11/11 skipped: various reasons
t/02searches_joins…ok
47/47 skipped: various reasons
t/03rebless…ok
4/4 skipped: various reasons
t/03transactions…ok
42/42 skipped: various reasons
t/03versions…ok
6/6 skipped: various reasons
t/10schema…ok
14/17 skipped: various reasons
t/11schema_records…ok
63/63 skipped: various reasons
t/pod…ok
All tests successful, 476 subtests skipped.
Files=16, Tests=511, 4 wallclock secs ( 2.42 cusr + 1.55 csys = 3.97 CPU)
make[1]: Leaving directory
`/root/.cpan/build/DBIx-SearchBuilder-1.54-mDfU3Y’
JESSE/DBIx-SearchBuilder-1.54.tar.gz
Tests succeeded but one dependency not OK (DBD::SQLite)
Warning (usually harmless): ‘YAML’ not installed, will not store persistent
state
JESSE/DBIx-SearchBuilder-1.54.tar.gz
[dependencies] – NA
Running make install
make test had returned bad status, won’t install without force
DASHBOARDS dependencies:
HTML::RewriteAttributes >= 0.02…found
MIME::Types…found
FASTCGI dependencies:
CGI::Fast…found
CGI >= 3.38…found
FCGI…found
GD dependencies:
GD::Text…found
GD…found
GD::Graph…found
GPG dependencies:
PerlIO::eol…found
GnuPG::Interface…found
ICAL dependencies:
Data::ICal…MISSING

Install module Data::ICal
Data::ICal is up to date (0.13).
MAILGATE dependencies:
Pod::Usage…found
HTML::TreeBuilder…found
Getopt::Long…found
HTML::FormatText…found
LWP::UserAgent…found
MASON dependencies:
Storable >= 2.08…found
CSS::Squish >= 0.06…found
Apache::Session >= 1.53…found
Errno…found
Devel::StackTrace >= 1.19…found
CGI::Cookie >= 1.20…found
Text::WikiFormat >= 0.76…found
XML::RSS >= 1.05…found
HTML::Mason >= 1.36…found
Digest::MD5 >= 2.27…found
MYSQL dependencies:
DBD::mysql >= 2.1018…found
SMTP dependencies:
Net::SMTP…found
STANDALONE dependencies:
Net::Server::PreFork…found
Net::Server…found
HTTP::Server::Simple >= 0.34…found
HTTP::Server::Simple::Mason >= 0.09…found

SOME DEPENDENCIES WERE MISSING.
ICAL missing dependencies:
Data::ICal…MISSING
CORE missing dependencies:
DBIx::SearchBuilder >= 1.54…MISSING
make: *** [fixdeps] Error 1
root@tuxtrack:/space/rt-packages/rt-3.8.1#

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

Joseph_Spenner · December 31, 2008, 4:55pm

Ruslan:
Thanks for the tip. Forcing SQLite succeeded, and ‘make fixdeps’ took care of the rest. I think I’m almost there.
My next/current problem is with FastCGI. My rt-test-dependencies indicate it should work. However, when I add these lines to my httpd.conf as described in the doc at http://wiki.bestpractical.com/view/FastCGIConfiguration:

Tell FastCGI to put its temporary files somewhere sane.

FastCgiIpcDir /tmp

Number of processes is tunable, but you need at least 3 or 4

FastCgiServer /opt/rt3/bin/mason_handler.fcgi -idle-timeout 120 -processes 4

I get errors when trying to start apache:

“Invalid command ‘FastCgiIpcDir’, perhaps misspelled or defined by a module not included in the server configuration”

I’m using the apache which came standard on my slackware 12.2 distribution.

root@tuxtrack:/space/rt-packages# httpd -V
Server version: Apache/2.2.10 (Unix)
Server built: Oct 22 2008 17:54:27
Server’s Module Magic Number: 20051115:18
Server loaded: APR 1.3.3, APR-Util 1.3.4
Compiled using: APR 1.3.3, APR-Util 1.3.4
Architecture: 32-bit
Server MPM: Prefork
threaded: no
forked: yes (variable process count)
Server compiled with…
-D APACHE_MPM_DIR=“server/mpm/prefork”
-D APR_HAS_SENDFILE
-D APR_HAS_MMAP
-D APR_HAVE_IPV6 (IPv4-mapped addresses enabled)
-D APR_USE_SYSVSEM_SERIALIZE
-D APR_USE_PTHREAD_SERIALIZE
-D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
-D APR_HAS_OTHER_CHILD
-D AP_HAVE_RELIABLE_PIPED_LOGS
-D DYNAMIC_MODULE_LIMIT=128
-D HTTPD_ROOT=“/usr”
-D SUEXEC_BIN=“/usr/bin/suexec”
-D DEFAULT_PIDLOG=“/var/run/httpd/httpd.pid”
-D DEFAULT_SCOREBOARD=“logs/apache_runtime_status”
-D DEFAULT_LOCKFILE=“/var/run/httpd/accept.lock”
-D DEFAULT_ERRORLOG=“logs/error_log”
-D AP_TYPES_CONFIG_FILE=“/etc/httpd/mime.types”
-D SERVER_CONFIG_FILE=“/etc/httpd/httpd.conf”
root@tuxtrack:/space/rt-packages#

From what I can tell, the available modules in /usr/lib/httpd/modules/ do not include a mod_fastcgi.so (name?). I only see mod_cgi.so. I tried downloading and compiling the module from http://www.fastcgi.com/drupal/ which created a libfcgi.so. I copied that into /usr/lib/httpd/modules/ and made an entry in httpd.conf:

LoadModule libfcgi lib/httpd/modules/libfcgi.so

But it didn’t like that at all:

httpd: Syntax error on line 54 of /etc/httpd/httpd.conf: Can’t locate API module structure `libfcgi’ in file /usr/lib/httpd/modules/libfcgi.so: /usr/lib/httpd/modules/libfcgi.so: undefined symbol: libfcgi

Perhaps I’m heading down the wrong path.
Any help would be great.

Thanks!— On Wed, 12/31/08, Ruslan Zakirov ruslan.zakirov@gmail.com wrote:

It’s ok to force install DBD::SQLite, I saw this errors too. This
module is required to test DBIx::SearchBuilder functionality only.

Joseph_Spenner · December 31, 2008, 6:07pm

Ruslan:
Thanks for the tip. Forcing SQLite succeeded, and ‘make fixdeps’ took care of the rest. I think I’m almost there.
My next/current problem is with FastCGI. My rt-test-dependencies indicate it should work. However, when I add these lines to my httpd.conf as described in the doc at http://wiki.bestpractical.com/view/FastCGIConfiguration:

Tell FastCGI to put its temporary files somewhere sane.

FastCgiIpcDir /tmp

Number of processes is tunable, but you need at least 3 or 4

FastCgiServer /opt/rt3/bin/mason_handler.fcgi -idle-timeout 120 -processes 4

I get errors when trying to start apache:

“Invalid command ‘FastCgiIpcDir’, perhaps misspelled or defined by a module not included in the server configuration”

I’m using the
apache which came standard on my slackware 12.2 distribution.

I believe I have figured it out. I did the following:

downloaded http://www.fastcgi.com/dist/mod_fastcgi-2.4.6.tar.gz

compiled it:

root@tuxtrack:/space/rt-packages/mod_fastcgi-2.4.6# apxs -o mod_fastcgi.so -c *.c

copied it to a place where apache will find it:

root@tuxtrack:/space/rt-packages/mod_fastcgi-2.4.6# cp .libs/mod_fastcgi.so /usr/lib/httpd/modules/mod_fastcgi.so

Updated httpd.conf with the VirtualHost entry and FastCGI entries as described in the documentation, as well as added:

LoadModule fastcgi_module lib/httpd/modules/mod_fastcgi.so

Also had to add (to get rid of “Permission Denied” error):

<Directory “/opt/rt3”>
Order allow,deny
Allow from all

Looks good so far.

Thanks for listening!

Joseph_Spenner · January 6, 2009, 5:48pm

I successfully migrated a RT 2.0.15 system to RT 3.8.1. Everything worked quite well, with only 2 small stumbling blocks:

The importer didn’t like to import tickets/queues that were disabled. So, I re-enabled all the queues, did a new dump/import. All went well.
I had to modify how mysql started:
–max_allowed_packet=128M as recommended at http://wiki.bestpractical.com/view/PgToMySQL to get rid of a ‘max allowed packet’ error I got.

I have a question/issue with RT3.8.1 though. On the main menu, “RT at a glance”, everything looks great. However, the section titles: “10 highest priority tickets I own”, “10 newest unowned tickets”, and “Bookmarked Tickets” are hyperlinks which give an error when clicked. They appear to be trying to go to a ‘localhost’ address:

http://localhost/Search/Results.html?Format='<a%20href%3D"%2FTicket%2FDisplay.html%3Fid%3D__id__">__id__<%2Fa>%2FTITLE%3A%23'%2C'<a%20href%3D"%2FTicket%2FDisplay.html%3Fid%3D__id__">__Subject__<%2Fa>%2FTITLE%3ASubject'%2CPriority%2C%20QueueName%2C%20ExtendedStatus&Order=DESC&OrderBy=Priority&Query=%20Owner%20%3D%20'__CurrentUser__'%20AND%20(%20Status%20%3D%20'new'%20OR%20Status%20%3D%20'open')

http://localhost/Search/Results.html?Format='<a%20href%3D"%2FTicket%2FDisplay.html%3Fid%3D__id__">__id__<%2Fa>%2FTITLE%3A%23'%2C'<a%20href%3D"%2FTicket%2FDisplay.html%3Fid%3D__id__">__Subject__<%2Fa>%2FTITLE%3ASubject'%2CQueueName%2C%20ExtendedStatus%2C%20CreatedRelative%2C%20'<A%20HREF%3D"%2FTicket%2FDisplay.html%3FAction%3DTake%26id%3D__id__">Take<%2Fa>%2FTITLE%3ANBSP'&Order=DESC&OrderBy=Created&Query=%20Owner%20%3D%20'Nobody'%20AND%20(%20Status%20%3D%20'new'%20OR%20Status%20%3D%20'open')

http://localhost/Search/Results.html?Format='<a%20href%3D"%2FTicket%2FDisplay.html%3Fid%3D__id__">__id__<%2Fa>%2FTITLE%3A%23'%2C'<a%20href%3D"%2FTicket%2FDisplay.html%3Fid%3D__id__">__Subject__<%2Fa>%2FTITLE%3ASubject'%2CPriority%2C%20QueueName%2C%20ExtendedStatus%2C%20Bookmark&Order=DESC&OrderBy=LastUpdated&Query=id%20%3D%20'__Bookmarked__'&Rows=999

When the error is on the screen, if I replace ‘localhost’ with the system/ip and reload, the section comes up correctly.

Where is it getting ‘localhost’ ?

Thanks!

Duane_Hill · January 6, 2009, 6:06pm

I successfully migrated a RT 2.0.15 system to RT 3.8.1. Everything worked quite
well, with only 2 small stumbling blocks:

The importer didn’t like to import tickets/queues that were disabled. So, I
re-enabled all the queues, did a new dump/import. All went well.

I had to modify how mysql started:

–max_allowed_packet=128M
as recommended at http://wiki.bestpractical.com/view/PgToMySQL to get rid of
a ‘max allowed packet’ error I got.

I have a question/issue with RT3.8.1 though. On the main menu, “RT at a glance”,
everything looks great. However, the section titles: “10 highest priority
tickets I own”, “10 newest unowned tickets”, and “Bookmarked Tickets” are
hyperlinks which give an error when clicked. They appear to be trying to go to a
‘localhost’ address:

http://localhost/Search/Results.html?Format='<a%20href%3D"%2FTicket%2FDispl
ay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%2FTITLE%3A%23%27%2C%27%3Ca%20href%3D%
22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%2FTITLE%3ASub
ject%27%2CPriority%2C%20QueueName%2C%20ExtendedStatus&Order=DESC&OrderBy=Priority
&Query=%20Owner%20%3D%20%27__CurrentUser__%27%20AND%20(%20Status%20%3D%20%27new%2
7%20OR%20Status%20%3D%20%27open%27)

http://localhost/Search/Results.html?Format='<a%20href%3D"%2FTicket%2FDispl
ay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%2FTITLE%3A%23%27%2C%27%3Ca%20href%3D%
22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%2FTITLE%3ASub
ject%27%2CQueueName%2C%20ExtendedStatus%2C%20CreatedRelative%2C%20%27%3CA%20HREF%
3D%22%2FTicket%2FDisplay.html%3FAction%3DTake%26id%3D__id__%22%3ETake%3C%2Fa%3E%2
FTITLE%3ANBSP%27&Order=DESC&OrderBy=Created&Query=%20Owner%20%3D%20%27Nob
ody%27%20AND%20(%20Status%20%3D%20%27new%27%20OR%20Status%20%3D%20%27open%27)

http://localhost/Search/Results.html?Format='<a%20href%3D"%2FTicket%2FDispl
ay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%2FTITLE%3A%23%27%2C%27%3Ca%20href%3D%
22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%2FTITLE%3ASub
ject%27%2CPriority%2C%20QueueName%2C%20ExtendedStatus%2C%20Bookmark&Order=DESC&Or
derBy=LastUpdated&Query=id%20%3D%20%27__Bookmarked__%27&Rows=999

When the error is on the screen, if I replace ‘localhost’ with the system/ip and
reload, the section comes up correctly.

Where is it getting ‘localhost’ ?

The following parameter controls what is used in the URL:

 Set($WebDomain, 'localhost');

Add to RT_SiteConfig.pm and change localhost to the IP or hostname.

Joseph_Spenner · January 6, 2009, 6:15pm

Where is it getting ‘localhost’ ?

The following parameter controls what is used in the URL:

 Set($WebDomain, 'localhost');

Add to RT_SiteConfig.pm and change localhost to the IP or hostname.

That was it. Thanks!
Curious how all the other links seemed to know where to go…

Joseph_Spenner · January 6, 2009, 9:35pm

I successfully migrated a RT 2.0.15 system to RT 3.8.1. Everything worked quite well, with only 2 small stumbling blocks:

The importer didn’t like to import tickets/queues that were disabled. So, I re-enabled all the queues, did a new dump/import. All went well.
I had to modify how mysql started:
–max_allowed_packet=128M as recommended at http://wiki.bestpractical.com/view/PgToMySQL to get rid of a ‘max allowed packet’ error I got.

What is the recommended max_allowed_packet size for RT3? Is there a performance hit making it too big, as I set above? The default value (16M) would cause a failure during the import, but I’m not sure how it would behave now that the import is finished. I don’t want it to crash later though.

Joseph_Spenner · January 7, 2009, 8:52pm

–max_allowed_packet=128M as recommended at
http://wiki.bestpractical.com/view/PgToMySQL to get rid of
a ‘max allowed packet’ error I got.

What is the recommended max_allowed_packet size for RT3?
Is there a performance hit making it too big, as I set
above? The default value (16M) would cause a failure during
the import, but I’m not sure how it would behave now
that the import is finished. I don’t want it to crash
later though.

I was also curious about more generic mysql settings. Does anyone have some /etc/my.conf recommendations? On my distro (slackware 12.2) there exists:

/etc/my-huge.cnf
/etc/my-large.cnf
/etc/my-medium.cnf
/etc/my-small.cnf

My RT has about 13000 tickets, and isn’t very busy. However, since my test upgrade the new RT3 is quite a bit slower in response time compared to my RT2. Ticket content loads slowly. I’m also configured with FastCGI. Should I expect this to be slower than mod_perl ?

Joseph_Spenner · January 8, 2009, 3:08pm

I recently posted regarding some performance issues after a migration from RT2.0.15 to RT3.8.1. I originally thought it might be a mysql issue, but I think it’s apache and the Mason FCGI. The system will be practically 100% idle until I view a ticket. While the ticket is slowly coming up in the browser, the system goes to 0% idle, with the “mason_handler.fcgi” taking 3/4 of the CPU and memory, and mysql taking most of the rest. This is currently running on a VirtualBox with 512M memory. Is this not sufficient memory? Or is something else not tuned correctly?
Any ideas would be great.

Both standard with Slackware 12.2:

Apache = 2.2.10
mysql = 5.0.67

Thanks!