Local Application Installation and Configuration
LOCAL APPLICATION INSTALLATION AND CONFIGURATION
Steps require for a successful installation and configuration of MicMac Software
On server system:
Install vb6
Go to control panel to bring down the user account
INSTALLATION PROCESSOn SERVER AND CLIENT SYSTEM
INSTALLINGMicMac CERM
Step 1: Installation
a.Insert the CD into your CD Drive (It Will Auto Run and an Introduction Splash Screen will appear)
b.Click on Next Button to continue with Installation
Step 2: MicMac CERM Setup
(License Agreement)
a.Click on ‘‘I Agree’’ Button if you have read and you are Sure of conformity with the single user license and if otherwise,
b.Click‘‘Cancel’’ Button to disagree and cancel the Installation Process. You can also‘‘Click’’ the Back Button to go back to the Beginning.
Step 3: MicMac CERM Setup
(Choose Install Location)
a.Click on ‘‘Next’’ Button to continue Installation on the default Location or Destination Folder.
b.On the other hand Click on Browse Button to pick on your Location of interest then Click Next Button.
Step 4: MicMac CERM Setup
(Choose Install Location)
a.Click on the Server Installation Radio/ Option Button if you are installing on a standalone or a single system then Click the Next Button.
NB: If you choose client installation, make sure you’ve mapped your drive on the client system. See page 7.
Step 5: MicMac CERM Setup
(Choose Install Location)
a.Click on Client installation Radio/ Option Button, If you are installing on or over the network then Click the Next Button
Step 6: MicMac CERM Setup
(Choose Install Location)
a.Click on the Browse Button to search and to locate the path to your Server and Click on the Install Button.
Step 7: MicMac CERM Setup
(Open File Location)
a.Locate your Server path or the name of your Server through My Network places and Click on the Open Button.
Step 8: MicMac CERM Setup
(Installing)
a.Click on the Install Button to begin Installation proper. Clicking on the Show details Button will display all files transfer and locations.
Step 9: MicMac CERM Setup
(Installation Complete)
a.Installation of the MicMac CERM has completed successfully when it shows this form and the Message Boxes shown below
b.Click on the Next Button to complete Installation and OK button(s) on the Message Boxes to complete the process.
c.You can now go on with the Third-party Installation steps.
Step 10: MicMac CERM Setup
(Third- Party Software Installation)
a.Click on the FileZilla Button to begin its’ Installation or
b.Click on the Adobe PDF Button to begin its’ Installation
Step 11: FileZilla Client 3.3.0 Setup
(License Agreement FileZilla)
a.Click on ‘‘I Agree’’ Button if you have read and Sure of conformity with the single user license rule and if otherwise,
b.Click‘‘Cancel’’ Button to disagree and cancel the Installation Process.
c.Follow the Screen prompts “NEXT/ INSTALL/ CONTINUE” to complete the Installation of the FileZilla to your Computer
NB:
Please do call the support line to request for a Hostname, Username and Password. This will enable you to activate the FileZilla Transfer Support to our Server.
Step 12: Adobe Acrobat PDF
(License Agreement Adobe Reader 8.1.2 Setup)
a.Follow the Screen prompts “NEXT/ INSTALL/ CONTINUE AND FINISH” to complete the Installation of the Adobe Reader to your Computer
Step 13: If Auto Run Fails
(MicMac CERM Setup)
a.Insert the CD into your CD Drive
b.Go through My Computer to locate the CD- ROM Drive
c.Double- click or Right Click to pick option to open the CD.
d.Locate the Setup Button on your CD, then Double- click or Right Click to pick option to Install to Start or continue the Installation process as seen in Step 1 Installation above.
Step 14: MicMac CERM Setup
(Installation Complete)
a.Click on the Next Button to complete the Third-Party installation process
Step 15: MicMac CERM Setup
(Completing the MicMac CERM Setup Wizard)
a.Click on the Finish Button to complete the MicMac CERM Installation process and close the wizard.
Installation has been Successfully Completed
NB:
If at any time your system demands to Restart during Installation process for Updates, Click on “Yes” to Restart your system. After restarting, Start with your MicMac CERM Activation.
MAPPING DRIVE FOR MICMAC APPLICATION ON CLIENT SYSTEM
To map a network drive, go to your computer at the top menu click on ‘Map network drive’ or right click on ‘Network’ then click on ‘Map network drive…’ and you see as shown below;
Picka letter for your drive and also browse or get the path to the server application.
Installing wampserver
- Run the wampserverSoftware to start installation
- Click on the Next button
- Choose to accept the agreement then click Next
- Check the boxes to select any of the options
- Click Install button to start the installation.
- Installation in progress…
- Click on ‘Allow access’ to allow the program through firewall
- By default, it picks the localhost as the SMTP server. Click Next
- Wampserver is successfully installed. Click the Finish button to launch the program.
HOW TO CHANGE MYSQL PORT TO ANY OTHER PORT IF NEED BE.
If your MySQL by default has taken the port 80, you need to change it to any other free port available. This is done as follows:
- Start your wamp
- Click on the wamp icon
- Locate the Apache folder then navigate to the httpd.conf
- Click to open the file, search for “Listen”by pressing Ctrl + F
- Change the 80 to 8080 or any other.
Testing your wampserver for localhost or with any other port number.
From your browser, type ‘localhost’ or you append your new port number to the localhost as in ‘localhost:8080. So after running the page, it will display the below page;
Make Wamp Automatic in Services
- Go to Services by clicking Start, then click control panel --Administrative Tools-- Component Services, then it will show as below;
Then click on Services (Local) and also locate your ‘wampapache’ and ‘wampmysqld’ services.
Double click on each of them and it will pop up the below snapshot.
Changes the Startup type from manual to Automatic, then click on apply to effect the changes. Then you are good to go with your wampserver, happy Coding.
NB: Do this for both services.
Importing database using sxd
Dump the sxd folder in the www root folder of the wampserver.
To access the sxd program, on your browser, type ‘localhost/sxd/ or you have changed the port number of your wampserver, append it with the localhoste.g localhost:8080/sxd/, then it will load the page as shown below:
Enter User as root then click the Enter button to have access to the application. Do the below to create the database to import your tables ;
Click the icon after Services to create a new database, type in the database name and then click create to create the database as shown below;
Then click on the import, create a fresh database to import the tables as shown above, and pick your database from ‘File ‘ Dropdown, then click on execute to start importing, then it will load the pageas shown below;
You have to wait for it to finish importing, and then you will get a message ‘Job Successful’.
NB: You should have your database in the backup folder in the sxd folder.
Configuring ODBC for Access database and MySQL database
For Access Database:
- Search for odbcad32.exe in your windows.
- Open by clicking on it, then it will display the below view;
Click on the Add button to add a new data source and it will show as below;
Pick Microsoft Access Driver (*.mdb) then click finish. It pop up a new form to input name and also select database as shown below;
Enter ‘MicMac’ as the Data Source Name and click on select to pick your database. After clicking on select button, it will display as shown below;
Click ‘OK’ to close the dialog box.
For MySQL Database:
NB: Before configuring odbc for mysql database, you have to install mysql-connector-odbcdriver and fs2.exe
Install MySQL Driver:
Launch the software to start installation, and it will pop up the dialog below;
Click the Next button to continue
Choose to accept the license agreement. Then click Next to display the below;
Choose to Install the Complete installation, and then continue clicking next till you finish Installing.
Install FS2:
Launch the software, then click next to continue.
Click Next to continue
Click Yes to continue. And continue clicking Next and other options to continue installing till it finishes.
After Installing MySQL Driver and fs2.exe
Click on the Add button to add a new data source and it will show as below;
Pick MySQL ODBC 3.5.1 Driver then click finish. It pops up a new form to fill the necessary and also select database as shown below;
NB: if on a server system, the TCP/IP is ‘localhost’, also if it’s on a client system, you will have to use the IP address of the server system.
Note: If you encounter this error that ODBC 3.51 Driver cannot get hostname for your address, try and turn off the Microsoft Firewall.
Click on test to test connectivity, if successful, it will show ‘connection successful’ as shown below, if not successful; make sure the port number is open on the (server) system. Also see below on how to open your port number.
On Client System:
Map your Drive , see page 7
Configure odbc for MicMac and MicMac_Mysql, see page 18
Text for Connectivity
From the software check your config to make sure it is pointing to the right folders.
NB: The ODBC for Mysql will only connect if the server system port number is open. Also if you are connecting multiple systems, then you have to give access/ privileges to other systems. You can do this by clicking on privileges and also clicking on Add user as shown below:
Pick Any user, Any host, No Password and also make sure the ‘Grant all privileges on database ‘Micmac_cerm_local_nut’ is checked.
On the same page, click on ‘Check All’ to check all the queries then click Go. The new user will be added as shown below;
Opening Port Number
Open Windows firewall by clicking start button, clicking control panel, clicking security and then clicking Windows Firewall. Or search for “Windows Firewall with Advance Security”. So you should see this view below;
Click on the Inbound Rules, on the right hand side click “New Rule...” then it will shows you this dialog box below:
It picked program by default, so you will select port then click Next, in the next view, you will select TCP and also select Specific local ports whereby you will enter the port you want to open. See diagram below:
Click Next, choose “Allow for all connection” then click Next. Also, in the profile pane, make sure all the options are checked as shown below:
Click next, then finally, Specify a name and description for the new rule. Then click finish as shown below.
1