Yes, opensmppbox can be connected to sqlbox. Just as any other smsbox is able to. See the comments of the other users on this thread.
== Rene -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Milan P. Stanic Sent: Tuesday, 07 August, 2012 12:17 To: [email protected] Subject: Re: [opensmppbox] SMSC rejected login to transmit (bind failed) On Tue, 2012-08-07 at 10:41, Christopher Burke wrote: > The opensmppbox appears in the bearerbox as an smsbox, therefore I So, it is connected to bearerbox and not to to SQLBox as you told in your previous e-mail. AFAIK opensmppbox cannot be connected to SQLBox. Please prove me wrong. If you connect it to bearerbox and connect SQLBox to bearerbox to, you can say that the opensmppbox and sqlbox are (inter)connected but opensmppbox does not know anything about sqlbox. I'm writing this mail not to bash you but to explain that the opensmppbox can only be connected to bearerbox, which is clearly depicted and described in (opensmppbox) documentation. > setup as I would an smsbox connected to a sqlbox. Configurations are > below; but if this is not how it's designed possibly I done something > wrong or I can expect some undesired results. > > *The opensmppbox configuration: * > cb@MOBILEWORKBOX:~$ sudo cat > /etc/kannel/internal/smppboxes/send_hsl/send/send.conf > ############################################################ > # KANNEL CONFIGURATION # > # Christopher Burke <[email protected]> # > ############################################################ > > include=/etc/kannel/internal/bearerboxes/send_hsl/send/send.conf > > ############################################################ > # SMPPBOX Connections # > ############################################################ > > group = opensmppbox > opensmppbox-id = send_hsl_smpp > opensmppbox-port = 12090 > bearerbox-host = localhost > bearerbox-port = *12005* > log-level = 0 > log-file = > /var/log/kannel/send_hsl/send/log_smppbox.log > our-system-id = send_hsl_smpp > route-to-smsc = send_hsl > smpp-logins = > /etc/kannel/internal/smppboxes/smpplogins.txt > box-dlr-storage = mysql > > ############################################################ > # mysql Connections # > ############################################################ > > group = mysql-connection > id = mydlr > host = localhost > username = root > password = root > database = SEND_HSL_SMPP > max-connections = 20 > > ############################################################ > # dlrmysql Connections # > ############################################################ > > group = dlr-db > id = mydlr > table = smppdlr > 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 = boxcid > > *The SQLBox Configuration:* > cb@MOBILEWORKBOX:~$ sudo cat > /etc/kannel/internal/sqlboxes/send_hsl/send/send.conf > ############################################################ > # KANNEL CONFIGURATION # > # Christopher Burke <[email protected]> # > ############################################################ > > ############################################################ > # SQLBOX GROUP # > ############################################################ > > group = sqlbox > id = send_sqlbox > smsbox-id = send_sqlbox > bearerbox-host = localhost > bearerbox-port = *12001* > smsbox-port = *12005* > smsbox-port-ssl = false > sql-log-table = sent_sms > sql-insert-table = send_sms > log-file = > /var/log/kannel/send_hsl/send/log_sqlbox.log > log-level = 0 > > group = mysql-connection > id = send_sqlbox > host = localhost > username = root > password = root > database = SEND_HSL_SQLBOX > > *The SMPP/SMSC/Bearerbox configuration:* cb@MOBILEWORKBOX:~$ sudo cat > /etc/kannel/internal/bearerboxes/send_hsl/send/send.conf > ############################################################ > # KANNEL CONFIGURATION # > # Christopher Burke <[email protected]> # > ############################################################ > > group = smsbox > > ############################################################ > # CORE GROUP # > ############################################################ > > group = core > admin-port = 12000 > smsbox-port = *12001* > admin-password = foobarz > log-file = > /var/log/kannel/send_hsl/send/log_bearerbox.log > access-log = > /var/log/kannel/send_hsl/send/acc_bearerbox.log > log-level = 0 > box-deny-ip = "*.*.*.*" > box-allow-ip = "*.*.*.*" > > ############################################################ > # SMSC GROUP # > ############################################################ > > group = smsc > smsc = smpp > smsc-id = send_hsl > host = a.b.c.d > port = abcd > transceiver-mode = false > smsc-username = "foo" > smsc-password = "bar" > system-type = "SMPP" > address-range = "12345678901" > source-addr-ton = 1 > source-addr-npi = 1 > dest-addr-ton = 1 > dest-addr-npi = 1 > bind-addr-ton = 1 > bind-addr-npi = 1 > > > On 07/08/12 10:27, Milan P. Stanic wrote: > >On Tue, 2012-08-07 at 09:57, Christopher Burke wrote: > >>Hi Guys, > >> > >>Just thought I'd wrap up on this issue as it's now solved. > >> > >>1. You can connect an OpenSMPPBox to a SQLBox > >If that is true then Rene (Kluwen) should update opensmppbox > >documetation with the description of SQLBox parameters and update > >diagram in SMPPBox.png > > > >>2. The reason I could not connect was because I had the "vma" string > >>as lower case in the smpplogins file, but upper case in the > >>configuration file > >Could you post your config section where you define 'SQLBox' > >parameters, please? > > > >>Thanks again! > >> > >>Chris > >> > >>On 03/08/12 17:51, Milan P. Stanic wrote: > >>>On Fri, 2012-08-03 at 17:05, Christopher Burke wrote: > >>>>Hi, > >>>> > >>>>Using the latest from SVN - perhaps I'll try to add the VMA into > >>>>the smpplogins.txt and see if that works. > >>>> > >>>>Are you communicating directly to the bearerbox or to a sqlbox? > >>>Is it possible for opensmppbox to communicate/connect anything than > >>>bearerbox? > >>>>Kind Regards and Thanks in Advance, > >>>> > >>>>Chris > >>>> > >>>>On 03/08/12 16:10, Milan P. Stanic wrote: > >>>>>On Fri, 2012-08-03 at 14:42, Christopher Burke wrote: > >>>>>>Thanks for your response. My smpplogins is as follows: > >>>>>> > >>>>>>username internal 127.0.0.1 > >>>>>Which version of the opensmppbox you use? > >>>>> > >>>>>I have next line in my smpplogings.txt file: > >>>>>xxxx yyyy vma 127.0.0.1 > >>>>>where xxxx is username and yyyy is password. > >>>>> > >>>>>>-rw-rw-rw- 1 root root 28 Aug 3 14:40 smpplogins.txt > >>>>>> > >>>>>>Does this look okay to you? > >>>>>> > >>>>>>Kind Regards, > >>>>>> > >>>>>>Christopher > >>>>>> > >>>>>>On 03/08/12 10:48, Artem Chekulaev wrote: > >>>>>>>Hi > >>>>>>> > >>>>>>>I had the same issue. Try to delete your smpplogins.txt (or > >>>>>>>where you store your logins) and create it again from emtpy and > >>>>>>>fill it carefully, not from example. In my case it was > >>>>>>>rights-to-read-file issue too - Kannel had no rights to any > >>>>>>>access that file > >>>>>>> > >>>>>>>2012/8/3 Christopher Burke <[email protected] > >>>>>>><mailto:[email protected]>> > >>>>>>> > >>>>>>> Hi, > >>>>>>> > >>>>>>> I've been attempting to connect an opensmppbox to my > >>>>>>> configuration, however I am getting the following errors: > >>>>>>> > >>>>>>> 2012-08-03 10:19:06 [10282] [6] ERROR: SMPP[recv_smpp]: SMSC > >>>>>>> rejected login to transmit, code 0x0000000d (Bind Failed). > >>>>>>> 2012-08-03 10:19:06 [10282] [6] ERROR: SMPP[recv_smpp]: Couldn't > >>>>>>> connect to SMS center (retrying in 10 seconds). > >>>>>>> > >>>>>>> What is a likely cause of this issue? I can post my configuration > >>>>>>> files and detailed logs if needed. > >>>>>>> > >>>>>>> Kind Regards and Thanks in Advance, > >>>>>>> > >>>>>>> Chris > >>>>>>> > >>>>-- > >>>>*Christopher Burke* > >>>>Development Team Leader / Software Engineer http://simulity.com > >>>>Mobile: +44 7590 571 833 > >>>>Skype:krslynx > >>>>NOTICE: This message contains privileged & confidential > >>>>information intended only for the use of the addressee named > >>>>above. If you are not the intended recipient of this message, you > >>>>are hereby notified that you must not disseminate, copy or take > >>>>any action in reliance on it. If you have received this message in > >>>>error, please notify Simulity Labs immediately. Any views > >>>>expressed in this message are those of the individual sender > >>>>except where the sender specifically states them to be the view of > >>>>Simulity Labs > >>-- > >>*Christopher Burke* > >>Development Team Leader / Software Engineer http://simulity.com > >>Mobile: +44 7590 571 833 > >>Skype:krslynx > >>NOTICE: This message contains privileged & confidential information > >>intended only for the use of the addressee named above. If you are > >>not the intended recipient of this message, you are hereby notified > >>that you must not disseminate, copy or take any action in reliance > >>on it. If you have received this message in error, please notify > >>Simulity Labs immediately. Any views expressed in this message are > >>those of the individual sender except where the sender specifically > >>states them to be the view of Simulity Labs > > -- > *Christopher Burke* > Development Team Leader / Software Engineer http://simulity.com > Mobile: +44 7590 571 833 > Skype:krslynx > NOTICE: This message contains privileged & confidential information > intended only for the use of the addressee named above. If you are not > the intended recipient of this message, you are hereby notified that > you must not disseminate, copy or take any action in reliance on it. > If you have received this message in error, please notify Simulity > Labs immediately. Any views expressed in this message are those of the > individual sender except where the sender specifically states them to > be the view of Simulity Labs -- Kind regards, Milan -------------------------------------------------- Arvanta, http://www.arvanta.net Please do not send me e-mail containing HTML code or documents in proprietary format (word, excel, pps and so on)
