Re: Another Idea HRD DB Query
You are correct. By default it uses MS Access I believe. But there is an option to convert to MySql to get performance boost which is fairly easy to do. But it was my assumption that Mike was geeky enough? to do just that. :)
-Brent N9BC
|
Re: 8 relays - no soldering
Steve, I have the 4 relay.? Sending 1 toggles.? Send 1, first time turn on.? Send 1 2nd time turn off. I am far from a programmer!
Here is a copy of the 4 relay Flow, I am developing. An Additional node is set up to shutdown or reset Pi and also shows current CPU load and CPU temperature.
If you have no want for MQTT, delete the bottom four buttons and MQTT calls.
Mike
de KA9LHE Anan 7000DLE Anan 10e
On Mon, Aug 24, 2020 at 2:11 PM Steve Bunting M0BPQ < steve@...> wrote: Hi everyone,
A small victory for me is getting some relays to switch via a simple dashboard. However, I cant work out how the payloads are configured to switch individual relays or pair of relays together. I have been editing the payload in the switch-ui node with the following results
Payload = 1 then relay 1 turns on
Payload = 2 then relay 2 turns on??
Payload = 3 then relays 1 and? 2 turn on??
Payload = 4 then relay 3 turns on
Payload = 5 then relays 1 and 3 turn on???
Payload = 6 then relays 1, 2? and 3 turn on??
Payload = 8 then relay 4 turns on
I cant see the logic to this - but I'm not always logical! Is there a way to figure this out without trial and error?
73
Steve, M0BPQ
--
Michael Coomer?
Amateur Radio Station: KA9LHE
This email has been sent from: ka9lhe@....? (260)639-4748 (Google Voice; rings cell, home, voip phones)
This email (including all attachments) from Michael Coomer is for the sole use of the recipient(s). Any unauthorized review, use, disclosure or distribution is strictly prohibited. If you are not the intended recipient of this email, please contact the sender by reply email and destroy all copies of the original message and any attachments.
|
Re: 8 relays - no soldering
2 ^ (relay number -1)
:)
Tom NY4I
toggle quoted message
Show quoted text
On Aug 24, 2020, at 2:57 PM, Steve Bunting M0BPQ < steve@...> wrote:
Now of course after posting I work it out:
Relay 1 = payload 1
Relay 2 = 2
Relay 3 = 4
Relay 4 = 8
Relay 5 = 16
Relay 6 = 32
Relay 7 = 64
Relay 8 = 128
Multiples relays are the sums. Easy when you know how.....
73
Steve
|
Re: 8 relays - no soldering
Now of course after posting I work it out:
Relay 1 = payload 1
Relay 2 = 2
Relay 3 = 4
Relay 4 = 8
Relay 5 = 16
Relay 6 = 32
Relay 7 = 64
Relay 8 = 128
Multiples relays are the sums. Easy when you know how.....
73
Steve
|
Re: Another Idea HRD DB Query
Isn’t the question first which database HRD is using? Or do later versions all use MySQL? I thought that was an option to pick your engine.
toggle quoted message
Show quoted text
On Aug 24, 2020, at 2:26 PM, Brent Crier < bcrier@...> wrote:
This might be what you are looking for,
MariaDB [(none)]> use mysql
MariaDB [(mysql)]>
SELECT COL_BAND, COL_CALL, COL_GRIDSQUARE, COL_MODE
FROM mysql.table_hrd_contacts_v01
WHERE COL_BAND='6m' and COL_MODE='ft8' and COL_GRIDSQUARE like 'EN54%';
73,
Brent N9BC
|
Re: Another Idea HRD DB Query
This might be what you are looking for,
MariaDB [(none)]> use mysql
MariaDB [(mysql)]>
SELECT COL_BAND, COL_CALL, COL_GRIDSQUARE, COL_MODE
FROM mysql.table_hrd_contacts_v01
WHERE COL_BAND='6m' and COL_MODE='ft8' and COL_GRIDSQUARE like 'EN54%';
73,
Brent N9BC
|
Re: 8 relays - no soldering
I don’t have that relay board, but it is a binary number that makes it work then I would explain it this way:
Take the payload and convert it to binary. It should be obvious at that point :-)
Payload = 1 is 00000001 Payload = 2 is 00000010 Payload = 4 is 00000100 Payload = 6 is 00000110 - Your example is wrong Payload = 7 is 00000111 - your 7 was missing Payload = 8 is 00001000
If the the bit value is 1, then the relay is on.
The bit values for the individual relays are:
1: ? ?1 2: ? ?2 3: ? ?4 4: ? ?8 5: ?16 6: ?32 7: ?64 8: 128
Example Relay 1 and 3 on is 1+2 = 3
Example” Relay 1 and 4 on is 1+8 = 9
All relays = 1+2+4+8+16+32+64+128 = 255
I hope this helps.
73, Andreas, N6NU
toggle quoted message
Show quoted text
On Aug 24, 2020, at 11:11 AM, Steve Bunting M0BPQ < steve@...> wrote:
Hi everyone,
A small victory for me is getting some relays to switch via a simple dashboard. However, I cant work out how the payloads are configured to switch individual relays or pair of relays together. I have been editing the payload in the switch-ui node with the following results
Payload = 1 then relay 1 turns on
Payload = 2 then relay 2 turns on??
Payload = 3 then relays 1 and? 2 turn on??
Payload = 4 then relay 3 turns on
Payload = 5 then relays 1 and 3 turn on???
Payload = 6 then relays 1, 2? and 3 turn on??
Payload = 8 then relay 4 turns on
I cant see the logic to this - but I'm not always logical! Is there a way to figure this out without trial and error?
73
Steve, M0BPQ
|
Re: 8 relays - no soldering
Hi everyone,
A small victory for me is getting some relays to switch via a simple dashboard. However, I cant work out how the payloads are configured to switch individual relays or pair of relays together. I have been editing the payload in the switch-ui node with the following results
Payload = 1 then relay 1 turns on
Payload = 2 then relay 2 turns on??
Payload = 3 then relays 1 and? 2 turn on??
Payload = 4 then relay 3 turns on
Payload = 5 then relays 1 and 3 turn on???
Payload = 6 then relays 1, 2? and 3 turn on??
Payload = 8 then relay 4 turns on
I cant see the logic to this - but I'm not always logical! Is there a way to figure this out without trial and error?
73
Steve, M0BPQ
|
Re: Another Idea HRD DB Query
Depending upon which database engine you have your HRD se to use, it appears there is a node-red interface to it.
?looks to be for the the Microsoft engines. No doubt a similar one exists for MySQL.
I do not use HRD but with a database schema it should not be too hard to figure out the query.?
So are you looking for a way to issue the query with the grid to alert you? I am also curious if you are getting into the arena of JTAlert and could leverage that to do the alert—just curious of your use case.
Regards,
Tom NY4I
toggle quoted message
Show quoted text
On Aug 24, 2020, at 10:29 AM, Michael Walker < va3mw@...> wrote:
Has anyone consider a database query for HRD?
In working?6M, I want to check if I need a grid number quickly.? I know I can do this with HRD, but it isn't a simple operation.
Mike va3mw
|
Node Red - more info -- Flex Community
Hi All
We are now over 150 members.
Originally, this group was started by some Flex operators to leverage some of the features of the Flex 6000 series radios.??
When the Flex Community had to be shut down as the provider was going out of business, Flex had to scramble to set up a new one (not trivial and not inexpensive).??
Before I started this group, we had a LONG chat going on on our community pages here:??
It is just another place to look if you need some more information.
73 all and thanks for joining us.
Mike va3mw?
|
Another Idea HRD DB Query
Has anyone consider a database query for HRD?
In working?6M, I want to check if I need a grid number quickly.? I know I can do this with HRD, but it isn't a simple operation.
Mike va3mw
|
Re: Error running FRStack using wiki procedure
Thanks Tom. I will update the WiKi to make it clear which version to install and update the links to the latest version of ASPNet.?
73 Dave wo2x Sent from my waxed string and tin cans.?
toggle quoted message
Show quoted text
On Aug 20, 2020, at 3:08 AM, Tom Schaefer NY4I <thomasmschaefer@...> wrote:
?Thanks for the help on this issue. The problem was that I installed the 64 bit version of aspnetcore-runtime by mistake. My Pi (3B) did not like that version. This was my mistake but I followed the bolded instructions versus reading closer and getting the 32 bit version (in the comment below it). I might suggest something in that Wiki article like this to help the next person to avoid that mistake.
If you have a 32 bit Raspberry PI, sudo wget this file:?
If you have a 64 bit version, sudo wget this file:?sudo wget https://download.visualstudio.microsoft.com/download/pr/76829580-79b2-4ec5-97ff-1a733936af14/6ba68613c7491951b896396f7d7490d9/aspnetcore-runtime-3.1.6-linux-arm64.tar.gz // Note check??for latest version under Linux...
------ Original below -----
? sudo wget https://download.visualstudio.microsoft.com/download/pr/76829580-79b2-4ec5-97ff-1a733936af14/6ba68613c7491 951b896396f7d7490d9/aspnetcore-runtime-3.1.6-linux-arm64.tar.gz
?
# The following website has this info. https://dotnet.microsoft.com/download/dotnet-core/3.1
?
# Here is the current one for ARM32 devices
# https://download.visualstudio.microsoft.com/download/pr/92e90ed5-dba3-427b-a876-8b46fe5e16b6/69cae4fe4a0ec6bc7585de6fa889fd66/aspnetcore-runtime-3.1.6-linux-arm.tar.gz
?
# From the Downloads folder, execute the following commands:
Thanks ,
Tom NY4I
|
Re: Error running FRStack using wiki procedure
Thanks for the help on this issue. The problem was that I installed the 64 bit version of aspnetcore-runtime by mistake. My Pi (3B) did not like that version. This was my mistake but I followed the bolded instructions versus reading closer and getting the 32 bit version (in the comment below it). I might suggest something in that Wiki article like this to help the next person to avoid that mistake.
If you have a 32 bit Raspberry PI, sudo wget this file:?
If you have a 64 bit version, sudo wget this file:?sudo wget https://download.visualstudio.microsoft.com/download/pr/76829580-79b2-4ec5-97ff-1a733936af14/6ba68613c7491951b896396f7d7490d9/aspnetcore-runtime-3.1.6-linux-arm64.tar.gz // Note check??for latest version under Linux...
------ Original below -----
? sudo wget https://download.visualstudio.microsoft.com/download/pr/76829580-79b2-4ec5-97ff-1a733936af14/6ba68613c7491 951b896396f7d7490d9/aspnetcore-runtime-3.1.6-linux-arm64.tar.gz
?
# The following website has this info. https://dotnet.microsoft.com/download/dotnet-core/3.1
?
# Here is the current one for ARM32 devices
# https://download.visualstudio.microsoft.com/download/pr/92e90ed5-dba3-427b-a876-8b46fe5e16b6/69cae4fe4a0ec6bc7585de6fa889fd66/aspnetcore-runtime-3.1.6-linux-arm.tar.gz
?
# From the Downloads folder, execute the following commands:
Thanks ,
Tom NY4I
|
Re: Error running FRStack using wiki procedure
Tom
Yes, you go to any browser?and access Node-Red.? IP:1880 for the flows and IP:1880/ui for the dashboard.
You do not need a desktop....However, ? Mark puts his Flows on the Raspberry Pi, "/usr/local/frstack" directory and I found running a browser on the Raspberry Pi desktop an easy way to import the flows.? Then thereafter I used my desktop browser.
I can send you the MKCM flows directly for import into your desktop Node-Red browser, if you like.? Just?let me know.? Then you do not need a Raspberry Pi desktop for accessing the flows.
You do need to access, with a terminal program, to make changes to the "/usr/local/frstack/appsettings.json" configuration file.? Settings are shown in MKCM's?instructions:
Alan
Thanks. I will break out a fresh download of Buster.
I usually use Buster-Lite. Any reason to use a desktop config with Nodered/FRStack?
I may be wrong but I am assuming that after the flows are built, one goes to a web page to access them—not the Flow editor. I hope that is right and I do not access the flows from only the local interface of the RPi with a desktop.
Thanks,
Tom NY4I
PS Sorry for the noob questions.
Tom
Mine went very smooth, using my notes. ? I did start with a "fresh" build on the Raspberry Pi using the Debian OS.
Alan I went through your updated instructions.
Is this usually this hard? FRStackWebAPI ending with error code of "error code" is curious to say the least.
pi@nodered:~$ sudo systemctl start FRStackWebApi Job for FRStackWebApi.service failed because the control process exited with error code. See "systemctl status FRStackWebApi.service" and "journalctl -xe" for details. pi@nodered:~$ journalctl -xe Aug 19 17:41:13 nodered systemd[1]: Stopped FRStack Web APIs. -- Subject: A stop job for unit FRStackWebApi.service has finished -- Defined-By: systemd -- Support:? --? -- A stop job for unit FRStackWebApi.service has finished. --? -- The job identifier is 1777 and the job result is done. Aug 19 17:41:13 nodered systemd[1]:?FRStackWebApi.service: Start request repeated too quickly. Aug 19 17:41:13 nodered systemd[1]:?FRStackWebApi.service: Failed with result 'exit-code'. -- Subject: Unit failed -- Defined-By: systemd -- Support:? --? -- The unit FRStackWebApi.service has entered the 'failed' state with result 'exit-code'. Aug 19 17:41:13 nodered systemd[1]:?Failed to start FRStack Web APIs. -- Subject: A start job for unit FRStackWebApi.service has failed -- Defined-By: systemd -- Support:? --? -- A start job for unit FRStackWebApi.service has finished with a failure. --? -- The job identifier is 1777 and the job result is failed.
Not much in the sense of diagnostics here. This is on a Pi3B now with Buster. Rebooted several times since upgrade.
I'm willing to start from scratch on anything else if that it easier.
Heck - I'll take an IMG if we just want to test the hardware.
Thanks,
Tom NY4I ?
|
Re: Error running FRStack using wiki procedure
Thanks. I will break out a fresh download of Buster.
I usually use Buster-Lite. Any reason to use a desktop config with Nodered/FRStack?
I may be wrong but I am assuming that after the flows are built, one goes to a web page to access them—not the Flow editor. I hope that is right and I do not access the flows from only the local interface of the RPi with a desktop.
Thanks,
Tom NY4I
PS Sorry for the noob questions.
toggle quoted message
Show quoted text
Tom
Mine went very smooth, using my notes. ? I did start with a "fresh" build on the Raspberry Pi using the Debian OS.
Alan I went through your updated instructions.
Is this usually this hard? FRStackWebAPI ending with error code of "error code" is curious to say the least.
pi@nodered:~$ sudo systemctl start FRStackWebApi Job for FRStackWebApi.service failed because the control process exited with error code. See "systemctl status FRStackWebApi.service" and "journalctl -xe" for details. pi@nodered:~$ journalctl -xe Aug 19 17:41:13 nodered systemd[1]: Stopped FRStack Web APIs. -- Subject: A stop job for unit FRStackWebApi.service has finished -- Defined-By: systemd -- Support:? --? -- A stop job for unit FRStackWebApi.service has finished. --? -- The job identifier is 1777 and the job result is done. Aug 19 17:41:13 nodered systemd[1]:?FRStackWebApi.service: Start request repeated too quickly. Aug 19 17:41:13 nodered systemd[1]:?FRStackWebApi.service: Failed with result 'exit-code'. -- Subject: Unit failed -- Defined-By: systemd -- Support:? --? -- The unit FRStackWebApi.service has entered the 'failed' state with result 'exit-code'. Aug 19 17:41:13 nodered systemd[1]:?Failed to start FRStack Web APIs. -- Subject: A start job for unit FRStackWebApi.service has failed -- Defined-By: systemd -- Support:? --? -- A start job for unit FRStackWebApi.service has finished with a failure. --? -- The job identifier is 1777 and the job result is failed.
Not much in the sense of diagnostics here. This is on a Pi3B now with Buster. Rebooted several times since upgrade.
I'm willing to start from scratch on anything else if that it easier.
Heck - I'll take an IMG if we just want to test the hardware.
Thanks,
Tom NY4I ?
|
Re: Error running FRStack using wiki procedure
Tom
Mine went very smooth, using my notes. ? I did start with a "fresh" build on the Raspberry Pi using the Debian OS.
Alan
I went through your updated instructions.
Is this usually this hard? FRStackWebAPI ending with error code of "error code" is curious to say the least.
pi@nodered:~$ sudo systemctl start FRStackWebApi
Job for FRStackWebApi.service failed because the control process exited with error code.
See "systemctl status FRStackWebApi.service" and "journalctl -xe" for details.
pi@nodered:~$ journalctl -xe
Aug 19 17:41:13 nodered systemd[1]: Stopped FRStack Web APIs.
-- Subject: A stop job for unit FRStackWebApi.service has finished
-- Defined-By: systemd
-- Support:
--?
-- A stop job for unit FRStackWebApi.service has finished.
--?
-- The job identifier is 1777 and the job result is done.
Aug 19 17:41:13 nodered systemd[1]: FRStackWebApi.service: Start request repeated too quickly.
Aug 19 17:41:13 nodered systemd[1]: FRStackWebApi.service: Failed with result 'exit-code'.
-- Subject: Unit failed
-- Defined-By: systemd
-- Support:
--?
-- The unit FRStackWebApi.service has entered the 'failed' state with result 'exit-code'.
Aug 19 17:41:13 nodered systemd[1]: Failed to start FRStack Web APIs.
-- Subject: A start job for unit FRStackWebApi.service has failed
-- Defined-By: systemd
-- Support:
--?
-- A start job for unit FRStackWebApi.service has finished with a failure.
--?
-- The job identifier is 1777 and the job result is failed.
Not much in the sense of diagnostics here. This is on a Pi3B now with Buster. Rebooted several times since upgrade.
I'm willing to start from scratch on anything else if that it easier.
Heck - I'll take an IMG if we just want to test the hardware.
Thanks,
Tom NY4I
?
|
Re: Error running FRStack using wiki procedure
I went through your updated instructions. Is this usually this hard? FRStackWebAPI ending with error code of "error code" is curious to say the least.
pi@nodered:~$ sudo systemctl start FRStackWebApi
Job for FRStackWebApi.service failed because the control process exited with error code.
See "systemctl status FRStackWebApi.service" and "journalctl -xe" for details.
pi@nodered:~$ journalctl -xe
Aug 19 17:41:13 nodered systemd[1]: Stopped FRStack Web APIs.
-- Subject: A stop job for unit FRStackWebApi.service has finished
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--?
-- A stop job for unit FRStackWebApi.service has finished.
--?
-- The job identifier is 1777 and the job result is done.
Aug 19 17:41:13 nodered systemd[1]: FRStackWebApi.service: Start request repeated too quickly.
Aug 19 17:41:13 nodered systemd[1]: FRStackWebApi.service: Failed with result 'exit-code'.
-- Subject: Unit failed
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--?
-- The unit FRStackWebApi.service has entered the 'failed' state with result 'exit-code'.
Aug 19 17:41:13 nodered systemd[1]: Failed to start FRStack Web APIs.
-- Subject: A start job for unit FRStackWebApi.service has failed
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--?
-- A start job for unit FRStackWebApi.service has finished with a failure.
--?
-- The job identifier is 1777 and the job result is failed.
Not much in the sense of diagnostics here. This is on a Pi3B now with Buster. Rebooted several times since upgrade.
I'm willing to start from scratch on anything else if that it easier.
Heck - I'll take an IMG if we just want to test the hardware.
Thanks,
Tom NY4I
?
|
Re: Error running FRStack using wiki procedure
Thanks Alan. I will update the WiKi later.?
Dave wo2x Sent from my waxed string and tin cans.?
toggle quoted message
Show quoted text
On Aug 19, 2020, at 2:35 PM, Alan Blind, WA9WUD <a.alan.blind@...> wrote:
? Tom
I had the same problem with that step.? In the end, the step was not necessary?and I skipped it.? Here are my notes on the FRS install.? Suggest you re-boot?your Raspberry Pi and run all of the steps from the beginning, as shown in my notes.
Alan WA9WUD
<Screen Shot 2020-08-19 at 2.30.27 PM.png>
|
Re: Error running FRStack using wiki procedure
Tom
I had the same problem with that step.? In the end, the step was not necessary?and I skipped it.? Here are my notes on the FRS install.? Suggest you re-boot?your Raspberry Pi and run all of the steps from the beginning, as shown in my notes.
Alan WA9WUD
|
Re: Error running FRStack using wiki procedure
That’s a lot of Pi. Too bad they aren’t the kind you can eat. I prefer Boston Creame Pie.?
Sorry. Needed some humor today.?
Dave wo2x Sent from my waxed string and tin cans.?
toggle quoted message
Show quoted text
On Aug 19, 2020, at 2:19 PM, Tom Schaefer NY4I <thomasmschaefer@...> wrote:
? I just realized I am on Stretch. Upgrading the RPi to Buster and trying again.?
Hazards of having 15 RPis in the house.?
Tom NY4I Principal Solutions Architect Better Software Solutions, Inc.? 727-437-2771 On Aug 19, 2020, at 2:15 PM, Tom Schaefer NY4I via groups.io <thomasmschaefer@...> wrote:
?I am new to Nodered and FRStack. I followed the procedure on the Wiki to install and ran into an issue with the FRStack WebAPI. I am using the procedure here:?/g/nodered-hamradio/wiki/22502 I did the steps to download and unzip FRStack. I verified each step worked.
Install FRStack WebAPI on RPi
sudo mkdir -p /usr/local/frstack
cd /usr/local/frstack
sudo wget http://www.mkcmsoftware.com/download/FRStackWebApiRpi.zip
sudo unzip FRStackWebApiRpi
?
Run FRStack WebAPI from commandline
dotnet FRStackWebApi.dll --urls "http://*:5025"
When I enter the?botnet?command, I receive the following error:
pi@nodered:/usr/local/frstack$ dotnet FRStackWebApi.dll --urls "http://*:5025"
-bash: /usr/bin/dotnet: cannot execute binary file: Exec format error
Has anyone run into that?
Thanks,
Tom NY4I
|
Tom Schaefer - NY4I
Dave wo2x