X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fdocs%2Fupgrade8.html;h=cf60a8582b69bc18af7a5ae05de5513104518d8d;hp=11b80e3901317a004b67b8516bdfe5648a7aaab6;hb=8ed2714fc50607081d7ac4edf0b17e23902dabba;hpb=fb98e91566e72bc3adb823b706529002af487c09 diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 11b80e390..cf60a8582 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -8,7 +8,7 @@
  • Backup your database and current Freeside installation. (with PostgreSQL) (with MySQL)
  • mod_perl is now required.
  • Install Time-Duration, Tie-IxHash and HTML-Widgets-SelectLayers (minimum version 0.02). -
  • Install Apache::ASP or HTML::Mason. +
  • Install Apache::ASP or HTML::Mason (use version 1.0x - Freeside is not yet compatible with version 1.1x).
  • Install rsync @@ -36,6 +36,7 @@ PerlSetVar Global /usr/local/etc/freeside/asp-global/
      +
    • (use version 1.0x - Freeside is not yet compatible with version 1.1x)
    • Run make masondocs
    • Copy masondocs/ to your web server's document space.
    • Copy htetc/handler.pl to your web server's configuration directory. @@ -69,6 +70,12 @@ CREATE TABLE svc_forward ( dst varchar(80), PRIMARY KEY (svcnum) ); +ALTER TABLE part_svc ADD svc_forward__srcsvc varchar(80) NULL; +ALTER TABLE part_svc ADD svc_forward__srcsvc_flag char(1) NULL; +ALTER TABLE part_svc ADD svc_forward__dstsvc varchar(80) NULL; +ALTER TABLE part_svc ADD svc_forward__dstsvc_flag char(1) NULL; +ALTER TABLE part_svc ADD svc_forward__dst varchar(80) NULL; +ALTER TABLE part_svc ADD svc_forward__dst_flag char(1) NULL; CREATE TABLE cust_credit_bill ( creditbillnum int primary key, @@ -213,7 +220,9 @@ CREATE TABLE cust_tax_exempt ( ); CREATE UNIQUE INDEX cust_tax_exempt1 ON cust_tax_exempt ( taxnum, year, month ); -ALTER TABLE svc_acct ADD domsvc integer NOT NULL; +ALTER TABLE svc_acct ADD domsvc integer NULL; +ALTER TABLE part_svc ADD svc_acct__domsvc varchar(80) NULL; +ALTER TABLE part_svc ADD svc_acct__domsvc_flag char(1) NULL; ALTER TABLE svc_domain ADD catchall integer NULL; ALTER TABLE cust_main ADD referral_custnum integer NULL; ALTER TABLE cust_main ADD comments text NULL; @@ -234,6 +243,8 @@ 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; +ALTER TABLE part_svc ADD svc_acct__sec_phrase varchar(80) NULL; +ALTER TABLE part_svc ADD svc_acct__sec_phrase_flag char(1) NULL; ALTER TABLE part_pkg ADD taxclass varchar(80) NULL; ALTER TABLE cust_main_county ADD taxclass varchar(80) NULL; ALTER TABLE cust_main_county ADD exempt_amount decimal(10,2); @@ -304,6 +315,12 @@ CREATE INDEX cust_main5 ON cust_main ( ship_company );
    • Create a service definition with table svc_forward
    • Run bin/fs-migrate-svc_acct_sm username
    +
  • Or if you just have svc_acct records: +
      +
    • Order and provision a package for your default domain and note down the Service # or svcnum. +
    • UPDATE svc_acct SET domsvc = svcnum +
    • Update your service definitions to have default (or fixed) domsvc. +
  • Run bin/fs-migrate-payrefusername
  • Run bin/fs-migrate-part_svcusername
  • After running bin/fs-migrate-payref, apply the following changes to your database: @@ -352,7 +369,7 @@ ALTER TABLE cust_refund DROP COLUMN crednum;
  • IMPORTANT: After running bin/create-history-tables, run bin/dbdef-create username again.
  • As the freeside UNIX user, run bin/populate-msgcat username to populate the message catalog -
  • 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