Drew here is my mysql part of my config.
#CORE BEARERBOX group = core admin-port = 13000 smsbox-port = 13001 wapbox-port = 13002 dlr-storage = mysql log-file = "/var/log/kannel/bearerbox.log" log-level = 0 access-log = "/var/log/kannel/beareraccess.log" #### CONEXION A MYSQL LOCALHOST group = mysql-connection id = mydlr host = localhost username = user password = pass database = kannel_dlr max-connections = 2 #### DLR DB DEFINITION group = dlr-db id = mydlr table = tblkannel_dlr field-smsc = smsc field-timestamp = ts field-destination = destination field-source = source field-service = service field-url = url field-mask = mask field-status = status field-boxc-id = boxc have you tried to connect directly to mysql? Are you having any mysql reference/errors/entries in bearerbox log? use log-level = 0 for debug. You might try to install kannel from souce... if so, I'll recommend you to use cvs rather than stable 1.4.1 Regards Alvaro |-----------------------------------------------------------------------------------------------------------------| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.NET www.smsglobal.com.mx y www.pravcom.com On Thu, Jan 8, 2009 at 9:22 AM, Nikos Balkanas <nbalka...@gmail.com> wrote: > OK. I get it know. I didn't see the rest of the mail. Just the part about > the panics. I will let Alvero handle the question. I am sure that you > misunderstood him. What he asked you to do from the shell is: > > One window: > bearerbox <confifile> > > Another window: > smsbox <conffile> > > Send your sms and watch for any mysql lines for errors. > > BR, > Nikos > > ----- Original Message ----- > From: Drew Stockler > To: Nikos Balkanas > Cc: users@kannel.org > Sent: Thursday, January 08, 2009 2:12 PM > Subject: Re: Ubuntu Installation with DLR mysql > My problem is my data is not inserting into mysql. Alvero was trying to help > me. > > He wanted to see the results of bearerbox etc/init.d/kannel. The results > were the panic errors below. That was the first time I ever ran that > command. I ran it in terminal window and the panic errors appeared in that > window. > > Then you asked for the first 100 lines of code from the log. I stopped and > started kannel with /etc/init.d/kannel stop/start and showed you the > lines. You said everything looked good. > > Again my problem is nothing gets inserted into mysql when I send a sms > message. The message is successfully sent but nothing in the database. How > do I trouble shoot this? > > Thanks, > Drew > > --- On Wed, 1/7/09, Nikos Balkanas <nbalka...@gmail.com> wrote: > > From: Nikos Balkanas <nbalka...@gmail.com> > Subject: Re: Ubuntu Installation with DLR mysql > To: "Drew Stockler" <psustock1...@yahoo.com> > Cc: users@kannel.org > Date: Wednesday, January 7, 2009, 8:15 PM > > Sorry I am confused. > A minute ago you were wondering why your bearerbox panics. Then you send as > proof a logfile from a run as: > > sudo bearerbox /etc/init.d/kannel > which is clearly wrong. > > So what is your problem? Did you run it like that or not? Do you get > bearerbox panics or suddenly your "logs are fine"? > > Nikos > > ----- Original Message ----- > From: Drew Stockler > To: Nikos Balkanas > Cc: users@kannel.org > Sent: Thursday, January 08, 2009 2:14 AM > Subject: Re: Ubuntu Installation with DLR mysql > I always start and stop kannel with etc/init.d/kannel stop/start. I just ran > the bearerbox <config file> because one of the users told me to. > > My problem is my logs seem fine, the sms messages are sent without a > problem, however kannel does not insert the information into mysql. The > kannel.conf file also seems correct. I will post it below. I have created > all the tables properly. Does anyone know my next step in troubleshooting? > > group = core > admin-port = 13000 > admin-password = bar > admin-deny-ip = "" > admin-allow-ip = "127.0.0.1" > smsbox-port = 13003 > wdp-interface-name = "*" > log-file = "/var/log/kannel/bearerbox.txt" > log-level = 0 > box-deny-ip = "*.*.*.*" > box-allow-ip = "127.0.0.1" > dlr-storage = mysql > > > group = smsc > smsc = at > modemtype = auto > device = /dev/ttyS0 > my-number = 3124010078 > sms-center = +13123149810 > connect-allow-ip = 127.0.0.1 > > > > group = sms-service > keyword = > keyword-regex = .* > catch-all = yes > max-messages = 0 > get-url = "http://localhost/sms?phone=%p&text=%a" > > group = sendsms-user > username = **** > password = ***** > max-messages = 10 > concatenation = true > > group = smsbox > bearerbox-host = 127.0.0.1 > sendsms-port = 13004 > global-sender = 3124010078 > log-file = "/var/log/kannel/smsbox.txt" > log-level = 0 > > include= "/usr/share/doc/kannel/examples/modems.conf" > > group = mysql-connection > id = mydlr > host = localhost > username = *** > password = ***** > database = dlr > max-connections = 1 > > group = dlr-db > id = mydlr > table = dlr > field-smsc = smsc > field-timestamp = ts > field-destination = destination > field-source = source > field-service = service > field-url = url > field-mask = mask > field-status = status > field-boxc-id = boxc > > > > --- On Wed, 1/7/09, Nikos Balkanas <nbalka...@gmail.com> wrote: > > From: Nikos Balkanas <nbalka...@gmail.com> > Subject: Re: Ubuntu Installation with DLR mysql > To: "Nikos Balkanas" <nbalka...@gmail.com>, "Drew Stockler" > <psustock1...@yahoo.com>, users@kannel.org > Date: Wednesday, January 7, 2009, 4:23 PM > > Sorry, too quick pressing the send button. > > You are starting bearerbox the wrong way. > > Use either: > > bearerbox <configure file> > > or > > /init.d/kannel start > > Don't mix those two!! > > PS: you don't need to su to run bearerbox, as long as your logfile is in an > accesible place (i.e. /tmp/bearer.log) > > BR, > Nikos > > ----- Original Message ----- > From: Nikos Balkanas > To: Drew Stockler ; users@kannel.org > Sent: Thursday, January 08, 2009 12:18 AM > Subject: Re: Ubuntu Installation with DLR mysql > Hmmm... It is pretty obvious what happens. > How did you generate the 100 successful lines you sent me? > > Nikos > ----- Original Message ----- > > From: Drew Stockler > To: users@kannel.org ; Nikos Balkanas > Sent: Wednesday, January 07, 2009 11:52 PM > Subject: Re: Ubuntu Installation with DLR mysql > i typed into the terminal: > > sudo bearerbox /etc/init.d/kannel > [sudo] password for drew: > 2009-01-07 15:50:57 [30787] [0] INFO: Debug_lvl = -1, log_file = <none>, > log_lvl = 0 > 2009-01-07 15:50:58 [30787] [0] ERROR: Group does not contain variable > 'group'. > 2009-01-07 15:50:58 [30787] [0] ERROR: Error found on line 26 of file > `/etc/init.d/kannel'. > 2009-01-07 15:50:58 [30787] [0] PANIC: Couldn't read configuration from > `/etc/init.d/kannel'. > 2009-01-07 15:50:58 [30787] [0] PANIC: bearerbox(gw_panic+0x107) [0x80c5227] > 2009-01-07 15:50:58 [30787] [0] PANIC: bearerbox(main+0xc2d) [0x80536cd] > 2009-01-07 15:50:58 [30787] [0] PANIC: > /lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe0) [0xb78b9050] > 2009-01-07 15:50:58 [30787] [0] PANIC: bearerbox [0x8051d51] > > -- On Wed, 1/7/09, Nikos Balkanas <nbalka...@gmail.com> wrote: > > From: Nikos Balkanas <nbalka...@gmail.com> > Subject: Re: Ubuntu Installation with DLR mysql > To: "Drew Stockler" <psustock1...@yahoo.com>, users@kannel.org, "Alvaro > Cornejo" <cornejo.alv...@gmail.com> > Date: Wednesday, January 7, 2009, 3:44 PM > > I see nothing wrong here. All configuration seems good. You are using a 2 > year old gateway, though. That's what you get for working with binaries... > This doesn't seem as the same logfile, though. As Alvaro suggested, which > log file listed the error? > > BR, > Nikos > > ----- Original Message ----- > From: Drew Stockler > To: users@kannel.org ; Alvaro Cornejo ; Nikos Balkanas > Sent: Wednesday, January 07, 2009 11:07 PM > Subject: Re: Ubuntu Installation with DLR mysql > Version 1.4.1-2 > > here is the first 100 lines at start up > > 2009-01-07 14:57:48 [29955] [0] INFO: Added logfile > `/var/log/kannel/bearerbox.txt' with level `0'. > 2009-01-07 14:57:48 [29955] [0] INFO: HTTP: Opening server at port 13000. > 2009-01-07 14:57:48 [29955] [0] DEBUG: Started thread 1 > (gwlib/fdset.c:poller) > 2009-01-07 14:57:48 [29955] [0] DEBUG: Started thread 2 > (gwlib/http.c:server_thread) > 2009-01-07 14:57:48 [29955] [0] DEBUG: Started thread 3 > (gw/bb_http.c:httpadmin_run) > 2009-01-07 14:57:48 [29955] [0] DEBUG: starting smsbox connection module > 2009-01-07 14:57:48 [29955] [0] INFO: BOXC: 'smsbox-max-pending' not set, > using default (100). > 2009-01-07 14:57:48 [29955] [0] DEBUG: Started thread 4 > (gw/bb_boxc.c:sms_to_smsboxes) > 2009-01-07 14:57:48 [29955] [0] DEBUG: Started thread 5 > (gw/bb_boxc.c:smsboxc_run) > 2009-01-07 14:57:48 [29955] [0] INFO: Set SMS resend frequency to 60 > seconds. > 2009-01-07 14:57:48 [29955] [0] INFO: SMS resend retry set to unlimited. > 2009-01-07 14:57:48 [29955] [0] INFO: DLR rerouting for smsc id <(null)> > disabled. > 2009-01-07 14:57:48 [29955] [0] INFO: AT2[/dev/ttyS0]: configuration doesn't > show modemtype. will autodetect > 2009-01-07 14:57:48 [29955] [0] DEBUG: Started thread 6 > (gw/smsc/smsc_at.c:at2_device_thread) > 2009-01-07 14:57:48 [29955] [0] DEBUG: Started thread 7 > (gw/bb_smscconn.c:sms_router) > 2009-01-07 14:57:48 [29955] [0] DEBUG: starting UDP sender/receiver module > 2009-01-07 14:57:48 [29955] [0] INFO: Adding interface * > 2009-01-07 14:57:48 [29955] [0] DEBUG: udpc_create: Bound to UDP > <0.0.0.0:9200> > 2009-01-07 14:57:48 [29955] [0] DEBUG: Started thread 8 > (gw/bb_udp.c:udp_receiver) > 2009-01-07 14:57:48 [29955] [0] DEBUG: Started thread 9 > (gw/bb_udp.c:udp_sender) > 2009-01-07 14:57:48 [29955] [0] DEBUG: udpc_create: Bound to UDP > <0.0.0.0:9201> > 2009-01-07 14:57:48 [29955] [0] DEBUG: Started thread 10 > (gw/bb_udp.c:udp_receiver) > 2009-01-07 14:57:48 [29955] [3] DEBUG: Thread 3 (gw/bb_http.c:httpadmin_run) > maps to pid 29955. > 2009-01-07 14:57:48 [29955] [1] DEBUG: Thread 1 (gwlib/fdset.c:poller) maps > to pid 29955. > 2009-01-07 14:57:48 [29955] [0] DEBUG: Started thread 11 > (gw/bb_udp.c:udp_sender) > 2009-01-07 14:57:48 [29955] [0] DEBUG: starting wapbox connection module > 2009-01-07 14:57:48 [29955] [0] ERROR: Missing wapbox-port variable, cannot > start WAP > 2009-01-07 14:57:48 [29955] [0] DEBUG: starting WDP router > 2009-01-07 14:57:48 [29955] [0] DEBUG: Started thread 12 > (gw/bearerbox.c:wdp_router) > 2009-01-07 14:57:48 [29955] [0] INFO: > ---------------------------------------- > 2009-01-07 14:57:48 [29955] [0] INFO: Kannel bearerbox II version 1.4.1 > starting > 2009-01-07 14:57:48 [29955] [4] DEBUG: Thread 4 > (gw/bb_boxc.c:sms_to_smsboxes) maps to pid 29955. > 2009-01-07 14:57:48 [29955] [5] DEBUG: Thread 5 (gw/bb_boxc.c:smsboxc_run) > maps to pid 29955. > 2009-01-07 14:57:48 [29955] [6] DEBUG: Thread 6 > (gw/smsc/smsc_at.c:at2_device_thread) maps to pid 29955. > 2009-01-07 14:57:48 [29955] [6] DEBUG: AT2[/dev/ttyS0]: detecting modem > speed. > 2009-01-07 14:57:48 [29955] [6] INFO: AT2[/dev/ttyS0]: opening device > 2009-01-07 14:57:48 [29955] [6] DEBUG: AT2[/dev/ttyS0]: device opened > 2009-01-07 14:57:48 [29955] [2] DEBUG: Thread 2 (gwlib/http.c:server_thread) > maps to pid 29955. > 2009-01-07 14:57:48 [29955] [7] DEBUG: Thread 7 > (gw/bb_smscconn.c:sms_router) maps to pid 29955. > 2009-01-07 14:57:48 [29955] [7] DEBUG: sms_router: time to sleep 30.00 secs. > 2009-01-07 14:57:48 [29955] [8] DEBUG: Thread 8 (gw/bb_udp.c:udp_receiver) > maps to pid 29955. > 2009-01-07 14:57:48 [29955] [9] DEBUG: Thread 9 (gw/bb_udp.c:udp_sender) > maps to pid 29955. > 2009-01-07 14:57:48 [29955] [10] DEBUG: Thread 10 (gw/bb_udp.c:udp_receiver) > maps to pid 29955. > 2009-01-07 14:57:48 [29955] [11] DEBUG: Thread 11 (gw/bb_udp.c:udp_sender) > maps to pid 29955. > 2009-01-07 14:57:48 [29955] [12] DEBUG: Thread 12 > (gw/bearerbox.c:wdp_router) maps to pid 29955. > 2009-01-07 14:57:48 [29955] [12] DEBUG: udp_die: removing producers from > udp-lists > 2009-01-07 14:57:48 [29955] [12] DEBUG: Thread 12 > (gw/bearerbox.c:wdp_router) terminates. > 2009-01-07 14:57:48 [29955] [0] INFO: MAIN: Start-up done, entering mainloop > 2009-01-07 14:57:48 [29955] [0] DEBUG: AT2[/dev/ttyS0]: start called > 2009-01-07 14:57:48 [29955] [7] DEBUG: sms_router: gwlist_len = 0 > 2009-01-07 14:57:49 [29955] [6] DEBUG: AT2[/dev/ttyS0]: device opened > 2009-01-07 14:57:49 [29955] [6] INFO: AT2[/dev/ttyS0]: speed set to 115200 > 2009-01-07 14:57:49 [29955] [6] DEBUG: AT2[/dev/ttyS0]: --> ^M > 2009-01-07 14:57:49 [29955] [5] INFO: Client connected from <127.0.0.1> > 2009-01-07 14:57:49 [29955] [5] DEBUG: Started thread 13 > (gw/bb_boxc.c:function) > 2009-01-07 14:57:49 [29955] [13] DEBUG: Thread 13 (gw/bb_boxc.c:function) > maps to pid 29955. > 2009-01-07 14:57:49 [29955] [13] DEBUG: Started thread 14 > (gw/bb_boxc.c:boxc_sender) > 2009-01-07 14:57:49 [29955] [14] DEBUG: Thread 14 (gw/bb_boxc.c:boxc_sender) > maps to pid 29955. > 2009-01-07 14:57:51 [29955] [6] DEBUG: AT2[/dev/ttyS0]: --> AT^M > 2009-01-07 14:57:55 [29955] [6] DEBUG: AT2[/dev/ttyS0]: --> AT^M > 2009-01-07 14:57:59 [29955] [6] DEBUG: AT2[/dev/ttyS0]: --> AT^M > 2009-01-07 14:58:03 [29955] [6] INFO: AT2[/dev/ttyS0]: closing device > 2009-01-07 14:58:03 [29955] [6] INFO: AT2[/dev/ttyS0]: opening device > 2009-01-07 14:58:03 [29955] [6] DEBUG: AT2[/dev/ttyS0]: device opened > 2009-01-07 14:58:04 [29955] [6] DEBUG: AT2[/dev/ttyS0]: device opened > 2009-01-07 14:58:04 [29955] [6] INFO: AT2[/dev/ttyS0]: speed set to 57600 > 2009-01-07 14:58:04 [29955] [6] DEBUG: AT2[/dev/ttyS0]: --> ^M > 2009-01-07 14:58:06 [29955] [6] DEBUG: AT2[/dev/ttyS0]: --> AT^M > 2009-01-07 14:58:10 [29955] [6] DEBUG: AT2[/dev/ttyS0]: --> AT^M > 2009-01-07 14:58:14 [29955] [6] DEBUG: AT2[/dev/ttyS0]: --> AT^M > 2009-01-07 14:58:18 [29955] [6] INFO: AT2[/dev/ttyS0]: closing device > 2009-01-07 14:58:18 [29955] [6] INFO: AT2[/dev/ttyS0]: opening device > 2009-01-07 14:58:18 [29955] [6] DEBUG: AT2[/dev/ttyS0]: device opened > 2009-01-07 14:58:19 [29955] [6] DEBUG: AT2[/dev/ttyS0]: device opened > 2009-01-07 14:58:19 [29955] [6] INFO: AT2[/dev/ttyS0]: speed set to 38400 > 2009-01-07 14:58:19 [29955] [6] DEBUG: AT2[/dev/ttyS0]: --> ^M > 2009-01-07 14:58:21 [29955] [6] DEBUG: AT2[/dev/ttyS0]: --> AT^M > 2009-01-07 14:58:25 [29955] [6] DEBUG: AT2[/dev/ttyS0]: --> AT^M > 2009-01-07 14:58:29 [29955] [6] DEBUG: AT2[/dev/ttyS0]: --> AT^M > 2009-01-07 14:58:33 [29955] [6] INFO: AT2[/dev/ttyS0]: closing device > 2009-01-07 14:58:33 [29955] [6] INFO: AT2[/dev/ttyS0]: opening device > 2009-01-07 14:58:33 [29955] [6] DEBUG: AT2[/dev/ttyS0]: device opened > 2009-01-07 14:58:34 [29955] [6] DEBUG: AT2[/dev/ttyS0]: device opened > 2009-01-07 14:58:34 [29955] [6] INFO: AT2[/dev/ttyS0]: speed set to 19200 > 2009-01-07 14:58:34 [29955] [6] DEBUG: AT2[/dev/ttyS0]: --> ^M > 2009-01-07 14:58:36 [29955] [6] DEBUG: AT2[/dev/ttyS0]: --> AT^M > 2009-01-07 14:58:40 [29955] [6] DEBUG: AT2[/dev/ttyS0]: --> AT^M > 2009-01-07 14:58:44 [29955] [6] DEBUG: AT2[/dev/ttyS0]: --> AT^M > 2009-01-07 14:58:48 [29955] [6] INFO: AT2[/dev/ttyS0]: closing device > 2009-01-07 14:58:48 [29955] [6] INFO: AT2[/dev/ttyS0]: opening device > 2009-01-07 14:58:48 [29955] [6] DEBUG: AT2[/dev/ttyS0]: device opened > 2009-01-07 14:58:49 [29955] [6] DEBUG: AT2[/dev/ttyS0]: device opened > 2009-01-07 14:58:49 [29955] [6] INFO: AT2[/dev/ttyS0]: speed set to 9600 > 2009-01-07 14:58:49 [29955] [6] DEBUG: AT2[/dev/ttyS0]: --> ^M > 2009-01-07 14:58:51 [29955] [6] DEBUG: AT2[/dev/ttyS0]: --> AT^M > 2009-01-07 14:58:51 [29955] [6] DEBUG: AT2[/dev/ttyS0]: <-- OK > 2009-01-07 14:58:51 [29955] [6] INFO: AT2[/dev/ttyS0]: closing device > 2009-01-07 14:58:51 [29955] [6] INFO: AT2[/dev/ttyS0]: detect speed is 9600 > 2009-01-07 14:58:51 [29955] [6] DEBUG: AT2[/dev/ttyS0]: detecting modem type > 2009-01-07 14:58:51 [29955] [6] INFO: AT2[/dev/ttyS0]: opening device > > --- On Wed, 1/7/09, Nikos Balkanas <nbalka...@gmail.com> wrote: > > From: Nikos Balkanas <nbalka...@gmail.com> > Subject: Re: Ubuntu Installation with DLR mysql > To: "Drew Stockler" <psustock1...@yahoo.com>, users@kannel.org, "Alvaro > Cornejo" <cornejo.alv...@gmail.com> > Date: Wednesday, January 7, 2009, 2:30 PM > > This looks bad. It is complaining that it cannot find "group = core" in the > configuration file. Which clearly you do have. Furthermore it shouldn't > start if it didn't have a correct core group. Smells like memory > corruption... > What version gateway are you using? > > Could you send an excerpt from the bearerbox (100 or so lines) from its > startup? > > BR, > Nikos > > ----- Original Message ----- > From: Drew Stockler > To: users@kannel.org ; Alvaro Cornejo > Sent: Wednesday, January 07, 2009 9:42 PM > Subject: Re: Ubuntu Installation with DLR mysql > I get this: > 2009-01-07 13:39:22 [27781] [0] INFO: Debug_lvl = -1, log_file = <none>, > log_lvl = 0 > 2009-01-07 13:39:23 [27781] [0] PANIC: DLR: can't find group core > 2009-01-07 13:39:23 [27781] [0] PANIC: bearerbox(gw_panic+0x107) [0x80c5227] > 2009-01-07 13:39:23 [27781] [0] PANIC: bearerbox(dlr_init+0x1c8) [0x805ce48] > 2009-01-07 13:39:23 [27781] [0] PANIC: bearerbox(main+0x10a) [0x8052baa] > 2009-01-07 13:39:23 [27781] [0] PANIC: > /lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe0) [0xb789b050] > 2009-01-07 13:39:23 [27781] [0] PANIC: bearerbox [0x8051d51] > > > --- On Wed, 1/7/09, Alvaro Cornejo <cornejo.alv...@gmail.com> wrote: > > From: Alvaro Cornejo <cornejo.alv...@gmail.com> > Subject: Re: Ubuntu Installation with DLR mysql > To: "Drew Stockler" <psustock1...@yahoo.com>, "users@kannel.org" > <users@kannel.org> > Date: Wednesday, January 7, 2009, 12:54 PM > > Please cc to kannel list so you can receive better support. > > the ./configure make, make install is only needed when downloading > sources from kannel. > > otherwise apt-get install is enough > > try bearerbox pathtoconfigfile to see if there are errors when > running bearerbox and if it finds mysql files > > > > |-----------------------------------------------------------------------------------------------------------------| > Envνe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier > celular y Nextel > en el Perϊ, Mιxico y en mas de 180 paises. Use aplicaciones 2 vias via > SMS y GPRS online > Visitenos en www.perusms.NET www.smsglobal.com.mx y > www.pravcom.com > > > > On Wed, Jan 7, 2009 at 1:15 PM, Drew Stockler > <psustock1...@yahoo.com> > wrote: >> > > > http://packages.ubuntu.com/hardy/i386/kannel/filelist >> >> > According to ubuntu, there > is no files called configure to run in the >> directory in which kannel is installed /etc/init.d/kannel >> >> On the page below it says that it is compiled with ssl, mysql and native >> malloc >> >> http://packages.ubuntu.com/hardy/i386/kannel/filelist >> >> When you downloaded kannel from the hardy repositories did you have to do >> the configure; make; install? >> >> The tables are set up and the config is below >> >> group = core >> admin-port = 13000 >> admin-password = bar >> admin-deny-ip = "" >> admin-allow-ip = "127.0.0.1" >> smsbox-port = 13003 >> wdp-interface-name = "*" >> log-file = "/var/log/kannel/bearerbox.txt" >> log-level = 0 >> box-deny-ip = "*.*.*.*" >> box-allow-ip = > "127.0.0.1" >> dlr-storage = > > > mysql >> >> >> group = smsc >> smsc = at >> modemtype = > auto >> device = > /dev/ttyS0 >> my-number = 3124010078 >> sms-center = +13123149810 >> connect-allow-ip = 127.0.0.1 >> >> >> >> group = sms-service >> keyword = >> keyword-regex = .* >> catch-all = yes >> max-messages = 0 >> get-url = "http://localhost/sms?phone=%p&text=%a" >> >> group = sendsms-user >> username = ***** >> password = ***** >> max-messages = 10 >> concatenation = true >> >> group = smsbox >> bearerbox-host = 127.0.0.1 >> sendsms-port = 13004 >> global-sender = 3124010078 >> log-file = "/var/log/kannel/smsbox.txt" >> log-level = 0 >> >> include= "/usr/share/doc/kannel/examples/modems.conf" >> >> group = mysql-connection >> id = mydlr >> host = localhost >> > username = > *** >> > > password = ****** >> database = dlr >> max-connections = 1 >> >> > group = dlr-db >> id = > mydlr >> table = dlr >> field-smsc = smsc >> field-timestamp = ts >> field-destination = destination >> field-source = source >> field-service = service >> field-url = url >> field-mask = mask >> field-status = status >> field-boxc-id = boxc >> >> >> >> >> >> --- On Wed, 1/7/09, Alvaro Cornejo <cornejo.alv...@gmail.com> wrote: >> >> From: Alvaro Cornejo <cornejo.alv...@gmail.com> >> Subject: Re: Ubuntu Installation with DLR mysql >> To: "Drew Stockler" <psustock1...@yahoo.com>, > "users@kannel.org" >> <users@kannel.org> >> Date: Wednesday, January 7, 2009, 9:30 AM >> >> Just run >> >> (mysql must be installed before this) >> >> ./configure > --with-mysql > > > --enable-start-stop-daemon >> >> on the dir where you downloaded kannel >> >> then > make >> >> and make > install (if you want to change default install dir doit here >> >> >> >> >> >> > |-----------------------------------------------------------------------------------------------------------------| >> Envνe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier >> celular y Nextel >> en el >> Perϊ, Mιxico y en mas de 180 paises. Use aplicaciones 2 vias via >> SMS y GPRS online >> Visitenos en www.perusms.NET www.smsglobal.com.mx y >> www.pravcom.com >> >> >> >> On Tue, Jan 6, 2009 at 9:04 PM, Drew Stockler > <psustock1...@yahoo.com> >> wrote: >>> I have the tables created correctly. Here are my confige enteries > which >> are >>> correct. The > only thing I am having > > trouble with > is the make > ./configure >> I >>> don't understand the syntax via the command > line. Is there any >> > documentation >>> for that. i have searched the user guide, and google. I see > ./configure >> and >>> type make all the time but when i put them into the command line i get >>> nothing. >>> >>> Thanks for all the help, >>> >>> Drew >>> >>> --- On Tue, 1/6/09, Alvaro Cornejo <cornejo.alv...@gmail.com> > wrote: >>> >>> From: Alvaro Cornejo <cornejo.alv...@gmail.com> >>> Subject: Re: >> Ubuntu Installation with DLR mysql >>> To: "Drew Stockler" <psustock1...@yahoo.com> >>> Cc: users@kannel.org >>> Date: Tuesday, January 6, 2009, 7:09 PM >>> >>> Just follow indications on documentation about creation of dlr > tables, >>> make of kannel with > > mysql support and the > appropiate config entries. >>> >>> I use ubuntu hardy with kannel & > mysql from packages with > no > problem >>> >>> Regards >>> >>> Alvaro >>> >>> >>> On Tue, 2009-01-06 at 16:41 -0800, Drew Stockler wrote: >>>> Is there anyone out there who installed kannel from the ubuntu >>>> repositories and successfully integrated kannel with mysql for >> dlr's? >>>> >>>> All the documenation i saw was for a downloaded install from >>>> kannel.org then do a ./configure make and include the mysql > commands. >>>> >>>> Is their a procedure for a debian install/ubuntu repository I >> can >>>> follow? >>>> >>>> Thanks >>>> > > > > > Drew >>>> >>>> >>>> >>>> >>> >>> >>> >> >> > > > > > >