iNQUIRE Installation v1.3 28/02/2019

3.2.1 Sql Server Configuration

1. Click start, run Sql Server Configuration Manager
2. Expand "SQL Server Network Configuration" in left hand pane
3. Highlight "Protocols for MSSQLSERVER", make sure "Shared Memory", "TCP/IP" enabled
4. Expand "SQL Native Client xx.x Configuration"
5. Highlight "Client Protocols", make sure "Shared Memory", "TCP/IP" and "Named Pipes" are all enabled
6. Repeat for 32/64 bit instances as needed
7. [*Run "OpenSqlServerPort.bat" as administrator from command line]?

3.2.2 Sql Server Browser Service

1. Click "Start -> Administrative Tools -> Services", right click "SQL Server Browser" select "Properties"
2. Tab "Log on" as "Built-in account -> Network Service [enter admin password]"
3. Tab "General" set startup type to automatic
4. Click apply, click ok
5. In "Services" window, right click "SQL Server Browser -> Restart"

3.2.3 Sql Server Properties

1. Run SQL Server Management Studio, connect to SQL Server instance, right click on server instance in left hand side pane, select "Properties"
2. Click "Security" in left hand side pane
3. Select "Sql Server and Windows Authentication Mode"
4. Click "Connections" in left hand side pane
5. Ensure "Allow remote connections to this server" is checked
6. Click "Ok"
7. Right click on server instance, select "Restart"

3.2.4 Restore iNQUIRE Database

1. Start -> Sql Server Management Studio
2. Connect to Sql Server
3. Extract database .bak file from supplied zip/rar "INQUIRE_Lite"
4. Copy database to easily accessible path, eg "C:\"
5. Sql Server Management Studio, right click "Databases -> Restore Database"
6. Select database from path above
7. To database: INQUIRE_Lite
8. In "Select the backup sets to restore" tick in restore column, should only be one set [see screenshot]
9. Click "Ok"

3.2.5 Create a New User

1. Left pane, expand Security, right click Logins -> New Login
2. Login name "dreuser2"
3. Select Sql Server Authentication, password "[PASSWORD]"
4. Untick "Enforce password expiration"
5. Select Default database: INQUIRE_Lite
6. If there are any issues with using login name "dreuser2", you can try "dreuser[x]" eg "dreuser3", as long as you update your ASP.net web.config with the login name, eg edit "C:\ASPSites\inquire\1.13\web.config" <connectionStrings> section, it may appear multipe times.

3.2.6 Add Users to Databases

1. Left pane expand Databases, expand "INQUIRE_Lite", expand "Security", right click "Users -> New User"
2. Username as created above eg "dreuser2"
3. Login name eg "dreuser2"
4. Database role membership, tick: db_datareader, db_datawriter, db_owner

3.3.1 Running Solr via included server (Jetty)

1. To run Solr on demand, with an output window (useful for debugging), copy solr\solr.bat to the Solr installation directory, update to reflect correct JRE path, Jetty/Solr port, etc, then run this batch file from the command line:

   "%JAVA_HOME%\bin\java" -Dsolr.solr.home=%SOLR_HOME% -Djetty.port=8983 -jar c:\solr\start.jar

