This is rather embarrassing, however after having read all the great replies
and thinking nothing can go wrong now, things still seem a bit odd.
However this is most likely due to some misunderstanding on my side, which
is why I'm going to try to clear this out once and for all.
You might wounder why I'm asking so many (possibly stupid) questions, well
basically I find this to be a very exciting program, however hard to solve
some things without asking people who are more experienced.
Also I'm doing a SMS based 3rd year project where we're going to handle SMS
voting, so I need to be able to store users (on phone numbers) be able to
check what they wrote, have a script analyse the database etc, check that
they are registered voters, send a reply, count votes etc...
Obviously if I could get mysql and kannel to work while UNDERSTANDING how it
works, the project would be quite simple.
So, if anyone has the time and patience please follow my (hopefully simple)
questions, and steps below.
(for kannel.conf and how I installed mysql it's at the bottom, together with
my kannel mysql database.)
I'm sure this is useful not only to myself but others as well, and hopefully
after all this I'll be a bit more qualified myself to answer any questions.
Mysql steps and Questions
1.
(for Navjot Singh) I've looked through all possible posts and mail archives
I could find, however I don't seem to find the post you were talking about:
"For MORE info, PLEASE follow my posts on mysql+dlr, you will get clear
picture."
Any link to it somewhere? (or was it the one I already posted a link to?)
2.
what's the difference between "dlrmask=31" and "dlr-mask=31"
asking this because people say different things in different posts and I
tried dlrmask=31 but then an error message came up in my sms box saying use
"dlr-mask" instead.
3.
Does kannel never store messages in mysql unless you add &dlrmask (dlr-mask
?) to your send command?
4.
Now if the above is true (which I suspect) how then does kannel store an
incoming message?
5.
Can I add dlrmask or dlr-mask in my kannel.conf file somewhere to make it
store incoming messages?
6.
>From earlier replies I've gathered a fair bit of information, I know a
dlr.php file is useful for handling messages and mysql, however do I have to
have one to store a message? (seems like it)
7.
Of course I'm about to make the above, but I have to ask, just in case some
one already has one they want to share, is this a possibility?
8.
For my general understanding could anyone outline how it actually works when
a message is sent and when a message is delievered and stored.
for example:
message is sent
kannel stores the data in mysql
kannel then either leaves it like this or HAS to call a dlr.php file?
etc etc..
and then also for
message delievered
etc...
9.
I'm sure I lack something. I know the dlr.php file can do basically anything
you program it to do, however how would it know when a message has been
delivered if url isn't specified somewhere?
10.
I can see how the dlr.php can send a message, that's not difficult to
understand, it just uses the /sendsms.&to..&dlrmask? &dlr-mask etc.
11.
but then when does the thing actually get stored to mysql?
12.
hmm my head is spinning surely you don't need dlr.php to just store the
basics, surely kannel knows what the date, time, phone number etc is? And if
kannel didn't store this how would this info be transferred to dlr.php from
kannel?
If all this is answered I have to thank you all a lot, I know some of it is
probably basic and unfortunatly my understanding is soo limited I probably
wasn't even able to write the proper questions to get a real understanding.
But thank you for trying to help me.
-------------------------------------------------
Below is tests and how I've configured it all...
13.
Tried it all out today and I ended up with nothing in my database and the
following error (debug) messages:
--------------------------------------------------------------
2003-11-10 22:03:29 [11] DEBUG: boxc_receiver: sms received
2003-11-10 22:03:29 [11] DEBUG: send_msg: sending msg to box: <127.0.0.1>
2003-11-10 22:03:30 [7] DEBUG: AT2[wavecom_1]: TP-Validity-Period: 24.0
hours
2003-11-10 22:03:30 [7] DEBUG: AT2[wavecom_1]: --> AT+CMGS=23^M
2003-11-10 22:03:30 [7] DEBUG: AT2[wavecom_1]: <-- >
2003-11-10 22:03:30 [7] DEBUG: AT2[wavecom_1]: send command status: 1
2003-11-10 22:03:30 [7] DEBUG: AT2[wavecom_1]: -->
0031000B817018360612F00000A70 AC8329BFD06A9C37236
2003-11-10 22:03:30 [7] DEBUG: AT2[wavecom_1]: --> ^Z
2003-11-10 22:03:32 [0] DEBUG: Main Thread: Nothing todo.
2003-11-10 22:03:33 [7] DEBUG: AT2[wavecom_1]: <-- >
2003-11-10 22:03:33 [7] DEBUG: AT2[wavecom_1]: <-- +CMGS: 33
2003-11-10 22:03:33 [7] DEBUG: AT2[wavecom_1]: <-- OK
2003-11-10 22:03:33 [7] DEBUG: AT2[wavecom_1]: send command status: 0
2003-11-10 22:03:33 [7] DEBUG: DLR[mysql]: Adding DLR smsc=wavecom_1, ts=33,
src =07xxxxxxxx, dst=07xxxxxxxxx, mask=31, boxc=
2003-11-10 22:03:33 [7] DEBUG: sql: INSERT INTO SmsEvent (smsc, ts, source,
dest ination, service, url, mask, boxc, status) VALUES ('wavecom_1', '33',
'079xxxxxxxx 50', '07xxxxxxxxxx', 'jarl', '', '31', '', '0');
2003-11-10 22:03:33 [7] DEBUG: SMSC[wavecom_1]: creating DLR message
2003-11-10 22:03:33 [7] DEBUG: SMSC[wavecom_1]: DLR =
2003-11-10 22:03:33 [1] DEBUG: Dumping 1 messages and 0 acks to store
2003-11-10 22:03:33 [12] DEBUG: send_msg: sending msg to box: <127.0.0.1>
2003-11-10 22:03:33 [12] DEBUG: boxc_sender: sent message to <127.0.0.1>
2003-11-10 22:03:33 [11] DEBUG: boxc_receiver: got ack
2003-11-10 22:03:35 [11] DEBUG: boxc_receiver: heartbeat with load value 0
recei ved
2003-11-10 22:03:39 [7] DEBUG: AT2[wavecom_1]: <-- +CDS: 25
2003-11-10 22:03:39 [7] DEBUG: AT2[wavecom_1]: <--
0006210C914487616320013011011 28591003011011285220000
2003-11-10 22:03:39 [7] DEBUG: AT2[wavecom_1]: got STATUS-REPORT for message
<33 >:
2003-11-10 22:03:39 [7] DEBUG: AT2[wavecom_1]: Numeric receiver
(international) <+44xxxxxxxx>
2003-11-10 22:03:39 [7] DEBUG: DLR[mysql]: Looking for DLR smsc=wavecom_1,
ts=33 , dst=+44xxxxxxxxx, type=1
2003-11-10 22:03:39 [7] DEBUG: sql: SELECT mask, service, url, source,
destinati on, boxc FROM SmsEvent WHERE smsc='wavecom_1' AND ts='33';
2003-11-10 22:03:39 [7] DEBUG: Found entry, row[0]=31, row[1]=jarl, row[2]=,
row [3]=079xxxxxxxx, row[4]=078xxxxxxxxxx row[5]=
2003-11-10 22:03:39 [7] DEBUG: DLR[mysql]: created DLR message for URL <>
2003-11-10 22:03:39 [7] DEBUG: removing DLR from database
2003-11-10 22:03:39 [7] DEBUG: sql: DELETE FROM SmsEvent WHERE
smsc='wavecom_1' AND ts='33' LIMIT 1;
2003-11-10 22:03:39 [7] DEBUG: AT2[wavecom_1]: --> AT+CNMA^M
2003-11-10 22:03:39 [12] DEBUG: send_msg: sending msg to box: <127.0.0.1>
2003-11-10 22:03:39 [12] DEBUG: boxc_sender: sent message to <127.0.0.1>
2003-11-10 22:03:39 [11] DEBUG: boxc_receiver: got ack
2003-11-10 22:03:40 [7] DEBUG: AT2[wavecom_1]: <-- OK
2003-11-10 22:03:42 [0] DEBUG: Main Thread: Nothing todo.
2003-11-10 22:03:52 [0] DEBUG: Main Thread: Nothing todo.
2003-11-10 22:04:02 [0] DEBUG: Main Thread: Nothing todo.
2003-11-10 22:04:05 [11] DEBUG: boxc_receiver: heartbeat with load value 0
recei ved
So it tried to add it to the database? But deleted it? I'm confused again?
Installed it all with:
./configure --enable-mysql --with-dlr=mysql
make
make install
Then I set up a mysql database 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) )
#;
After this I added the following to my kannel.conf file
# MYSQL CONFIGURATION
group = core
..
dlr-storage = mysql
group = mysql-connection
id = mydlr1
host = localhost
mysql-username = jarl
mysql-password = jarl
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
Thank you all once again, you're great, thanks,
Jarl
