oreka-user Mailing List for oreka

Hi Jeremy,
 
You would need to write a SQL command that deletes the latest database
entries on a regular basis, such as
 
delete from recsegment where timestamp < XXX;
 
Cheers
Henri

  _____  

From: ore...@li...
[mailto:ore...@li...] On Behalf Of Campbell,
Jeremy P.
Sent: 21 November 2006 20:02
To: ore...@li...
Subject: [Oreka-user] Purging files



We use Oreka, OrkWeb, and OrkTrack.  Aside from just deleting the audio
files, what else should I do to clean up old recordings?  We want to start
purging our recordings after 96 hours.  Has anyone written code to purge
recordings on a timed basis that I could just modify?

 

Thanks,

Jeremy

 

_____________________________
Jeremy P. Campbell
Information Systems Director
Town of Davidson, NC
704-940-9632 - voice, direct
704-892-7591 ext. 248 - voice, main
704-892-3971 - fax
JCa...@ci...

 

We use Oreka, OrkWeb, and OrkTrack.  Aside from just deleting the audio
files, what else should I do to clean up old recordings?  We want to
start purging our recordings after 96 hours.  Has anyone written code to
purge recordings on a timed basis that I could just modify?

=20

Thanks,

Jeremy

=20

_____________________________
Jeremy P. Campbell
Information Systems Director
Town of Davidson, NC
704-940-9632 - voice, direct
704-892-7591 ext. 248 - voice, main
704-892-3971 - fax
JCa...@ci...

=20

Support for GSM6.10 wire format has been added in subversion (GSM as a
storage format has been default since the first release of Oreka). Thanks to
<http://kbs.cs.tu-berlin.de/%7Ejutta/toast.html> Jutta Degener and Carsten
Bormann from Technische Universitaet Berlin for making this codec available.
Stay tuned for an official release of the latest trunk (0.6 branch)

Cheers
Henri

Hi Adam,
 
Things to check:
 
* Make sure you are running Tomcat on port 8080.
* Make sure orktrack is up and running using the Tomcat manager and issuing
this:
# wget "http://localhost:8080/orktrack/command?type=ping" which should
return as "success=true"
 
Cheers
Henri

  _____  

From: ore...@li...
[mailto:ore...@li...] On Behalf Of Adam Kavan
Sent: 31 October 2006 16:57
To: ore...@li...
Subject: [Oreka-user] Another problem



I must just be having a bad day.  I've got orkaudio working!  It is
generating files like 20061031_153335_192.168.200.45,8000.mcf which I assume
are the recordings as well as files that end in a .orig.  But nothing seems
to be getting into the mysql database from orktrack.  I turned on orktrack
debug and see a lot of

 

15:54:50,776 org.apache.catalina.session.ManagerBase DEBUG - Start expire
sessions StandardManager at 1162331690776 sessioncount 0

15:54:50,776 org.apache.catalina.session.ManagerBase DEBUG - End expire
sessions StandardManager processingTime 0 expired sessions: 0

 

In the orktrack.log file.

 

My orkaudio config looks like

 

<config>

<!-- This is an example configuration file for the Oreka orkaudio capture
service on Linux -->

<!-- Copy this to config.xml and modify according to taste -->

 

  <AudioOutputPath>/var/lib/tomcat5/webapps/ROOT/</AudioOutputPath>

 

  <!-- Use the following if oreka has been installed (having run "make
install") -->

  <CapturePluginPath>/usr/lib</CapturePluginPath>

  <CapturePlugin>libvoip.so</CapturePlugin>

  <!-- Use the following if you run oreka uninstalled (without having run
"make install") -->

 
<!--<CapturePluginPath>audiocaptureplugins/voip/.libs</CapturePluginPath>-->

  <!--<CapturePlugin>libvoip.so</CapturePlugin>-->

 

  <!-- Audio file storage format: choose from: native, gsm, ulaw, alaw,
pcmwav -->

  <StorageAudioFormat>gsm</StorageAudioFormat>

 

  <!-- If you want to keep native audio files as well as compressed, change
this to "no" -->

  <DeleteNativeFile>yes</DeleteNativeFile>

 

  <NumBatchThreads></NumBatchThreads>

 

  <TrackerHostname>localhost</TrackerHostname>

  <EnableReporting>true</EnableReporting>

  <ClientTimeout>1000</ClientTimeout>

 

  <AudioSegmentation>false</AudioSegmentation>

  <AudioSegmentDuration>10</AudioSegmentDuration>

 

  <BatchProcessingEnhancePriority>true</BatchProcessingEnhancePriority>

 

  <VoIpPlugin>

    <!-- Use this if you want to force capture from a given list of devices.
-->

    <!-- All available devices are listed in /etc/orkaudio/orkaudio.log when
the service is starting -->

    <Devices>eth0</Devices>

 

    <!-- If AllowedIpRanges is used, only packets with *both* source and
destination -->

    <!-- matching the list are retained -->

    <!--<AllowedIpRanges>212.125.143.0/24, 82.150.0.0/16,
82.199.64.133</AllowedIpRanges>-->

    <AllowedIpRanges>192.168.200.0/24</AllowedIpRanges>

    <!-- If BlockedIpRanges is used, packets with *either* source or
destination -->

    <!-- matching the list are dropped -->

    <!--<BlockedIpRanges>212.125.143.0/24, 82.150.0.0/16,
82.199.64.133</BlockedIpRanges>-->

 

    <!-- LanMasks can be ignored if you have standard LAN addresses
(192.168.x.x or 10.x.x.x) -->

    <!-- LanMasks might be used to determine the direction of a call
(incoming or outgoing into or from the LAN) -->

    <!--<LanMasks>10.4.3.4, 1.2.3.4</LanMasks>-->

 

    <!-- The following is a csv list of your PBX, PSTN gateway, conferencing
server or such "gateway" devices -->

    <MediaGateways>192.168.200.2</MediaGateways>

  </VoIpPlugin>

  <GeneratorPlugin>

    <NumConcurrentPorts>1</NumConcurrentPorts>

    <AudioDuration>5</AudioDuration>

    <AudioFilename>sine.8KHz.pcm.wav</AudioFilename>

  </GeneratorPlugin>

</config>

 

My msql.hbm.xml file is the same between orktrack and orkweb and orkweb
allows me to login so I think I got it right.  Any ideas what I did wrong
this time?

 

 

 

--- Adam Kavan

--- R&D

--- Better living through overwhelming technological superiority!