| columns_that_make_record_distinct = [:some_id, :another_name] | |
| distinct_ids = Model.select("MIN(id) as id").group(columns_that_make_record_distinct).map(&:id) | |
| duplicate_records = Model.where.not(id: distinct_ids) |
| sudo apt-get update | |
| sudo apt-get install build-essential chrpath libssl-dev libxft-dev -y | |
| sudo apt-get install libfreetype6 libfreetype6-dev -y | |
| sudo apt-get install libfontconfig1 libfontconfig1-dev -y | |
| cd ~ | |
| export PHANTOM_JS="phantomjs-2.1.1-linux-x86_64" | |
| wget https://github.com/Medium/phantomjs/releases/download/v2.1.1/$PHANTOM_JS.tar.bz2 | |
| sudo tar xvjf $PHANTOM_JS.tar.bz2 | |
| sudo mv $PHANTOM_JS /usr/local/share | |
| sudo ln -sf /usr/local/share/$PHANTOM_JS/bin/phantomjs /usr/local/bin |
The PostgreSQL container stopped unexpectedly, was automatically restarted, but suddenly didn't accept any connections anymore. Neither from the API service containers nor from the Macbook over the internet.
Error in logs:
FATAL: pg_hba.conf rejects connection for host "10.0.1.2", user "postgres", database "******", SSL off
| # This file contains pin mappings for the Anycubic i3 Mega with | |
| # Ultrabase from 2017. (This config may work on an Anycubic i3 Mega v1 | |
| # prior to the Ultrabase if you comment out the definition of the | |
| # endstop_pin in the stepper_z1 section.) To use this config, the | |
| # firmware should be compiled for the AVR atmega2560. | |
| # See the example.cfg file for a description of available parameters. | |
| [stepper_x] | |
| step_pin: PF0 |
| ; /usr/share/pulseaudio/alsa-mixer/profile-sets/astro-a50-gen4.conf | |
| [General] | |
| auto-profiles = yes | |
| [Mapping analog-voice] | |
| description = Voice | |
| device-strings = hw:%f,0,0 | |
| channel-map = left,right | |
| paths-output = steelseries-arctis-output-chat-common |
This will allow you to test a specific frequency that you hear when you do your resonance testing in Klipper and potentially track down where extra peaks are coming from. If something is rattling at a specific frequency, you can specify that frequency and feel around the printer until you track it down.
Code was adopted by zifnab from somewhere in Klipper.
You have to have [resonance_holder] in your printer.cfg.
The command is HOLD_RESONANCE AXIS=<axis> FREQ=int SECONDS=<seconds>