Ошибка error binding sensor connection

Что не так ?

@bot.message_handler(commands=['start'])
def start(message):
    sql = sqlite3.connect('C:\Program1\bot.telegram\bazdan.db3')
    c = sql.cursor()
    c.execute("""CREATE TABLE IF NOT EXISTS user (id INTEGER, name TEXT, race, inventory)""")
    sql.commit()
    sql.close

@bot.message_handler(content_types=['text'])
def history_now(message):
    if message.chat.type == 'private':
        user_id=[message.chat.id]
        c.execute(f"SELECT race FROM user WHERE id == ?",(user_id))
        data=c.fetchone()
        if data is not None:
            name=message.text
            c.execute(f"UPDATE user SET name =? WHERE id=?", (name, user_id))
            sql.commit()
            sql.close
            confirm_name=(f'Имя {name} записано')
            bot.send_message(message.chat.id, confirm_name, parse_mode='html')

вот сама ошибка
c.execute(f»UPDATE user SET name =? WHERE id=?», (name, user_id))
sqlite3.InterfaceError: Error binding parameter 1 — probably unsupported type.

Error binding sensor connection trinus vr

Новые темы необходимо создавать только в корневом разделе! В дальнейшем они будут обработаны модераторами.

Если Вы выложили новую версию программы, пожалуйста, сообщите об этом модератору нажав на вашем сообщении кнопку «Жалоба».

Последнее обновление программы в шапке: 18.05.2020

Краткое описание:
Отслеживание движений головы по 3(минимум 2) датчикам телефона + транслирование изображения на экран телефона. Почти полная эмуляция Oculus Rift.

