Installation and setup

If the PC already has MySQL and previous version’s Thick Client installed, you might want to remove them and restart.

1. Uninstall MySQL Server

go to Control Panel > Programs and Features, uninstall “MySQL Server”
go to “C:/Program File”, remove the “MySQL Server folder”
go to Control Panel > Administrator Tools > Services, stop the “MySQL Server”
now, to remove “MySQL service”
Click “Start” and type “CMD” in the Start search box

- Right click on CMD in the list and click on "*Run as administrator*"
- Type sc delete MySQL
- will then prompt DeleteService SUCCESS
- restart the PC now

2. Uninstall Thick Client

go to Control Panel > Programs and Features, uninstall “Thick Client”
Required components to set up POS.

- Microsoft .NET Framework 3.5 (You can skip this step. As Windows 7 should already come with .Net Framework installed. When you install Thick Client later on, if this is not installed yet, it will prompt you for the installation through the net)
- MySQL
- MySQL Tools for 5.0
- ThickClientSetup.zip (attached below this page)
- Minimum 150Mb of free space
If you are running any other operating system than Windows Vista, kindly ensure that you have Microsoft .NET Framework 3.5 installed. This is a redistributable software and can be downloaded directly from Microsoft.
Once your computer is installed with Microsoft .NET Framework 3.5, you will need to download and install the following:
- MySQL
- MySQL Tools

Installing MySQL

Run the installation mysql-5.0.51b-win32.exe
Click “Next”
Select “Complete”, and click “Next”. Proceed to click “Install”
Proceed to clicking ”Next” until you have reached a prompt where “Configure MySQL Server Now” (Should be automatically ticked)
Click Finish

Configuring MySQL

Please wait awhile until the next prompter appears.

If it doesn’t pop up, go to All Programs -> MySQL -> MySQL Server 5.0 -> MySQL Server Instance Config Wizard

Click “‘Next”
Select “Detailed Configuration” and click ”Next”
Select “Dedicated MySQL Server Machine” and click ”Next“
Select “Multifunctional Database” and click “Next”
It is recommended that the drive and directory be left as default, which will show you “C:Installation Path”, click Next
Select “Decision Support (DSS)/ OLAP” and click “Next”
Ensure that both “TCP/IP Networking” and “Strict Mode” are enabled. The port number is recommended to be left as default. Click “Next”
Select “Best Support For Multilingualism” and click “Next”
Ensure that “Install As Windows Service” is enabled and the Service Name should be “MySQL”. Also, ensure that “Launch the MySQL Server automatically” is enabled. Click “Next”
Ensure that “Modify Security Settings” is ticked.
Key in the Root password as “root” and retype “root” in the column below.
- Ignore “Enable Root Access from Remote Machines”. Click “Next”
Click “Execute”
When Processing Configuration is running, please check if all configurations are ticked :
- Configuration file created
- Windows service MySQL installed
- Service started successfully
- Security settings applied
Click “Finish”

Installing MySQL Tools for 5.0

Run the installation file mysql-gui-tools-5.0-r17-win32.exe
Click “Next”
Should you agree with the license agreement,
- select “I accept the terms in the license agreement” and click Next
Destination Folder
- Click "Next" to install to this folder / click "change" to install to different folder
Click “Next”
Select “Complete” and click “Next”
Click “Install”
Click “Finish”

Installing the Point Of Sales

Download the POS program here
Click "Next"
To install in this folder
- click "Next"
To install to a different folder
- click "Browse" > "Next"
Click "Next" to start installation.
Click "Close"

Set up Data or Memory size of MySQL

Go to windows > Start > MySQL > MySQL Administrator (> right click > Run as administrator)
Ignore "Stored Connection"
Ensure that the name for Server Host = localhost
User name = root, and key in the password you have entered before when “Configuring MySQL”(referring above is “wavelet”) > Click "OK"
Click "Startup Variables" > "Advanced Networking tab"
At Data / Memory size section > check "Max packet size" and key in "1000*M"
- Check *Net buffer length and key in *1000*K.
Click Apply changes > Service Control > Stop Service
After server was stopped, click "Start Service"
Exit

First Time Open POS (setting up of the wsemp database)

Click "ThickClient Launcher" (on your desktop) or Go to C:\Program Files > Wavelet > ThickClient > ThickClient.exe (> right click > Run as administrator)
The Thick Client Installation will appear > Click "Next"
The ‘Application is successfully installed.’ will shown > Click "OK"
Login –
- Username: Developer
- Password : wavelet
Configuration > click “Import and Export Tab”
Go to EMP server to Export Master Data file (see below - How to export from EMP Guide)**
Go back to the POS, at "Import Master Data from EMP" > click "Browse",
Select the import file that you exported from EMP
Click Import> Please wait until finish > popup success message
Click "OK" to Exit POS Configuration
Login again to use the POS.

**How to export from EMP

At EMP Server > Trading > Thick Client Management > Export Master Data > click Export

Open 'MySQL AdministratorTo check if a database exists'

Login
Click "Catalogs"
Select "wsemp" to view all tables of wsemp schema.

Open POS

Click on "ThickClient Launcher" (on your desktop)
Login – The username and password are the same as in EMP.

- Username : XXX
- Password : YYY

Linking the POS to EMP Server

IMPORTANT!

Download both:
xstream-1.3.jar
xpp3_min-1.1.4c.jar

After download, copy these files into the /usr/java/jboss-4.0.1RC2/server/default/lib/ directory as the root user on the EMP server

Open POS by double clicking "ThickClient Launcher" on desktop.
Go to Configuration > Synchronization > Web Services, enter http://cloud.wavelet.biz/demo-ws/EMPThickClientService?wsdl
Click on "*Download Now*" button, to synchronize all master data from EMP server’s database into the POS. Example : Item codes, Stock balance and Pricing.
Click "Start"

NOTE: If you encounter Password Error 1045 during the above steps and Error messages show "Access denied for user 'root'@'localhost'(using password:YES)":

You may go to Start > MySQL Command Client and:

1. Hit 'Enter' (or if it does not work, try typing 'wavelet' before hitting Enter)
2. Key in the following command: