This quick document highlight how allow Amazon Redshift to load data from S3 bucket in another AWS account and possibly in different AWS Region
AWS Account A
region us-west-2 -> S3 bucket my.bucket
Daniel P nokernel
nokernel
/ aws-redshift-copy-s3-role.md
Created
June 1, 2017 18:18
allow Amazon Redshift to load data from S3 bucket in another AWS account and possibly in different AWS Region
nokernel
/ keybase.md
Created
September 10, 2019 20:33
I hereby claim:
- I am nokernel on github.
- I am nokernel (https://keybase.io/nokernel) on keybase.
- I have a public key ASDgMzY77JtqV1NOcJXHRyZ7X0xKzO2hDp4Z-qvztkxKtQo
To claim this, I am signing this object:
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /dts-v1/; | |
| / { | |
| interrupt-parent = < 0x01 >; | |
| #address-cells = < 0x02 >; | |
| #size-cells = < 0x02 >; | |
| model = "Purism Librem 5"; | |
| compatible = "purism,librem5\0fsl,imx8mq"; | |
| aliases { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Script started on 2020-01-03 08:13:08-05:00 [TERM="xterm-256color" TTY="/dev/pts/0" COLUMNS="80" LINES="24"] | |
| root@pietro:~# dmesg | grep -i camera | |
| [ 1.517773] device: 'camera_en': device_add | |
| [ 1.517825] PM: Adding info for No Bus:camera_en | |
| root@pietro:~# v4l2-ctl --list-devices | |
| Cannot open device /dev/video0, exiting. | |
| root@pietro:~# i2cdetect -l | |
| i2c-3 i2c 30a50000.i2c I2C adapter | |
| i2c-1 i2c 30a30000.i2c I2C adapter | |
| i2c-2 i2c 30a40000.i2c I2C adapter |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [Fri Jan 3 11:27:38 2020] bus: 'platform': really_probe: probing driver pwm-imx27 with device 30660000.pwm | |
| [Fri Jan 3 11:27:38 2020] pwm-imx27 30660000.pwm: no init pinctrl state | |
| [Fri Jan 3 11:27:38 2020] pwm-imx27 30660000.pwm: no sleep pinctrl state | |
| [Fri Jan 3 11:27:38 2020] pwm-imx27 30660000.pwm: no idle pinctrl state | |
| [Fri Jan 3 11:27:38 2020] pwm-imx27 30660000.pwm: getting ipg clock failed with -517 | |
| [Fri Jan 3 11:27:38 2020] platform 30660000.pwm: Driver pwm-imx27 requests probe deferral | |
| [Fri Jan 3 11:27:38 2020] platform 30660000.pwm: Added to deferred list | |
| [Fri Jan 3 11:27:38 2020] bus: 'platform': driver_probe_device: matched device 30670000.pwm with driver pwm-imx27 | |
| [Fri Jan 3 11:27:38 2020] bus: 'platform': really_probe: probing driver pwm-imx27 with device 30670000.pwm | |
| [Fri Jan 3 11:27:38 2020] pwm-imx27 30670000.pwm: no init pinctrl state |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Date: 2020-01-04 EST | |
| [09:52:21.700] weston 5.0.0 | |
| https://wayland.freedesktop.org | |
| Bug reports to: https://gitlab.freedesktop.org/wayland/weston/issues/ | |
| Build: unknown (not built from git or tarball) | |
| [09:52:21.701] Command line: weston -Swayland-1 --log=/home/purism/weston.log | |
| [09:52:21.701] OS: Linux, 5.3.0-librem5-h1, #1 SMP PREEMPT Tue Dec 24 15:42:56 CET 2019, aarch64 | |
| [09:52:21.701] Starting with no config file. | |
| [09:52:21.702] Output repaint window is 7 ms maximum. | |
| [09:52:21.702] Loading module '/usr/lib/aarch64-linux-gnu/libweston-5/wayland-backend.so' |
nokernel
/ weston-start.log
Created
January 4, 2020 14:55
Librem5 weston startup log with WAYLAND_DEBUG=1
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [2463518.480] -> [email protected]_registry(new id wl_registry@2) | |
| [2463518.656] -> [email protected](new id wl_callback@3) | |
| [2463519.357] [email protected]_id(3) | |
| [2463519.401] [email protected](1, "wl_data_device_manager", 3) | |
| [2463519.461] [email protected](2, "wl_shm", 1) | |
| [2463519.508] -> [email protected](2, "wl_shm", 1, new id [unknown]@4) | |
| [2463519.571] [email protected](3, "zwp_linux_dmabuf_v1", 3) | |
| [2463519.609] [email protected](4, "wl_drm", 2) | |
| [2463519.646] [email protected](5, "zxdg_output_manager_v1", 2) | |
| [2463519.685] [email protected](6, "wl_compositor", 4) |
nokernel
/ gist:eed52f1e9800e26c53766dee07f2d0f5
Created
January 28, 2020 22:49
libremd5 bluetooth headset crash wifi+bluetooth
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [Tue Jan 28 17:37:15 2020] redpine_91x: rsi_interrupt_handler: Failed to Read Intr Status Register | |
| [Tue Jan 28 17:37:15 2020] bus: 'sdio': remove device mmc1:fffd:1 | |
| [Tue Jan 28 17:37:15 2020] redpine_91x: rsi_sdio_check_buffer_status: Failed to read status register | |
| [Tue Jan 28 17:37:15 2020] redpine_91x: rsi_sdio_check_buffer_status: Failed to read status register | |
| [Tue Jan 28 17:37:15 2020] redpine_91x: rsi_sdio_check_buffer_status: Failed to read status register | |
| [Tue Jan 28 17:37:15 2020] redpine_91x: rsi_sdio_check_buffer_status: Failed to read status register | |
| [Tue Jan 28 17:37:15 2020] redpine_91x: rsi_sdio_check_buffer_status: Failed to read status register | |
| [Tue Jan 28 17:37:15 2020] redpine_91x: rsi_sdio_check_buffer_status: Failed to read status register | |
| [Tue Jan 28 17:37:15 2020] redpine_91x: rsi_sdio_check_buffer_status: Failed to read status register | |
| [Tue Jan 28 17:37:15 2020] redpine_91x: rsi_sdio_check_buffer_status: Failed to read status register |
nokernel
/ sysbench --threads=4 cpu run
Last active
May 16, 2020 14:22
librem5 Chestnut sysbench cpu run
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| sysbench --threads=4 cpu run | |
| sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) | |
| Running the test with following options: | |
| Number of threads: 4 | |
| Initializing random number generator from current time | |
| Prime numbers limit: 10000 |
nokernel
/ librem5-chestnut-no-wwan-adapder
Created
February 16, 2021 20:44
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [Tue Feb 16 15:40:59 2021] usb 1-1.2: reset high-speed USB device number 11 using xhci-hcd | |
| [Tue Feb 16 15:41:00 2021] usb 1-1.2: USB disconnect, device number 11 | |
| [Tue Feb 16 15:41:00 2021] option1 ttyUSB0: GSM modem (1-port) converter now disconnected from ttyUSB0 | |
| [Tue Feb 16 15:41:00 2021] option 1-1.2:1.0: device disconnected | |
| [Tue Feb 16 15:41:00 2021] option1 ttyUSB1: GSM modem (1-port) converter now disconnected from ttyUSB1 | |
| [Tue Feb 16 15:41:00 2021] option 1-1.2:1.1: device disconnected | |
| [Tue Feb 16 15:41:00 2021] option1 ttyUSB2: GSM modem (1-port) converter now disconnected from ttyUSB2 | |
| [Tue Feb 16 15:41:00 2021] option 1-1.2:1.2: device disconnected | |
| [Tue Feb 16 15:41:00 2021] option1 ttyUSB3: GSM modem (1-port) converter now disconnected from ttyUSB3 | |
| [Tue Feb 16 15:41:00 2021] option 1-1.2:1.3: device disconnected |
OlderNewer