[OpenSIPS-Users] Siremis with Opensips - possible ?

Ewgeny evoip at ukr.net
Fri Nov 1 09:52:51 CET 2013


I have tried to add following lines in TViewer tool config:
$config->custom_table = "usr_preferences"; $config->custom_table_columns 
= array ("Id" => "id","UUID" => "uuid","Username" => "username","Domain" 
=> "domain","Attribute" => "attribute","Type" => "type","Value" => "value");


but I get the following errors:"Failed to issue query, error message : 
MDB2 Error: syntax error"

in Apache error.log:
  [error] [client 10.10.25.30] PHP Notice:  Undefined index: id in 
/var/www/openssip-cp/web/tools/system/tviewer/template/tviewer.main.php 
on line 50, referer: http://10.10.25.2/openssip-cp/web/menu.php
  [error] [client 10.10.25.30] PHP Notice:  Undefined index: uuid in 
/var/www/openssip-cp/web/tools/system/tviewer/template/tviewer.main.php 
on line 50, referer: http://10.10.25.2/openssip-cp/web/menu.php
  [error] [client 10.10.25.30] PHP Notice:  Undefined index: username in 
/var/www/openssip-cp/web/tools/system/tviewer/template/tviewer.main.php 
on line 50, referer: http://10.10.25.2/openssip-cp/web/menu.php
  [error] [client 10.10.25.30] PHP Notice:  Undefined index: domain in 
/var/www/openssip-cp/web/tools/system/tviewer/template/tviewer.main.php 
on line 50, referer: http://10.10.25.2/openssip-cp/web/menu.php
  [error] [client 10.10.25.30] PHP Notice:  Undefined index: attribute 
in 
/var/www/openssip-cp/web/tools/system/tviewer/template/tviewer.main.php 
on line 50, referer: http://10.10.25.2/openssip-cp/web/menu.php
  [error] [client 10.10.25.30] PHP Notice:  Undefined index: type in 
/var/www/openssip-cp/web/tools/system/tviewer/template/tviewer.main.php 
on line 50, referer: http://10.10.25.2/openssip-cp/web/menu.php
  [error] [client 10.10.25.30] PHP Notice:  Undefined index: value in 
/var/www/openssip-cp/web/tools/system/tviewer/template/tviewer.main.php 
on line 50, referer: http://10.10.25.2/openssip-cp/web/menu.php
  [error] [client 10.10.25.30] PHP Notice:  Undefined property: 
stdClass::$custom_table_primary_key in 
/var/www/openssip-cp/web/tools/system/tviewer/template/tviewer.main.php 
on line 86, referer: http://10.10.25.2/openssip-cp/web/menu.php


About online users, i have user authentication through RADIUS protocol, 
my users are not stored in the database.
will it work?


30.10.2013 20:50, Bogdan-Andrei Iancu ?????:
> Hi Ewgeny,
>
> Actually you can do both now in CP :).
>
> For usr_preferences, you can use the generic TViewer tool which can be 
> cloned and mapped over any kind of table, overing possibility to 
> add/edit/delete/search. It may be a better approach to have a 
> preconfigured TViewer for usr_preferences table.
>
> In regards to online users, in the "Users" section, you can choose to 
> see only the Online or Offline users. Also, for each user can see the 
> registered contacts (if online).
>
> Regards,
> Bogdan-Andrei Iancu
> OpenSIPS Founder and Developer
> http://www.opensips-solutions.com
>
> On 10/30/2013 07:57 PM, Ewgeny wrote:
>> I want to add the ability to control table "usr_preferences" - that 
>> means to view, add and remove values from usr_preferences table.
>> Also i need to view in a convenient form registered SIP UACs (like 
>> 'ul_dump'), in Siremis this feature is very handy :)
>>
>>
>>
>> 30.10.2013 19:21, Bogdan-Andrei Iancu ?????:
>>> Reporting bugs or lack of functionality may be a good start in doing 
>>> the CP better - we are open and willing to do the coding.
>>>
>>> Regards,
>>> Bogdan-Andrei Iancu
>>> OpenSIPS Founder and Developer
>>> http://www.opensips-solutions.com
>>>
>>> On 10/30/2013 03:18 PM, Mike Tesliuk wrote:
>>>> Yep,
>>>>
>>>> This is a very good sugestion :)
>>>>
>>>> I like OpenSIPS-CP , on my instalation i see some errors that are 
>>>> not a problem for me but can be for other users, but we realy can 
>>>> make some contribuition to this project.
>>>>
>>>> Im not a development dedicated guy, but i know a a litle bit of a 
>>>> lot of things , this could be very nice
>>>>
>>>>
>>>> 2013/10/30 Bogdan-Andrei Iancu <bogdan at opensips.org 
>>>> <mailto:bogdan at opensips.org>>
>>>>
>>>>     Hello Ewgeny,
>>>>
>>>>     Siremis is not designed for OpenSIPS and you may have huge
>>>>     compatibility
>>>>     issues - of course, if you want to dive into this, feel free :).
>>>>
>>>>     Maybe a better approach (for you and for the rest of the
>>>>     community) is
>>>>     to identify things that should be improved in OpenSIPS Control
>>>>     Panel and
>>>>     let's make it better.
>>>>
>>>>     Best regards,
>>>>
>>>>     Bogdan-Andrei Iancu
>>>>     OpenSIPS Founder and Developer
>>>>     http://www.opensips-solutions.com
>>>>
>>>>
>>>>     On 10/28/2013 04:11 PM, Ewgeny wrote:
>>>>     > Hello!
>>>>     >
>>>>     > Is that possible to use Siremis WEB GUI
>>>>     > http://siremis.asipto.com/2013/05/08/siremis-v4-0-0-released/
>>>>     with
>>>>     > Opensips ?
>>>>     > Siremis has better features for SIP Database management then
>>>>     Opensips
>>>>     > Control Panel, and lots of other feature that Opensip CP
>>>>     does'nt have.
>>>>     > I tried to install version 3.2 in conjunction with Opensips,
>>>>     but it
>>>>     > does not work well, a lot of errors.
>>>>     > Maybe someone has experience with Siremis and Opensips
>>>>     adaptation?
>>>>     >
>>>>     >
>>>>     > Best Regards,
>>>>     > Ewgeny
>>>>     >
>>>>     >
>>>>     >
>>>>     >
>>>>     > _______________________________________________
>>>>     > Users mailing list
>>>>     > Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>>>>     > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>     >
>>>>
>>>>     _______________________________________________
>>>>     Users mailing list
>>>>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>>>>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> 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/20131101/77eea99b/attachment-0001.htm>


More information about the Users mailing list