Date   

Re: TNC-Pi9k6 reset

John G8BPQ
 

I doubt if the reset is needed, but can’t speak for all software. It isn’t
used by linbpq.

73, John G8BPQ

________________________________________
From: RaspberryPi-4-HamRadio@groups.io
[mailto:RaspberryPi-4-HamRadio@groups.io] On Behalf Of N5XMT
Sent: 07 September 2020 00:36
To: RaspberryPi-4-HamRadio@groups.io
Subject: [RaspberryPi-4-HamRadio] TNC-Pi9k6 reset

Hi All,
Putting together the tower of Babel for all my digital needs LOL.  
Using my 8GB Pi4, TNC-pi9K6, FE-PI audio board, and a Nexus DR-X dual radio
controller.  It allows 2 radios to be used with the sound card TNC etc.
With this combo, I could potentially be running 3 radios independently from
1 Pi.  The issue I am having, is GPIO18, Pin 12 of the Pi's GPIO header is
used by the TNC-Pi9K6 as a reset pin.  The FE-PI uses it as a PCM clock for
the audio... so, once the overlay for the FE-PI is loaded, the Teensy in the
TNC-Pi9K6 is held in a continuous resetting condition. 
My Question is, do I need really need a hardware reset from the Pi for the
Teensy?  I can cut the trace and put a physical push button on the TNC-Pi9K6
if it is needed.
Thanks


Re: /dev/ttyUSB0 device not responding

N5XMT
 

ssh in and do sudo raspi-config
go to interfacing and serial port.
disable logins to the serial port and enable the hardware.

On Sun, Sep 6, 2020 at 5:18 PM VK2AHB <vk2ahb@...> wrote:
I have just re-flashed Buster and installed Build-a-pi.  flrig can't configure the USB port with  error  "Transceiver is not responding"

I tried flrig on the laptop and all is OK.
ls -sal *USB*
0 crw-rw---- 1 root dialout 188, 0 Sep  7 10:10 ttyUSB0

pi is a member of dialout group.  I've never seen this behaviour before.

Paul VK2AHB
 


/dev/ttyUSB0 device not responding

VK2AHB
 

I have just re-flashed Buster and installed Build-a-pi.  flrig can't configure the USB port with  error  "Transceiver is not responding"

I tried flrig on the laptop and all is OK.
ls -sal *USB*
0 crw-rw---- 1 root dialout 188, 0 Sep  7 10:10 ttyUSB0

pi is a member of dialout group.  I've never seen this behaviour before.

Paul VK2AHB
 


TNC-Pi9k6 reset

N5XMT
 

Hi All,
Putting together the tower of Babel for all my digital needs LOL.  
Using my 8GB Pi4, TNC-pi9K6, FE-PI audio board, and a Nexus DR-X dual radio controller.  It allows 2 radios to be used with the sound card TNC etc.
With this combo, I could potentially be running 3 radios independently from 1 Pi.  The issue I am having, is GPIO18, Pin 12 of the Pi's GPIO header is used by the TNC-Pi9K6 as a reset pin.  The FE-PI uses it as a PCM clock for the audio... so, once the overlay for the FE-PI is loaded, the Teensy in the TNC-Pi9K6 is held in a continuous resetting condition. 
My Question is, do I need really need a hardware reset from the Pi for the Teensy?  I can cut the trace and put a physical push button on the TNC-Pi9K6 if it is needed.
Thanks


TNC-Pi inventory for sale

Chuck K4RGN
 

As the TARPN project in central North Carolina migrates from TNC-Pi's to NinoTNCs, I am selling my inventory of TNC-Pi parts:
1. One assembled and populated TNC-Pi, green PCB version 2.3 TARPN. It was working when removed from service. This board has a 2x5 bus connector, installed top side only.
2. One kit TNC-Pi, unassembled; bag appears to contain all parts except the four ICs that go in sockets (see below). Green PCB version 2.3a TARPN. This board has a place for a 2x5 bus connector.
3. Three assembled TNC-Pis, populated except no socketed ICs (see below).
   a. Two red PCB version 1.1. These boards have space for a 2x13 connector. 2x5 connectors are installed, top side only. 
   b. One red PCB version 1.2. A 2x13 connector is installed, top side only, with two pins clipped. 
