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 to try the new Yahoo! Mail.
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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Hi.. I'd like to thank you for the reply on my questions. I've read the README file on msilo module and it appears just like you sent. I've checked my SER database and i found that there is table named silo without I have to create it myself. When I take a look at my SERWeb config.php, it requires table named voice_silo too. It says that silo is to store plain text message and voice_silo is to store voice message. I try to create voice_silo table using mysql script that shown on README file but SERWeb still gets error because there are missing fields that must be on voice_silo table (such as 'file' and 'subject' fields). Please help me to solve this problem. Thanx
Regards,
Meidiana
--------------------------------- How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates.
-
Greger V. Teigre -
Meidiana Ten