[Serusers] SER & SEMS

[Steve Blair]

Ian:

  What version of SER are you using? I have 0.8.14 stable. In this 
release the
fifo_db_url parameter behaved as you described so I removed it without
any adverse affects. Other than loading vm.so and defining the
modparam("voicemail", "db_url", "mysql://ser:<rwuser>@localhost/ser")  I
didn't need to make any specific changes to get SEMS to work.

-Steve


Ian Bonham wrote:

>(Must MUST remember to hit reply-all, and not just reply!)
>
>Hi Steve
>
>Whats happening is the call gets to SER/SEMS and then SEMS seems to fail
>because it can't communicate with SER properly. I've set up as per the Howto
>exactly, but if I add the line :
>
>fifo_db_url="mysql://xxx:xxx@localhost/ser"
>
>to ser.cfg in Globals, SER fails to start. This is confusing me as in the
>Howto's it seems this line is important. If I # out the line, SER starts, but
>when a call hits SER/SEMS, SEMS in debug mode reports :
>
>(25654) DEBUG: execute (AmServer.cpp:276): everything is OK !
>(25654) DEBUG: write_to_fifo (SerClient.cpp:237): write_to_fifo:
><:DB:00006436608B8F33
>select
>email_address
>.
>subscriber
>username = "8709304900"
>.
>
>  
>
>(25654) DEBUG: write_to_fifo (SerClient.cpp:244): Write to fifo: completed
>(25654) DEBUG: parseLine (SerDBQuery.cpp:119): line=<500 command 'DB' not
>available>
>(25654) DEBUG: parseLine (SerDBQuery.cpp:119): line=<>
>(25654) ERROR: startSession (AmSession.cpp:468): 404 voicemail: no email
>address for user <8709304900>
>(25654) DEBUG: write_to_fifo (SerClient.cpp:237): write_to_fifo:
><:t_reply:0000643625E7F6D6
>404
>voicemail: no email address for user <8709304900>
>43869:628960497
>0000643613172552
>Contact: <sip:8709304900 at 217.160.187.14:5090>
>  
>
>(25654) DEBUG: write_to_fifo (SerClient.cpp:244): Write to fifo: completed
>(25654) DEBUG: getReturnCode (AmRequest.cpp:357): response from Ser: 500
>command 't_reply' not available
>(25654) ERROR: reply (AmRequest.cpp:335): AmRequestUAS::reply: 500 command
>'t_reply' not available
>
>
>So I'm getting two problems I think. First it can't get the Subscribers email
>address from the SER database. I can if I run the query from mysql on the
>command line, but SEMS seems unable to get through to the SER database. Is
>that because of the error <500 command 'DB' not available> ?
>Then it cannot find the command 't_reply'.
>
>Any suggestions greatly appriciated,
>
>Ian Bonham
>
>
>
>Steve Blair (blairs at isc.upenn.edu) wrote:
>  
>
>>Can you explain what is wrong?
>>
>>Ian Bonham wrote:
>>
>>    
>>
>>>Hi All,
>>>
>>>Just a quickie, I'm having MEGA problems getting SER/SEMS operating as a
>>>voicemail server. I'm running SER as a proxy on 5060 and SER/SEMS on 5090.
>>>
>>>I can get the calls to divert to SER/SEMS on 5090 if the subscriber is
>>>unavailable, but I'm having huge problems getting SER/SEMS running properly.
>>>The example conf's in the SER-SEMS howto dont seem to work on my set up, and I
>>>keep getting database errors thrown up.
>>>
>>>I have mailed the SEMS list, but I wondered if anyone here has a working
>>>SER/SEMS Voicemail configuration, would you be kind enough to post your
>>>ser.cfg and sems.conf so I can compare to try to see where I'm messing it up?
>>>
>>>Many thanks,
>>>
>>>Ian
>>>
>>>_______________________________________________
>>>Serusers mailing list
>>>serusers at lists.iptel.org
>>>http://lists.iptel.org/mailman/listinfo/serusers
>>>
>>>
>>>      
>>>
>>--
>>
>>ISC Network Engineering
>>The University of Pennsylvania
>>3401 Walnut Street, Suite 221A
>>Philadelphia, PA 19104
>>
>>
>>voice: 215-573-8396
>>
>>       215-746-8001
>>
>>fax: 215-898-9348
>>
>>sip:blairs at upenn.edu
>>
>>
>>    
>>

-- 
  
ISC Network Engineering
The University of Pennsylvania
3401 Walnut Street, Suite 221A
Philadelphia, PA 19104  


voice: 215-573-8396 

       215-746-8001

fax: 215-898-9348    

sip:blairs at upenn.edu