Install Notes of OSA 0.4.8, MYSQL 18.104.22.168, and Z-Stick Gen5
Here is my experience, which was not a fun experience, that I hope helps anyone else looking at OSA to have a much smoother process. I won't go in to the details of the horror here. Let's just say the installation and configuration was a week long on and off install / uninstall, try the change, try that change...
My installation went on to an old HP laptop running Windiws 10 that was no longer used and needed a purpose. I did not clean the OS I just took the laptop as is and started the endeavor of home automation software using OSA.
A little about me: I am very savvy when it comes to technology in general. I have coded in C#, System Admin on large domains. built / repaired systems, designed / installed / configured AMX and Crestron systems. And last, but not least, an expert troubleshooter, which was the most needed skill of all. So, what I am trying to get across is that I may be a newbie to OSA I am not when it comes to integration and programming systems.
What did I get working you may ask? So far I have OSA 0.4.8 running with MySQL 22.214.171.124 with Z-Wave, Jabber, and WUnderground configured.
1. Need a computer that can remain on and have the same IP address all the time. I chose an old laptop.
2. A Controller to control devices. I wanted to control Z-Wave devices so I purchased the newer Aeon Labs Aeotec Z-Wave Z-Stick, Gen5 (ZW090). There are other options for the control protocol.
3. Download the needed installs:
c. Extra plugins desired (Z-Wave for my needs).
d. Visual Studio. I don't know if the express versions will work since I installed a full version (Explained below).
1. Install MySQL. I installed this as a server that runs multiple applications. I did change the instance name from MYSQL5.7 to MYSQL.
2. Install OSA as a server following the instructions in the documentation.
3. Open the MySQL.ini file located in C:\ProgramData\MySQL\MySQL Server 5.7\
4. Add "event-scheduler = ON" to the end of the file. (Without the quotes)
This installs the base system. Following the documentation you should now be able to get to the web admin interface.
Installing a plug-in.
OSA installs a tool named OSA Manager. Run this tool.
1. Select plug-ins -> install plug-in.
2. Browse to the file location that you used when you downloaded the plug-in and select the plug-in then click "open".
3. click "Install" on the confirmation dialog that pops up.
4. You will get a windows dialog when the plug-in is installed correctly.
NOTE: The plug-in is not necessarily running after installation.
Configuring and running the plug-in. Specifically the Z-Wave plug-in.
This is where the nightmare started... I could not get the Z_Wave to start.
To start I did not understand the function of the dropdowns on the objects page. I would select the Z-Wave object and then I kept selecting "running" in the state dropdown thinking that was running the plug-in. This is totally wrong! You use the method dropdown to control the plug-in and the state should change accordingly. Once, I understood this troubleshooting was much easier...
Per the instructions in multiple places here, I plugged in my Z-Stick; verified the com port it was using then changed the setting in the property field of the Z-Wave object. Using the method dropdown I would select start and then I would monitor the "server logs" located on the web interface under the "logs."
I started with version 0.4.9 beta. This failed to run. after some reading I then tried 0.5.1a, 5.2a, 5.4a, 5.5a, 5.6a, 0.6.0b, 6.1b, 4.7b, and .4.8b. (what's with the version numbering anyway???) needless to say they all failed. I tried installing one version of the plug-in while replacing the config directory and other things... All to no success! Ready for what work???
The problem with 0.4.9b is that it is looking for a developer assembly that you won't have unless you install Visual Studio (VS)!!! I learned this by installing the OSA, MySQL, and the Z-Wave plug-in on my system that has VS already installed and in less than 15 min I was controlling a Z-Wave light. I then installed VS on the ole' laptop and viola the 0.4.9b (Newest) plug-in is running and OSA is now adding the devices loaded in the Z-Stick...
I then configured a couple of schedules that didn't run until I found the information in installation step 4 above.
Now, I have methods running based on schedules and events. Jabber sends me updates on changes to confirm things are getting triggered...
On to creating screens and having a user interface...
Hopefully with this post whomever does the install delivery can look at the release version and remove this little issue and anyone looking to install the newest will be able to avoid some of the major challenges I had...