<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Hi everyone! With all the help and guidance I've received in this forum, I've successfully installed MediaProxy 2.6.1.<div><br></div><div>I don't see the media_sessions table in the opensips db that I configured in MediaProxy's config.ini file. That's not a surprise since I configured the config.ini file *after* I installed MediaProxy. So, when MP started, the media-dispatcher db parameter was commented out. Also, I set MediaProxy to use the opensips db and the user to be the opensips user with full rights to the opensips db.</div><div><br></div><div>I've looked in the logs for a description of the attributes, data types, etc., of the fields of the media_sessions table, but I can't find any. Using the info from the config.ini file, I manually created the table and fields but I don't know if I set the correct data types, whether or not the field(s) could be NULL, etc.:</div><div><br></div><div><div>MySQL commands:</div><div><br></div><div>CREATE TABLE media_sessions (</div><div>call_id INT NOT NULL AUTO_INCREMENT,</div><div>from_tag VARCHAR(60) NOT NULL,</div><div>to_tag VARCHAR(60) NOT NULL,</div><div>info BLOB NOT NULL,</div><div>PRIMARY KEY ( call_id )</div><div>);</div><div><br></div><div>The media_sessions table:</div><div><br></div><div>mysql> DESCRIBE media_sessions;</div><div>+-------------+------------------+----------+--------+--------------+---------------------+</div><div>| Field | Type | Null | Key | Default | Extra |</div><div>+-------------+------------------+----------+--------+--------------+---------------------+</div><div>| call_id | int(11) | NO | PRI | NULL | auto_increment |</div><div>| from_tag | varchar(60) | NO | | NULL | |</div><div>| to_tab | varchar(60) | NO | | NULL | |</div><div>| info | blob | NO | | NULL | |</div><div>+-------------+-----------------+----------+---------+---------------+---------------------+</div><div>4 rows in set (0.00 sec)</div></div><div><br></div><div>Can someone kindly share the field attributes for the media_sessions table so that I can modify my table if necessary?</div><div><br></div><div>Thank you.</div><div><br></div><div>Regards</div><div><br></div><div>Gary</div><div><br></div> </div></body>
</html>