View source for Installing SmartSimple on Windows Server

This article describes the method required to install a copy of [[SmartSimple]] on a '''Windows Server'''.

The target audience for this document is technical support staff with an intermediate knowledge with Windows 2000.

==Download the Application==

[[SmartSimple]] technical support will provide you with the web location where you can download your copy of [[SmartSimple]].

Download this file and unzip into the required folder.

There will be two folders created within the [[SmartSimple]] folder:

* '''mysql-4.0.17''' - contains MySQL version required.
* '''Tomcat''' - contains Tomcat Application Server.
* '''Readme.txt''' - contains these instructions.

[[SmartSimple]] [[Application|application]] files are stored within the following folder structure:

'''SMARTSIMPLE\Tomcat\webapps\ROOT'''

==Required Changes to Configuration File==

You will need to make some changes to the configuration files.

'''\SMARTSIMPLE\Tomcat\webapps\ROOT\s_dbinfo.jsp'''

These values must be set when the [[Application|application]]is first installed.

'''.UPLOADFOLDER, absolute path of upload folder e.g. "C:SMARTSIMPLE/ROOT/resources/"'''

This folder is used for files uploaded using the [[Smart Folder|SmartFolders]] feature.

'''.SMTPSERVER, the IP address or name of the SMTP server.'''

This is required to enable the built-in email functions of the [[Application|application]].

Use "127.0.0.1" if current computer is to be used as the SMTP server.

==Possible Settings Changes Required==

'''\SMARTSIMPLE\Tomcat\conf\server.xml'''

Only required if database is not on the same box as the [[Application|application]] or if the database [[Username|username]] or [[Password|password]] is changed.

'''.user, database user name.'''

'''.password, database password.'''

'''.database url (if database is not on the same box)'''

'''\SMARTSIMPLE\Tomcat\webapps\ROOT\s_commagent.jsp'''
 
Only required if database is not on the same box as the [[Application|application]] or if the database [[Username|username]] or [[Password|password]]is changed.

'''.dataip, database url'''

'''.dbuser, database user name.'''

'''.dbpswd, database password.'''

==Launching Database Server==

1. Change directory to '''\SMARTSIMPLE\mysql-4.0.17\bin''' in command line.

2. Type '''mysqld-nt'''

You can also install '''mysql''' as an '''NT''' service.

==Launching Tomcat server==

1. Change directory to '''\SMARTSIMPLE\Tomcat\bin''' in command line.

2. Type '''startup.bat'''

If both launch successful you can access the standard interface or the [[Administration Interface|system administrator]] interface.

==Verifying Operation in Browser==

For standard [[User|user]] interface go to:

'''Localhost/'''

Standard login screen will be displayed.  You can login with your regular [[Username|username]] and [[Password|password]].

For [[Administration Interface|System Administrator]] interface go to:

'''Localhost/SysAdmin/'''

[[SmartSimple]] will supply a [[Password|password]] for this entry point.

==Machine Dependencies==

You will need to make sure that the following software is preloaded on the machine for the [[Application|application]] to start.

'''j2sdk1.4.1_01 or higher.'''

You will need to make sure the following environmental variable is set:

'''JAVA_HOME environmental variable set to j2sdk1.4.1_01 folder.'''

==Setting up TomCat 4.1.12 to Run as an NT Service== 

1. Set '''NT''' system environment variables as follows:

'''CATALINA_HOME=C:\jakarta-tomcat-4.1.12''' - Set this value to the actual install location of this folder (stored within the [[SmartSimple]] folder). 

'''CATALINA_OPTS=-server -Xms128m -Xmx512m'''  - Just a memory setting option.

2. Open up a new command prompt to ensure environment variables you just added are active - use the '''Set''' command. 

3. Run the following (must be all one line so you may have to put text in notepad and then copy): 
	

'''%CATALINA_HOME%\bin\tomcat.exe -install Apache-Catalina %JAVA_HOME%\jre\bin\server\jvm.dll''' '''-Djava.class.path=%CATALINA_HOME%\bin\bootstrap.jar;%JAVA_HOME%\lib\tools.jar -Dcatalina.home=%CATALINA_HOME% %CATALINA_OPTS% -Xrs -start''' '''org.apache.catalina.startup.BootstrapService -params start -stop org.apache.catalina.startup.BootstrapService -params stop -out''' '''%CATALINA_HOME%\logs\stdout.log -err %CATALINA_HOME%\logs\stderr.log''' 


You will have a problem if there is a space in the name of the folder.

4. Go to '''Services and Applications''' in '''Computer Management''' and start the service. 

If required set the startup type for this service to Automatic

==To Uninstall Catalina Service Use==

'''%CATALINA_HOME%\bin\tomcat.exe -uninstall Apache-Catalina'''
 
You should get a message saying that the task was installed successfully. 

The service is called '''Apache-Catalina''' (name can be changed either in command above or from windows services list (right-click to get properties). 

Contact [[SmartSimple]] technical support if you have any problems.

[[Category:System Management]]