dbiScript Installation Instructions
- 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
- Open web.config (from the same folder as this document) in a text editor
- Replace the orange text in <smtp from="dbiScript Administrator < admin@domain.com >"> with an administrative email address
- 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
- Open Internet Information Services (IIS)
- 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:
- 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
- "https" is listed in the Web Site's binding list (Bindings… under Edit Site in the left pane)
- The application you create in the following steps has its SSL Settings set to Require SSL
- In the Connections pane (at left), navigate to the Default Web Site folder, right-click on the folder and select Add Application…
- Enter dbiScript as the Alias
- Click on Select… (to the right of Application pool)
- 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
- Click OK
- Enter the folder you selected in step 1 as the Physical path
- Select the dbiScript application (added to the Connections pane in the last step)
- .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)
- Right-click the dbiScript application folder in the Connections pane and Select Edit Permissions…
- Click on the Security tab of the Properties window
- 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
- Click OK to close the Properties window
- Open the dbiScript application folder in the Connections pane
- Right-click on the data folder and Select Edit Permissions…
- Click on the Security tab of the Properties window
- Click Edit…
- If IUSR does not appear in the list of user names, click Add… and add it
- Select the IUSR account
- 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
- Ensure that Windows automatically (in the last step) checked the List folder contents and Read checkboxes in the Deny column
- If IIS_IUSRS does not appear in the list of user names, click Add… and add it
- Select the IIS_IUSRS account
- 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)
- Ensure that Windows automatically (in the last step) checked the Write checkbox in the Allow column
- Click OK
- Open your browser of choice (Google Chrome, Mozilla Firefox, Apple Safari, Opera, or Internet Explorer 9+)
- 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
- Navigate to http://localhost/dbiScript/apps/clinic/
- 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
- Navigate to http://localhost/dbiScript/apps/nwind/
- The dbiScript code for the Northwind application is located in dbiScript/apps/nwind/nwind.js