[Serusers] voice_silo table missing. Please help!!

[Greger V. Teigre]

Hi,
A few pointers:
- For 0.9.x: Always read the README for each module, residing in the 
module directory, for 0.10.x, see iptel.org/ser
- In general, iptel.org is the best source of info

Below is the relevant info from msilo's README.
g-)

1.5. Installation & Running

1.5.1. Database setup

   Before running SER with msilo, you have to setup the database
   table where the module will store the message. For that, if
   the table was not created by the installation script or you
   choose to install everything by yourself you can use the
   following SQL script (good for MySQL) as template. Database
   and table name can be set with module parameters so they can
   be changed, but the name of the columns must be as they are in
   the next SQL script.

   Example 1-10. msilo sql script
...

-- SQL script for MSILO module

DROP DATABASE IF EXISTS msilo;

-- create a database for storage
CREATE DATABASE msilo;

USE msilo;

-- create the table
CREATE TABLE silo(
      -- unique ID per message
    mid INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
      -- src address - From URI
    src_addr VARCHAR(255) NOT NULL DEFAULT "",
      -- dst address - To URI
    dst_addr VARCHAR(255) NOT NULL DEFAULT "",
      -- r-uri == username at domain (for compatibility with old version)
    r_uri VARCHAR(255) NOT NULL DEFAULT "",
      -- username
    username VARCHAR(64) NOT NULL DEFAULT "",
      -- domain
    domain VARCHAR(128) NOT NULL DEFAULT "",
      -- incoming time
    inc_time INTEGER NOT NULL DEFAULT 0,
      -- expiration time
    exp_time INTEGER NOT NULL DEFAULT 0,
      -- content type
    ctype VARCHAR(32) NOT NULL DEFAULT "text/plain",
      -- body of the message
    body BLOB NOT NULL DEFAULT ""
);


Meidiana Ten wrote:
> Hi there,
> I've read your post in mailing list about voice_silo table.
> I setup my SER 0.9.7 and I am trying to activate msilo module to store 
> voice message for offline user.
> I've checked the SER database and found that there is no table named 
> voice_silo.
> Please help me with the table description so I can create the table.
> And please tell me how voicemail is store? ( I mean if it is store 
> directly into voice_silo table using x-lite or we must use other 
> application to input voice then store it into any folder). I really 
> need detail because I'm newbie in Linux.
>  
> Thanx
>  
> Meidiana
>
> ------------------------------------------------------------------------
> Do you Yahoo!?
> Get on board. You're invited 
> <http://us.rd.yahoo.com/evt=40791/*http://advision.webevents.yahoo.com/mailbeta> 
> to try the new Yahoo! Mail.
> ------------------------------------------------------------------------
>
> _______________________________________________
> Serusers mailing list
> Serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20061012/b8c903c2/attachment.htm>