Hmm fear maybe not a lot of people actually use mysql to store messages... my earlier post, details the problem... however I've now got a question in order to be able to work on the problem unless someone figures it out....
(old message below as well) (using gentoo linux with kannel-cvs with mysql built in) What triggers storing of messages? Is it when you send one? Recieve one? have one on hold? anything in the config file(that I didn't have in there)? or all of them? or none...? any ideas? Any help is greatly appreciated, I've gone so far, just need to be able to store messages properly and my project is more than halfway :p Thanks a lot in advance, Jarl "Jarlco" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Got a strange problem on my hands that I can't seem to figure out... I've > got mysql and would like to store any messages coming in our out in my > database, the database is set up with: > #CREATE TABLE SmsEvent ( > #smsc VARCHAR(255), > #ts VARCHAR(255), > #destination VARCHAR(255), > #service VARCHAR(255), > #url VARCHAR(255), > #mask VARCHAR(255), > #status VARCHAR(255), > #boxc VARCHAR(255), > #source VARCHAR(255), > #PRIMARY KEY(smsc) ) > #; > > However when I check the actual database after sending/recieving messages > there is nothing in it.... > The status of the boxes looks like this: > > > Kannel bearerbox version `cvs-20031101'. System Linux, release > 2.4.20-gentoo-r6, version #1 Fri Sep 26 23:43:56 BST 2003, machine i686. > Hostname jarlco, IP 192.168.0.10. Libxml version 20508. Using OpenSSL 0.9.6k > 30 Sep 2003. Using MySQL 4.0.14. Using native malloc. > Status: running, uptime 0d 0h 22m 7s > WDP: received 0 (0 queued), sent 0 (0 queued) > SMS: received 0 (0 queued), sent 3 (0 queued), store size 0 > SMS: inbound 0.00 msg/sec, outbound 0.00 msg/sec > DLR: 0 queued, using mysql storage > Box connections: > smsbox:(none), IP 127.0.0.1 (0 queued), (on-line 0d 0h 14m 6s) > SMSC connections: > wavecom_1 AT2[wavecom_1] (online 1327s, rcvd 0, sent 3, failed 0, > queued 0 msgs) > > > and my config file looks like this: > ------------------------------------------ > group = core > admin-port = 13000 > admin-password = bar > smsbox-port = 13001 > store-file = "/tmp/kannel.store" > log-level = 2 > log-file = "/tmp/kannel.log" > access-log = /tmp/kannel.access > dlr-storage = mysql > > # SMSC CONNECTIONS > > group = smsc > smsc = at > smsc-id = wavecom_1 > allowed-smsc-id = wavecom_1 > modemtype = wavecom > device = /dev/ttyS0 > speed = 9600 > > > # MODEM GROUP > > group = modems > id = wavecom > name = Wavecom > detect-string = "WAVECOM" > > # SMSBOX SETUP > > group = smsbox > bearerbox-host = localhost > sendsms-port = 13013 > sendsms-url = "/cgi-bin/sendsms" > sendota-url = "/cgi-bin/sendota" > sendsms-chars = "0123456789 +-" > global-sender = 079 > reply-couldnotfetch = "Sorry, service was unable to fetch content..." > reply-couldnotrepresent = "Sorry, real message could not be represented as > SMS" > reply-requestfailed = "Sorry, the request failed" > reply-emptymessage = "Empty SMS was recieved" > log-file = "/tmp/smsbox.log" > access-log = "/tmp/kannel.access" > log-level = 3 > > # SEND SMS USER CONFIG > > group = sendsms-user > username = jarl > password = cornell > > group = sendsms-user > username = tester > password = foobar > > # SMS SERVICE > > group = sms-service > keyword = xxx > aliases = "af;ta;argh;tsk" > name = test1 > header = Jarl's SMS Service > footer = J.C > text = xxx service > > group = sms-service > keyword = www > get-url = "http://%S"; > > group = sms-service > keyword = vote > text = "Thank you for your vote it will now be processed" > > group = sms-service > keyword = nop > text = "service" > > # DEFAULT SERVICE > > group = sms-service > keyword = default > text = "default" > > > # MYSQL CONFIGURATION > > group = mysql-connection > id = mydlr1 > host = localhost > mysql-username = jarl > mysql-password = xxx > database = kannel > > # STORAGE GROUP > > group = dlr-db > id = mydlr1 > table = SmsEvent > field-smsc = smsc > field-timestamp = ts > field-destination = destination > field-service = service > field-url = url > field-mask = mask > field-status = status > field-boxc-id = boxc > field-source = source > > > > Cheers a lot for any help in this matter, I'm sure i'm just not > understanding this properly, which is why I'm hoping someone here will > maybe.. > /Jarl > > > > >
