 documentation home | 3. Configuring the PMB database | |
|---|---|---|
 | Chapter 5. Windows |  |
documentation home | 3. Configuring the PMB database | |
|---|---|---|
| | Chapter 5. Windows | |
To install the database to be used by PMB, you have to access the quick install page http://localhost/pmb/tables/install.php. Complete the Home page address of the application http://localhost/pmb/ on the address bar of your browser with ./tables/install.php to look like this http://localhost/pmb/tables/install.php.
Upon validation, the following page should appear on your screen :
You are required to provide some precision here. For the time being, we advise you to leave the values already entered as they are. The fill-in form ends with a tick box 'Load tables with the test set?". Tick this option if you wish the install script to include a data test set to start using the application. This is optional, you may equally start by entering your own data.
Now click the 'Create the database' button to confirm.
The creation process of the PMB database goes very quickly. As soon as it is completed, the following page appears on your screen :
If the page displays error messages, it's a good idea to save it with the "Save Page As..." of your browser for eventual transmission to people in a position to help you (see the section What if you can't do it ? of this guide).
The installation of PMB is now complete.
To access PMB from now on, you need only start your internet browser and go to the address : http://localhost/pmb/. On some systems (certain versions of Windows), when you start the application for the first time, the machine may try to connect to Internet. If it were to happen, try clicking 'work offline' to continue. Finally, if the problem persists, access PMB by using this address : http://127.0.0.1/pmb/ (it is the same as the previous one).
Very important : When you start PMB for the first time, the username is admin and the password is admin. It is the only login created during the install process. It is up to you to create new users from the menu administration>manage users. It is a good thing too to change the password of user admin, the existing one being a default password.
When you install a version of PMB and you wish to test the application, you can use the test data provided in the distribution. These test data can be loaded automatically during the PMB install process or manually later on. They are located in various files inside your_dir_pmb/tables.
Files description
bibli.sql : the database structure only, no data
minimum.sql : user admin/admin, application's settings
feed_essential.sql : what you need to run the application in quick-start mode :
the appliction's preloaded data, modifications allowed
a backup set ready to use
a set of Z39.50 settings
data_test.sql : a small selection of records, borrowers data for testing PMB immediately :
Records, borrowers, lenders, items, serials
Based on data supplied in feed_essential.sql
Must load the thesaurus UNESCO_FR supplied in unesco_fr.sql
Note : you can delete the test data after evaluating PMB as they can pollute your database later. For this, use one of the scripts /tables/empty_example_set; for more details consult the Administrator's Guide of PMB.
Thesaurus :
3 thesauri are offered to you :
unesco_fr.sql : the UNESCO thesaurus, hierarchical structure, quite large and well made
agneaux.sql : smaller, simpler, but equally well made
environnement : a possible thesaurus for an Environment based collection
You will find here a list of data tables loaded by these various SQL files. To run an SQL file using the command line with MySQL, go to the MySQL documentation.
minimum.sql
Content of table `paramètres'
Content of table `users` : user admin/admin
feed_essential.sql
same as minimum.sql plus
Content of table `docs_codestat'
Content of table `docs_location`
Content of table `docs_section`
Content of table `docs_statut`
Content of table `docs_type`
Content of table `empr_categ`
Content of table `empr_codestat`
Content of table `lenders`
Content of table `sauv_lieux`
Content of table `sauv_sauvegardes`
Content of table `sauv_tables`
Content of table `z_attr`
Content of table `z_bib`
data_test.sql
same as feed_essential.sql plus
Content of table `users` : additional users
Content of table `empr`
Content of table `empr_groupe`
Content of table `groupe`
Content of table `notices`
Content of table `exemplaires`
Content of table `authors`
Content of table `publishers`
Content of table `collections`
Content of table `sub_collections`
Content of table `responsability`
Content of table `bulletins`
Content of table `analysis`
Content of table `notices_categories`
agneaux.sql or unesco_fr.sql or environnement.sql
Content of table `categories`
Content of table `categ_assoc`
| |  | |
| 2. Manual install |  | 4. What if you can't do it ? |
