X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fdocs%2Fupgrade8.html;h=a7b5853b3bdc50688fe6c9a3701c44c05d85b256;hp=3edf425bf4d5d4c5b2c79b939963bc48e089cd6f;hb=87af741da0dd5f6a76bbb566b4d6c54cd5b15315;hpb=69f252e5353483662c81b1d6d0e750ae08577649
diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html
index 3edf425bf..a7b5853b3 100644
--- a/httemplate/docs/upgrade8.html
+++ b/httemplate/docs/upgrade8.html
@@ -7,7 +7,7 @@
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 Time-Duration, and Tie-IxHash
+ Install Time-Duration, Tie-IxHash and HTML-Widgets-SelectLayers.
Install Apache::ASP or HTML::Mason.
Install rsync
@@ -171,6 +171,22 @@ CREATE TABLE part_export_option (
CREATE INDEX part_export_option1 ON part_export_option ( exportnum );
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;
ALTER TABLE cust_main ADD referral_custnum integer NULL;
@@ -188,6 +204,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 );
@@ -303,11 +322,25 @@ 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.
+ 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...)