3.3.2 Running Solr via Jetty as a Windows Service (for full documentation see http://www.eclipse.org/jetty/documentation/current/startup-windows-service.html)

1. Make "temp" directory in Solr installation path, eg "C:\solr\temp"
2. Unpack supplied solr\commons-daemon-1.0.15-bin-windows.zip or download latest Apache Commons Daemon from http://www.apache.org/dist/commons/daemon/binaries/
3. Copy prunmgr.exe and [system cpu architecture]\prunsrv.exe to Solr installation path eg "c:\solr"
4. Copy solr\install-jetty-service.bat to the Solr installation directory, update the file to reflect the system configuration (see variables highlighted in red):

   @echo off
   set SOLR_BASE=C:\solr
   set SERVICE_NAME=SolrService
   set JETTY_HOME=%SOLR_BASE%
   set JETTY_BASE=%SOLR_BASE%
   set STOPKEY=inquire
   set STOPPORT=50001
   
   set PR_INSTALL=%SOLR_BASE%\prunsrv.exe
   
   @REM Service Log Configuration
   set PR_LOGPREFIX=%SERVICE_NAME%
   set PR_LOGPATH=%SOLR_BASE%\logs
   set PR_STDOUTPUT=auto
   set PR_STDERROR=auto
   set PR_LOGLEVEL=Debug
   
   @REM Path to Java Installation
   set PR_JVM=%JAVA_HOME%\jre\bin\server\jvm.dll
   set PR_CLASSPATH=%JETTY_HOME%\start.jar;%JAVA_HOME%\lib\tools.jar
   
   @REM JVM Configuration
   set PR_JVMMS=128
   set PR_JVMMX=512
   set PR_JVMSS=4000
   set PR_JVMOPTIONS=-Duser.dir="%JETTY_BASE%";-Djava.io.tmpdir="%SOLR_BASE%\temp";-Djetty.home="%JETTY_HOME%";-Djetty.base="%JETTY_BASE%";-Dsolr.solr.home="%SOLR_HOME%";-Djetty.port=8983
   @REM Startup Configuration
   set JETTY_START_CLASS=org.eclipse.jetty.start.Main
   
   set PR_STARTUP=auto
   set PR_STARTMODE=java
   set PR_STARTCLASS=%JETTY_START_CLASS%
   set PR_STARTPARAMS=STOP.KEY="%STOPKEY%";STOP.PORT=%STOPPORT%
   
   @REM Shutdown Configuration
   set PR_STOPMODE=java
   set PR_STOPCLASS=%JETTY_START_CLASS%
   set PR_STOPPARAMS=--stop;STOP.KEY="%STOPKEY%";STOP.PORT=%STOPPORT%;STOP.WAIT=10
   
   %PR_INSTALL% //IS/%SERVICE_NAME% ^
     --DisplayName="%SERVICE_NAME%" ^
     --Install="%PR_INSTALL%" ^
     --Startup="%PR_STARTUP%" ^
     --LogPath="%PR_LOGPATH%" ^
     --LogPrefix="%PR_LOGPREFIX%" ^
     --LogLevel="%PR_LOGLEVEL%" ^
     --StdOutput="%PR_STDOUTPUT%" ^
     --StdError="%PR_STDERROR%" ^
     --JavaHome="%JAVA_HOME%" ^
     --Jvm="%PR_JVM%" ^
     --JvmMs="%PR_JVMMS%" ^
     --JvmMx="%PR_JVMMX%" ^
     --JvmSs="%PR_JVMSS%" ^
     --JvmOptions="%PR_JVMOPTIONS%" ^
     --Classpath="%PR_CLASSPATH%" ^
     --StartMode="%PR_STARTMODE%" ^
     --StartClass="%JETTY_START_CLASS%" ^
     --StartParams="%PR_STARTPARAMS%" ^
     --StopMode="%PR_STOPMODE%" ^
     --StopClass="%PR_STOPCLASS%" ^
     --StopParams="%PR_STOPPARAMS%"
   
   if not errorlevel 1 goto installed
   echo Failed to install "%SERVICE_NAME%" service.  Refer to log in %PR_LOGPATH%
   goto end
   
   :installed
   echo The Service "%SERVICE_NAME%" has been installed
   
   :end
                                   

5. Run this batch file from the command line as an Administrator

3.4 iNQUIRE

1. Edit "[iNQUIRE deployment path]\Web.config"
2. Edit email settings
3. Edit SolrUri settings (NB: SolrUriXml is redundant and can just point to any instance/core of Solr)
4. XmlDataFile is deprecated
5. MediaDirectoryRemote is for non Jpeg2000 media, can just be set to "/" if none exist, or create "Media" directory in deployment directory if needed
6. ImageDirectory can be set to eg "C:\ASPSites\inquire\1.8\" if no non-jpeg2000 media, or point at non-jp2 media directory
7. connectionStrings: DataSource should be Sql Server machine, eg localhost, user should be the username and password created in Sql Server management utility above:

   <add name="BL_DRE_INQUIREConnectionString"
       connectionString="Data Source=BODL-DIGITAL-DE;Initial Catalog=BL_DRE_INQUIRE;Persist Security Info=True;User ID=dreuser2;Password=[PASSWORD]"
       providerName="System.Data.SqlClient" />"

   NB: MS Sql Server seems to be happy with just eg "Data Source=BODL-DIGITAL-DE", but Sql Server Express needs [machine name]\[instance name] eg "Data Source=ACER-LAPTOP\SQLEXPRESS"

3.5 IIS

1. Launch IIS, right click "Default Web Site -> Add Application"
2. Alias: eg "inquire_1.8", Application pool: "ASP.NET v4.0", Physical path "[inquire deployment directory]", eg "C:\ASPSites\inquire\1.8"

3.6 Microsoft IIS Url Rewrite [Optional]

1. Open web.config, copy rewrite section to default website web.config (usually in inetput/wwwroot) so rules are inherited by inquire site. Then comment out the rewrite section in the inquire web.config. The default website web.config should thus look similar to the following:

   <?xml version="1.0" encoding="UTF-8"?>
       <configuration>
           <system.webServer>
               <rewrite>
                   <rules>
                       <clear />
                           <rule name="inquire direct view item (ris export url)" patternSyntax="Wildcard" stopProcessing="false">
                               <match url="inquire/v/*" /> <conditions logicalGrouping="MatchAll" trackAllCaptures="false" />
                               <action type="Rewrite" url="inquire/Discover/Search/?p=c+0,t+,rsrs+0,rsps+10,fa+,so+id^desc,scids+,pid+,vi+{R:1}" appendQueryString="true" />
                           </rule>
   
                           <rule name="iNQUIRE" patternSyntax="Wildcard" stopProcessing="true">
                               <match url="inquire/*" negate="false" />
                               <conditions logicalGrouping="MatchAll" trackAllCaptures="false" />
                               <action type="Redirect" url="inquire_1.12/{R:1}" redirectType="Found" />
                           </rule>
                       </rules>
                   </rewrite>
               </system.webServer>
           </configuration>