RE: Using MySQL storage
Hello, Where can I find more information about sqlbox? Some documentations... Thanx Roman Alonso -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Rene Kluwen Enviado el: Sábado, 20 de Marzo de 2004 04:42 p.m. Para: Pedro B.; [EMAIL PROTECTED] Asunto: RE: Using MySQL storage sqlbox logs MO, MT and DLR messages. Rene Kluwen Chimit -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Pedro B. Sent: vrijdag 19 maart 2004 0:31 To: [EMAIL PROTECTED] Subject: Re: Using MySQL storage Hello, First of all, i apologise if this question (and/or an answer) have already been discussed, but i did not find any on the mailing list's archives. Will the sqlbox also be able to support archiving/logging of incoming sms's, or will the only way to it be (for example), an exec to a php or pl code that would process the MO, log it, process it, create the MT, sent it? Thanks in advance \\pb Rene Kluwen wrote: SQLBOX is for this. It is another box (besides smsbox, wapbox, bearerbox) for Kannel. It will be available as patch on this mailinglist shortly, after I worked away everything that has been waiting for me in the month that I have been away from my desk. Rene Kluwen Chimit -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Reto Hersiczky Sent: vrijdag 5 maart 2004 1:34 To: [EMAIL PROTECTED] Subject: Using MySQL storage I want to store each SMS delivery log entry directly into a MySQL table. I could verify Kannel is able to read from the related database table since the web-based status panel on http://localhost:13000/status.html?username=foopassword=bar always shows the exact number of rows as DLR: 1 queued, using mysql storage (I just played with that table so the 1 row has been inserted by me not by the smsbox daemon.) Although I can send SMS with http://localhost:13002/cgi-bin/sendsms?to=0764611551username=foopassword=b artext=Hello and Kannel confirms the built-in MySQL support is ready ... Kannel bearerbox version `1.2.1'. System Linux, release 2.4.20-8, version #1 Thu Mar 13 17:54:28 EST 2003, machine i686. Hostname foo.bar.ch, IP 127.0.0.1. Libxml version 20504. Using MySQL 4.0.15. Using LibSDB 0.5.2. Using native malloc. ... no records are being inserted. The goal is to send SMS through smsbox and the the requests and their status are beeing logged into a MySQL table. Can anybody share her/his expertise on this? Have configured and compiled Kannel with ./configure --disable-ssl --with-mysql=/usr --enable-mysql --with-dlr=mysql --enable-mysql-dlr --enable-sdb -- Best regards, Reto mailto:[EMAIL PROTECTED] Will publish the complete solution procedure on this as quickly as I get rid of this problem on http://www.infocopter.com/know-how/kannel-mysql-print.htm
RE: Using MySQL storage
Nowhere yet. They are 'under construction'. Rene Kluwen Chimit -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Roman Alonso Sent: dinsdag 23 maart 2004 14:05 To: 'Rene Kluwen'; 'Pedro B.'; [EMAIL PROTECTED] Subject: RE: Using MySQL storage Hello, Where can I find more information about sqlbox? Some documentations... Thanx Roman Alonso -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Rene Kluwen Enviado el: Sábado, 20 de Marzo de 2004 04:42 p.m. Para: Pedro B.; [EMAIL PROTECTED] Asunto: RE: Using MySQL storage sqlbox logs MO, MT and DLR messages. Rene Kluwen Chimit -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Pedro B. Sent: vrijdag 19 maart 2004 0:31 To: [EMAIL PROTECTED] Subject: Re: Using MySQL storage Hello, First of all, i apologise if this question (and/or an answer) have already been discussed, but i did not find any on the mailing list's archives. Will the sqlbox also be able to support archiving/logging of incoming sms's, or will the only way to it be (for example), an exec to a php or pl code that would process the MO, log it, process it, create the MT, sent it? Thanks in advance \\pb Rene Kluwen wrote: SQLBOX is for this. It is another box (besides smsbox, wapbox, bearerbox) for Kannel. It will be available as patch on this mailinglist shortly, after I worked away everything that has been waiting for me in the month that I have been away from my desk. Rene Kluwen Chimit -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Reto Hersiczky Sent: vrijdag 5 maart 2004 1:34 To: [EMAIL PROTECTED] Subject: Using MySQL storage I want to store each SMS delivery log entry directly into a MySQL table. I could verify Kannel is able to read from the related database table since the web-based status panel on http://localhost:13000/status.html?username=foopassword=bar always shows the exact number of rows as DLR: 1 queued, using mysql storage (I just played with that table so the 1 row has been inserted by me not by the smsbox daemon.) Although I can send SMS with http://localhost:13002/cgi-bin/sendsms?to=0764611551username=foopassword=b artext=Hello and Kannel confirms the built-in MySQL support is ready ... Kannel bearerbox version `1.2.1'. System Linux, release 2.4.20-8, version #1 Thu Mar 13 17:54:28 EST 2003, machine i686. Hostname foo.bar.ch, IP 127.0.0.1. Libxml version 20504. Using MySQL 4.0.15. Using LibSDB 0.5.2. Using native malloc. ... no records are being inserted. The goal is to send SMS through smsbox and the the requests and their status are beeing logged into a MySQL table. Can anybody share her/his expertise on this? Have configured and compiled Kannel with ./configure --disable-ssl --with-mysql=/usr --enable-mysql --with-dlr=mysql --enable-mysql-dlr --enable-sdb -- Best regards, Reto mailto:[EMAIL PROTECTED] Will publish the complete solution procedure on this as quickly as I get rid of this problem on http://www.infocopter.com/know-how/kannel-mysql-print.htm
RE: Using MySQL storage
sqlbox logs MO, MT and DLR messages. Rene Kluwen Chimit -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Pedro B. Sent: vrijdag 19 maart 2004 0:31 To: [EMAIL PROTECTED] Subject: Re: Using MySQL storage Hello, First of all, i apologise if this question (and/or an answer) have already been discussed, but i did not find any on the mailing list's archives. Will the sqlbox also be able to support archiving/logging of incoming sms's, or will the only way to it be (for example), an exec to a php or pl code that would process the MO, log it, process it, create the MT, sent it? Thanks in advance \\pb Rene Kluwen wrote: SQLBOX is for this. It is another box (besides smsbox, wapbox, bearerbox) for Kannel. It will be available as patch on this mailinglist shortly, after I worked away everything that has been waiting for me in the month that I have been away from my desk. Rene Kluwen Chimit -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Reto Hersiczky Sent: vrijdag 5 maart 2004 1:34 To: [EMAIL PROTECTED] Subject: Using MySQL storage I want to store each SMS delivery log entry directly into a MySQL table. I could verify Kannel is able to read from the related database table since the web-based status panel on http://localhost:13000/status.html?username=foopassword=bar always shows the exact number of rows as DLR: 1 queued, using mysql storage (I just played with that table so the 1 row has been inserted by me not by the smsbox daemon.) Although I can send SMS with http://localhost:13002/cgi-bin/sendsms?to=0764611551username=foopassword=b artext=Hello and Kannel confirms the built-in MySQL support is ready ... Kannel bearerbox version `1.2.1'. System Linux, release 2.4.20-8, version #1 Thu Mar 13 17:54:28 EST 2003, machine i686. Hostname foo.bar.ch, IP 127.0.0.1. Libxml version 20504. Using MySQL 4.0.15. Using LibSDB 0.5.2. Using native malloc. ... no records are being inserted. The goal is to send SMS through smsbox and the the requests and their status are beeing logged into a MySQL table. Can anybody share her/his expertise on this? Have configured and compiled Kannel with ./configure --disable-ssl --with-mysql=/usr --enable-mysql --with-dlr=mysql --enable-mysql-dlr --enable-sdb -- Best regards, Reto mailto:[EMAIL PROTECTED] Will publish the complete solution procedure on this as quickly as I get rid of this problem on http://www.infocopter.com/know-how/kannel-mysql-print.htm
RE: Using MySQL storage
SQLBOX is for this. It is another box (besides smsbox, wapbox, bearerbox) for Kannel. It will be available as patch on this mailinglist shortly, after I worked away everything that has been waiting for me in the month that I have been away from my desk. Rene Kluwen Chimit -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Reto Hersiczky Sent: vrijdag 5 maart 2004 1:34 To: [EMAIL PROTECTED] Subject: Using MySQL storage I want to store each SMS delivery log entry directly into a MySQL table. I could verify Kannel is able to read from the related database table since the web-based status panel on http://localhost:13000/status.html?username=foopassword=bar always shows the exact number of rows as DLR: 1 queued, using mysql storage (I just played with that table so the 1 row has been inserted by me not by the smsbox daemon.) Although I can send SMS with http://localhost:13002/cgi-bin/sendsms?to=0764611551username=foopassword=b artext=Hello and Kannel confirms the built-in MySQL support is ready ... Kannel bearerbox version `1.2.1'. System Linux, release 2.4.20-8, version #1 Thu Mar 13 17:54:28 EST 2003, machine i686. Hostname foo.bar.ch, IP 127.0.0.1. Libxml version 20504. Using MySQL 4.0.15. Using LibSDB 0.5.2. Using native malloc. ... no records are being inserted. The goal is to send SMS through smsbox and the the requests and their status are beeing logged into a MySQL table. Can anybody share her/his expertise on this? Have configured and compiled Kannel with ./configure --disable-ssl --with-mysql=/usr --enable-mysql --with-dlr=mysql --enable-mysql-dlr --enable-sdb -- Best regards, Reto mailto:[EMAIL PROTECTED] Will publish the complete solution procedure on this as quickly as I get rid of this problem on http://www.infocopter.com/know-how/kannel-mysql-print.htm
Re: Using MySQL storage
Hello, First of all, i apologise if this question (and/or an answer) have already been discussed, but i did not find any on the mailing list's archives. Will the sqlbox also be able to support archiving/logging of incoming sms's, or will the only way to it be (for example), an exec to a php or pl code that would process the MO, log it, process it, create the MT, sent it? Thanks in advance \\pb Rene Kluwen wrote: SQLBOX is for this. It is another box (besides smsbox, wapbox, bearerbox) for Kannel. It will be available as patch on this mailinglist shortly, after I worked away everything that has been waiting for me in the month that I have been away from my desk. Rene Kluwen Chimit -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Reto Hersiczky Sent: vrijdag 5 maart 2004 1:34 To: [EMAIL PROTECTED] Subject: Using MySQL storage I want to store each SMS delivery log entry directly into a MySQL table. I could verify Kannel is able to read from the related database table since the web-based status panel on http://localhost:13000/status.html?username=foopassword=bar always shows the exact number of rows as DLR: 1 queued, using mysql storage (I just played with that table so the 1 row has been inserted by me not by the smsbox daemon.) Although I can send SMS with http://localhost:13002/cgi-bin/sendsms?to=0764611551username=foopassword=b artext=Hello and Kannel confirms the built-in MySQL support is ready ... Kannel bearerbox version `1.2.1'. System Linux, release 2.4.20-8, version #1 Thu Mar 13 17:54:28 EST 2003, machine i686. Hostname foo.bar.ch, IP 127.0.0.1. Libxml version 20504. Using MySQL 4.0.15. Using LibSDB 0.5.2. Using native malloc. ... no records are being inserted. The goal is to send SMS through smsbox and the the requests and their status are beeing logged into a MySQL table. Can anybody share her/his expertise on this? Have configured and compiled Kannel with ./configure --disable-ssl --with-mysql=/usr --enable-mysql --with-dlr=mysql --enable-mysql-dlr --enable-sdb -- Best regards, Reto mailto:[EMAIL PROTECTED] Will publish the complete solution procedure on this as quickly as I get rid of this problem on http://www.infocopter.com/know-how/kannel-mysql-print.htm