diff options
author | ivan <ivan> | 2001-04-22 00:45:57 +0000 |
---|---|---|
committer | ivan <ivan> | 2001-04-22 00:45:57 +0000 |
commit | 18700d872d6379527f5dca6e5b051dfb960aab20 (patch) | |
tree | 67852822361ff5d17c647e82c951bd2169ff62f7 | |
parent | 942ef7ba86d01a57c9daca0c7c522560b7e73966 (diff) |
update postgres examples
-rw-r--r-- | htdocs/docs/config.html | 10 | ||||
-rw-r--r-- | htdocs/docs/install.html | 6 |
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 /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>) |