X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;ds=inline;f=httemplate%2Fdocs%2Fupgrade8.html;h=841a053ed7d4511d33542267b673fc246b7658ce;hb=a7c1b602f88c177db34477ed4cdc1f72603f8995;hp=61d956ce81443bf112402fc77929573a08a6e82e;hpb=7e3eb82f87c371785544b706b7347c7edde2b593;p=freeside.git
diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html
index 61d956ce8..841a053ed 100644
--- a/httemplate/docs/upgrade8.html
+++ b/httemplate/docs/upgrade8.html
@@ -7,8 +7,9 @@
If migrating from less than 1.3.1, see these instructions first.
Backup your database and current Freeside installation. (with PostgreSQL) (with MySQL)
mod_perl is now required.
- Install Archive-Tar, Time-Duration, and Tie-IxHash
+ Install Time-Duration, Tie-IxHash and HTML-Widgets-SelectLayers.
Install Apache::ASP or HTML::Mason.
+ Install rsync
@@ -105,8 +106,12 @@ CREATE TABLE queue (
jobnum int primary key,
job text not null,
_date int not null,
- status varchar(80) not null
+ status varchar(80) not null,
+ statustext text null,
+ svcnum int null
);
+CREATE INDEX queue1 ON queue ( svcnum );
+CREATE INDEX queue2 ON queue ( status );
CREATE TABLE queue_arg (
argnum int primary key,
@@ -147,9 +152,17 @@ CREATE TABLE part_bill_event (
);
CREATE INDEX part_bill_event1 ON part_bill_event ( payby );
+CREATE TABLE export_svc (
+ exportsvcnum int primary key,
+ exportnum int not null,
+ svcpart int not null
+);
+CREATE UNIQUE INDEX export_svc1 ON export_svc ( exportnum, svcpart );
+CREATE INDEX export_svc2 ON export_svc ( exportnum );
+CREATE INDEX export_svc3 ON export_svc ( svcpart );
+
CREATE TABLE part_export (
exportnum int primary key,
- svcpart int not null,
machine varchar(80) not null,
exporttype varchar(80) not null,
nodomain char(1) NULL
@@ -157,14 +170,30 @@ CREATE TABLE part_export (
CREATE INDEX part_export1 ON part_export ( machine );
CREATE INDEX part_export2 ON part_export ( exporttype );
-CREATE INDEX part_export_option (
+CREATE TABLE part_export_option (
optionnum int primary key,
exportnum int not null,
- option varchar(80) not null,
+ optionname varchar(80) not null,
optionvalue text NULL
);
CREATE INDEX part_export_option1 ON part_export_option ( exportnum );
-CREATE INDEX part_export_option2 ON part_export_option ( option );
+CREATE INDEX part_export_option2 ON part_export_option ( optionname );
+
+CREATE TABLE radius_usergroup (
+ usergroupnum int primary key,
+ svcnum int not null,
+ groupname varchar(80) not null
+);
+CREATE INDEX radius_usergroup1 ON radius_usergroup ( svcnum );
+CREATE INDEX radius_usergroup2 ON radius_usergroup ( groupname );
+
+CREATE TABLE msgcat (
+ msgnum int primary key,
+ msgcode varchar(80) not null,
+ locale varchar(16) not null,
+ msg text not null
+);
+CREATE INDEX msgcat1 ON msgcat ( msgcode, locale );
ALTER TABLE svc_acct ADD domsvc integer NOT NULL;
ALTER TABLE svc_domain ADD catchall integer NULL;
@@ -183,6 +212,9 @@ ALTER TABLE cust_bill ADD closed char(1) NULL;
ALTER TABLE cust_pay ADD closed char(1) NULL;
ALTER TABLE cust_credit ADD closed char(1) NULL;
ALTER TABLE cust_refund ADD closed char(1) NULL;
+ALTER TABLE cust_bill_event ADD status varchar(80);
+ALTER TABLE cust_bill_event ADD statustext text NULL;
+ALTER TABLE svc_acct ADD sec_phrase varchar(80) NULL;
CREATE INDEX cust_main3 ON cust_main ( referral_custnum );
CREATE INDEX cust_credit_bill1 ON cust_credit_bill ( crednum );
CREATE INDEX cust_credit_bill2 ON cust_credit_bill ( invnum );
@@ -298,11 +330,26 @@ ALTER TABLE cust_refund DROP COLUMN crednum;
IMPORTANT: After applying the second set of database changes, run bin/dbdef-create again.
+ IMPORTANT: run bin/create-history-tables
+ IMPORTANT: After running bin/create-history-tables, run bin/dbdef-create again.
set the user_policy configuration value as appropriate for your site.
+ set the locale configuration value to en_US.
+ the mxmachines, nsmachines, arecords and cnamerecords configuration values have been deprecated. Set the defaultrecords configuration value instead.
Create the `/usr/local/etc/freeside/cache.datasrc' directory
- (ownded by the freeside user).
+ (owned by the freeside user).
freeside-queued was installed with the Perl modules. Start it now and ensure that is run upon system startup.
Set appropriate invoice events for your site. At the very least, you'll want to set some invoice events "After 0 days": a BILL invoice event to print invoices, a CARD invoice event to batch or run cards real-time, and a COMP invoice event to "pay" complimentary customers. If you were using the -i option to freeside-bill it should be removed.
Use freeside-daily instead of freeside-bill.
+ If you would like Freeside to notify your customers when their credit
+ cards and other billing arrangements are about to expire, arrange for
+ freeside-expiration-alerter to be run daily by cron or similar
+ facility. The message it sends can be configured from the
+ Configuration choice of the main menu as alerter_template.
+ Export has been rewritten. If you were using the icradiusmachines,
+ icradius_mysqldest, icradius_mysqlsource, or icradius_secrets files, add
+ an appropriate "sqlradius" export to all relevant Service Definitions
+ instead. Use MySQL replication or
+ point the "sqlradius" export directly at your external ICRADIUS or FreeRADIUS
+ database (or through an SSL-necrypting proxy...)