From 51984ac3d3da3006809c6866fdecd4ad83610731 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 30 Jul 2001 07:36:04 +0000 Subject: templates!!! --- httemplate/docs/upgrade8.html | 82 +++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 82 insertions(+) create mode 100644 httemplate/docs/upgrade8.html (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html new file mode 100644 index 000000000..fdf91647f --- /dev/null +++ b/httemplate/docs/upgrade8.html @@ -0,0 +1,82 @@ + + Upgrading to 1.4.0 + + +

Upgrading to 1.4.0 from 1.3.1

If migrating from less than 1.3.1, see these instructions first. +
Back up your data and current Freeside installation. +
Install Apache::ASP or HTML::Mason. +

+ + + + + + + + +

Apache::ASP Mason

Apache::ASP	Mason
+ Run `make aspdocs` + Copy `aspdocs/` to your web server's document space. + Create a Global directory, such as `/usr/local/etc/freeside/asp-global/` + Copy `htetc/global.asa` to the Global directory. + Configure Apache for the Global directory and to execute .cgi files using Apache::ASP. For example: + +<Directory /usr/local/apache/htdocs/freeside-asp> +<Files ~ (\.cgi)> +AddHandler perl-script .cgi +PerlHandler Apache::ASP +</Files> +<Perl> +$MLDBM::RemoveTaint = 1; +</Perl> +PerlSetVar Global /usr/local/etc/freeside/asp-global/ +</Directory> + +	+ Run `make masondocs` + Copy `masondocs/` to your web server's document space. + Copy `htetc/handler.pl` to your web server's configuration directory. + Edit `handler.pl` and set an appropriate `data_dir`, such as `/usr/local/etc/freeside/mason-data` + Configure Apache to use the `handler.pl` file and to execute .cgi files using HTML::Mason. For example: + +<Directory /usr/local/apache/htdocs/freeside-mason> +<Files ~ (\.cgi)> +AddHandler perl-script .cgi +PerlHandler HTML::Mason +</Files> +<Perl> +require "/usr/local/apache/conf/handler.pl"; +</Perl> +</Directory> + +

Run make aspdocs +
Copy aspdocs/ to your web server's document space. +
Create a Global directory, such as /usr/local/etc/freeside/asp-global/ +
Copy htetc/global.asa to the Global directory. +

Configure Apache for the Global directory and to execute .cgi files using Apache::ASP. For example: +

+<Directory /usr/local/apache/htdocs/freeside-asp>
+<Files ~ (\.cgi)>
+AddHandler perl-script .cgi
+PerlHandler Apache::ASP
+</Files>
+<Perl>
+$MLDBM::RemoveTaint = 1;
+</Perl>
+PerlSetVar Global /usr/local/etc/freeside/asp-global/
+</Directory>
+

Run make masondocs +
Copy masondocs/ to your web server's document space. +
Copy htetc/handler.pl to your web server's configuration directory. +
Edit handler.pl and set an appropriate data_dir, such as /usr/local/etc/freeside/mason-data +

Configure Apache to use the handler.pl file and to execute .cgi files using HTML::Mason. For example: +

+<Directory /usr/local/apache/htdocs/freeside-mason>
+<Files ~ (\.cgi)>
+AddHandler perl-script .cgi
+PerlHandler HTML::Mason
+</Files>
+<Perl>
+require "/usr/local/apache/conf/handler.pl";
+</Perl>
+</Directory>
+

Change to the FS directory in the new tarball, and build and install the + Perl modules: +
```
+$ cd FS/
+$ perl Makefile.PL
+$ make
+$ su
+# make install UNINST=1
```
+

If you wish to enable service/shipping addresses, apply the following + changes to your database: +

+ALTER TABLE cust_main ADD COLUMN ship_last varchar(80) NULL;
+ALTER TABLE cust_main ADD COLUMN ship_first varchar(80) NULL;
+ALTER TABLE cust_main ADD COLUMN ship_company varchar(80) NULL;
+ALTER TABLE cust_main ADD COLUMN ship_address1 varchar(80) NULL;
+ALTER TABLE cust_main ADD COLUMN ship_address2 varchar(80) NULL;
+ALTER TABLE cust_main ADD COLUMN ship_city varchar(80) NULL;
+ALTER TABLE cust_main ADD COLUMN ship_county varchar(80) NULL;
+ALTER TABLE cust_main ADD COLUMN ship_state varchar(80) NULL;
+ALTER TABLE cust_main ADD COLUMN ship_zip varchar(10) NULL;
+ALTER TABLE cust_main ADD COLUMN ship_country char(2) NULL;
+ALTER TABLE cust_main ADD COLUMN ship_daytime varchar(20) NULL;
+ALTER TABLE cust_main ADD COLUMN ship_night varchar(20) NULL;
+ALTER TABLE cust_main ADD COLUMN ship_fax varchar(12) NULL;
+

Run bin/dbdef-create. + -- cgit v1.2.1 From 5d2a3918043acd0d3ead743fc44a3a3a0fbc4aec Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 30 Jul 2001 09:53:54 +0000 Subject: Pg primary key upgrade fix (create fix in new DBIx::DBSchema) --- httemplate/docs/upgrade8.html | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index fdf91647f..dfeba6505 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -61,6 +61,34 @@ $ perl Makefile.PL $ make $ su # make install UNINST=1 +

If you are using PostgreSQL, apply the following changes to your database: +

+CREATE UNIQUE INDEX agent_pkey ON agent ( agentnum );
+CREATE UNIQUE INDEX agent_type_pkey agent_type ( typenum );
+CREATE UNIQUE INDEX cust_bill_pkey ON cust_bill ( invnum );
+CREATE UNIQUE INDEX cust_credit_pkey ON cust_credit ( crednum );
+CREATE UNIQUE INDEX cust_main_pkey ON cust_main ( custnum );
+CREATE UNIQUE INDEX cust_main_county_pkey ON cust_main_county ( taxnum );
+CREATE UNIQUE INDEX cust_main_invoice_pkey ON cust_main_invoice ( destnum );
+CREATE UNIQUE INDEX cust_pay_pkey ON cust_pay ( paynum );
+CREATE UNIQUE INDEX cust_pkg_pkey ON cust_pkg ( pkgnum );
+CREATE UNIQUE INDEX cust_refund_pkey ON cust_refund ( refundnum );
+CREATE UNIQUE INDEX cust_svc_pkey ON cust_svc ( svcnum );
+CREATE UNIQUE INDEX domain_record_pkey ON domain_record ( recnum );
+CREATE UNIQUE INDEX nas_pkey ON nas ( nasnum );
+CREATE UNIQUE INDEX part_pkg_pkey ON part_pkg ( pkgpart );
+CREATE UNIQUE INDEX part_referral_pkey ON part_referral ( refnum );
+CREATE UNIQUE INDEX part_svc_pkey ON part_svc ( svcpart );
+CREATE UNIQUE INDEX port_pkey ON port ( portnum );
+CREATE UNIQUE INDEX prepay_credit_pkey ON prepay_credit ( prepaynum );
+CREATE UNIQUE INDEX session_pkey ON session ( sessionnum );
+CREATE UNIQUE INDEX svc_acct_pkey ON svc_acct ( svcnum );
+CREATE UNIQUE INDEX svc_acct_pop_pkey ON svc_acct_pop ( popnum );
+CREATE UNIQUE INDEX svc_acct_sm_pkey ON svc_acct_sm ( svcnum );
+CREATE UNIQUE INDEX svc_domain_pkey ON svc_domain ( svcnum );
+CREATE UNIQUE INDEX svc_www_pkey ON svc_www ( svcnum );
+CREATE UNIQUE INDEX type_pkgs_pkey ON type_pkgs ( typenum );
+

If you wish to enable service/shipping addresses, apply the following changes to your database:

-- 
cgit v1.2.1


From 1dd250b6ff2c32f0bb9b4db7606066f34721e7d9 Mon Sep 17 00:00:00 2001
From: ivan 
Date: Sat, 11 Aug 2001 05:54:45 +0000
Subject: add comments field

---
 httemplate/docs/upgrade8.html | 5 +++++
 1 file changed, 5 insertions(+)

(limited to 'httemplate/docs/upgrade8.html')

diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html
index dfeba6505..702da5a1b 100644
--- a/httemplate/docs/upgrade8.html
+++ b/httemplate/docs/upgrade8.html
@@ -105,6 +105,11 @@ ALTER TABLE cust_main ADD COLUMN ship_country char(2) NULL;
 ALTER TABLE cust_main ADD COLUMN ship_daytime varchar(20) NULL;
 ALTER TABLE cust_main ADD COLUMN ship_night varchar(20) NULL;
 ALTER TABLE cust_main ADD COLUMN ship_fax varchar(12) NULL;
+

If you wish to enable customer comments, apply the following change to + your database: +
```
+ALTER TABLE cust_main ADD COLUMN comments varchar NULL;
 
```
Run bin/dbdef-create. -- cgit v1.2.1 From 4d513ff5a17bd3b697502b54c9516577a0a8d3e4 Mon Sep 17 00:00:00 2001 From: jeff Date: Sun, 12 Aug 2001 19:41:26 +0000 Subject: merging vpopmail support branch --- httemplate/docs/upgrade8.html | 27 +++++++++++++++++++++++++++ 1 file changed, 27 insertions(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 702da5a1b..1a5c998c6 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -61,6 +61,30 @@ $ perl Makefile.PL $ make $ su # make install UNINST=1 +

Apply the following changes to your database: +

+CREATE TABLE svc_forward (
+  svcnum int NOT NULL,
+  srcsvc int NOT NULL,
+  dstsvc int NOT NULL,
+  dst varchar(80),
+  PRIMARY KEY (svcnum)
+);
+ALTER TABLE svc_acct ADD domsvc integer NOT NULL;
+ALTER TABLE svc_domain ADD catchall integer;
+ALTER TABLE part_svc ADD svc_acct__domsvc integer NULL;
+ALTER TABLE part_svc ADD svc_acct__domsvc_flag char(1) NULL;
+ALTER TABLE part_svc ADD svc_domain__catchall integer NULL;
+ALTER TABLE part_svc ADD svc_domain__catchall_flag char(1) NULL;
+ALTER TABLE part_svc ADD svc_forward__srcsvc integer NULL;
+ALTER TABLE part_svc ADD svc_forward__srcsvc_flag char(1) NULL;
+ALTER TABLE part_svc ADD svc_forward__dstsvc integer NULL;
+ALTER TABLE part_svc ADD svc_forward__dstsvc_flag char(1) NULL;
+ALTER TABLE part_svc ADD svc_forward__dst integer NULL;
+ALTER TABLE part_svc ADD svc_forward__dst_flag char(1) NULL;
+
+

If you are using PostgreSQL, apply the following changes to your database:

 CREATE UNIQUE INDEX agent_pkey ON agent ( agentnum );
@@ -112,4 +136,7 @@ ALTER TABLE cust_main ADD COLUMN ship_fax varchar(12) NULL;
 ALTER TABLE cust_main ADD COLUMN comments varchar NULL;

Run bin/dbdef-create. +
create a service based on svc_forward +
Run bin/fs-migrate-svc_acct_sm +
create the conf.dbsrc/user_policy as appropriate for your site -- cgit v1.2.1 From 8c7396531e6bf6f7c6cc4e5d19e2d381442223c5 Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 19 Aug 2001 13:50:47 +0000 Subject: indices on cust_main ship_last and ship_country --- httemplate/docs/upgrade8.html | 2 ++ 1 file changed, 2 insertions(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 1a5c998c6..60f8f1593 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -129,6 +129,8 @@ ALTER TABLE cust_main ADD COLUMN ship_country char(2) NULL; ALTER TABLE cust_main ADD COLUMN ship_daytime varchar(20) NULL; ALTER TABLE cust_main ADD COLUMN ship_night varchar(20) NULL; ALTER TABLE cust_main ADD COLUMN ship_fax varchar(12) NULL; +CREATE INDEX cust_main1 ON cust_main ( ship_last ); +CREATE INDEX cust_main2 ON cust_main ( ship_company );
If you wish to enable customer comments, apply the following change to your database: -- cgit v1.2.1 From aa7b51c0794f6a61e522fbba978f6c64446d8696 Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 28 Aug 2001 14:34:14 +0000 Subject: customer-to-customer referrals! --- httemplate/docs/upgrade8.html | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 60f8f1593..e2bb333d6 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -82,7 +82,8 @@ ALTER TABLE part_svc ADD svc_forward__dstsvc integer NULL; ALTER TABLE part_svc ADD svc_forward__dstsvc_flag char(1) NULL; ALTER TABLE part_svc ADD svc_forward__dst integer NULL; ALTER TABLE part_svc ADD svc_forward__dst_flag char(1) NULL; - +ALTER TABLE cust_main ADD referral_custnum integer NULL; +CREATE INDEX cust_main3 ON cust_main ( referral_custnum );
If you are using PostgreSQL, apply the following changes to your database: -- cgit v1.2.1 From 5e99168da38e7616fc726242ce7d85e140f22c6f Mon Sep 17 00:00:00 2001 From: ivan
Date: Tue, 28 Aug 2001 16:58:08 +0000 Subject: customer-to-customer referrals in singup server --- httemplate/docs/upgrade8.html | 1 + 1 file changed, 1 insertion(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index e2bb333d6..dfbe6a253 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -138,6 +138,7 @@ CREATE INDEX cust_main2 ON cust_main ( ship_company );
```
 ALTER TABLE cust_main ADD COLUMN comments varchar NULL;
 
```
+
If you are using the signup server, reinstall it according to the instructions. The 1.3.x signup server is not compatible with 1.4.x.
Run bin/dbdef-create.
create a service based on svc_forward
Run bin/fs-migrate-svc_acct_sm -- cgit v1.2.1 From 3ae5a3652e8d8270ba7d5b6cd061bf28fe629e61 Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 29 Aug 2001 08:45:04 +0000 Subject: catchall *can* be NULL --- httemplate/docs/upgrade8.html | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index dfbe6a253..3edc87864 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -71,7 +71,7 @@ CREATE TABLE svc_forward ( PRIMARY KEY (svcnum) ); ALTER TABLE svc_acct ADD domsvc integer NOT NULL; -ALTER TABLE svc_domain ADD catchall integer; +ALTER TABLE svc_domain ADD catchall integer NULL; ALTER TABLE part_svc ADD svc_acct__domsvc integer NULL; ALTER TABLE part_svc ADD svc_acct__domsvc_flag char(1) NULL; ALTER TABLE part_svc ADD svc_domain__catchall integer NULL; -- cgit v1.2.1 From 6412f71a3557249225abf5eb2096ebad1729c585 Mon Sep 17 00:00:00 2001 From: jeff Date: Sat, 1 Sep 2001 21:52:20 +0000 Subject: add cust_credit_bill relating multiple invoices to credits --- httemplate/docs/upgrade8.html | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 3edc87864..b35194df2 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -70,6 +70,15 @@ CREATE TABLE svc_forward ( dst varchar(80), PRIMARY KEY (svcnum) ); + +CREATE TABLE cust_credit_bill ( + crednum int not null, + invnum int not null, + _date timestamp not null, + amount decimal(10,2) not null, + PRIMARY KEY (crednum) +); + ALTER TABLE svc_acct ADD domsvc integer NOT NULL; ALTER TABLE svc_domain ADD catchall integer NULL; ALTER TABLE part_svc ADD svc_acct__domsvc integer NULL; @@ -84,6 +93,7 @@ ALTER TABLE part_svc ADD svc_forward__dst integer NULL; ALTER TABLE part_svc ADD svc_forward__dst_flag char(1) NULL; ALTER TABLE cust_main ADD referral_custnum integer NULL; CREATE INDEX cust_main3 ON cust_main ( referral_custnum ); +CREATE INDEX cust_credit_bill2 ON cust_credit_bill ( invnum );
If you are using PostgreSQL, apply the following changes to your database: -- cgit v1.2.1 From 42ac86258bce00f5e7fa2db7e375c4a344295a15 Mon Sep 17 00:00:00 2001 From: jeff Date: Sat, 1 Sep 2001 22:28:51 +0000 Subject: haste makes waste... and left a method out --- httemplate/docs/upgrade8.html | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index b35194df2..765c2b8d5 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -75,8 +75,7 @@ CREATE TABLE cust_credit_bill ( crednum int not null, invnum int not null, _date timestamp not null, - amount decimal(10,2) not null, - PRIMARY KEY (crednum) + amount decimal(10,2) not null ); ALTER TABLE svc_acct ADD domsvc integer NOT NULL; @@ -93,6 +92,7 @@ ALTER TABLE part_svc ADD svc_forward__dst integer NULL; ALTER TABLE part_svc ADD svc_forward__dst_flag char(1) NULL; ALTER TABLE cust_main ADD referral_custnum integer 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 ); -- cgit v1.2.1 From 98ddc878969bb39e576e3bd316f96ff7eeedb750 Mon Sep 17 00:00:00 2001 From: ivan Date: Sat, 1 Sep 2001 23:41:51 +0000 Subject: cust_bill_pay and cust_credit_refund --- httemplate/docs/upgrade8.html | 25 ++++++++++++++++++++++++- 1 file changed, 24 insertions(+), 1 deletion(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 765c2b8d5..1e4064e8d 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -72,12 +72,30 @@ CREATE TABLE svc_forward ( ); CREATE TABLE cust_credit_bill ( + creditbillnum int primary key, crednum int not null, invnum int not null, - _date timestamp not null, + _date int not null, amount decimal(10,2) not null ); +CREATE TABLE cust_bill_pay ( + billpaynum int primary key, + invnum int not null, + paynum int not null, + _date int not null, + amount decimal(10,2) not null +); + +CREATE TABLE cust_credit_refund ( + creditrefundnum int primary key, + crednum int not null, + refundnum int not null, + _date int not null, + amount decimal(10,2) not null +); + + ALTER TABLE svc_acct ADD domsvc integer NOT NULL; ALTER TABLE svc_domain ADD catchall integer NULL; ALTER TABLE part_svc ADD svc_acct__domsvc integer NULL; @@ -94,6 +112,10 @@ ALTER TABLE cust_main ADD referral_custnum integer 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 ); +CREATE INDEX cust_bill_pay1 ON cust_bill_pay ( invnum ); +CREATE INDEX cust_bill_pay2 ON cust_bill_pay ( paynum ); +CREATE INDEX cust_credit_refund1 ON cust_credit_refund ( crednum ); +CREATE INDEX cust_credit_refund2 ON cust_credit_refund ( refundnum );
If you are using PostgreSQL, apply the following changes to your database: @@ -152,5 +174,6 @@ ALTER TABLE cust_main ADD COLUMN comments varchar NULL;
Run bin/dbdef-create.
create a service based on svc_forward
Run bin/fs-migrate-svc_acct_sm +
Run bin/fs-migrate-payref
create the conf.dbsrc/user_policy as appropriate for your site -- cgit v1.2.1 From 8c1f9804d9a02c0c054eededeb500c72a640249a Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 2 Sep 2001 02:46:55 +0000 Subject: cust_refund and cust_pay get custnums --- httemplate/docs/upgrade8.html | 2 ++ 1 file changed, 2 insertions(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 1e4064e8d..573db3683 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -109,6 +109,8 @@ ALTER TABLE part_svc ADD svc_forward__dstsvc_flag char(1) NULL; ALTER TABLE part_svc ADD svc_forward__dst integer NULL; ALTER TABLE part_svc ADD svc_forward__dst_flag char(1) NULL; ALTER TABLE cust_main ADD referral_custnum integer NULL; +ALTER TABLE cust_pay ADD custnum integer; +ALTER TABLE cust_refund ADD custnum integer; 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 ); -- cgit v1.2.1 From 02b16ae5152826a2dfc3ec9a2e173198e2d013d3 Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 2 Sep 2001 03:20:45 +0000 Subject: upgrade --- httemplate/docs/upgrade8.html | 14 ++++++++++++++ 1 file changed, 14 insertions(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 573db3683..cd537119e 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -177,5 +177,19 @@ ALTER TABLE cust_main ADD COLUMN comments varchar NULL;
create a service based on svc_forward
Run bin/fs-migrate-svc_acct_sm
Run bin/fs-migrate-payref +

After running bin/fs-migrate-payref, apply the following changes to your database: + +

PostgreSQL	MySQL, others
+ +ALTER TABLE cust_pay RENAME COLUMN invnum TO depreciated; +ALTER TABLE cust_refund RENAME COLUMN crednum TO depreciated; + +	+ +ALTER TABLE cust_pay DROP COLUMN invnum; +ALTER TABLE cust_refund DROP COLUMN crednum; + +

PostgreSQL

MySQL, others

+ALTER TABLE cust_pay RENAME COLUMN invnum TO depreciated;
+ALTER TABLE cust_refund RENAME COLUMN crednum TO depreciated;
+

+ALTER TABLE cust_pay DROP COLUMN invnum;
+ALTER TABLE cust_refund DROP COLUMN crednum;
+

IMPORTANT: After applying the second set of database changes, run bin/dbdef-create again.

create the conf.dbsrc/user_policy as appropriate for your site -- cgit v1.2.1 From 29b94aeb1c3003f7a9bbfbe1a91a86f8b9edfbbc Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 2 Sep 2001 03:42:32 +0000 Subject: really. backup. --- httemplate/docs/upgrade8.html | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index cd537119e..6d5018816 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -5,7 +5,7 @@

Upgrading to 1.4.0 from 1.3.1

If migrating from less than 1.3.1, see these instructions first. -
Back up your data and current Freeside installation. +
Backup your database and current Freeside installation. (with PostgreSQL) (with MySQL)
Install Apache::ASP or HTML::Mason.

-- cgit v1.2.1 From fbcb45dfe5a1bce7981fe4527176b9fdf2ec54b7 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 3 Sep 2001 22:07:39 +0000 Subject: fix more bugs --- httemplate/docs/upgrade8.html | 30 ++++++++++++++++++++++++++++-- 1 file changed, 28 insertions(+), 2 deletions(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 6d5018816..518d76168 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -181,8 +181,34 @@ ALTER TABLE cust_main ADD COLUMN comments varchar NULL;

PostgreSQL MySQL, others

-ALTER TABLE cust_pay RENAME COLUMN invnum TO depreciated;
-ALTER TABLE cust_refund RENAME COLUMN crednum TO depreciated;
+CREATE TABLE cust_pay_temp (
+  paynum int primary key,
+  custnum int not null,
+  paid decimal(10,2) not null,
+  _date int null,
+  payby char(4) not null,
+  payinfo varchar(16) null,
+  paybatch varchar(80) null
+);
+INSERT INTO cust_pay_temp SELECT * from cust_pay;
+DROP TABLE cust_pay;
+ALTER TABLE cust_pay_temp RENAME TO cust_pay;
+CREATE UNIQUE INDEX cust_pay1 ON cust_pay paynum;
+CREATE TABLE cust_refund_temp (
+  refundnum int primary key,
+  custnum int not null,
+  _date int null,
+  refund decimal(10,2) not null,
+  otaker varchar(8) not null,
+  reason varchar(80) not null,
+  payby char(4) not null,
+  payinfo varchar(16) null,
+  paybatch varchar(80) null
+);
+INSERT INTO cust_refund_temp SELECT * from cust_refund;
+DROP TABLE cust_refund;
+ALTER TABLE cust_refund_temp RENAME TO cust_refund;
+CREATE UNIQUE INDEX cust_refund1 ON cust_refund refundnum;

-- 
cgit v1.2.1


From 57d69d5c1f98f778a0df82795ce21ee7bd21042a Mon Sep 17 00:00:00 2001
From: ivan 
Date: Thu, 6 Sep 2001 20:42:00 +0000
Subject: finally fix part_svc!!!

---
 httemplate/docs/upgrade8.html | 20 ++++++++++----------
 1 file changed, 10 insertions(+), 10 deletions(-)

(limited to 'httemplate/docs/upgrade8.html')

diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html
index 518d76168..67b0e5fe1 100644
--- a/httemplate/docs/upgrade8.html
+++ b/httemplate/docs/upgrade8.html
@@ -95,19 +95,17 @@ CREATE TABLE cust_credit_refund (
   amount decimal(10,2) not null
 );
 
+CREATE TABLE part_svc_column (
+  columnnum int primary key,
+  svcpart int not null,
+  columnname varchar(64) not null,
+  columnvalue varchar(80) null,
+  columnflag char(1) null
+);
+
 
 ALTER TABLE svc_acct ADD domsvc integer NOT NULL;
 ALTER TABLE svc_domain ADD catchall integer NULL;
-ALTER TABLE part_svc ADD svc_acct__domsvc integer NULL;
-ALTER TABLE part_svc ADD svc_acct__domsvc_flag char(1) NULL;
-ALTER TABLE part_svc ADD svc_domain__catchall integer NULL;
-ALTER TABLE part_svc ADD svc_domain__catchall_flag char(1) NULL;
-ALTER TABLE part_svc ADD svc_forward__srcsvc integer NULL;
-ALTER TABLE part_svc ADD svc_forward__srcsvc_flag char(1) NULL;
-ALTER TABLE part_svc ADD svc_forward__dstsvc integer NULL;
-ALTER TABLE part_svc ADD svc_forward__dstsvc_flag char(1) NULL;
-ALTER TABLE part_svc ADD svc_forward__dst integer NULL;
-ALTER TABLE part_svc ADD svc_forward__dst_flag char(1) NULL;
 ALTER TABLE cust_main ADD referral_custnum integer NULL;
 ALTER TABLE cust_pay ADD custnum integer;
 ALTER TABLE cust_refund ADD custnum integer;
@@ -118,6 +116,7 @@ CREATE INDEX cust_bill_pay1 ON cust_bill_pay ( invnum );
 CREATE INDEX cust_bill_pay2 ON cust_bill_pay ( paynum );
 CREATE INDEX cust_credit_refund1 ON cust_credit_refund ( crednum );
 CREATE INDEX cust_credit_refund2 ON cust_credit_refund ( refundnum );
+CREATE UNIQUE INDEX part_svc_column1 ON part_svc_column ( svcpart, columnname );

If you are using PostgreSQL, apply the following changes to your database: @@ -177,6 +176,7 @@ ALTER TABLE cust_main ADD COLUMN comments varchar NULL;

create a service based on svc_forward

Run bin/fs-migrate-svc_acct_sm

Run bin/fs-migrate-payref +

Run bin/fs-migrate-part_svc

After running bin/fs-migrate-payref, apply the following changes to your database:

PostgreSQL

MySQL, others

-- cgit v1.2.1 From f5266a4d07d116efd732f433d0f4f3a47b143a7d Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 11 Sep 2001 00:08:18 +0000 Subject: faster (cached) fuzzy searches prelim. job queues! fixed part_svc editing --- httemplate/docs/upgrade8.html | 19 ++++++++++++++++++- 1 file changed, 18 insertions(+), 1 deletion(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 67b0e5fe1..d86adc046 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -103,6 +103,19 @@ CREATE TABLE part_svc_column ( columnflag char(1) null ); +CREATE TABLE queue ( + jobnum int primary key, + job varchar not null, + _date int not null, + status varchar(80) not null +); + +CREATE TABLE queue_arg ( + argnum int primary key, + jobnum int not null, + arg varchar null +); +CREATE INDEX queue_arg1 ON queue_arg ( jobnum ); ALTER TABLE svc_acct ADD domsvc integer NOT NULL; ALTER TABLE svc_domain ADD catchall integer NULL; @@ -217,5 +230,9 @@ ALTER TABLE cust_refund DROP COLUMN crednum;

IMPORTANT: After applying the second set of database changes, run bin/dbdef-create again. -

create the conf.dbsrc/user_policy as appropriate for your site +

create the user_policy configuration file as appropriate for your site. +

Create the `/usr/local/etc/freeside/cache.datasrc' directory + (ownded by the freeside user). +

freeside-queued was installed with the Perl modules. Start it now and ensure that is run upon system startup. + -- cgit v1.2.1 From 04ac51dff5dd29a1c674168f5d3396acbb158dbc Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 12 Sep 2001 15:54:25 +0000 Subject: mason warnings --- httemplate/docs/upgrade8.html | 1 + 1 file changed, 1 insertion(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index d86adc046..a179e96b4 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -33,6 +33,7 @@ PerlSetVar Global /usr/local/etc/freeside/asp-global/

NOTE: Mason support is still a bit buggy in the 1.4.0 prereleases. This will be fixed before 1.4.0. You have been warned.
Run make masondocs
Copy masondocs/ to your web server's document space.
Copy htetc/handler.pl to your web server's configuration directory. -- cgit v1.2.1 From 8ca6f203e5dae208d7af581d68671fe47c5e1a1a Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 26 Sep 2001 09:17:06 +0000 Subject: add part_pop_local table --- httemplate/docs/upgrade8.html | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index a179e96b4..747b8e29c 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -118,6 +118,16 @@ CREATE TABLE queue_arg ( ); CREATE INDEX queue_arg1 ON queue_arg ( jobnum ); +CREATE TABLE part_pop_local ( + localnum int primary key, + popnum int not null, + city varchar(80) null, + state char(2) null, + npa char(3) not null, + nxx char(3) not null +); +CREATE UNIQUE INDEX part_pop_local1 ON part_pop_local ( npa, nxx ); + 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; -- cgit v1.2.1 From 44e51a5c50be350fa698bcdcf86ad5c01a7631a2 Mon Sep 17 00:00:00 2001 From: jeff Date: Tue, 2 Oct 2001 16:00:31 +0000 Subject: add pkey to batch payments and fix a doc typo --- httemplate/docs/upgrade8.html | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 747b8e29c..6be51d664 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -132,6 +132,7 @@ 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; ALTER TABLE cust_pay ADD custnum integer; +ALTER TABLE cust_pay_batch ADD paybatchnum integer; ALTER TABLE cust_refund ADD custnum integer; CREATE INDEX cust_main3 ON cust_main ( referral_custnum ); CREATE INDEX cust_credit_bill1 ON cust_credit_bill ( crednum ); @@ -140,13 +141,14 @@ CREATE INDEX cust_bill_pay1 ON cust_bill_pay ( invnum ); CREATE INDEX cust_bill_pay2 ON cust_bill_pay ( paynum ); CREATE INDEX cust_credit_refund1 ON cust_credit_refund ( crednum ); CREATE INDEX cust_credit_refund2 ON cust_credit_refund ( refundnum ); +CREATE UNIQUE INDEX cust_pay_batch_pkey ON cust_pay_batch ( paybatchnum ); CREATE UNIQUE INDEX part_svc_column1 ON part_svc_column ( svcpart, columnname );

If you are using PostgreSQL, apply the following changes to your database:

 CREATE UNIQUE INDEX agent_pkey ON agent ( agentnum );
-CREATE UNIQUE INDEX agent_type_pkey agent_type ( typenum );
+CREATE UNIQUE INDEX agent_type_pkey ON agent_type ( typenum );
 CREATE UNIQUE INDEX cust_bill_pkey ON cust_bill ( invnum );
 CREATE UNIQUE INDEX cust_credit_pkey ON cust_credit ( crednum );
 CREATE UNIQUE INDEX cust_main_pkey ON cust_main ( custnum );
-- 
cgit v1.2.1


From 2a716543d01f3298609b8ac4b1b3fac15ecfb3b1 Mon Sep 17 00:00:00 2001
From: ivan 
Date: Tue, 2 Oct 2001 20:07:58 +0000
Subject: doc clarification (?)

---
 httemplate/docs/upgrade8.html | 7 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)

(limited to 'httemplate/docs/upgrade8.html')

diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html
index 6be51d664..afb84296e 100644
--- a/httemplate/docs/upgrade8.html
+++ b/httemplate/docs/upgrade8.html
@@ -199,8 +199,11 @@ ALTER TABLE cust_main ADD COLUMN comments varchar NULL;

If you are using the signup server, reinstall it according to the instructions. The 1.3.x signup server is not compatible with 1.4.x.
Run bin/dbdef-create. -
create a service based on svc_forward -
Run bin/fs-migrate-svc_acct_sm +
If you have svc_acct_sm records or service definitions: +
- Create a service definition with table svc_forward +
- Run bin/fs-migrate-svc_acct_sm +
Run bin/fs-migrate-payref
Run bin/fs-migrate-part_svc
After running bin/fs-migrate-payref, apply the following changes to your database: -- cgit v1.2.1 From 4bbf90e800406ff75a5fed09ba5cd71293cda542 Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 9 Oct 2001 23:10:17 +0000 Subject: add `unsuspendauto' config file: enable the automatic unsuspension of suspended packages when a customer's balance due changes from positive to zero or negative as the result of a payment or credit add cust_pkg.manual_flag to disable this behaviour per customer package (no UI to set this yet) --- httemplate/docs/upgrade8.html | 1 + 1 file changed, 1 insertion(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index afb84296e..79eb6da3f 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -134,6 +134,7 @@ ALTER TABLE cust_main ADD referral_custnum integer NULL; ALTER TABLE cust_pay ADD custnum integer; ALTER TABLE cust_pay_batch ADD paybatchnum integer; ALTER TABLE cust_refund ADD custnum integer; +ALTER TABLE cust_pkg ADD manual_flag char(1) 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 ); -- cgit v1.2.1 From a6d3e4dc73803cffad96fd4b6270b2fb5f4b0568 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 15 Oct 2001 10:42:29 +0000 Subject: price plans web gui 1st pass, oh my --- httemplate/docs/upgrade8.html | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 79eb6da3f..c317e88c8 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -135,6 +135,8 @@ ALTER TABLE cust_pay ADD custnum integer; ALTER TABLE cust_pay_batch ADD paybatchnum integer; ALTER TABLE cust_refund ADD custnum integer; ALTER TABLE cust_pkg ADD manual_flag char(1) NULL; +ALTER TABLE part_pkg ADD plan varchar NULL; +ALTER TABLE part_pkg ADD plandata varchar 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 ); @@ -223,7 +225,7 @@ CREATE TABLE cust_pay_temp ( INSERT INTO cust_pay_temp SELECT * from cust_pay; DROP TABLE cust_pay; ALTER TABLE cust_pay_temp RENAME TO cust_pay; -CREATE UNIQUE INDEX cust_pay1 ON cust_pay paynum; +CREATE UNIQUE INDEX cust_pay1 ON cust_pay (paynum); CREATE TABLE cust_refund_temp ( refundnum int primary key, custnum int not null, @@ -238,7 +240,7 @@ CREATE TABLE cust_refund_temp ( INSERT INTO cust_refund_temp SELECT * from cust_refund; DROP TABLE cust_refund; ALTER TABLE cust_refund_temp RENAME TO cust_refund; -CREATE UNIQUE INDEX cust_refund1 ON cust_refund refundnum; +CREATE UNIQUE INDEX cust_refund1 ON cust_refund (refundnum);

-- 
cgit v1.2.1


From 60c837e0aaf454dfa0b0c0283dc36928782d1b6c Mon Sep 17 00:00:00 2001
From: ivan 
Date: Sat, 20 Oct 2001 12:18:00 +0000
Subject: setup and recurring fee tax exempt flags, UI to edit rework part_pkg
 editing UI some more

---
 httemplate/docs/upgrade8.html | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'httemplate/docs/upgrade8.html')

diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html
index c317e88c8..a368d4488 100644
--- a/httemplate/docs/upgrade8.html
+++ b/httemplate/docs/upgrade8.html
@@ -137,6 +137,8 @@ ALTER TABLE cust_refund ADD custnum integer;
 ALTER TABLE cust_pkg ADD manual_flag char(1) NULL;
 ALTER TABLE part_pkg ADD plan varchar NULL;
 ALTER TABLE part_pkg ADD plandata varchar NULL;
+ALTER TABLE part_pkg ADD setuptax char(1) NULL;
+ALTER TABLE part_pkg ADD recurtax char(1) 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 );
-- 
cgit v1.2.1


From 160db3d20070241532162f8fa257e2ae4dd1f611 Mon Sep 17 00:00:00 2001
From: ivan 
Date: Tue, 30 Oct 2001 14:28:05 +0000
Subject: docu

---
 httemplate/docs/upgrade8.html | 10 +++-------
 1 file changed, 3 insertions(+), 7 deletions(-)

(limited to 'httemplate/docs/upgrade8.html')

diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html
index a368d4488..94ca832ef 100644
--- a/httemplate/docs/upgrade8.html
+++ b/httemplate/docs/upgrade8.html
@@ -54,14 +54,10 @@ require "/usr/local/apache/conf/handler.pl";

Change to the FS directory in the new tarball, and build and install the - Perl modules: +

Build and install the Perl modules:

-$ cd FS/
-$ perl Makefile.PL
-$ make
 $ su
-# make install UNINST=1

+# make install-perl-modules

Apply the following changes to your database:

 CREATE TABLE svc_forward (
@@ -251,7 +247,7 @@ ALTER TABLE cust_refund DROP COLUMN crednum;

IMPORTANT: After applying the second set of database changes, run bin/dbdef-create again. -
create the user_policy configuration file as appropriate for your site. +
set the user_policy configuration value as appropriate for your site.
Create the `/usr/local/etc/freeside/cache.datasrc' directory (ownded by the freeside user).
freeside-queued was installed with the Perl modules. Start it now and ensure that is run upon system startup. -- cgit v1.2.1 From fee9bc7edcdd27e7a4e47bc313d05c66cd900073 Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 26 Dec 2001 23:59:33 +0000 Subject: doc --- httemplate/docs/upgrade8.html | 2 ++ 1 file changed, 2 insertions(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 94ca832ef..0855e6dee 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -135,6 +135,8 @@ ALTER TABLE part_pkg ADD plan varchar NULL; ALTER TABLE part_pkg ADD plandata varchar NULL; ALTER TABLE part_pkg ADD setuptax char(1) NULL; ALTER TABLE part_pkg ADD recurtax char(1) NULL; +ALTER TABLE part_pkg ADD disabled char(1) NULL; +ALTER TABLE part_svc ADD disabled char(1) 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 ); -- cgit v1.2.1 From 69a0a7504f84aa9bb1f204d1f3522e1520e0885e Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 3 Jan 2002 17:40:26 +0000 Subject: more schema changes: part_bill_event and cust_bill_event tables remove old 1.4.0pre READMEs --- httemplate/docs/upgrade8.html | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 0855e6dee..13830dc6c 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -124,6 +124,25 @@ CREATE TABLE part_pop_local ( ); CREATE UNIQUE INDEX part_pop_local1 ON part_pop_local ( npa, nxx ); +CREATE TABLE cust_bill_event ( + eventnum int primary key, + invnum int not null, + eventpart int not null, + _date int not null, +); +CREATE UNIQUE INDEX cust_bill_event1 ON cust_bill_event ( eventpart, invnum ); +CREATE INDEX cust_bill_event2 ON cust_bill_event ( invnum ); + +CREATE TABLE part_bill_event ( + eventpart int primary key, + payby char(4) not null, + event varchar(80) not null, + eventcode text null, + seconds int null, + disabled char(1) null, +); +CREATE INDEX part_bill_event1 ON part_bill_event ( payby ); + 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; -- cgit v1.2.1 From 17d52b98d95c3f5494fd890e1b0e41c6b34463eb Mon Sep 17 00:00:00 2001 From: ivan Date: Sat, 12 Jan 2002 07:23:16 +0000 Subject: fix upgrade8.html to be in agreement with fs-setup --- httemplate/docs/upgrade8.html | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 13830dc6c..904694879 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -102,7 +102,7 @@ CREATE TABLE part_svc_column ( CREATE TABLE queue ( jobnum int primary key, - job varchar not null, + job text not null, _date int not null, status varchar(80) not null ); @@ -110,7 +110,7 @@ CREATE TABLE queue ( CREATE TABLE queue_arg ( argnum int primary key, jobnum int not null, - arg varchar null + arg text null ); CREATE INDEX queue_arg1 ON queue_arg ( jobnum ); @@ -150,8 +150,8 @@ ALTER TABLE cust_pay ADD custnum integer; ALTER TABLE cust_pay_batch ADD paybatchnum integer; ALTER TABLE cust_refund ADD custnum integer; ALTER TABLE cust_pkg ADD manual_flag char(1) NULL; -ALTER TABLE part_pkg ADD plan varchar NULL; -ALTER TABLE part_pkg ADD plandata varchar NULL; +ALTER TABLE part_pkg ADD plan varchar(80) NULL; +ALTER TABLE part_pkg ADD plandata text NULL; ALTER TABLE part_pkg ADD setuptax char(1) NULL; ALTER TABLE part_pkg ADD recurtax char(1) NULL; ALTER TABLE part_pkg ADD disabled char(1) NULL; @@ -217,7 +217,7 @@ CREATE INDEX cust_main2 ON cust_main ( ship_company );

If you wish to enable customer comments, apply the following change to your database:

-ALTER TABLE cust_main ADD COLUMN comments varchar NULL;
+ALTER TABLE cust_main ADD COLUMN comments text NULL;

If you are using the signup server, reinstall it according to the instructions. The 1.3.x signup server is not compatible with 1.4.x.

Run bin/dbdef-create. -- cgit v1.2.1 From b03df92e48df653460cb8b6034a06dd1de6f4095 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 28 Jan 2002 05:15:29 +0000 Subject: part_export schema changes --- httemplate/docs/upgrade8.html | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 904694879..144242b6a 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -143,6 +143,25 @@ CREATE TABLE part_bill_event ( ); CREATE INDEX part_bill_event1 ON part_bill_event ( payby ); +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 +); +CREATE INDEX part_export1 ON part_export ( machine ); +CREATE INDEX part_export2 ON part_export ( exporttype ); + +CREATE INDEX part_export_option ( + optionnum int primary key, + exportnum int not null, + option varchar(80) not null, + optionvalue text NULL +); +CREATE INDEX part_export_option1 ON part_export ( exportnum ); +CREATE INDEX part_export_option2 ON part_export ( option ); + 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; -- cgit v1.2.1 From 1aa750eba2b9b73b4f09f28b9acd748ee3669bd4 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 28 Jan 2002 06:57:23 +0000 Subject: book closing schema changes --- httemplate/docs/upgrade8.html | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 144242b6a..bbb528cda 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -175,6 +175,10 @@ ALTER TABLE part_pkg ADD setuptax char(1) NULL; ALTER TABLE part_pkg ADD recurtax char(1) NULL; ALTER TABLE part_pkg ADD disabled char(1) NULL; ALTER TABLE part_svc ADD disabled char(1) NULL; +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; 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 ); -- cgit v1.2.1 From c5c0ba135749164ec8ba75d18f76c29625e1bc7e Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 29 Jan 2002 17:42:46 +0000 Subject: weight, plan and plandata fields in part_bill_event --- httemplate/docs/upgrade8.html | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index bbb528cda..c4d023a58 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -128,7 +128,7 @@ CREATE TABLE cust_bill_event ( eventnum int primary key, invnum int not null, eventpart int not null, - _date int not null, + _date int not null ); CREATE UNIQUE INDEX cust_bill_event1 ON cust_bill_event ( eventpart, invnum ); CREATE INDEX cust_bill_event2 ON cust_bill_event ( invnum ); @@ -139,7 +139,10 @@ CREATE TABLE part_bill_event ( event varchar(80) not null, eventcode text null, seconds int null, - disabled char(1) null, + weight int not null, + plan varchar(80) null, + plandata text null, + disabled char(1) null ); CREATE INDEX part_bill_event1 ON part_bill_event ( payby ); -- cgit v1.2.1 From 8cbba53b09bb5b09355316b7ff8948500c3b4b76 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 4 Feb 2002 16:44:48 +0000 Subject: billing events! --- httemplate/docs/upgrade8.html | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index c4d023a58..360fba691 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -6,6 +6,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 Apache::ASP or HTML::Mason.

@@ -33,7 +34,6 @@ PerlSetVar Global /usr/local/etc/freeside/asp-global/

NOTE: Mason support is still a bit buggy in the 1.4.0 prereleases. This will be fixed before 1.4.0. You have been warned.
Run make masondocs
Copy masondocs/ to your web server's document space.
Copy htetc/handler.pl to your web server's configuration directory. -- cgit v1.2.1 From 79f83ad93cc6f77a155528661a4681946fdd17a6 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 4 Feb 2002 17:04:33 +0000 Subject: have fs-setup create the necessary "default" billing events documentation on necessary "default" billing events --- httemplate/docs/upgrade8.html | 1 + 1 file changed, 1 insertion(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 360fba691..f0b16222c 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -298,5 +298,6 @@ ALTER TABLE cust_refund DROP COLUMN crednum;
Create the `/usr/local/etc/freeside/cache.datasrc' directory (ownded 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.

-- cgit v1.2.1 From d9d79aeecc2c0d79bd1d066a702252ffd683661e Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 5 Feb 2002 07:57:38 +0000 Subject: fix part_export_option indices --- httemplate/docs/upgrade8.html | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index f0b16222c..022d1f6ae 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -162,8 +162,8 @@ CREATE INDEX part_export_option ( option varchar(80) not null, optionvalue text NULL ); -CREATE INDEX part_export_option1 ON part_export ( exportnum ); -CREATE INDEX part_export_option2 ON part_export ( option ); +CREATE INDEX part_export_option1 ON part_export_option ( exportnum ); +CREATE INDEX part_export_option2 ON part_export_option ( option ); ALTER TABLE svc_acct ADD domsvc integer NOT NULL; ALTER TABLE svc_domain ADD catchall integer NULL; -- cgit v1.2.1 From 65f2a86b2c239782f209b481744915f858530598 Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 5 Feb 2002 09:46:07 +0000 Subject: doc --- httemplate/docs/upgrade8.html | 1 + 1 file changed, 1 insertion(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 022d1f6ae..daf73a1a3 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -7,6 +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 Archive-Tar, Time-Duration, DBIx-DataSource, and Tie-IxHash

Install Apache::ASP or HTML::Mason. -- cgit v1.2.1 From d7a54962112545979a1710f97dd5299fbd9c1aaf Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 5 Feb 2002 11:06:29 +0000 Subject: don't need DBIx::DataSource for upgrades --- httemplate/docs/upgrade8.html | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index daf73a1a3..0949315b9 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 Archive-Tar, Time-Duration, DBIx-DataSource, and Tie-IxHash +

Install Archive-Tar, Time-Duration, and Tie-IxHash

Install Apache::ASP or HTML::Mason.

-- cgit v1.2.1 From 298b8d9a262265fe7106da1ff552ce6778237034 Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 10 Feb 2002 01:48:00 +0000 Subject: remove -i option from freeside-bill (obsoleted by invoice events) --- httemplate/docs/upgrade8.html | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 0949315b9..b243eba75 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -299,6 +299,6 @@ ALTER TABLE cust_refund DROP COLUMN crednum;

Create the `/usr/local/etc/freeside/cache.datasrc' directory (ownded 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. -- cgit v1.2.1 From ddb53fcc9fc80561354b97e4e7803004990138d0 Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 10 Feb 2002 18:56:49 +0000 Subject: use unique tokens to prevent double-submission of payments in the web UI (closes: Bug#320) --- httemplate/docs/upgrade8.html | 3 +++ 1 file changed, 3 insertions(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index b243eba75..2c7008a6c 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -192,6 +192,9 @@ CREATE INDEX cust_credit_refund1 ON cust_credit_refund ( crednum ); CREATE INDEX cust_credit_refund2 ON cust_credit_refund ( refundnum ); CREATE UNIQUE INDEX cust_pay_batch_pkey ON cust_pay_batch ( paybatchnum ); CREATE UNIQUE INDEX part_svc_column1 ON part_svc_column ( svcpart, columnname ); +CREATE INDEX cust_pay2 ON cust_pay ( paynum ); +CREATE INDEX cust_pay3 ON cust_pay ( custnum ); +CREATE INDEX cust_pay4 ON cust_pay ( paybatch );

If you are using PostgreSQL, apply the following changes to your database: -- cgit v1.2.1 From 7e3eb82f87c371785544b706b7347c7edde2b593 Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 10 Feb 2002 19:58:43 +0000 Subject: update billing documentation for the new world of invoice events added freeside-daily replacing freeside-bill for the new world of invoice events --- httemplate/docs/upgrade8.html | 1 + 1 file changed, 1 insertion(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 2c7008a6c..61d956ce8 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -303,5 +303,6 @@ ALTER TABLE cust_refund DROP COLUMN crednum; (ownded by the freeside user).

freeside-queued was installed with the Perl modules. Start it now and ensure that is run upon system startup.

Use freeside-daily instead of freeside-bill. -- cgit v1.2.1 From 968f75993d7ec66d743bd5ab5e43d1d46556c27c Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 18 Feb 2002 01:26:07 +0000 Subject: rsync docs --- httemplate/docs/upgrade8.html | 1 + 1 file changed, 1 insertion(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 61d956ce8..85c33d649 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -9,6 +9,7 @@

mod_perl is now required.

Install Archive-Tar, Time-Duration, and Tie-IxHash

Install Apache::ASP or HTML::Mason. +

Install rsync

-- cgit v1.2.1 From 47bc56487b4aebf3e415767a053dc049fe4a28d4 Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 19 Feb 2002 23:43:54 +0000 Subject: set EVERYTHING=1 for your own mod_perl compile --- httemplate/docs/upgrade8.html | 10 +++++++--- 1 file changed, 7 insertions(+), 3 deletions(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 85c33d649..ac006d221 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -106,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, @@ -161,11 +165,11 @@ CREATE INDEX part_export2 ON part_export ( exporttype ); CREATE INDEX 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 ); ALTER TABLE svc_acct ADD domsvc integer NOT NULL; ALTER TABLE svc_domain ADD catchall integer NULL; -- cgit v1.2.1 From c82f33db5954253c96790918b7274566ac9182af Mon Sep 17 00:00:00 2001 From: ivan Date: Sat, 23 Feb 2002 02:02:36 +0000 Subject: UI work on main menu, remove Archive::Tar from docs --- httemplate/docs/upgrade8.html | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index ac006d221..e11041682 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 Archive-Tar, Time-Duration, and Tie-IxHash +

Install Time-Duration, and Tie-IxHash

Install Apache::ASP or HTML::Mason.

Install rsync -- cgit v1.2.1 From 69f252e5353483662c81b1d6d0e750ae08577649 Mon Sep 17 00:00:00 2001 From: khoff Date: Wed, 27 Feb 2002 17:07:28 +0000 Subject: Should be "CREATE TABLE" not "CREATE INDEX" for part_export_option --- httemplate/docs/upgrade8.html | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index e11041682..3edf425bf 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -162,7 +162,7 @@ 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, optionname varchar(80) not null, -- cgit v1.2.1 From 6a37289c12238d48ea864b8177216ca276b33a40 Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 27 Feb 2002 22:39:14 +0000 Subject: add status and statustext fields to cust_bill_event --- httemplate/docs/upgrade8.html | 2 ++ 1 file changed, 2 insertions(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 3edf425bf..a4fb1762f 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -188,6 +188,8 @@ 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; 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 ); -- cgit v1.2.1 From 239484572a9191100993bb1e85ffe8834689feb0 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 4 Mar 2002 12:48:49 +0000 Subject: *** empty log message *** --- httemplate/docs/upgrade8.html | 2 ++ 1 file changed, 2 insertions(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index a4fb1762f..874a9de7e 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -305,6 +305,8 @@ 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.

Create the `/usr/local/etc/freeside/cache.datasrc' directory (ownded by the freeside user). -- cgit v1.2.1 From 871947fde1e738eb6edadc39fc5fa7029060515a Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 6 Mar 2002 23:31:24 +0000 Subject: add freeside-expiration-alerter to upgrade8.html --- httemplate/docs/upgrade8.html | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 874a9de7e..4b0c493f0 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -313,5 +313,10 @@ ALTER TABLE cust_refund DROP COLUMN crednum;

freeside-queued was installed with the Perl modules. Start it now and ensure that is run upon system startup.

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. -- cgit v1.2.1 From f96adaf19c0097ef8c9d6f29a5541b75381cc05d Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 12 Mar 2002 15:33:22 +0000 Subject: abstract stupid HTML layer trick out to HTML::Widgets::SelectLayers --- httemplate/docs/upgrade8.html | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 4b0c493f0..2640be419 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 -- cgit v1.2.1 From daac302e231e2e09b84e771c0413b0f2119c52e8 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 18 Mar 2002 09:10:12 +0000 Subject: new config value `defaultrecords', documentation, javascript config file editor --- httemplate/docs/upgrade8.html | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 2640be419..25e766b1e 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -308,8 +308,9 @@ ALTER TABLE cust_refund DROP COLUMN crednum;

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.

Use freeside-daily instead of freeside-bill. -- cgit v1.2.1 From f1038a648b3d53db925b23519e7cd2a30c6837ed Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 20 Mar 2002 21:31:49 +0000 Subject: new export! infostreet and sqlradius provisioning switched over (Bug #299 - doesn't close it, but all the groundwork is done) also removes non-transactional ICRADIUS export from svc_acct.export (closes: Bug#347) --- httemplate/docs/upgrade8.html | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 25e766b1e..e52b69ad3 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -319,5 +319,11 @@ ALTER TABLE cust_refund DROP COLUMN crednum; 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...) -- cgit v1.2.1 From 20bb426a02c0ea54d8feaea7c5da51735ab70293 Mon Sep 17 00:00:00 2001 From: ivan Date: Fri, 22 Mar 2002 18:56:33 +0000 Subject: RADIUS groups on the way! --- httemplate/docs/upgrade8.html | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index e52b69ad3..440024de2 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -171,6 +171,14 @@ 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 ); + 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; -- cgit v1.2.1 From 87af741da0dd5f6a76bbb566b4d6c54cd5b15315 Mon Sep 17 00:00:00 2001 From: ivan Date: Fri, 5 Apr 2002 23:51:18 +0000 Subject: - add message catalog table & beginning of web interface - add security_phrase and conf option to svc_acct.pm - random other stuff --- httemplate/docs/upgrade8.html | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 440024de2..a7b5853b3 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -179,6 +179,14 @@ CREATE TABLE radius_usergroup ( 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; @@ -198,6 +206,7 @@ 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 ); -- cgit v1.2.1 From 0b65ce59c7d2ee712389c27954382274ddf718a5 Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 10 Apr 2002 13:42:49 +0000 Subject: bulk checkin from working on the road: - use msgcat for more error messages - should be all things that would come3 back from the signup server normally now - signup server: don't display access number

PostgreSQL

MySQL, others

@@ -322,9 +317,10 @@ CREATE TABLE cust_pay_temp ( _date int null, payby char(4) not null, payinfo varchar(16) null, - paybatch varchar(80) null + paybatch varchar(80) null, + closed char(1) null ); -INSERT INTO cust_pay_temp SELECT * from cust_pay; +INSERT INTO cust_pay_temp SELECT paynum, custnum, paid, _date, payby, payinfo, paybatch, closed FROM cust_pay; DROP TABLE cust_pay; ALTER TABLE cust_pay_temp RENAME TO cust_pay; CREATE UNIQUE INDEX cust_pay1 ON cust_pay (paynum); @@ -337,9 +333,10 @@ CREATE TABLE cust_refund_temp ( reason varchar(80) not null, payby char(4) not null, payinfo varchar(16) null, - paybatch varchar(80) null + paybatch varchar(80) null, + closed char(1) null ); -INSERT INTO cust_refund_temp SELECT * from cust_refund; +INSERT INTO cust_refund_temp SELECT refundnum, custnum, _date, refund, otaker, reason, payby, payinfo, '', closed from cust_refund; DROP TABLE cust_refund; ALTER TABLE cust_refund_temp RENAME TO cust_refund; CREATE UNIQUE INDEX cust_refund1 ON cust_refund (refundnum); @@ -350,16 +347,11 @@ ALTER TABLE cust_pay DROP COLUMN invnum; 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. -

As the freeside UNIX user, run bin/populate-msgcat username to populate the message catalog, passing the username of a Freeside user you c -reated above: -

-$ su freeside
-$ bin/populate-msgcat username
-

IMPORTANT: After applying the second set of database changes, run bin/dbdef-create username again. +

IMPORTANT: run bin/create-history-tables username +

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. -- cgit v1.2.1 From 45cf3a8cff466b4731a95e11ff7f4f76aee25d7c Mon Sep 17 00:00:00 2001 From: ivan Date: Fri, 21 Jun 2002 09:03:47 +0000 Subject: doc --- httemplate/docs/upgrade8.html | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 11b80e390..8ba3b5baf 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -213,7 +213,7 @@ 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 svc_domain ADD catchall integer NULL; ALTER TABLE cust_main ADD referral_custnum integer NULL; ALTER TABLE cust_main ADD comments text NULL; @@ -304,6 +304,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: -- cgit v1.2.1 From 90a4aec660be666dda630895d4e96e87a7a04028 Mon Sep 17 00:00:00 2001 From: ivan Date: Fri, 21 Jun 2002 09:28:27 +0000 Subject: don't forget part_svc in upgrades --- httemplate/docs/upgrade8.html | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 8ba3b5baf..75155407c 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -69,6 +69,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, @@ -214,6 +220,8 @@ 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 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 +242,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); -- cgit v1.2.1 From 6fb47adef49450c1fb237251aae911b0825e6869 Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 14 Jul 2002 00:28:23 +0000 Subject: no mason 1.1x yet :( --- httemplate/docs/upgrade8.html | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 75155407c..0210430ef 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. -- cgit v1.2.1 From 5153f40717ef15e1d41aeb86d29b204e84c81509 Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 28 Nov 2002 05:10:33 +0000 Subject: deprecate username_policy --- httemplate/docs/upgrade8.html | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 0210430ef..cf60a8582 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -369,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 -- cgit v1.2.1 From dfd4f9377b21a5eab563e1739f296e04668ce6ca Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 7 Apr 2005 01:29:03 +0000 Subject: ancient upgrade fix, oops. thanks Rick Harby --- httemplate/docs/upgrade8.html | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index cf60a8582..9ca7cb7b9 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -149,7 +149,9 @@ CREATE TABLE cust_bill_event ( eventnum int primary key, invnum int not null, eventpart int not null, - _date int not null + _date int not null, + status varchar(80) not null, + statustext text ); CREATE UNIQUE INDEX cust_bill_event1 ON cust_bill_event ( eventpart, invnum ); CREATE INDEX cust_bill_event2 ON cust_bill_event ( invnum ); -- cgit v1.2.1