SOLVED!
Thanks to Mr. Kiran! =)
31.03.2011, в 17:33, Kiran Reddy написал(а):
> can you please check whether sqlbox is running or not or 13013 port is opened
> or not
>
> On Thursday 31 March 2011 07:01 PM, Pavel Ageev wrote:
>>
>> I've tried that.
>>
>> If i set sqlbox connect first to bearbox, then smppbox to ssqlbox - i'll
>> catch new problems
>> Sample from smppbox.log, when kannel-sqlbox-smpp configurated like u said
>>
>> 2011-03-31 17:24:08 [35410] [0] DEBUG: Started thread 45
>> (opensmppbox.c:function)
>> 2011-03-31 17:24:08 [35410] [45] DEBUG: Thread 45 (opensmppbox.c:function)
>> maps to pid 35410.
>> 2011-03-31 17:24:08 [35410] [45] INFO: Client connected from <[cut]>
>> 2011-03-31 17:24:08 [35410] [45] DEBUG: Connecting to <[cut]>
>> 2011-03-31 17:24:08 [35410] [45] ERROR: connect to <[cut]> failed
>> 2011-03-31 17:24:08 [35410] [45] ERROR: System error 61: Connection refused
>> 2011-03-31 17:24:08 [35410] [45] ERROR: error connecting to server `[cut]'
>> at port `1303'
>> 2011-03-31 17:24:08 [35410] [45] ERROR: opensmppbox: Failed to connect to
>> bearerbox.
>> 2011-03-31 17:24:08 [35410] [45] DEBUG: Thread 45 (opensmppbox.c:function)
>> terminates.
>>
>> 31.03.2011, в 17:12, Kiran Reddy написал(а):
>>
>>> Hi,
>>>
>>> Try this configuration.
>>>
>>>
>>> KANNEL.CONF
>>> #---------------------------------------------
>>> # CORE
>>> group = core
>>> admin-port = [cut]
>>> admin-allow-ip = [cut]
>>> smsbox-port = 13001
>>> admin-password = [cut]
>>> log-level = 0
>>> log-file = "/var/log/kannel/core.log"
>>> access-log = "/var/log/kannel/core-access.log"
>>> store-file = "/var/log/kannel/kannel.store.sms"
>>> #---------------------------------------------
>>> # SMSC CONNECTIONS
>>> #
>>> group = smsc
>>> smsc = smpp
>>> host = [cut]
>>> port = 3705
>>> smsc-id = "nevaline"
>>> allowed-smsc-id = "nevaline"
>>> system-type = "transceiver"
>>> smsc-username = [cut]
>>> smsc-password = [cut]
>>> transceiver-mode = true
>>> interface-version = 34
>>> source-addr-ton = 1
>>> source-addr-npi = 1
>>> dest-addr-ton = 1
>>> dest-addr-npi = 1
>>> bind-addr-ton = 1
>>> bind-addr-npi = 1
>>> address-range = ""
>>> enquire-link-interval = 30
>>> max-pending-submits = 5
>>> reconnect-delay = 30
>>> #---------------------------------------------
>>> # SMSBOX SETUP
>>> #
>>> group = smsbox
>>> smsbox-id = "main_box"
>>> bearerbox-host = localhost
>>> log-level = 0
>>> mo-recode = true
>>> log-file = "/var/log/kannel/smsbox.log"
>>> access-log = "/var/log/kannel/smsbox-access.log"
>>>
>>> #---------------------------------------------
>>> # SMSBOX ROUTE SETUP
>>> #
>>> #SMPPBOX-ROUTE.CONF
>>> #For example, routing for one of smpp client, connected to smppbox
>>> group = smsbox-route
>>> smsbox-id = main_box
>>> smsc-id = "nevaline"
>>> shortcode = "9690;9691;9693;9694;9696;9697"
>>>
>>> SQLBOX.CONF
>>> ------------------------
>>> group = sqlbox
>>> id = sqlbox-db
>>> smsbox-id = sqlbox
>>> bearerbox-host = localhost
>>> bearerbox-port = 13001
>>> smsbox-port = 1303
>>> smsbox-port-ssl = false
>>> sql-log-table = sent_sms
>>> sql-insert-table = send_sms
>>> log-file = "/var/log/kannel/kannel-sqlbox.log"
>>> log-level = 0
>>>
>>> # Example MYSQL Connection
>>> group = mysql-connection
>>> id = sqlbox-db
>>> host = [cut]
>>> port = 3306
>>> username = [cut]
>>> password = [cut]
>>> database = sqlbox
>>> max-connections = 1
>>>
>>> #---------------------------------------------
>>> # ROUTING INSIDE BEARERBOX
>>> #
>>> include = "/usr/local/etc/smppbox-route.conf"
>>>
>>> SMPPBOX.CONF
>>> group = core
>>> group = opensmppbox
>>> opensmppbox-id = "movable_redirect"
>>> opensmppbox-port = 2346
>>> bearerbox-host = localhost
>>> bearerbox-port = 1303
>>> log-level = 0
>>> log-file = "var/log/kannel/smppbox.log"
>>> our-system-id = "mova_redirect"
>>> use-systemid-as-smsboxid = true
>>> route-to-smsc = "nevaline"
>>> smpp-logins = "/usr/local/etc/kannelmain/smpplogins.txt"
>>>
>>> SMPPLOGINS.TXT
>>> hold all connection (its about 16 smpp clients)
>>>
>>> Regards,
>>> Kiran Reddy
>>>
>>> On Thursday 31 March 2011 06:14 PM, Pavel Ageev wrote:
>>>>
>>>> So no one can help in this question?
>>>> Even develop? =(
>>>>
>>>> 23.03.2011, в 14:57, Pavel Ageev написал(а):
>>>>
>>>>> Hi there
>>>>>
>>>>> I'v got some problems with configuring kannel with all addons
>>>>>
>>>>> First of all, today i have good working configuration
>>>>> SMSC<---> BB <---> SMPPBOX <---> SMPP CLIENTS
>>>>> Detailed:
>>>>> I have connection to real smsc, which have about 70 shortcodes. I receive
>>>>> all messages by that connection, and must route this packets to different
>>>>> smpp-clients according to shortcode (they all connected to our smppbox)
>>>>> Everything is going good... but i need to store all routed sms to my
>>>>> database. Of course, i found addon called sqlbox, but i dont understand
>>>>> how to configurate all this scheme, to catch up all incoming and outgoing
>>>>> messages by sqlbox, and only after that route them to smppbox, so i need
>>>>> SMSC<---> BB <---> SQLBOX <---> SMPPBOX <---> SMPP CLIENTS
>>>>>
>>>>> I, just try to configure my sqlbox as i saw in example, but sqlbox just
>>>>> connect to BB and dont receive any messages, they like always go through
>>>>> the smmppbox to clients (boxes)
>>>>>
>>>>> Plz, i really need help.
>>>>>
>>>>> As i know, you need to watch configs to help in problem
>>>>>
>>>>> KANNEL.CONF
>>>>> #---------------------------------------------
>>>>> # CORE
>>>>> #
>>>>> group = core
>>>>> admin-port = [cut]
>>>>> admin-allow-ip = [cut]
>>>>> smsbox-port = 13001
>>>>> admin-password = [cut]
>>>>> log-level = 0
>>>>> log-file = "/var/log/kannel/core.log"
>>>>> access-log = "/var/log/kannel/core-access.log"
>>>>> store-file = "/var/log/kannel/kannel.store.sms"
>>>>> #---------------------------------------------
>>>>> # SMSC CONNECTIONS
>>>>> #
>>>>> #--------------------
>>>>> # [cut] sms-center.Redirect
>>>>> #
>>>>> group = smsc
>>>>> smsc = smpp
>>>>> host = [cut]
>>>>> port = 3705
>>>>> smsc-id = "nevaline"
>>>>> allowed-smsc-id = "nevaline"
>>>>> system-type = "transceiver"
>>>>> smsc-username = [cut]
>>>>> smsc-password = [cut]
>>>>> transceiver-mode = true
>>>>> interface-version = 34
>>>>> source-addr-ton = 1
>>>>> source-addr-npi = 1
>>>>> dest-addr-ton = 1
>>>>> dest-addr-npi = 1
>>>>> bind-addr-ton = 1
>>>>> bind-addr-npi = 1
>>>>> address-range = ""
>>>>> enquire-link-interval = 30
>>>>> max-pending-submits = 5
>>>>> reconnect-delay = 30
>>>>> #---------------------------------------------
>>>>> # SMSBOX SETUP
>>>>> #
>>>>> group = smsbox
>>>>> smsbox-id = "main_box"
>>>>> bearerbox-host = [cut]
>>>>> log-level = 0
>>>>> mo-recode = true
>>>>> log-file = "/var/log/kannel/smsbox.log"
>>>>> access-log = "/var/log/kannel/smsbox-access.log"
>>>>> #---------------------------------------------
>>>>> # ROUTING INSIDE BEARERBOX
>>>>> #
>>>>> include = "/usr/local/etc/smppbox-route.conf"
>>>>>
>>>>> SMPPBOX.CONF
>>>>> group = core
>>>>> group = opensmppbox
>>>>> opensmppbox-id = "movable_redirect"
>>>>> opensmppbox-port = 2346
>>>>> bearerbox-host = [cut]
>>>>> bearerbox-port = 13001
>>>>> log-level = 0
>>>>> log-file = "var/log/kannel/smppbox.log"
>>>>> our-system-id = "mova_redirect"
>>>>> use-systemid-as-smsboxid = true
>>>>> route-to-smsc = "nevaline"
>>>>> smpp-logins = "/usr/local/etc/kannelmain/smpplogins.txt"
>>>>>
>>>>> SMPPLOGINS.TXT
>>>>> hold all connection (its about 16 smpp clients)
>>>>>
>>>>> SMPPBOX-ROUTE.CONF
>>>>> For example, routing for one of smpp client, connected to smppbox
>>>>> group = smsbox-route
>>>>> smsbox-id = [cut]
>>>>> smsc-id = "nevaline"
>>>>> shortcode = "9690;9691;9693;9694;9696;9697"
>>>>>
>>>>> SQLBOX.CONF
>>>>> group = sqlbox
>>>>> id = sqlbox-db
>>>>> smsbox-id = sqlbox
>>>>> bearerbox-host = [cut]
>>>>> bearerbox-port = 13001
>>>>> smsbox-port = 1303
>>>>> smsbox-port-ssl = false
>>>>> sql-log-table = sent_sms
>>>>> sql-insert-table = send_sms
>>>>> log-file = "/var/log/kannel/kannel-sqlbox.log"
>>>>> log-level = 0
>>>>>
>>>>> # Example MYSQL Connection
>>>>> group = mysql-connection
>>>>> id = sqlbox-db
>>>>> host = [cut]
>>>>> port = 3306
>>>>> username = [cut]
>>>>> password = [cut]
>>>>> database = sqlbox
>>>>> max-connections = 1
>>>>>
>>>>
>>>> ------------------------------------------
>>>> Pavel Ageev
>>>> Movable Сompany - Mobile content and Solutions
>>>>
>>>> mail: s...@movable.ru
>>>> web: www.movable.ru
>>>> skype: nawmem
>>>> work phone.: (812) 4480878 additional. 14
>>>>
>>>> Russia, Saint-Petersburg
>>>> Sedova Street, 11, 3rd floor, №313
>>>>
>>
>> ------------------------------------------
>> Pavel Ageev
>> Movable Сompany - Mobile content and Solutions
>>
>> mail: s...@movable.ru
>> web: www.movable.ru
>> skype: nawmem
>> work phone.: (812) 4480878 additional. 14
>>
>> Russia, Saint-Petersburg
>> Sedova Street, 11, 3rd floor, №313
>>
------------------------------------------
Pavel Ageev
Movable Сompany - Mobile content and Solutions
mail: s...@movable.ru
web: www.movable.ru
skype: nawmem
work phone.: (812) 4480878 additional. 14
Russia, Saint-Petersburg
Sedova Street, 11, 3rd floor, №313
