blob: 6ad19b063d610ad4f1cce7fa7698c043f51f73ec (
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
57
58
59
|
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)
(errors? try "make clean" then "make install-perl-modules", then
"make install-docs" or "make deploy" again)
|
