Difference between revisions of "Henriette"
(→MySQL) |
(→MySQL) |
||
Line 14: | Line 14: | ||
#Configure to run: server machine, multifunctional DB, C: as installation path, online transaction processing (oltp), enable tcp/ip networking on 3306 port, enable strict mode, multilanguage utf-8, install as a windows service, include bin directory, set root passwork, enable access from remote machines. | #Configure to run: server machine, multifunctional DB, C: as installation path, online transaction processing (oltp), enable tcp/ip networking on 3306 port, enable strict mode, multilanguage utf-8, install as a windows service, include bin directory, set root passwork, enable access from remote machines. | ||
#Security considerations with mysql. | #Security considerations with mysql. | ||
− | + | ##You might need to allow port 3306 as an exeption through the firewall settings in windows for it to work. | |
− | + | ##You might also want to change the root user and password for security reasons. | |
#Download [http://www.phpmyadmin.net/home_page/downloads.php phpmyadmin] - the english version or multilanguage if you wish. | #Download [http://www.phpmyadmin.net/home_page/downloads.php phpmyadmin] - the english version or multilanguage if you wish. | ||
#Extract the zip folder to C:\ms4w\Apache\htdocs and maybe further into a folder system only you know for security reasons. | #Extract the zip folder to C:\ms4w\Apache\htdocs and maybe further into a folder system only you know for security reasons. |
Revision as of 08:52, 9 August 2007
Contents
Setup
ms4w
This service has been installed on all the servers and the directory structure in the ms4w\Apache\htdocs folder is either 'projects' or 'students'. The 'students' folder is divided into the different students user names and the 'projects' folder is divided into the project names. From this follows that the portus project code is all in ms4w\Apache\htdocs\projects\portus_ark and my own sintana project is in ms4w\Apache\htdocs\students\hro106\sintana.
When setting up ms4w I have changed the LISTEN setting in ms4w\Apache\conf\httpd.conf from 80 to 8080 since most of the servers already had some other service running on 80. This means that the root of the server can be reached from http://localhost:8080 or the equivalent. So for the ay-dehus server the address is http://ay-dehus.soton.ac.uk:8080/ and then the folders which lead to the projects and the ark code.
MySQL
- Download MySQL from http://dev.mysql.com/downloads/mysql
- Install to c:\program files
- Configure to run: server machine, multifunctional DB, C: as installation path, online transaction processing (oltp), enable tcp/ip networking on 3306 port, enable strict mode, multilanguage utf-8, install as a windows service, include bin directory, set root passwork, enable access from remote machines.
- Security considerations with mysql.
- You might need to allow port 3306 as an exeption through the firewall settings in windows for it to work.
- You might also want to change the root user and password for security reasons.
- Download phpmyadmin - the english version or multilanguage if you wish.
- Extract the zip folder to C:\ms4w\Apache\htdocs and maybe further into a folder system only you know for security reasons.
ARK
The ARK code for each project has been placed into the file directory of the ms4w\Apache\htdocs root folder under the relevant folder structure.