Hi Theodore
Actually dlr is supported by smsc_at. The issue is more operator
specific. I do have some of the operators that do send dlr and others
not. Request the dlr and see what you get
Also I noticed that the one that provide dlrs does it not for the
intremediate dlr status but for final statuses (delivered/failed).
Another thing is that I receive most of the final dlrs after
midnigt.... look like the operator queues most the dlrs up to 2am to
send them !!!
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 Tue, Jun 23, 2009 at 9:00 AM, Theodore G<[email protected]> wrote:
> Thanks Alejandro,
> the symlink solved the mysql connection problem.
>
> I just found out from the kannel guide that AT command in smsc does not
> support DLR, so no report will be delivered. I'm using Huawei E172 modem
> with the at command, so I guess I won't be able to see the DLRs.
>
> Thanks for the help. Now my kannel runs smoothly with no errors.
>
>
> On Tue, Jun 23, 2009 at 11:05 AM, Alejandro Guerrieri
> <[email protected]> wrote:
>>
>> Then use a symlink:
>> ln -s /path/where/mysql-sock-is /path/where/mysql-sock-should-be
>> Hope it helps,
>> Alejandro
>>
>> On Tue, Jun 23, 2009 at 9:16 AM, Theodore G <[email protected]> wrote:
>>>
>>> Hi,
>>> I found where xampp is keeping the mysql.sock. the my.cnf in xampp is
>>> already set correctly, i found another my.cnf in /etc/mysql directory, and
>>> changed that with the new mysql.sock location, but when I tried to start
>>> bearerbox, the same error came up. looks like the location kannel is
>>> searching for mysql.sock is looking from somewhere else, not in my.cnf file.
>>>
>>>
>>> I also tried to change the host in the mysql-connection group to
>>> 127.0.0.1 and this is the error i get
>>> -----------------------------
>>> malaikam...@xps:/etc/kannel$ bearerbox
>>> 2009-06-23 10:14:27 [5993] [0] INFO: Debug_lvl = -1, log_file = <none>,
>>> log_lvl = 0
>>> 2009-06-23 10:14:27 [5993] [0] ERROR: MYSQL: can not connect to database!
>>> 2009-06-23 10:14:27 [5993] [0] ERROR: MYSQL: Can't connect to MySQL
>>> server on '127.0.0.1' (111)
>>> 2009-06-23 10:14:27 [5993] [0] ERROR: MYSQL: can not connect to database!
>>> 2009-06-23 10:14:27 [5993] [0] ERROR: MYSQL: Can't connect to MySQL
>>> server on '127.0.0.1' (111)
>>> 2009-06-23 10:14:27 [5993] [0] ERROR: MYSQL: can not connect to database!
>>> 2009-06-23 10:14:27 [5993] [0] ERROR: MYSQL: Can't connect to MySQL
>>> server on '127.0.0.1' (111)
>>> 2009-06-23 10:14:27 [5993] [0] ERROR: MYSQL: can not connect to database!
>>> 2009-06-23 10:14:27 [5993] [0] ERROR: MYSQL: Can't connect to MySQL
>>> server on '127.0.0.1' (111)
>>> 2009-06-23 10:14:27 [5993] [0] ERROR: MYSQL: can not connect to database!
>>> 2009-06-23 10:14:27 [5993] [0] ERROR: MYSQL: Can't connect to MySQL
>>> server on '127.0.0.1' (111)
>>> 2009-06-23 10:14:27 [5993] [0] PANIC: DLR: MySQL: database pool has no
>>> connections!
>>> 2009-06-23 10:14:27 [5993] [0] PANIC: bearerbox(gw_panic+0xd4)
>>> [0x80d4674]
>>> 2009-06-23 10:14:27 [5993] [0] PANIC: bearerbox(dlr_init_mysql+0x359)
>>> [0x8063529]
>>> 2009-06-23 10:14:27 [5993] [0] PANIC: bearerbox(dlr_init+0x8b)
>>> [0x8061b2b]
>>> 2009-06-23 10:14:27 [5993] [0] PANIC: bearerbox(main+0x10a) [0x8054b5a]
>>> 2009-06-23 10:14:27 [5993] [0] PANIC:
>>> /lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe5) [0xb7855775]
>>> 2009-06-23 10:14:27 [5993] [0] PANIC: bearerbox [0x8053f31]
>>>
>>> ------------------------------
>>>
>>>
>>> On Mon, Jun 22, 2009 at 5:21 PM, Donald Jackson <[email protected]>
>>> wrote:
>>>>
>>>> Hi Theodore,
>>>>
>>>> I use MAMP (Mac clone of XAMPP).
>>>>
>>>> It stores the mysqld.sock file elsewhere (usually in the MAMP
>>>> directory). I would suggest trying to change "localhost" to "127.0.0.1"
>>>> this
>>>> should solve your problem.
>>>>
>>>> Alternatively, find the place where XAMPP is keeping your mysqld.sock
>>>> file and edit your my.cnf file accordingly.
>>>>
>>>> Hope this helps.
>>>>
>>>> Donald
>>>> http://www.thearchitech.com/
>>>>
>>>>
>>>> 2009/6/22 Theodore G <[email protected]>
>>>>>
>>>>> Hello everyone,
>>>>> I am trying to use mysql as the dlr storage, but i get an error (see
>>>>> my log dump below):
>>>>>
>>>>> --------------------------------------------------------------
>>>>> 2009-06-22 13:12:14 [5828] [0] INFO: Debug_lvl = -1, log_file = <none>,
>>>>> log_lvl = 0
>>>>> 2009-06-22 13:12:14 [5828] [0] ERROR: MYSQL: can not connect to
>>>>> database!
>>>>> 2009-06-22 13:12:14 [5828] [0] ERROR: MYSQL: Can't connect to local
>>>>> MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
>>>>> 2009-06-22 13:12:14 [5828] [0] ERROR: MYSQL: can not connect to
>>>>> database!
>>>>> 2009-06-22 13:12:14 [5828] [0] ERROR: MYSQL: Can't connect to local
>>>>> MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
>>>>> 2009-06-22 13:12:14 [5828] [0] ERROR: MYSQL: can not connect to
>>>>> database!
>>>>> 2009-06-22 13:12:14 [5828] [0] ERROR: MYSQL: Can't connect to local
>>>>> MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
>>>>> 2009-06-22 13:12:14 [5828] [0] ERROR: MYSQL: can not connect to
>>>>> database!
>>>>> 2009-06-22 13:12:14 [5828] [0] ERROR: MYSQL: Can't connect to local
>>>>> MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
>>>>> 2009-06-22 13:12:14 [5828] [0] ERROR: MYSQL: can not connect to
>>>>> database!
>>>>> 2009-06-22 13:12:14 [5828] [0] ERROR: MYSQL: Can't connect to local
>>>>> MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
>>>>> 2009-06-22 13:12:14 [5828] [0] PANIC: DLR: MySQL: database pool has no
>>>>> connections!
>>>>> 2009-06-22 13:12:14 [5828] [0] PANIC: bearerbox(gw_panic+0xd4)
>>>>> [0x80d4674]
>>>>> 2009-06-22 13:12:14 [5828] [0] PANIC: bearerbox(dlr_init_mysql+0x359)
>>>>> [0x8063529]
>>>>> 2009-06-22 13:12:14 [5828] [0] PANIC: bearerbox(dlr_init+0x8b)
>>>>> [0x8061b2b]
>>>>> 2009-06-22 13:12:14 [5828] [0] PANIC: bearerbox(main+0x10a) [0x8054b5a]
>>>>> 2009-06-22 13:12:14 [5828] [0] PANIC:
>>>>> /lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe5) [0xb78e1775]
>>>>> 2009-06-22 13:12:14 [5828] [0] PANIC: bearerbox [0x8053f31]
>>>>>
>>>>> ----------------------------------------------------------------
>>>>>
>>>>> my configurations as related to mysql settings are:
>>>>>
>>>>> ----------------------------------------
>>>>> group = core
>>>>> admin-port = 13000
>>>>> smsbox-port = 13001
>>>>> admin-password = bar
>>>>> #admin-deny-ip = "*.*.*.*"
>>>>> #admin-allow-ip = ""
>>>>> log-file = "/home/malaikamkuu/kannel/bearerbox.log"
>>>>> log-level = 1
>>>>> #box-deny-ip = "*.*.*.*"
>>>>> #box-allow-ip = "127.0.0.1"
>>>>> #unified-prefix = "00358,0"
>>>>> store-type = spool
>>>>> store-location = "/home/malaikamkuu/kannel/spool"
>>>>> dlr-storage = mysql
>>>>>
>>>>> group = mysql-connection
>>>>> id = dlrdb
>>>>> host = localhost
>>>>> username = root
>>>>> password = password
>>>>> database = kannel
>>>>> max-connections = 5
>>>>>
>>>>>
>>>>> group = dlr-db
>>>>> id = dlrdb
>>>>> table = dlr
>>>>> field-smsc = smsc
>>>>> field-timestamp = ts
>>>>> field-destination = destination
>>>>> field-source = source
>>>>> field-service = service
>>>>> field-url = ""
>>>>> field-mask = mask
>>>>> field-status = status
>>>>> field-boxc-id = boxc
>>>>> ---------------------------------------
>>>>> i have the database up, i have created the database and the table and
>>>>> the fields, and i can access it using phpmyadmin, I can also access it
>>>>> using
>>>>> the terminal. But kannel gives me the above error
>>>>>
>>>>>
>>>>> My kannel environment is:
>>>>>
>>>>> Kannel bearerbox version `1.4.3'. Build `Feb 14 2009 16:26:23',
>>>>> compiler `4.3.3'. System Linux, release 2.6.28-11-generic, version
>>>>> #42-Ubuntu SMP Fri Apr 17 01:57:59 UTC 2009, machine i686. Hostname
>>>>> xps.tz,
>>>>> IP 127.0.1.1. Libxml version 2.6.32. Using OpenSSL 0.9.8g 19 Oct 2007.
>>>>> Compiled with MySQL 5.0.75, using MySQL 5.0.75. Using native malloc.
>>>>>
>>>>> Regards,
>>>>> Godfrey
>>>>
>>>>
>>>>
>>>> --
>>>> Donald Jackson
>>>> http://www.ddj.co.za/
>>>> donaldjster(a)gmail.com
>>>
>>
>
>
