LoraGW and LoRaClient esp32 TTON

https://github.com/kersing/LoRaWAN-Tracker-workshop   https://github.com/kersing/ESP-1ch-Gateway-v5.0 Getting Home Assistant, Mosquitto MQTT, and CloudMQTT To Work Together Using an MQTT Bridge https://home-assistant.io/blog/2017/11/10/ttn-with-mqtt/    

CLI import CSV into suiteCRM

convert from windows-1250 to UTF8 iconv -f WINDOWS-1250 -t UTF-8 customer.csv > customer.u.csv inspired by this web http://www.jsmackin.co.uk/suitecrm/large-imports-in-suitecrm/ LOAD DATA INFILE '/tmp/customer.u.csv' INTO TABLE contacts FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' (id,description,department,first_name,last_name,primary_address_street,primary_address_city,primary_address_postalcode,phone_home,phone_work,phone_other,phone_fax,phone_mobile,description,alt_address_street,alt_address_street,salutation,alt_address_street,title,primary_address_country,primary_address_state); REBUILD INDEX DB ALTER TABLE contacts DROP KEY idx_cont_last_first; ALTER TABLE contacts DROP KEY idx_contacts_del_last; ALTER TABLE contacts … Číst dál

upgrade openwrt and build own image zabbix

download OpenWrt-ImageBuilder untar and jump into directory make image PROFILE=TLWA901 PACKAGES="-wpad-mini wpad luci zabbix-extra-mac80211 zabbix-extra-network zabbix-extra-wifi" copy image into old running AP scp ./bin/ar71xx/openwrt-15.05.1-ar71xx-generic-tl-wa901nd-v2-squashfs-fact ory.bin root@192.168.1.23:/tmp/ ssh into AP ssh root@[ip] cd /tmp sysupgrade -b backup.tar.gz # backup old config sysupgrade -f ./backup.tar.gz ./openwrt-15.05.1-ar71xx -generic-tl-wa901nd-v2-squashfs-factory.bin # install new image and restore old config configure zabbix echo … Číst dál