MS SQL for Beaglebone black Debian 


sudo apt-get --assume-yes update


























sudo apt-get --assume-yes install freetds-dev freetds-bin



it would take some time on processing triggers for man-db ...






















































sudo apt-get --assume-yes install python-dev python-pip














sudo pip install pymssql



gcc take some times...be patient....













imported with no error









when using MSSQL account I got error:











Traceback (most recent call last):

  File "<stdin>", line 1, in <module>

  File "pymssql.pyx", line 641, in pymssql.connect (pymssql.c:10788)

pymssql.OperationalError: (40615, "Cannot open server 'tiked' requested by the login. Client                                        with IP address '123.50.61.133' is not allowed to access the server.  To enable access, use                                        the Windows Azure Management Portal or run sp_set_firewall_rule on the master database to c                                       reate a firewall rule for this IP address or address range.  It may take up to five minutes                                        for this change to take effect.DB-Lib error message 40615, severity 14:\nGeneral SQL Server                                        error: Check messages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAdaptive                                        Server connection failed\n")







So, there are firewall work to to....



So, logging into Azure, and search setting, the IP record is already there, press add to allow access, and still need to press save for active the IP.













then run again, this time no error message
































































留言











張貼留言






























這個網誌中的熱門文章









Heltec ESP32+OLED+Lora, hardware testing




















圖片







   you can easily find some good boards from china, but most of them lack of accurate document...  Hrere is an example;   https://hackaday.io/project/26991-esp32-board-wifi-lora-32   the board looks good with lora and a 128x64 OLED, but the IIC and reset connection is important, since pin can be muxing easily, so every board could be different.   pinMode(16,OUTPUT);   digitalWrite(16, LOW); // set GPIO16 low to reset OLED   delay(50);   digitalWrite(16, HIGH); // while OLED is running, must set GPIO16 to high    and, if needed, edit your Wire.begin() to Wire.begin(4,15); (4 = SDA 15 SCL)    i tested it with the Adafruit SSD1306 and the Acrobotics SSD1306 Librarys   both work.    Display size is 128x64        There are discussions on these boards on TＴＮ as a LORA node..or maybee single ch gateway?   Heltec has a git :  https://github.com/Heltec-Aaron-Lee   And there is another copy call TTGO  https://de.aliexpress.com/item/TTGO-LORA32-868-915-Mhz-SX1276-ESP32-Oled-display-Bluetooth-WIFI








閱讀完整內容










micro SD card for ESP32, on lolin32 with OLED and heltec 32 lora oled




















圖片







I have purchased 2 micro SD card holder for my esp project.     First I would like to test with heltec esp32 lora oled module.  this module uses:  sck=05  MISO=19  MOSI=27  SS(lora)=18, then I assigned 21 for sd SS   and there is a lib in esp32-arduino, which use SS default at 5   I took the example and use SD.begin(21), but I alway get the error:  entry 0x40078a9c  Card Mount Failed   But I do saw once that it read out the sd card type and volume.    Not sure it's the issue of lora sd card swithing, or it just can't work.   The other esp32 card I have is an wemos esp32 oled, it did not leave me too much pins, I need to find out how to connect sd to it.   But I have wemos D1 mini esp8266 on hand, and connect it as:    * The WeMos Micro SD Shield uses:    * D5, D6, D7, D8, 3V3 and G    *    * The shield uses SPI bus pins:    * D5 = CLK    * D6 = MISO    * D7 = MOSI    * D8 = CS     It's not working with the example in the arduino IDE 1.8.5, which marked SD(esp8266), but it w








閱讀完整內容










Install Network Time Protocol(NTP) on BeagleBone with Angstrom linux and set local time zone





















 Referenced from : http://cwraig.id.au/?p=513   1. Update your Package List   opkg update   2. Get the ntp Package   opkg install ntp ntpdate   Update 2014/07/03  for the latest beaglebone image(2013-06-20) with kernel 3.8.12, after this installation,   system will add to service list, so only need to change time zone   3. Now we need to stop the ntpd service so we can request a manual update   /etc/init.d/ntpd stop   manual update   ntpdate pool.ntp.org   type in date, you should see the date is changing to current date and time, but the time zone is not corrected.   The time zone info is contained in /etc/localtime , use this to remove it:  rm /etc/localtime   before link up our time zone, look into /usr/share/zoneinfo folder for your timezone.   I did not find taiwan in asia, not plan to use hong_kong, but there is still:  /usr/share/zoneinfo/Etc/GMT-8   now we make the link with ln command  ln -s /usr/share/zoneinfo/Etc/GMT-8 /etc/localtime   now type date again to check, should ha








閱讀完整內容