147
edits
Changes
From SME Server
Jump to navigationJump to search
mLine 21:
Line 21: − + − + Line 31:
Line 31: − + Line 42:
Line 42: − + Line 50:
Line 50: − + − Remotely get to command line of LAN SME8 server using ssh (secure shell):+ − Open a terminal with root permissions (sudo su - on my Linux PC)+ − [/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:+ − + − Code: [Select]+ − 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 … + + + + Line 78:
Line 68: − − Stay logged on to … − Line 95:
Line 82: − + +
→Set-up on SME8
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>
<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]].
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>
3. Sort out OpenBaseDir restriction (to allow files to be uploaded by PhreeBooks)
'''3. Sort out OpenBaseDir restriction'''<br>
This is needed to allow files to be uploaded by PhreeBooks<br>
You can read about this at [[PHP#Open_basedir_restriction]]
<br>
Remotely get to console of SME8 server using ssh (secure shell)<br>
Run 'sudo su -' on a Ubuntu PC use '''Putty''' on Windows PCs.
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)
Code: [Select]
Code: [Select]
mkdir phreebooks
mkdir phreebooks
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