4. Uninstalled ICs:
  a. Six PIC16F1847 microcontrollers with W2FS firmware. Buyer will have to reset their data values to W2FS defaults using the TXDELAY pot.
  b. Five MX614 modems.
  c. Six 6023 op-amps.
  d. Four 23K640 memories.
 
This sale is as-is, no warranty. Entire lot only. Sale is final, no returns or refund. Just $90 plus $20 for insured USPS shipping to 48 CONUS. Email k4rgn@... if interested. Will verify buyer's address at qrz.com, so include your callsign.

73, Chuck, K4RGN


Re: New participant and new with the Raspi

Julio Paredes - KW4WA
 

Thanks.  That did it.


Re: TT4 delays about 15 seconds as KISS modem

Bill AA6BD
 

Thanks, Mark, for the clarification.  I removed the line starting with "ADMIN=", replaced "$ADMIN" with my call sign, replaced "tnc" with my axport name as specified in /etc/ax25/axports and it works fine now.
--
Bill AA6BD


Re: Fw: Docker 101, Adaptive Joins, and more (Database Weekly 2020-09-05)

rene wit de
 

Please ignore this message,wrong forward address


Fw: Docker 101, Adaptive Joins, and more (Database Weekly 2020-09-05)

rene wit de
 




From: Database Weekly <subscriptions@...>
Sent: Saturday, September 5, 2020 7:05 AM
To: renedewit@... <renedewit@...>
Subject: Docker 101, Adaptive Joins, and more (Database Weekly 2020-09-05)
 

 

Problems displaying this newsletter? View online.
Database Weekly
The Complete Weekly Roundup of SQL Server News
Hand-picked content to sharpen your professional edge
Editorial
 

Mentoring

Over the years when I changed careers and then advanced in IT, many people helped me learn or provided opportunities. Some of these people gave specific in-person help, like my brothers who taught me programming logic and database normalization before I ever thought about working in technology. Others assisted from a distance when I read their books and articles or watched their presentations. I’m not sure if these people can be called my mentors, but I am sure I wouldn’t be where I am today without them.

I count Steve Jones as a long-time mentor because he was the person who helped develop me as a writer 15 years ago. He was also kind enough to sit with me to discuss my career options one year at PASS Summit, and I’m sure he was quite busy that week, so I’m grateful that he took the time. We’ve never had any kind of formal mentorship set up, but I know I can always count on him for advice. (We work together now at Redgate!)

A consulting company I worked for a few years ago set up mentoring sessions between senior and junior consultants. I ended up with three or four juniors who wanted me to mentor them. If I remember correctly, many of the sessions would be cancelled due to customer work, so I’m not sure how effective they were.

Today, I get many informal requests asking for help with just about anything related to the data platform. Many are requests for good books on a particular data platform topic. It's frequently on an area I know nothing about, and only or or two books might exist on the topic as well.

I also often get asked for help with queries. This usually ends up with me writing a query instead of actually teaching anything. It's also possibly not correct because most people don’t take the time to provide enough sample data nor all the business rules. Most problems are not straightforward. My advice is to be sure to provide a script with the create table and insert statements as well as making sure that the data is representative, not just one edge case. In fact, it is probably better to post your one-off questions like this on a forum or #sqlhelp. That way, more people who have some time to spare will see your questions.

Right now, I have what I’ll call official mentoring relationships set up with three people. I’ve given each individual some recommendations, and there are specific goals in mind. So far, my mentees are enthusiastic and following up with me on their own. It is up to them to do the work. The outcome is not my problem; however, I will assist the best I can and am rooting for them.

