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

[Gary Patton]

Edwin:
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.
Regards
Gary 

> 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`)
> ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
> AUTO_INCREMENT=52 ;
> 
> 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>