summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorivan <ivan>2001-04-22 00:45:57 +0000
committerivan <ivan>2001-04-22 00:45:57 +0000
commit18700d872d6379527f5dca6e5b051dfb960aab20 (patch)
tree67852822361ff5d17c647e82c951bd2169ff62f7
parent942ef7ba86d01a57c9daca0c7c522560b7e73966 (diff)
update postgres examples
-rw-r--r--htdocs/docs/config.html10
-rw-r--r--htdocs/docs/install.html6
2 files changed, 8 insertions, 8 deletions
diff --git a/htdocs/docs/config.html b/htdocs/docs/config.html
index db4b95427..b255ce30e 100644
--- a/htdocs/docs/config.html
+++ b/htdocs/docs/config.html
@@ -18,18 +18,18 @@ admin secretfile
john secretfile
sam secretfile
</pre>
- <li>Next, the filename(s) referenced in <b>/usr/local/etc/freeside/mapsecrets</b> file should be created in the <b>/usr/local/etc/freeside/</b> directory. This file contains three lines: <a href="http://search.cpan.org/doc/TIMB/DBI-1.15/DBI.pm">DBI data source</a> (for example,
- <tt>DBI:mysql:freeside</tt> or <tt>DBI:Pg:dbname=freeside</tt>), database username, and database password.
- This file should not be world readable. See the <a href="http://search.cpan.org/doc/TIMB/DBI-1.15/DBI.pm">DBI manpage</a> and the <a href="http://search.cpan.org/search?mode=module&query=DBD">manpage for your DBD</a> for the exact syntax of a DBI data source. For example:
+ <li>Next, the filename(s) referenced in <b>/usr/local/etc/freeside/mapsecrets</b> file should be created in the <b>/usr/local/etc/freeside/</b> directory. Each file contains three lines: <a href="http://search.cpan.org/doc/TIMB/DBI-1.15/DBI.pm">DBI data source</a> (for example,
+ <tt>DBI:mysql:freeside</tt> or <tt>DBI:Pg:host=localhost;dbname=freeside</tt>), database username, and database password.
+ These files should not be world readable. See the <a href="http://search.cpan.org/doc/TIMB/DBI-1.15/DBI.pm">DBI manpage</a> and the <a href="http://search.cpan.org/search?mode=module&query=DBD">manpage for your DBD</a> for the exact syntax of a DBI data source. In a normal installation such as the example above, a single file <b>/usr/local/etc/freeside/secretfile</b> would be created - for example:
<pre>
-DBI:Pg:dbname=freeside
+DBI:Pg:host=localhost;dbname=freeside
dbusername
dbpassword
</pre>
</ul>
All further configuration files and directories are located in
<tt>/usr/local/etc/freeside/conf.<i>datasource</i></tt>, for example,
-<tt>/usr/local/etc/freeside/conf.DBI:Pg:dbname=freeside</tt>
+<tt>/usr/local/etc/freeside/conf.DBI:Pg:host=localhost;dbname=freeside</tt> (remember to backslash-escape the ; character when creating directories in the shell: <tt>mkdir&nbsp;/usr/local/etc/freeside/conf.DBI:Pg:host=localhost\;dbname=freeside</tt>).
<ul>
<li><a name="address">address</a> - This configuration file is no longer used. See <a href="#invoice_template">invoice_template</a> instead.
<li><a name="apacheroot">apacheroot</a> - The directory containing Apache virtual hosts
diff --git a/htdocs/docs/install.html b/htdocs/docs/install.html
index 4bc43358f..af5251d5d 100644
--- a/htdocs/docs/install.html
+++ b/htdocs/docs/install.html
@@ -37,14 +37,14 @@ Before installing, you need:
Install the Freeside distribution:
<ul>
<li>Add the user `freeside' to your system.
- <li>Add the freeside database to your database engine. (with <a href="http://www.mysql.com/Manual_chapter/manual_Reference.html#CREATE_DATABASE">MySQL</a>) (with <a href="http://www.postgresql.org/docs/admin/manage-ag.htm#AEN854">PostgreSQL</a>)
<li>Allow the freeside user full access to the freeside database.
<ul>
<li> with <a href="http://www.mysql.com/Manual_chapter/manual_Privilege_system.html#Privilege_system">MySQL</a>:<pre>$ mysqladmin -u root password '<i>set_a_root_database_password</i>'
$ mysql -u root -p
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE,DROP on freeside.* TO freeside@localhost IDENTIFIED BY '<i>set_a_freeside_database_password</i>';</pre>
- <li> with <a href="http://www.postgresql.org/docs/admin/newuser.htm">PostgreSQL</a>
+ <li> with <a href="http://postgresql.readysetnet.com/users-lounge/docs/7.1/postgres/user-manag.html#DATABASE-USERS">PostgreSQL</a>
</ul>
+ <li>Add the freeside database to your database engine. (with <a href="http://www.mysql.com/Manual_chapter/manual_Reference.html#CREATE_DATABASE">MySQL</a>) (with <a href="http://postgresql.readysetnet.com/users-lounge/docs/7.1/postgres/managing-databases.html#MANAGE-AG-CREATEDB">PostgreSQL</a>)
<li>Unpack the tarball: <pre>gunzip -c fs-x.y.z.tar.gz | tar xvf -</pre>
<li>Build and install the Perl libraries:
<pre>
@@ -52,7 +52,7 @@ $ cd FS/
$ perl Makefile.PL
$ make
$ su
-# make install</pre>
+# make install UNINST=1</pre>
<li>Copy or link fs-x.y.z/htdocs to your web server's document space. <pre>mkdir /usr/local/apache/htdocs/freeside
cp -r fs-x.y.z/htdocs/* /usr/local/apache/htdocs/freeside</pre> or <pre>ln -s /full/path/to/fs-x.y.z/htdocs /usr/local/apache/htdocs/freeside</pre>
<li>Restrict access to this web interface. (with <a href="http://httpd.apache.org/docs/misc/FAQ.html#user-authentication">Apache</a>)