Being a mentor is a great way to pay it forward. For those of you who have found mentors, remember that they are giving you a precious give – their time.

Kathi Kellenberger

Join the debate, and respond to the editorial on the forums

 
Redgate University
The Weekly News
All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit.
Vendors/3rd Party Products

When SQL Server Performance Goes Bad: Rogue Indexes

Phil Factor explains how SQL Monitor helps focus performance tuning efforts on the tables and queries where 'rogue indexes' might be a significant problem, and then how to identify both 'missing' indexes that might be beneficial to the overall workload, and those that are unused or duplicated, and so are doing more harm than good.

.NET Related Articles

Build a REST API in .NET Core

A REST API can hide the complexity behind large scale solutions using simple verbs like POST, PUT, or PATCH. In this article, Camilo Reyes explains how to create a REST API in .NET Core.

AI/Machine Learning/Cognitive Services

Google offers to help others with the tricky ethics of AI

Services to include spotting racial bias, developi...

Information Measurement with SQL Server, Part 6.1: Information Gain and Tree Structures

By Steve Bolton …………Like many of my other series of amateur mistutorials, the section of my blog devoted to the broad topic of Information Measurement is ultimately meant to... The...

Why Build a Hybrid Data Lake for Analytics and AI

Click to learn more about author Haoyuan Li. The present global crisis has bolstered cries for cost-cutting across organizations. Data lakes spanning from on-premises environments to a public cloud...

Administration

Restoring the SQL Server Master Database

The master database contains records of the structure/configuration for both the current instance and all other databases...

Troubleshoot a SQL Server performance issue like a pro – Part 1

Once you have worked on enough SQL Server performance issues, you start to develop an approach and lean on the same tools...

dbachecks meets ImportExcel

I got a message from a friend on Twitter last night asking ‘Is there an easy way to get dbachecks backup info into an Excel spreadsheet?’...

Change Azure SQL Database Service Level Objectives in SSMS

Sometimes as a DBA, I am lazy and want the ability to execute all of my tasks in one place...

Storage 101: The Future of Storage

Robert Sheldon wraps up his series on storage by discussing the latest storage innovation and ideas.

Restoring the SQL Server Master Database

Total: 1 Average: 5 INTRODUCTION The master database contains records of the structure/configuration for both the current instance and all other databases. When you run sp_configure, you are writing...

Failing SQL Agent Jobs – Part 1

SQL Server Agent Jobs are one of the core features of SQL Server. Agent Jobs perform many actions, from maintenance tasks (server and database), data movement flows, replication, log... The...

Redgate SQL Prompt
Big Data

How to Leverage Big Data for Business Intelligence

Click to learn more about author Errin O’Connor. If you have heard about Moore’s law, then you know that in the span of two years, the computer’s capacity increases...

Computing in the Cloud (Azure, Google, AWS)

Microsoft Azure Announces Project Bicep, an ARM DSL

Managing Azure Resource Manager (ARM) templates can be challenging. The Microsoft Azure team is aware of the challenges and has released a very early-alpha-v0.1 version of a new effort named...

Podcast recording – Mixed Extents 01 – Cloud vs. On-Prem

I’m thrilled to have been part of the second Eig...

Conferences, Classes, Events, and Webinars

Monitoring is Key to Database DevOps Success

Through automated database monitoring, organizations are not only catching deployment issues faster, they are also resolving them quicker by empowering seamless integration between development and database management teams.

Fully Left-shifted Deployments with Version Control and Automatic Cloning

Discover the future of DevOps! Join Microsoft MVP Kendra Little to see Redgate's recent innovations in action and give you a picture of where Database DevOps is going, and why.

DMO/SMO/Powershell

dbatools.io = command-line SQL Server Management Studio: Let me see

dbatools commands used: Get-DbaDatabase Get-DbaDbF...

Database Design, Theory and Development

The final word on storage for DATETIME2

Two years ago I wrote a post that got a lot of traction in the comments at the time. Last month there was renewed interest because one of the...

