Nishadh KA

Raspberry pi errors

2014-01-08


  1. with GSM data card and serial to USB connected to the USB hub, after connecting GSM data card, a few minutes after the ssh is getting disconnected
  2. After dismantling the RPi with RTC, clock time become erroneous, so it was reconnected with lots of reboots and set the time manually using the command

    sudo hwclock --set --date "01/16/2014 08:33:01"
    
  3. to set the computer time using https://wiki.debian.org/DateTime#Set_the_time_manually

    date --set 1998-11-02 
    date --set 21:08:00
    
  4. Now RPI is connected with data card, without connecting serial to USB wire, now the RPi is working without a problem.

  5. Data card is checked with SMS also, so now connecting the serial USB to RPi, by connecting the USB serial second to a data card, not showing any problem.

  6. create sqlite database by

    sudo apt-get install sqlite3 libsqlite3-dev
    sqlite3 mydatabase.db
    CREATE TABLE data3 (SNo  INTEGER PRIMARY KEY, data VARCHAR(100));