| NEW SERVER SETUP | |
| 1. | Make sure you are logged in as an Administrator on server and create user 'countercat'
|
| 2. | Install FTP client and FTP server (FileZilla) and Winrar on server |
| 3. | Download Sophio SDK |
| 4. | Create FTP user countercat with password ****** , add rights to Drive D ( Show Video ) - If ftp is not working see note on step 9 for removing packet filter for 1and1 servers |
| 5. | Transfer and Install Visual Foxpro 9, prerequisite files and service packs post install from source server (serial.txt contains the enterprise serial number) ( Show Video ) |
| 6. | Install VFP9 (not vfp8) and prerequisite files ( Show Video ) |
| 7. | Unpack Sophio SDK files (file comes from sophio download server) ( Show Video ) |
| 8. | Run Ipsec to enable passive FTP ports and access to SVN server ( Show Video ) - if you are hosted on 1and1 servers you often have to unassign the existing policy which is blocking the svn ports and everything else. |
| 9. | Install SVN clients (1- slik subversion 64bit in the svn folder from sdk download, then 2-tortoisesvn 64bit) ( Show Video ) - Note: If you are installing a dedicated server at 1and1, make sure you un assign the packet filter in 'ip security policies'. you will see one likely turned on. This step is necessary if your svn will not connect. |
| 9b. | Setup SVN folders ( Show Video ) (webstore/sophio creds...) - right click d:\inetpub\countercat\ and choose 'svn checkout' then insert this url : http://svn.sophio.com:3690/svn/sophio-webstore/web-folder/countercat/trunk (folder to save to is: d:\inetpub\countercat\templates\ - http://screencast.com/t/YEiCSuEa8dw ) - then navigate to d:\countercat and right click and choose 'svn checkout' and insert this url:: http://svn.sophio.com:3690/svn/exe/trunk (folder to save to is: d:\countercat\exe\) |
| 10. | Register sophio.dll to be used by template editor - http://screencast.com/t/4cN0r8VV( Show Video ) |
| 11. | Install IIS components ( Show Video ) - http://www.microsoft.com/web/downloads/platform.aspx (add web deployment, urlrewrite, search engine optimizatin toolkit, web deployment tool 1.1, ip and domain restrictions, ip request filtering, basic authentication, iis url authorization, iis http redirection urlrewrite 2.0) |
| 12. | Setup Applicatin Pool in IIS ( Show Video ) |
| 13. | Configure DCOM to allow webstore to run as a COM application ( automation ) ( Show Video ) |
| 14. | Configure IIS to work with Sophio ISAPI extension (wws and epc) ( Show Video ) |
| 15. | Install dot net 4.0 from here: http://www.microsoft.com/download/en/confirmation.aspx?id=17851 then go to d:\download\mysql\ and Install MySQL server, setup root user with password ********* then create countercat user and sophio_core schema. If mysql is already on server and this is a fresh server remove mysql and reinstall latest version. Add full rights for user countercat to database sophio_core. ( Show Video ) ( Show Video ) |
| 16. | If running on a 64bit server, you must enable 32 bit apps in IIS (more info) - this step was covered above |
| 17. | Install SOAPSDK (if not in the master sdk, download here) |
| 18. | Install the Sophio wildcard ssl certificate (download the ssl folder if not already on server)( Show Video ) |
| 19. | (may be optional check to see if \countercat\exe has webstore.exe) Download the folder d:\download\newstoresetup\newexe and copy all the dll files (except wc.dll) to the d:\countercat folder and the wc.dll to the d:\inetpub\countercat\ folder (make sure iis is not running when you do this) |
| 20. | Add the base ip address of the web server to the smtp auth bypass of webmail.sophio.com so stores can send mail |
| 21. | Create a base store. The store should be the last three digits of the ip address of the server dot sophio.com, for example http://217.sophio.com - do this by copying wws_stores.dbf from another server with just the first record. |
| 22. | Setup scheduled tasks for d:\countercat\exe\getwhd.exe (3rd day of each month) + d:\countercat\exe\sophiotaskmanager.exe (every 5 min) |
| 23. | Create new user for client admin (same user name, new password, be sure to email client) |
| 24. | updated webmon on source server to hit maintsvnupdates.wws every 5 minutes (for automated executuable/content distribution) |
| TRANSFER AN EXISTING STORE FROM A SERVER TO ANOTHER | |
| 1. | create am xml copy of the stores wws_stores record. do this by hitting the link storetoxml.wws. for example: http://217.sophio.com/storetoxml.wws (you will need to have admin access to create this) |
| 2. | Logon to the new server via RDC, start up ftpzilla and transfer the clients html folder d:\inetpub\ folder and the clients data folder d:\wconnect to the new server. Note you should turn off the site in IIS on the 'old' server. this is safe to do without telling the client if late at night otherwise make sure client knows they'll have some downtime. (it should not take more than 15 minutes for any single website) |
| 3. |
Create a new webstore on the new server. Go to command box 'as administrator' and run the batch file d:\countercat\exe\createsite.cmd. from d:\countercat\exe\createsite rootname |
| 4. |
The next step is to get create a store on the new server from the xml copy you made in step 1. To do that open this link on a browser on the new server - http://999.sophio.com/xmltostore.wws - When you click that a page comes up asking you for the ZIP(xml) file you just created from the previous step. The file should be in the templates folder of the site you just moved via ftp and is named wwstorexml.zip - When you attach it, the file will be read, and a new store record will be created with the same storepk from the file you created. If that storepk is somehow in use on the new server already, it will be WRITTEN over. So if you are moving a site back and forth, chances are that store record will be written over. Make sure you know what you are doing and intend to do that, otherwise the site you are restoring the xml file will now have the same configuration from the previous store. Normally this is ok if you are dong it for the first time. |
| 5. | Update DNSMadeEasy with the new ip address for the domain you just moved. |
| 6. |
Create adminuser on new server using same name. Be sure to add user to 'sophio' group. If you cannot find password from original store advset, create new one and email the customer new password. Update the advset tag so that Sophio staff can find the new password |
| 7. | update the FTP settings at ftpcentral.sophio.com so that ftp centrla knows where the site is 'now'. |
| 8. | Test site home page, catalog, add to cart, and finally checkout. Search for a part number using this page: searchitem.epc?lookfor=0001800609 or searchitem.epc?lookfor=ph8a add to cart, checkout, do the images all look good? Does https work? Can you add to cart and check freight? Can you checkout and see a good looking checkout page? |
