<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'>Edwin:<div><br></div><div>Thanks for the table info. I guess that's what I was saying but not clearly. I compiled and installed MediaProxy. Then it started automatically. I did a "ps ax | grep media-" and it was running. There was a *.pid and *.sock file in /var/run/mediaproxy/ directory.</div><div><br></div><div>LOL - but I hadn't configured the config.ini file yet, so the database accounting section of the file was still commented out. </div><div><br></div><div>I thought that's why I suspect I don't have the media_sessions table in my database - the config.ini file that MediaProxy read on start-up didn't tell it to use database accounting, so it didn't connect to my db to create the table. I'm still learning!</div><div><br></div><div>Again, thanks for the info.</div><div><br></div><div>Regards</div><div><br></div><div>Gary</div><div> <br><br><div>> Date: Fri, 25 Jul 2014 07:23:36 -0700<br>> From: eahaselhoff@gmail.com<br>> To: users@lists.opensips.org<br>> Subject: Re: [OpenSIPS-Users] MediaProxy 2.6.1 - manually creating media_sessions table<br>> <br>> Hi Gary,<br>> <br>> If you give your database user CREATE rights the database is greated at<br>> first start.<br>> <br>> But to answer your question:<br>> CREATE TABLE IF NOT EXISTS `media_sessions` (<br>> `id` int(11) NOT NULL AUTO_INCREMENT,<br>> `call_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,<br>> `from_tag` varchar(64) COLLATE utf8_unicode_ci NOT NULL,<br>> `to_tag` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,<br>> `info` mediumblob,<br>> PRIMARY KEY (`id`)<br>> ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci<br>> AUTO_INCREMENT=52 ;<br>> <br>> Cheers,<br>> <br>> Edwin<br>> <br>> <br>> <br>> --<br>> View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/MediaProxy-2-6-1-manually-creating-media-sessions-table-tp7592620p7592621.html<br>> Sent from the OpenSIPS - Users mailing list archive at Nabble.com.<br>> <br>> _______________________________________________<br>> Users mailing list<br>> Users@lists.opensips.org<br>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users<br></div></div> </div></body>
</html>