Difference between revisions of "Installing iBID Central Database"

From EHS Help
Jump to: navigation, search
(First draft)
 
m (→‎The Client Application)
 
(4 intermediate revisions by the same user not shown)
Line 8: Line 8:
 
#Download the aquila_mssql_ddl zip file and unzip the 3 scripts
 
#Download the aquila_mssql_ddl zip file and unzip the 3 scripts
 
#Create a new MSSQL database on your MSSQL server instance.
 
#Create a new MSSQL database on your MSSQL server instance.
−
#Run each of the 3 scripts against the new database to create the database objects
+
#Run each of the 3 scripts against the new database to create the database objects.
 
#Create a new user for the application servers to access the database & grant all rights to all objects in the database.
 
#Create a new user for the application servers to access the database & grant all rights to all objects in the database.
−
 
  
 
==The Web Server==
 
==The Web Server==
Line 20: Line 19:
 
Notes:
 
Notes:
 
*The web server does not have to be on the same server as the MS SQL Server instance.
 
*The web server does not have to be on the same server as the MS SQL Server instance.
−
*Please supply the URL of the webserver including the path to the aquilaweb.exe web module, e.g. http://ibid.mdsas.com/cgi-bin/aquilaweb.exe
+
*Please supply us with the URL of the webserver including the path to the aquilaweb.exe web module as this is the URL for sending centralised data returns.
−
 
+
  
 
==The Local Application Server==
 
==The Local Application Server==
Line 27: Line 25:
 
#Download the aquilaserver_setup.exe installation script & run on your chosen app server. (Can be different from the web & sql servers, or the same)
 
#Download the aquilaserver_setup.exe installation script & run on your chosen app server. (Can be different from the web & sql servers, or the same)
 
#Edit the ''ConnectionString'' property in the file '''{program files}\Evolution Healthcare Systems Limited\AquilaServer\AquilaServer.ini''' to specify the server, database, username and password previously set up.
 
#Edit the ''ConnectionString'' property in the file '''{program files}\Evolution Healthcare Systems Limited\AquilaServer\AquilaServer.ini''' to specify the server, database, username and password previously set up.
−
#In the same file you can specify a different port for the app server to listen on (defaults to port 8099).
+
#In the same file you can specify a different port for the app server to listen on (defaults is port 8099) by adding a line '''Port=8098''' to the '''[Settings]''' section.
 
#Ensure that your firewall has this port open, or create an exception rule for aquilaserver.exe.
 
#Ensure that your firewall has this port open, or create an exception rule for aquilaserver.exe.
 
#Open Services.msc & ensure that the aquilaserver.exe is started and it set to start Automatically.
 
#Open Services.msc & ensure that the aquilaserver.exe is started and it set to start Automatically.
−
 
  
 
==The Client Application==
 
==The Client Application==
Line 39: Line 36:
  
 
Replace SERVERNAME with the name of the server hosting AquilaServer.exe and replace PORT_NUMBER with the configured port number, e.g. ''http://myserver:8099/bin''.  You can also edit this setting at the Login screen.
 
Replace SERVERNAME with the name of the server hosting AquilaServer.exe and replace PORT_NUMBER with the configured port number, e.g. ''http://myserver:8099/bin''.  You can also edit this setting at the Login screen.
 +
 +
''Note, you can also connect to the database via the aquilaweb.exe IIS module by using the URL of the module & adding the '''/bin''' path.  e.g. '''http://ibid.mdsas.com/cgi-bin/aquilaweb.exe/bin'''''
  
 
Login credentials:
 
Login credentials:

Latest revision as of 15:06, 4 September 2012

This is a Technical Instructions topic


The Database

Following to be performed using MS SQL Server Management Studio (or equivalent tool).

  1. Download the aquila_mssql_ddl zip file and unzip the 3 scripts
  2. Create a new MSSQL database on your MSSQL server instance.
  3. Run each of the 3 scripts against the new database to create the database objects.
  4. Create a new user for the application servers to access the database & grant all rights to all objects in the database.

The Web Server

  1. Download the aquila_webserver.zip package.
  2. Unzip both files (aquilaweb.exe and aquilaweb.ini) to the scripts folder of your IIS installation (cgi-bin)
  3. Edit the ConnectionString property in the aquilaweb.ini file to specify the server, database, username and password previously set up.

Notes:

  • The web server does not have to be on the same server as the MS SQL Server instance.
  • Please supply us with the URL of the webserver including the path to the aquilaweb.exe web module as this is the URL for sending centralised data returns.

The Local Application Server

  1. Download the aquilaserver_setup.exe installation script & run on your chosen app server. (Can be different from the web & sql servers, or the same)
  2. Edit the ConnectionString property in the file {program files}\Evolution Healthcare Systems Limited\AquilaServer\AquilaServer.ini to specify the server, database, username and password previously set up.
  3. In the same file you can specify a different port for the app server to listen on (defaults is port 8099) by adding a line Port=8098 to the [Settings] section.
  4. Ensure that your firewall has this port open, or create an exception rule for aquilaserver.exe.
  5. Open Services.msc & ensure that the aquilaserver.exe is started and it set to start Automatically.

The Client Application

To test the installation, download the client application installation (aquilacrs_setup.exe) & install. The installation will ask you for the database URL, which is made up as follows:

http://SERVERNAME:PORT_NUMBER/bin

Replace SERVERNAME with the name of the server hosting AquilaServer.exe and replace PORT_NUMBER with the configured port number, e.g. http://myserver:8099/bin. You can also edit this setting at the Login screen.

Note, you can also connect to the database via the aquilaweb.exe IIS module by using the URL of the module & adding the /bin path. e.g. http://ibid.mdsas.com/cgi-bin/aquilaweb.exe/bin

Login credentials:

  • Username: admin
  • Password: adminabc123

(You will be prompted to change the password on logging in, please make a note of the new password).

Retrieved from ‘https://evolutionhealthcaresystems.co.uk/help/index.php?title=Installing_iBID_Central_Database&oldid=337’