Line 22: |
Line 22: |
| | | |
| | | |
− | 1. Create a Bookkeeping ibay (from which to run PhreeBooks) using Server Manager<br> | + | 1. Create a Bookkeeping ibay |
− | Information bay name - bookkeeping | + | This will be the directory Phreebook will run from. You must create it from Server Manager<br> |
− | Description – '''Phreebooks Accounting''' | + | Information bay name - bookkeeping<br> |
− | Group – Admin ... (set user Group) | + | Description – '''Phreebooks Accounting'''<br> |
− | User access via file sharing or user ftp – '''Write = group, Read = group''' | + | Group – Admin ... (set user Group)<br> |
− | Public access via web or anonymous ftp – '''Local network, no password required''' | + | User access via file sharing or user ftp – '''Write = group, Read = group'''<br> |
− | Execution of dynamic content (CGI, PHP, SSI) – '''Enabled''' | + | Public access via web or anonymous ftp – '''Local network, no password required''' <br> |
| + | Execution of dynamic content (CGI, PHP, SSI) – '''Enabled'''<br> |
| + | <br> |
| | | |
| + | 2. Create a PhreeBooks database |
| + | You can do it via via command line or I use [[PHPMyAdmin]]. |
| | | |
− | 2. Create a PhreeBooks database (either via command line or I use phpMyAdmin)
| + | {{Note box| Please note that it is strongly advised to set MySQL to default to the InnoDB format using [[MySQL#Enable_InnoDB_engine]] <br> |
− | Please note that it is strongly advised to set MySQL to default to the InnoDB format and not | + | and not MyISAM, as apparently InnoDB is 'more robust'. <br> |
− | MyISAM, as apparently InnoDB is 'more robust'. PhpMyAdmin seems to be set out-of-the-box to default to MyISAM. | + | BTW: PhpMyAdmin seems to be set out-of-the-box to default to MyISAM. <br> |
− | | + | <br> |
− | phpMyAdmin - http://stackoverflow.com/questions/3939099/phpmyadmin-showing-myisam-instead-of-innodb
| + | This InnoDB / MyISAM issue won't affect getting PhreeBooks going now, however, may cause some data integrity uncertainty down the road. Best to get it right now. }} |
− | phpMyAdmin - http://virtualizesharepoint.com/2011/05/11/convert-myisam-to-innodb-using-phpmyadmin-for-moodle/
| |
− | MySQL - http://wiki.contribs.org/MySQL
| |
− | | |
− | This InnoDB / MyISAM issue won't affect getting PhreeBooks going now, however, may cause some data integrity uncertainty down the road. Best to get it right now. | |
− | | |
− | In phpMyAdmin:
| |
− | Create database - phreebooks
| |
− | Collation – utf8_general_ci
| |
− | Create user: select 'phreebooks' database from list on LHS > Privileges > Add User
| |
− | set unique User Name and Password (make sure that you have made a note of these)
| |
− | host - localhost
| |
− | Database for user - Grant all privileges on database “phreebooks”
| |
− | Add User
| |
| | | |
| + | In PHPMyAdmin:<br> |
| + | Create database - '''phreebooks'''<br> |
| + | Collation – utf8_general_ci<br> |
| + | Create user: select ''''phreebooks'''' database from list on LHS > Privileges > Add User<br> |
| + | Choose a unique '''User Name''' and '''Password''' and (make sure that you have made a note of these!<br> |
| + | host - '''localhost'''<br> |
| + | Database for user - '''Grant all privileges''' on database '''phreebooks'''<br> |
| + | '''Add User'''<br> |
| | | |
| | | |