DevOps and Continuous Delivery (CI/CD)

Database Development with GitHub

How can you use GitHub to do team-based database development? This article proposes a process that splits development work into task-based GitHub branches, incorporates daily database builds and integration...

The top 7 benefits of DevOps for CEOs

Updated August 2020 If you were asked what the benefits of DevOps are, you could probably name two or three straight away. Maybe four or five. But – and...

DevOps for Data Science – Continuous Delivery

In this series on DevOps for Data Science, I’ve explained the concept of a DevOps “Maturity Model” – a list of things you can do, in order, that will...

ETL/SSIS/Azure Data Factory/Biml

Creating Your First Azure Data Factory

Azure Data Factory has grown in both popularity an...

HA/DR/Always On/Clustering

Configuring AlwaysOn Availability Groups on SQL Server

Total: 1 Average: 5INTRODUCTION This document describes the steps and additional information necessary to configure AlwaysOn Availability Groups for HA and DR on MS SQL Server. AlwaysOn Availability Groups...

Performance Tuning SQL Server

Adaptive Joins in SQL Server

SQL Server 2017 (compatibility 140) brought us many Intelligent Query Processing (IQP), formally known as Adaptive Query Processing, features that improve performance on workloads straight out of the box... The...

Starting SQL: Things Query Plans Can’t Tell You

Hidey-Hole When you’re looking at the execution plan for a query that someone is griping about, one thing to keep in mind is that it’s just part of the picture....

Starting SQL: Compensating For Lock Waits

No, Lock Locks are necessary, I’m told. There’s this whole “ACID” thing that makes databases work. It’s generally a good idea for people who into correct answers. But blocking is one...

PowerPivot/PowerQuery/PowerBI

New Power BI Migration Documentation

I’m really pleased to announce that new Power BI Migration documentation that I authored is published on the

Power BI in Excel updates and more… (Roundup | Aug 31, 2020)

Thanks for watching this week's Power BI news roun...

Professional Development

Lessons learned from being self-employed, 2 years in

Two years ago I quit my job and started working for myself. After two years, I think most people would look at it as a big success, I’m now...

Security News and Issues

We Didn't Encrypt Your Password, We Hashed It. Here's What That Means:

You've possibly just found out you're in a data breach. The organisation involved may have contacted you and advised your password...

T-SQL

Columnstore Query Patterns

Ed Pollack walks us through some query patterns wh...

Please stop using this UPSERT anti-pattern

There is a very common anti-pattern you should avoid, involving updating a row if it exists and inserting it if it doesn't. See how to avoid race conditions and...

Weighted Randomization In T-SQL

When I am not working on or writing about SQL, I am posting theme park pictures on Twitter of DisneyWorld (@DisneyPicADay) and Dollywood (@DollywoodP). The fun part of it...

All triggers have to be able to handle multiple row operations.

Quick post today. Recently I was helping a co-worker write a trigger. Basically there is a table of servers that’s ... Continue reading The post All triggers have to be...

Who Dropped Your Table? – SQL in Sixty Seconds #112

Who Dropped My Table? - I was recently asked this ...

SQL Homework – September 2020 – More DML Triggers

Triggers. Still blech. In June I asked you to play with DML triggers. Well, one more time. First of all ... Continue reading The post SQL Homework – September 2020...

Virtualization and Containers/Kubernetes

Windows containers & SQL Server – Part 3 – Error Logs

So far this series has covered: installing Docker for Windows...

Docker 101 and How do containers work?

Everyone is using containers and talking about containers. Except those for whom it hasn't "clicked." Obvious to some and unendingly frustrating to others, containers are changing how we build...

 
RSS FeedTwitter
This email has been sent to renedewit@.... To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@.... This newsletter was sent to you because you signed up at SQLServerCentral.com. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@...

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -


Re: TT4 delays about 15 seconds as KISS modem

Mark Griffith
 

