It is possible to install SoftSlate Commerce manually without using the Installer tool. Sometimes this is more convenient (or even necessary), especially if you're having trouble with the installer tool. To install manually, follow these steps:
Create the empty database to be used for SoftSlate Commerce.
Initialize the database objects by running each of the
create*.sql files followed by the
insert.sql files under the subdirectories of the
WEB-INF/classes/resources directory. E.g.
etc. These files create and insert the database objects needed by
Run update commands to set the URL settings in the
table according to where your installation lives:
update sscSetting set mediumValue='<base customer URL>' where code = 'customerURL';mysql>
update sscSetting set mediumValue='<base secure customer URL>' where code = 'customerSecureURL';mysql>
update sscSetting set mediumValue='<base administrator URL>' where code = 'administratorURL';
Insert a record into the
sscAdministrator table, so you have
an admin login:
insert into sscAdministrator (userName, password, isActive, class) values ('myusername', 'mypassword', 1, 'com.softslate.commerce.businessobjects.administrator.AdministratorBean');
Assign the admin user to the superuser role:
insert into sscAdministratorRole (administratorID, roleID, class) values (1, 1, 'com.softslate.commerce.businessobjects.administrator.AdministratorRoleBean')
Update the security setting for admin passwords so you can login without an encrypted password:
update sscSetting set smallValue='noEncryption' where code = 'administratorEncryptionType';
You can change this setting back to being encrypted in the
Security Settings -> Encryption Settings
screen, but you have edit the password in the administrator immediately after you do
that to encrypt it.
To configure the database connection settings manually, edit the
WEB-INF/classes/hibernate.properties file located
under the SoftSlate Commerce installation directory. Add the database name,
username, password, and other settings.
WEB-INF/classes/appSettings.properties. Set the
"databaseType" property to one of the following: MySQL, MSSQL, Oracle, or
Restart your application server.
The last thing is to generate the two-way encryption key, if you plan to use two-way encryption for customer password and credit card information (which is the default). The only way to do this currently is to run the installer. Since the installer creates the key before trying to set up the database, even if you get errors during the installer, it should already have created the key for you. So, run the installer once to create the key.
Finally, last but not least, edit
WEB-INF/classes/appSettings.properties again. Add the
following line, which locks the installer from being used: