It is always recommend to read through all instructions first before proceeding.
NOTE: Upgrading to AyaNova 4 from AyaNova 3 requires an AyaNova 4 activation key for the same number (or more) licenses as your AyaNova 3 database was licensed for. Refer to the AyaNova Pricing web page and AyaNova FAQ Answers web page for details on this if needed.
Upgrading for network Firebird configuration is a 10 step process:
1. Apply the AyaNova 4 keycode to your AyaNova 3 database.
2. Create and backup the snapshot of your AyaNova 3 database and related files
3. Remove all AyaNova 3 programs
4. Remove Firebird 1.5
5. Install stand-alone AyaNova 4 on server
6. Install and configure Firebird 2.0
7. Configure the server's AyaNova 4 for network Firebird 2.0 database
8. Prep and install AyaNova 4 on networked computers
9. Install and configure any additional AyaNova 4 optional programs on the server (Event Generator, WBI, and/or DP)
10. Confirm your network Firebird snapshot backup and restore procedures
1. Apply the AyaNova 4 keycode to your AyaNova 3 database.
a. this can be done later in the steps, but if done before it saves confusion
2. Create and backup the snapshot of your AyaNova 3 database and related files
a. Refer to the AyaNova 3 manual for backing up your networked Firebird AyaNova 3 database to a snapshot file
b. Make a backup of your aliases.conf file in the Firebird 1.5 directory - C:\Program Files\Firebird\Firebird_1_5
| • | Alternatively, make a note to yourself the database name and path entered in that aliases.conf file |
| • | For example, if may say AYANOVA = C:\Data\AyaNova\AYANOVA.FDB |
c. Make a backup of your AyaNova 3 networkFirebirdsnapshot.bat file
3. Remove all AyaNova 3 programs
| • | Make sure all users are out of all AyaNova 3 related programs connecting to the database (AyaNova3 , QBI, PTI, WBI, AyaNova Data Portal) |
| • | If was running the network Event Generator 3 service, shut down that service |
| • | Uninstall any previous AyaNova 3 programs via Control Panel -> Add/Remove Programs |
| • | Uninstall QBI, PTI and any AyaNova 3 import utilities if applicable |
| • | Uninstall Event Generator, AyaNova Data Portal, WBI |
| • | Uninstall AyaNova 3 |
4. Un-install Firebird Server 1.5
NOTE: AyaNova 4 requires Firebird 2.0
NOTE: you can not have both versions of Firebird service running on a computer at the same time, so you must uninstall the older version 1.5 before installing Firebird 2.0 or be prepared to not run Firebird 1.5 while running 2.0 service.
5. Install stand-alone AyaNova 4 on server
a. Refer to stand-alone AyaNova 4 installation steps
b. Run AyaNova 4 and confirm it loads successfully
| • | The first time you run AyaNova 4, it will display with the AyaNova Administrator username and password pre-entered as the trial AyaNova 4 database was installed - this is OK and expected. |
The following steps will now install and configure Firebird 2, move and update your licensed AyaNova 3 database to AyaNova 4
c. Make sure you have exited out of AyaNova 4
6. Install and configure Firebird 2.0
a. Download the network Firebird 2 database server installation file from the link on the AyaNova web site http://www.ayanova.com/download.htm and be logged into the server as the server's administrator user
| • | NOTE: AyaNova 4 requires Firebird 2.0 |
| • | NOTE: you can not have both versions of Firebird service running on a computer at the same time, so you must uninstall the older version 1.5 before installing Firebird 2.0 or be prepared to not run Firebird 1.5 while running 2.0 service. |
b. Start the network Firebird 2 database server installation
| • | The installation will have defaults selected, and these defaults are what you do want. |
| • | Make sure Super Server binary is selected, and leave all other selections as shown |
d. Once the network Firebird server installation is complete, move to the Firebird program directory C:\Program Files\Firebird\Firebird_2_0 via Windows Explorer
e. Using NotePad, open the file aliases.conf
Do NOT use any other program to open and edit this file
f. Enter text identifying the name of your database and the path where your existing AyaNova 3 database file is.
For example, if your existing AyaNova 3 database is in C:\Data\AyaNova, enter the text as follows - note there is no # in front of it
AYANOVA = C:\Data\AyaNova\AYANOVA.FDB
g. Save and close the aliases.conf file
h. Reboot the computer and log in as the computer administrator again
i. Confirm that the network Firebird server is running
Open Control Panel -> Administrative Tools -> Services
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
You will also note in Control Panel is the Firebird Service Control. Double-click to open to confirm is running.
j. As the network Firebird server uses a default password that is known by all, it is suggested that you change the default password. This is an optional step.
Open a command prompt (Start -> Run -> cmd)
Move to the C:\Program Files\Firebird\Firebird_2_0\bin directory by changing to that directory by typing
CD C:\Program Files\Firebird\Firebird_2\bin
Type (do not copy – will receive syntax error message if attempt to do so)
gsec –user sysdba –password masterkey
You will now see a shell prompt
GSEC>
Type
modify sysdba –pw aya78787
(aya78787 is an example password, type in your own)
(the above command line changes the password for your Firebird server)
Make a note of this password exactly as typed
Press the Enter key and type the following at the prompt
quit
Exit out of the command prompt window
7. Configure the server's AyaNova 4 for network Firebird 2.0 database
a. Delete the existing config.txt using NotePad in the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova folder
b. Move to the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova/examples folder
c. Copy the EXAMPLE_FIREBIRD_SERVERconfig.txt file
d. Move back to the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova folder
e. Paste in the EXAMPLE_FIREBIRD_SERVERconfig.txt file into the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova folder
f. Rename this file to config.txt
g. Edit this new config.txt using NotePad
| • | Do not use any other program but NotePad to edit this file |
| • | Edit the example IP address in this file's DataSource to your server's IP address where the AyaNova database is. |
| • | Edit the database name to what you set in the aliases.config file |
| • | If you changed the Firebird Server's password in step 5.j also edit the password in this file to that. |
| • | Alternatively, you can use your server's computer name instead of its IP address. In the screenshot below, the server's full computer name is devsrvr so instead of entering where it is 192.168.1.100, you would enter devsvr if that was the name of your server |
j. Save the file.
k. Now run the AyaNova 4 program and log in as the AyaNova Administrator
| • | There may be a delay as the database is updated - let it do this. The delay could be 15 seconds up to 15 minutes or more. Let it update. |
l. If you had not pre-applied the AyaNova 4 keycode to your AyaNova 3 database, a message will display that the licenses have expired - this is OK and expected because your AyaNova 3 database had AyaNova 3 licenses, and needs to now be licensed for AyaNova 4.
m. Apply your AyaNova 4 activation keycode as per its instructions.
If you encounter an issue connecting to the AyaNova networked database via the server, do go back and double-check each of your steps from the beginning.
8. Prep and install AyaNova 4 on networked computers
a. Copy your network Firebird configured config.txt file from the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova folder to a shared location that your networked users can access.
b. Copy/Move to this same shared folder the AyaNova installation file AyaNovaSetup.exe that you used to install on the server
c. On each networked computer, uninstall any AyaNova 3 programs via the Control Panel (or delete manually the folders and files as well as any desktop icons if previously copied over)
d. Have each local networked computer run the AyaNovaSetup.exe file from that shared location that also has the edited config.txt in that same shared location.
| • | Make sure the networked computer selects AyaNova - Networked computer installation |
If the local networked computer will also run QBI, or PTI, select when installing on that computer those optional AyaNova programs. Refer to the QBI Manual or PTI Manual available from the AyaNova download web page if using QBI or PTI.
The AyaNovaSetup.exe will "see" that config.txt file and automatically copy it to that computer's AyaNova program directory so no additional configuration is needed on that user's station.
The install will only install the AyaNova program files it has been told to install, will copy that config.txt file to the networked workstations AyaNova program folder and will not install a trial database.
The AyaNova installation will place a desktop icon for AyaNova on the desktop as well as in the start menu.
You can confirm that AyaNova is configured correctly on the networked computer by logging in on that networked computer, selecting Help -> About AyaNova so that you know that you are correctly connecting to the networked Firebird configuration (screenshot below is an example and may not have the same ip address as you, same database name, nor same password)
9. Install and configure any additional AyaNova 4 optional programs on the server (Event Generator, WBI, and/or DP) as needed
See also:
AyaNova 4 Network Generator installation steps
AyaNova 4 Data Portal installation and configuration steps
QBI 4 Help file for requirements, installation and use from the AyaNova web site
PTI 4 Help file for requirements, installation and use from the AyaNova web site
WBI 4 Help file for requirements, installation, configuration and use from the AyaNova web site
10. Confirm your backup and restore procedures for your AyaNova 4 database
| • | Refer to your AyaNova 3 backed up networkFirebirdsnapshot.bat if needed when editing your AyaNova 4 networkFirebirdsnapshot.bat file - do note the different Firebird_2_0 folder for gbak |
Refer to the AyaNova Support Forum for additional sample report templates
See also:
How is AyaNova 4 different from AyaNova 3