Описание с официального сайта:
* Обратите внимание, приложение не достигло своего полного потенциала. Я постоянно работаю над улучшением производительности и исправлением ошибок. Пожалуйста, будьте терпеливы и готовы играть с различными настройками и сообщайте о проблемах на форуме.
Trinus Gyre транслирует потоковое видео в ваше Android устройство, и отслеживание положения головы в компьютер. Благодаря этому вы можете играть в свои любимые компьютерные игры погружаясь в Виртуальную Реальность максимальным образом.
К вашему Android устройству необходимо иметь гарнитуру виртуальной реальности, например Google Cardboard (или любую другую доступную в настоящее время). Вы можете наслаждаться опытом виртуальной реальности, аналогичную специализированным системам, только значительно дешевле.
Эта версия имеет ограничение по времени работы 10 минут за один раз (вы можете запустить его столько раз, сколько пожелаете). Только чтобы убедиться, что он будет работать с компьютером, вашим Android устройством и любимыми играми. Я очень рекомендую скачать бесплатно тестовую версию прежде чем вы будете рассматривать покупку полной версии, так как Trinus Gyre может не работать с вашей конфигурацией оборудования.
Инструкция по использованию, а также сервер приложений для скачивания можно найти на http://oddsheepgames.com/trinus
Пожалуйста, свяжитесь со мной или посетите форум (http://oddsheepgames.com/?page_id=208), если у вас возникли проблемы с приложением.
Как использовать Trinus Gyre? Присоединяйтесь к нам на Facebook! https://www.facebook.com/trinusgyre
Особенности:
— Беспроводная трансляция видео, которая дарит полную свободу вращения. Или .
— USB потоковая трансляция видео, для повышения производительности
— Данные датчиков передают повороты на ваше устройство. В настоящее время поддерживается эмуляция Мыши, FreeTrack/TrackIR протокол VR или использование внешних средств (opentrack или FreePie)
— Поддельный 3D (для игр, не поддерживающих режим полноценного 3D)
— Коррекция искажений под линзы конкретной VR гарнитуры
— Возможность подключения прямого подключения WiFi (маршрутизатор не требуется). Обратите внимание, что эта опция будет работать не на всех системах. Используйте маршрутизатор, если возникли проблемы с прямым подключением WiFi.
— Ограничение 10 минут за сеанс (платная версия без ограничений)
Требования:
— Компьютер с OS Windows (последней редакции рекомендуется)
— Google Cardboard или аналогичная VR гарнитура (есть много хороших качественных гарнитур, доступных в Интернете)
— Сервер приложений, который можно загрузить отсюда: http://trinusvr.com/download-2/

Требуется Android: 4.0 или выше
Русский интерфейс: Да

Источник

Trinus Virtual Reality

Affordable VR

Connecting… And nothing happened.

• This topic has 3 replies, 3 voices, and was last updated 6 years, 2 months ago by ohgrant .

So i was using trinus vr for a long time now, i’ve recently got my new phone, from ios to android. I started trinus vr on pc and phone, it was working fine, but the screen showing on phone is a little bit small, a big black space is there, i started to find how to change the settings, i played outlast, it was working fine until aometime it crashed. Now i can’t stream anything to my phone. I uninstalled both apps on phone and pc and restarted both. Nothing seem to fix it. When i connect to trinus server, nothing happens and when i turn onn and off and on some error appears and it says,

Error error binding sensor connection
(192.168.43.1.7777) try a different port
Java.net.bindexception:bind failed: eaddrinuse(address already in use)

P.s. I also tried using other port like 4567 still nothing seem to happen.

did you change the port on both Trinus PC and Trinus phone?

Yep i did, but nothing still to have happened.

And also both of them have connected to trinus server, same ip and port.

• This reply was modified 6 years, 3 months ago by TheDarkBright .

Hi, I don’t know if it will help, but I had issues getting it to connect to the server too. In my case I went to advanced mode and set the IP exactly the same as the phone. Still didn’t connect using the connect power button in the advanced mode. I tried several times just getting error messages. I switched to basic mode and clicked the connect power button there, error at first “couldn’t connect using default method, switching to fast” then it connected to the server. Hope that helps.

Источник

Trinus Virtual Reality

Affordable VR

Update 1.5 issues

• This topic has 19 replies, 5 voices, and was last updated 8 years, 3 months ago by loxai .

I don’t know if we need another post regarding updates to trinus gyre but for now I found this the only format to indicates every bug I found in new version.

So,
The older version worked FLAWLESSY for me, NOT even single disconnection error.
New version I am getting errors with immediately or several minutes after start gaming (both wi if and USB – USB works only if auto detection is off, WiFi works only when auto detection is ON)

The new version has much lower latency – I can use head movement for aiming!

I will give detailed error rapport later!
PS. I this kind of post (updated focused) is not needed just delete it – I will make separate posts under USB and Wifi troubleshooting.

I’ve got such error while playing Skyrim. Trinus stops streaming and server application says: “Error capturing frame: the collection was modified after creating instanse of enum” (something like that – I’ve tranclated error description because it is shown in russian for me. Originally “Error capturing frame Коллекция была изменена после создания экземпляра перечислителя”)
Any help?

P.s. Happen while Usb-tethering mode using vireio perseption and freepie redirect to disable tracking

The same error happened for Grid Autosport in Face3D mode. Definitly this error was brought by version 1.5

• This reply was modified 8 years, 3 months ago by Nazar .
• This reply was modified 8 years, 3 months ago by loxai .

I guess I broke something, sorry :S I will try to fix it asap. If you manage to get it working with some other configuration, let me know, as it might help me find the bug.

This might be related to the same bug Nazar just posted. I’m really sorry about it, I’ll try to fix it asap.

Ok guys, I think I found the reason… a silly coding mistake. Nazar’s error detail tipped me on the potential culprit. Should be good now, just download the server from the usual location and give it a shot… I’ll be waiting 🙂

a side note on the USB autodetect issue you mention, @thief. It might be the fact that initial connection through USB can take a good amount of time (this is a networking setup thing, not TG). You can check this if you keep running ipconfig repeatedly after USB tether has been established: you will see a network without gateway, keep doing ipconfig until it is assigned. By then the TG connection will have been already established if it was already started and waiting…
if this is not the case for the issue you mention, please let me know in which way is autodetect not working with USB, and if you are using any external tool for (reverse?) tethering.

Played Skyrim for a couple of minutes – issue seems to be fixed. Thanks for quick response)

