|
This type of installation would be for where the database is located in a shared location on a “server” with the AyaNova program run from each networked computer.
Use of AyaNova with network Firebird engine is a 5 step process
| 1. | Ensure network uses TCPIP for communication between computers and server |
| 2. | Embedded AyaNova database and program is installed to server |
| 3. | Network Firebird database server is installed and configured |
| 4. | Configure access for the AyaNova program |
| 5. | Configure network computers |
1. Requirements prior to installation
The server and networked computers will communicate via TCPIP. If your network is not configured, please contact your local computer center.
Determine the server’s static internal IP address or the server’s computer name.
| 1. | Determine the internal network IP Address of the server |
| a. | Open a command prompt on the server (Start -> Run -> cmd) and type |
ipconfig
| b. | Make a note of the server’s IP Address |
| c. | Confirm that network computers can “talk” to the server |
| i. | Open a command prompt on the networked computer and type |
ping 192.168.1.15
| ii. | Substitute the example IP address above 192.168.1.15 for your server’s IP Address |
| iii. | If you get a timeout, there is an issue connecting via TCPIP. Please contact your local computer center to troubleshoot. |
| 2. | Determine the server’s computer name by opening the System Properties |
| a. | Screenshot below, the computer name is devsrvr |
2. Installation of AyaNova to server
| 2. | As recommended in the installation - take all defaults – install to the suggested program path C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3 |
| 3. | Once installation is complete, log into AyaNova and confirm successful |
| 5. | It is very important that the AyaNova database is not accessed further unless stated so in the following steps. If the AyaNova database is accessed before steps are completed, corruption could occur. |
3. Installation and configuration of access via network Firebird database server
| 1. | Create a folder from which the networked AyaNova database will be located |
| a. | For example: C:\Data\AyaNova |
| 2. | Move the AYANOVA.FDB file from C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3 to this new folder |
| a. | Do not move or edit or copy this database file once Firebird is installed |
| 3. | Download the network Firebird database server installation file from the link on the AyaNova web site |
| 4. | Start the network Firebird database server installation |
| 5. | Accept all defaults – do NOT deselect or select other than the defaults. |
| 6. | Make sure Super Server binary is selected, and leave all other selections as shown |
| 7. | Leave all selections as shown in screenshot above. |
| a. | If you receive the error |
The dynamic link library MSVCP60.DLL could not be found.
| b. | Copy the file MSVCP60.DLL from another computer to the System32 folder of the Windows folder for the operating system |
| c. | Restart the network Firebird server installation |
| 8. | Once the network Firebird server installation is complete, move to the Firebird program directory C:\Program Files\Firebird\Firebird_1_5 |
| 9. | Using NotePad, open the file aliases.conf |
| a. | Do NOT use any other program to open and edit this file |
| 10. | Enter the following text |
AYANOVA = C:\Data\AyaNova\AYANOVA.FDB
| a. | Where C:\Data\AyaNova\AYANOVA.FDB is the folder and AyaNova database file |
| 11. | Save and close the aliases.conf file |
| 12. | Reboot the computer and log in as the computer administrator again |
| 13. | Confirm that the network Firebird server is running |
| a. | Open Control Panel -> Administrative Tools -> Services |
| b. | Confirm both the Firebird Guardian Service and the Firebird Service are running, that the Firebird Guardian Service is set to Automatic and the Firebird Service is set to Manual as shown in screenshot below |
| d. | You will also note in Control Panel is the Firebird Service Control |
| e. | Double-click to open to confirm is running |
| 14. | As the network Firebird server uses a default password that is known by all, you need to change it. (Password below is example only - use your own password) |
| a. | Open a command prompt (Start -> Run -> cmd) |
| b. | Move to the C:\Program Files\Firebird\Firebird_1_5\bin directory |
gsec –user sysdba –password masterkey
| d. | You will now see a shell prompt |
GSEC>
modify sysdba –pw aya78787
| f. | aya78787 is an example password, type in your own |
| g. | make a note of this password |
quit
| j. | Close the command prompt window |
| k. | Now you can configure access for networked computers |
4. Configure access for the AyaNova program
| 1. | Delete the existing AyaNova.exe.config file in C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3 |
| 2. | Rename the AyaNova.exe.config.FIREBIRD_SERVER_VERSION file to AyaNova.exe.config |
| 3. | Use NotePad to open this AyaNova.exe.config |
| l. | Do NOT use any other program to edit this file |
| 4. | Edit the sample IP Address to your server’s IP Address |
Or enter the server’s computer name
| 5. | Edit the password to the password you created above in step 16 |
| 6. | Save and close the file |
| 7. | Delete the AyaNova icon on your desktop and create a new shortcut to the AyaNova.exe executable |
| 8. | Double-click on this new AyaNova icon on your desktop to confirm successful start up and log into the networked AyaNova database |
| 9. | First time the AyaNova log in screen loads, it may take a few seconds – it will come up. |
| 10. | If you receive an error instead of the AyaNova login screen, go back through each step and confirm in case of a spelling or location error |
5. Configuration of networked computers
| 1. | Uninstall any previous AyaNova v3 installation |
| a. | Use of previous AyaNova 3 program files or previous beta AyaNova database will result in corruption |
| 2. | Install Microsoft .NET Framework 2 and applicable service patches. |
| a. | Check if already installed by opening Control Panel -> Add/remove Programs -> scroll to determine if Microsoft .NET Framework 2 is installed |
| b. | Refer to the Microsoft downloads web page http://www.microsoft.com/downloads if you do not already have this installed. If not displayed under Popular Downloads, enter Microsoft .NET Framework 2 in the Search for a Download section |
| c. | Be sure computer has been rebooted if just installed |
| 3. | Copy the folder and all its files C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3 from the server you configured in the previous steps to the local hard-drive of each networked computer. |
| a. | Do NOT run the AyaNova executable from a networked location – all program files must reside with all files on each computer's local hard drive |
| 4. | Create a desktop shortcut to the AyaNova.exe |
| a. | Right-click on the desktop |
| c. | Browse to the location of the AyaNova 3 folder and files that you copied to this networked computer's local hard drive |
| g. | Type a name “AyaNova v3” |
Run AyaNova by double-clicking the AyaNova desktop icon and confirm successful login.
Please note that moving, editing or copying a live database file will cause database problems – even corruption
If you need to move or copy the networked AYANOVA.FDB database file, before preceding you must:
| • | Ensure all AyaNova users are not accessing |
| • | Shut down any AyaNova related running programs (Event Generator, AyaNovaDP, etc) |
| • | Open Control Panel -> Firebird Server Manager -> select Stop |
Refer to the section on backing up the AyaNova database file when using the network Firebird server.
|