From fluixab@bellsouth.net Sat Mar  3 17:17:40 2012
From: Bernard Fluixa <fluixab@bellsouth.net>
To: freeswitch-users@lists.freeswitch.org
Subject: [Freeswitch-users] mod shell stream
Date: Sat, 03 Mar 2012 09:17:08 -0500
Message-ID: <A492BA22-28AE-4701-84EB-4F8403244F63@bellsouth.net>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============8860265867889369585=="

--===============8860265867889369585==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Hi there,

I'm trying to make a playback of streamed sound data coming from a database. =
I could make the example included in documentation work (cat file.wav | sox -=
t wav - $@ -t raw -). However, I can't make it work with same sox options aft=
er having uploaded that same file into my PGSQL database and select it instea=
d of a cat command.=20

My shell script is

#!/bin/bash

psql -h <HOST> -U postgres -E -t -q -d <DATABASE> -c "select <BINARY COLUM DA=
TA> from <TABLE> " | sox -t wav - $@ -t raw -

Freeswitch gives me a "sox FAIL formats: can't open input  `-': WAVE: RIFF he=
ader not found" error message.


Has anybody streamed data from database into Freeswitch?

Thank you.

Bernard
   =20




--===============8860265867889369585==
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"
MIME-Version: 1.0

PGh0bWw+PGhlYWQ+PC9oZWFkPjxib2R5IHN0eWxlPSJ3b3JkLXdyYXA6IGJyZWFrLXdvcmQ7IC13
ZWJraXQtbmJzcC1tb2RlOiBzcGFjZTsgLXdlYmtpdC1saW5lLWJyZWFrOiBhZnRlci13aGl0ZS1z
cGFjZTsgIj5IaSB0aGVyZSw8ZGl2Pjxicj48L2Rpdj48ZGl2PkknbSB0cnlpbmcgdG8gbWFrZSBh
IHBsYXliYWNrIG9mIHN0cmVhbWVkIHNvdW5kIGRhdGEgY29taW5nIGZyb20gYSBkYXRhYmFzZS4g
SSBjb3VsZCBtYWtlIHRoZSBleGFtcGxlIGluY2x1ZGVkIGluIGRvY3VtZW50YXRpb24gd29yayAo
Y2F0IGZpbGUud2F2IHwgc294IC10IHdhdiAtICRAIC10IHJhdyAtKS4gSG93ZXZlciwgSSBjYW4n
dCBtYWtlIGl0IHdvcmsgd2l0aCBzYW1lIHNveCBvcHRpb25zIGFmdGVyIGhhdmluZyB1cGxvYWRl
ZCB0aGF0IHNhbWUgZmlsZSBpbnRvIG15IFBHU1FMIGRhdGFiYXNlIGFuZCBzZWxlY3QgaXQgaW5z
dGVhZCBvZiBhIGNhdCBjb21tYW5kLiZuYnNwOzwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+TXkg
c2hlbGwgc2NyaXB0IGlzPC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj48ZGl2PiMhL2Jpbi9iYXNo
PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5wc3FsIC1oICZsdDtIT1NUJmd0OyAtVSBwb3N0Z3Jl
cyAtRSAtdCAtcSAtZCAmbHQ7REFUQUJBU0UmZ3Q7IC1jICJzZWxlY3QgJmx0O0JJTkFSWSBDT0xV
TSBEQVRBJmd0OyBmcm9tICZsdDtUQUJMRSZndDsgIiB8IHNveCAtdCB3YXYgLSAkQCAtdCByYXcg
LTwvZGl2PjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+RnJlZXN3aXRjaCBnaXZlcyBtZSBhICJz
b3ggRkFJTCBmb3JtYXRzOiBjYW4ndCBvcGVuIGlucHV0ICZuYnNwO2AtJzogV0FWRTogUklGRiBo
ZWFkZXIgbm90IGZvdW5kIiBlcnJvciBtZXNzYWdlLjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+
PGJyPjwvZGl2PjxkaXY+SGFzIGFueWJvZHkgc3RyZWFtZWQgZGF0YSBmcm9tIGRhdGFiYXNlIGlu
dG8gRnJlZXN3aXRjaD88L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PlRoYW5rIHlvdS48L2Rpdj48
ZGl2Pjxicj48L2Rpdj48ZGl2PkJlcm5hcmQ8L2Rpdj48ZGl2PiZuYnNwOyZuYnNwOyZuYnNwOzxm
b250IGNsYXNzPSJBcHBsZS1zdHlsZS1zcGFuIiBmYWNlPSJtb25vc3BhY2UiPjxzcGFuIGNsYXNz
PSJBcHBsZS1zdHlsZS1zcGFuIiBzdHlsZT0iZm9udC1zaXplOiAxM3B4OyBsaW5lLWhlaWdodDog
MTRweDsgd2hpdGUtc3BhY2U6IHByZTsgIj4mbmJzcDs8L3NwYW4+PC9mb250PjwvZGl2PjxkaXY+
PGJyPjwvZGl2PjwvYm9keT48L2h0bWw+

--===============8860265867889369585==--


From dujinfang@gmail.com Sun Mar  4 09:13:22 2012
From: Seven Du <dujinfang@gmail.com>
To: freeswitch-users@lists.freeswitch.org
Subject: Re: [Freeswitch-users] mod shell stream
Date: Sun, 04 Mar 2012 14:12:47 +0800
Message-ID: <5BA3C64DA53B4EAC9B1DA367F8FFD398@gmail.com>
In-Reply-To: <A492BA22-28AE-4701-84EB-4F8403244F63@bellsouth.net>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============7319729303075285027=="

--===============7319729303075285027==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

I think you might need a script to strip the column header ?

 psql -c "select 1" |cat=20
 ?column?=20
----------
        1
(1 row)




--=20
About: http://about.me/dujinfang
Blog: http://www.dujinfang.com
Proj:  http://www.freeswitch.org.cn