Источник

Trinus Virtual Reality

Affordable VR

error delivering sensor data

• This topic has 12 replies, 5 voices, and was last updated 8 years, 3 months ago by loxai .

after the setup i go to run a game and when i hit ok is instantly stops and gives me a
error delivering sensor data sendto failed:
ECONNRESET (connection reset by peer)(/192.168.42.156)

it sounds like its on my end i just dont know how to fix it. i added an exception in my antivirus so that doesnt interfere. any ideas?

not certain why this is happening, I will do some code improvements to get more detailed info on failure reasons.

Hi, I’m getting the same error. First I get an error message saying “Error initializing sensor server Unable to resolve host “PCName/192.168.178.10″: No address associated with hostname”

After this error message on the Trinus Gyre Server, the game selection window pops up. After I select a game I get this error message: “Error delivering sensor data sendto failed: ECONNRESET (Connection reset by peer)(/192.168.42.140)

With Trinus Gyre v1.0 it worked like a charm.

Did it stop working after version 1.1 or you skipped directly to 1.2? What connection type are you using? I need more details to get an idea of the problem, please let me know more and I will try to have it fixed for next update. Sorry for the inconvenience.

On 1.1 I only used USB tethering, so I can’t tell. I selected “Router Wifi” on the Trinus server.

I also checked my Wifi router settings. I have a Wifi Router as an access point behind my DSL modem/router. DHCP is turned off on the Wifi router. If I enable DHCP on my Wifi Router, the first error message isn’t showing. After I select a game I get this error: “Error initializing sensor server Unable to resolve host “192.168.178.10/192.168.178.10″: No address associated with hostname”

If I disable DHCP again, because my DSL Router assigns the ip adresses I get this error: Error delivering sensor data sendto failed: ECONNRESET (Connection reset by peer)(null)

I also noticed I can’t stop the app after these errors. If I tap the top it says “stop” but nothing happens.

Sadly USB tethering isn’t working well on my system. I have a lot of sudden fps drops contrary to the Wifi connection in 1.0 . I don’t know why USB tethering behaves like this, because I have an i7 4770k and a R9 280x in my PC and a Nexus 5.

Last Trinus version killed tracking for me at all. Behavior is very strange:
after connection for a few seconds I cannot move mouse coursor even with my mouse(sensor type “Mouse”). Then my mouse starts working, but there is no tracking at all. Not the server neither the phone app tells any errors, video is streamed nicely, but no tracking

I’ve tried mouse, trackIR, freeTrack, freePie Redirect sensor type – nothing works as it did in previous versions

Connection type also doesn’t effect tracking – I’m using both router and usb connection. That’s really disappointing

I understand. I will work on fixing this. Apologies for the inconvenience

Maybe it is availabe to organize some kind of loggin. I’m also a developer – I know of what a good help it could be

Reinstalling application solved the issue. My problem was caused by teathering. Trinus Gyre usb teather doesn’t work for me. So I’ve found a way to set lan with the phone. Those settings worked with previous version of Gyre (I could choose the ip of the phone), but doesn’t work with 1.2
As I can say that setting affects android application – when teathering is enabled my way, I cannot change ip address in the phone app (the field is disabled).
This terminal emulator command causes such behavior:
ifconfig usb0 192.168.137.2 netmask 255.255.255.0

Maybe, it can be of some help
Thanks for the feedback

Same problem here. I get it when trying to run Half-Life 2. I am using USB tethering, which works fine with my N64 Emulator, but when I try to run HL2, I get this error message. My message says, “Connection reset by peer (/192.168.42.99)”

Any progress on this issue? It’s strange that it only happens when trying to run certain games, such as HL2.

Ok… it’s working for me now (but still with some other issues). I think the problem may be that the game has to be windowed and behind the server window… The game cannot be minimized when you select it from the drop down menu. I’m not sure if it’s that simple for everyone, but that fixed the issue for me.

you can switch between apps with alt-enter, so that you don’t have to minimise the game

Источник

Help & Troubleshooting

Requirements

