<img src="overview.png">
<ul>
<li><a href="install.html">New Installation</a>
- <li><a href="upgrade4.html">Upgrading from 1.2.x to 1.2.2</a>
- <li><a href="upgrade5.html">Upgrading from 1.2.2 to 1.2.3</a>
- <li><a href="upgrade6.html">Upgrading from 1.2.3 to 1.3.0</a>
<li><a href="upgrade7.html">Upgrading from 1.3.0 to 1.3.1</a>
<li><a href="upgrade8.html">Upgrading from 1.3.1 to 1.4.0</a>
<li><a href="upgrade9.html">Upgrading from 1.4.0 to 1.4.1</a>
<li>POP mail accounts have entries in passwd only, and have a particular shell.
<li>Everything else in passwd is a shell account.
</ul>
- <li><a name="svc_acct_sm">bin/svc_acct_sm.import</a> - Import qmail ( `virtualdomains' and `rcpthosts' ), or sendmail ( `virtusertable' and `sendmail.cw' ) files. Before running bin/svc_acct_sm.import, you need <a href="../browse/part_svc.cgi">services</a> as follows:
+
<!-- <li><a name="svc_acct_sm">bin/svc_acct_sm.import</a> - Import qmail ( `virtualdomains' and `rcpthosts' ), or sendmail ( `virtusertable' and `sendmail.cw' ) files. Before running bin/svc_acct_sm.import, you need <a href="../browse/part_svc.cgi">services</a> as follows:
<ul>
<li>Domain (table svc_acct)
<li>Mail alias (table svc_acct_sm)
</ul>
+-->
<li><a name="cust_main">Importing customer data</a>
<ul>
<li>Manually
+++ /dev/null
-<head>
- <title>Upgrading to 1.2.2</title>
-</head>
-<body>
-<h1>Upgrading to 1.2.2 from 1.2.x</h1>
-<ul>
- <li>If migrating from 1.0.0, see these <a href="upgrade.html">instructions</a> first.
- <li>If migrating from less than 1.1.4, see these <a href="upgrade2.html">instructions</a> first.
- <li>If migrating from less than 1.2.0, see these <a href="upgrade3.html">instructions</a> first.
- <li>Back up your data and current Freeside installation.
- <li>Install the Perl modules <a href="http://www.perl.com/CPAN/modules/by-module/Locale/">Locale-Codes</a> and <a href="http://www.perl.com/CPAN/modules/by-module/Net/">Net-Whois</a>.
- <li>Apply the following changes to your database:
-<pre>
-ALTER TABLE cust_pay_batch CHANGE exp exp VARCHAR(11);
-</pre>
- <li>Copy or symlink htdocs to the new copy.
- <li>Remove the symlink or directory <i>(your_site_perl_directory)</i>/FS.
- <li>Change to the FS directory in the new tarball, and build and install the
- Perl modules:
- <pre>
-$ cd FS/
-$ perl Makefile.PL
-$ make
-$ su
-# make install</pre>
- <li>Run bin/dbdef-create. This file uses MySQL-specific syntax. If you are running a different database engine you will need to modify it slightly.
-</body>
+++ /dev/null
-<head>
- <title>Upgrading to 1.3.0</title>
-</head>
-<body>
-<h1>Upgrading to 1.2.3 from 1.2.2</h1>
-<ul>
- <li>If migrating from 1.0.0, see these <a href="upgrade.html">instructions</a> first.
- <li>If migrating from less than 1.1.4, see these <a href="upgrade2.html">instructions</a> first.
- <li>If migrating from less than 1.2.0, see these <a href="upgrade3.html">instructions</a> first.
- <li>If migrating from less than 1.2.2, see these <a href="upgrade4.html">instructions</a> first.
- <li>Back up your data and current Freeside installation.
- <li>Apply the following changes to your database:
-<pre>
-ALTER TABLE svc_acct_pop ADD loc CHAR(4);
-CREATE TABLE prepay_credit (
- prepaynum int NOT NULL,
- identifier varchar(80) NOT NULL,
- amount decimal(10,2) NOT NULL,
- PRIMARY KEY (prepaynum),
- INDEX (identifier)
-);
-</pre>
- <li>Copy or symlink htdocs to the new copy.
- <li>Remove the symlink or directory <i>(your_site_perl_directory)</i>/FS.
- <li>Change to the FS directory in the new tarball, and build and install the
- Perl modules:
- <pre>
-$ cd FS/
-$ perl Makefile.PL
-$ make
-$ su
-# make install</pre>
- <li>Run bin/dbdef-create. This file uses MySQL-specific syntax. If you are running a different database engine you will need to modify it slightly.
-</body>
+++ /dev/null
-<head>
- <title>Upgrading to 1.3.0</title>
-</head>
-<body>
-<h1>Upgrading to 1.3.0 from 1.2.3</h1>
-<ul>
- <li>If migrating from 1.0.0, see these <a href="upgrade.html">instructions</a> first.
- <li>If migrating from less than 1.1.4, see these <a href="upgrade2.html">instructions</a> first.
- <li>If migrating from less than 1.2.0, see these <a href="upgrade3.html">instructions</a> first.
- <li>If migrating from less than 1.2.2, see these <a href="upgrade4.html">instructions</a> first.
- <li>If migrating from less than 1.2.3, see these <a href="upgrade5.html">instructions</a> first.
- <li>Back up your data and current Freeside installation.
- <li>As 1.3.0 requires transactions, <b>MySQL's default <a href="http://www.mysql.com/doc/M/y/MyISAM.html">MyISAM</a> and <a href="http://www.mysql.com/doc/I/S/ISAM.html">ISAM</a> table types are no longer supported</b>. Converting to <a href="http://www.postgresql.org/">PostgreSQL</a> is recommended. If you really want to use MySQL, convert your tables to one of the <a href="http://www.mysql.com/doc/T/a/Table_types.html">transaction-safe table types</a> such as <a href="http://www.mysql.com/doc/B/D/BDB.html">BDB</a>.
- <li>Copy the <i>invoice_template</i> file from the <i>conf/</i> directory in the distribution to your <a href="config.html">configuration directory</a>.
- <li>Install the <a href="http://search.cpan.org/search?dist=Text-Template">Text-Template</a>, <a href="http://search.cpan.org/search?dist=DBIx-DBSchema">DBIx-DBSchema</a>, <a href="http://search.cpan.org/search?dist=Net-SSH">Net-SSH</a>, <a href="http://search.cpan.org/search?dist=String-ShellQuote">String-ShellQuote</a> and <a href="http://search.cpan.org/search?dist=Net-SCP">Net-SCP</a> Perl modules.
- <li>Apply the following changes to your database:
-<pre>
-CREATE TABLE domain_record (
- recnum int NOT NULL,
- svcnum int NOT NULL,
- reczone varchar(80) NOT NULL,
- recaf char(2) NOT NULL,
- rectype char(5) NOT NULL,
- recdata varchar(80) NOT NULL,
- PRIMARY KEY (recnum)
-);
-CREATE TABLE svc_www (
- svcnum int NOT NULL,
- recnum int NOT NULL,
- usersvc int NOT NULL,
- PRIMARY KEY (svcnum)
-);
-ALTER TABLE part_svc ADD svc_www__recnum varchar(80) NULL;
-ALTER TABLE part_svc ADD svc_www__recnum_flag char(1) NULL;
-ALTER TABLE part_svc ADD svc_www__usersvc varchar(80) NULL;
-ALTER TABLE part_svc ADD svc_www__uesrsvc_flag char(1) NULL;
-ALTER TABLE svc_acct CHANGE _password _password varchar(50) NULL;
-ALTER TABLE svc_acct ADD seconds integer NULL;
-ALTER TABLE part_svc ADD svc_acct__seconds integer NULL;
-ALTER TABLE part_svc ADD svc_acct__seconds_flag char(1) NULL;
-ALTER TABLE prepay_credit ADD seconds integer NULL;
-
-</pre>
- <li>If your database supports dropping columns:
-<pre>
-ALTER TABLE cust_bill DROP owed;
-ALTER TABLE cust_credit DROP credited;
-</pre>
- Or, if your database does not support dropping columns, you can do this:
-<pre>
-ALTER TABLE cust_bill CHANGE owed depriciated decimal(10,2);
-ALTER TABLE cust_credit CHANGE credited depriciated2 decimal(10,2);
-</pre>
-
- <li>Copy or symlink htdocs to the new copy.
- <li>Remove the symlink or directory <i>(your_site_perl_directory)</i>/FS.
- <li>Change to the FS directory in the new tarball, and build and install the
- Perl modules:
- <pre>
-$ cd FS/
-$ perl Makefile.PL
-$ make
-$ su
-# make install</pre>
- <li>Run bin/dbdef-create.
-</body>
projects / freeside.git / commitdiff