Sent with Sparrow (http://www.sparrowmailapp.com)


On Saturday, March 3, 2012 at 10:17 PM, Bernard Fluixa wrote:

> Hi there,
>=20
> I'm trying to make a playback of streamed sound data coming from a database=
. I could make the example included in documentation work (cat file.wav | sox=
 -t wav - $@ -t raw -). However, I can't make it work with same sox options a=
fter having uploaded that same file into my PGSQL database and select it inst=
ead of a cat command.=20
>=20
> My shell script is
>=20
> #!/bin/bash
>=20
> psql -h <HOST> -U postgres -E -t -q -d <DATABASE> -c "select <BINARY COLUM =
DATA> from <TABLE> " | sox -t wav - $@ -t raw -
>=20
> Freeswitch gives me a "sox FAIL formats: can't open input  `-': WAVE: RIFF =
header not found" error message.
>=20
>=20
> Has anybody streamed data from database into Freeswitch?
>=20
> Thank you.
>=20
> Bernard
>    =20
>=20
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting@freeswitch.org (mailto:consulting@freeswitch.org)
> http://www.freeswitchsolutions.com
>=20
> FreeSWITCH-powered IP PBX: The CudaTel Communication Server
> http://www.cudatel.com
>=20
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>=20
> FreeSWITCH-users mailing list
> FreeSWITCH-users@lists.freeswitch.org (mailto:FreeSWITCH-users@lists.freesw=
itch.org)
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>=20
>=20





--===============7319729303075285027==
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"
MIME-Version: 1.0

CiAgICAgICAgICAgICAgICA8ZGl2PgogICAgICAgICAgICAgICAgICAgIDxkaXY+SSB0aGluayB5
b3UgbWlnaHQgbmVlZCBhIHNjcmlwdCB0byBzdHJpcCB0aGUgY29sdW1uIGhlYWRlciA/PC9kaXY+
PGRpdj48YnI+PC9kaXY+PGRpdj4mbmJzcDtwc3FsIC1jICJzZWxlY3QgMSIgfGNhdCZuYnNwOzwv
ZGl2PjxkaXY+Jm5ic3A7P2NvbHVtbj8mbmJzcDs8L2Rpdj48ZGl2Pi0tLS0tLS0tLS08L2Rpdj48
ZGl2PiZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAxPC9kaXY+PGRpdj4oMSByb3cpPC9kaXY+
PGRpdj48YnI+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj48YnI+PC9kaXY+CiAgICAgICAgICAg
ICAgICA8L2Rpdj4KICAgICAgICAgICAgICAgIDxkaXY+PGRpdj48YnI+PC9kaXY+PGRpdj4tLSZu
YnNwOzwvZGl2PjxkaXY+QWJvdXQ6IGh0dHA6Ly9hYm91dC5tZS9kdWppbmZhbmc8L2Rpdj48ZGl2
PkJsb2c6IGh0dHA6Ly93d3cuZHVqaW5mYW5nLmNvbTwvZGl2PjxkaXY+UHJvajogJm5ic3A7aHR0
cDovL3d3dy5mcmVlc3dpdGNoLm9yZy5jbjwvZGl2PjxkaXY+PGJyPjwvZGl2PlNlbnQgd2l0aCA8
YSBocmVmPSJodHRwOi8vd3d3LnNwYXJyb3dtYWlsYXBwLmNvbSI+U3BhcnJvdzwvYT48YnI+PGRp
dj48YnI+PC9kaXY+PC9kaXY+CiAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICA8cCBz
dHlsZT0iY29sb3I6ICNBMEEwQTg7Ij5PbiBTYXR1cmRheSwgTWFyY2ggMywgMjAxMiBhdCAxMDox
NyBQTSwgQmVybmFyZCBGbHVpeGEgd3JvdGU6PC9wPgogICAgICAgICAgICAgICAgPGJsb2NrcXVv
dGUgdHlwZT0iY2l0ZSIgc3R5bGU9ImJvcmRlci1sZWZ0LXN0eWxlOnNvbGlkO2JvcmRlci13aWR0
aDoxcHg7bWFyZ2luLWxlZnQ6MHB4O3BhZGRpbmctbGVmdDoxMHB4OyI+CiAgICAgICAgICAgICAg
ICAgICAgPHNwYW4+PGRpdj48ZGl2PkhpIHRoZXJlLDxkaXY+PGJyPjwvZGl2PjxkaXY+SSdtIHRy
eWluZyB0byBtYWtlIGEgcGxheWJhY2sgb2Ygc3RyZWFtZWQgc291bmQgZGF0YSBjb21pbmcgZnJv
bSBhIGRhdGFiYXNlLiBJIGNvdWxkIG1ha2UgdGhlIGV4YW1wbGUgaW5jbHVkZWQgaW4gZG9jdW1l
bnRhdGlvbiB3b3JrIChjYXQgZmlsZS53YXYgfCBzb3ggLXQgd2F2IC0gJEAgLXQgcmF3IC0pLiBI
b3dldmVyLCBJIGNhbid0IG1ha2UgaXQgd29yayB3aXRoIHNhbWUgc294IG9wdGlvbnMgYWZ0ZXIg
aGF2aW5nIHVwbG9hZGVkIHRoYXQgc2FtZSBmaWxlIGludG8gbXkgUEdTUUwgZGF0YWJhc2UgYW5k
IHNlbGVjdCBpdCBpbnN0ZWFkIG9mIGEgY2F0IGNvbW1hbmQuJm5ic3A7PC9kaXY+PGRpdj48YnI+
PC9kaXY+PGRpdj5NeSBzaGVsbCBzY3JpcHQgaXM8L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2Pjxk
aXY+IyEvYmluL2Jhc2g8L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PnBzcWwgLWggJmx0O0hPU1Qm
Z3Q7IC1VIHBvc3RncmVzIC1FIC10IC1xIC1kICZsdDtEQVRBQkFTRSZndDsgLWMgInNlbGVjdCAm
bHQ7QklOQVJZIENPTFVNIERBVEEmZ3Q7IGZyb20gJmx0O1RBQkxFJmd0OyAiIHwgc294IC10IHdh
diAtICRAIC10IHJhdyAtPC9kaXY+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5GcmVlc3dpdGNo
IGdpdmVzIG1lIGEgInNveCBGQUlMIGZvcm1hdHM6IGNhbid0IG9wZW4gaW5wdXQgJm5ic3A7YC0n
OiBXQVZFOiBSSUZGIGhlYWRlciBub3QgZm91bmQiIGVycm9yIG1lc3NhZ2UuPC9kaXY+PGRpdj48
YnI+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5IYXMgYW55Ym9keSBzdHJlYW1lZCBkYXRhIGZy
b20gZGF0YWJhc2UgaW50byBGcmVlc3dpdGNoPzwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+VGhh
bmsgeW91LjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+QmVybmFyZDwvZGl2PjxkaXY+Jm5ic3A7
Jm5ic3A7Jm5ic3A7PGZvbnQgZmFjZT0ibW9ub3NwYWNlIj48c3BhbiBzdHlsZT0iZm9udC1zaXpl
OiAxM3B4OyBsaW5lLWhlaWdodDogMTRweDsgd2hpdGUtc3BhY2U6IHByZTsgIj4mbmJzcDs8L3Nw
YW4+PC9mb250PjwvZGl2PjxkaXY+PGJyPjwvZGl2PjwvZGl2PjxkaXY+PGRpdj5fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fPC9kaXY+PGRpdj5Qcm9mZXNzaW9uYWwgRnJlZVNXSVRDSCBDb25zdWx0aW5nIFNlcnZp
Y2VzOjwvZGl2PjxkaXY+PGEgaHJlZj0ibWFpbHRvOmNvbnN1bHRpbmdAZnJlZXN3aXRjaC5vcmci
PmNvbnN1bHRpbmdAZnJlZXN3aXRjaC5vcmc8L2E+PC9kaXY+PGRpdj48YSBocmVmPSJodHRwOi8v
d3d3LmZyZWVzd2l0Y2hzb2x1dGlvbnMuY29tIj5odHRwOi8vd3d3LmZyZWVzd2l0Y2hzb2x1dGlv
bnMuY29tPC9hPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+RnJlZVNXSVRDSC1wb3dlcmVkIElQ
IFBCWDogVGhlIEN1ZGFUZWwgQ29tbXVuaWNhdGlvbiBTZXJ2ZXI8L2Rpdj48ZGl2PjxhIGhyZWY9
Imh0dHA6Ly93d3cuY3VkYXRlbC5jb20iPmh0dHA6Ly93d3cuY3VkYXRlbC5jb208L2E+PC9kaXY+
PGRpdj48YnI+PC9kaXY+PGRpdj5PZmZpY2lhbCBGcmVlU1dJVENIIFNpdGVzPC9kaXY+PGRpdj48
YSBocmVmPSJodHRwOi8vd3d3LmZyZWVzd2l0Y2gub3JnIj5odHRwOi8vd3d3LmZyZWVzd2l0Y2gu
b3JnPC9hPjwvZGl2PjxkaXY+PGEgaHJlZj0iaHR0cDovL3dpa2kuZnJlZXN3aXRjaC5vcmciPmh0
dHA6Ly93aWtpLmZyZWVzd2l0Y2gub3JnPC9hPjwvZGl2PjxkaXY+PGEgaHJlZj0iaHR0cDovL3d3
dy5jbHVlY29uLmNvbSI+aHR0cDovL3d3dy5jbHVlY29uLmNvbTwvYT48L2Rpdj48ZGl2Pjxicj48
L2Rpdj48ZGl2PkZyZWVTV0lUQ0gtdXNlcnMgbWFpbGluZyBsaXN0PC9kaXY+PGRpdj48YSBocmVm
PSJtYWlsdG86RnJlZVNXSVRDSC11c2Vyc0BsaXN0cy5mcmVlc3dpdGNoLm9yZyI+RnJlZVNXSVRD
SC11c2Vyc0BsaXN0cy5mcmVlc3dpdGNoLm9yZzwvYT48L2Rpdj48ZGl2PjxhIGhyZWY9Imh0dHA6
Ly9saXN0cy5mcmVlc3dpdGNoLm9yZy9tYWlsbWFuL2xpc3RpbmZvL2ZyZWVzd2l0Y2gtdXNlcnMi
Pmh0dHA6Ly9saXN0cy5mcmVlc3dpdGNoLm9yZy9tYWlsbWFuL2xpc3RpbmZvL2ZyZWVzd2l0Y2gt
dXNlcnM8L2E+PC9kaXY+PGRpdj5VTlNVQlNDUklCRTo8YSBocmVmPSJodHRwOi8vbGlzdHMuZnJl
ZXN3aXRjaC5vcmcvbWFpbG1hbi9vcHRpb25zL2ZyZWVzd2l0Y2gtdXNlcnMiPmh0dHA6Ly9saXN0
cy5mcmVlc3dpdGNoLm9yZy9tYWlsbWFuL29wdGlvbnMvZnJlZXN3aXRjaC11c2VyczwvYT48L2Rp
dj48ZGl2PjxhIGhyZWY9Imh0dHA6Ly93d3cuZnJlZXN3aXRjaC5vcmciPmh0dHA6Ly93d3cuZnJl
ZXN3aXRjaC5vcmc8L2E+PC9kaXY+PC9kaXY+PC9kaXY+PC9zcGFuPgogICAgICAgICAgICAgICAg
IAogICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgIAog
ICAgICAgICAgICAgICAgPC9ibG9ja3F1b3RlPgogICAgICAgICAgICAgICAgIAogICAgICAgICAg
ICAgICAgPGRpdj4KICAgICAgICAgICAgICAgICAgICA8YnI+CiAgICAgICAgICAgICAgICA8L2Rp
dj4KICAgICAgICAgICAg

--===============7319729303075285027==--


From fluixab@bellsouth.net Sun Mar  4 15:30:59 2012
From: Bernard Fluixa <fluixab@bellsouth.net>
To: freeswitch-users@lists.freeswitch.org
Subject: Re: [Freeswitch-users] mod shell stream
Date: Sun, 04 Mar 2012 07:30:05 -0500
Message-ID: <F038CC44-2CF3-4BF9-97B3-CBDA0D96840E@bellsouth.net>
In-Reply-To: <5BA3C64DA53B4EAC9B1DA367F8FFD398@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============3363609148698132532=="

--===============3363609148698132532==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

That is already done with the -t option (tuples only)

Thanks anyway

Bernard

On Mar 4, 2012, at 1:12 AM, Seven Du wrote:

> I think you might need a script to strip the column header ?
>=20
>  psql -c "select 1" |cat=20
>  ?column?=20
> ----------
>         1
> (1 row)
>=20
>=20
>=20
>=20
> --=20
> About: http://about.me/dujinfang
> Blog: http://www.dujinfang.com
> Proj:  http://www.freeswitch.org.cn
>=20
> Sent with Sparrow
>=20
> On Saturday, March 3, 2012 at 10:17 PM, Bernard Fluixa wrote:
>=20
>> Hi there,
>>=20
>> I'm trying to make a playback of streamed sound data coming from a databas=
e. I could make the example included in documentation work (cat file.wav | so=
x -t wav - $@ -t raw -). However, I can't make it work with same sox options =
after having uploaded that same file into my PGSQL database and select it ins=
tead of a cat command.=20
>>=20
>> My shell script is
>>=20
>> #!/bin/bash
>>=20
>> psql -h <HOST> -U postgres -E -t -q -d <DATABASE> -c "select <BINARY COLUM=
 DATA> from <TABLE> " | sox -t wav - $@ -t raw -
>>=20
>> Freeswitch gives me a "sox FAIL formats: can't open input  `-': WAVE: RIFF=
 header not found" error message.
>>=20
>>=20
>> Has anybody streamed data from database into Freeswitch?
>>=20
>> Thank you.
>>=20
>> Bernard
>>    =20
>>=20
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting@freeswitch.org
>> http://www.freeswitchsolutions.com
>>=20
>> FreeSWITCH-powered IP PBX: The CudaTel Communication Server
>> http://www.cudatel.com
>>=20
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://wiki.freeswitch.org
>> http://www.cluecon.com
>>=20
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users@lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>=20
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting@freeswitch.org
> http://www.freeswitchsolutions.com
>=20
> FreeSWITCH-powered IP PBX: The CudaTel Communication Server
> http://www.cudatel.com
>=20
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>=20
> FreeSWITCH-users mailing list
> FreeSWITCH-users@lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org




--===============3363609148698132532==
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"
MIME-Version: 1.0

PGh0bWw+PGhlYWQ+PC9oZWFkPjxib2R5IHN0eWxlPSJ3b3JkLXdyYXA6IGJyZWFrLXdvcmQ7IC13
ZWJraXQtbmJzcC1tb2RlOiBzcGFjZTsgLXdlYmtpdC1saW5lLWJyZWFrOiBhZnRlci13aGl0ZS1z
cGFjZTsgIj48ZGl2PlRoYXQgaXMgYWxyZWFkeSBkb25lIHdpdGggdGhlIC10IG9wdGlvbiAodHVw
bGVzIG9ubHkpPC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5UaGFua3MgYW55d2F5PC9kaXY+PGRp
dj48YnI+PC9kaXY+PGRpdj5CZXJuYXJkPC9kaXY+PGJyPjxkaXY+PGRpdj5PbiBNYXIgNCwgMjAx
MiwgYXQgMToxMiBBTSwgU2V2ZW4gRHUgd3JvdGU6PC9kaXY+PGJyIGNsYXNzPSJBcHBsZS1pbnRl
cmNoYW5nZS1uZXdsaW5lIj48YmxvY2txdW90ZSB0eXBlPSJjaXRlIj4KICAgICAgICAgICAgICAg
IDxkaXY+CiAgICAgICAgICAgICAgICAgICAgPGRpdj5JIHRoaW5rIHlvdSBtaWdodCBuZWVkIGEg
c2NyaXB0IHRvIHN0cmlwIHRoZSBjb2x1bW4gaGVhZGVyID88L2Rpdj48ZGl2Pjxicj48L2Rpdj48
ZGl2PiZuYnNwO3BzcWwgLWMgInNlbGVjdCAxIiB8Y2F0Jm5ic3A7PC9kaXY+PGRpdj4mbmJzcDs/
Y29sdW1uPyZuYnNwOzwvZGl2PjxkaXY+LS0tLS0tLS0tLTwvZGl2PjxkaXY+Jm5ic3A7ICZuYnNw
OyAmbmJzcDsgJm5ic3A7IDE8L2Rpdj48ZGl2PigxIHJvdyk8L2Rpdj48ZGl2Pjxicj48L2Rpdj48
ZGl2Pjxicj48L2Rpdj48ZGl2Pjxicj48L2Rpdj4KICAgICAgICAgICAgICAgIDwvZGl2PgogICAg
ICAgICAgICAgICAgPGRpdj48ZGl2Pjxicj48L2Rpdj48ZGl2Pi0tJm5ic3A7PC9kaXY+PGRpdj5B
Ym91dDogPGEgaHJlZj0iaHR0cDovL2Fib3V0Lm1lL2R1amluZmFuZyI+aHR0cDovL2Fib3V0Lm1l
L2R1amluZmFuZzwvYT48L2Rpdj48ZGl2PkJsb2c6IDxhIGhyZWY9Imh0dHA6Ly93d3cuZHVqaW5m
YW5nLmNvbSI+aHR0cDovL3d3dy5kdWppbmZhbmcuY29tPC9hPjwvZGl2PjxkaXY+UHJvajogJm5i
c3A7PGEgaHJlZj0iaHR0cDovL3d3dy5mcmVlc3dpdGNoLm9yZy5jbiI+aHR0cDovL3d3dy5mcmVl
c3dpdGNoLm9yZy5jbjwvYT48L2Rpdj48ZGl2Pjxicj48L2Rpdj5TZW50IHdpdGggPGEgaHJlZj0i
aHR0cDovL3d3dy5zcGFycm93bWFpbGFwcC5jb20vIj5TcGFycm93PC9hPjxicj48ZGl2Pjxicj48
L2Rpdj48L2Rpdj48cCBzdHlsZT0iY29sb3I6ICNBMEEwQTg7Ij5PbiBTYXR1cmRheSwgTWFyY2gg
MywgMjAxMiBhdCAxMDoxNyBQTSwgQmVybmFyZCBGbHVpeGEgd3JvdGU6PC9wPgogICAgICAgICAg
ICAgICAgPGJsb2NrcXVvdGUgdHlwZT0iY2l0ZSIgc3R5bGU9ImJvcmRlci1sZWZ0LXN0eWxlOnNv
bGlkO2JvcmRlci13aWR0aDoxcHg7bWFyZ2luLWxlZnQ6MHB4O3BhZGRpbmctbGVmdDoxMHB4OyI+
CiAgICAgICAgICAgICAgICAgICAgPHNwYW4+PGRpdj48ZGl2PkhpIHRoZXJlLDxkaXY+PGJyPjwv
ZGl2PjxkaXY+SSdtIHRyeWluZyB0byBtYWtlIGEgcGxheWJhY2sgb2Ygc3RyZWFtZWQgc291bmQg
ZGF0YSBjb21pbmcgZnJvbSBhIGRhdGFiYXNlLiBJIGNvdWxkIG1ha2UgdGhlIGV4YW1wbGUgaW5j
bHVkZWQgaW4gZG9jdW1lbnRhdGlvbiB3b3JrIChjYXQgZmlsZS53YXYgfCBzb3ggLXQgd2F2IC0g
JEAgLXQgcmF3IC0pLiBIb3dldmVyLCBJIGNhbid0IG1ha2UgaXQgd29yayB3aXRoIHNhbWUgc294
IG9wdGlvbnMgYWZ0ZXIgaGF2aW5nIHVwbG9hZGVkIHRoYXQgc2FtZSBmaWxlIGludG8gbXkgUEdT
UUwgZGF0YWJhc2UgYW5kIHNlbGVjdCBpdCBpbnN0ZWFkIG9mIGEgY2F0IGNvbW1hbmQuJm5ic3A7
PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5NeSBzaGVsbCBzY3JpcHQgaXM8L2Rpdj48ZGl2Pjxi
cj48L2Rpdj48ZGl2PjxkaXY+IyEvYmluL2Jhc2g8L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PnBz
cWwgLWggJmx0O0hPU1QmZ3Q7IC1VIHBvc3RncmVzIC1FIC10IC1xIC1kICZsdDtEQVRBQkFTRSZn
dDsgLWMgInNlbGVjdCAmbHQ7QklOQVJZIENPTFVNIERBVEEmZ3Q7IGZyb20gJmx0O1RBQkxFJmd0
OyAiIHwgc294IC10IHdhdiAtICRAIC10IHJhdyAtPC9kaXY+PC9kaXY+PGRpdj48YnI+PC9kaXY+
PGRpdj5GcmVlc3dpdGNoIGdpdmVzIG1lIGEgInNveCBGQUlMIGZvcm1hdHM6IGNhbid0IG9wZW4g
aW5wdXQgJm5ic3A7YC0nOiBXQVZFOiBSSUZGIGhlYWRlciBub3QgZm91bmQiIGVycm9yIG1lc3Nh
Z2UuPC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5IYXMgYW55Ym9keSBz
dHJlYW1lZCBkYXRhIGZyb20gZGF0YWJhc2UgaW50byBGcmVlc3dpdGNoPzwvZGl2PjxkaXY+PGJy
PjwvZGl2PjxkaXY+VGhhbmsgeW91LjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+QmVybmFyZDwv
ZGl2PjxkaXY+Jm5ic3A7Jm5ic3A7Jm5ic3A7PGZvbnQgZmFjZT0ibW9ub3NwYWNlIj48c3BhbiBz
dHlsZT0iZm9udC1zaXplOiAxM3B4OyBsaW5lLWhlaWdodDogMTRweDsgd2hpdGUtc3BhY2U6IHBy
ZTsgIj4mbmJzcDs8L3NwYW4+PC9mb250PjwvZGl2PjxkaXY+PGJyPjwvZGl2PjwvZGl2PjxkaXY+
PGRpdj5fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fPC9kaXY+PGRpdj5Qcm9mZXNzaW9uYWwgRnJlZVNXSVRDSCBD
b25zdWx0aW5nIFNlcnZpY2VzOjwvZGl2PjxkaXY+PGEgaHJlZj0ibWFpbHRvOmNvbnN1bHRpbmdA
ZnJlZXN3aXRjaC5vcmciPmNvbnN1bHRpbmdAZnJlZXN3aXRjaC5vcmc8L2E+PC9kaXY+PGRpdj48
YSBocmVmPSJodHRwOi8vd3d3LmZyZWVzd2l0Y2hzb2x1dGlvbnMuY29tLyI+aHR0cDovL3d3dy5m
cmVlc3dpdGNoc29sdXRpb25zLmNvbTwvYT48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PkZyZWVT
V0lUQ0gtcG93ZXJlZCBJUCBQQlg6IFRoZSBDdWRhVGVsIENvbW11bmljYXRpb24gU2VydmVyPC9k
aXY+PGRpdj48YSBocmVmPSJodHRwOi8vd3d3LmN1ZGF0ZWwuY29tLyI+aHR0cDovL3d3dy5jdWRh
dGVsLmNvbTwvYT48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2Pk9mZmljaWFsIEZyZWVTV0lUQ0gg
U2l0ZXM8L2Rpdj48ZGl2PjxhIGhyZWY9Imh0dHA6Ly93d3cuZnJlZXN3aXRjaC5vcmcvIj5odHRw
Oi8vd3d3LmZyZWVzd2l0Y2gub3JnPC9hPjwvZGl2PjxkaXY+PGEgaHJlZj0iaHR0cDovL3dpa2ku
ZnJlZXN3aXRjaC5vcmcvIj5odHRwOi8vd2lraS5mcmVlc3dpdGNoLm9yZzwvYT48L2Rpdj48ZGl2
PjxhIGhyZWY9Imh0dHA6Ly93d3cuY2x1ZWNvbi5jb20vIj5odHRwOi8vd3d3LmNsdWVjb24uY29t
PC9hPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+RnJlZVNXSVRDSC11c2VycyBtYWlsaW5nIGxp
c3Q8L2Rpdj48ZGl2PjxhIGhyZWY9Im1haWx0bzpGcmVlU1dJVENILXVzZXJzQGxpc3RzLmZyZWVz
d2l0Y2gub3JnIj5GcmVlU1dJVENILXVzZXJzQGxpc3RzLmZyZWVzd2l0Y2gub3JnPC9hPjwvZGl2
PjxkaXY+PGEgaHJlZj0iaHR0cDovL2xpc3RzLmZyZWVzd2l0Y2gub3JnL21haWxtYW4vbGlzdGlu
Zm8vZnJlZXN3aXRjaC11c2VycyI+aHR0cDovL2xpc3RzLmZyZWVzd2l0Y2gub3JnL21haWxtYW4v
bGlzdGluZm8vZnJlZXN3aXRjaC11c2VyczwvYT48L2Rpdj48ZGl2PlVOU1VCU0NSSUJFOjxhIGhy
ZWY9Imh0dHA6Ly9saXN0cy5mcmVlc3dpdGNoLm9yZy9tYWlsbWFuL29wdGlvbnMvZnJlZXN3aXRj
aC11c2VycyI+aHR0cDovL2xpc3RzLmZyZWVzd2l0Y2gub3JnL21haWxtYW4vb3B0aW9ucy9mcmVl
c3dpdGNoLXVzZXJzPC9hPjwvZGl2PjxkaXY+PGEgaHJlZj0iaHR0cDovL3d3dy5mcmVlc3dpdGNo
Lm9yZy8iPmh0dHA6Ly93d3cuZnJlZXN3aXRjaC5vcmc8L2E+PC9kaXY+PC9kaXY+PC9kaXY+PC9z
cGFuPgogICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAg
IAogICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgPC9ibG9ja3F1b3RlPgogICAgICAg
ICAgICAgICAgIAogICAgICAgICAgICAgICAgPGRpdj4KICAgICAgICAgICAgICAgICAgICA8YnI+
CiAgICAgICAgICAgICAgICA8L2Rpdj4KICAgICAgICAgICAgX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXzxicj5Q
cm9mZXNzaW9uYWwgRnJlZVNXSVRDSCBDb25zdWx0aW5nIFNlcnZpY2VzOjxicj48YSBocmVmPSJt
YWlsdG86Y29uc3VsdGluZ0BmcmVlc3dpdGNoLm9yZyI+Y29uc3VsdGluZ0BmcmVlc3dpdGNoLm9y
ZzwvYT48YnI+aHR0cDovL3d3dy5mcmVlc3dpdGNoc29sdXRpb25zLmNvbTxicj48YnI+RnJlZVNX
SVRDSC1wb3dlcmVkIElQIFBCWDogVGhlIEN1ZGFUZWwgQ29tbXVuaWNhdGlvbiBTZXJ2ZXI8YnI+
aHR0cDovL3d3dy5jdWRhdGVsLmNvbTxicj48YnI+T2ZmaWNpYWwgRnJlZVNXSVRDSCBTaXRlczxi
cj5odHRwOi8vd3d3LmZyZWVzd2l0Y2gub3JnPGJyPmh0dHA6Ly93aWtpLmZyZWVzd2l0Y2gub3Jn
PGJyPmh0dHA6Ly93d3cuY2x1ZWNvbi5jb208YnI+PGJyPkZyZWVTV0lUQ0gtdXNlcnMgbWFpbGlu
ZyBsaXN0PGJyPkZyZWVTV0lUQ0gtdXNlcnNAbGlzdHMuZnJlZXN3aXRjaC5vcmc8YnI+aHR0cDov
L2xpc3RzLmZyZWVzd2l0Y2gub3JnL21haWxtYW4vbGlzdGluZm8vZnJlZXN3aXRjaC11c2Vyczxi
cj5VTlNVQlNDUklCRTpodHRwOi8vbGlzdHMuZnJlZXN3aXRjaC5vcmcvbWFpbG1hbi9vcHRpb25z
L2ZyZWVzd2l0Y2gtdXNlcnM8YnI+aHR0cDovL3d3dy5mcmVlc3dpdGNoLm9yZzxicj48L2Jsb2Nr
cXVvdGU+PC9kaXY+PGJyPjwvYm9keT48L2h0bWw+

--===============3363609148698132532==--


From msc@freeswitch.org Tue Mar  6 00:19:16 2012
From: Michael Collins <msc@freeswitch.org>
To: freeswitch-users@lists.freeswitch.org
Subject: Re: [Freeswitch-users] mod shell stream
Date: Mon, 05 Mar 2012 13:18:44 -0800
Message-ID:
 <CAKzWOxXQH6YkNhwSNdL-vEOr8vCuczb8kNzKr3crFGbioaMy1w@mail.gmail.com>
In-Reply-To: <F038CC44-2CF3-4BF9-97B3-CBDA0D96840E@bellsouth.net>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============6721788065268316952=="

--===============6721788065268316952==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit

On Sun, Mar 4, 2012 at 4:30 AM, Bernard Fluixa <fluixab@bellsouth.net>wrote:

> That is already done with the -t option (tuples only)
>
> Thanks anyway
>
> Bernard
>
>
Does your script work if you do it in two steps, i.e. read from the
database and drop into a file, then cat the file into sox? I'm just curious
if something unexpected is happening on the command line when piping from
psql to sox.

-MC



--===============6721788065268316952==
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"
MIME-Version: 1.0

PGJyPjxicj48ZGl2IGNsYXNzPSJnbWFpbF9xdW90ZSI+T24gU3VuLCBNYXIgNCwgMjAxMiBhdCA0
OjMwIEFNLCBCZXJuYXJkIEZsdWl4YSA8c3BhbiBkaXI9Imx0ciI+Jmx0OzxhIGhyZWY9Im1haWx0
bzpmbHVpeGFiQGJlbGxzb3V0aC5uZXQiPmZsdWl4YWJAYmVsbHNvdXRoLm5ldDwvYT4mZ3Q7PC9z
cGFuPiB3cm90ZTo8YnI+PGJsb2NrcXVvdGUgY2xhc3M9ImdtYWlsX3F1b3RlIiBzdHlsZT0ibWFy
Z2luOjAgMCAwIC44ZXg7Ym9yZGVyLWxlZnQ6MXB4ICNjY2Mgc29saWQ7cGFkZGluZy1sZWZ0OjFl
eCI+CjxkaXYgc3R5bGU9IndvcmQtd3JhcDpicmVhay13b3JkIj48ZGl2PlRoYXQgaXMgYWxyZWFk
eSBkb25lIHdpdGggdGhlIC10IG9wdGlvbiAodHVwbGVzIG9ubHkpPC9kaXY+PGRpdj48YnI+PC9k
aXY+PGRpdj5UaGFua3MgYW55d2F5PC9kaXY+PHNwYW4gY2xhc3M9IkhPRW5aYiI+PGZvbnQgY29s
b3I9IiM4ODg4ODgiPjxkaXY+PGJyPjwvZGl2PjxkaXY+QmVybmFyZDwvZGl2PjwvZm9udD48L3Nw
YW4+PGRpdj4KPGRpdiBjbGFzcz0iaDUiPjxicj48L2Rpdj48L2Rpdj48L2Rpdj48L2Jsb2NrcXVv
dGU+PGJyPjwvZGl2PkRvZXMgeW91ciBzY3JpcHQgd29yayBpZiB5b3UgZG8gaXQgaW4gdHdvIHN0
ZXBzLCBpLmUuIHJlYWQgZnJvbSB0aGUgZGF0YWJhc2UgYW5kIGRyb3AgaW50byBhIGZpbGUsIHRo
ZW4gY2F0IHRoZSBmaWxlIGludG8gc294PyBJJiMzOTttIGp1c3QgY3VyaW91cyBpZiBzb21ldGhp
bmcgdW5leHBlY3RlZCBpcyBoYXBwZW5pbmcgb24gdGhlIGNvbW1hbmQgbGluZSB3aGVuIHBpcGlu
ZyBmcm9tIHBzcWwgdG8gc294Ljxicj4KPGJyPi1NQzxicj4K

--===============6721788065268316952==--


From fluixab@bellsouth.net Thu Mar  8 18:25:09 2012
From: Bernard Fluixa <fluixab@bellsouth.net>
To: freeswitch-users@lists.freeswitch.org
Subject: Re: [Freeswitch-users] mod shell stream
Date: Thu, 08 Mar 2012 07:24:38 -0800
Message-ID: <1331220278.14097.YahooMailRC@web180216.mail.gq1.yahoo.com>
In-Reply-To:
 <CAKzWOxXQH6YkNhwSNdL-vEOr8vCuczb8kNzKr3crFGbioaMy1w@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============2978866093201515853=="

--===============2978866093201515853==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Michael,

Thanks for your reply. Yes it works in this case.

Any thoughts?

Bernard




________________________________
From: Michael Collins <msc@freeswitch.org>
To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>
Sent: Mon, March 5, 2012 10:18:44 PM
Subject: Re: [Freeswitch-users] mod shell stream




On Sun, Mar 4, 2012 at 4:30 AM, Bernard Fluixa <fluixab@bellsouth.net> wrote:

That is already done with the -t option (tuples only)
>
>
>Thanks anyway
>
>Bernard
>
>
Does your script work if you do it in two steps, i.e. read from the database =
and=20
drop into a file, then cat the file into sox? I'm just curious if something=20
unexpected is happening on the command line when piping from psql to sox.

-MC



--===============2978866093201515853==
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"
MIME-Version: 1.0

PGh0bWw+PGhlYWQ+PHN0eWxlIHR5cGU9InRleHQvY3NzIj48IS0tIERJViB7bWFyZ2luOjBweDt9
IC0tPjwvc3R5bGU+PC9oZWFkPjxib2R5PjxkaXYgc3R5bGU9ImZvbnQtZmFtaWx5OnRpbWVzIG5l
dyByb21hbixuZXcgeW9yayx0aW1lcyxzZXJpZjtmb250LXNpemU6MTJwdCI+PGRpdj5NaWNoYWVs
LDxicj48YnI+VGhhbmtzIGZvciB5b3VyIHJlcGx5LiBZZXMgaXQgd29ya3MgaW4gdGhpcyBjYXNl
Ljxicj48YnI+QW55IHRob3VnaHRzPzxicj48YnI+QmVybmFyZDxicj48L2Rpdj48ZGl2IHN0eWxl
PSJmb250LWZhbWlseTp0aW1lcyBuZXcgcm9tYW4sIG5ldyB5b3JrLCB0aW1lcywgc2VyaWY7Zm9u
dC1zaXplOjEycHQiPjxicj48ZGl2IHN0eWxlPSJmb250LWZhbWlseTp0aW1lcyBuZXcgcm9tYW4s
IG5ldyB5b3JrLCB0aW1lcywgc2VyaWY7Zm9udC1zaXplOjEycHQiPjxmb250IGZhY2U9IlRhaG9t
YSIgc2l6ZT0iMiI+PGhyIHNpemU9IjEiPjxiPjxzcGFuIHN0eWxlPSJmb250LXdlaWdodDogYm9s
ZDsiPkZyb206PC9zcGFuPjwvYj4gTWljaGFlbCBDb2xsaW5zICZsdDttc2NAZnJlZXN3aXRjaC5v
cmcmZ3Q7PGJyPjxiPjxzcGFuIHN0eWxlPSJmb250LXdlaWdodDogYm9sZDsiPlRvOjwvc3Bhbj48
L2I+IEZyZWVTV0lUQ0ggVXNlcnMgSGVscCAmbHQ7ZnJlZXN3aXRjaC11c2Vyc0BsaXN0cy5mcmVl
c3dpdGNoLm9yZyZndDs8YnI+PGI+PHNwYW4gc3R5bGU9ImZvbnQtd2VpZ2h0OiBib2xkOyI+U2Vu
dDo8L3NwYW4+PC9iPiBNb24sIE1hcmNoIDUsIDIwMTIgMTA6MTg6NDQgUE08YnI+PGI+PHNwYW4g
c3R5bGU9ImZvbnQtd2VpZ2h0OiBib2xkOyI+U3ViamVjdDo8L3NwYW4+PC9iPiBSZTogW0ZyZWVz
d2l0Y2gtdXNlcnNdIG1vZCBzaGVsbCBzdHJlYW08YnI+PC9mb250Pjxicj4KPGJyPjxicj48ZGl2
IGNsYXNzPSJnbWFpbF9xdW90ZSI+T24gU3VuLCBNYXIgNCwgMjAxMiBhdCA0OjMwIEFNLCBCZXJu
YXJkIEZsdWl4YSA8c3BhbiBkaXI9Imx0ciI+Jmx0OzxhIHJlbD0ibm9mb2xsb3ciIHltYWlsdG89
Im1haWx0bzpmbHVpeGFiQGJlbGxzb3V0aC5uZXQiIHRhcmdldD0iX2JsYW5rIiBocmVmPSJtYWls
dG86Zmx1aXhhYkBiZWxsc291dGgubmV0Ij5mbHVpeGFiQGJlbGxzb3V0aC5uZXQ8L2E+Jmd0Ozwv
c3Bhbj4gd3JvdGU6PGJyPjxibG9ja3F1b3RlIGNsYXNzPSJnbWFpbF9xdW90ZSIgc3R5bGU9Im1h
cmdpbjowIDAgMCAuOGV4O2JvcmRlci1sZWZ0OjFweCAjY2NjIHNvbGlkO3BhZGRpbmctbGVmdDox
ZXg7Ij4KPGRpdiBzdHlsZT0id29yZC13cmFwOmJyZWFrLXdvcmQ7Ij48ZGl2PlRoYXQgaXMgYWxy
ZWFkeSBkb25lIHdpdGggdGhlIC10IG9wdGlvbiAodHVwbGVzIG9ubHkpPC9kaXY+PGRpdj48YnI+
PC9kaXY+PGRpdj5UaGFua3MgYW55d2F5PC9kaXY+PHNwYW4gY2xhc3M9IkhPRW5aYiI+PGZvbnQg
Y29sb3I9IiM4ODg4ODgiPjxkaXY+PGJyPjwvZGl2PjxkaXY+QmVybmFyZDwvZGl2PjwvZm9udD48
L3NwYW4+PGRpdj4KPGRpdiBjbGFzcz0iaDUiPjxicj48L2Rpdj48L2Rpdj48L2Rpdj48L2Jsb2Nr
cXVvdGU+PGJyPjwvZGl2PkRvZXMgeW91ciBzY3JpcHQgd29yayBpZiB5b3UgZG8gaXQgaW4gdHdv
IHN0ZXBzLCBpLmUuIHJlYWQgZnJvbSB0aGUgZGF0YWJhc2UgYW5kIGRyb3AgaW50byBhIGZpbGUs
IHRoZW4gY2F0IHRoZSBmaWxlIGludG8gc294PyBJJ20ganVzdCBjdXJpb3VzIGlmIHNvbWV0aGlu
ZyB1bmV4cGVjdGVkIGlzIGhhcHBlbmluZyBvbiB0aGUgY29tbWFuZCBsaW5lIHdoZW4gcGlwaW5n
IGZyb20gcHNxbCB0byBzb3guPGJyPgo8YnI+LU1DPGJyPgo8L2Rpdj48L2Rpdj4KCgoKPC9kaXY+
PC9ib2R5PjwvaHRtbD4=

--===============2978866093201515853==--


From msc@freeswitch.org Fri Mar  9 02:53:50 2012
From: Michael Collins <msc@freeswitch.org>
To: freeswitch-users@lists.freeswitch.org
Subject: Re: [Freeswitch-users] mod shell stream
Date: Thu, 08 Mar 2012 15:53:19 -0800
Message-ID:
 <CAKzWOxVOqOabWrcOLuqSL5yzN7yjMxUJU=9BBzWiAQgtVMknQg@mail.gmail.com>
In-Reply-To: <1331220278.14097.YahooMailRC@web180216.mail.gq1.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============3161343831141375752=="

--===============3161343831141375752==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit

I'm afraid I'll have to defer to those more knowledgeable than I in such
matters.

Any sox and/or cmd line gurus out there with some ideas?
-MC

On Thu, Mar 8, 2012 at 7:24 AM, Bernard Fluixa <fluixab@bellsouth.net>wrote:

> Michael,
>
> Thanks for your reply. Yes it works in this case.
>
> Any thoughts?
>
> Bernard
>
> ------------------------------
> *From:* Michael Collins <msc@freeswitch.org>
> *To:* FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>
> *Sent:* Mon, March 5, 2012 10:18:44 PM
> *Subject:* Re: [Freeswitch-users] mod shell stream
>
>
>
> On Sun, Mar 4, 2012 at 4:30 AM, Bernard Fluixa <fluixab@bellsouth.net>wrote:
>
>> That is already done with the -t option (tuples only)
>>
>> Thanks anyway
>>
>> Bernard
>>
>>
> Does your script work if you do it in two steps, i.e. read from the
> database and drop into a file, then cat the file into sox? I'm just curious
> if something unexpected is happening on the command line when piping from
> psql to sox.
>
> -MC
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting@freeswitch.org
> http://www.freeswitchsolutions.com
>
> FreeSWITCH-powered IP PBX: The CudaTel Communication Server
> http://www.cudatel.com
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users@lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>



--===============3161343831141375752==
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"
MIME-Version: 1.0

SSYjMzk7bSBhZnJhaWQgSSYjMzk7bGwgaGF2ZSB0byBkZWZlciB0byB0aG9zZSBtb3JlIGtub3ds
ZWRnZWFibGUgdGhhbiBJIGluIHN1Y2ggbWF0dGVycy48YnI+PGJyPkFueSBzb3ggYW5kL29yIGNt
ZCBsaW5lIGd1cnVzIG91dCB0aGVyZSB3aXRoIHNvbWUgaWRlYXM/PGJyPi1NQzxicj48YnI+PGRp
diBjbGFzcz0iZ21haWxfcXVvdGUiPk9uIFRodSwgTWFyIDgsIDIwMTIgYXQgNzoyNCBBTSwgQmVy
bmFyZCBGbHVpeGEgPHNwYW4gZGlyPSJsdHIiPiZsdDs8YSBocmVmPSJtYWlsdG86Zmx1aXhhYkBi
ZWxsc291dGgubmV0Ij5mbHVpeGFiQGJlbGxzb3V0aC5uZXQ8L2E+Jmd0Ozwvc3Bhbj4gd3JvdGU6
PGJyPgo8YmxvY2txdW90ZSBjbGFzcz0iZ21haWxfcXVvdGUiIHN0eWxlPSJtYXJnaW46MCAwIDAg
LjhleDtib3JkZXItbGVmdDoxcHggI2NjYyBzb2xpZDtwYWRkaW5nLWxlZnQ6MWV4Ij48ZGl2Pjxk
aXYgc3R5bGU9ImZvbnQtZmFtaWx5OnRpbWVzIG5ldyByb21hbixuZXcgeW9yayx0aW1lcyxzZXJp
Zjtmb250LXNpemU6MTJwdCI+PGRpdj5NaWNoYWVsLDxicj48YnI+VGhhbmtzIGZvciB5b3VyIHJl
cGx5LiBZZXMgaXQgd29ya3MgaW4gdGhpcyBjYXNlLjxicj4KPGJyPkFueSB0aG91Z2h0cz88YnI+
PGJyPkJlcm5hcmQ8YnI+PC9kaXY+PGRpdiBzdHlsZT0iZm9udC1mYW1pbHk6dGltZXMgbmV3IHJv
bWFuLG5ldyB5b3JrLHRpbWVzLHNlcmlmO2ZvbnQtc2l6ZToxMnB0Ij48YnI+PGRpdiBzdHlsZT0i
Zm9udC1mYW1pbHk6dGltZXMgbmV3IHJvbWFuLG5ldyB5b3JrLHRpbWVzLHNlcmlmO2ZvbnQtc2l6
ZToxMnB0Ij48Zm9udCBmYWNlPSJUYWhvbWEiPjxociBzaXplPSIxIj4KPGI+PHNwYW4gc3R5bGU9
ImZvbnQtd2VpZ2h0OmJvbGQiPkZyb206PC9zcGFuPjwvYj4gTWljaGFlbCBDb2xsaW5zICZsdDs8
YSBocmVmPSJtYWlsdG86bXNjQGZyZWVzd2l0Y2gub3JnIiB0YXJnZXQ9Il9ibGFuayI+bXNjQGZy
ZWVzd2l0Y2gub3JnPC9hPiZndDs8YnI+PGI+PHNwYW4gc3R5bGU9ImZvbnQtd2VpZ2h0OmJvbGQi
PlRvOjwvc3Bhbj48L2I+IEZyZWVTV0lUQ0ggVXNlcnMgSGVscCAmbHQ7PGEgaHJlZj0ibWFpbHRv
OmZyZWVzd2l0Y2gtdXNlcnNAbGlzdHMuZnJlZXN3aXRjaC5vcmciIHRhcmdldD0iX2JsYW5rIj5m
cmVlc3dpdGNoLXVzZXJzQGxpc3RzLmZyZWVzd2l0Y2gub3JnPC9hPiZndDs8YnI+CjxiPjxzcGFu
IHN0eWxlPSJmb250LXdlaWdodDpib2xkIj5TZW50Ojwvc3Bhbj48L2I+IE1vbiwgTWFyY2ggNSwg
MjAxMiAxMDoxODo0NCBQTTxicj48Yj48c3BhbiBzdHlsZT0iZm9udC13ZWlnaHQ6Ym9sZCI+U3Vi
amVjdDo8L3NwYW4+PC9iPiBSZTogW0ZyZWVzd2l0Y2gtdXNlcnNdIG1vZCBzaGVsbCBzdHJlYW08
YnI+PC9mb250Pjxicj4KPGJyPjxicj48ZGl2IGNsYXNzPSJnbWFpbF9xdW90ZSI+T24gU3VuLCBN
YXIgNCwgMjAxMiBhdCA0OjMwIEFNLCBCZXJuYXJkIEZsdWl4YSA8c3BhbiBkaXI9Imx0ciI+Jmx0
OzxhIHJlbD0ibm9mb2xsb3ciIGhyZWY9Im1haWx0bzpmbHVpeGFiQGJlbGxzb3V0aC5uZXQiIHRh
cmdldD0iX2JsYW5rIj5mbHVpeGFiQGJlbGxzb3V0aC5uZXQ8L2E+Jmd0Ozwvc3Bhbj4gd3JvdGU6
PGJyPjxibG9ja3F1b3RlIGNsYXNzPSJnbWFpbF9xdW90ZSIgc3R5bGU9Im1hcmdpbjowIDAgMCAu
OGV4O2JvcmRlci1sZWZ0OjFweCAjY2NjIHNvbGlkO3BhZGRpbmctbGVmdDoxZXgiPgoKPGRpdiBz
dHlsZT0id29yZC13cmFwOmJyZWFrLXdvcmQiPjxkaXY+VGhhdCBpcyBhbHJlYWR5IGRvbmUgd2l0
aCB0aGUgLXQgb3B0aW9uICh0dXBsZXMgb25seSk8L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PlRo
YW5rcyBhbnl3YXk8L2Rpdj48c3Bhbj48Zm9udCBjb2xvcj0iIzg4ODg4OCI+PGRpdj48YnI+PC9k
aXY+PGRpdj5CZXJuYXJkPC9kaXY+PC9mb250Pjwvc3Bhbj48ZGl2Pgo8ZGl2Pjxicj48L2Rpdj48
L2Rpdj48L2Rpdj48L2Jsb2NrcXVvdGU+PGJyPjwvZGl2PkRvZXMgeW91ciBzY3JpcHQgd29yayBp
ZiB5b3UgZG8gaXQgaW4gdHdvIHN0ZXBzLCBpLmUuIHJlYWQgZnJvbSB0aGUgZGF0YWJhc2UgYW5k
IGRyb3AgaW50byBhIGZpbGUsIHRoZW4gY2F0IHRoZSBmaWxlIGludG8gc294PyBJJiMzOTttIGp1
c3QgY3VyaW91cyBpZiBzb21ldGhpbmcgdW5leHBlY3RlZCBpcyBoYXBwZW5pbmcgb24gdGhlIGNv
bW1hbmQgbGluZSB3aGVuIHBpcGluZyBmcm9tIHBzcWwgdG8gc294Ljxicj4KCjxicj4tTUM8YnI+
CjwvZGl2PjwvZGl2PgoKCgo8L2Rpdj48L2Rpdj48YnI+X19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXzxicj4KUHJv
ZmVzc2lvbmFsIEZyZWVTV0lUQ0ggQ29uc3VsdGluZyBTZXJ2aWNlczo8YnI+CjxhIGhyZWY9Im1h
aWx0bzpjb25zdWx0aW5nQGZyZWVzd2l0Y2gub3JnIj5jb25zdWx0aW5nQGZyZWVzd2l0Y2gub3Jn
PC9hPjxicj4KPGEgaHJlZj0iaHR0cDovL3d3dy5mcmVlc3dpdGNoc29sdXRpb25zLmNvbSIgdGFy
Z2V0PSJfYmxhbmsiPmh0dHA6Ly93d3cuZnJlZXN3aXRjaHNvbHV0aW9ucy5jb208L2E+PGJyPgo8
YnI+CkZyZWVTV0lUQ0gtcG93ZXJlZCBJUCBQQlg6IFRoZSBDdWRhVGVsIENvbW11bmljYXRpb24g
U2VydmVyPGJyPgo8YSBocmVmPSJodHRwOi8vd3d3LmN1ZGF0ZWwuY29tIiB0YXJnZXQ9Il9ibGFu
ayI+aHR0cDovL3d3dy5jdWRhdGVsLmNvbTwvYT48YnI+Cjxicj4KT2ZmaWNpYWwgRnJlZVNXSVRD
SCBTaXRlczxicj4KPGEgaHJlZj0iaHR0cDovL3d3dy5mcmVlc3dpdGNoLm9yZyIgdGFyZ2V0PSJf
YmxhbmsiPmh0dHA6Ly93d3cuZnJlZXN3aXRjaC5vcmc8L2E+PGJyPgo8YSBocmVmPSJodHRwOi8v
d2lraS5mcmVlc3dpdGNoLm9yZyIgdGFyZ2V0PSJfYmxhbmsiPmh0dHA6Ly93aWtpLmZyZWVzd2l0
Y2gub3JnPC9hPjxicj4KPGEgaHJlZj0iaHR0cDovL3d3dy5jbHVlY29uLmNvbSIgdGFyZ2V0PSJf
YmxhbmsiPmh0dHA6Ly93d3cuY2x1ZWNvbi5jb208L2E+PGJyPgo8YnI+CkZyZWVTV0lUQ0gtdXNl
cnMgbWFpbGluZyBsaXN0PGJyPgo8YSBocmVmPSJtYWlsdG86RnJlZVNXSVRDSC11c2Vyc0BsaXN0
cy5mcmVlc3dpdGNoLm9yZyI+RnJlZVNXSVRDSC11c2Vyc0BsaXN0cy5mcmVlc3dpdGNoLm9yZzwv
YT48YnI+CjxhIGhyZWY9Imh0dHA6Ly9saXN0cy5mcmVlc3dpdGNoLm9yZy9tYWlsbWFuL2xpc3Rp
bmZvL2ZyZWVzd2l0Y2gtdXNlcnMiIHRhcmdldD0iX2JsYW5rIj5odHRwOi8vbGlzdHMuZnJlZXN3
aXRjaC5vcmcvbWFpbG1hbi9saXN0aW5mby9mcmVlc3dpdGNoLXVzZXJzPC9hPjxicj4KVU5TVUJT
Q1JJQkU6PGEgaHJlZj0iaHR0cDovL2xpc3RzLmZyZWVzd2l0Y2gub3JnL21haWxtYW4vb3B0aW9u
cy9mcmVlc3dpdGNoLXVzZXJzIiB0YXJnZXQ9Il9ibGFuayI+aHR0cDovL2xpc3RzLmZyZWVzd2l0
Y2gub3JnL21haWxtYW4vb3B0aW9ucy9mcmVlc3dpdGNoLXVzZXJzPC9hPjxicj4KPGEgaHJlZj0i
aHR0cDovL3d3dy5mcmVlc3dpdGNoLm9yZyIgdGFyZ2V0PSJfYmxhbmsiPmh0dHA6Ly93d3cuZnJl
ZXN3aXRjaC5vcmc8L2E+PGJyPgo8YnI+PC9ibG9ja3F1b3RlPjwvZGl2Pjxicj4K

--===============3161343831141375752==--