+++ /dev/null
-<head>
- <title>Upgrading to 1.4.2</title>
-</head>
-<body>
-<h1>Upgrading to 1.4.2 from 1.4.1</h1>
-<ul>
- <li>If migrating from less than 1.4.1, see these <a href="upgrade9.html">instructions</a> first.
- <li>Back up your data and current Freeside installation.
- <li>Install <a href="http://search.cpan.org/search?dist=Locale-SubCountry">Locale::SubCountry</a>
- <li>Install <a href="http://search.cpan.org/search?dist=IPC-ShareLite">IPC::ShareLite</a>
- <li>Install <a href="http://search.cpan.org/search?dist=HTML-Widgets-SelectLayers">HTML::Widgets::SelectLayers</a> 0.04.
- <li>Install <a href="http://search.cpan.org/search?dist=DBIx-DBSchema">DBIx::DBSchema</a> 0.23.
- <li>Install <a href="http://search.cpan.org/search?dist=DBD-Pg">DBD::Pg</a> 1.32.
- <li>Install <a href="http://search.cpan.org/search?dist=Cache-Cache">Cache::Cache</a>.
- <li>Install <a href="http://search.cpan.org/search?dist=Net-SSH">Net::SSH</a> 0.08.
- <li>Install <a href="http://search.cpan.org/search?dist=Crypt-PasswdMD5">Crypt::PasswdMD5</a>
- <li>Install <a href="http://search.cpan.org/search?dist=Net-Whois-Raw">Net::Whois::Raw</a>
- <li>CGI.pm minimum version 2.47 is required. You will probably need to install a current CGI.pm from CPAN if you are using Perl 5.005 or earlier.
- <li>File::Temp minimum version 0.14 is required. You will probably need to install a currrent File::Temp from CPAN if you are using Perl 5.6 or earlier.
- <li>If using Apache::ASP, add <code>PerlSetVar RequestBinaryRead Off</code> to your Apache configuration and make sure you are using Apache::ASP minimum version 2.55.
- <li>Run <code>make aspdocs</code> or <code>make masondocs</code>.
- <li>Copy <code>aspdocs/</code> or <code>masondocs/</code> to your web server's document space.
- <li>Run <code>make install-perl-modules</code>.
- <li>The signup server and password server are deprecated in 1.4.2. Their functionality has been incorperated into the self-service server. Edit or reinstall your init script, and set the "signup_server-default_agentnum" and "signup_server-default_refnum" configuration options. The FS::SignupClient interface is still available as a compatibility wrapper, so you should be able to continue to use your current signup.cgi.
- <li>Optional: To use typeset invoices, install tetex and ghostscript, and copy conf/invoice_latex, conf/invoice_latexnotes, and conf/invoice_latexfooter to /usr/local/etc/freeside/conf.<datasrc>/
- <li>Restart Apache and freeside-queued.
-</body>
+++ /dev/null
-<head>
- <title>Upgrading to 1.5.8</title>
-</head>
-<body>
-<h1>Upgrading to 1.5.8 from 1.4.1 or 1.4.2</h1
-
-<table bgcolor="#dddddd">
-<tr><td>
-<i><b>Note:</b> Version numbering has been simplified. 1.5.7 and 1.5.8 are the
-versions following 1.5.0pre6. They are still development versions - releases
-with odd numbered middle parts (NN in x.NN.x) are development versions, like
-Perl or Linux.
-</td></tr>
-</table>
-<br>
-
-<ul>
- <li>If migrating from 1.5.0pre6, see README.1.5.7 instead
- <li>If migrating from 1.5.7, see README.1.5.8 instead
- <li> install DBD::Pg 1.32, 1.41 or later (not 1.40) (or, if you're using a Perl version before 5.6, you could try installing DBD::Pg 1.22 with <a href="http://420.am/~ivan/DBD-Pg-1.22-fixvercmp.patch">this patch</a> and commenting out the "use DBD::Pg 1.32" at the top of DBIx/DBSchema/DBD/Pg.pm)
- <li> 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)
- <li> install Net::SSH 0.08 or later
- <li> install HTML::Widgets::SelectLayers 0.05 or later
- <li> install Business::CreditCard 0.28 or later
-
- <li>If using Apache::ASP, add PerlSetVar RequestBinaryRead Off and PerlSetVar IncludesDir /your/freeside/document/root/ to your Apache configuration and make sure you are using Apache::ASP minimum version 2.55.
- <ul>
- <li>In httpd.conf, change <Files ~ \.cgi> to <Files ~ (\.cgi|\.html)>
- <li>In httpd.conf, change <b>AddHandler perl-script .cgi</b> or <b>SetHandler perl-script</b> to <b>AddHandler perl-script .cgi .html</b>
- </ul>
- <li>install NetAddr::IP, Chart::Base, Locale::SubCountry, Text::CSV_XS,
-Spreadsheet::WriteExcel, IO-stringy (IO::Scalar), Frontier::RPC
-(Frontier::RPC2), MIME::Entity (MIME-tools), IPC::Run3, Net::Whois::Raw,
-JSON, Term::ReadKey and Color::Scheme
-<!-- and Crypt::YAPassGen-->
-
- <li>Apply the following changes to your database:
-<pre>
-INSERT INTO msgcat ( msgnum, msgcode, locale, msg ) VALUES ( 20, 'svc_external-id', 'en_US', 'External ID' );
-INSERT INTO msgcat ( msgnum, msgcode, locale, msg ) VALUES ( 21, 'svc_external-title', 'en_US', 'Title' );
-
-DROP INDEX cust_bill_pkg1;
-</pre>
-
- <li>On recent Pg versions:
-<pre>
-ALTER TABLE cust_main ALTER COLUMN payinfo varchar(512) NULL;
-ALTER TABLE h_cust_main ALTER COLUMN payinfo varchar(512) NULL;
-ALTER TABLE cust_pay_batch ADD COLUMN batchnum int NOT NULL;
-ALTER TABLE cust_pay_batch ALTER COLUMN batchnum SET NOT NULL;
-ALTER TABLE cust_pay_batch ADD COLUMN payinfo varchar(512) NULL;
-UPDATE cust_pay_batch SET payinfo = cardnum;
-ALTER TABLE cust_pay_batch DROP COLUMN cardnum;
-ALTER TABLE h_cust_pay_batch ADD COLUMN payinfo varchar(512) NULL;
-UPDATE h_cust_pay_batch SET payinfo = cardnum;
-ALTER TABLE h_cust_pay_batch DROP COLUMN cardnum;
-</pre>
-On older Pg versions that don't support altering columns directly, you will need to dump the database, edit the schema definitions in the dump file, and reload.
-
- <li>On recent Pg versions:
-<pre>
-ALTER TABLE svc_forward ALTER COLUMN srcsvc DROP NOT NULL;
-ALTER TABLE h_svc_forward ALTER COLUMN srcsvc DROP NOT NULL;
-ALTER TABLE svc_forward ALTER COLUMN dstsvc DROP NOT NULL;
-ALTER TABLE h_svc_forward ALTER COLUMN dstsvc DROP NOT NULL;
-ALTER TABLE cust_main ALTER COLUMN zip DROP NOT NULL;
-ALTER TABLE h_cust_main ALTER COLUMN zip DROP NOT NULL;
-</pre>
-Or on Pg versions that don't support DROP NOT NULL (tested on 7.1 and 7.2 so far):
-<pre>
-UPDATE pg_attribute SET attnotnull = FALSE WHERE ( attname = 'srcsvc' OR attname = 'dstsvc' ) AND ( attrelid = ( SELECT oid FROM pg_class WHERE relname = 'svc_forward' ) OR attrelid = ( SELECT oid FROM pg_class WHERE relname = 'h_svc_forward' ) );
-UPDATE pg_attribute SET attnotnull = FALSE WHERE ( attname = 'zip' ) AND ( attrelid = ( SELECT oid FROM pg_class WHERE relname = 'cust_main' ) OR attrelid = ( SELECT oid FROM pg_class WHERE relname = 'h_cust_main' ) );
-</pre>
-
- <li> If you created your database with a version before 1.4.2, dump database, edit the following, then reload:
- <ul>
- <li>cust_main and h_cust_main: increase otaker from 8 to 32
- <li>cust_main and h_cust_main: change ss from char(11) to varchar(11) ( "character(11)" to "character varying(11)" )
- <li>cust_credit and h_cust_credit: increase otaker from 8 to 32
- <li>cust_pkg and h_cust_pkg: increase otaker from 8 to 32
- <li>cust_refund and h_cust_refund: increase otaker from 8 to 32
- <li>domain_record and h_domain_record: increase reczone from 80 to 255
- <li>domain_record and h_domain_record: change rectype from char to varchar ( "character(5)" to "character varying(5)" )
- <li>domain_record and h_domain_record: increase recdata from 80 to 255
- </ul>
-
-<li>make install-perl-modules to install the new libraries and CLI utilities
-<li>run "freeside-upgrade username" to create the remaining new tables and columns
-
-<li>optionally:
-<pre>
-CREATE INDEX cust_main4 ON cust_main ( daytime );
-CREATE INDEX cust_main5 ON cust_main ( night );
-CREATE INDEX cust_main6 ON cust_main ( fax );
-CREATE INDEX cust_main7 ON cust_main ( refnum );
-CREATE INDEX cust_main8 ON cust_main ( county );
-CREATE INDEX cust_main9 ON cust_main ( state );
-CREATE INDEX cust_main10 ON cust_main ( country );
-CREATE INDEX cust_main11 ON cust_main ( ship_last );
-CREATE INDEX cust_main12 ON cust_main ( ship_company );
-CREATE INDEX cust_main13 ON cust_main ( ship_daytime );
-CREATE INDEX cust_main14 ON cust_main ( ship_night );
-CREATE INDEX cust_main15 ON cust_main ( ship_fax );
-CREATE INDEX agent2 ON agent ( disabled );
-CREATE INDEX part_bill_event2 ON part_bill_event ( disabled );
-CREATE INDEX cust_pay4 ON cust_pay (_date);
-CREATE INDEX part_referral1 ON part_referral ( disabled );
-CREATE INDEX part_pkg2 ON part_pkg ( promo_code );
-CREATE INDEX h_part_pkg2 ON h_part_pkg ( promo_code );
-</pre>
-
-</ul>
-
-</body>
-</html>
+++ /dev/null
-<head>
- <title>Upgrading to 1.4.1</title>
-</head>
-<body>
-<h1>Upgrading to 1.4.1 from 1.4.0</h1>
-<ul>
- <li>If migrating from less than 1.4.0, see these <a href="upgrade8.html">instructions</a> first.
- <li>Back up your data and current Freeside installation.
- <li>Run <code>make aspdocs</code> or <code>make masondocs</code>.
- <li>Copy <code>aspdocs/</code> or <code>masondocs/</code> to your web server's document space.
- <li>Run <code>make install-perl-modules</code>.
- <li>Install <a href="http://search.cpan.org/search?dist=Net-SSH">Net::SSH</a> minimum version 0.07
- <li>Apply the following changes to your database:
-<pre>
-INSERT INTO msgcat ( msgnum, msgcode, locale, msg ) VALUES ( 18, 'daytime', 'en_US', 'Day Phone' );
-INSERT INTO msgcat ( msgnum, msgcode, locale, msg ) VALUES ( 19, 'night', 'en_US', 'Night Phone' );
-</pre>
- <li>Optionally, apply the following changes to your database (performance improvements):
-<pre>
-CREATE INDEX part_pkg1 ON part_pkg ( disabled );
-CREATE INDEX part_svc1 ON part_svc ( disabled );
-CREATE INDEX cust_bill2 ON cust_bill ( _date );
-</pre>
- <li>If you want to use ACH (electronic checks), you will need to make changes to your database. The easiest way to make these changes is to dump your database (with pg_dump), change the payinfo field in the cust_pay, cust_refund, h_cust_pay and h_cust_refund tables from varchar(16) to varchar(80), reload the database from the dump.
- <li>If you will be doing bind exports you should make additional changes to your database. Follow the directions above to dump the database and change the reczone and recdata fields in the domain_record and h_domain_record tables from varchar(80) to varchar(255).
- <li>If you made changes to your db schema from a dump as listed above run dbdef-create.
- <li>Restart Apache and freeside-queued.
-</body>
projects / freeside.git / commitdiff