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:[email protected]] Sent: 02 June 2011 11:06 To: Richard Crawshaw Cc: [email protected] 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. Regards, Richard Crawshaw Software Developer Contact Group Telephone (UK): 0844 448 442 Telephone (ROI): 0818 286 795 Mobile : 0786 625 9418 Direct Facsimile: 0844 448 9090 Email: [email protected] Web Site: http://www.contactgroup.com/ 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 [email protected] The Validity of any pricing information contained herein is 30 days unless otherwise stated. E & OE. Standard terms and conditions apply. Service by Contact Group. Registered in England No. 4125665. Registered office: Lonsdale House, 52 Blucher Street, Birmingham, B1 1QU. Data Protection No. Z7911829
<<inline: 111060213310704101.gif>>
dlr.conf
Description: dlr.conf
$ tsql -S sqlcluster -U kannel locale is "en_US.UTF-8" locale charset is "UTF-8" Password: 1> select * from dlrs 2> go smsc ts destination source service url mask status boxc 1> bye
