Hello,
I have 3 SMSC (gsm1, gsm2, gsm3) in my Kannel-Setup and I'm using sqlbox to save all kind of information about the messages in a database.
My question is how can I store the sending SMSC of every message in the database ?
For example:
If I call the webservice with the argument "&smsc=gsm1" and the message is sent, I see this information in the database entry :
If I call the webservice with the argument "&smsc=gsm1" and the message is sent, I see this information in the database entry :
+---------------------+--------+------+---------+-----------------+---------+---------------+------------+-------------+---------+---------+------+----------+--------+------+--------+----------+----------+----------+----------+---------+------+---------+------+---------+---------+-------+
| date | sql_id | momt | sender | receiver | udhdata | msgdata | time | smsc_id | service | account | id | sms_type | mclass | mwi | coding | compress | validity | deferred | dlr_mask | dlr_url | pid | alt_dcs | rpi | charset | boxc_id | binfo |
+---------------------+--------+------+---------+-----------------+---------+---------------+------------+-------------+---------+---------+------+----------+--------+------+--------+----------+----------+----------+----------+---------+------+---------+------+---------+---------+-------+
| date | sql_id | momt | sender | receiver | udhdata | msgdata | time | smsc_id | service | account | id | sms_type | mclass | mwi | coding | compress | validity | deferred | dlr_mask | dlr_url | pid | alt_dcs | rpi | charset | boxc_id | binfo |
+---------------------+--------+------+---------+-----------------+---------+---------------+------------+-------------+---------+---------+------+----------+--------+------+--------+----------+----------+----------+----------+---------+------+---------+------+---------+---------+-------+
| 2013-08-05 15:43:31 | 10 | MT | xxxxxx | xxxxxxxxxxxxxx | NULL | bla | xxxxxxxxx | gsm1 | user1 | NULL | NULL | 2 | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | smsbox1 | NULL |
But I configured message-routing in a way, which eventually allows me to bypass a SMSC which is not working at this given moment.
Because of this message-routing I can't call the webservice with the argument "&smsc=" ! But if i don't use that argument, the information about the sending SMSC is not stored in the database :(
Once a month, I need to know how many messages were sent through gsm1, gsm2 and gsm3. I'm not able to get this information, if the database field is not getting filled :(
Regards,
Florian