Installation

Connection

SteamVR has started and will switch to Ready once client is connected

Setup

These are the basic steps to get started with Trinus. Once you are familiar with how Trinus works you can explore all its features to get the most out of your VR experience. If there’s any problem, please check the Common Problems section below.

• Run SteamVR Room Setup (from the SteamVR status window)
  • Select Standing Only
  • Click Next (Establish tracking page)
  • Click Calibrate Center and then Next
  • Input the height for your sitting or standing position (choose whichever you are most frequently be using, you can still tweak it afterwards via Trinus Height option). The actual headset current location/height is only relevant for 6dof capable devices (like the Lenovo Mirage Solo). Click Calibrate Floor and then Next
  • You are done! You can do this Setup anytime if you want to re-calibrate
• For your initial setup, the Trinus default settings should be fine but.
  • If necessary, adjust the Trinus performance (Resolution and Quality) settings so that they match your setup capabilities
  • To get the most of your Trinus experience review the options, using the contextual help shown on the right side
• Once you have the system working smoothly you can start with some free VR experiences, like The Lab or The Night Cafe. Note that, when SteamVR loads, you might just get a simple white/grey room with lines, and you can’t do much from there. You can either start a SteamVR game from the traditional 2D Steam UI or enable SteamVR Home from SteamVR settings
• Use the Controller tab to load a suitable game profile. Default profiles as well as a few game specific profiles are included with Trinus, but you can create (and share!) your own. More details in the Controller Profiles section below

Default Single Controller Button Mapping

Default Dual Controller Button Mapping (for each physical controller)

Common Problems

Doesn’t connect, stays on Waiting for connection or black screen

This could be for a number of reasons, mainly networking problems. Make sure PC and Android are on the same network (connected to same router) and there are no firewalls blocking communication (Trinus uses port 18086)

It is normal to sometimes get a black screen for a moment during connect/disconnect. Just give it a few seconds

For USB Tethering, a generic Windows USB driver is used but your device may require specific driver provided by the manufacturer

Stop Trinus PC/SteamVR, make sure there are no VR related processes (eg. VR Server) and try again. Restart Trinus Android if it still fails to connect

Image freezes / low framerate / compression artifacts

If image freezes try exiting Trinus Android app by pressing the home (O) button and then opening Trinus VR again

If your router is not a fast Wifi AC one, try connecting via USB. A home router may work well for internet streaming and gaming but still underperform for VR streaming. Distance to router can also be a deciding factor, it is recommended to have PC, headset and router in the same room (and PC is plugged through Ethernet cable)

Another wireless alternative is to use a PC or phone created Wifi hotspot to connect both sides

Still, USB is the fastest option. While the default USB driver installed with Windows should work fine for most hardware, it may not be optimised for your specific phone model, check your manufacturer’s support information and drivers

Lower the Trinus Resolution and Quality settings. You can also disable 3D depth option

Check Daydream controller battery

No Audio / No control of the game

Put the game window on the foreground (active window)

Note that audio is not streamed to the phone, so you’ll need to connect your headphones to the PC

Unusual height

Adjust the height in Trinus. Alternatively, re-run SteamVR Room Setup.

Steam VR Error 108 or 301

Check that your Intel Integrated Graphics card is enabled and shown in Device Manager. If it is not, you may need to activate it via BIOS settings (usually something like IGPU Enable/Disable, Multimonitor setup, . ). The Intel GPU is needed for Trinus streaming purposes, while the more powerful discrete graphics card is used for the game rendering

Make sure the Intel Graphics Card is enabled and visible from Device Manager, it is needed for encoding the 3D rendered by the discrete GPU

If enabling the Intel Graphics Card doesn’t solve the issue, stop SteamVR and Trinus VR. Make sure there’s no VR Server process running (either kill it via Task manager or restart PC)

Un-install and Re-install Trinus SteamVR driver (check the Trinus notifications for any errors)

Steam VR Error 306

Stop Steam VR and Trinus VR. Make sure there’s no VR Server process running (either kill it via Task manager or restart PC)

