Line 21: |
Line 21: |
| | | |
| | | |
− | 1. Create a Bookkeeping ibay | + | '''1. Create a Bookkeeping ibay '''<br> |
| This will be the directory Phreebook will run from. You must create it from Server Manager<br> | | This will be the directory Phreebook will run from. You must create it from Server Manager<br> |
− | Information bay name - bookkeeping<br> | + | Information bay name - '''bookkeeping'''<br> |
| Description – '''Phreebooks Accounting'''<br> | | Description – '''Phreebooks Accounting'''<br> |
| Group – Admin ... (set user Group)<br> | | Group – Admin ... (set user Group)<br> |
Line 31: |
Line 31: |
| <br> | | <br> |
| | | |
− | 2. Create a PhreeBooks database | + | '''2. Create a PhreeBooks database'''<br> |
| You can do it via via command line or I use [[PHPMyAdmin]]. | | You can do it via via command line or I use [[PHPMyAdmin]]. |
| | | |
Line 42: |
Line 42: |
| In PHPMyAdmin:<br> | | In PHPMyAdmin:<br> |
| Create database - '''phreebooks'''<br> | | Create database - '''phreebooks'''<br> |
− | Collation – utf8_general_ci<br> | + | Collation – '''utf8_general_ci'''<br> |
| Create user: select ''''phreebooks'''' database from list on LHS > Privileges > Add User<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> | | Choose a unique '''User Name''' and '''Password''' and (make sure that you have made a note of these!<br> |
Line 50: |
Line 50: |
| | | |
| | | |
− | 3. Sort out OpenBaseDir restriction (to allow files to be uploaded by PhreeBooks) | + | '''3. Sort out OpenBaseDir restriction'''<br> |
− | Remotely get to command line of LAN SME8 server using ssh (secure shell):
| + | This is needed to allow files to be uploaded by PhreeBooks<br> |
− | Open a terminal with root permissions (sudo su - on my Linux PC)
| + | You can read about this at [[PHP#Open_basedir_restriction]] |
− | [/list]
| |
− | Code: [Select]
| |
− | ssh root@<server ip address> -L443:localhost:443
| |
− | (Qn. Is this the best way/secure?)
| |
− | | |
− | Here are the excellent instructions: 'Modifying the PHPBaseDir setting for an ibay'
| |
− | http://wiki.contribs.org/PHP#Open_basedir_restriction
| |
| | | |
− | I can only add one tiny thing to these instructions; that if you get no response to No.1, then move straight on to the 3rd line of code in No.2. Like this:
| + | <br> |
− | | + | Remotely get to console of SME8 server using ssh (secure shell)<br> |
− | Code: [Select]
| + | Run 'sudo su -' on a Ubuntu PC use '''Putty''' on Windows PCs. |
− | db accounts setprop bookkeeping PHPBaseDir /home/e-smith/files/ibays/bookkeeping/:/tmp/
| |
− | | |
− | then don't forget to:
| |
− | Code: [Select]
| |
− | signal-event ibay-modify bookkeeping
| |
− | | |
− | Stay logged on to …
| |
| | | |
| + | ssh root@'''<server ip address>''' -L443:localhost:443 |
| | | |
| + | Then run this: |
| + | db accounts setprop bookkeeping PHPBaseDir /home/e-smith/files/ibays/bookkeeping/:/tmp/ |
| + | signal-event ibay-modify bookkeeping |
| | | |
| 4. Create an upload directory in the Software ibay: (to receive your .zip file) | | 4. Create an upload directory in the Software ibay: (to receive your .zip file) |
Line 78: |
Line 68: |
| Code: [Select] | | Code: [Select] |
| mkdir phreebooks | | mkdir phreebooks |
− |
| |
− | Stay logged on to …
| |
− |
| |
| | | |
| | | |
Line 95: |
Line 82: |
| | | |
| | | |
− | 6. Upload the PhreeBooks .zip file: | + | '''6. Upload the PhreeBooks .zip file<br> |
| + | |
| I am sure that you could cd to the upload directory in 4. and wget the .zip file straight to the created upload directory. e.g. | | I am sure that you could cd to the upload directory in 4. and wget the .zip file straight to the created upload directory. e.g. |
| wget http://sourceforge.net/projects/phreebooks/files/latest/download?source=directory | | wget http://sourceforge.net/projects/phreebooks/files/latest/download?source=directory |