<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi, <br>
A few pointers:<br>
- For 0.9.x: Always read the README for each module, residing in the
module directory, for 0.10.x, see iptel.org/ser<br>
- In general, iptel.org is the best source of info<br>
<br>
Below is the relevant info from msilo's README.<br>
g-)<br>
<br>
1.5. Installation & Running<br>
<br>
1.5.1. Database setup<br>
<br>
Before running SER with msilo, you have to setup the database<br>
table where the module will store the message. For that, if<br>
the table was not created by the installation script or you<br>
choose to install everything by yourself you can use the<br>
following SQL script (good for MySQL) as template. Database<br>
and table name can be set with module parameters so they can<br>
be changed, but the name of the columns must be as they are in<br>
the next SQL script.<br>
<br>
Example 1-10. msilo sql script<br>
...<br>
<br>
-- SQL script for MSILO module<br>
<br>
DROP DATABASE IF EXISTS msilo;<br>
<br>
-- create a database for storage<br>
CREATE DATABASE msilo;<br>
<br>
USE msilo;<br>
<br>
-- create the table<br>
CREATE TABLE silo(<br>
-- unique ID per message<br>
mid INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,<br>
-- src address - From URI<br>
src_addr VARCHAR(255) NOT NULL DEFAULT "",<br>
-- dst address - To URI<br>
dst_addr VARCHAR(255) NOT NULL DEFAULT "",<br>
-- r-uri == username@domain (for compatibility with old version)<br>
r_uri VARCHAR(255) NOT NULL DEFAULT "",<br>
-- username<br>
username VARCHAR(64) NOT NULL DEFAULT "",<br>
-- domain<br>
domain VARCHAR(128) NOT NULL DEFAULT "",<br>
-- incoming time<br>
inc_time INTEGER NOT NULL DEFAULT 0,<br>
-- expiration time<br>
exp_time INTEGER NOT NULL DEFAULT 0,<br>
-- content type<br>
ctype VARCHAR(32) NOT NULL DEFAULT "text/plain",<br>
-- body of the message<br>
body BLOB NOT NULL DEFAULT ""<br>
);<br>
<br>
<br>
Meidiana Ten wrote:
<blockquote
cite="mid20061011104140.47165.qmail@web32408.mail.mud.yahoo.com"
type="cite">
<div>Hi there,</div>
<div>I've read your post in mailing list about voice_silo table.</div>
<div>I setup my SER 0.9.7 and I am trying to activate msilo module to
store voice message for offline user.</div>
<div>I've checked the SER database and found that there is no table
named voice_silo.</div>
<div>Please help me with the table description so I can create the
table.</div>
<div>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.</div>
<div> </div>
<div>Thanx</div>
<div> </div>
<div>Meidiana</div>
<p> </p>
<hr size="1">Do you Yahoo!?<br>
Get on board. <a
href="http://us.rd.yahoo.com/evt=40791/*http://advision.webevents.yahoo.com/mailbeta">You're
invited</a> to try the new Yahoo! Mail.
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
Serusers mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Serusers@lists.iptel.org">Serusers@lists.iptel.org</a>
<a class="moz-txt-link-freetext" href="http://lists.iptel.org/mailman/listinfo/serusers">http://lists.iptel.org/mailman/listinfo/serusers</a>
</pre>
</blockquote>
</body>
</html>