Re: Gnokii-smsd-mysql question

[Paul Darius]

On Sat, Apr 4, 2009 at 2:07 AM, Pawel Kot <address@hidden> wrote:
> And how do you run smsd?
>
To start the daemon, I make a small file call startsmsd.sh that contain the following command :
nohup gnokii-smsd -c 127.0.0.1 -m mysql -d database -u username -p password &

to send sms, I just insert into mysql command :
insert into outbox (number,text) values ('number','message');

The outbox table was modified to ensure delivery report for each messages.
mysql> desc outbox;
+----------------+------------------+------+-----+---------------------+----------------+
| Field          | Type             | Null | Key | Default             | Extra          |
+----------------+------------------+------+-----+---------------------+----------------+
| id             | int(10) unsigned | NO   | PRI | NULL                | auto_increment |
| number         | varchar(20)      | NO   |     |                     |                |
| processed_date | timestamp        | NO   |     | CURRENT_TIMESTAMP   |                |
| insertdate     | timestamp        | NO   |     | 0000-00-00 00:00:00 |                |
| text           | varchar(160)     | YES  |     | NULL                |                |
| phone          | tinyint(4)       | YES  |     | NULL                |                |
| processed      | tinyint(4)       | NO   |     | 0                   |                |
| error          | tinyint(4)       | NO   |     | -1                  |                |
| dreport        | tinyint(4)       | NO   |     | 1                   |                |
| not_before     | time             | NO   |     | 00:00:00            |                |
| not_after      | time             | NO   |     | 23:59:59            |                |
+----------------+------------------+------+-----+---------------------+----------------+
11 rows in set (0.00 sec)

I got the above commands from googling.

Cheers

Paul