'프로그램 사용'에 해당되는 글 2263건

  1. 2024.07.25 postgresql permission denied for schema public
  2. 2024.07.24 라즈베리에 phppgadmin. 안되잖아?
  3. 2024.07.23 phppgadmin
  4. 2024.07.22 ssh socks proxy
  5. 2024.07.22 postgresql 15.7 on rpi
  6. 2024.07.21 postgresql cli
  7. 2024.07.19 meld 자동 줄 바꿈
  8. 2024.07.19 qemu arm 에뮬레이션
  9. 2024.07.17 libfreenect2 성공
  10. 2024.07.15 libfreenect2 실행 성공..
프로그램 사용/postgreSQL2024. 7. 25. 15:05

postgresql permission denied for schema public

계정생성하고 database생성하고 테이블 만들려는데.. 어라?

ERROR:  permission denied for schema public

 

찾아보니 권한과 소유권을 둘 다 줘야 가능한 듯.

권한만 줘서는 동일한 에러가 발생한다.

GRANT ALL ON DATABASE mydb TO admin;
ALTER DATABASE mydb OWNER TO admin;

[링크 : https://stackoverflow.com/questions/74110708/postgres-15-permission-denied-for-schema-public]

저작자표시

'프로그램 사용 > postgreSQL' 카테고리의 다른 글

postgresql 리스트 명령  (0) 2024.07.25
라즈베리에 phppgadmin. 안되잖아?  (0) 2024.07.24
phppgadmin  (0) 2024.07.23
postgresql 15.7 on rpi  (0) 2024.07.22
postgresql cli  (0) 2024.07.21
Posted by 구차니
프로그램 사용/postgreSQL2024. 7. 24. 10:55

라즈베리에 phppgadmin. 안되잖아?

접속 시도해보니 안되길래

 

버전 확인

phpPgAdmin 7.13.0 (PHP 8.2.7)

 

postgresql은 아래와 같은데..

$ psql --version
psql (PostgreSQL) 15.7 ( 15.7-0+deb12u1)

 

그래서 phpPgAdmin 버전으로 찾아보니..

7.13.0 이후로는 안나오는것 같고(2020년 11월 9일.. 4년 가까이 과거..)

그 당시 지원되는게 Postgres 13 / 14.. 15니 될리가 없었...나?

phpPgAdmin 7.13.0 Now Available!
Posted on 2020-11-09 by phpPgAdmin Project
 Related Open Source
I’m pleased to announce the latest release of phpPgAdmin, version 7.13.0.

This release incorporates the following changes:

Add support for Postgres 13
Add provisional support for Postgres 14
Upgrade Jquery library to 3.4.1 (Nirgal)
Allow users to see group owned databases when using “owned only”
Fix bug where sorting on selects dumped you to the table screen (MichaMEG)

[링크 : https://www.postgresql.org/about/news/phppgadmin-7130-now-available-2107/]

 

죽은 프로젝트 인 듯.. 걍 사용을 포기하는게 낫겠다..

[링크 : https://github.com/phppgadmin/phppgadmin]

[링크 : https://sourceforge.net/projects/phppgadmin/]

저작자표시

'프로그램 사용 > postgreSQL' 카테고리의 다른 글

postgresql 리스트 명령  (0) 2024.07.25
postgresql permission denied for schema public  (0) 2024.07.25
phppgadmin  (0) 2024.07.23
postgresql 15.7 on rpi  (0) 2024.07.22
postgresql cli  (0) 2024.07.21
Posted by 구차니
프로그램 사용/postgreSQL2024. 7. 23. 19:29

phppgadmin

pgadmin은 써봐도 phppgadmin은 첨인가...

 

 

[링크 : https://www.rosehosting.com/blog/how-to-install-phppgadmin-on-ubuntu-22-04/]

 

 

+

생각해보니 pgadmin 이라고 웹기반으로 하는 녀석이었지

phpmyadmin 처럼 apache에서 웹을 띄워서 하진 않았던 것 같다.

저작자표시

'프로그램 사용 > postgreSQL' 카테고리의 다른 글

postgresql permission denied for schema public  (0) 2024.07.25
라즈베리에 phppgadmin. 안되잖아?  (0) 2024.07.24
postgresql 15.7 on rpi  (0) 2024.07.22
postgresql cli  (0) 2024.07.21
psql copy to  (0) 2020.02.10
Posted by 구차니
프로그램 사용/ssh scp sftp2024. 7. 22. 19:08

ssh socks proxy

예전에 해봤는데 안되길래 포기했던 녀석들..

이제는 시간이 지났으니 잘 되려나?

 

ssh -D

[링크 : https://superuser.com/questions/408031/differences-between-ssh-l-to-d]

 

wget은 socks proxy 미지원,curl 사용 필요

[링크 : https://askubuntu.com/questions/1327783/can-you-set-socks5-proxy-from-linux-command-line]

 

--proxy-server="socks5://myproxy:8080"

[링크 : https://www.chromium.org/developers/design-documents/network-stack/socks-proxy/]

 

[링크 : https://thesafety.us/proxy-setup-chrome-windows]

[링크 : https://datawookie.dev/blog/2023/12/ssh-tunnel-dynamic-port-forwarding/]

저작자표시

'프로그램 사용 > ssh scp sftp' 카테고리의 다른 글

ssh ecdsa 미지원(ubuntu 22.04)  (0) 2023.05.30
ubuntu ssh x11 forwarding시 gnome 화면 끌어오기  (0) 2022.07.11
ssh 슈도 터미널 실행  (0) 2022.04.25
ssh Are you sure you want to continue connecting (yes/no)?  (0) 2022.04.25
sshd 에서 ssh 로그인 끄고 sftp만 허용하기  (0) 2022.04.01
Posted by 구차니
프로그램 사용/postgreSQL2024. 7. 22. 10:46

postgresql 15.7 on rpi

예전 centos 할 때 랑은 또 경로가 달라져서 헷갈리네

 

설정 변경

# cat /etc/postgresql/15/main/pg_hba.conf 
local   all             postgres                                peer

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     md5
# IPv4 local connections:
host    all             all             127.0.0.1/32            scram-sha-256
# IPv6 local connections:
host    all             all             ::1/128                 scram-sha-256
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     peer
host    replication     all             127.0.0.1/32            scram-sha-256
host    replication     all             ::1/128                 scram-sha-256

 

서비스 재기동

$ sudo systemctl restart postgresql

 

postgres 계정으로 로그인 후 계정 및 database 생성

pi@raspberrypi:~ $ sudo su - postgres
postgres@raspberrypi:~$ psql
psql (15.7 ( 15.7-0+deb12u1))
Type "help" for help.

postgres=# create user username with password 'userpassword';
CREATE ROLE
postgres=# create database userdb;
CREATE DATABASE
materials=> \q
postgres@raspberrypi:~$

 

일반 계정에서 특정 사용자로 로그인

pi@raspberrypi:~ $ psql -U username userdb
Password for user username: 
psql (15.7 ( 15.7-0+deb12u1))
Type "help" for help.

userdb=> \q

 

[링크 : https://zipeya.tistory.com/entry/postgresql-DB생성-및-접속-시-Peer-authentication에러-발생-시-해야할-것]

저작자표시

'프로그램 사용 > postgreSQL' 카테고리의 다른 글

라즈베리에 phppgadmin. 안되잖아?  (0) 2024.07.24
phppgadmin  (0) 2024.07.23
postgresql cli  (0) 2024.07.21
psql copy to  (0) 2020.02.10
postgresql 제약조건 관련  (0) 2020.02.07
Posted by 구차니
프로그램 사용/postgreSQL2024. 7. 21. 01:28

postgresql cli

이전에는 대부분 pgadmin 이라는 웹기반으로 사용하다 보니 콘솔에서 쓸 방법 찾는 중

 

[링크 : https://www.postgresql.org/docs/current/app-psql.html]

[링크 : https://kwomy.tistory.com/m/9]

[링크 : https://kugancity.tistory.com/m/entry/postgre-sql-command-line에서-사용하기]

 

저작자표시

'프로그램 사용 > postgreSQL' 카테고리의 다른 글

phppgadmin  (0) 2024.07.23
postgresql 15.7 on rpi  (0) 2024.07.22
psql copy to  (0) 2020.02.10
postgresql 제약조건 관련  (0) 2020.02.07
postgresql database / table 복제 및 동기화  (0) 2020.02.07
Posted by 구차니
프로그램 사용/meld2024. 7. 19. 10:50

meld 자동 줄 바꿈

meld 에서 항상 옆으로 길게 보이다 보니 어떻게 설정을 해야 하나 찾아보는데

용어가 나중에 겨우 기억나서 검색..

word wrap

 

아무튼 Meld - Preference - 편집기 - 표시 에서

Enable text wrapping 과

Do not split words over two lines 를 체크해주면 된다.

 

 

[링크 : https://superuser.com/questions/1716173/meld-wrap-lines-keep-whole-words]

저작자표시

'프로그램 사용 > meld' 카테고리의 다른 글

meld for windows 비교 내용이 안나오는 문제  (0) 2014.03.31
meld for windows  (0) 2014.03.31
meld 에서 문법강조 켜기(syntax highlighter on Meld)  (0) 2011.10.15
meld - GUI merge tool for linux  (0) 2009.04.06
GUI diff tool - meld  (6) 2009.02.13
Posted by 구차니
프로그램 사용/qemu2024. 7. 19. 09:27

qemu arm 에뮬레이션

x86 에서 arm을 qemu를 통해 해보고 싶어져서 찾아보는 중

 

$ sudo apt install qemu-system-arm

[링크 : https://ubuntu.com/server/docs/boot-arm64-virtual-machines-on-qemu]

 

$ sudo apt-get install gcc-arm-linux-gnueabihf libc6-dev-armhf-cross qemu-user-static

[링크 : https://gist.github.com/luk6xff/9f8d2520530a823944355e59343eadc1]

저작자표시

'프로그램 사용 > qemu' 카테고리의 다른 글

colo qemu  (0) 2019.03.25
qcow2  (0) 2019.02.01
qemu on windows  (0) 2012.04.24
qemu 사용하기  (0) 2012.04.11
qemu / qemu-launcher  (0) 2012.04.08
Posted by 구차니
프로그램 사용/kinect2024. 7. 17. 23:55

libfreenect2 성공

아.. 역시 컴퓨터를 바꾸면 잘되는구나.. (어?)

 

심심해서 키넥트 본체는 연결안하고 허브만 연결했더니 당연하게(?) 허브만 뜬다.

 

파란 부분은 키넥트 본체를 꼽아야만 뜨는 부분

$ sudo dmesg -w
[ 1780.341670] usb 4-4: new SuperSpeed USB device number 8 using xhci_hcd
[ 1781.804378] usb 3-4: new high-speed USB device number 7 using xhci_hcd
[ 1781.954783] usb 3-4: New USB device found, idVendor=045e, idProduct=02d9, bcdDevice= 0.70
[ 1781.954794] usb 3-4: New USB device strings: Mfr=1, Product=2, SerialNumber=0
[ 1781.954797] usb 3-4: Product: NuiSensor Adaptor      
[ 1781.954800] usb 3-4: Manufacturer: Microsoft Corporation  
[ 1781.955676] hub 3-4:1.0: USB hub found
[ 1781.955807] hub 3-4:1.0: 1 port detected
[ 1783.324924] usb 4-4: New USB device found, idVendor=045e, idProduct=02d9, bcdDevice= 0.73
[ 1783.324936] usb 4-4: New USB device strings: Mfr=1, Product=2, SerialNumber=0
[ 1783.324940] usb 4-4: Product: NuiSensor Adaptor      
[ 1783.324942] usb 4-4: Manufacturer: Microsoft Corporation  
[ 1783.326192] hub 4-4:1.0: USB hub found
[ 1783.326380] hub 4-4:1.0: 1 port detected
[ 1783.808453] usb 4-4.1: new SuperSpeed USB device number 9 using xhci_hcd
[ 1783.829395] usb 4-4.1: New USB device found, idVendor=045e, idProduct=02d8, bcdDevice= 1.00
[ 1783.829404] usb 4-4.1: New USB device strings: Mfr=1, Product=2, SerialNumber=4
[ 1783.829408] usb 4-4.1: Product: Xbox NUI Sensor
[ 1783.829410] usb 4-4.1: Manufacturer: Microsoft
[ 1783.829413] usb 4-4.1: SerialNumber: 501441643042

 

빌드하고 실행하니

~/src/libfreenect2/build/bin$ ./Protonect 
Version: 0.2.0
Environment variables: LOGFILE=<protonect.log>
Usage: ./Protonect [-gpu=<id>] [gl | cl | clkde | cuda | cudakde | cpu] [<device serial>]
        [-noviewer] [-norgb | -nodepth] [-help] [-version]
        [-frames <number of frames to process>]
To pause and unpause: pkill -USR1 Protonect
[Info] [Freenect2Impl] enumerating devices...
[Info] [Freenect2Impl] 10 usb devices connected
[Info] [Freenect2Impl] found valid Kinect v2 @4:5 with serial 501441643042
[Info] [Freenect2Impl] found 1 devices
libva info: VA-API version 1.14.0
libva error: vaGetDriverNameByIndex() failed with unknown libva error, driver_name = (null)
[Error] [VaapiRgbPacketProcessorImpl] vaInitialize(display, &major_ver, &minor_ver): unknown libva error
[Info] [Freenect2DeviceImpl] opening...
[Info] [Freenect2DeviceImpl] transfer pool sizes rgb: 20*16384 ir: 60*8*33792
[Info] [Freenect2DeviceImpl] opened
[Info] [Freenect2DeviceImpl] starting...
[Debug] [Freenect2DeviceImpl] status 0x090000: 9729
[Debug] [Freenect2DeviceImpl] status 0x090000: 9731
[Info] [Freenect2DeviceImpl] submitting rgb transfers...
[Info] [Freenect2DeviceImpl] submitting depth transfers...
[Debug] [DepthPacketStreamParser] not all subsequences received 0
[Info] [Freenect2DeviceImpl] started
device serial: 501441643042
device firmware: 4.0.3911.0
[Debug] [DepthPacketStreamParser] not all subsequences received 768
[Debug] [DepthPacketStreamParser] skipping depth packet
[Debug] [DepthPacketStreamParser] skipping depth packet
[Debug] [DepthPacketStreamParser] skipping depth packet
[Debug] [DepthPacketStreamParser] skipping depth packet
[Debug] [DepthPacketStreamParser] skipping depth packet
[Debug] [DepthPacketStreamParser] skipping depth packet
[Info] [DepthPacketStreamParser] 6 packets were lost
[Info] [OpenGLDepthPacketProcessor] avg. time: 16.9263ms -> ~59.0797Hz
[Info] [TurboJpegRgbPacketProcessor] avg. time: 15.0939ms -> ~66.2519Hz
[Info] [OpenGLDepthPacketProcessor] avg. time: 14.96ms -> ~66.8449Hz
[Info] [TurboJpegRgbPacketProcessor] avg. time: 15.5262ms -> ~64.4071Hz
[Info] [OpenGLDepthPacketProcessor] avg. time: 14.8158ms -> ~67.4954Hz
[Info] [TurboJpegRgbPacketProcessor] avg. time: 15.8073ms -> ~63.2617Hz
[Info] [OpenGLDepthPacketProcessor] avg. time: 14.3364ms -> ~69.7524Hz
[Info] [TurboJpegRgbPacketProcessor] avg. time: 16.633ms -> ~60.1215Hz

 

잘나온다. 저번에 10세대에서는 카메라 영상(좌하단)과 3d로 재구성된 영상(우상단)이 찌그러지던데, 무슨 차이이려나?

 

 

저작자표시

'프로그램 사용 > kinect' 카테고리의 다른 글

libfreenect2 on 2760p 성공  (0) 2024.08.18
libfreenect2 실행 성공..  (0) 2024.07.15
libfreenect2 실행 실패  (0) 2024.07.14
libfreenect2 CUDA 끄고 빌드 성공  (0) 2024.07.13
kinect v2 / freenect 실패  (0) 2024.07.09
Posted by 구차니
프로그램 사용/kinect2024. 7. 15. 21:57

libfreenect2 실행 성공..

10세대 노트북에서 해서 그런가 잘 된다.

2세대에는 native USB3.0이 없어서 그런가?

 

[  102.223422] usb 1-3: new high-speed USB device number 5 using xhci_hcd
[  102.375595] usb 1-3: New USB device found, idVendor=045e, idProduct=02d9, bcdDevice= 0.70
[  102.375609] usb 1-3: New USB device strings: Mfr=1, Product=2, SerialNumber=0
[  102.375615] usb 1-3: Product: NuiSensor Adaptor      
[  102.375619] usb 1-3: Manufacturer: Microsoft Corporation  
[  102.377490] hub 1-3:1.0: USB hub found
[  102.377643] hub 1-3:1.0: 1 port detected
[  102.832793] usb 2-3: new SuperSpeed USB device number 3 using xhci_hcd
[  105.820384] usb 2-3: New USB device found, idVendor=045e, idProduct=02d9, bcdDevice= 0.73
[  105.820400] usb 2-3: New USB device strings: Mfr=1, Product=2, SerialNumber=0
[  105.820406] usb 2-3: Product: NuiSensor Adaptor      
[  105.820411] usb 2-3: Manufacturer: Microsoft Corporation  
[  105.825068] hub 2-3:1.0: USB hub found
[  105.825375] hub 2-3:1.0: 1 port detected
[  106.307431] usb 2-3.1: new SuperSpeed USB device number 4 using xhci_hcd
[  106.328374] usb 2-3.1: New USB device found, idVendor=045e, idProduct=02d8, bcdDevice= 1.00
[  106.328380] usb 2-3.1: New USB device strings: Mfr=1, Product=2, SerialNumber=4
[  106.328381] usb 2-3.1: Product: Xbox NUI Sensor
[  106.328383] usb 2-3.1: Manufacturer: Microsoft
[  106.328384] usb 2-3.1: SerialNumber: 501441643042
[  106.379651] usbcore: registered new interface driver snd-usb-audio
[  120.739532] usb 2-3.1: reset SuperSpeed USB device number 4 using xhci_hcd
[  163.891946] warning: `ThreadPoolForeg' uses wireless extensions which will stop working for Wi-Fi 7 hardware; use nl80211
[  188.498922] usb 1-3: USB disconnect, device number 5
[  188.581688] usb 2-3: USB disconnect, device number 3
[  188.581693] usb 2-3.1: USB disconnect, device number 4

 

되니 좋긴한데.. 되서 나쁘네.. 컴퓨터 바꾸어야 한다는 말이잖아.. ㅠㅠ

libfreenect2/build/bin$ ./Protonect 
Version: 0.2.0
Environment variables: LOGFILE=<protonect.log>
Usage: ./Protonect [-gpu=<id>] [gl | cl | clkde | cuda | cudakde | cpu] [<device serial>]
        [-noviewer] [-norgb | -nodepth] [-help] [-version]
        [-frames <number of frames to process>]
To pause and unpause: pkill -USR1 Protonect
[Info] [Freenect2Impl] enumerating devices...
[Info] [Freenect2Impl] 8 usb devices connected
[Info] [Freenect2Impl] found valid Kinect v2 @2:4 with serial 501441643042
[Info] [Freenect2Impl] found 1 devices
libva info: VA-API version 1.14.0
libva info: Trying to open /usr/lib/x86_64-linux-gnu/dri/iHD_drv_video.so
libva info: Found init function __vaDriverInit_1_14
libva info: va_openDriver() returns 0
[Info] [VaapiRgbPacketProcessorImpl] driver: Intel iHD driver for Intel(R) Gen Graphics - 22.3.1 ()
[Info] [Freenect2DeviceImpl] opening...
[Info] [Freenect2DeviceImpl] transfer pool sizes rgb: 20*16384 ir: 60*8*33792
[Info] [Freenect2DeviceImpl] opened
[Info] [Freenect2DeviceImpl] starting...
[Debug] [Freenect2DeviceImpl] status 0x090000: 9729
[Debug] [Freenect2DeviceImpl] status 0x090000: 9731
[Info] [Freenect2DeviceImpl] submitting rgb transfers...
[Info] [Freenect2DeviceImpl] submitting depth transfers...
[Debug] [DepthPacketStreamParser] not all subsequences received 0
[Info] [Freenect2DeviceImpl] started
device serial: 501441643042
device firmware: 4.0.3911.0
[Debug] [DepthPacketStreamParser] not all subsequences received 960
[Debug] [DepthPacketStreamParser] not all subsequences received 1007
[Info] [DepthPacketStreamParser] 1 packets were lost
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Debug] [DepthPacketStreamParser] not all subsequences received 511
[Debug] [DepthPacketStreamParser] not all subsequences received 1019
[Info] [DepthPacketStreamParser] 3 packets were lost
[Debug] [DepthPacketStreamParser] not all subsequences received 1015
[Debug] [DepthPacketStreamParser] not all subsequences received 1015
[Debug] [DepthPacketStreamParser] not all subsequences received 1019
[Info] [DepthPacketStreamParser] 3 packets were lost
[Info] [OpenGLDepthPacketProcessor] avg. time: 7.41895ms -> ~134.79Hz
[Info] [VaapiRgbPacketProcessor] avg. time: 3.69809ms -> ~270.41Hz
[Debug] [DepthPacketStreamParser] not all subsequences received 1015
[Info] [DepthPacketStreamParser] 1 packets were lost
[Info] [OpenGLDepthPacketProcessor] avg. time: 7.03777ms -> ~142.091Hz
[Info] [VaapiRgbPacketProcessor] avg. time: 3.92516ms -> ~254.767Hz
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Debug] [DepthPacketStreamParser] not all subsequences received 1019
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Debug] [DepthPacketStreamParser] not all subsequences received 991
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Debug] [DepthPacketStreamParser] not all subsequences received 987
[Info] [DepthPacketStreamParser] 7 packets were lost
[Debug] [DepthPacketStreamParser] not all subsequences received 511
[Debug] [DepthPacketStreamParser] not all subsequences received 511
[Debug] [DepthPacketStreamParser] not all subsequences received 991
[Debug] [DepthPacketStreamParser] not all subsequences received 511
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Debug] [DepthPacketStreamParser] not all subsequences received 1019
[Debug] [DepthPacketStreamParser] not all subsequences received 767
[Debug] [DepthPacketStreamParser] not all subsequences received 991
[Debug] [DepthPacketStreamParser] not all subsequences received 1019
[Info] [DepthPacketStreamParser] 9 packets were lost
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Debug] [DepthPacketStreamParser] not all subsequences received 971
[Debug] [DepthPacketStreamParser] not all subsequences received 511
[Debug] [DepthPacketStreamParser] not all subsequences received 511
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Info] [VaapiRgbPacketProcessor] avg. time: 4.29916ms -> ~232.603Hz
[Debug] [DepthPacketStreamParser] not all subsequences received 1019
[Debug] [DepthPacketStreamParser] not all subsequences received 511
[Debug] [DepthPacketStreamParser] not all subsequences received 511
[Info] [DepthPacketStreamParser] 9 packets were lost
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Debug] [DepthPacketStreamParser] not all subsequences received 987
[Info] [OpenGLDepthPacketProcessor] avg. time: 7.66351ms -> ~130.489Hz
[Debug] [DepthPacketStreamParser] not all subsequences received 511
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Debug] [DepthPacketStreamParser] not all subsequences received 1019
[Debug] [DepthPacketStreamParser] not all subsequences received 511
[Debug] [DepthPacketStreamParser] not all subsequences received 511
[Debug] [DepthPacketStreamParser] not all subsequences received 511
[Info] [DepthPacketStreamParser] 9 packets were lost
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Debug] [DepthPacketStreamParser] not all subsequences received 1019
[Info] [DepthPacketStreamParser] 2 packets were lost
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Debug] [DepthPacketStreamParser] not all subsequences received 1007
[Info] [VaapiRgbPacketProcessor] avg. time: 4.41688ms -> ~226.404Hz
[Info] [DepthPacketStreamParser] 2 packets were lost
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Debug] [DepthPacketStreamParser] not all subsequences received 1019
[Info] [DepthPacketStreamParser] 2 packets were lost
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Info] [OpenGLDepthPacketProcessor] avg. time: 6.63554ms -> ~150.704Hz
[Debug] [DepthPacketStreamParser] not all subsequences received 510
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Debug] [DepthPacketStreamParser] not all subsequences received 1019
[Debug] [DepthPacketStreamParser] not all subsequences received 1015
[Info] [DepthPacketStreamParser] 5 packets were lost
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Info] [DepthPacketStreamParser] 2 packets were lost
[Info] [VaapiRgbPacketProcessor] avg. time: 4.01999ms -> ~248.757Hz
[Debug] [DepthPacketStreamParser] not all subsequences received 511
[Info] [DepthPacketStreamParser] 1 packets were lost
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Debug] [DepthPacketStreamParser] not all subsequences received 511
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Info] [OpenGLDepthPacketProcessor] avg. time: 6.68671ms -> ~149.55Hz
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Debug] [DepthPacketStreamParser] not all subsequences received 1022
[Info] [DepthPacketStreamParser] 5 packets were lost
[Debug] [DepthPacketStreamParser] not all subsequences received 511
[Debug] [DepthPacketStreamParser] not all subsequences received 511
[Info] [DepthPacketStreamParser] 2 packets were lost
[Info] [VaapiRgbPacketProcessor] avg. time: 4.43949ms -> ~225.251Hz
[Info] [OpenGLDepthPacketProcessor] avg. time: 6.87763ms -> ~145.399Hz
[Info] [VaapiRgbPacketProcessor] avg. time: 4.5502ms -> ~219.771Hz
[Info] [OpenGLDepthPacketProcessor] avg. time: 6.86435ms -> ~145.68Hz
[Debug] [DepthPacketStreamParser] not all subsequences received 511
[Debug] [DepthPacketStreamParser] not all subsequences received 959
[Debug] [DepthPacketStreamParser] not all subsequences received 895
[Debug] [DepthPacketStreamParser] not all subsequences received 511
[Debug] [DepthPacketStreamParser] not all subsequences received 959
[Info] [DepthPacketStreamParser] 5 packets were lost
[Info] [VaapiRgbPacketProcessor] avg. time: 4.07819ms -> ~245.207Hz
[Info] [OpenGLDepthPacketProcessor] avg. time: 6.89874ms -> ~144.954Hz
[Info] [VaapiRgbPacketProcessor] avg. time: 4.5117ms -> ~221.646Hz
[Debug] [DepthPacketStreamParser] not all subsequences received 991
[Info] [DepthPacketStreamParser] 1 packets were lost
[Info] [OpenGLDepthPacketProcessor] avg. time: 7.00382ms -> ~142.779Hz
[Info] [VaapiRgbPacketProcessor] avg. time: 4.54288ms -> ~220.125Hz
[Info] [OpenGLDepthPacketProcessor] avg. time: 7.04759ms -> ~141.892Hz
[Info] [VaapiRgbPacketProcessor] avg. time: 4.4388ms -> ~225.286Hz
[Debug] [DepthPacketStreamParser] not all subsequences received 959
[Info] [DepthPacketStreamParser] 1 packets were lost
[Info] [Freenect2DeviceImpl] stopping...
[Info] [Freenect2DeviceImpl] canceling rgb transfers...
[Info] [OpenGLDepthPacketProcessor] avg. time: 7.02522ms -> ~142.344Hz
[Info] [Freenect2DeviceImpl] canceling depth transfers...
[Info] [Freenect2DeviceImpl] stopped
[Info] [Freenect2DeviceImpl] closing...
[Info] [Freenect2DeviceImpl] releasing usb interfaces...
[Info] [Freenect2DeviceImpl] deallocating usb transfer pools...
[Info] [Freenect2DeviceImpl] closing usb device...
[Info] [Freenect2DeviceImpl] closed
[Info] [Freenect2DeviceImpl] closing...
[Info] [Freenect2DeviceImpl] already closed, doing nothing

 

디버그 모드로 하니 몇 줄 더 나오긴 한데.. 별 차이가 없어 보인다

$ LIBUSB_DEBUG=3 ./Protonect 
Version: 0.2.0
Environment variables: LOGFILE=<protonect.log>
Usage: ./Protonect [-gpu=<id>] [gl | cl | clkde | cuda | cudakde | cpu] [<device serial>]
        [-noviewer] [-norgb | -nodepth] [-help] [-version]
        [-frames <number of frames to process>]
To pause and unpause: pkill -USR1 Protonect
libusb: warning [libusb_init] installing new context as implicit default
[Info] [Freenect2Impl] enumerating devices...
[Info] [Freenect2Impl] 8 usb devices connected
[Info] [Freenect2Impl] found valid Kinect v2 @2:6 with serial 501441643042
[Info] [Freenect2Impl] found 1 devices
libva info: VA-API version 1.14.0
libva info: Trying to open /usr/lib/x86_64-linux-gnu/dri/iHD_drv_video.so
libva info: Found init function __vaDriverInit_1_14
libva info: va_openDriver() returns 0
[Info] [VaapiRgbPacketProcessorImpl] driver: Intel iHD driver for Intel(R) Gen Graphics - 22.3.1 ()
[Info] [Freenect2DeviceImpl] opening...
[Info] [Freenect2DeviceImpl] transfer pool sizes rgb: 20*16384 ir: 60*8*33792
[Info] [Freenect2DeviceImpl] opened
[Info] [Freenect2DeviceImpl] starting...
libusb: error [udev_hotplug_event] ignoring udev action change
libusb: error [udev_hotplug_event] ignoring udev action change
[Debug] [Freenect2DeviceImpl] status 0x090000: 1024
[Debug] [Freenect2DeviceImpl] status 0x090000: 9729
[Debug] [Freenect2DeviceImpl] status 0x090000: 9731
[Info] [Freenect2DeviceImpl] submitting rgb transfers...
[Info] [Freenect2DeviceImpl] submitting depth transfers...
[Debug] [DepthPacketStreamParser] not all subsequences received 0
[Info] [Freenect2DeviceImpl] started
device serial: 501441643042
device firmware: 4.0.3911.0
[Debug] [DepthPacketStreamParser] not all subsequences received 896
[Info] [OpenGLDepthPacketProcessor] avg. time: 7.5057ms -> ~133.232Hz
[Info] [VaapiRgbPacketProcessor] avg. time: 4.58964ms -> ~217.882Hz
[Debug] [DepthPacketStreamParser] not all subsequences received 511

 

$ lsusb -t -v
/:  Bus 02.Port 1: Dev 1, Class=root_hub, Driver=xhci_hcd/6p, 10000M
    ID 1d6b:0003 Linux Foundation 3.0 root hub
    |__ Port 3: Dev 5, If 0, Class=Hub, Driver=hub/1p, 5000M
        ID 045e:02d9 Microsoft Corp. 
        |__ Port 1: Dev 6, If 0, Class=Vendor Specific Class, Driver=, 5000M
            ID 045e:02d8 Microsoft Corp. 
        |__ Port 1: Dev 6, If 1, Class=Vendor Specific Class, Driver=, 5000M
            ID 045e:02d8 Microsoft Corp. 
        |__ Port 1: Dev 6, If 2, Class=Audio, Driver=snd-usb-audio, 5000M
            ID 045e:02d8 Microsoft Corp. 
        |__ Port 1: Dev 6, If 3, Class=Audio, Driver=snd-usb-audio, 5000M
            ID 045e:02d8 Microsoft Corp. 
/:  Bus 01.Port 1: Dev 1, Class=root_hub, Driver=xhci_hcd/12p, 480M
    ID 1d6b:0002 Linux Foundation 2.0 root hub
    |__ Port 3: Dev 6, If 0, Class=Hub, Driver=hub/1p, 480M
        ID 045e:02d9 Microsoft Corp. 
    |__ Port 5: Dev 2, If 0, Class=Vendor Specific Class, Driver=, 12M
        ID 04e8:730b Samsung Electronics Co., Ltd 
    |__ Port 6: Dev 3, If 0, Class=Video, Driver=uvcvideo, 480M
        ID 2b7e:0134  
    |__ Port 6: Dev 3, If 1, Class=Video, Driver=uvcvideo, 480M
        ID 2b7e:0134  
    |__ Port 10: Dev 4, If 0, Class=Wireless, Driver=btusb, 12M
        ID 8087:0026 Intel Corp. AX201 Bluetooth
    |__ Port 10: Dev 4, If 1, Class=Wireless, Driver=btusb, 12M
        ID 8087:0026 Intel Corp. AX201 Bluetooth

 

 

+

2024.07.18

빌드 타임 추가 (노트북)

8쓰레드 4쓰레드 2쓰레드 1쓰레드
real 0m6.974s
user 0m27.675s
sys 0m2.416s		 real 0m7.923s
user 0m19.886s
sys 0m1.687s		 real 0m11.978s
user 0m19.263s
sys 0m1.688s		 real 0m17.982s
user 0m16.453s
sys 0m1.503s

 

+

2024.07.20

빌드 타임 추가 (데스크 탑 / i7-3770)

8쓰레드 4쓰레드 2쓰레드 1쓰레드
real 0m4.899s
user 0m22.435s
sys 0m2.366s		 real 0m5.263s
user 0m14.712s
sys 0m1.612s		 real 0m8.456s
user 0m13.561s
sys 0m1.707s		 real 0m15.343s
user 0m13.623s
sys 0m1.707s

 

 

저작자표시

'프로그램 사용 > kinect' 카테고리의 다른 글

libfreenect2 on 2760p 성공  (0) 2024.08.18
libfreenect2 성공  (0) 2024.07.17
libfreenect2 실행 실패  (0) 2024.07.14
libfreenect2 CUDA 끄고 빌드 성공  (0) 2024.07.13
kinect v2 / freenect 실패  (0) 2024.07.09
Posted by 구차니

티스토리툴바