May 2014 - FreeSWITCH-users - FreeSWITCH Mailing Lists

How to extract B-Leg cdrs after call hangup
by HardikPatel 22 May '14

22 May '14

Hi all I am fresher for freeswitch and i just want to know is there any posiblity to extract B-leg cdrs data using mod_xml_curl and mod_xm_cdrs module. My actuall problem is when my call is hangup i am getting A-Leg cdrs data to process but in A-Leg data i am getting wrong values for billseconds and duration variables but in B-Leg data i am getting actual data that i want. So is there any posiblity to extract that cdrs using any variable or some another way? Thanks in Advance Hardik Patel -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/How-to-extract-B-Leg-cdrs-aft… Sent from the freeswitch-users mailing list archive at Nabble.com.

2 1

Quirks with pickup/$1
by Francis 22 May '14

22 May '14

Hi all, I've been testing pickup/ with groups and individual endpoints, which works well, except: 1. When setting BLF keys for group pickup, the status shows as 'in use', not ringing. This prevents the phones (Yealink T28P) from activating their directed pickup feature. 2. Individual phones can only be picked up if the call is directly from a single caller. If the call comes via a call group, attempts to pick up individual phones fail and the group pickup extension must be used instead. 3. Conversely, calls that are blind transferred to a call group can be picked up via group pickup, but attended transfers cannot. Obviously, an unanswered attended transfer is an oxymoron, but if the phones are configured to allow attended transfers then the user could easily create such a situation. I tested this on stable as well as git master, the behavior is the same. I'll see what I can dig out of the logs tomorrow, when my eyes aren't so red. Any hints in the meantime as to how I can make the behavior more consistent would be greatly received! Francis

1 0

Questions about bridge pattern and variables captured by conditions
by Iskren Hadzhinedev 22 May '14

22 May '14

Hello, I'm having some trouble understanding a couple of things. First is what's the difference between: <action application="bridge" data="sofia/local/1000(a)sip.test.com"/> and <action application="bridge" data="sofia/sip.test.com/1000"/> ? The other question: With these dialplan rules: <condition field="${destination_number}" expression="^([0-9]{6})$"/> <condition field="${toll_allow}" expression="local"> <action application="set" data="hangup_after_bridge=true"/> <action application="bridge" data="sofia/gateway/${default_gateway}/$1"/> <anti-action application="answer"/> <anti-action application="speak" data="Local calls are not allowed!"/> </condition> The variable $1 doesn't get expanded to the captured expression. Is it possible to retain it somehow without setting a temporary variable? Thanks! Kind regards, -- Iskren Hadzhinedev

2 2

FS behind NAT issue
by Neo Haux 21 May '14

21 May '14

