dbiScript Installation Instructions

  1. Ensure the dbiScript folder (and all its contents) is placed in a location on your machine where you’ll want a website to exist. If you’ve unpacked the files into a temporary directory, now is the time to move the files to a better location
  2. Open web.config (from the same folder as this document) in a text editor
  3. Replace the orange text  in <smtp from="dbiScript Administrator &lt; admin@domain.com &gt;"> with an administrative email address
  4. In the line <network host="smtp.domain.com" port="25" userName="smtp-user@domain.com" password="password"/> replace all orange text with your SMTP host information and credentials. dbiScript uses this account to send out temporary passwords to new users of your application. If you skip this step you will still be able to create new user accounts but your users will be unable to log in; you will need to reset their passwords once a valid smtp account has been specified
  5. Open Internet Information Services (IIS)
  6. Security Caution: If you're configuring dbiScript for development purposes then an http binding is sufficient. For deployed applications, it's important to use an https binding. To use an https binding, ensure that:
    1. A valid Server Certificate exists. To check, click on the server in the Connections pane and then double-click on Server Certificates in the IIS section of the middle pane. If no certificate is listed, you will need to acquire one. Note that self-signed certificates will not work properly; for LAN (intranet) deployments, use a Windows Server Certificate Authority; for internet deployments, use a recognized commercial Certificate Authority
    2. "https" is listed in the Web Site's binding list (Bindings… under Edit Site in the left pane)
    3. The application you create in the following steps has its SSL Settings set to Require SSL
  7. In the Connections pane (at left), navigate to the Default Web Site folder, right-click on the folder and select Add Application…
  8. Enter dbiScript as the Alias
  9. Click on Select… (to the right of Application pool)
  10. Change the Application Pool to ASP.NET v4.0; if that option is not available, you’ll need to upgrade to the latest version of .NET
  11. Click OK
  12. Enter the folder you selected in step 1 as the Physical path
  13. Select the dbiScript application (added to the Connections pane in the last step)
  14. .NET Trust Levels: dbiScript requires full trust. Double-click on .NET Trust Levels (in the ASP.NET section) and ensure the Trust level is set to Full (internal)
  15. Right-click the dbiScript application folder in the Connections pane and Select Edit Permissions…
  16. Click on the Security tab of the Properties window
  17. Ensure that both the IUSR and IIS_IUSRS accounts are listed in Group or user names and have Read & execute permission; if not, click Edit… and add/modify them
  18. Click OK to close the Properties window
  19. Open the dbiScript application folder in the Connections pane
  20. Right-click on the data folder and Select Edit Permissions…
  21. Click on the Security tab of the Properties window
  22. Click Edit…
  23. If IUSR does not appear in the list of user names, click Add… and add it
  24. Select the IUSR account
  25. Check the Read & Execute checkbox in the Deny column. This prevents internet users from directly accessing the files in the data folder and its subfolders
  26. Ensure that Windows automatically (in the last step) checked the List folder contents and Read checkboxes in the Deny column
  27. If IIS_IUSRS does not appear in the list of user names, click Add… and add it
  28. Select the IIS_IUSRS account
  29. Check the Modify checkbox in the Allow column. This enables the middle tier (Cyberaxiom.dbiScript.dll) to update the database (when using an Access or SQL Anywhere database in this folder) and to upload and delete files (for the dbiScript PhotoAlbum and FileVault fields)
  30. Ensure that Windows automatically (in the last step) checked the Write checkbox in the Allow column
  31. Click OK
  32. Open your browser of choice (Google Chrome, Mozilla Firefox, Apple Safari, Opera, or Internet Explorer 9+)
  33. If you have Microsoft Access installed on your machine, you’re ready to go. If you’re using another database then open the appropriate folder within the databases folder and follow the steps in the Instructions.htm file
  34. Navigate to http://localhost/dbiScript/apps/clinic/
  35. The dbiScript code for the Clinic application is located in dbiScript/apps/clinic/clinic.js. Open this file in a text editor and experiment! The clinic.rebuildDatabase.js file is a duplicate of the clinic.js file with code added for rebuilding the database. Try renaming clinic.js to clinic.min.js and clinic.rebuildDatabase.js to clinic.js and then reloading the application. The clinic.testing.js file demonstrates more features and properties of dbiScript
  36. Navigate to http://localhost/dbiScript/apps/nwind/
  37. The dbiScript code for the Northwind application is located in dbiScript/apps/nwind/nwind.js