Ops, missed the attachment, you already checked that :P Ok, try raising the log level then.
Regards, Alex On Thu, Jun 2, 2011 at 3:06 PM, Alejandro Guerrieri < [email protected]> wrote: > 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 < > [email protected]> 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:[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. >> >> >> 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: [email protected] >> 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 >> [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 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>>