It's just grabbing the call sign, so just replace $ADMIN with your call sign.

Mark
KD0QYN


On Friday, September 4, 2020, 5:59:06 PM CDT, Bill AA6BD <bill@...> wrote:


Mark,
In your little program, I understand substituting my callsign and tnc name in axports.  I don't have a file wl2k.conf.  I have a directory /etc/ax25 which is where axports and a bunch of ax25....conf files are stored but there is no wl2k.conf file in that directory.  What is this file?
--
Bill AA6BD


Re: New participant and new with the Raspi

K6AEA@...
 

Did you right-click the speaker icon, and select the appropriate output?


Re: TT4 delays about 15 seconds as KISS modem

Bill AA6BD
 

Mark,
In your little program, I understand substituting my callsign and tnc name in axports.  I don't have a file wl2k.conf.  I have a directory /etc/ax25 which is where axports and a bunch of ax25....conf files are stored but there is no wl2k.conf file in that directory.  What is this file?
--
Bill AA6BD


Re: Dual purpose DMR hotspot and HF digimodes

Bryan Waller
 

Just ordered the least expensive dual band, dual timeslot MMDVM with decent reviews from Amazon and reviews confirming that it runs on the PI4b. I'll likely first set it up with its own SD card image since I have never run a DMR hotspot before, then try to incorporate it in with my KM4ACK build a pi setup on a separate SD. Since the single timeslots have long run on the original pi, I would think that the 4b would have plenty of processing power to do DMR hotspot and HF digital duty at the same time, even running dual timeslots. We shall see. If it doesn't work, I'll order another PI and set them up separately.


Re: Dual purpose DMR hotspot and HF digimodes

 

I would think a Pi with a HAT (like DRAWS™) for HF/Digital Data such as Packet and an attached USB MMDVM for digital voice modes would be a good combination.

On Fri, Sep 4, 2020 at 7:48 AM Bryan Waller <bryanw55@...> wrote:
I may give it a roll in the near future. Worst case is that I'd have to buy another pi if it doesn't work.



--
John D. Hays
Kingston, WA
K7VE

 


Re: Dual purpose DMR hotspot and HF digimodes

Bryan Waller
 

I may give it a roll in the near future. Worst case is that I'd have to buy another pi if it doesn't work.


Re: Dual purpose DMR hotspot and HF digimodes

the gadget techie
 

That would be interesting.  All the DMR stuff is just a process on the pi being it's derived from Debian.  Limits maybe imposed by the mem/cpu capabilities, in that can it perform efficient enough under the various load that the apps place on the unit.  All the GUI-based stuff will put a higher demand on the processing capabilities vs. the DMR "conversion".

Would be an interesting POC.


Re: TT4 delays about 15 seconds as KISS modem

Mark Griffith
 

I'm not sure if it the kissattach or just starting the AX.25 service.  This may have appeared in early kernels, it wasn't in Wheezy, but when Buster was released, this delay showed up.  May have been in Stretch too.  Annoying, but that is what you get with open sourced software.  I notice it as every time AX.25 is started.

My answer was every time I start the AX.25 service, I run a little program to wake it up.

#!/bin/sh

ADMIN=`grep ^mycall /usr/local/etc/wl2k.conf | cut -d\= -f2`
/usr/sbin/beacon tnc $ADMIN -s -t1 "Test"
/usr/sbin/beacon tnc $ADMIN -s -t1 "Test"
/usr/sbin/beacon tnc $ADMIN -s -t1 "Test"

This just sends a very small beacon signal and every AX.25 transmission after that will not have a delay.  The first two "tests" are not normally transmitted, but the third will.

You would have to modify the script for your call sign and the tnc name in axports.

Mark
KD0QYN


On Thursday, September 3, 2020, 1:20:53 PM CDT, David Ranch <rpi4hamradio-groupsio@...> wrote:



This is a known behavior of the mkiss kernel module creating a one-time delay.  There are a few ways to address this (crc_force=1) this be it just be patient for your first connection attempt OR change the options used when the mkiss kernel module is installed.  This later approach is the way I do it on my system via my packetrig.sh startup script:

   http://www.trinityos.com/HAM/CentosDigitalModes/usr/local/sbin/packetrig.sh
   --

   #Attempt to set the crcmode to NONE :: this can also be done with kissparm's -c option
   echo -e "\nLoading mkiss kernel module with CRC-mode: none" >> $LOG 2>&1
   $MODPROBE -q mkiss crc_force=1 >> $LOG 2>&1
   --

--David
KI6ZHD


On 09/03/2020 10:26 AM, Bill AA6BD wrote:
I have a TT4 connected to a Raspberry Pi running PAT Winlink client and ax.25 and kissattach.  I can connect the TT4 to PAT client when I use the kissattach command.  After I power up my Raspberry Pi, the first time that I try to connect PAT to a gateway, there is about a 15 second delay when it seems nothing is happening, and then the TT4 issues a PTT and the radio connects to the gateway and all works as expected.

If I try again to connect PAT to the gateway, there is no delay.  The PTT happens almost immediately and the session proceeds.

Is there some setting in the TT4 or in the Raspberry Pi (PAT or ax.25 or kissattach?) that can reduce or eliminate the 15 second delay the first time?
--
Bill AA6BD


Re: TT4 delays about 15 seconds as KISS modem

David Ranch
 


This is a known behavior of the mkiss kernel module creating a one-time delay.  There are a few ways to address this (crc_force=1) this be it just be patient for your first connection attempt OR change the options used when the mkiss kernel module is installed.  This later approach is the way I do it on my system via my packetrig.sh startup script:

   http://www.trinityos.com/HAM/CentosDigitalModes/usr/local/sbin/packetrig.sh
   --

   #Attempt to set the crcmode to NONE :: this can also be done with kissparm's -c option
   echo -e "\nLoading mkiss kernel module with CRC-mode: none" >> $LOG 2>&1
   $MODPROBE -q mkiss crc_force=1 >> $LOG 2>&1
   --

--David
KI6ZHD


On 09/03/2020 10:26 AM, Bill AA6BD wrote:
I have a TT4 connected to a Raspberry Pi running PAT Winlink client and ax.25 and kissattach.  I can connect the TT4 to PAT client when I use the kissattach command.  After I power up my Raspberry Pi, the first time that I try to connect PAT to a gateway, there is about a 15 second delay when it seems nothing is happening, and then the TT4 issues a PTT and the radio connects to the gateway and all works as expected.

If I try again to connect PAT to the gateway, there is no delay.  The PTT happens almost immediately and the session proceeds.

Is there some setting in the TT4 or in the Raspberry Pi (PAT or ax.25 or kissattach?) that can reduce or eliminate the 15 second delay the first time?
--
Bill AA6BD


TT4 delays about 15 seconds as KISS modem

Bill AA6BD
 

I have a TT4 connected to a Raspberry Pi running PAT Winlink client and ax.25 and kissattach.  I can connect the TT4 to PAT client when I use the kissattach command.  After I power up my Raspberry Pi, the first time that I try to connect PAT to a gateway, there is about a 15 second delay when it seems nothing is happening, and then the TT4 issues a PTT and the radio connects to the gateway and all works as expected.

If I try again to connect PAT to the gateway, there is no delay.  The PTT happens almost immediately and the session proceeds.

Is there some setting in the TT4 or in the Raspberry Pi (PAT or ax.25 or kissattach?) that can reduce or eliminate the 15 second delay the first time?
--
Bill AA6BD


FoxTelem using USB Sound

Suryono Adisoemarta
 

Has anybody use a USB soundcard to decode using FoxTelem ?

On mine I can see it detected on starting FoxTelem.jar, but not shown / available on the dropdown source menu.

This is on Rpi 3B running headless

73 de Yono - YD0NXX

1781 - 1800 of 13915