Just like with playing any other Daydream experience, your Android device may eventually overheat (specially older devices, like the Google Pixel). Do breaks more frequently or, if you are an advanced user, try some DIY cooling solution or underclocking the phone

Unresponsive mapped controls

Pressing the edges still requires touching the touchpad. Make sure you are not pressing on the outer rim of the touchpad.

Other problems / The above didn’t help

Please use the forum here to report issues

Supported Games

Here’s the list of games you can play with Trinus and gamepad or keyboard+mouse. You can also play SteamVR games that require VR controllers, but this has some limitations at the moment (working to improve that!). Trinus duplicates the (single) Daydream controller to have two SteamVR controllers. The second virtual controller will mimic the movements of the main one, and you can map buttons for both virtual controllers into the Daydream controller (along with some extra VR actions like crouch or move sideways). See the Controller Profiles section for more details on those custom mappings.

If you want to play non-VR games, you can do that too with Trinus. But this feature is currently in non working state (coming soon. ish). Note that Async Reprojection needs to be disabled beforehand, using the Trinus Android Config app.

Also, if you like retro gaming, you can try Dolphin VR (an emulator for GameCube and Wii games) or 3DNes (an emulator for NES). Keep in mind you should own the games you emulate.

VR Controllers

The Daydream kit includes a single controller, which Trinus will duplicate to have to virtual controllers.

Trinus also supports connecting a second Daydream compatible controller to have two separate virtual controllers. Here are the steps to do so:

• Go to Android Bluetooth Settings
• Press the Home (O) button on the second controller and do a Bluetooth scan
• The Daydream controller will appear on the list, just tap it to pair. You should now have two Daydream controllers listed
• Start Daydream and activate the main controller as usual
• Start a Trinus session
• Once SteamVR is showing, press the Home (O) button on the second controller to activate it, then press again and hold it for 5 seconds
• Second controller will now be active. Pressing the Home button at anytime will reset its orientation

You can search online for Daydream compatible controllers. Purchase options:

[Have a suggested link? Post in the forum]

Controller Profiles

Trinus can map two virtual controllers actions to a single Daydream physical controller, one being the Main controller (right hand) and the other the Secondary controller (left hand). Both will have the same movement but handle buttons separately. You can, for example, assign Main and Secondary triggers to the left and right edges of the touchpad, for a dual wielding guns game, being able to shoot both weapons with a single physical controller. Or you could map the touchpad center to activate both triggers. Moreover, Trinus has custom mappings for actions like crouching or running (second controller inverts movement of main to simulate swinging arms).

Before exploring controller customisation, you can select any of the Default (or game specific) profiles to get started and later tweak to your preference, once you are familiar with the system. Press the Cheat Sheet button (when available) to see detailed information on the profile mappings.

When you create a new profile, current profile data is copied so you can tweak the existing one (eg. creating a DefaultMyVersion out of existing Default).

The profile system allows flexible customisation for each of your games. If you create a good profile, please share with others on the forum here.

Источник

I have also problem with bind E1747

I think it default group is 0 and I want to move it to group 1.

Zigbee2MQTT:debug 2021-04-13 21:09:43: Received Zigbee message from 'Motion_3', type 'commandOnWithTimedOff', cluster 'genOnOff', data '{"ctrlbits":0,"offwaittime":0,"ontime":1800}' from endpoint 1 with groupID 0 Zigbee2MQTT:info 2021-04-13 21:09:43: MQTT publish: topic 'zigbee_home_2/Motion_3', payload '{"battery":100,"linkquality":90,"occupancy":true,"requested_brightness_level":76,"requested_brightness_percent":30,"update":{"state":"idle"},"update_available":false}'

When I tries to bind to group

mosquitto_pub -t "zigbee_home_2/bridge/request/device/bind" -h xxx.xx. -p yyyy -m '{"from": "Motion_3", "to": "1"}'

I receive:

