Hello,
I saw that the sending SMSC can be stored in the access-log.
I made several tests with the custom access-log-format: But the problem is that I don't get a unique ID in the access-log for every message.
access-log-format= " TS="%t" SMS-ID="%F" ID2="%x" USER="%n" TYPE="%l" SMSC="%i" TO="%P" TEXT="%b"
Neither "%t" nor "%F" give me a unique ID :(
I still need one place where every message is stored with all necessary informations.
Conclusion:
In sent_sms table of SQLBOX is no SMSC_ID (Only the virtual SMSC_ID used for routing purposes, which is not useful for accounting/billing purposes).
In access-log there is no unique ID for every message.
How can I archieve my goal, so that all necessary informations will be stored in one place ?
How do you account the costs for sending messages through different SMSC's ?
Thank you in advance,
Florian
Gesendet: Montag, 05. August 2013 um 16:03 Uhr
Von: "hans joachim" <[email protected]>
An: "[email protected]" <[email protected]>
Betreff: SMS Accounting
Von: "hans joachim" <[email protected]>
An: "[email protected]" <[email protected]>
Betreff: SMS Accounting
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
