adhocshare

Knowledge is Power

adhocshare Blog

0

Linux / Mac

Out of disk space in VirtualBox

Background Was working on compiling mysql server from source on a Oracle Linux 6 virtual machine and the root partition got full. Now what are my alternatives?   Options Increase space by resizing the .vdi disk file Tried and failed.....

0

Bigdata / Hadoop

Sqoop – Data import & export

Data import using Sqoop Teradata example $ sqoop import –connect jdbc:teradata://server_name/DATABASE=db1,LOGMECH=LDAP,CHARSET=UTF8 –driver “com.teradata.jdbc.TeraDriver” –username <user1> –password <password1> –query “select a.*, b.* from a inner join b on a.a_id=b.a_id where \$CONDITIONS AND a.f1 in (‘A’,’B’,’C’) group by 1” –null-string ‘\\N’ –null-non-string...

0

Raspberry PI

RaspberryPi

Basic Steps Increase swap partition $ less /etc/dphys-swapfile $ ll /var/swap -rw——— 1 root 100M Aug 20 06:58 /var/swap $ sudo dphys-swapfile swapoff $ sudo vi /etc/dphys-swapfile # add below line for 2GB swap partition CONF_SWAPSIZE=2048 $ sudo dphys-swapfile setup...

0

Programming

Extracting table and column names from SQL query

(Not original article) sql-metadata is a Python library that uses a tokenized query returned by python-sqlparse and generates query metadata. This metadata can return column and table names from your supplied SQL query. Here are a couple of example from the sql-metadata github readme:...

0

Mac

MacOS tips

Hide a user account in MacOS https://support.apple.com/en-us/HT203998 https://www.reddit.com/r/macsysadmin/comments/emxph7/catalina_create_a_hidden_user/ https://github.com/gregneagle/pycreateuserpkg Creating user account https://apple.stackexchange.com/questions/226073/how-do-i-create-user-accounts-from-the-terminal-in-mac-os-x-10-11 https://sterlingit.com.au/how-to-create-a-user-or-admin-user-in-osx-apple-mac-via-terminal-commands-in-9-simple-steps/ https://mackeeper.com/blog/post/356-using-various-types-of-user-accounts-on-mac/   Find files created or modified by an installer http://hints.macworld.com/article.php?story=20091223115101622   Take backup of startup entries I’d take a before and after snapshot to identify...

0

DevOps

JMeter test plan automation

This automation script runs JMeter test plan with multiple input files specified by JMeter. It also has ability to send email before working on an input file and once the input file processing is complete. This is a working attempt...

0

DevOps

Apache JMeter user.properties file

JMeter user properties file Stashing my jmeter user.properties file settings 😉   command-line > bin/jmeter.bat -n -t “project\Test Plan.jmx” -l “project\output_results\testresults.jtl”   user.properties jmeter.save.saveservice.output_format=xml jmeter.save.saveservice.url=true jmeter.save.saveservice.samplerData=true jmeter.save.saveservice.requestHeaders=true jmeter.save.saveservice.response_code=true jmeter.save.saveservice.response_data=true jmeter.save.saveservice.responseHeaders=true jmeter.save.saveservice.response_message=true jmeter.save.saveservice.thread_name=true jmeter.save.saveservice.time=true jmeter.save.saveservice.latency=true jmeter.save.saveservice.bytes=true jmeter.save.saveservice.hostname=true jmeter.save.saveservice.label=true jmeter.save.saveservice.data_type=true jmeter.save.saveservice.assertions=true jmeter.save.saveservice.assertion_results_failure_message=true...

0

Linux / Windows

WSL2 configuration

X11 forwarding on WSL2 More info here ~/.bashrc export DISPLAY=$(awk ‘/nameserver / {print $2; exit}’ /etc/resolv.conf 2>/dev/null):0 export LIBGL_ALWAYS_INDIRECT=1   Windows links for linux apps in WSL Adds linux GUI application menu to a windows toolbar https://github.com/cascadium/wsl-windows-toolbar-launcher Related posts: Access...