Widespread Augmented Reality

Widespread Augmented Reality
Click on the image to get the Android Augmented Reality Heads up Display

Sunday, September 24, 2023

XAMPP - MySQL Load Table with 8000 rows, 1.16 GB

The back up .SQL file seems to be excessively large at 1.16GB, but nevertheless I would like to load it locally on my laptop running the XAMPP server

First I alter the php.ini file so that the back up SQL file can be uploaded through XAMPP's PHPMyAdmin.

Also had to overcome a time limit constraint by editing C:\xampp\phpMyAdmin\config.inc.php with $cfg['ExecTimeLimit'] = 0;

Lastly use the command line to override mySQL settings.

After loading the table, reset mySQL settings



Perhaps rather than all this, maybe I should create and load the table with a batch program outside of PHPMyAdmin.

Saturday, September 16, 2023

Whistler TRX-1 Digital Scanner

For the past two years, I have been using a linux pc, CubicSDR and a dipole wire antenna to monitor police frequencies in Los Angeles. But since RFK Jr. was scheduled for an appearance about a mile away, I decided to dust off an actual hard wired scanner, which then made me realize that the software inside was probably out of date. Therefore, I downloaded TRX-1Install_3.45.0.700 from https://whistlergroup.com/pages/trx-1-downloads-1

  • Turn off scanner and plug into PC via the USB cable.
  • Double click the TRX-1Install file
  • Open the application: Whistler TRX-1 Handheld Digital Scanner Progamming System
  • This is also called EZ Scan software in the hard copy manual
  • Let the North American CPU firware update take place
  • Update libraries
  • Hopefully everything still works after unplugging the scanner
  • If not, hopefully I still have a back up of the SD card
  • I am sure there are earlier posts on this blog that address this
  • Thursday, September 7, 2023

    Android Studio Error: Unable to make field private final java.lang.String java.io.File.path accessible

    Unable to make field private final java.lang.String java.io.File.path accessible:
    Unable to make field private final java.lang.String java.io.File.path
    accessible: module java.base does not "opens java.io" to unnamed module

    Resolved with:


  • In build.gradle (project)

    dependencies {
    //classpath 'com.android.tools.build:gradle:4.1.2' classpath 'com.android.tools.build:gradle:4.1.3'
    classpath 'com.google.gms:google-services:4.3.15'
    classpath("com.android.tools.build:gradle:7.0.0")
    }
  • In gradle-wrapper.properties

    distributionBase=GRADLE_USER_HOME
    distributionPath=wrapper/dists
    distributionUrl=https\://services.gradle.org/distributions/gradle-7.2-bin.zip
    zipStoreBase=GRADLE_USER_HOME
    zipStorePath=wrapper/dists
  • Leaving build.gradle (app) as is.
    sourceCompatibility JavaVersion.VERSION_1_7
    targetCompatibility JavaVersion.VERSION_1_7
  • Not updating android plugin
  • Android Studio Build Run Faster

    https://developer.android.com/studio/intro/studio-config?utm_source=android-studio#antivirus-impact

    Wednesday, September 6, 2023

    Kali Linux Dual Boot on Lenovo Desktop

    SigintOS in dual boot keeps failing. Will see if 2013 desktop hardware accepts Kali dual boot

    Use Windows Disk Management, to shrink C volume to allow at least 100GB of free space after the Windows partion. I call it D: Linux
    I could format it as ext4 and label it D: Linux, but the Linux installer will likely not recognize it anyway and I'll have to set up a / root partion and swap during the Linux install.
    I do this anyway: There is now a C: Windows and D: Linux
    Download smaller installer boot image from https://www.kali.org/get-kali/#kali-platforms
    Create bootable USB with https://rufus.ie/en/
    Turn on Lenovo desktop while holding or tapping F1 to access BIOS
    In BIOS, disable Secure Boot, disable CSM, change boot priority to UEFI
    Insert bootable USB and restart with F2 or F12 keys held down to ensure booting from USB.
    With USB booted, select graphical install.
    Install in contiguous free space, but installer does not see the ext4 set up earlier.
    So select manual install and partition the free space as / and swap
    The following is covered in https://www.section.io/engineering-education/setting-up-kali-linux-for-dual-boot/ and here https://www.kali.org/docs/installation/dual-boot-kali-with-linux/:
    partition disks, erase disks, write changes to disk, install base system
    The manual partition of D: Linux resulted in immediate fail of "Install the base system"
    Using partitioning to delete my Linux partitions created with Windows.
    Now it is free space
    Select partition and select automatic partition
    Now "Install the base system" is proceeding with a progress bar
    After a long while of progress, the install fails on busybox
    Go back and recreate bootable USB with larger "installer-everything" image
    Do not select all in one partition but rather select "/home, /temp et. al." option Install the base system Select and install software If fail, abort installation, delete ext4 partitions, reboot. Select automatic partition with one / Select only default tools and top 10 Install the base system Select and install software

    Installation complete - success after several fails seems to be due to installing off the larger Kali Linux, selecting fewer tools to install.
    But now GRUB does not load. Need to go back into BIOS, disable CSM, enable UEFI boot. When hitting F12 during start up I see Kali option.
    Can I live with this?

    Also dual boot worked for me a couple years ago on a 2016 laptop. Search this blog for "dual boot"


    Immediately install these:
    sudo apt install hackrf
    sudo apt install realtek-rtl88xxau-dkms
    https://www.briansantacruz.me/2019/07/27/how-to-install-alfa-awus1900-on-kali-linux/
    Boot from USB
    Start desktop machine with F1 to enter BIOS
    Under Startup, enable CSM and set Boot Priority to [Legacy first]
    Turn off desktop machine and then turn on with F12 to boot SigintOS USB
    Adjust Text Entry settings to make English keyboard versus Turkish

    Tuesday, September 5, 2023

    SigintOS Live USB on Lenovo Desktop

    Download from https://www.sigintos.com/download/
    Using Rufus Portable https://rufus.ie/en/, create a bootable USB with persistance
    Access Lenovo desktop BIOS by hitting F12 while booting.
    Disable Secure Boot, disable CSM, change Boot Priority from Legacy to UEFI
    Plug in SigintOS USB and boot while hitting F2 or F12 to point to USB drive
  • Turn on Lenovo Tower while holding F12
  • Enable CSM
  • Boot Priority Legacy
  • Save and Exit while holding F12
  • Select the SigintOS USB as the boot device
  • While in SigintOS live, go to Settings | Keyboard | Text Entry. Remove Turkey and keep English

    Dual boot SigintOS

    Disk Management on Windows desktop: Shrink C to create a D: Linux exFat partition.
    Right click on C: and D: to access Properties. Turn on "Shared" for each partition.
    Turn off Windows and plug in SigintOS USB.
    Turn on Windows machine while hitting F12 to point to USB boot.
    While in live SigintOS, search "install"
    Select option to "Install SigintOS alongside Windows"
    Click on "advanced partitioning tool"
    Highlight the free Linux partition, format as ext4, reduce size by 4000 and specify / mount point.
    Highlight the remaining 4000 MB, format as swap.
    Install

    Damn, installer crashed.

    Sticking with the live USB flashed as DD image and no persistant storage