Raspberry pi errors
2014-01-08
- 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
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"
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
Now RPI is connected with data card, without connecting serial to USB wire, now the RPi is working without a problem.
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.
create sqlite database by
sudo apt-get install sqlite3 libsqlite3-dev sqlite3 mydatabase.db CREATE TABLE data3 (SNo INTEGER PRIMARY KEY, data VARCHAR(100));