-
-
- <li>
-
- <h3>Creating the Database</h3>
-
-
-
- <ol>
-
-
- <li>NOTE : As FrontAccounting is still heavily under
- development, the database structure will ALWAYS change between releases, so
- if you have a database that you created for a previous release of
- FrontAccounting, it WILL NOT WORK after installing a new release. You may
- run the script, update_db.php and select the appropriate script, f.i.
- alter.sql (from release 1.XX to release 2.0).
-
-
- <li>We strongly suggest using a GUI to manage your database(s) and database users. If you don\92t have any, download <a href="http://www.phpmyadmin.net/"><strong>phpMyAdmin</strong></a>.
-
-
- <li>Create a database with a name of your choice. The default in config_db.php is \91<strong><em>frontacc</em></strong>\92, but of course you can select
- whatever name you desire.
-
-
- <li>Populate the database you have created. There are two scripts
-are provided to populate the database (both inside the folder /sql) :
-
-
- <ol>
-
-
- <li><strong><em>en_US-demo.sql</em></strong>. This has a minimal
- amount of demonstration data set up so that transactions can be tried to
- see how the system works.
-
-
- <li><strong><em>en_US-new.sql</em></strong>. This script has
-only the basic data necessary to start a new company system off. If you
-wish to set up your company on FrontAccounting then this is the script
-to use. </li>
-
-
-
- </ol>
-
-
- <li>Now that the database is created you will need to
- set up a database user to access this database. DO NOT USE THE USER \91ROOT\92.
- Set up a new user and give that user full privileges over the database
- \91frontacc\92.
- <li>After successfully install, remove or rename your install directory <strong><em>your_url/account/install</em></strong> (or
-whatever directory you entered) for safety reasons. You don't need it any more.</li>
-
-
-
- </ol>
-
-
- <li>
-
- <h3>Editing config_db.php</h3>
-
-
-
- <ol>
-
-
- <li><strong><em>config_db.php</em></strong> contains connection
- information for the database. These must be set to your local settings or
- you will not be able to access FrontAccounting.
-
-
- <li>FrontAccounting allows multiple connections, you
- can enter as many connections as you have separate entities (most people
- will use only one).
-
-
- <li><strong>$db_connections</strong> is an array of connections \96
- for each connection :
-
-
- <li>\93<strong>name</strong>\94 is the
- name of the connection, this is the name that will be displayed to the user
-
-
- <li>\93<strong>host</strong>\94 is the
- computer IP address or name where the database is. The default is localhost
- assuming that the web server is also the sql server.
-
-
- <li>\93<strong>dbuse</strong>r\94 is
- the user name under which the database should be accessed. NB, again, do not
- use the user ROOT. A user with appropriate privileges must be set up.
-
-
- <li>\93<strong>dbpassword</strong>\94
- is the password for \93dbuser\94. You would have entered this when you created
- \93dbuser\94.
-
-
- <li>\93<strong>dbname</strong>\94 is
- the name of the database. The provided scripts use the name OpenAccounting.
-
-
- <li>\93<strong>tbpref</strong>\94 is the table prefix for
-the tables. If you only have access to one database, you must use table
-prefix to separate the companies. Table prefix is set by a table prefix
-counter inside config_db.php, fi. 0_ for the first company.</li>
-
-
-
- </ol>
-
-
- </li>
-
-
-</ol>
-
-
-<h2> Logging In For the First Time</h2>
-
-
-<ol>
-
-
- <li>Pleae ensure that the folder <strong>/company/0</strong> on the server is <strong>writable</strong>.
-
-
- <li>Open a browser and enter the URL for the web server
- directory where FrontAccounting is installed.
-
-
- <li>Enter the user name: '<strong>admin</strong>'
-
-
- <li>Enter the password: '<strong>password</strong>'
-
-
- <li>(NB : enter without quotation marks).
-
-
- <li>
-
- <div>You can set up additional user accounts from the System Setup