Hi,

It should be obvious. In group core you specify:

smsbox-port = 13003

and yet in group sqlbox you specify:

bearerbox-port = 13001

Those 2 should match. sqlbox connects to bearerbox as another smsbox.

BR,
Nikos

On Thu, Jun 16, 2011 at 2:58 AM, Michael vd Poel <[email protected]> wrote:

> Hi all,
>
> When I kick off sqlbox (on CentOS), it doesn't connect.
> The kannel-sqlbox.log says:
>
> 2011-06-15 22:45:37 [15745] [0] INFO:
> MYSQL: server version 5.0.92-community,client version 5.0.92.
> 2011-06-15 22:45:37 [15745] [0] DEBUG:
> Started thread 1 (sqlbox.c:sql_to_bearerbox)
> 2011-06-15 22:45:37 [15745] [1] DEBUG:
> Thread 1 (sqlbox.c:sql_to_bearerbox) maps to pid 15745.
> 2011-06-15 22:45:37 [15745] [1] DEBUG:
> Connecting to <127.0.0.1>
> 2011-06-15 22:45:37 [15745] [1] ERROR:
> connect to <127.0.0.1> failed
> 2011-06-15 22:45:37 [15745] [1] ERROR:
> System error 111: Connection refused
> 2011-06-15 22:45:37 [15745] [1] ERROR:
> error connecting to server `localhost' at port `13001'
> 2011-06-15 22:45:37 [15745] [1] DEBUG:
> Thread 1 (sqlbox.c:sql_to_bearerbox) terminates.
>
> The MySQL connection seems to be fine.
> I believe, that somehow the ports as defined in the conf files cause a
> conflict.
> This is my kannel-sqlbox.conf file:
>
> “group = sqlbox
> id = sqlbox-db
> smsbox-id = sqlbox
> global-sender = ""
> bearerbox-host = localhost
> bearerbox-port = 13001
> smsbox-port = 13005
> 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
> group=mysql-connection
> id =sqlbox-db
> host = localhost
> username = gebruiker
> password = password
> database = tekstberichten”
>
>
> My main config file is:
>
> "group = core
> admin-port = 13000
> admin-password = bar
> admin-deny-ip = "*.*.*.*"
> admin-allow-ip = "127.0.0.1"
> smsbox-port = 13003
> log-file = "/var/log/kannel/bearerbox.log"
> box-deny-ip = "*.*.*.*"
> box-allow-ip = "127.0.0.1"
> dlr-storage=mysql
> log-level=0
>
> group = smsbox
> bearerbox-host="localhost"
> sendsms-port = 13013
> sendsms-chars = "+0123456789"
> log-file = "/var/log/kannel/smsbox.log"
> log-level = 0
> access-log = "/var/log/kannel/access.log"
> log-level = 0
> mo-recode = 1
>
> group = smsc
> smsc = smpp
> smsc-id = smpp
> host = msg1.smpp.com
> port = 8000
> receive-port = 8000
>
> transceiver-mode = false
> throughput = 10
> smsc-username = gebruiker
> smsc-password = paswoord
> system-type = 9ca36c15
> dest-addr-ton=1
> log-file = "/var/log/kannel/smpp.log"
> log-level = 0
> msg-id-type=0x01
> enquire-link-interval = 30
>
> group = sendsms-user
> username = username
> password = pwd
> forced-smsc =  smpp
>
> name = users
> user-deny-ip = "*.*.*.*"
> user-allow-ip = "127.0.0.1"
> max-messages = 3
> concatenation = 1
> omit-empty = 1
>
> # DLR SETUP
> #mysql connection
>
> group = mysql-connection
> id = mydlr
> host = localhost
> username = gebruiker
> password = password
> database = sms
> max-connections = 10
>
> group = dlr-db
> id = mydlr
> table=log
> field-smsc=smsc
> field-timestamp=timestamp
> field-destination=destination
> field-source=source
> field-service=service
> field-url=url
> field-mask=mask
> field-status=status
> field-boxc-id=boxc_id"
>
> Would anyone be able to help me get on track?
>
> Thanks in advance!
>
>
> Michael
>
>
>
>

Reply via email to