Re: [Oreka-user] JDBCConnectionException

No, this is the only error that I see..

2006-04-13 12:44:10,046  INFO batchProcessing:77 - Th0 processing: =
20060413_124331_192.168.1.150,8014
2006-04-13 12:44:10,046  INFO reporting:67 - hostname=3Dfrog type=3Dtape =
recid=3D20060413_124331_192.168.1.150,8014 stage=3Dstop =
captureport=3D192.168.1.150,8014 timestamp=3D1144946611 =
filename=3D2006/04/13/12/20060413_124331_192.168.1.150,8014.wav =
localparty=3D192.168.1.150 localentrypoint=3D =
remoteparty=3D209.244.16.215 direction=3Dunkn duration=3D39 =
service=3Dorkaudio-frog=20
2006-04-13 12:44:10,078 ERROR batchProcessing:164 - BatchProcessing: =
BatchProcessing - Could not instanciate RTP mixer

  ----- Original Message -----=20
  From: Henri Herscher=20
  To: 'Brian West' ; ore...@li...=20
  Sent: Thursday, April 13, 2006 12:56 PM
  Subject: RE: [Oreka-user] JDBCConnectionException


  Hi Brian,

  Most likely, Oreka did not have the appropriate codec for your =
traffic. Can you find entries looking like the following in orkaudio.log =
?

  Could not find decoder for RTP payload type:xx

  Henri



-------------------------------------------------------------------------=
-----
  From: Brian West [mailto:br...@gm...]=20
  Sent: 13 April 2006 12:40
  To: Henri Herscher; ore...@li...
  Subject: Re: [Oreka-user] JDBCConnectionException


  Thank you Henri,

  Everything looks good now, except playing of the audio files.

  I have them outputting to \webapps\root but each call is producing a =
1KB wav file and a larger "mcf.orig" file.

  I have looked in the documentation for this and did not find much.

  My format is:  <StorageAudioFormat>pcmwav</StorageAudioFormat>

  Thank you,

  Brian
    ----- Original Message -----=20
    From: Henri Herscher=20
    To: 'Brian West' ; ore...@li...=20
    Sent: Thursday, April 13, 2006 11:16 AM
    Subject: RE: [Oreka-user] JDBCConnectionException


    Hi Brian,

    Don't use the database called "mysql". This is the administrative =
database that mysql is using for managing privileged access and such.

    Just do:

    mysql> create database oreka

    and edit both mysql.hbm.xml to reflect this.

    Cheers
    Henri



-------------------------------------------------------------------------=
---
    From: ore...@li... =
[mailto:ore...@li...] On Behalf Of Brian West
    Sent: 13 April 2006 10:26
    To: ore...@li...
    Subject: Re: [Oreka-user] JDBCConnectionException


    I think the service was called "oreka", but the db name was "mysql". =
I changed mysql.hbm.xml to reflect "mysql".

    I turned on sql tracing in log4j.properties, restarted tomcat and =
received this...


    10:13:50,156 root  INFO - =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
    10:13:50,156 root  INFO - orkweb starting ...
    10:13:50,687 org.hibernate.SQL DEBUG - select user0_.id as id26_0_, =
user0_.disabled as disabled26_0_, user0_.email as email26_0_, =
user0_.firstname as firstname26_0_, user0_.lastname as lastname26_0_, =
user0_.dateCreated as dateCrea6_26_0_, user0_.dateDeleted as =
dateDele7_26_0_, user0_.dateDisabled as dateDisa8_26_0_, user0_.deleted =
as deleted26_0_, user0_.password as password26_0_ from User user0_ where =
user0_.id=3D?
    10:13:50,703 org.hibernate.SQL DEBUG - insert into User (disabled, =
email, firstname, lastname, dateCreated, dateDeleted, dateDisabled, =
deleted, password) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
    10:13:50,703 net.sf.oreka.HibernateManager ERROR - Hibernate =
error:org.hibernate.exception.ConstraintViolationException
    10:13:54,875 org.apache.tapestry.ApplicationServlet  INFO - =
Initialized application servlet 'orkweb': 1,797 millis to create =
HiveMind Registry, 4,141 millis overall.


    ----- Original Message -----=20
      From: Henri Herscher=20
      To: 'Brian West' ; ore...@li...=20
      Sent: Thursday, April 13, 2006 9:43 AM
      Subject: RE: [Oreka-user] JDBCConnectionException


      Hi Brian,

      You need to create the oreka database manually if you haven't =
already done so. Can you make sure that the db is accessible by doing =
the following directly on the Tomcat+mySQL box:

      # mysql -u root -pbwest
      # use oreka

      Henri



-------------------------------------------------------------------------=
-
      From: ore...@li... =
[mailto:ore...@li...] On Behalf Of Brian West
      Sent: 13 April 2006 09:02
      To: ore...@li...
      Subject: [Oreka-user] JDBCConnectionException


      Every time I start tomcat, I get a JDBCConnectionException.

      - My db name is oreka.
      - Db username password is as below.
      - DB is set to port 3306. No software firewall on my server. Port =
3306 is opened up on the router.
      - Tomcat and mysql reside on the same machine.


      Is there something wrong with my =3D"hibernate.connection.url" ?

      My connection settings:
       <property =
name=3D"hibernate.connection.url">jdbc:mysql://localhost/oreka</property>=

       <property name=3D"hibernate.connection.password">bwest</property>
       <property name=3D"hibernate.connection.username">root</property>


      Error Text:


      08:54:57,015 root  INFO - =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
      08:54:57,015 root  INFO - orkweb starting ...
      08:54:57,687 net.sf.oreka.HibernateManager ERROR - Hibernate =
error:org.hibernate.exception.JDBCConnectionException

      Brian