From owner-freebsd-questions@FreeBSD.ORG Wed Feb 22 14:07:44 2012 Return-Path: Delivered-To: freebsd-questions@FreeBSD.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 9A55B106564A for ; Wed, 22 Feb 2012 14:07:44 +0000 (UTC) (envelope-from matthew@FreeBSD.org) Received: from smtp.infracaninophile.co.uk (smtp6.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3cd3:cd67:fafa:3d78]) by mx1.freebsd.org (Postfix) with ESMTP id 0C3488FC1C for ; Wed, 22 Feb 2012 14:07:43 +0000 (UTC) Received: from seedling.black-earth.co.uk (seedling.black-earth.co.uk [IPv6:2001:8b0:151:1:fa1e:dfff:feda:c0bb]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.14.5/8.14.5) with ESMTP id q1ME7bwC025075 (version=TLSv1/SSLv3 cipher=DHE-RSA-CAMELLIA256-SHA bits=256 verify=NO) for ; Wed, 22 Feb 2012 14:07:37 GMT (envelope-from matthew@FreeBSD.org) X-DKIM: OpenDKIM Filter v2.4.3 smtp.infracaninophile.co.uk q1ME7bwC025075 Authentication-Results: smtp.infracaninophile.co.uk/q1ME7bwC025075; dkim=none (no signature); dkim-adsp=none Message-ID: <4F44F6A1.9080202@FreeBSD.org> Date: Wed, 22 Feb 2012 14:07:29 +0000 From: Matthew Seaman User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2 MIME-Version: 1.0 To: freebsd-questions@FreeBSD.org References: <4F44B4D3.1070004@FreeBSD.org> In-Reply-To: X-Enigmail-Version: 1.3.5 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig9E46995C5209587C7783CDC3" X-Virus-Scanned: clamav-milter 0.97.3 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.8 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00 autolearn=ham version=3.3.2 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on lucid-nonsense.infracaninophile.co.uk Cc: Subject: Re: CPAN hanging on ExtUtils::MakeMaker even if installed X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 22 Feb 2012 14:07:44 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig9E46995C5209587C7783CDC3 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On 22/02/2012 12:48, Jaime Kikpole wrote: > On Wed, Feb 22, 2012 at 4:26 AM, Matthew Seaman w= rote: >> Speaking as the rt40 port maintainer, I feel you may be making your li= fe >> unnecessarily difficult here. The port won't touch your data: it does= >> precisely nothing to the database. It does let you set default values= >> for DB connection parameters at install time, but that's not required= >> and you can just use the normal configuration files to the same effect= =2E >=20 > I had no idea. I assumed that it could only attempt to setup a new > DB. Thank you. That will be a big help. It's a FreeBSD ports thing -- ports generally do not provide pre-packaged configurations, on the basis that is what sysadmins are for.= > Does the rt40 port make a new MySQL database by the name of rt4? My > current data is in a MySQL database named rt3, which is why I ask. > How would you recommend getting the migrated data over to the new > version? No -- as I said, the port doesn't touch the database at all. What it does do is print out a message with some instructions on what to do next. Actually, these are pretty much a condensed version of what is in the README in the rt-4.0.5 sources. To create a brand-new empty database and associated userid and password for rt-4.0.5 run: /usr/local/sbin/rt-setup-database --action create,acl \ --prompt-for-dba-password This will use the defaults specified when you built the port, prompting you for the password for the privileged DBA login used to do the schema modification bits. (While you can set that at build time, I don't recommend it on the basis that it will store the password internally in plain text.) You may need to do other dba related bits, like editing the pg_hba.conf file to allow the new user appropriate access levels. For upgrades from rt-3.x to rt-4.x, the procedure would be to start with a copy of your rt3 DB loaded into a new rt4 DB instance -- ie. by using mysqldump and mysql client to load, or pg_dump and psql to load or the equivalent for whatever RDBMS you prefer. Then use rt-setup-database to apply the required schema updates. Note: although the rt40 port defaults to using MySQL, personally, I'd choose PostgreSQL for a new install. (Pg supports full-text indexing natively, whereas MySQL needs external software and more to do so.) Switching RDBMSes as part of the upgrade is not a trivial operation, so unless you have good reason, just stick with whatever DB you've already g= ot. The DB default of MySQL is what was there historically, and I didn't think my arbitrarily changing that was justified. > As a side note, it seems that I've put off the Apache 1.3.x to 2.x > upgrade for far too long. The rt40 port requires p5-Log-Dispatch > which requires some Apache port. Since apache13 was deprecated in > November, I'll have to upgrade Apache itself first. I'm thinking that > I'll do that today and go with the apache22 port. I'm open to advise > on the Apache upgrade if anyone has any. >=20 rt40 can be run with any web server supported by PSGI, which is rather more than just Apache. (There's even a built-in pure-perl one, but that's really not suitable for any sort of serious usage level.) While apache22 is the default, p5-Log-Dispatch doesn't have any apache dependencies that I can see... How hard the apache upgrade is for you depends on what else you serve with your apache13 instance currently. If this is a server dedicated to RT, then it should be pretty simple. For a dedicated RT VHOST (or a dedicated apache instance), and assuming a) you're using mod_perl and b) you want to use HTTPS, the rt-related config should look something like this: ServerName rt.example.org SSLEngine on SSLCertificateFile www/apache22/certs/rt.example.org-cert.pem SSLCertificateKeyFile www/apache22/certs/rt.example.org-key.pem AddDefaultCharset UTF-8 DocumentRoot "/usr/local/share/rt40/html" Order Allow,Deny Allow from 192.0.2.0/24 SetHandler modperl PerlResponseHandler Plack::Handler::Apache2 PerlSetVar psgi_app /usr/local/sbin/rt-server use Plack::Handler::Apache2; Plack::Handler::Apache2->preload("/usr/local/sbin/rt-server"); (Just drop the lines starting SSL and change the port number to 80 if you prefer plain text HTTP.) There are some more examples in the RT supplied documentation in /usr/local/share/doc/rt40/web_deployment.pod >> Hmmm... well, the port doesn't use 'make fixdeps' because it's the por= ts >> job to ensure that all the required dependencies are fulfilled. >=20 > That is very good news. Thank you. >=20 >=20 >> However, if I try it manually, everything works just fine. This is on= a >> system with only the version of E::MM that comes bundled with perl-5.1= 2 >> (which is version 6.56). The make fixdeps output looks completely >> different though -- what version of RT are you trying to use? >=20 > RT 4.0.5. Perl 5.8.9. I think there may well be moves to drop perl-5.8 support from ports in the relatively near future. If you're going to be having an update-fest anyhow, then I'd recommend switching to perl-5.12 instead. > Thanks so much for the help. Its one of the great things about the > open source community that I'm not at the mercy of a "help desk" that > say things like "OK, why don't you go ahead and reinstall it, then?" Thank you. Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. PGP: http://www.infracaninophile.co.uk/pgpkey --------------enig9E46995C5209587C7783CDC3 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.16 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk9E9qkACgkQ8Mjk52CukIypQACffDD4NZuUTIduDOGgZ6G84FaI kggAoJNTiC4mbTt3XCOMPYILqHVvIIhU =wTAC -----END PGP SIGNATURE----- --------------enig9E46995C5209587C7783CDC3--