Gammu: Configuring SMSD in OSX using MySQL Database

gammu-configure-mysql.md

Configuring Gammu in OSX with MySQL

Requirements:

• Install Gammu
• Install MySQL v5.5 (not working with 5.6 >)
• Install wget

Step by step:

• Check the sql files in here

$ cd /usr/share/doc/gammu/examples/sql

or from https://github.com/gammu/gammu/blob/master/docs/sql/mysql.sql

• runs below commands:

$ wget https://raw.githubusercontent.com/gammu/gammu/master/docs/sql/mysql.sql
$ mysql -u root -p
mysql> create database gammu;
ok
mysql>quit

Create User for Gammu

$ mysql -u root -p
mysql> CREATE USER 'gammu'@'localhost' IDENTIFIED BY 'gammu';
mysql> CREATE USER 'gammu'@'%' IDENTIFIED BY 'gammu';
mysql> GRANT ALL PRIVILEGES ON gammu.* TO 'gammu'@'localhost' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON gammu.* TO 'gammu'@'%' WITH GRANT OPTION;
mysql> flush privileges;
mysql> quit;

Import from MySQL

$ mysql -u root -p gammu < mysql.sql
mysql> show tables;

• Configure SMSDRC

$ sudo touch /etc/gammu-smsdrc
$ sudo nano /etc/gammu-smsdrc

—
# /etc/gammu-smsdrc

port = /dev/(your_device)
connection = (your_connection)
startinfo = yes
# Debugging
logformat = textall
# SMSD configuration, see gammu-smsdrc(5)
[smsd]
service = mysql
driver = native_mysql
deliveryreport = sms
logfile = /var/log/gammu/smsd.log
debuglevel = 255
pin = 1234
user = root #your mysql user
password = 123456789 #your mysql password
pc = localhost #Server Mysql
database = gammu #DB name
phoneid = modem_1
-

Running Gammu Daemon

Run gammu-smsd with this command on your terminal : (it will runs the daemon with config from /etc/gammu-smsdrc)

$ sudo gammu-smsd

or for specific configuration file

$ gammu-smsd -c ~/.gammu-smsdrc