Hi, I am trying to use my FS behind a NAT with SIP soft from Internet. So I have this setup: FS:192.168.2.110 ------ ROUTER (IP=70.70.70.70=myhost.no-ip.info) ----- SIP phone (SIP:/24.114.103.245/) I followed the wiki (http://wiki.freeswitch.org/wiki/NAT_Traversal) and updated these files: external.xml: <param name="ext-sip-ip" value="70.70.70.70"/> <param name="ext-rtp-ip" value="70.70.70.70"/> vars.xml: <X-PRE-PROCESS cmd="set" data="bind_server_ip=/myhost.no-ip.info/"/> When I try to register with the external SIP phone I get this error: /2014-05-21 12:47:54.843521 [WARNING] sofia_reg.c:2566 Can't find user [1001(a)myhost.no-ip.info] from 24.114.103.245/ /You must define a domain called 'myhost.no-ip.info' in your directory and add a user with the id="1001" attribute/ /and you must configure your device to use the proper domain in it's authentication credentials./ I don't have a multi-tennant setup, only one domain. I use this FS also for SIP device in the same LAN *freeswitch@internal> eval ${domain}** **192.168.2.110* I am missing something ? Any suggestion is welcome! Thank you in advance.

2 1

FS + Gtalk + pygtalkrobot + hangout
by Yuriy Nasida 21 May '14

21 May '14

Hello guys, First I would like to thank you for this perfect manual https://wiki.freeswitch.org/wiki/Mod_dingaling But... I got some problems with auto accepting of friend requests from customers. I know that this fs module doesn't do this type of work. I also saw in mail-list history that some people try to use pygtalkrobot for such cases. Um... I really tried this method but pygtalkrobot works not stable. Sometimes it accept, sometimes not. Not sure why. Do anybody know better method for auto accepting ? Also, do anybody know if we able to use this module with new google feature - hangout (it works with video calls only). Please advice Thanks.

1 0

Need help to stop this hack into FreeSwitch!
by Mario G 21 May '14

21 May '14

Someone has gotten into my FreeSwitch, my firewall is set to only allow SIP traffic from my ITSP, and I added a rule to block the bad address but it did not work so I am baffled. It looks like 85.25.198.253 (Germany) is making a call to me and trying to call out. I would really appreciate any ideas on what kind of general FW rule to add to prevent this, I don’t know what is going on. Next I’ll run PCAPs. I was thinking of a rule to block all outgoing SIP traffic except to the ITSP. Would appreciate help, especially an explanation of what they are trying to do in FS. Mario G * Started May 19 8am, goes through all 7 sip accounts every 10 seconds * Each time it starts at extension 1000, goes through all 7 accounts, then waits 10 seconds, the extension is incremented by 1 and goes through all 7 accounts, this repeats until finally stopping at extension 9010, then starts at a different time of day hours later. * My account is itsp1 and itsp2, there are 5 more but I cut them out to reduce this. * 1.2.3.4 is my public wan address. * They look like 85.25.198.253, but blocking that in the FW does not help. Odd since I have done that before and it worked. * The "processing 4003 <4003>->+972592406392” is baffling. This is a short/reduced snippet from the log: 2014-05-19 17:02:23.827470 [NOTICE] switch_channel.c:1054 New Channel sofia/itsp1/4003(a)1.2.3.4 [2837a51d-b25d-4b42-9fd9-f5b772d93f70] 2014-05-19 17:02:23.827470 [DEBUG] switch_core_session.c:1052 Send signal sofia/itsp1/4003(a)1.2.3.4 [BREAK] 2014-05-19 17:02:23.827470 [DEBUG] switch_core_state_machine.c:467 (sofia/itsp1/4003(a)1.2.3.4) Running State Change CS_NEW 2014-05-19 17:02:23.827470 [DEBUG] switch_core_session.c:1052 Send signal sofia/itsp1/4003(a)1.2.3.4 [BREAK] 2014-05-19 17:02:23.827470 [DEBUG] sofia.c:8334 sofia/itsp1/4003(a)1.2.3.4 receiving invite from 85.25.198.253:5074 version: 1.5.13b git 285e7dc 2014-05-19 17:38:09Z 64bit 2014-05-19 17:02:23.827470 [DEBUG] sofia.c:6200 Channel sofia/itsp1/4003(a)1.2.3.4 entering state [received][100] 2014-05-19 17:02:23.827470 [DEBUG] sofia.c:6210 Remote SDP: v=0 o=sipcli-Session 1785091527 1239589188 IN IP4 85.25.198.253 s=sipcli c=IN IP4 85.25.198.253 t=0 0 m=audio 5075 RTP/AVP 18 0 8 101 a=rtpmap:18 G729/8000 a=rtpmap:0 PCMU/8000 a=rtpmap:8 PCMA/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-15 a=ptime:20 2014-05-19 17:02:23.827470 [DEBUG] switch_core_media.c:3437 Audio Codec Compare [PCMA:8:8000:20:64000] ++++ is saved as a match 2014-05-19 17:02:23.827470 [DEBUG] switch_core_media.c:3383 Audio Codec Compare [PCMA:8:8000:20:64000]/[GSM:3:8000:20:13200] 2014-05-19 17:02:23.827470 [DEBUG] switch_core_media.c:3309 Set telephone-event payload to 101 2014-05-19 17:02:23.827470 [DEBUG] switch_core_media.c:2343 Set Codec sofia/itsp1/4003(a)1.2.3.4 PCMU/8000 20 ms 160 samples 64000 bits 2014-05-19 17:02:23.827470 [DEBUG] switch_core_codec.c:111 sofia/itsp1/4003(a)1.2.3.4 Original read codec set to PCMU:0 2014-05-19 17:02:23.827470 [DEBUG] switch_core_media.c:3626 Set 2833 dtmf send/recv payload to 101 2014-05-19 17:02:23.827470 [DEBUG] sofia.c:6485 (sofia/itsp1/4003(a)1.2.3.4) State Change CS_NEW -> CS_INIT 2014-05-19 17:02:23.827470 [DEBUG] switch_core_session.c:1387 Send signal sofia/itsp1/4003(a)1.2.3.4 [BREAK] 2014-05-19 17:02:23.827470 [DEBUG] switch_core_state_machine.c:486 (sofia/itsp1/4003(a)1.2.3.4) State NEW 2014-05-19 17:02:23.827470 [DEBUG] switch_core_state_machine.c:467 (sofia/itsp1/4003(a)1.2.3.4) Running State Change CS_INIT 2014-05-19 17:02:23.827470 [DEBUG] switch_core_state_machine.c:507 (sofia/itsp1/4003(a)1.2.3.4) State INIT 2014-05-19 17:02:23.827470 [DEBUG] mod_sofia.c:87 sofia/itsp1/4003(a)1.2.3.4 SOFIA INIT 2014-05-19 17:02:23.827470 [DEBUG] switch_core_state_machine.c:40 sofia/itsp1/4003(a)1.2.3.4 Standard INIT 2014-05-19 17:02:23.827470 [DEBUG] switch_core_state_machine.c:48 (sofia/itsp1/4003(a)1.2.3.4) State Change CS_INIT -> CS_ROUTING 2014-05-19 17:02:23.827470 [DEBUG] switch_core_session.c:1387 Send signal sofia/itsp1/4003(a)1.2.3.4 [BREAK] 2014-05-19 17:02:23.827470 [DEBUG] switch_core_state_machine.c:507 (sofia/itsp1/4003(a)1.2.3.4) State INIT going to sleep 2014-05-19 17:02:23.827470 [DEBUG] switch_core_state_machine.c:467 (sofia/itsp1/4003(a)1.2.3.4) Running State Change CS_ROUTING 2014-05-19 17:02:23.827470 [DEBUG] switch_channel.c:2178 (sofia/itsp1/4003(a)1.2.3.4) Callstate Change DOWN -> RINGING 2014-05-19 17:02:23.827470 [DEBUG] switch_core_state_machine.c:523 (sofia/itsp1/4003(a)1.2.3.4) State ROUTING 2014-05-19 17:02:23.827470 [DEBUG] mod_sofia.c:123 sofia/itsp1/4003(a)1.2.3.4 SOFIA ROUTING 2014-05-19 17:02:23.827470 [DEBUG] switch_core_state_machine.c:164 sofia/itsp1/4003(a)1.2.3.4 Standard ROUTING 2014-05-19 17:02:23.827470 [INFO] mod_dialplan_xml.c:558 Processing 4003 <4003>->+972592406392 in context public Dialplan: sofia/itsp1/4003(a)1.2.3.4 parsing [public->unloop] continue=false Dialplan: sofia/itsp1/4003(a)1.2.3.4 Regex (PASS) [unloop] ${unroll_loops}(true) =~ /^true$/ break=on-false Dialplan: sofia/itsp1/4003(a)1.2.3.4 Regex (FAIL) [unloop] ${sip_looped_call}() =~ /^true$/ break=on-false Dialplan: sofia/itsp1/4003(a)1.2.3.4 parsing [public->outside_call] continue=true Dialplan: sofia/itsp1/4003(a)1.2.3.4 Absolute Condition [outside_call] Dialplan: sofia/itsp1/4003(a)1.2.3.4 Action set(outside_call=true) Dialplan: sofia/itsp1/4003(a)1.2.3.4 Action export(RFC2822_DATE=${strftime(%a, %d %b %Y %T %z)}) Dialplan: sofia/itsp1/4003(a)1.2.3.4 parsing [public->call_debug] continue=true Dialplan: sofia/itsp1/4003(a)1.2.3.4 Regex (FAIL) [call_debug] ${call_debug}(false) =~ /^true$/ break=never Dialplan: sofia/itsp1/4003(a)1.2.3.4 parsing [public->public_extensions] continue=false Dialplan: sofia/itsp1/4003(a)1.2.3.4 Regex (FAIL) [public_extensions] destination_number(+972592406392) =~ /^([1-2][0-1][0-3])$/ break=on-false ………. deleted lines Dialplan: sofia/itsp1/4003(a)1.2.3.4 Regex (FAIL) [itsp1_did] destination_number(+972592406392) =~ /^(1212121212121)$/ break=on-false Dialplan: sofia/itsp1/4003(a)1.2.3.4 parsing [public->itsp2_did] continue=false Dialplan: sofia/itsp1/4003(a)1.2.3.4 Regex (FAIL) [itsp2_did] destination_number(+972592406392) =~ /^(1313131313131)$/ break=on-false 2014-05-19 17:02:23.827470 [DEBUG] switch_core_state_machine.c:214 (sofia/itsp1/4003(a)1.2.3.4) State Change CS_ROUTING -> CS_EXECUTE 2014-05-19 17:02:23.827470 [DEBUG] switch_core_session.c:1387 Send signal sofia/itsp1/4003(a)1.2.3.4 [BREAK] 2014-05-19 17:02:23.827470 [DEBUG] switch_core_state_machine.c:523 (sofia/itsp1/4003(a)1.2.3.4) State ROUTING going to sleep 2014-05-19 17:02:23.827470 [DEBUG] switch_core_state_machine.c:467 (sofia/itsp1/4003(a)1.2.3.4) Running State Change CS_EXECUTE 2014-05-19 17:02:23.827470 [DEBUG] switch_core_state_machine.c:530 (sofia/itsp1/4003(a)1.2.3.4) State EXECUTE 2014-05-19 17:02:23.827470 [DEBUG] mod_sofia.c:178 sofia/itsp1/4003(a)1.2.3.4 SOFIA EXECUTE 2014-05-19 17:02:23.827470 [DEBUG] switch_core_state_machine.c:256 sofia/itsp1/4003(a)1.2.3.4 Standard EXECUTE EXECUTE sofia/itsp1/4003(a)1.2.3.4 set(outside_call=true) 2014-05-19 17:02:23.827470 [DEBUG] mod_dptools.c:1435 sofia/itsp1/4003(a)1.2.3.4 SET [outside_call]=[true] EXECUTE sofia/itsp1/4003(a)1.2.3.4 export(RFC2822_DATE=Mon, 19 May 2014 17:02:23 -0700) 2014-05-19 17:02:23.827470 [DEBUG] switch_channel.c:1246 EXPORT (export_vars) [RFC2822_DATE]=[Mon, 19 May 2014 17:02:23 -0700] 2014-05-19 17:02:23.827470 [NOTICE] switch_core_state_machine.c:313 sofia/itsp1/4003(a)1.2.3.4 has executed the last dialplan instruction, hanging up. 2014-05-19 17:02:23.827470 [NOTICE] switch_core_state_machine.c:315 Hangup sofia/itsp1/4003(a)1.2.3.4 [CS_EXECUTE] [NORMAL_CLEARING] 2014-05-19 17:02:23.827470 [DEBUG] switch_channel.c:3216 Send signal sofia/itsp1/4003(a)1.2.3.4 [KILL] 2014-05-19 17:02:23.827470 [DEBUG] switch_core_session.c:1387 Send signal sofia/itsp1/4003(a)1.2.3.4 [BREAK] 2014-05-19 17:02:23.827470 [DEBUG] switch_core_state_machine.c:530 (sofia/itsp1/4003(a)1.2.3.4) State EXECUTE going to sleep 2014-05-19 17:02:23.827470 [DEBUG] switch_core_state_machine.c:467 (sofia/itsp1/4003(a)1.2.3.4) Running State Change CS_HANGUP 2014-05-19 17:02:23.827470 [DEBUG] switch_core_state_machine.c:730 (sofia/itsp1/4003(a)1.2.3.4) Callstate Change RINGING -> HANGUP 2014-05-19 17:02:23.846717 [DEBUG] switch_core_state_machine.c:732 (sofia/itsp1/4003(a)1.2.3.4) State HANGUP 2014-05-19 17:02:23.846717 [DEBUG] mod_sofia.c:413 Channel sofia/itsp1/4003(a)1.2.3.4 hanging up, cause: NORMAL_CLEARING 2014-05-19 17:02:23.846717 [DEBUG] mod_sofia.c:547 Responding to INVITE with: 480 2014-05-19 17:02:23.846717 [DEBUG] switch_core_state_machine.c:58 sofia/itsp1/4003(a)1.2.3.4 Standard HANGUP, cause: NORMAL_CLEARING 2014-05-19 17:02:23.846717 [DEBUG] switch_core_state_machine.c:732 (sofia/itsp1/4003(a)1.2.3.4) State HANGUP going to sleep 2014-05-19 17:02:23.846717 [DEBUG] switch_core_state_machine.c:499 (sofia/itsp1/4003(a)1.2.3.4) State Change CS_HANGUP -> CS_REPORTING 2014-05-19 17:02:23.846717 [DEBUG] switch_core_session.c:1387 Send signal sofia/itsp1/4003(a)1.2.3.4 [BREAK] 2014-05-19 17:02:23.846717 [DEBUG] switch_core_state_machine.c:467 (sofia/itsp1/4003(a)1.2.3.4) Running State Change CS_REPORTING 2014-05-19 17:02:23.846717 [DEBUG] switch_core_state_machine.c:818 (sofia/itsp1/4003(a)1.2.3.4) State REPORTING 2014-05-19 17:02:23.846717 [DEBUG] switch_core_state_machine.c:102 sofia/itsp1/4003(a)1.2.3.4 Standard REPORTING, cause: NORMAL_CLEARING 2014-05-19 17:02:23.846717 [DEBUG] switch_core_state_machine.c:818 (sofia/itsp1/4003(a)1.2.3.4) State REPORTING going to sleep 2014-05-19 17:02:23.846717 [DEBUG] switch_core_state_machine.c:493 (sofia/itsp1/4003(a)1.2.3.4) State Change CS_REPORTING -> CS_DESTROY 2014-05-19 17:02:23.846717 [DEBUG] switch_core_session.c:1387 Send signal sofia/itsp1/4003(a)1.2.3.4 [BREAK] 2014-05-19 17:02:23.846717 [DEBUG] switch_core_session.c:1604 Session 234 (sofia/itsp1/4003(a)1.2.3.4) Locked, Waiting on external entities 2014-05-19 17:02:23.846717 [NOTICE] switch_core_session.c:1622 Session 234 (sofia/itsp1/4003(a)1.2.3.4) Ended 2014-05-19 17:02:23.846717 [NOTICE] switch_core_session.c:1626 Close Channel sofia/itsp1/4003(a)1.2.3.4 [CS_DESTROY] 2014-05-19 17:02:23.846717 [DEBUG] switch_core_state_machine.c:618 (sofia/itsp1/4003(a)1.2.3.4) Callstate Change HANGUP -> DOWN 2014-05-19 17:02:23.846717 [DEBUG] switch_core_state_machine.c:621 (sofia/itsp1/4003(a)1.2.3.4) Running State Change CS_DESTROY 2014-05-19 17:02:23.846717 [DEBUG] switch_core_state_machine.c:631 (sofia/itsp1/4003(a)1.2.3.4) State DESTROY 2014-05-19 17:02:23.846717 [DEBUG] mod_sofia.c:323 sofia/itsp1/4003(a)1.2.3.4 SOFIA DESTROY 2014-05-19 17:02:23.846717 [DEBUG] switch_core_state_machine.c:109 sofia/itsp1/4003(a)1.2.3.4 Standard DESTROY 2014-05-19 17:02:23.846717 [DEBUG] switch_core_state_machine.c:631 (sofia/itsp1/4003(a)1.2.3.4) State DESTROY going to sleep 2014-05-19 17:02:25.107472 [NOTICE] switch_channel.c:1054 New Channel sofia/itsp1/4003(a)1.2.3.4 [364bd3e4-2c4b-4412-b259-10cfb0b6c391] 2014-05-19 17:02:25.107472 [DEBUG] switch_core_session.c:1052 Send signal sofia/itsp1/4003(a)1.2.3.4 [BREAK] 2014-05-19 17:02:25.107472 [DEBUG] switch_core_state_machine.c:467 (sofia/itsp1/4003(a)1.2.3.4) Running State Change CS_NEW 2014-05-19 17:02:25.107472 [DEBUG] switch_core_session.c:1052 Send signal sofia/itsp1/4003(a)1.2.3.4 [BREAK] 2014-05-19 17:02:25.107472 [DEBUG] sofia.c:8334 sofia/itsp1/4003(a)1.2.3.4 receiving invite from 85.25.198.253:5084 version: 1.5.13b git 285e7dc 2014-05-19 17:38:09Z 64bit 2014-05-19 17:02:25.107472 [DEBUG] sofia.c:6200 Channel sofia/itsp1/4003(a)1.2.3.4 entering state [received][100] 2014-05-19 17:02:25.107472 [DEBUG] sofia.c:6210 Remote SDP: v=0 o=sipcli-Session 17343503 2124966596 IN IP4 85.25.198.253 s=sipcli c=IN IP4 85.25.198.253 t=0 0 m=audio 5085 RTP/AVP 18 0 8 101 a=rtpmap:18 G729/8000 a=rtpmap:0 PCMU/8000 a=rtpmap:8 PCMA/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-15 a=ptime:20 2014-05-19 17:02:25.107472 [DEBUG] switch_core_media.c:3383 Audio Codec Compare [G729:18:8000:20:8000]/[G722:9:8000:20:64000]

11 15

Reminder! FreeSWITCH Weekly Conference Call Today 1PM EDT 1700 GMT
by Ken Rice 21 May '14

21 May '14

Hey Guys, Just a reminder, Today ClueCon Weekly! 1PM EDT, 1700 GMT Todays Topic: ClueCon Speakers Preview and Community Scrum. How to Access: sip:888@conference.freeswitch.org, +1.919.386.9900 via the US PSTN or http://wiki.freeswitch.org/wiki/Weekly_Conference_Call_Calling_Instructions for other access methods around the world! If you havent Registered for ClueCon don¹t let your chance for 16 extra entries to the door prize drawings slip past! K -- Ken http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org irc.freenode.net #freeswitch Twitter: @FreeSWITCH

1 0

Random crash : somewhere in trace showing switch_core_session_exec failing
by Bhavesh Soni 21 May '14

21 May '14

Folks, My board randomly crashes sometimes making outgoing calls; The backtrace looks like: mymodule /lib/libc.so.6(__default_sa_restorer_v2+0x0)[0x404bc630]#012 /lib/libc.so.6(gsignal+0x40)[0x404bb2ec]#012 /lib/libc.so.6(abort+0x1b0)[0x404c0b04]#012 /lib/libc.so.6(__default_sa_restorer_v2+0x0)[0x404bc630]#012 mymodule /lib/libfreeswitch.so.1(*switch_core_session_exec*+0x56c)[0x4014385c]#012 /lib/libfreeswitch.so.1(*switch_core_session_execute_application_get_flags*+0x494)[0x40143ee8]#012 /lib/libfreeswitch.so.1(*switch_core_session_run*+0xea0)[0x40147980]#012 /lib/libfreeswitch.so.1(+0x59a7c)[0x40142a7c]#012 /lib/libfreeswitch.so.1(+0xdc8bc)[0x401c58bc]#012 /lib/libpthread.so.0(+0x5a90)[0x400cea90]#012 /lib/libc.so.6(clone+0x88)[0x40567fb8]#012 Is it really failing somewhere in switch_thread? Also, some times I see different set of traces, where *esl_recv_event()* fails? I am running freeswitch version 1.2.1 on my ARM board. -- Regards Bhavesh GS LAB (O) +91 20 4671 1256 (M) +91 86000 64681

3 4

How to extract B-Leg cdrs after call hangup
by Hardik Patel 21 May '14

21 May '14

Hi all I am fresher for freeswitch and i just want to know is there any posiblity to extract B-leg cdrs data using mod_xml_curl and mod_xm_cdrs module. My actuall problem is when my call is hangup i am getting A-Leg cdrs data to process but in A-Leg data i am getting wrong values for billseconds and duration variables but in B-Leg data i am getting actual data that i want. So is there any posiblity to extract that cdrs using any variable or some another way? Thanks in Advance Hardik Patel

2 1

Opensips using ODBC
by Matt Broad 21 May '14

21 May '14

Hi, not strictly a Freeswitch question, so apologies, but just wanted to know if anyone has any experience using opensips and connecting to a microsoft sql database instead of MySql? I can see that there is an odbc module, which I assume using freetds and unixodbc, should be able to do the job. But I can't find any examples of people who aren't using Mysql. Any pointers would be very much appreciated :) thanks Matt

2 4