Re: [rt-users] Install problem using a db server on a different host
Hello, Thank you! That solved the problem. I don't know how I missed the --with-db-rt-host variable, but I removed everything I had done (except perl modules - I'm not that stupid!) and started with the configure statement again - this time using the above variable. Everything went tickety-boo. The only thing I can think of is that I didn't read closely enough and assumed I had the db host setting taken care of with the --with-db-host. Duh. At any rate, thank you for the help and thanks to Best Practical for a wonderful product. Michael -Original Message- From: [EMAIL PROTECTED] [mailto:rt-users- [EMAIL PROTECTED] On Behalf Of Ruslan Zakirov Sent: Wednesday, August 06, 2008 6:45 PM To: [EMAIL PROTECTED] Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Install problem using a db server on a different host 1) check option --with-db-rt-host 2) try --enable-layout=RT3 Also want to note that you should run setup-database from dir where RT is installed. On Thu, Aug 7, 2008 at 3:22 AM, Michael Silver [EMAIL PROTECTED] wrote: Hello, I'm installing RT 3.8.0 on a CentOS box but using a mysql server on a different box. I've finished all the steps in the README up to the stage of doing make initialize-database. When I do that, it appears to be creating an ACL for my rt db user as [EMAIL PROTECTED] instead of [EMAIL PROTECTED] or [EMAIL PROTECTED] snip Michael Michael Silver, Network Administrator Parkland Regional Library 5404 56 Avenue Lacombe, AB T4L 1G1 Phone: 403.782.3850 [EMAIL PROTECTED] Fax: 403.782.4650 http://www.prl.ab.ca/ ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Installation of RTFM 2.2.1 on RT 3.8.0 fails
Back in July, Cameron posted a message to the list regarding an installation problem. (See http://lists.bestpractical.com/pipermail/rt-users/2008-July/052816.html for his message.) As far as I can tell, there wasn't a response sent to the list, and I had a similar problem. I'm posting this in case my experience helps anyone else out. Thanks to Ruslan, I've now got a fresh working installation of RT 3.8.0. I went to install RTFM and ran into an issue with the initdb step. It returned Working with: Type: mysql Host: db01.prl.ab.ca Name: ref_ill_rt User: refrt DBA:refrt Now populating database schema. Couldn't finish 'schema' step. ERROR: Couldn't find schema file(s) '*' ...returned with error: 65280 make: *** [initdb] Error 255 I noticed that it was using the db-rt-user as both user and dba. The configure line for RT did specify the db-dba as root. I tried the refrt password, and it connected but returned the error above. (Using the root password with the above settings returned an access denied message as expected.) I then replaced the dba in the perl command line with root, but got the same error as above. I went hunting for the schema and found it in RTFM-2.2.1/etc/schema.mysql. So I cheated and ran mysql -h db01.prl.ab.ca -D ref_ill_rt -u root -p schema.mysql and it appears to have worked. The other line in the Makefile refers to acl, but the acl.mysql file says there aren't any changes needed in mysql for ACL so I didn't run it. Below is the complete run from perl Makefile.PL up to the error message in case it helps. Michael [EMAIL PROTECTED] RTFM-2.2.1]# perl Makefile.PL Using RT configurations from /opt/rt3/lib/RT.pm: ./bin = /opt/rt3/local/bin ./etc = /opt/rt3/local/etc/FM ./html = /opt/rt3/share/html ./lib = /opt/rt3/local/lib ./po= /opt/rt3/local/po/FM ./sbin = /opt/rt3/local/sbin For first-time installation, type 'make initdb'. *** Module::AutoInstall version 1.03 *** Checking for Perl dependencies... [Core Features] Cannot reliably compare non-decimal formatted versions. Please install version.pm or Sort::Versions. - RT...loaded. (3.8.0 = 3.4.2) - Text::WikiFormat ...loaded. (0.79) - Tree::Simple ...loaded. (1.18) - HTML::TreeBuilder ...loaded. (3.23) - Time::ParseDate ...loaded. (2006.0814) - HTML::FormatText ...loaded. (2.04) - YAML ...loaded. (0.66) *** Module::AutoInstall configuration finished. Open input '/root/RTFM-2.2.1/t/utils.pl' file for substitution Open output '/root/RTFM-2.2.1/t/utils.pl' file for substitution Writing Makefile for RTFM [EMAIL PROTECTED] RTFM-2.2.1]# make Manifying blib/man3/RT::FM::Topic_Overlay.3pm Manifying blib/man3/RT::FM::Article.3pm Manifying blib/man3/RT::FM::TopicCollection_Overlay.3pm Manifying blib/man3/RT::FM::ObjectTopic.3pm Manifying blib/man3/RT::FM::Record.3pm Manifying blib/man3/RT::FM::ObjectTopicCollection_Overlay.3pm Manifying blib/man3/RT::URI::fsck_com_rtfm.3pm Manifying blib/man3/RT::FM::Class.3pm Manifying blib/man3/RT::FM::ArticleCollection.3pm Manifying blib/man3/RT::URI::a.3pm Manifying blib/man3/RT::FM::Article_Overlay.3pm Manifying blib/man3/RT::FM::ObjectTopicCollection.3pm Manifying blib/man3/RT::FM::ClassCollection_Overlay.3pm Manifying blib/man3/RT::FM::ArticleCollection_Overlay.3pm Manifying blib/man3/RT::FM::Class_Overlay.3pm Manifying blib/man3/RT::FM::SearchBuilder.3pm Manifying blib/man3/RT::FM::TopicCollection.3pm Manifying blib/man3/RT::FM::Topic.3pm Manifying blib/man3/RT::FM::ClassCollection.3pm Manifying blib/man3/RT::FM::System.3pm [EMAIL PROTECTED] RTFM-2.2.1]# make install Writing /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/RTFM/.packli st Appending installation info to /usr/lib/perl5/5.8.8/i386-linux-thread-multi/perllocal.pod [EMAIL PROTECTED] RTFM-2.2.1]# make initdb /usr/bin/perl -Ilib -I/opt/rt3/local/lib -I/opt/rt3/lib /opt/rt3/sbin/rt-setup-database --action schema --datadir etc --datafile etc/initialdata --dba refrt --prompt-for-dba-password In order to create or update your RT database, this script needs to connect to your mysql instance on db01.prl.ab.ca as refrt Please specify that user's database password below. If the user has no database password, just press return. Password: Working with: Type: mysql Host: db01.prl.ab.ca Name: ref_ill_rt User: refrt DBA:refrt Now populating database schema. Couldn't finish 'schema' step. ERROR: Couldn't find schema file(s) '*' ...returned with error: 65280 make: *** [initdb] Error 255 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Install problem using a db server on a different host
Hello, I'm installing RT 3.8.0 on a CentOS box but using a mysql server on a different box. I've finished all the steps in the README up to the stage of doing make initialize-database. When I do that, it appears to be creating an ACL for my rt db user as [EMAIL PROTECTED] instead of [EMAIL PROTECTED] or [EMAIL PROTECTED] The configure statement I used was: ./configure --with-db-type=mysql --with-db-host=db01.prl.ab.ca --with-db-dba=root --with-db-database=ref_ill_rt --with-db-rt-user=refrt --with-db-rt-pass=secret --with-web-user=apache --with-web-group=apache Looking at Makefile, I see that the initialize-database runs create schema acl coredata insert. It appears to complete up to acl, but dies when running coredata. I manually applied the permissions on the database for the [EMAIL PROTECTED] (GRANT ALL PRIVILEGES ON ref_ill_rt TO 'refrt'@'%' IDENTIFIED BY 'secret';) and was then able to successfully run rt-setup-database --action coredata --dba root --prompt-for-dba-password. I'm now stuck on the final action (insert). When I try running it (either manually via a command or by creating another stanza in the Makefile), I get the following error results: /usr/bin/perl sbin/rt-setup-database --action insert --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 db01.prl.ab.ca 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: db01.prl.ab.ca Name: ref_ill_rt User: refrt DBA:root Now inserting data [Wed Aug 6 17:02:23 2008] [warning]: Use of uninitialized value in concatenation (.) or string at sbin/rt-setup-database line 253, STDIN line 1. (sbin/rt-setup-database:253) Couldn't finish 'insert' step. ERROR: Couldn't load data from '/content' for import: ERROR:Can't locate /content in @INC (@INC contains: /root/rt-3.8.0/sbin/../local/lib /root/rt-3.8.0/sbin/../lib /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.7/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl/5.8.7 /usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 .) at /root/rt-3.8.0/sbin/../lib/RT/Handle.pm line 690, STDIN line 1. make: *** [insert-database] Error 255 I can successfully connect to the db server from this host using mysql -h db01.prl.ab.ca -u refrt -p and can successfully select data from the tables (e.g. the entries in the ACL table). I'm quite happy to admit I've missed something. I've read the appropriate docs (although I could have missed something) and Googled without much luck. Everything seems to assume you're running mysql on the same server. Can anyone point me in the right direction to get this up and running? My perl-fu isn't strong enough for me to look at the source and figure a way around this. I am not averse to starting the RT installation over if that's what it takes - the perl dependencies are resolved, and that's always been the hardest part before. If I missed a step or a configure element, I would like to know what it was so I know how to avoid this in the future. I appreciate any help anyone can give me on or off list. Michael Michael Silver, Network Administrator Parkland Regional Library 5404 56 Avenue Lacombe, AB T4L 1G1 Phone: 403.782.3850 [EMAIL PROTECTED] Fax: 403.782.4650 http://www.prl.ab.ca/ ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com