Problem building RT 3.6.5 on FreeBSD 7.0-PRERELEASE

Maybe I am trying to do something on the “cutting edge”, but
I get the following error when I try to build the www/rt36
port on FreeBSD 7.0-PRERELEASE (this maybe something the
FreeBSD RT port maintainer should resolve - dunno):

Congratulations. RT has been installed.

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

(You will definitely need to set RT’s database password in
/usr/local/rt3/etc/RT_SiteConfig.pm before continuing. Not doing so could be
very dangerous. Note that you do not have to manually add a
database user or set up a database for RT. These actions will be
taken care of in the next step.)
DBI connect(‘;host=localhost;port=4200’,‘rtroot’,…) failed: Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2) at /usr/local/rt3/sbin/rt-setup-database line 154
Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2) at /usr/local/rt3/sbin/rt-setup-database line 157.
Database doesn’t appear to exist. Aborting database drop. at /usr/local/rt3/sbin/rt-setup-database line 158.
DBI connect(‘;host=localhost;port=4200’,‘rtroot’,…) failed: Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2) at /usr/local/rt3/sbin/rt-setup-database line 105
Failed to connect to dbi:mysql:;host=localhost;port=4200 as rtroot: Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2) at /usr/local/rt3/sbin/rt-setup-database line 105.
*** Error code 255 (ignored)

To complete the installation of this port, please follow these steps:

  1. Edit /usr/local/rt3/etc/RT_SiteConfig.pm, by referring to
    the default config file (/usr/local/rt3/etc/RT_Config.pm).
  2. Configure the email and web gateways. Please refer to
    ‘SETTING UP THE MAIL GATEWAY’ in /usr/local/rt3/README
  3. Restart Apache.
  4. Do remember to CHANGE the root’s password for the web interface.
    The default is “password” (without the quotes.)
  5. Configure RT per the instructions at
    Resources — Best Practical Solutions

===> Registering installation for rt-3.6.5

Then I noticed the MySQL client was built, but not the server…

#pkg_info | grep -i mysql
mysql-client-5.0.51a Multithreaded SQL database (client)
p5-DBD-mysql-4.006 MySQL driver for the Perl5 Database Interface (DBI)

It seems odd to me that RT which depends on MySQL as the database
wouldn’t treat the MySQL server as a dependency. Am I missing something?

Regards,

web…

William Bulley Email: web@umich.edu

Maybe I am trying to do something on the “cutting edge”, but
I get the following error when I try to build the www/rt36
port on FreeBSD 7.0-PRERELEASE (this maybe something the
FreeBSD RT port maintainer should resolve - dunno):

You probably want to file a FreeBSD ticket about the issue

William Bulley wrote:

#pkg_info | grep -i mysql
mysql-client-5.0.51a Multithreaded SQL database (client)
p5-DBD-mysql-4.006 MySQL driver for the Perl5 Database Interface (DBI)

It seems odd to me that RT which depends on MySQL as the database
wouldn’t treat the MySQL server as a dependency. Am I missing something?

This is normal and by design. The RT port depends on the ability to
connect to a database being available on the server – the database
itself can be on some other server. Pretty much any program that can
access MySQL will have similarly a dependency on mysql-client and not
on mysql-server. If you need MySQL on that machine, then just install
it.

Cheers,

Matthew

Dr Matthew Seaman The Bunker, Ash Radar Station
PGP: 0x60AE908C on servers Marshborough Rd
Tel: +44 1304 814890 Sandwich
Fax: +44 1304 814899 Kent, CT13 0PL, UK

signature.asc (250 Bytes)