[OpenSIPS-Users] MediaProxy 2.6.1 - manually creating media_sessions table

Gary Patton gpatton.public at outlook.com
Fri Jul 25 20:45:46 CEST 2014

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.
LOL - but I hadn't configured the config.ini file yet, so the database accounting section of the file was still commented out.  
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!
Again, thanks for the info.

> Date: Fri, 25 Jul 2014 07:23:36 -0700
> From: eahaselhoff at gmail.com
> To: users at lists.opensips.org
> Subject: Re: [OpenSIPS-Users] MediaProxy 2.6.1 - manually creating	media_sessions table
> Hi Gary,
> If you give your database user CREATE rights the database is greated at
> first start.
> But to answer your question:
> CREATE TABLE IF NOT EXISTS `media_sessions` (
>   `id` int(11) NOT NULL AUTO_INCREMENT,
>   `call_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
>   `from_tag` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
>   `to_tag` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
>   `info` mediumblob,
>   PRIMARY KEY (`id`)
> Cheers,
> Edwin
> --
> 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
> Sent from the OpenSIPS - Users mailing list archive at Nabble.com.
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20140725/c4daab4b/attachment-0001.htm>

More information about the Users mailing list