OK, that's better :) Have you configured the connection and field values properly? What about freetds.conf?
Try connecting with tsql and make sure that you can connect properly from that box using the parameters you configured on Kannel. You should be able to "use" the DB you configured and run the create scripts manually from tsql. You could also try raising freetds' log level and see if you get anything relevant there. Regards, Alex On Thu, Jun 2, 2011 at 2:31 PM, Richard Crawshaw < richard.craws...@the-contactgroup.com> wrote: > Alex > > > > I’ve redone the configure and make; FreeTDS has been detected and the make > lines now have -lct on them. I’m guessing that I failed to add the > --with-mssql switch on configure when I re-did it to capture the output; > at least that’s the most likely explanation, though I don’t know for > certain. > > > > However, the problem remains; though I have managed to patch the > executables with patchelf. > > http://nixos.org/patchelf.html > > > > Running ldd on bearerbox now gives the following: > > linux-gate.so.1 => (0x00661000) > > librt.so.1 => /lib/tls/i686/cmov/librt.so.1 (0x003a5000) > > libresolv.so.2 => /lib/tls/i686/cmov/libresolv.so.2 (0x007b8000) > > libnsl.so.1 => /lib/tls/i686/cmov/libnsl.so.1 (0x009d3000) > > libm.so.6 => /lib/tls/i686/cmov/libm.so.6 (0x006ee000) > > libpthread.so.0 => /lib/tls/i686/cmov/libpthread.so.0 (0x00374000) > > libxml2.so.2 => /usr/lib/libxml2.so.2 (0x00e8e000) > > * libct.so.4 => /usr/local/lib/libct.so.4 (0x00d56000)* > > libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0x0042b000) > > /lib/ld-linux.so.2 (0x00a94000) > > libdl.so.2 => /lib/tls/i686/cmov/libdl.so.2 (0x0089e000) > > libz.so.1 => /lib/libz.so.1 (0x00dab000) > > > > Everything now runs but the Bearerbox gives the following in the log file: > > 2011-06-02 12:16:01 [1383] [0] INFO: Kannel bearerbox II version 1.5.0 > starting > > 2011-06-02 12:16:01 [1383] [0] INFO: MAIN: Start-up done, entering mainloop > > 2011-06-02 12:16:24 [1383] [3] ERROR: ct_send() failed > > > > 2011-06-02 12:16:24 [1383] [3] ERROR: MSSQL: DB selection failed! > > 2011-06-02 12:16:24 [1383] [3] ERROR: ct_send() failed > > > > 2011-06-02 12:16:24 [1383] [3] ERROR: MSSQL: DB selection failed! > > 2011-06-02 12:16:24 [1383] [3] ERROR: ct_send() failed > > > > Those last two lines are repeated continually. I’m not able to get a > response on the status web-page and have to stop kannel by killing the > terminal window that it’s running in. Commenting out the external dlr > settings allows everything to run normally; re-instate them and it reverts > to not working. > > > > I’ve attached the dlr conf file. > > > > The core conf is below: > > # BEARERBOX SETUP > > group = core > > admin-port = 4001 > > smsbox-port = 4002 > > admin-password = ******* > > box-deny-ip = "*.*.*.*" > > box-allow-ip = "127.0.0.1;10.1.2.*" > > log-file = bearerbox.log > > log-level = 1 > > dlr-storage = mssql > > access-log = access.log > > > > Also attached is my connection through from the Kannel Ubuntu machine to > our MS SQL Server, using the FreeTDS tsql tool. > > > > Any pointers as to what the solution to this is would be gratefully > received. > > > > Once again, many thanks. > > > > Richard > > > > *From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com] > *Sent:* 02 June 2011 11:06 > > *To:* Richard Crawshaw > *Cc:* users@kannel.org > *Subject:* Re: Installing Kannel with mssql support > > > > Richard: > > > > checking whether to compile with FreeTDS Ct-Lib support... disabled > > Configure is not detecting FreeTDS and there's no -lct on the make lines. > > > > Somehow the system is fooled and it's not really finding the library and/or > the headers to link against it. > > > Kind regards, > > *Richard Crawshaw* > Software Developer > > > > [image: www.contactgroup.com] <http://www.contactgroup.com> > > *Contact Group* > Telephone (UK): 0844 448 442 > Telephone (ROI): 0818 286 795 > Mobile : 0786 625 9418 > Direct Facsimile: 0844 448 9090 > Email: richard.craws...@the-contactgroup.com > Web Site: www.the-contactgroup.com > Twitter: #contactgroup <http://twitter.com/#!/contactgroup> > > This e-mail is intended for the above named only. It may contain private > and confidential information or material that is privileged. If it has come > to you in error you must take no action based upon it, nor must you copy or > show it to anyone. Please return the message immediately to > postmas...@the-contactgroup.com The Validity of any pricing information > contained herein is 30 days unless otherwise stated. E & OE. Standard terms > and conditions apply. Service by Truancy Call Ltd. Registered in England No. > 4125665. Registered office: Lonsdale House, 52 Blucher Street, Birmingham, > B1 1QU. Data Protection No. Z7911829 Data Protection No. Z7911829 >
<<111060213310603801.gif>>
