summaryrefslogtreecommitdiff
path: root/README.1.5.8
blob: cf414545e51720b022b04987af05a716f03f9da8 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56

install JSON
install Term::ReadKey

install DBIx::DBSchema 0.27 (or later)
  (if you are running Pg version 7.2.x or earlier, install at least
   DBIx::DBSchema 0.29)
install HTML::Widgets:SelectLayers 0.05 (or later)
install Business::CreditCard 0.28 (or later)

make install-perl-modules
run "freeside-upgrade username" to uprade your database schema

(if freeside-upgrade hangs, try stopping Apache, all Freeside processes, and
 anything else connected to your database, especially on older Pg versions)

Optional:
CREATE INDEX cust_pkg2 ON cust_pkg ( pkgpart );

CREATE INDEX cust_bill_pkg2 ON cust_bill_pkg ( pkgnum );
CREATE INDEX cust_main9 ON cust_main ( county );
CREATE INDEX cust_main10 ON cust_main ( state );
CREATE INDEX cust_main11 ON cust_main ( country );
CREATE INDEX cust_main_county1 ON cust_main_county ( county );
CREATE INDEX cust_main_county2 ON cust_main_county ( state );
CREATE INDEX cust_main_county3 ON cust_main_county ( country );

Optional for better VoIP performance:
CREATE INDEX rate_detail2 ON rate_detail ( ratenum, dest_regionnum );

-----

Installs w/integrated RT:
  Install Module::Versions::Report

  chmod a+r /opt/rt3/etc/RT*Config.pm
  cd rt
  su freeside

  /opt/rt3/sbin/rt-setup-database --action schema --datadir etc/upgrade/3.3.0
  /opt/rt3/sbin/rt-setup-database --action acl --datadir etc/upgrade/3.3.0
  /opt/rt3/sbin/rt-setup-database --action insert --datadir etc/upgrade/3.3.0

  /opt/rt3/sbin/rt-setup-database --action schema --datadir etc/upgrade/3.3.11
  /opt/rt3/sbin/rt-setup-database --action acl --datadir etc/upgrade/3.3.11
  /opt/rt3/sbin/rt-setup-database --action insert --datadir etc/upgrade/3.3.11

  run "dbdef-create username"

  make configure-rt

------

make install-docs
 (or "make deploy" if you've got everything setup in the Makefile)