Hello.
My RT-3.6.7 working fine under FreeBSD 7-STABLE x86_64 with:
- Apache 2.2.8
- mod_perl2-2.0.3_3,3
- MySQL 5.0.51-log
- all p5 and other packages from lastest FreeBSD ports
current database 2 years old and have size ~500MB and attachments
have 112888 elements
Alexander, can you tell us if anything shows up in the mysql error
logs? Also, what version of DBD::mysql do you have installed?
any idea in wich way to move?
i also try to clean install (3.8.1 release) in differnet db on same host and i got following:
make initialize-database
/usr/bin/perl sbin/rt-setup-database --action init --dba root --prompt-for-dba-password
In order to create or update your RT database, this script needs to connect to your mysql instance on localhost as root
Please specify that user’s database password below. If the user has no database
password, just press return.
Password:
Working with:
Type: mysql
Host: localhost
Name: rt3_2
User: rt_user
DBA: root
Now creating a mysql database rt3_2 for RT.
Done.
Now populating database schema.
Done.
Now inserting database ACLs
Granting access to rt_user@‘localhost’ on rt3_2.
Done.
Now inserting RT core system objects
[Tue Aug 19 01:39:41 2008] [warning]: DBD::mysql::st execute failed: MySQL server has gone away
at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505. (/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)
[Tue Aug 19 01:39:41 2008] [warning]: RT::Handle=HASH(0x297fae8) couldn’t execute the query ‘INSERT INTO GroupMembers (GroupId, MemberId)
VALUES (?, ?)’ at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x297fae8)’, ‘INSERT INTO GroupMembers (GroupId, MemberId) VALUES (?, ?)’, 2, 1) called
at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 353
DBIx::SearchBuilder::Handle::Insert(‘RT::Handle=HASH(0x297fae8)’, ‘GroupMembers’, ‘GroupId’, 2, ‘MemberId’, 1) called
at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/mysql.pm line 36
DBIx::SearchBuilder::Handle::mysql::Insert(‘RT::Handle=HASH(0x297fae8)’, ‘GroupMembers’, ‘GroupId’, 2, ‘MemberId’, 1) called
at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1293
DBIx::SearchBuilder::Record::Create(‘RT::GroupMember=HASH(0x306e568)’, ‘GroupId’, 2, ‘MemberId’, 1) called at /usr/local/rt3/lib/RT/Record.pm line 289
RT::Record::Create(‘RT::GroupMember=HASH(0x306e568)’, ‘GroupId’, 2, ‘MemberId’, 1) called at /usr/local/rt3/lib/RT/GroupMember_Overlay.pm line 251
RT::GroupMember::_StashUser(‘RT::GroupMember=HASH(0x306e568)’, ‘Group’, ‘RT::Principal=HASH(0x30478b8)’, ‘Member’, ‘RT::Principal=HASH(0x2f5ff78)’)
called at /usr/local/rt3/lib/RT/Group_Overlay.pm line 524
RT::Group::_CreateACLEquivalenceGroup(‘RT::Group=HASH(0x3004fa8)’, ‘RT::Principal=HASH(0x2f5ff78)’) called at /usr/local/rt3/lib/RT/User_Overlay.pm
line 397
RT::User::_BootstrapCreate(‘RT::User=HASH(0x2f601d8)’, ‘Name’, ‘RT_System’, ‘RealName’, ‘The RT System itself’, ‘Comments’, ‘Do not delete or modify
this user. It is integral to RT's in…’, ‘Creator’, 1, …) called at /usr/local/rt3/lib/RT/Handle.pm line 556
RT::Handle::InsertInitialData(‘RT::Handle=HASH(0x297fae8)’) called at sbin/rt-setup-database line 240
main::action_coredata(‘prompt-for-dba-password’, 1, ‘action’, ‘init’, ‘dba’, ‘root’) called at sbin/rt-setup-database line 166
(/usr/local/lib/perl5/5.8.8/Carp.pm:272)
[Tue Aug 19 01:39:41 2008] [crit]: Couldn’t add the user to his own acl equivalence group: (/usr/local/rt3/lib/RT/Group_Overlay.pm:528)
[Tue Aug 19 01:39:42 2008] [warning]: DBD::mysql::st execute failed: MySQL server has gone away
at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505. (/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)
[Tue Aug 19 01:39:42 2008] [warning]: RT::Handle=HASH(0x297fae8) couldn’t execute the query 'DELETE FROM Groups WHERE id=? ’
at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x297fae8)’, 'DELETE FROM Groups WHERE id=? ', 2) called
at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1326
DBIx::SearchBuilder::Record::__Delete(‘RT::Group=HASH(0x3004fa8)’) called at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record/Cachable.pm
line 152
DBIx::SearchBuilder::Record::Cachable::__Delete(‘RT::Group=HASH(0x3004fa8)’) called
at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1306
DBIx::SearchBuilder::Record::Delete(‘RT::Group=HASH(0x3004fa8)’) called at /usr/local/rt3/lib/RT/Record.pm line 115
RT::Record::Delete(‘RT::Group=HASH(0x3004fa8)’) called at /usr/local/rt3/lib/RT/Group_Overlay.pm line 530
RT::Group::_CreateACLEquivalenceGroup(‘RT::Group=HASH(0x3004fa8)’, ‘RT::Principal=HASH(0x2f5ff78)’) called at /usr/local/rt3/lib/RT/User_Overlay.pm
line 397
RT::User::_BootstrapCreate(‘RT::User=HASH(0x2f601d8)’, ‘Name’, ‘RT_System’, ‘RealName’, ‘The RT System itself’, ‘Comments’, ‘Do not delete or modify
this user. It is integral to RT's in…’, ‘Creator’, 1, …) called at /usr/local/rt3/lib/RT/Handle.pm line 556
RT::Handle::InsertInitialData(‘RT::Handle=HASH(0x297fae8)’) called at sbin/rt-setup-database line 240
main::action_coredata(‘prompt-for-dba-password’, 1, ‘action’, ‘init’, ‘dba’, ‘root’) called at sbin/rt-setup-database line 166
(/usr/local/lib/perl5/5.8.8/Carp.pm:272)
[Tue Aug 19 01:39:42 2008] [warning]: Use of uninitialized value in subroutine entry at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm
line 1328. (/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm:1328)
[Tue Aug 19 01:39:42 2008] [warning]: Attempted to rollback a transaction with none in progress
at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 747
DBIx::SearchBuilder::Handle::EndTransaction(‘RT::Handle=HASH(0x297fae8)’, ‘Action’, ‘rollback’, ‘Force’, ‘undef’) called
at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 795
DBIx::SearchBuilder::Handle::Rollback(‘RT::Handle=HASH(0x297fae8)’) called at /usr/local/rt3/lib/RT/User_Overlay.pm line 400
RT::User::_BootstrapCreate(‘RT::User=HASH(0x2f601d8)’, ‘Name’, ‘RT_System’, ‘RealName’, ‘The RT System itself’, ‘Comments’, ‘Do not delete or modify
this user. It is integral to RT's in…’, ‘Creator’, 1, …) called at /usr/local/rt3/lib/RT/Handle.pm line 556
RT::Handle::InsertInitialData(‘RT::Handle=HASH(0x297fae8)’) called at sbin/rt-setup-database line 240
main::action_coredata(‘prompt-for-dba-password’, 1, ‘action’, ‘init’, ‘dba’, ‘root’) called at sbin/rt-setup-database line 166
(/usr/local/lib/perl5/5.8.8/Carp.pm:272)
[Tue Aug 19 01:39:42 2008] [crit]: Couldn’t stash the user in groupmembers (/usr/local/rt3/lib/RT/User_Overlay.pm:401)
Couldn’t finish ‘coredata’ step.
ERROR: Could not create user
*** Error code 255
and have no errors in logs at this time.
next p5-modules are installed:
pkg_info | grep ^p5
p5-Algorithm-Diff-1.1902 Perl interface to compute differences between two objects
p5-Apache-DBI-1.06 DBI persistent connection, authentication and authorization
p5-Apache-Session-1.86 A persistence framework for session data
p5-Archive-Tar-1.38_1 Perl module for creation and manipulation of tar files
p5-Array-Compare-1.16 Perl extension for comparing arrays
p5-Authen-SASL-2.12 Perl5 module for SASL authentication
p5-BSD-Resource-1.2901 Perl module to access BSD resource limit and priority funct
p5-CGI.pm-3.38,1 Simple Common Gateway Interface Class for Perl
p5-CSS-Squish-0.07 Compact many CSS files into one big file
p5-Cache-2.04_1 A Perl Cache interface
p5-Cache-Cache-1.05_1 Cache::Cache – Perl Cache interface
p5-Cache-Simple-TimedExpiry-0.27 A lightweight cache with timed expiration
p5-Calendar-Simple-1.20 Perl extension to create simple calendars
p5-Class-Accessor-0.31 Automated accessor generation
p5-Class-Accessor-Chained-0.01 make chained accessors
p5-Class-Container-0.12 Glues object frameworks together transparently
p5-Class-Data-Inheritable-0.08 Inheritable, overridable class data
p5-Class-Factory-Util-1.7 Utility functions for (factory) classes
p5-Class-Inspector-1.23 Provides information about classes
p5-Class-MethodMaker-2.12 Perl module for creating generic methods
p5-Class-ReturnValue-0.55 A return-value object that can be treated as a boolean,arra
p5-Class-Singleton-1.4 Perl module that describes a singular object class
p5-Clone-0.28 Clone - recursively copy Perl datatypes
p5-Compress-Raw-Zlib-2.012 Low-Level Interface to zlib compression library
p5-Compress-Zlib-2.012 Perl5 interface to zlib compression library
p5-Convert-BinHex-1.119 Perl module to extract data from Macintosh BinHex files
p5-Crypt-OpenSSL-Bignum-0.04 OpenSSL’s multiprecision integer arithmetic
p5-Crypt-OpenSSL-RSA-0.25 Perl5 module to RSA encode and decode strings using OpenSSL
p5-Crypt-OpenSSL-Random-0.04 Perl5 interface to the OpenSSL pseudo-random number generat
p5-DBD-mysql50-4.006 MySQL 5.0 driver for the Perl5 Database Interface (DBI)
p5-DBI-1.60.4 The perl5 Database Interface. Required for DBD::* modules
p5-DBIx-DBSchema-0.36 An OO-interface to database schemas
p5-DBIx-SearchBuilder-1.54 Perl extension for easy SQL SELECT Statement generation
p5-Data-ICal-0.13_1 Data::ICal - Generates iCalendar (RFC 2445) calendar files
p5-DateTime-0.43.02 A date and time object
p5-DateTime-Format-Mail-0.30.01 Convert between DateTime and RFC2822/822 formats
p5-DateTime-Format-W3CDTF-0.04 Parse and format W3CDTF datetime strings
p5-DateTime-Locale-0.40.01_1 Localization support for DateTime
p5-DateTime-TimeZone-0.77.01 Time zone object base class and factory
p5-Devel-StackTrace-1.19.02 Stack trace and stack trace frame objects
p5-Devel-Symdump-2.0800 A perl5 module that dumps symbol names or the symbol table
p5-Digest-1.15 Modules that calculate message digests
p5-Digest-HMAC-1.01 Perl5 interface to HMAC Message-Digest Algorithms
p5-Digest-MD5-2.36 Perl5 interface to the MD5 algorithm
p5-Digest-SHA-5.47 Perl extension for SHA-1/224/256/384/512
p5-Digest-SHA1-2.11 Perl interface to the SHA-1 Algorithm
p5-Email-Address-1.88.9 RFC 2822 Address Parsing and Creation
p5-Email-Date-Format-1.002 Produce RFC 2822 date strings
p5-Encode-2.26 Provides interfaces between strings and the rest of the sys
p5-Encode-Detect-1.01 An Encode::Encoding subclass that detects the encoding of d
p5-Error-0.17015 Perl module to provide Error/exception support for perl: Er
p5-Exception-Class-1.24 A module that allows you to declare real exception classes
p5-ExtUtils-CBuilder-0.23 Compile and link C code for Perl modules
p5-ExtUtils-ParseXS-2.19 Converts Perl XS code into C code
p5-ExtUtils-XSBuilder-0.28 Autogenerating XS-glue Code
p5-FastCGI-0.67 Modules for perl5, for enabling FastCGI support in CGI scri
p5-File-NFSLock-1.20 File::NFSLock - perl module to do NFS (or not) locking
p5-File-ShareDir-0.05 Locate per-dist and per-module shared files
p5-File-Temp-0.20 Perl5 module to generate temporary files or directories saf
p5-Font-AFM-1.20 An interface to Adobe font metrics files
p5-FreezeThaw-0.43 A module for converting Perl structures to strings and back
p5-GD-2.39 A perl5 interface to Gd Graphics Library version2
p5-GD-Graph-1.44.01_1 Graph plotting module for perl5
p5-GD-TextUtil-0.86_1 Text utilities for use with GD drawing package
p5-GSSAPI-0.26 Perl extension providing access to the GSSAPIv2 library
p5-Geography-Countries-1.4 Handle ISO-3166 country codes
p5-Getopt-Long-2.37 Perl module for extended processing of command line options
p5-GnuPG-Interface-0.36_2 Perl module for interfacing with GnuPG
p5-GraphViz-2.03_2 GraphViz - Perl interface to the GraphViz graphing tool
p5-HTML-Format-2.04 A module to format HTML to text or PS
p5-HTML-Mason-1.39_1 High-performance, dynamic web site authoring system
p5-HTML-Parser-3.56_1 Perl5 module for parsing HTML documents
p5-HTML-RewriteAttributes-0.03 Simple yet powerful HTML attribute rewriting
p5-HTML-Scrubber-0.08 Perl extension for scrubbing/sanitizing html
p5-HTML-Tagset-3.20 Some useful data table in parsing HTML
p5-HTML-Tree-3.23 A collection of modules to manupulate HTML syntax trees
p5-HTTP-Server-Simple-0.34 A very simple standalone HTTP daemon
p5-HTTP-Server-Simple-Mason-0.09 An abstract baseclass for a standalone mason server
p5-Heap-0.80 Perl extensions for keeping data partially sorted
p5-Hook-LexWrap-0.20 Lexically scoped subroutine wrappers for Perl
p5-IO-Compress-Base-2.012 Base Class for IO::Uncompress modules
p5-IO-Compress-Zlib-2.012 Perl5 interface for reading and writing of (g)zip files
p5-IO-Multiplex-1.09 IO::Multiplex - Manage IO on many file handles
p5-IO-Socket-INET6-2.52 Perl module with object interface to AF_INET6 domain socket
p5-IO-Socket-SSL-1.14 Perl5 interface to SSL sockets
p5-IO-String-1.08 Simplified Perl5 module to handle I/O on in-core strings
p5-IO-Tty-1.07 Flexible I/O Perl5 module that allows manipulation of pseud
p5-IO-Zlib-1.09 IO:: style interface to Compress::Zlib
p5-IO-stringy-2.110 Perl5 module for using IO handles with non-file objects
p5-IP-Country-2.23_1 Fast lookup of country codes from IP addresses
p5-IPC-Run-0.80 IPC::Run - Run subprocesses with piping and redirection
p5-IPC-Run-SafeHandles-0.02 IPC::Run::SafeHandles - Safe guarding for IPC::Run(3)
p5-IPC-ShareLite-0.13 A simple interface to access shared memory
p5-List-MoreUtils-0.22 Provide the stuff missing in List::Util
p5-Locale-Maketext-1.13 A framework for software localization and inheritance-based
p5-Locale-Maketext-Fuzzy-0.10 Locale::Maketext::Fuzzy - Maketext from already interpolate
p5-Locale-Maketext-Lexicon-0.66 Use other catalog formats in Locale::Maketext
p5-Log-Dispatch-2.21 A suite of OO modules for logging messages to multiple outp
p5-MIME-Base64-3.07 Perl5 module for Base64 and Quoted-Printable encodings
p5-MIME-Lite-3.02.1 A simple interface for creating (not parsing!) MIME message
p5-MIME-Tools-5.427,2 A set of perl5 modules for MIME
p5-MIME-Types-1.24 Perl extension for determining MIME types
p5-Mail-DKIM-0.32 Perl5 module to process and/or create DKIM email
p5-Mail-SPF-2.005 Reference implementation of the RFC 4408 SPF protocol
p5-Mail-Sender-0.8.13 Module for sending mails with attachments through an SMTP s
p5-Mail-Sendmail-0.79 Perl module implementing a simple, platform-independent mai
p5-Mail-SpamAssassin-3.2.5 A highly efficient mail filter for identifying spam
p5-Mail-Tools-2.02 Perl5 modules for dealing with Internet e-mail messages
p5-Math-BigInt-1.89 Math::BigInt - Arbitrary size integer math package
p5-Module-Build-0.28.08_2 Build and install Perl modules
p5-Module-Versions-Report-1.05 Report versions of all modules in memory
p5-Net-1.22,1 Perl5 modules to access and use network protocols
p5-Net-DNS-0.63 Perl5 interface to the DNS resolver, and dynamic updates
p5-Net-DNS-Resolver-Programmable-0.003 Programmable DNS resolver for off-line testing
p5-Net-IP-1.25 Perl extension for manipulating IPv4/IPv6 addresses
p5-Net-SSLeay-1.35 Perl5 interface to SSL
p5-Net-Server-0.97 A configurable base class for writing internet servers in P
p5-NetAddr-IP-4.00.7 Perl module for working with IP addresses and blocks thereo
p5-Params-Util-0.33 Utility functions to aid in parameter checking
p5-Params-Validate-0.89 Validate method/function parameters
p5-Parse-RecDescent-1.95.1 A recursive descent parsing framework for Perl
p5-PathTools-3.2701 A Perl module for portably manipulating file specifications
p5-PerlIO-eol-0.14 PerlIO layer for normalizing line endings
p5-Regexp-Common-2.122 Regexp::Common - Provide commonly requested regular express
p5-Scalar-List-Utils-1.19,1 Perl subroutines that would be nice to have in the perl cor
p5-Socket6-0.20 IPv6 related part of the C socket.h defines and structure m
p5-Spiffy-0.30 Spiffy Perl Interface Framework For You
p5-Storable-2.18 Persistency for perl data structures
p5-Sub-Uplevel-0.1901_1 Sub::Uplevel - apparently run a function in a higher stack
p5-Term-ReadKey-2.30 A perl5 module for simple terminal control
p5-Test-Base-0.54_1 Test::Base - A Data Driven Testing Framework
p5-Test-Harness-3.13 Run perl standard test scripts with statistics
p5-Test-LongString-0.11 A library to test long strings
p5-Test-NoWarnings-0.084 Hide and store warnings while running test scripts
p5-Test-Simple-0.80 Basic utilities for writing tests in perl
p5-Test-Warn-0.11 Perl extension to test methods for warnings
p5-Text-Autoformat-1.14.0 Automatic and manual text wrapping and reformating formatti
p5-Text-Balanced-2.0.0_1 Extract delimited text sequences from strings
p5-Text-Diff-0.35 Text::Diff - Perform diffs on files and record sets
p5-Text-Iconv-1.7 Perl interface to iconv() codeset conversion function
p5-Text-Quoted-2.05 Text::Quoted - Extract the structure of a quoted mail messa
p5-Text-Reform-1.12.2_1 Manual text wrapping and reformatting
p5-Text-Template-1.45 Expand template text with embedded Perl
p5-Text-WikiFormat-0.79 Module for translating Wiki formatted text into other forma
p5-Text-Wrapper-1.02 Simple word wrapping routine
p5-Text-vFile-asData-0.05_1 Parse vFile formatted files into data structures
p5-Tie-IxHash-1.21 Perl module implementing ordered in-memory associative arra
p5-Time-HiRes-1.9715,1 A perl5 module implementing High resolution time, sleep, an
p5-Time-Local-1.18 Efficiently compute time from local and GMT time
p5-Time-modules-2006.0814 Set of modules for time manipulation
p5-TimeDate-1.16,1 Perl5 module containing a better/faster date parser for abs
p5-Tree-DAG_Node-1.06 Super class for representing nodes in a tree
p5-Tree-Simple-1.18 A simple tree object
p5-UNIVERSAL-require-0.11 Perl module to require() from a variable
p5-URI-1.37 Perl5 interface to Uniform Resource Identifier (URI) refere
p5-Want-0.18 A generalisation of wantarray
p5-XML-Filter-BufferText-1.01 Filter to put all characters() in one event
p5-XML-Handler-YAWriter-0.23 Yet another Perl SAX XML Writer
p5-XML-NamespaceSupport-1.09_1 A simple generic namespace support class
p5-XML-Parser-2.36 Perl extension interface to James Clark’s XML parser, expat
p5-XML-RSS-1.33 Perl extension to manage RDF Site Summary (RSS) files
p5-XML-SAX-0.96 Simple API for XML
p5-XML-SAX-Expat-0.40 Simple API for XML
p5-XML-SAX-Writer-0.50 SAX2 XML Writer
p5-XML-Simple-2.18 Trivial API for reading and writing XML (esp config files)
p5-XML-Twig-3.32 Process huge XML documents by chunks via a tree interface
p5-XML-XPath-1.13 Modules for parsing and evaluating XPath statements
p5-YAML-0.66 YAML implementation in Perl
p5-capitalization-0.03 Perl module which allows you to use familiar style on metho
p5-gettext-1.05_2 Message handling functions
p5-libapreq2-2.08_2 Generic Apache2 Request Library
p5-libwww-5.805 Perl5 library for WWW access
p5-libxml-0.08 Collection of Perl5 modules for working with XML
p5-version-0.76 Perl extension for Version Objects
Alexander Kubatkin