Filter
Top Products
Chapter 5. Setting up a SMS Gateway
MySQL connection configuration
For several reasons external storage may be required to handle dynamical issues, i.e. DLRs, sms-service,
sendsms-user, ota-setting, ota-bookmark definitions and so on. To define a MySQL database connection
you simple need to specify a mysql-connection group as follows:
Table 5-12. MySQL Connection Group Variables
Variable Value Description
group mysql-connection This is a mandatory variable
id (m) string
An optional name or id to
identify this MySQL connection
for internal reference with other
MySQL related configuration
groups. Any string is acceptable,
but semicolon ’;’ may cause
problems, so avoid it and any
other special non-alphabet
characters.
host (m) hostname or IP
Hostname or IP of a server
running a MySQL database to
connect to.
mysql-username (m) username
User name for connecting to
MySQL database.
mysql-password (m) password
Password for connecting to
MySQL database.
database (m) string
Name of database in MySQL
database server to connect to.
A sample ’mysql-connection’ group:
group = mysql-connection
id = dlr-db
host = localhost
mysql-username = foo
mysql-password = bar
database = dlr
In case you use different MySQL connections for several storage issues, i.e. one for DLR and another
different one for sms-service you may use the include configuration statement to extract the MySQL
related configuration groups to a seperate mysql.conf file.
Over-The-Air configurations
To enable Over-The-Air configuration of phones or other client devices that support the protocol you
need to configure a sendsms-user.ota-setting group is not necessary, you can send settings to the
72