Zigbee2MQTT:debug 2021-04-13 21:13:23: Received MQTT message on 'zigbee_home_2/bridge/request/device/bind' with data '{"from": "Motion_3", "to": "1"}' Zigbee2MQTT:debug 2021-04-13 21:13:23: binding cluster 'genOnOff' from 'Motion_3' to '1' Zigbee2MQTT:error 2021-04-13 21:13:43: Failed to bind cluster 'genLevelCtrl' from 'Motion_3' to '1' (Error: Bind 0x847127fffebe9e0d/1 genLevelCtrl from '1' failed (AREQ - ZDO - bindRsp after 10000ms)) Zigbee2MQTT:info 2021-04-13 21:13:43: MQTT publish: topic 'zigbee_home_2/bridge/log', payload '{"message":{"cluster":"genLevelCtrl","from":"Motion_3","to":"1"},"type":"device_bind_failed"}' Zigbee2MQTT:info 2021-04-13 21:13:43: MQTT publish: topic 'zigbee_home_2/bridge/response/device/bind', payload '{"data":{"clusters":[],"failed":["genOnOff","genLevelCtrl"],"from":"Motion_3","to":"1"},"error":"Failed to bind","status":"error"}' Zigbee2MQTT:error 2021-04-13 21:13:43: Failed to bind

Have tried with unbind first from group 0.
Does E1745 need to be in some state? Have tried with both Occupied and Not Occupied

Сообщение об ошибке

Ошибка привязки параметра 1 — вероятно, неподдерживаемый тип

сообщает, что значение в позиции 1^* в последовательности значений, переданных в cursor.execute, является экземпляром типа не поддерживается модулем sqlite3 Python.

Модуль Python sqlite3 поддерживает передачу None, int, float, str, bytes по умолчанию, а также умеет адаптировать datetime.date и datetime.datetime экземпляров.

Чтобы исправить ошибку, преобразуйте значение в указанной позиции в поддерживаемый тип.

Можно имитировать хранение неподдерживаемых типов в базе данных путем регистрации адаптеров и преобразователей для преобразования объектов этого типа в один из поддерживаемых типов и обратно.^**. Это механизм, используемый для обработки date и datetime экземпляры. Представьте, что у нас есть Fruit класс, который мы хотим иметь возможность хранить и извлекать в базе данных.

class Fruit:
    def __init__(self, name):
        self.name = name

    def __repr__(self):
        return f'Fruit({self.name!r})'

Мы создаем функции адаптера и конвертера и регистрируем их в sqlite:

def adapt_fruit(fruit):
    # We must return a supported type.
    return fruit.name

def convert_fruit(value):
    # value will always be bytes.
    return Fruit(value.decode('utf-8'))

sqlite3.register_adapter(Fruit, adapt_fruit)

# The first argument is the type of column that will store "fruits".
sqlite3.register_converter('fruit', convert_fruit)

Мы можем пройти detect_types к соединению и создайте таблицу со столбцом типа fruit:

apple = Fruit('Apple')
banana = Fruit('Banana')

with sqlite3.connect('so12952546.db', detect_types=sqlite3.PARSE_DECLTYPES) as conn:
    cur = conn.cursor()
    cur.execute("""DROP TABLE IF EXISTS tbl""")
    # Create a column with our "fruit" type.
    cur.execute("""CREATE TABLE tbl (name fruit)""")
    # Pass Fruit instances as values.
    cur.executemany("""INSERT INTO tbl (name) VALUES (?)""", [(apple,), (banana,)])
    conn.commit()
    cur.execute("""SELECT name FROM tbl""")
    # Fruit instances are returned.
    for row in cur:
        print(row)

Вывод:

(Fruit('Apple'),)
(Fruit('Banana'),)

Столбец будет иметь тип fruit в Sqlite, но он будет связан с поддерживаемым классом хранилища: text, в таком случае.

sqlite> .schema tbl
CREATE TABLE tbl (name fruit);
sqlite> SELECT name, typeof(name) FROM tbl;
Apple|text
Banana|text

^* Позиция вычисляется с использованием счета с отсчетом от нуля, поэтому первая позиция — это второй ценностное

^** Этот пример не охватывает все параметры — прочтите документацию по модулю для получения подробной информации.