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@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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers