Re: [SR-Users] siremis: login error / http error 404

[Elena-Ramona Modroiu]

Hi,


On 10/31/11 11:26 AM, Uwe Andersen wrote:

Hi,

I have installed Siremis 2.0.0 and Kamaillio 3.2.0 on a OpenSuse 11.4 system.
After the Siremis Web Installation Wizard finished the setup the login failed 
with a http error 404.

The Apache2.0 error_log shows:
[Mon Oct 31 11:09:49 2011] [error] [client ::1] File does not exist: 
/var/www/siremis-2.0.0/siremis/system, referer: 
http://localhost/siremis/index.php/user/login

The Apache2.0 access_log shows:
::1 - - [31/Oct/2011:11:09:36 +0100] "GET 
/siremis/bin/antispam_image.php?form=user.form.LoginForm&name=antispam&length=6&level=2?rand=1768032447 
HTTP/1.1" 200 240 "http://localhost/siremis/index.php/user/login"; "Mozilla/5.0 (X11; Linux i686; 
rv:7.0.1) Gecko/20100101 Firefox/7.0.1"
::1 - - [31/Oct/2011:11:09:48 +0100] "POST 
/siremis/bin/controller.php?F=RPCInvoke&P0=[user.form.LoginForm]&P1=[Login]&__this=btn_login:onclick&jsrs=1 
HTTP/1.1" 200 214 "http://localhost/siremis/index.php/user/login"; "Mozilla/5.0 (X11; Linux i686; 
rv:7.0.1) Gecko/20100101 Firefox/7.0.1"
::1 - - [31/Oct/2011:11:09:49 +0100] "GET /siremis/system/general_default HTTP/1.1" 404 1331 
"http://localhost/siremis/index.php/user/login"; "Mozilla/5.0 (X11; Linux i686; rv:7.0.1) 
Gecko/20100101 Firefox/7.0.1"

Is there anybody how can help me out of this?


do you have mod_rewrite enabled in your apache2 server?

Regards,
Ramona

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Siremis installation problem

[Elena-Ramona Modroiu]

Hi,

On 11/20/11 6:47 PM, Jonny Klompas wrote:

Hi,

When trying to access the Siremis home page to login after the 
installation, I receive the following error:


The requested URL /siremis/index.php/user/login was not found on this 
server.

do you have mod_rewrite enabled on apache web server?

Regards,
Ramona
___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Siremis installation problem

[Elena-Ramona Modroiu]

Hi,

do you have 'AllowOverride All' in your apache config?

Regards,
Ramona

On 11/22/11 10:13 AM, Jonny Klompas wrote:

I do.

Thanks

Jonny

----
*From:* Elena-Ramona Modroiu 
*To:* Jonny Klompas ; SIP Router - Kamailio 
(OpenSER) and SIP Express Router (SER) - Users Mailing List 


*Sent:* Tuesday, November 22, 2011 10:57 AM
*Subject:* Re: [SR-Users] Siremis installation problem

Hi,

On 11/20/11 6:47 PM, Jonny Klompas wrote:

Hi,

When trying to access the Siremis home page to login after the 
installation, I receive the following error:


The requested URL /siremis/index.php/user/login was not found on this 
server.

do you have mod_rewrite enabled on apache web server?

Regards,
Ramona



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] sr-users Digest, Vol 78, Issue 62 (was: Siremis installation problem)

[Elena-Ramona Modroiu]

Try to preserve the subject to be easy to follow in the mailing list 
archive.


Can you check siremis/.htaccess file? Was it updated properly by 'make 
prepare'?


Also, rewrite.load is in the list of the modules to be loaded by apache? 
Have you done a2enmod rewrite?


Regards,
Ramona

On 11/23/11 1:11 PM, Jonny Klompas wrote:

I think AllowOverride All is correctly set, you can see my config below:

Contents of my /etc/apache2/sites-available/default file:


ServerAdmin webmaster@localhost

DocumentRoot /var/www

Options FollowSymLinks
AllowOverride  None


Options Indexes FollowSymLinks MultiViews
AllowOverride All
Order allow,deny
allow from all


ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/

AllowOverride None
Options +ExecCGI -MultiViews +SymLinksIfOwnerMatch
Order allow,deny
Allow from all


ErrorLog ${APACHE_LOG_DIR}/error.log

# Possible values include: debug, info, notice, warn, error, crit,
# alert, emerg.
LogLevel warn

CustomLog ${APACHE_LOG_DIR}/access.log combined

Alias /doc/ "/usr/share/doc/"

Options Indexes MultiViews FollowSymLinks
AllowOverride None
Order deny,allow
Deny from all
Allow from 127.0.0.0/255.0.0.0 ::1/128




Alias /siremis "/var/www/siremis-2.0.0/siremis"

Options Indexes FollowSymLinks MultiViews
AllowOverride All
Order allow,deny
Allow from all

Order deny,allow
Deny from all


Order deny,allow
Deny from all



My rewrite.load file contains:
LoadModule rewrite_module /usr/lib/apache2/modules/mod_rewrite.so







*From:* "sr-users-requ...@lists.sip-router.org" 


*To:* sr-users@lists.sip-router.org
*Sent:* Wednesday, November 23, 2011 6:00 AM
*Subject:* sr-users Digest, Vol 78, Issue 62

Send sr-users mailing list submissions to
sr-users@lists.sip-router.org <mailto:sr-users@lists.sip-router.org>

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
or, via email, send a message with subject or body 'help' to
sr-users-requ...@lists.sip-router.org 
<mailto:sr-users-requ...@lists.sip-router.org>


You can reach the person managing the list at
sr-users-ow...@lists.sip-router.org 
<mailto:sr-users-ow...@lists.sip-router.org>


When replying, please edit your Subject line so it is more specific
than "Re: Contents of sr-users digest..."


Today's Topics:

  1. Re: Siremis installation problem (Elena-Ramona Modroiu)


----------

Message: 1
Date: Wed, 23 Nov 2011 09:15:51 +0100
From: Elena-Ramona Modroiu mailto:ram...@asipto.com>>
Subject: Re: [SR-Users] Siremis installation problem
To: sr-users@lists.sip-router.org <mailto:sr-users@lists.sip-router.org>
Message-ID: <4eccabb7.4010...@asipto.com 
<mailto:4eccabb7.4010...@asipto.com>>

Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"

Hi,

do you have 'AllowOverride All' in your apache config?

Regards,
Ramona

On 11/22/11 10:13 AM, Jonny Klompas wrote:
> I do.
>
> Thanks
>
> Jonny
>
> 
> *From:* Elena-Ramona Modroiu <mailto:ram...@asipto.com>>
> *To:* Jonny Klompas <mailto:jonny.klom...@yahoo.com>>; SIP Router - Kamailio

> (OpenSER) and SIP Express Router (SER) - Users Mailing List
> mailto:sr-users@lists.sip-router.org>>
> *Sent:* Tuesday, November 22, 2011 10:57 AM
> *Subject:* Re: [SR-Users] Siremis installation problem
>
> Hi,
>
> On 11/20/11 6:47 PM, Jonny Klompas wrote:
>> Hi,
>>
>> When trying to access the Siremis home page to login after the
>> installation, I receive the following error:
>>
>> The requested URL /siremis/index.php/user/login was not found on this
>> server.
> do you have mod_rewrite enabled on apache web server?
>
> Regards,
> Ramona
>
>
>
> ___
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users@lists.sip-router.org <mailto:sr-users@lists.sip-router.org>
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- next part --
An HTML attachment was scrubbed...
URL: 
<http://lists.sip-router.org/pipermail/sr-users/attachments/2023/740f390

[SR-Users] Siremis v2.1.0 Released

[Elena-Ramona Modroiu]

Siremis v2.1.0 has been released - this is an update to previous release 
v2.0.0, bringing several enhancements and new web pages to manage PUA 
and RLS. It is still compatible with Kamailio v3.1.x, the last of this 
kind, next one to be out in the near future will be compatible with 
Kamailio v3.2.x.


You can find the news about this release, including links to download, 
screenshots and demos, at:


  * http://siremis.asipto.com/2011/11/23/siremis-v2-1-0-released/

Alternative download site (tarball or git pull) is from sourceforge project:

  * http://sourceforge.net/projects/siremis/

Regards,
Ramona

PS. Siremis v2.1.0 is working for most of the components with Kamailio 
3.2.0, just the few that changed the database structure may not be fully 
functional (e.g., the modules with tables that have new columns, see 
http://www.kamailio.org/wiki/install/upgrade/3.1.x-to-3.2.0#sql_commands).


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

[SR-Users] Siremis v3.2.0 Released

[Elena-Ramona Modroiu]

Hi,

Siremis v3.2.0 is out - the web management interface for Kamailio and 
SER v3.2.x series.


Besides updates to existing views to match the database schema in 
Kamailio v3.2.x (such as lcr, dialog or siptrace), there are many new 
features. Among most important:


- SQL-based CDR rating engine for billing purposes, with views to manage 
the rating rules

- charts and table summaries to reflect the activity of accounting records
- new views to manage records for remote registrations, mtree and global 
black list
- command line tools to add new database table views in a step-by-step 
wizard fashion
- selection of usernames and domains for many views can be done by a 
select box or picker form with values from subscriber or domain tables


More details can be find in the announcement of the release on the web site:

  * http://asipto.com/u/4t

or in the ChangeLog inside the tarball.

Siremis can be downloaded from:

  * http://asipto.com/u/sd

Alternative download site, along with the GIT repository for Siremis, is 
offered at sourceforge.net project:


  * http://sourceforge.net/projects/siremis/

Regards,
Ramona

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] 回复： Why? there isn't a syslog.conf under mykamailiodirectory?

[Elena-Ramona Modroiu]

Hi,

regarding the configuration of syslog to write kamailio log messges in a 
special file, you can find couple of tutorials on kamailio.org wiki 
sites. One is:


http://www.kamailio.org/wiki/tutorials/3.2.x/syslog

Regards,
Ramona


 On 12/20/11 10:35 AM, sunny_day wrote:

I got it . Thank you Michal :)
--
albert.gu
-- 原始邮 件 --
*发件人:* "Michal Matyska";
*发送时间:* 2011年12月20日(星期二) 下午5:20
*收件人:* "SIP Router - Kamailio (OpenSER) and SIP Express Router 
(SER) - UsersMailing List";
*主题:* Re: [SR-Users] Why? there isn't a syslog.conf under 
mykamailiodirectory?

Hi,

use -E option and you'll get all the logs on the sterr.

Michal

sunny_day píše v Út 20. 12. 2011 v 17:10 +0800:
> Olle , Thank you very much for your reply!
> I am not the root user on the unix system. but I want to customize the
> log file for the function:  xlog.
> Now, I don't know where to see the content what xlog writes. It can
> help me to debug the script of kamailio.cfg i edited.
>
> what i do is collect the CDRs by dialog and acc modules. Any
> suggestion will be appreciated.
>
> Thanks a lot !
>
> --
> albert.gu
>
>
> -- Original --
> From:  "Olle E. Johansson";
> Date:  Tue, Dec 20, 2011 04:57 PM
> To:  "SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) -
> UsersMailing List";
>
> Subject:  Re: [SR-Users] Why? there isn't a syslog.conf under my
> kamailiodirectory?
>
>
> 20 dec 2011 kl. 05:57 skrev sunny_day:
>
> > There should be a syslog.conf file under the kamailio directory.
> > But I haven't.
> >
> > I only want to see the contents generated by "xlog"
>
> Syslog is a daemon in your operating system. The configuration file is
> propably in the /etc
> directory. Try running "man syslog.conf" for more information about
> that file.
>
> /O
>
>
> ___
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
> list
> sr-users@lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
> ___
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users@lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Hashed Passwords

[Elena-Ramona Modroiu]

Hi,

On 1/9/12 12:25 AM, Ben WIlliams wrote:

Is it possible to make Siremis store passwords in plaintext?


siremis stores plaintext password, but I assume you want not to store.

At this moment there is no config option for that, it will store plain 
text. You can update in the php file 
siremis/modules/ser/sbs/authdb/do/SubscriberDO.php to set an emty value 
for password field and just store ha1 and ha1b -- the file online in git 
repo:


http://siremis.git.sourceforge.net/git/gitweb.cgi?p=siremis/siremis;a=blob;f=siremis/modules/ser/sbs/authdb/do/SubscriberDO.php;hb=HEAD

After computation of ha1 and ha1b, reset the value of  $recArr['password'].

Also, as alternative, you can have a cron.d job to delete the values in 
password column of subscriber table.


Regards,
Ramona


  I've just
converted to hashed passwords as well and
kamctlrc has STORE_PLAINTEXT_PW=0 but Siremis is still storing
passwords in plaintext.

On Wed, Jan 4, 2012 at 12:28 AM, Ali Jawad  wrote:

Did trigger an email to fast this time, for people who might get here
using Google

modparam("auth_db", "calculate_ha1", yes)
should be
modparam("auth_db", "calculate_ha1", 0)

On Tue, Jan 3, 2012 at 1:03 PM, Ali Jawad  wrote:

Hi All
We are using plain text passwords for authentication, for the obvious
reasons we want to change to hashed passwords so first I executed the
following on the SQL server :

update subscriber set ha1 = md5(concat(username, ':', domain, ':',
password)), ha1b = md5(concat(username, '@', domain, ':', domain, ':',
password))

The related config is :



# - auth_db params -
#!ifdef WITH_AUTH
modparam("auth_db", "db_url", DBURL)
modparam("auth_db", "calculate_ha1", yes)
modparam("auth_db", "password_column", "ha1")
modparam("auth_db", "load_credentials", "")
modparam("auth_db", "use_domain", MULTIDOMAIN)

and

# - auth_db params -
#!ifdef WITH_AUTH
modparam("auth_db", "db_url", DBURL)
modparam("auth_db", "calculate_ha1", yes)
modparam("auth_db", "password_column", "ha1")
modparam("auth_db", "load_credentials", "")
modparam("auth_db", "use_domain", 1)


But I keep getting unauthorized, what did I miss here.

Regards



--
Ali Jawad
Information Systems Manager
Splendor Telecom (www.splendor.net)
Beirut, Lebanon
Phone: +9611373725/ext 116
FAX: +9611375554

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users




___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Backing up htable to SQL table ...

[Elena-Ramona Modroiu]

Hi,

I committed the patch in master branch, but I removed the condition 
'ht_db_expires_flag!=0', because it is used to control if expires column 
is saved in database, nothing else. If I misunderstood something, let me 
know, if not and all works fine for you with the commit, then the patch 
can be backported to 3.2.


Ramona

On 3/8/12 10:38 PM, Krishna Kurapati wrote:

Thanks Daniel for the help. I was looking at other module parameters.
I added this like and tried it again

modparam("htable", "htable","xhash=>size=8;dbtable=htable;dbmode=1;")

However, it was still not backing up to the database. Seems like there 
is bug when the expiration is not set or

set to 0. I modified the code and it worked.

Here is the change log:

--- a/modules_k/htable/ht_db.c
+++ b/modules_k/htable/ht_db.c
@@ -369,10 +369,12 @@ int ht_db_save_table(ht_t *ht, str *dbtable)
it->name.len, it->name.s, 
it->value.n);

}
-   if (it->expire <= now) {
+   if(ht->htexpire > 0 && ht_db_expires_flag!=0) {
+  if (it->expire <= now) {
LM_DBG("skipping expired entry");
it = it->next;
continue;
+  }
}

If this is the right fix for the bug, can someone commit this to the main?

Thanks
Krishna Kura

On Wed, Mar 7, 2012 at 9:48 PM, Krishna Kurapati > wrote:


Any help on how to backup the htable content to database table?

Thanks


On Tue, Mar 6, 2012 at 5:28 PM, Krishna Kurapati
mailto:kkura...@gmail.com>> wrote:

I did little more digging into htable source code. It looks
like syncing to database is happening when the module is being
destroyed.

To see if this is working, I tried to stop Kamailio and looked
into the database. The htable is still empty. Any configuration
changes required to make the process happen?

Thanks
Krish Kura

On Tue, Mar 6, 2012 at 8:38 AM, Krishna Kurapati
mailto:kkura...@gmail.com>> wrote:

Hi,

This is my first time attempt using htable module.
How can I back up the htable content in the database
incase the server restarts. I saw a htable in the MySQL
database.
My observation has been that htable module is not
automatically backing up to database even though I added
modparams to point to the database. Do I need to
explicitly backup htable content to database using sqlops
or some
other mechanism?

Thanks
Krish Kura






___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Siremis on Mysql and Kamailio on Postgresql

[Elena-Ramona Modroiu]

Hi,

the patch is to phpopenbiz framework, which is not included in siremis 
git repository. But we can include the patch itself and document it, can 
you add it as attachment to sourceforge tracker?


http://sourceforge.net/tracker/?atid=3020101&group_id=250738&func=browse

Regards,
Ramona


On 4/16/12 10:30 AM, Victor Seva wrote:

This patch seems to do the trick.

root@zs2:/var/www/siremis-3.2.0# diff -ruN
openbiz/bin/data/BizDataSql.php~ openbiz/bin/data/BizDataSql.php
--- openbiz/bin/data/BizDataSql.php~2010-09-15 15:09:29.0 +0200
+++ openbiz/bin/data/BizDataSql.php 2012-04-16 10:23:38.0 +0200
@@ -46,7 +46,7 @@
  public function addMainTable($mainTable)
  {
  $this->_mainTable = "$mainTable";
-$this->_tableJoins = " `$mainTable` T0 ";
+$this->_tableJoins = " $mainTable T0 ";
  }

  /**
@@ -74,7 +74,7 @@
  $this->_joinAliasList[$tableJoin->m_Name] = $alias;
  $this->_tableAliasList[$table] = $alias;
  $aliasRef = $this->getJoinAlias($joinRef);
-$this->_tableJoins .= " $joinType `$table` $alias ON
$alias.$column = $aliasRef.$columnRef ";
+$this->_tableJoins .= " $joinType $table $alias ON
$alias.$column = $aliasRef.$columnRef ";
  }

  /**
@@ -245,7 +245,7 @@
  //if (strpos($this->m_TableJoins, "JOIN $xtable") === false)
  if (!isset($this->_tableAliasList[$xtable]))
  {
-$this->_tableJoins .= " INNER JOIN `$xtable` $xalias
ON $xalias.$column2 = $mytable_col ";
+$this->_tableJoins .= " INNER JOIN $xtable $xalias ON
$xalias.$column2 = $mytable_col ";
  $this->_tableAliasList[$xtable] = $xalias;
  }
  // add a new where condition

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users




___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Siremis on Mysql and Kamailio on Postgresql

[Elena-Ramona Modroiu]

Hi,

add also this patch to the sourceforge tracker:

http://sourceforge.net/tracker/?atid=3020101&group_id=250738&func=browse

It will be applied to git -- few questions:

- have you tested and still works with MySQL?

- the last chunk in patch is related to xml config files - does not seem 
necessary:


--- siremis-3.2.0.orig/siremis/modules/ser/service/siremisCharts.xml
2011-12-14 19:52:59.0 +0100
+++ siremis-3.2.0/siremis/modules/ser/service/siremisCharts.xml 2012-04-16 
13:23:15.0 +0200
@@ -16,7 +16,7 @@



-   
+   

 
   

Regards,
Ramona

On 4/16/12 4:09 PM, Victor Seva wrote:

But there are querys on siremis using mysql format.


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] sdpops kamailio ans Siremis

[Elena-Ramona Modroiu]

Hi,

On 5/3/12 3:52 PM, Grégoire Vandendeurpel wrote:
Hi, I'm using Siremis 3.2 ans Kamailio 3.2.3 for my final project of 
my bachloor degree


I would like to know how Siremis and Kamailio work together? Like:

If I decide to set a protocol in the acl trusted in Siremis like TLS, 
ok, it works well !!
But I need to know the different links between siremis and kamailio to 
working well..


there are two main categories in the interaction between siremis and 
kamailio:


1) siremis offers web views to manage records in database tables used by 
kamailio
2) siremis offers several tools to interact with kamailio via MI/XMLRPC 
and display graphics based on statistics exported by kamailio




Why?

Cause I need to implement in Siremis a filter form on the sdpops 
module, and it has to work well of course with the database of ser!


Right now siremis is developed to work with kamailio database (which is 
created by 'kamctldb create' and is named so far 'openser').


So.. What are the different steps to do this?

- Create new table sdpops in ser
- create the form in siremis and view ..
- what in kamailio.cfg??

I found this: http://kb.asipto.com/siremis:install32x:new-views

OK, but in my case, I need to do that for SDPOPS, which is a module of 
kamailio, whithout any table and components about!


I mean, there is no openser.sdpops in the database of kamailio, so 
create the table ok.. but what are the columns, datas, to set in ??


cause I tried php gen_meta.php Serdb sdpops ser.acl.sdpops  of course 
it does not work --> no openser.sdpops ..


sdpops module does not use any database table. It exports only functions 
to use in config file, the parameters being given from config file 
(nothing is loaded from database by sdpops).


I don't understand why you look of a database view in siremis for sdpops 
module, it does not have/need one.


You should describe in more details what exactly you want to do and we 
may be able to give some hints how to implement it. Give some example of 
records you want to store and what kamailio should do with them.


Regards,
Ramona





thx in advance for your help

Best regards

--
/*Grégoire Vandendeurpel, */
/
/
/_IT Sector_/


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Siremis on Mysql and Kamailio on Postgresql

[Elena-Ramona Modroiu]

Hi,

On 4/17/12 8:23 AM, Victor Seva wrote:

2012/4/16 Elena-Ramona Modroiu:

Hi,

the patch is to phpopenbiz framework, which is not included in siremis git
repository. But we can include the patch itself and document it, can you add
it as attachment to sourceforge tracker?

http://sourceforge.net/tracker/?atid=3020101&group_id=250738&func=browse

I already contacted with openbiz comunity to point the problem [0].

[0] https://groups.google.com/d/topic/openbiz-cubi/4KdlKRQ9-ng/discussion
great! Still it would be good to have it in siremis tracker on 
sourceforge, for references in the future and to be easy to find it.


Regards,
Ramona


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Siremis upload file

[Elena-Ramona Modroiu]

Hi,

this is more related to phpopenbiz/cubi frameworks used to build 
siremis. Maybe you get some hints on their forums.


Is it any message you get in the syslog files of the http server?

Regards,
Ramona

On 4/23/12 12:02 PM, Jesús Pérez Rubio wrote:

Hi, I have a problem making some changes on siremis front-end
everything was ok except when I try to add a field to upload a file
I got this error:
#2, fopen(ejemplo.csv): failed to open stream: No such file or directory
could anybody help me please? :)

Mi configuration:
DO:
Required="N" Type="Blob"/>


Insert:
Label="File (.csv)" AllowURLParam="N"/>


.php:
public function InsertRecord($recArr)
{
return parent::InsertRecord($recArr);
}

SQL:
mysql> desc batch_provision;
++-+--+-+-++
| Field  | Type| Null | Key | Default | Extra  |
++-+--+-+-++
| id | int(11) | NO   | PRI | NULL| auto_increment |
| batch_file | blob| YES  | | NULL||
++-+--+-+-++
2 rows in set (0.02 sec)

Thanks in advance.

--
Jesús Pérez
VoIP Engineer at Quobis

Fixed: +34 902 999 465
Site: http://www.quobis.com 



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] [SIREMIS] send MI Commands to multiple kamailio servers

[Elena-Ramona Modroiu]

Hi,

current version of siremis does not support to send MI commands to 
multiple kamailio servers. One thing that has to be taken in 
consideration is handling the MI replies. One option, they can be 
appended one after the other and displayed in the text box of siremis 
page, separated by some delimiter with details about the instance that 
replied (ip address/port).


If you submit the patch, it will be committed and released with the next 
version. In case you plan more consistent contributions, once you have 
them developed, I can grant write access to sourceforge.net git 
repository for siremis, so you will be able to commit yourself.


Regards,
Ramona

On 5/14/12 8:33 AM, SamyGo wrote:

Hello all,

Following through the manual at : 
http://kb.asipto.com/siremis:install32x:mi-commands  I'm able to send 
MI commands on external/remote server But next hurdle is how can I 
define multiple remote servers i.e






Is there any already working configuration else I think I may need to 
start a surgery on siremisMICommands.php file and make it loop over 
the remote tag and disptach commands until loop ends.

is there any "MI-proxy" sort of thing available !!?

Regards,
Sammy.




___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

[SR-Users] Siremis v3.2.1 Released

[Elena-Ramona Modroiu]

Hi,

Siremis v3.2.1 is out, the web management interface for Kamailio SIP 
Server. It is the last release with new features planned to be 
compatible with Kamailio v3.2.x. Next major releases for Siremis will 
target upcoming Kamailio v3.3.x.


This time new features relate to web pages that allow management of own 
profile by SIP users, such as changing SIP password, management of speed 
dials or views for accounting, cdrs and location records. There was also 
added a form for doing user registrations (e.g., can be used for 
allowing public registrations).


You can read more details about the release as well as details about 
installation at:

  * http://siremis.asipto.com/

Regards,
Ramona

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

[SR-Users] Siremis v3.3.0 Released

[Elena-Ramona Modroiu]

Hi,

Siremis v3.3.0 was released - the web management interface compatible 
with Kamailio v3.3.x. This version is an update of v3.2.1 to be able to 
work with the database schema of Kamailio v3.3.x.


The news of the release, including links to installation and 
screenshots, is available at:

  - http://siremis.asipto.com/2012/09/06/siremis-v3-3-0-released/

Regards,
Ramona

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

[SR-Users] Siremis v4.1.0 Released

[Elena-Ramona Modroiu]

Hi,

a new release of Siremis is out - v4.1.0 - web management interface that 
is compatible out of the box with Kamailio v4.1.x series.


More details, including link to install tutorial, are available at:

   - http://siremis.asipto.com/2014/03/25/siremis-v4-1-0-released/

Regards,
Ramona


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Htable iterators, am I doing it wrong?

[Elena-Ramona Modroiu]

Try with latest version from git branch 4.2. I committed a fix for a 
last minute optimization done for searching the iterator by name.


Ramona

On 27/10/14 15:47, davy van de moere wrote:

I was giving the htable iterator a go , but I can't get it to work.

My relevant config would is:

modparam("htable", "htable", "testhtable=>size=4;")


in the request route I have this:


sht_iterator_start("i1", "testhtable");

 while(sht_iterator_next("i1")) {

  xlog("L_INFO","  $shtitkey(i1) is: $shtitval(i1)\n");

 }

sht_iterator_end("i1");


I added some values to my testhtable:


$ kamcmd htable.dump testhtable

{

entry: 0

size: 2

slot: {

item: {

name: x[0]

value: 1

}

item: {

name: x[1]

value: 1

}

}

}

But when I have something route over that part I get:



Oct 27 15:33:36  kamailio[18828]: INFO: 

Re: [SR-Users] OpenBiz error signing into Siremis 4.1

[Elena-Ramona Modroiu]

Can someone test using newer php versions and the latest git version of 
siremis from git hub?


  - https://github.com/asipto/siremis

It includes a newer smarty framework and seems to work ok with php 5.5 
(on ubuntu trusty/linux mint 17).


Regarding the error with database, maybe php 5.6 has different api for 
PDO or other new restrictions. I couldn't test with this version, if 
anyone can confirm the error is still there with latest siremis git, I 
will try to investigate more.


Ramona

On 04/12/14 19:45, Peter Villeneuve wrote:
To reiterate. The issues seem to only popup on PHP versions greater 
than 5.4.

Everything below 5.5 (like your 5.3) should work as expected.

On Thu, Dec 4, 2014 at 5:42 PM, Virmantas Variakojis 
> wrote:


Works fine for me with php 5.3

2014 gruod. 4 18:26 "Peter Villeneuve" mailto:peterv...@gmail.com>> ras(e.:

I can confirm there are issues with siremis and newer php
versions.
I have seen problems with Siremis and PHP > 5.4.
In fact I reported that back in May in the sr-dev list but got
no response.
http://lists.sip-router.org/pipermail/sr-dev/2014-May/024183.html

My errors were popping up with 5.5. I guess that with 5.6 it
gets even worse.

It seems that siremis needs to be updated to work with php
greater then 5.4

Cheers,

Peter

On Thu, Dec 4, 2014 at 3:29 PM, Daniel Shoemaker
mailto:danco...@gmail.com>> wrote:

It's all working.  Thanks for your help.  Apparently there
is an issue with php 5.6.  When I got rid of it and
installed php 5.4 it worked instantly.

Dan

On Thu, Dec 4, 2014 at 6:27 AM, Daniel Shoemaker
mailto:danco...@gmail.com>> wrote:

When I try to sign into Siremis 4.1 using admin and
the default password it gives me a pop-up saying that
Openbiz has encountered an error:

[{"target":"ERROR","content":"
\n[2014-11-17 11:51:15 (GMT)] An exception occurred
while executing this script:
\nError message: #8192, Non-static method
BizSystem::dbConnection() should not be called
statically, assuming $this from incompatible
context<\/font>
\nScript name and line number of error:

\/var\/www\/siremis-4.1.0\/openbiz\/bin\/data\/BizDataObj_Abstract.php:423<\/font>
\n

*function:<\/b> errorHandler ( 8192, \"Non-static
method BizSystem::dbConnection() should not be
called...\",

\"\/var\/www\/siremis-4.1.0\/openbiz\/bin\/data\/BizDataObj_Abstract.php\",
423, Array(0) ) @
\/var\/www\/siremis-4.1.0\/openbiz\/bin\/sysheader.inc
117\n
*function:<\/b> userErrorHandler ( 8192, \"Non-static
method BizSystem::dbConnection() should not be
called...\",

\"\/var\/www\/siremis-4.1.0\/openbiz\/bin\/data\/BizDataObj_Abstract.php\",
423, Array(0) ) @

\/var\/www\/siremis-4.1.0\/openbiz\/bin\/data\/BizDataObj_Abstract.php
423\n
*function:<\/b> getDBConnection ( ) @

\/var\/www\/siremis-4.1.0\/openbiz\/bin\/data\/BizDataObj_Lite.php
406\n
*function:<\/b> _run_search ( Array(2) ) @

\/var\/www\/siremis-4.1.0\/openbiz\/bin\/data\/BizDataObj_Lite.php
345\n
*function:<\/b> fetchRecords ( \"[username]='admin'
and status='1'\", Array(0), 1 ) @

\/var\/www\/siremis-4.1.0\/siremis\/modules\/service\/authService.php
98\n
*function:<\/b> authDBUser ( \"admin\", \"admin\" ) @

\/var\/www\/siremis-4.1.0\/siremis\/modules\/service\/authService.php
66\n
*function:<\/b> authenticateUser ( \"admin\",
\"admin\" ) @

\/var\/www\/siremis-4.1.0\/siremis\/modules\/user\/form\/LoginForm.php
92\n
*function:<\/b> Login ( ) @
\/var\/www\/siremis-4.1.0\/openbiz\/bin\/BizController.php
310\n
*function:<\/b> invoke ( ) @
\/var\/www\/siremis-4.1.0\/openbiz\/bin\/BizController.php
110\n
*function:<\/b> dispatchRequest ( ) @
\/var\/www\/siremis-4.1.0\/openbiz\/bin\/BizController.php
32\n
*function:<\/b> include_once (
\"\/var\/www\/siremis-4.1.0\/openbiz\/bin\/BizController.php\"
) @
\/var\/www\/siremis-4.1.0\/siremis\/bin\/controller.php 
6<\/div>\n


-

[SR-Users] Siremis v4.2.0 Released

[Elena-Ramona Modroiu]

Hi,

Siremis v4.2.0 has been released, web management interface aiming at 
compatibility with Kamailio v4.2.x series - notes about release are 
available at:


  - http://siremis.asipto.com/2015/02/02/siremis-v4-2-0-released/

Ramona

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] [Kamailio-Users] How can i install and configuration CDRTool + Freeradius + mediaproxy + kamailio

[Elena-Ramona Modroiu]

Hi Rajnikant,

you may also have a look at Siremis web management interface for 
Kamailio, a light-weight application that you can use for accounting 
purposes too.

http://siremis.asipto.com/install-accounting/

For a quick look at Siremis, here you can get a demo with 
username=admin, password=admin:

http://siremis.asipto.com/demo/

Best regards,
Ramona


On 04/23/2010 09:22 AM, RAJNIKANT VANZA wrote:

Hi All,

I would like to use CDRTool for accounting and integrate with kamailio 
+ mediaproxy + freeradius.


so, please let me know about configuration or installation steps for 
CDRTool on centos-5.X os.


I have followed this link for CDRTool configuration 
http://cdrtool.ag-projects.com/wiki/Install 


but not success and confused.

I have seen above url for CDRTool that provides information for deban 
os. but i want to install on centos.


I am installed and run kamailio and mediaproxy successful.

I am confused about compile or install about CDRTool and i want to 
help about Freeradius integration with kamailo and CDRTool.


Thanks in advance.

--
Best Regards,

Rajnikant


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
   


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Acnnot get Kamailio to start ... GRRR

[Elena-Ramona Modroiu]

Hi Nelson,

here it is a step by step tutorial to install Kamailio 3.0 for Debian/Ubuntu

http://www.kamailio.org/dokuwiki/doku.php/install:kamailio-3.0.x-from-git

Cheers,
Ramona


On 05/18/2010 06:55 PM, Nelson Pereira wrote:


Basic install with source using the provided script:

make_and_install install "standard"

then try to do :

/usr/local/sbin/kamctl start

INFO: Starting Kamailio :

ERROR: PID file /var/run/kamailio.pid does not exist -- Kamailio start 
failed


r...@qa-qsuitepbx-01:/usr/local/sbin#

What am I doing wrong?

*Nelson Pereira*


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
   


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Siremis 1.0 login fails (or, does nothing)

[Elena-Ramona Modroiu]

Hi,

do you have mysql module for php installed?

Regards,
Ramona


On 05/26/2010 10:07 PM, Joe Micciche wrote:

RHEL5.5 server
Kamailio 3.0 built from source via Git
Apache/2.2.3
PHP 5.3.2
MySQL 5.1.47

chown -R apache /var/www/html/siremis-1.0.0, apache is the httpd user.

Used the instructions from Asipto's site for Siremis install and
configure, added the alias to httpd.conf, Config.xml is:




 
 



I navigate to the Siremis page, http://10.5.10.21/siremis/ and get the
login screen, enter the login credentials, Submit, and nothing happens.

httpd/error_log:
[Wed May 26 12:49:45 2010] [error] [client 10.3.226.168] File does not
exist: /var/www/html/siremis-1.0.0/siremis-web/js/sound.js, referer:
http://10.5.10.21/siremis/bin/
[Wed May 26 12:49:45 2010] [error] [client 10.3.226.168] File does not
exist: /var/www/html/siremis-1.0.0/siremis-web/js/sound.js, referer:
http://10.5.10.21/siremis/bin/

I have wiped Siremis and done a fresh install, restarted httpd, and
still nothing.

Does anyone have ideas or suggestions on where else to look?

   



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Siremis 1.0 login fails (or, does nothing)

[Elena-Ramona Modroiu]

On 05/26/2010 10:27 PM, Joe Micciche wrote:

On 05/26/2010 04:20 PM, Elena-Ramona Modroiu wrote:
   

Hi,

do you have mysql module for php installed?
 

Yes I do.

Package matching php-mysql-5.1.6-27.el5.i386 already installed.
   

What do you get then for:

http://10.5.10.21/siremis/bin/home.php


Ramona



joe

   

Regards,
Ramona


On 05/26/2010 10:07 PM, Joe Micciche wrote:
 

RHEL5.5 server
Kamailio 3.0 built from source via Git
Apache/2.2.3
PHP 5.3.2
MySQL 5.1.47

chown -R apache /var/www/html/siremis-1.0.0, apache is the httpd user.

Used the instructions from Asipto's site for Siremis install and
configure, added the alias to httpd.conf, Config.xml is:



 
  
  
 


I navigate to the Siremis page, http://10.5.10.21/siremis/ and get the
login screen, enter the login credentials, Submit, and nothing happens.

httpd/error_log:
[Wed May 26 12:49:45 2010] [error] [client 10.3.226.168] File does not
exist: /var/www/html/siremis-1.0.0/siremis-web/js/sound.js, referer:
http://10.5.10.21/siremis/bin/
[Wed May 26 12:49:45 2010] [error] [client 10.3.226.168] File does not
exist: /var/www/html/siremis-1.0.0/siremis-web/js/sound.js, referer:
http://10.5.10.21/siremis/bin/

I have wiped Siremis and done a fresh install, restarted httpd, and
still nothing.

Does anyone have ideas or suggestions on where else to look?


   
 
   



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Siremis 1.0 login fails (or, does nothing)

[Elena-Ramona Modroiu]

On 05/26/2010 11:03 PM, Joe Micciche wrote:

On 05/26/2010 04:58 PM, Elena-Ramona Modroiu wrote:
   

What do you get then for:

http://10.5.10.21/siremis/bin/home.php
 

Exact same results, nothing happens.
   


but you get redirected to login page, right?

Can you check into files from siremis/log/ to see if you spot something 
unusual?


Also, can you create a simple php page to print the phpinfo() and 
double-check the mysql extension for php is enabled?


Ramona

httpd/error_log:
[Wed May 26 13:59:33 2010] [error] [client 10.3.226.168] File does not
exist: /var/www/html/siremis-1.0.0/siremis-web/js/sound.js, referer:
http://10.5.10.21/siremis/bin/login.php

httpd/access_log:
10.3.226.168 - - [26/May/2010:13:59:32 -0400] "GET /siremis/bin/home.php
HTTP/1.1" 302 - "-" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3)
Gecko/20100423 Firefox/3.6.3"
10.3.226.168 - - [26/May/2010:13:59:32 -0400] "GET
/siremis/bin/login.php HTTP/1.1" 200 2887 "-" "Mozilla/5.0 (X11; U;
Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Firefox/3.6.3"
10.3.226.168 - - [26/May/2010:13:59:33 -0400] "GET /siremis/js/sound.js
HTTP/1.1" 404 293 "http://10.5.10.21/siremis/bin/login.php"; "Mozilla/5.0
(X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423  Firefox/3.6.3"
10.3.226.168 - - [26/May/2010:13:59:44 -0400] "POST
/siremis/bin/controller.php HTTP/1.1" 200 1208
"http://10.5.10.21/siremis/bin/login.php"; "Mozilla/5.0 (X11; U; Linux
i686; en-US; rv:1.9.2.3) Gecko/20100423 Firefox/3.6.3"

   



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Siremis 1.0 login fails (or, does nothing)

[Elena-Ramona Modroiu]

On 05/27/2010 01:10 PM, Joe Micciche wrote:

On 05/27/2010 03:16 AM, Vicente wrote:
   

 Hi,

 I also had similar problems to log into Siremis some weeks ago. It
was caused by a combination of circumstances.

 First I had an error with the mysql password configured for Siremis.
No error messages pointed to that direction. After correcting the
password, I couldn't connect. Then I removed the cookies and temp files
on the browsers. And then I can login with Firefox or Camino. But still
can't login with Safari.

 What browser are you using?
 

Hi Vicente, I have cleared everything in my browsers and still no luck.
I am primarily using Firefox and Chromium, and have tried Epiphany,
Galeon, and even lynx.

The lack of any error messages is frustrating. Is there any way to turn
up debugging for Siremis?
   

what version of php are you using? If it is old, try:

- download siremis 0.9.1
- remove siremis-1.0.1/openbiz
- copy siremis-0.9.1/openbiz to siremis-1.0.1/
- try again

Note as well that in some OSes, connecting to openser database from 
127.0.0.1 is not same as localhost (which is used by kamctl to create 
openser user and database), so try with localhost instead of 127.0.0.1 
in siremis/metadata/Config.xml, in case you still get problems.



Ramona

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] PDT ran out of pkg memory using pdt_list

[Elena-Ramona Modroiu]

Hi,

On 07/20/2010 11:21 AM, Henning Westerholt wrote:

On Monday 19 July 2010, JR Richardson wrote:
   

[..]
When I added 180K records in the database, I got the "no more pkg mem"
error again.
I increased again:
#define PKG_MEM_POOL_SIZE 32*1024*1024
This allowed me to execute pdt_list with 180K records loaded.

I increased database record count to 240K and got the "no more pkg
mem" error again.

So I don't think it is prudent to just keep increasing
PKG_MEM_POOL_SIZE.  Is this an architectural limitation with fifo
pkg_mem, shouldn't this be a dynamic allocation if it's not within
shmem and has no affect on core sip-router function?  While the
pdt_reload and pdt_list is going on (takes a few seconds to load and
list), I don't see any problems with the sip-router executions.  I
guess I can just use the old fashion database query to look up routes
instead of fifo pdt_list.
 

Hi Jr,

if you don't use the PKG_MALLOC MM in your system at least the kamailio 1.5
will fallback to the system malloc, which don't have this size restrictions.
For 3.x/ sr there is an option to build the MI interface with system malloc as
well, it this commit:

commit 85f2302e8448ee20edb12bc3b4e2911ca3b111ec
Author: Daniel-Constantin Mierla
Date:   Mon Jun 29 12:34:08 2009 +0200

 lib/kmi: option to build it with system malloc

 - MI lib can be built independently of core with system malloc for pkg
   memory (see Makefile)
   


this is the option added to overcome the MI design limitations - while 
most of dumped structures are in shared memory, MI builds the output in 
PKG memory, resulting in insufficient space since shm is much bigger 
than pkg - also this sometime ended as well in lot of mem fragmentation 
for mi process in the past.


It needs to edit lib/kmi/Makefile and enable system malloc, recompile 
and reinstall.


Regards,
Ramona


Both workarounds should help in your case.

But you're right, its probably more meaningfull to just execute a DB query
instead of trying to pipe all this data through your (productive) sip server.

Regards,

Henning

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

   



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] PDT ran out of pkg memory using pdt_list

[Elena-Ramona Modroiu]

Hi,

On 07/20/2010 11:27 AM, Henning Westerholt wrote:

On Tuesday 20 July 2010, JR Richardson wrote:
   

[..]
So now I'm running out of shmem as well. After I loaded more than 320K
records in the pdt database table, I started getting these errors:
  0(17599) ERROR: pdt [pdtree.c:283]: bad parameters
  0(17599) INFO: pdt [pdt.c:490]: no prefix found in [711234]

shmem:real_used_size = 1247512
This parameter does not get above 1247512 without having a problem,
even though I have plenty of shmem available.

shmem:total_size = 33554432
shmem:used_size = 1229472
shmem:real_used_size = 1247512
shmem:max_used_size = 1247512
shmem:free_size = 32306920

I increased these parameters in config.h but that did not help:

/*used only if PKG_MALLOC is defined*/
#define PKG_MEM_POOL_SIZE 64*1024*1024

/*used if SH_MEM is defined*/
#define SHM_MEM_SIZE 64
 

Hi Jr,

its not necessary to re-compile the server to just increase the SHM mem pool.
You can give this as a config parameter or a server daemon parameter during
startup. Maybe there is also an bug present in the PDT, which somehow causes
this problems if you load that much records. I did a short look into the code,
there is a variable

#define PDT_MAX_DEPTH32
   


this defines the max length for prefixes (DIDs) that can be stored in 
the internal trees.



which somehow seems to restrict the maximum size of the internal (tree)
datastructure for queries. But i did not used this module so far - all i can
say is that during my test with cr we loaded more records without any problems
coming from the internal SHM MM, so i guess this is a limitation from the
module. Maybe you should also try to increase the pool to 512 MB (the mem is
just free also on a system level if its not used).
   


If there are many records then the shared memory size must be increased 
(command line parameter -m, e.g., -m 512). I used the module with over 
1million records without problem.


Regards,
Ramona

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] PDT ran out of pkg memory using pdt_list

[Elena-Ramona Modroiu]

Hi,

On 07/16/2010 11:51 PM, JR Richardson wrote:

Hi All,

I loaded up the PDT database with about 35K records and when I issue
the commad "kamctl fifo pdt_list" I get:

  3(3018) ERROR:  [tree.c:139]: no more pkg mem
  3(3018) ERROR: mi_fifo [fifo_fnc.c:509]: command (pdt_list) processing failed

Searching around I found the
http://www.kamailio.org/dokuwiki/doku.php/troubleshooting:memory which
suggest I adjust the pkg mem size in config.h.

In config.h, I found:

/*used only if PKG_MALLOC is defined*/
#define PKG_MEM_POOL_SIZE 4*1024*1024

So is this what I am supposed to adjust?  Maybe try:
#define PKG_MEM_POOL_SIZE 4*2048*2048
or
#define PKG_MEM_POOL_SIZE 8*1024*1024

Which one would be a logical adjustment?  Also, is there a correlation
between pkg mem and database record size as related to pdt_list?

The idea is to have a few 100K records loaded in kamailio and be able
to perform "kamctl fifo pdt_list | grep 512345" to show this prefix
route.  But without enough memory, doesn't work.
   


this is a limitation of MI control interface (as written in other email, 
there are workarounds).


Anyway, pdt_list can take the prefix as parameter, so you do not need to 
list entire tree and do grep, just list desired prefixes:

http://kamailio.org/docs/modules/stable/modules_k/pdt.html#id2854918

Regards,
Ramona

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] PDT ran out of pkg memory using pdt_list

[Elena-Ramona Modroiu]

Hi,

On 07/20/2010 12:37 PM, Henning Westerholt wrote:

On Tuesday 20 July 2010, Iñaki Baz Castillo wrote:
   

this is the option added to overcome the MI design limitations - while
most of dumped structures are in shared memory, MI builds the output in
PKG memory, resulting in insufficient space since shm is much bigger than
pkg - also this sometime ended as well in lot of mem fragmentation for mi
process in the past.
   

Hi Elena. This is also I'm a bit afraid of when using MI command to
manage large ammount of records (LCR, locations, 'address'
entries...).
Wouldn't make sense MI to use shared memory instead of private memory?
 

Hi Iñaki,

this would be possible, but its IMHO a bit wrong from a conceptional POV. This
FIFO command execution belongs to the MI process, and it should not affect the
working of other process which are busy routing SIP requests - they don't need
to see this as all. One workaround is as discussed is to just use system
malloc, another would be to partition the command execution in small steps
like we do for data loading in several modules.
   


agree, using shm does not bring benefits, but some drawbacks since shm 
involves locking for access, thus it affects the other processes (e.g., 
sip workers). It is better with system malloc, maybe this should be made 
default for MI.


Regards,
Ramona



But as i said earlier, its maybe not the best idea in general to pipe the
output of several houndred thousands rules through the MI interface,
especially if the information is available more or less similar in the
database.

Regards,

Henning

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
   



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] PDT ran out of pkg memory using pdt_list

[Elena-Ramona Modroiu]

On 07/20/2010 05:06 PM, JR Richardson wrote:

[..]
When I added 180K records in the database, I got the "no more pkg mem"
error again.
I increased again:
#define PKG_MEM_POOL_SIZE 32*1024*1024
This allowed me to execute pdt_list with 180K records loaded.

I increased database record count to 240K and got the "no more pkg
mem" error again.

So I don't think it is prudent to just keep increasing
PKG_MEM_POOL_SIZE.  Is this an architectural limitation with fifo
pkg_mem, shouldn't this be a dynamic allocation if it's not within
shmem and has no affect on core sip-router function?  While the
pdt_reload and pdt_list is going on (takes a few seconds to load and
list), I don't see any problems with the sip-router executions.  I
guess I can just use the old fashion database query to look up routes
instead of fifo pdt_list.

 

Hi Jr,

if you don't use the PKG_MALLOC MM in your system at least the kamailio
1.5
will fallback to the system malloc, which don't have this size
restrictions.
For 3.x/ sr there is an option to build the MI interface with system
malloc as
well, it this commit:

commit 85f2302e8448ee20edb12bc3b4e2911ca3b111ec
Author: Daniel-Constantin Mierla
Date:   Mon Jun 29 12:34:08 2009 +0200

 lib/kmi: option to build it with system malloc

 - MI lib can be built independently of core with system malloc for pkg
   memory (see Makefile)

   

this is the option added to overcome the MI design limitations - while most
of dumped structures are in shared memory, MI builds the output in PKG
memory, resulting in insufficient space since shm is much bigger than pkg -
also this sometime ended as well in lot of mem fragmentation for mi process
in the past.

It needs to edit lib/kmi/Makefile and enable system malloc, recompile and
reinstall.

Regards,
Ramona

 

Hi Ramona,

Thanks for your suggestions.  I started over with default mem
parameters in config.h and compiled with:
## uncomment next line for using system malloc with MI
DEFS+= -DMI_SYSTEM_MALLOC

I loaded the pdt database table with 360K records and also started
kamailio with '-m 512' but the table still has a max record
limitation, will not load propperly and I get these errors:
  0(22456) ERROR: pdt [pdtree.c:283]: bad parameters
  0(22456) INFO: pdt [pdt.c:490]: no prefix found in [2000171212]

Of course wihout a propper table load, pdt_list does not produce any
results (but i don;t get the pkg_mem error any more).

sip-router2:~# kamctl fifo get_statistics all
shmem:total_size = 536870912
shmem:used_size = 1229472
shmem:real_used_size = 1247560
shmem:max_used_size = 1255376
shmem:free_size = 535623352

There seems to still be a bottleneck with shmem, even through I have
512M+ available, I only seem to be using ~1.2M.  Is there an internal
shmem hard limit that can be adjusted?
   

Hi JR,

There is no limit hard-coded, I just loaded 1mio records in pdt 
(sdomain=*, prefix=1mio..2mio, domain=test.org) and statistics show:


shmem:total_size = 268435456
shmem:used_size = 26594256
shmem:real_used_size = 80148548
shmem:max_used_size = 80148548
shmem:free_size = 188286908

So the records are reflected in shared memory. What is the output of 
"kamailio -V"? What are the parameters for pdt?


Regards,
Ramona




___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] PDT ran out of pkg memory using pdt_list

[Elena-Ramona Modroiu]

On 07/20/2010 07:45 PM, JR Richardson wrote:

On Tue, Jul 20, 2010 at 12:04 PM, Elena-Ramona Modroiu
  wrote:
   

On 07/20/2010 05:06 PM, JR Richardson wrote:
 

[..]
When I added 180K records in the database, I got the "no more pkg mem"
error again.
I increased again:
#define PKG_MEM_POOL_SIZE 32*1024*1024
This allowed me to execute pdt_list with 180K records loaded.

I increased database record count to 240K and got the "no more pkg
mem" error again.

So I don't think it is prudent to just keep increasing
PKG_MEM_POOL_SIZE.  Is this an architectural limitation with fifo
pkg_mem, shouldn't this be a dynamic allocation if it's not within
shmem and has no affect on core sip-router function?  While the
pdt_reload and pdt_list is going on (takes a few seconds to load and
list), I don't see any problems with the sip-router executions.  I
guess I can just use the old fashion database query to look up routes
instead of fifo pdt_list.


 

Hi Jr,

if you don't use the PKG_MALLOC MM in your system at least the kamailio
1.5
will fallback to the system malloc, which don't have this size
restrictions.
For 3.x/ sr there is an option to build the MI interface with system
malloc as
well, it this commit:

commit 85f2302e8448ee20edb12bc3b4e2911ca3b111ec
Author: Daniel-Constantin Mierla
Date:   Mon Jun 29 12:34:08 2009 +0200

 lib/kmi: option to build it with system malloc

 - MI lib can be built independently of core with system malloc for
pkg
   memory (see Makefile)


   

this is the option added to overcome the MI design limitations - while
most
of dumped structures are in shared memory, MI builds the output in PKG
memory, resulting in insufficient space since shm is much bigger than pkg
-
also this sometime ended as well in lot of mem fragmentation for mi
process
in the past.

It needs to edit lib/kmi/Makefile and enable system malloc, recompile and
reinstall.

Regards,
Ramona


 

Hi Ramona,

Thanks for your suggestions.  I started over with default mem
parameters in config.h and compiled with:
## uncomment next line for using system malloc with MI
DEFS+= -DMI_SYSTEM_MALLOC

I loaded the pdt database table with 360K records and also started
kamailio with '-m 512' but the table still has a max record
limitation, will not load propperly and I get these errors:
  0(22456) ERROR: pdt [pdtree.c:283]: bad parameters
  0(22456) INFO: pdt [pdt.c:490]: no prefix found in [2000171212]

Of course wihout a propper table load, pdt_list does not produce any
results (but i don;t get the pkg_mem error any more).

sip-router2:~# kamctl fifo get_statistics all
shmem:total_size = 536870912
shmem:used_size = 1229472
shmem:real_used_size = 1247560
shmem:max_used_size = 1255376
shmem:free_size = 535623352

There seems to still be a bottleneck with shmem, even through I have
512M+ available, I only seem to be using ~1.2M.  Is there an internal
shmem hard limit that can be adjusted?

   

Hi JR,

There is no limit hard-coded, I just loaded 1mio records in pdt (sdomain=*,
prefix=1mio..2mio, domain=test.org) and statistics show:

shmem:total_size = 268435456
shmem:used_size = 26594256
shmem:real_used_size = 80148548
shmem:max_used_size = 80148548
shmem:free_size = 188286908

So the records are reflected in shared memory. What is the output of
"kamailio -V"? What are the parameters for pdt?

Regards,
Ramona
 

sip-router2:~# kamailio -V
version: kamailio 3.0.2 (i386/linux) a6141a
flags: STATS: Off, USE_IPV6, USE_TCP, USE_TLS, TLS_HOOKS,
DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MEM, SHM_MMAP, PKG_MALLOC,
F_MALLOC, USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT, USE_DNS_CACHE,
USE_DNS_FAILOVER, USE_NAPTR, USE_DST_BLACKLIST, HAVE_RESOLV_RES
ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16,
MAX_URI_SIZE 1024, BUF_SIZE 65535
poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.
@(#) $Id$
main.c compiled on 09:25:15 Jul 20 2010 with gcc 4.3.2
sip-router2:~#

# -  pdt params -
modparam("pdt", "db_url", "mysql://openserro:opense...@localhost/openser")
modparam("pdt", "char_list", "0123456789")
modparam("pdt", "check_domain", 0)
modparam("pdt", "fetch_rows", 5000)

Here is an interesting observation:
When I have 300K+ records in the pdt table, it seems like it will not
load properly and the shmem is very low, as expected without a large
memory pool needed to hold the records.  Statistics show:
shmem:total_size = 33554432
shmem:used_size = 1229472
shmem:real_used_size = 1247512
shmem:max_used_size = 1247512
shmem:free_size = 32306920
shmem:fragments = 11

When I decrease the table recrods to 240K, the complete table loads ok
and shmem reflect properly:
shmem:total_size = 33554432
shmem:used_size = 6349784
shmem:real_used_size = 8501144
shmem:max_used_size = 8501144
shmem:free_size = 25053288
s

Re: [SR-Users] Siremis 1.0.0 bug in LCR configuration?

[Elena-Ramona Modroiu]

Hi,

that column was added in 3.0.0 and not reflected in siremis. I just 
committed a patch for it on sourceforge.net svn:

http://sourceforge.net/projects/siremis/

Try with it and let me know if all is fine now.

I guess the 0 value behavior is something related to lcr module 
internals, maybe Juha can tell more.


Thanks for reporting,
Ramona


On 09/08/2010 11:55 AM, klaus.li...@inode.at wrote:

BTW:

additionally I found out that in case that all lcr_ids are set to '0' (as
it is by default in table gw!) the MI commands 'lcr_gw_dump' and
'lcr_lcr_dump' do not bring any result..
As soon as I change the lcr_ids to '1' (e.g.) all entries with a value
above '0' are visible with the two MI commands.

regards
Klaus

   

Hello list,

does anybody have experience in configuring LCR (gw and lcr table) in
the SQL database with siremis?

I found a problem that inserting a gateway via the menu "LCR Gateways"
is not possible without manual adaption in the database. It is no
problem inserting LCR Rules; the entries are representing all columns of
the SQL table "lcr". However, when I insert gateways that are linked
over the so called 'group_id' to the LCR Rules I can not find any field
in the WebGUI where I can put in a "lcr_id".
And that is the problem. When insertion of rules and gateways is
finished in the WebGUI I have to reload the lcr configuration e.g. with
the MI command "lcr_reload". But this is not possible, because kamailio
is displaying an error message, which looks like:

'ERROR: lcr [lcr_mod.c:1280]: gw grp_id<10>  of prefix<2910>  has no
gateways'

The reason of this error message is that the lcr_id of the table "gw" is
set to 0 (hardcoded). So it does not match when the rules are inserted
with another lcr_id (e.g. 1 instead of 0).

=>  why is it possible to insert a free lcr_id in the menu "LCR Rules"
but not in the menu "LCR Gateways"? If only lcr_id '0' is supported in
general, then this id should be fix in the menu "LCR Rules", too.


Am I wrong or does anybody else have an opinion to this topic?

regards,
Klaus


 
   



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

[SR-Users] Siremis v1.0.1 released

[Elena-Ramona Modroiu]

Hi,

Siremis, the web management interface for Kamailio, released v1.0.1. It 
is a patch update with fixes since v1.0.0. More about it at:

http://siremis.asipto.com/2010/09/14/siremis-v1-0-1-released/

The series 1.0.x will be kept compatible with Kamailio 3.0.x. A new 
major release is baked these days (new UI and features) to work with 
upcoming 3.1.0.


Regards,
Ramona

--
http://www.asipto.com

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

[SR-Users] Siremis v2.0 preview

[Elena-Ramona Modroiu]

Hi,

Siremis version 2.0 is planned to work with upcoming Kamailio or SER 3.1 
and by now is alpha version.


If you want to have a preview, then you can access it at:
http://demo.asipto.com/siremis20/

username: guest
password: guest

v2.0 brings a completely new face and many features, reusing the latest 
openbiz development framework, among them:

- easy 4 step web-based installer
- siremis account management (including roles per users)
- customizable menu from web interface
- customizable views from web interface
- rework of many kamailio/ser related components such as subscriber, 
siptrace, generic and usrloc charts


Siremis administration module, user profile management and web based 
customization elements are disabled in the demo, to avoid breaking the 
content.


Packaging is still under work, but if someone is good at php/xml, likes 
to dig in by itself to sort out issues and wants to help with testing, I 
can ship a raw tarball, just drop me an email. Feedback about this new 
version is also appreciated, in order to improve it.


Regards,
Ramona



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Siremis v2.0 preview

[Elena-Ramona Modroiu]

On 09/22/2010 04:47 PM, Omar wrote:

question: Is there a backward compatibility to at least from 1.4.3 ? :)
   


older siremis versions might work with 1.4.x, but there is no plan (or 
resources) to make new versions of siremis work with old versions of 
kamailio.


Regards,
Ramona


___
Omar
321 Communications
o...@321communications.com
Phone: 813-938-6099
Mobile: 404-345-4303





On Sep 22, 2010, at 10:23 AM, Elena-Ramona Modroiu wrote:

   

Hi,

Siremis version 2.0 is planned to work with upcoming Kamailio or SER 3.1 and by 
now is alpha version.

If you want to have a preview, then you can access it at:
http://demo.asipto.com/siremis20/

username: guest
password: guest

v2.0 brings a completely new face and many features, reusing the latest openbiz 
development framework, among them:
- easy 4 step web-based installer
- siremis account management (including roles per users)
- customizable menu from web interface
- customizable views from web interface
- rework of many kamailio/ser related components such as subscriber, siptrace, 
generic and usrloc charts

Siremis administration module, user profile management and web based 
customization elements are disabled in the demo, to avoid breaking the content.

Packaging is still under work, but if someone is good at php/xml, likes to dig 
in by itself to sort out issues and wants to help with testing, I can ship a 
raw tarball, just drop me an email. Feedback about this new version is also 
appreciated, in order to improve it.

Regards,
Ramona



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

 


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

   



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] [Kamailio-Business] Siremis v2.0 preview

[Elena-Ramona Modroiu]

On 09/22/2010 10:09 PM, Iñaki Baz Castillo wrote:

2010/9/22 Elena-Ramona Modroiu:
   

If you want to have a preview, then you can access it at:
http://demo.asipto.com/siremis20/
 

It looks really well :)
   

Gracias! Glad you like it!

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] [Kamailio-Business] Siremis v2.0 preview

[Elena-Ramona Modroiu]

On 09/23/2010 06:47 PM, Meftah Tayeb wrote:

ramona,
thank you for this new siremis branche
but, you are using captcha for login;)
so i am a blind user, how i can login now?


I understand, added to to-do list and we will see what can be done 
before full release.


Regards,
Ramona


:P
Le 22/09/2010 16:23, Elena-Ramona Modroiu a écrit :

Hi,

Siremis version 2.0 is planned to work with upcoming Kamailio or SER 
3.1 and by now is alpha version.


If you want to have a preview, then you can access it at:
http://demo.asipto.com/siremis20/

username: guest
password: guest

v2.0 brings a completely new face and many features, reusing the 
latest openbiz development framework, among them:

- easy 4 step web-based installer
- siremis account management (including roles per users)
- customizable menu from web interface
- customizable views from web interface
- rework of many kamailio/ser related components such as subscriber, 
siptrace, generic and usrloc charts


Siremis administration module, user profile management and web based 
customization elements are disabled in the demo, to avoid breaking 
the content.


Packaging is still under work, but if someone is good at php/xml, 
likes to dig in by itself to sort out issues and wants to help with 
testing, I can ship a raw tarball, just drop me an email. Feedback 
about this new version is also appreciated, in order to improve it.


Regards,
Ramona



___
Kamailio (OpenSER) - Business mailing list
busin...@lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/business
http://lists.openser-project.org/cgi-bin/mailman/listinfo/business






___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Siremis v2.0 preview

[Elena-Ramona Modroiu]

Hello,

On 09/24/2010 09:51 AM, Huy Nguyen wrote:

Hi,

On firefox 3.6.10, i can't login with account guest.

It show a error popup: *SQLSTATE[28000] [1045] Access denied for user 
'openser'@'localhost' (using password: YES)*


try again, there were some update at some point.

Let me know if it works.

Regards,
Ramona




Regards,
Huy Nguyen*
*


www.htk-inc.com 
http://pbxvn.com/forum/






> Date: Wed, 22 Sep 2010 16:23:15 +0200
> From: ram...@asipto.com
> To: sr-users@lists.sip-router.org; busin...@lists.kamailio.org
> Subject: [SR-Users] Siremis v2.0 preview
>
> Hi,
>
> Siremis version 2.0 is planned to work with upcoming Kamailio or SER 
3.1

> and by now is alpha version.
>
> If you want to have a preview, then you can access it at:
> http://demo.asipto.com/siremis20/
>
> username: guest
> password: guest
>
> v2.0 brings a completely new face and many features, reusing the latest
> openbiz development framework, among them:
> - easy 4 step web-based installer
> - siremis account management (including roles per users)
> - customizable menu from web interface
> - customizable views from web interface
> - rework of many kamailio/ser related components such as subscriber,
> siptrace, generic and usrloc charts
>
> Siremis administration module, user profile management and web based
> customization elements are disabled in the demo, to avoid breaking the
> content.
>
> Packaging is still under work, but if someone is good at php/xml, likes
> to dig in by itself to sort out issues and wants to help with 
testing, I

> can ship a raw tarball, just drop me an email. Feedback about this new
> version is also appreciated, in order to improve it.
>
> Regards,
> Ramona
>
>
>
> ___
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users@lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Siremis v2.0 preview

[Elena-Ramona Modroiu]

On 09/24/2010 10:28 PM, Edson - Lists wrote:
Just in a quick access, I try the "BD Aliases" tab under "Subscribers 
List" and notice that the pickup domain functionality didn't work as I 
expected. The button present a another window with a list of pickable 
domains, but when I select one and choose "SELECT", the window is 
closed and the field is not updated. Is this the desired behavior?


Selected domain should appear in the input field. What is your web browser?



And why "Aliases DB" under "Subscriber List" and under "Subscriber 
Services"? Aren't both the same thing?


There are different views. The one in Subscriber list is a relationship 
view - in that page, the tabs for aliases and location show only the 
entries related to selected user in subscriber view - click on a 
subscriber row, then look at aliases and location for its records in 
those modules.


Dedicated pages with entries in menu are full views of respective modules.


Regards,
Ramona



Looking further,
Edson.

Em 22/09/2010 11:23, Elena-Ramona Modroiu escreveu:

Hi,

Siremis version 2.0 is planned to work with upcoming Kamailio or SER 3.1
and by now is alpha version.

If you want to have a preview, then you can access it at:
http://demo.asipto.com/siremis20/

username: guest
password: guest

v2.0 brings a completely new face and many features, reusing the latest
openbiz development framework, among them:
- easy 4 step web-based installer
- siremis account management (including roles per users)
- customizable menu from web interface
- customizable views from web interface
- rework of many kamailio/ser related components such as subscriber,
siptrace, generic and usrloc charts

Siremis administration module, user profile management and web based
customization elements are disabled in the demo, to avoid breaking the
content.

Packaging is still under work, but if someone is good at php/xml, likes
to dig in by itself to sort out issues and wants to help with testing, I
can ship a raw tarball, just drop me an email. Feedback about this new
version is also appreciated, in order to improve it.

Regards,
Ramona



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users




___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Size of an mqueue

[Elena-Ramona Modroiu]

On 10/11/2010 11:35 AM, Alex Balashov wrote:

According to the documentation,

   Optional attribute 'size' specifies the maximum number of items
   in queue, if it is execeeded the oldest one is removed

Is this meant to imply that by default, absent this attribute, queues 
are boundless?  Or is there a default size anyway?


there is no default size, only memory limits - queue items are stored in 
shared memory.


Regards,
Ramona

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] getting unexpected values from htable

[Elena-Ramona Modroiu]

Hi,

On 10/14/2010 04:26 PM, Javier Gallart wrote:

Hi all

I'm testing the htable module at Kamailio 3.1. Currently it's an 
extremely simple table with a single row loaded from a postgres DB.

These are the relevant lines in the configuration file:

modparam("htable", "db_url", 
"postgres://user:passw...@localhost:5432/database")

modparam("htable", "htable", "a=>size=2;autoexpire=0;dbtable=h_table;")
modparam("htable", "key_name_column", "key_name")
modparam("htable", "key_type_column", "key_type")
modparam("htable", "value_type_column", "value_type")
modparam("htable", "key_value_column", "key_value")

The only line in the table is:

 key_name | key_value | key_type | value_type
--+---+--+
 5| 1 | 1| 0


do you want to store the value in an array-like format? I see you have 
key_type=1



For key_type 1 the key name in htable should be 5[0] and another item 
with key 5::size should be there, but sht_print() does not show it.


Are you sure this is the record you had in database? I tested with same 
record but with mysql and it looks ok in sht_print().


Regards,
Ramona



However, sht_print() shows this:

 0(8570) ERROR: htable [ht_api.c:488]: = htable[a] hid: 109 exp: 0>
 0(8570) ERROR: htable [ht_api.c:492]: htable[0] -- <0>
 0(8570) ERROR: htable [ht_api.c:492]: htable[1] -- <0>
 0(8570) ERROR: htable [ht_api.c:492]: htable[2] -- <0>
 0(8570) ERROR: htable [ht_api.c:492]: htable[3] -- <1>
 0(8570) ERROR: htable [ht_api.c:496]: cell: 5
 0(8570) ERROR: htable [ht_api.c:498]: hid: 51 msize: 74 flags: 0 
expire: 0

 0(8570) ERROR: htable [ht_api.c:502]: v-i:9585128

Any idea of what might be happening?

Thanks in advance.




___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
   


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] HTable 'size' parameter

[Elena-Ramona Modroiu]

Maybe the term entry should be replaced with slot, looks to be more 
standard. A good doc about hash tables is on wikipedia:


http://en.wikipedia.org/wiki/Hash_table

The htable module keeps the number of items in a slot, but not exported 
via rpc, this could be added in the future.


Ramona


On 10/17/2010 04:39 PM, Iñaki Baz Castillo wrote:

2010/10/16 Uriel Rozenbaum:
   

What would be best to optimize the system is to have some statistic
information, save every now and then the status of the htable and act
accordingly to:
- If the table is pretty much or completely used and you have
collisions, make the size parameter bigger
- If the table is big enough so you'll have some slots free and still
have collisions you can try picking some key (if you have redundant
ones) that is more "random" so the hash result will be more "random".
- If all above is not producing any result, add processor power to the
system so searches and inserts are faster

Hope these guidelines help, they are some conclusions from hashing and
queuing theory books.
 

Sure, thanks a lot.



   



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Siremis user guide

[Elena-Ramona Modroiu]

We can start a wiki page for it. Next version, 2.0, has a module that 
allows embedded help, but others should jump in and contribute.


Ramona

On 10/09/2010 10:11 AM, Alex Balashov wrote:
It's a front-end to streamline and automate the presentation of things 
with which users of Kamailio/SR are already famiiar on a more 
fundamental level, not to provide a newbie-oriented, from-nothing 
interface.


--
Alex Balashov - Principal
Evariste Systems LLC
1170 Peachtree Street
12th Floor, Suite 1200
Atlanta, GA 30309
Tel: +1-678-954-0670
Fax: +1-404-961-1892
Web: http://www.evaristesys.com/

On Oct 9, 2010, at 3:52 AM, Shrouk Khan > wrote:


hi has anyone ever found any user guide for siremis ? it seems to 
take information directly from database and showing it . there is no 
tool tip or any clue as to what is what


--
Regards

Shrouk Khan (Khan)
System Administrator / Telecommunication System Developer
Office:   +354 4400807 (Reykjavik)
   +44   2031370800 (London)
Mobile:  +66  875049439 (Bangkok)

Web: www.softverk.is 

Reykjavik, Iceland  //  London, UK   //  Bangkok, Thailand
___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org 
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
   


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] siremis 2.0 ?

[Elena-Ramona Modroiu]

Hi,

On 10/08/2010 01:54 PM, X- x -X wrote:

Hey all,
Congratulation on 3.1 release !

Any news on when siremis v 2.0 is hitting the stores ?


we try for next week, at least a public beta.



In the mean time what about alpha/beta version of it ? Its nowhere on 
the repos/sites (asipto etc..)


Is version 1.0.1 know to work smoothly with kamailio 3.1 ?


Apart of the modules that did changes to database structure.

Ramona

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] siremis 1.0.1 with kamalio 3.1 ?

[Elena-Ramona Modroiu]

Hi,

you can use 1.0.1 for all modules that had no change to database 
structure. See the wiki page of kamailio that lists changes done towards 
3.1.0.


On 10/12/2010 02:10 PM, X- x -X wrote:

Hi all,
Not sure if this should be put to siremis list or dev list or whatever 
but bear with me if you could.


Since siremis v 2.0 is not out. Is siremis 1.0.1 known to work fine 
with kamalio 3.1 ?

(ref: siremis 1.0.1 install http://siremis.asipto.com/install/ )

Is it ready for production deployment etc.. ?

Will greatly appreciate any response from anyone since Ramona seems to 
be on her sabbatical .


Free support is done in the best effort manner. You have the sources of 
1.0.1, nobody stops you to contribute to that application.


Ramona
___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Siremis user guide

[Elena-Ramona Modroiu]

On 10/21/2010 11:57 AM, Shrouk Khan wrote:
anyone knows when the v2.0 will be publicly available. it looks very 
impressive.
yesterday, just before your email, I sent several messages on this 
mailing list announcing that the plan is to have at least a public beta 
next week.


Ramona



On Thu, Oct 21, 2010 at 4:02 PM, Elena-Ramona Modroiu 
mailto:ram...@asipto.com>> wrote:


We can start a wiki page for it. Next version, 2.0, has a module
that allows embedded help, but others should jump in and contribute.

Ramona


On 10/09/2010 10:11 AM, Alex Balashov wrote:

It's a front-end to streamline and automate the presentation of
things with which users of Kamailio/SR are already famiiar on a
more fundamental level, not to provide a newbie-oriented,
from-nothing interface.

--
Alex Balashov - Principal
Evariste Systems LLC
1170 Peachtree Street
12th Floor, Suite 1200
Atlanta, GA 30309
Tel: +1-678-954-0670
Fax: +1-404-961-1892
Web: http://www.evaristesys.com/

On Oct 9, 2010, at 3:52 AM, Shrouk Khan mailto:shroukk...@softverk.is>> wrote:


hi has anyone ever found any user guide for siremis ? it seems
to take information directly from database and showing it .
there is no tool tip or any clue as to what is what

-- 
Regards


Shrouk Khan (Khan)
System Administrator / Telecommunication System Developer
Office:   +354 4400807 (Reykjavik)
   +44   2031370800 (London)
Mobile:  +66  875049439 (Bangkok)

Web: www.softverk.is <http://www.softverk.is>

Reykjavik, Iceland  //  London, UK   //  Bangkok, Thailand
___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users
mailing list
sr-users@lists.sip-router.org <mailto:sr-users@lists.sip-router.org>
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org  <mailto:sr-users@lists.sip-router.org>
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
   



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
list
sr-users@lists.sip-router.org <mailto:sr-users@lists.sip-router.org>
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users




--
Regards

Shrouk Khan (Khan)
System Administrator / Telecommunication System Developer
Office:   +354 4400807 (Reykjavik)
   +44   2031370800 (London)
Mobile:  +66  875049439 (Bangkok)

Web: www.softverk.is <http://www.softverk.is>

Reykjavik, Iceland  //  London, UK   //  Bangkok, Thailand


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
   


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] ERROR

[Elena-Ramona Modroiu]

On 10/22/2010 01:48 PM, michel freiha wrote:

Guys I'm getting the below error...Can anybody help please?

Oct 22 12:27:17 localhost /usr/local/sbin/kamailio[28566]: ERROR: 

[SR-Users] Siremis V2.0.0 Released

[Elena-Ramona Modroiu]

Hi,

Siremis v2.0.0 is out – the web management interface for Kamailio 
(Openser) v3.1.0 and SIP Express Router (SER).


This is a major release, with countless improvements and new features 
since v1.x series, among them:


* major re-factoring of web interface
* better accessibility
* simplified menu structure
* completely new look
* dashboard with the map of all available tools
* developed on top of Cubi and PHPOpenBiz v2.4 frameworks
* web installation wizard
* added new modules: xcap, dialog, new lcr
* usage of separate database for siremis itself
* management of users that can login to siremis
* management of menu can be done from web interface
* building Apache conf and htaccess file can be done by Makefie
* charts to monitor location transport layers

Step by step installation tutorial, screenshots and demo are available 
on the web at:


* Installation Tutorial - http://asipto.com/u/6
* Screenshots - http://asipto.com/u/7
* Web Demo - http://asipto.com/u/8

Siremis is used during Kamailio Advanced Training classes for management 
of SIP server, a good opportunity to learn about Siremis itself, next 
locations are:


* Kamailio Advanced Training for Carrier Services, November 22-25, 2010, 
Berlin, Germany (http://asipto.com/u/kat)
* Kamailio Advanced Training for Carrier Services, January 24-26, 2010, 
Irvine, CA, USA (http://asipto.com/u/katu)


More details about Siremis project are available at:

* http://siremis.asipto.com

Regards,
Ramona

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Kamalio 3.1, Siremis 2.0 Problem

[Elena-Ramona Modroiu]

On 11/01/2010 10:24 PM, Trevor Francis wrote:

I am running into the following errors:

/usr/local/sbin/kamailio[6774]: ERROR: db_mysql [km_dbase.c:120]: 
driver error on query: Unknown column 'random' in 'field list'
/usr/local/sbin/kamailio[6774]: ERROR:  [db_query.c:130]: error 
while submitting query
/usr/local/sbin/kamailio[6774]: ERROR: sqlops [sql_api.c:217]: cannot 
do the query



I believe it is preventing my LCR from working properly.


This is related to statistics collection, not LCR. We removed random 
chart because it was for demo purposes but the install guide was left 
unchanged in this section. I updated the installation guide now.


Thanks for reporting,
Ramona


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Dead Charts in Siremis 2.0

[Elena-Ramona Modroiu]

On 11/01/2010 11:21 PM, Trevor Francis wrote:
I managed to get the SHM chart working by manually adding the field 
"random" inside the table "statistics." However, the Charts "Load 
Charts" and "TM Charts" gave me "Internal System Errors" unless I add 
the fields tm_active, rcv_req_diff, fwd_req_diff, and 2xx_trans_diff 
to the statistics table in mysql. I am not sure if these statistics 
are being updated, because my charts dont appear to be displaying 
information. Can anyone speak to what is going on here?


These are some charts we played with and somehow slipped in tarball 
(they were not configured in installation guide). They are independent, 
so just remove the link from menu or don't access them.


Regards,
Ramona

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Siremis V2.0.0 Released - bug?

[Elena-Ramona Modroiu]

On 11/02/2010 07:57 AM, Jeremya wrote:

Elena-Ramona Modroiu wrote:
   

Hi,

Siremis v2.0.0 is out – the web management interface for Kamailio
(Openser) v3.1.0 and SIP Express Router (SER).
 

I downloaded and installed the latest source version of kamailio 3.1.0
(not git) and compiled an installed it. This works as expected.

I then downloaded siremis v 2.0.0 and installed it as instructed,
including creating the siremis tables etc. I can use it to some extent,
but the 'save' function for user edits fails. I can't change existing
users nor add new ones. The form just sits there
   


Do you access it from Siremis Administration panel, via Users Management?

It was reported that in some cases, changing password via My Account 
does not work, the alternative being via Users Management.


I guess the problem with Siremis users administration comes from Ajax 
execution on some browsers and web servers. Can you watch/copy the http 
traffic when you do the operation and send it here?


Regards,
Ramona


I can add roles and groups O.K.

The error message in CRIT.log is

'11/02/2010','06:55:11','CRIT','ErrorHandler','EVAL: $ret = guest, 3,
10; ',''


The user table structure is

mysql>  explain user;
+-+--+--+-+-++
| Field   | Type | Null | Key | Default | Extra  |
+-+--+--+-+-++
| id  | int(10) unsigned | NO   | PRI | NULL| auto_increment |
| username| varchar(64)  | NO   | UNI | ||
| password| varchar(64)  | NO   | | ||
| enctype | varchar(64)  | NO   | | SHA1||
| email   | varchar(64)  | YES  | MUL | ||
| status  | int(2)   | YES  | | 1   ||
| lastlogin   | datetime | YES  | | NULL||
| lastlogout  | datetime | YES  | | NULL||
| create_by   | int(10)  | YES  | | 1   ||
| create_time | datetime | YES  | | NULL||
| update_by   | int(10)  | YES  | | 1   ||
| update_time | datetime | YES  | | NULL||
+-+--+--+-+-++
12 rows in set (0.00 sec)

user table contents are

mysql>  select * from user;
++--+--+-+++-+-+---+-+---+-+
| id | username | password | enctype |
email  | status | lastlogin   |
lastlogout  | create_by | create_time | update_by |
update_time |
++--+--+-+++-+-+---+-+---+-+
|  1 | admin| d033e22ae348aeb5660fc2140aec35850c4da997 | SHA1|
ad...@yourcompany.com  |  1 | 2010-11-01 18:54:54 | 2009-08-24
13:24:14 | 1 | 2010-05-01 01:19:57 | 1 | 2010-11-01
18:54:54 |
|  2 | member   | 6467baa3b187373e3931422e2a8ef22f3e447d77 | SHA1|
mem...@yourcompany.com |  1 | 2010-05-01 01:19:57 | 2009-08-23
23:39:37 | 1 | 2010-05-01 01:19:57 | 5 | 2010-05-01
01:19:57 |
|  3 | guest| 35675e68f4b5af7b995d9205ad0fc43842f16450 | SHA1|
gu...@yourcompany.com  |  1 | NULL|
NULL|  NULL | 2010-01-12 02:20:10 |  NULL |
2010-01-12 02:20:10 |
++--+--+-+++-+-+---+-+---+-+
3 rows in set (0.00 sec)

debug is

'11/01/2010','23:54:51','DEBUG','DATAOBJ','Query Sql = SELECT T0.id,
T0.username, T0.password, T0.enctype, T0.email, T0.status, T0.lastlogin,
T0.lastlogout, T0.create_by, T0.create_time, T0.update_by,
T0.update_time FROM  `user` T0   LIMIT 10 BIND: ','n/a'
'11/01/2010','23:54:55','DEBUG','DATAOBJ','Query Sql = SELECT T0.id,
T0.username, T0.password, T0.enctype, T0.email, T0.status, T0.lastlogin,
T0.lastlogout, T0.create_by, T0.create_time, T0.update_by,
T0.update_time FROM  `user` T0  WHERE T0.id = :_v1  LIMIT 1 BIND: 3','n/a'
'11/01/2010','23:54:55','DEBUG','DATAOBJ','Query Sql = SELECT T0.id,
T0.name, T0.description, T0.startpage, T0.status, T0.default FROM
`role` T0  INNER JOIN `user_

Re: [SR-Users] Siremis V2.0.0 Released - bug?

[Elena-Ramona Modroiu]

On 11/02/2010 12:22 PM, Jeremya wrote:

Elena-Ramona Modroiu wrote:
   

On 11/02/2010 07:57 AM, Jeremya wrote:
 

Elena-Ramona Modroiu wrote:

   

Hi,

Siremis v2.0.0 is out – the web management interface for Kamailio
(Openser) v3.1.0 and SIP Express Router (SER).

 

I downloaded and installed the latest source version of kamailio 3.1.0
(not git) and compiled an installed it. This works as expected.

I then downloaded siremis v 2.0.0 and installed it as instructed,
including creating the siremis tables etc. I can use it to some extent,
but the 'save' function for user edits fails. I can't change existing
users nor add new ones. The form just sits there

   

I accessed it from the siremis management panel - not user panel.
I used wireshark to monitor.
When I analyse it I only see the initial POST request. There are no
responses - though I do see an animation on the web page of cycling
'blocks' - I assume made by java-script

The POST is

3423.792484203.31.40.68203.31.40.102HTTPPOST
/siremis/bin/controller.php?F=RPCInvoke&P0=[system.form.UserEditForm]&P1=[UpdateUser]&__this=btn_save:save_onclick
HTTP/1.1  (application/x-www-form-urlencoded)

   
Is there any error message in apache logs? There should be at least some 
error http reply.


Ramona

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] siremis 2.0 and Captcha issues !

[Elena-Ramona Modroiu]

Hi,

have you installed php gd package?

http://kb.asipto.com/siremis:install20:main#requirements

Ramona

On 11/02/2010 12:37 PM, X- x -X wrote:

Hi all,
Is anyone else is also having problems in seeing captcha while logging 
in http://myhost.mydomain/siremis/index.php/user/login 
 (during 
installation, I haven't been able to login since  Im not able to see 
any image. just the image reference thing)


I've tried firefox, chome & opera (all with flash plugins installed & 
of-course simple images also show fine)


Is there a way I can disable them.

Seem like these 2 files are driving the whole captch show

/var/www/siremis-2.0.0/siremis/bin/antispam_image.php
/var/www/siremis-2.0.0/siremis/modules/user/form/Antispam.php

Are there any distro version specific libraries required. Im trying 
the whole thing on debian lenny.


Cheers
--
X



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
   


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Siremis 2.0: error in LCR table editing??

[Elena-Ramona Modroiu]

Hi,

thanks for reporting. It will be fixed soon.

Regards,
Ramona

On 11/04/2010 02:16 PM, Klaus Feichtinger wrote:

Hello list,

has anybody else tried using SIREMIS 2.0 for administrating LCR tables in
kamailio 3.1.0?

I am not happy with the form / input boxes that are presented in the web
browser, because some fields are not as expected.

Following points are - from my point of view - incorrect:

  1) table "LCR_Gateway_List": the fields 'URI-scheme', 'Transport' and
'Strip' are represented by checkboxes. However, in reality these fields
are defined with smallint(3) types and e.g. transport is representing
values from NULL...4 - not boolean!

2) table "LCR_Target_List": the field priority is represented by a
checkbox, too. However, also this field is not boolean. Priorities are
represented by numbers, starting with '0' = highest priority a.s.o.


Can anybody check if this "problem" is a real one, or only present on my
PC? I have tested with IE and Firefox - the result is still the same.

regards,
Klaus



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

   



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Siremis 2.0: error in LCR table editing??

[Elena-Ramona Modroiu]

On 11/08/2010 06:20 PM, Lee Archer wrote:


When editing an LCR gateway values of 0 aren't populated in the Edit 
page but with LCR the value for Flags are mandatory in the web 
interface.  Is this an issue?




It will be investigated for the next release.

Ramona


Regards

Lee

*From:* sr-users-boun...@lists.sip-router.org 
[mailto:sr-users-boun...@lists.sip-router.org] *On Behalf Of *X- x -X

*Sent:* 08 November 2010 15:02
*To:* Daniel-Constantin Mierla; sr-users@lists.sip-router.org
*Subject:* Re: [SR-Users] Siremis 2.0: error in LCR table editing??

This is good to know that things those few things have been fixed. I 
only learned it from this email. Shouldn't the fixes info be 
transmitted like with a patched version ( siremis 2.0.1 ) or something.


Anyway good jobs guyz, dont take me as a thankless user.

Cheers

--

On Mon, Nov 8, 2010 at 4:30 PM, Daniel-Constantin Mierla 
mailto:mico...@gmail.com>> wrote:


Hello,



On 11/8/10 11:29 AM, Lee Archer wrote:

Hi, does Siremis have some sort of SVN where the latest branch with
updates can be downloaded or do we need to wait until you release the
fixed version?

the project has an svn repository hosted on sourceforge.net 
<http://sourceforge.net>, but it still has the sources of 1.0.x. it 
will be fixed in the near future


Re-download the tar ball from the web, it has now the fixes for lcr 
and siremis own-user management:


http://siremis.asipto.com/pub/downloads/siremis/siremis-2.0.0.tgz

Cheers,
Daniel

Regards

Lee

-Original Message-
From: sr-users-boun...@lists.sip-router.org
<mailto:sr-users-boun...@lists.sip-router.org>
[mailto:sr-users-boun...@lists.sip-router.org
<mailto:sr-users-boun...@lists.sip-router.org>] On Behalf Of
Elena-Ramona
Modroiu
Sent: 05 November 2010 09:40
To: Klaus Feichtinger
Cc: sr-users@lists.sip-router.org
<mailto:sr-users@lists.sip-router.org>
Subject: Re: [SR-Users] Siremis 2.0: error in LCR table editing??

Hi,

thanks for reporting. It will be fixed soon.

Regards,
Ramona

On 11/04/2010 02:16 PM, Klaus Feichtinger wrote:

Hello list,

has anybody else tried using SIREMIS 2.0 for administrating LCR tables
in kamailio 3.1.0?

I am not happy with the form / input boxes that are presented in the
web browser, because some fields are not as expected.

Following points are - from my point of view - incorrect:

  1) table "LCR_Gateway_List": the fields 'URI-scheme', 'Transport'
and 'Strip' are represented by checkboxes. However, in reality these
fields are defined with smallint(3) types and e.g. transport is
representing values from NULL...4 - not boolean!

2) table "LCR_Target_List": the field priority is represented by a
checkbox, too. However, also this field is not boolean. Priorities are
represented by numbers, starting with '0' = highest priority a.s.o.


Can anybody check if this "problem" is a real one, or only present on
my PC? I have tested with IE and Firefox - the result is still the

same.

regards,
Klaus



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
list sr-users@lists.sip-router.org
<mailto:sr-users@lists.sip-router.org>
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
list
sr-users@lists.sip-router.org <mailto:sr-users@lists.sip-router.org>
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
list
sr-users@lists.sip-router.org <mailto:sr-users@lists.sip-router.org>
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

--
Daniel-Constantin Mierla
http://www.asipto.com




___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org <mailto:sr-users@lists.sip-router.org>
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
   


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] siremis 2.0.0 CDRS link issues !

[Elena-Ramona Modroiu]

Hi,

On 11/12/2010 01:07 PM, X- x -X wrote:


Hi all,
I was wondering if Im the only one getting this error (in siremis 
2.0.0 with kamailio 3.1). i.e. I have activated the accounting modules 
& all but still when I click the "CDR list" in "Accounting Services" 
it errors on me saying that CDRS table is missing, which ofcourse is 
missing from the "openser" mysql DB.


Why is CDRS table missing ? Is it okay (advisable) to create a CDRS 
table mentioned in siremis 1.0 docs 
(http://siremis.asipto.com/install-accounting/)


the table is created when you install siremis 2.0 if you select the 
check-box to update SIP database in web installation wizard:


http://kb.asipto.com/siremis:install20:main#step_2

Ramona



Cheers
---
X




[2010-11-12 14:01:08 (GMT)] An exception occurred while executing this 
script:
Error message: #0, Error in query:: SELECT T0.cdr_id, T0.src_username, 
T0.src_domain, T0.dst_username, T0.dst_domain, T0.call_start_time, 
T0.duration, T0.sip_call_id, T0.sip_from_tag, T0.sip_to_tag, 
T0.src_ip, T0.cost, T0.created FROM `cdrs` T0 LIMIT 10. 
SQLSTATE[42S02]: Base table or view not found: 1146 Table 
'openser.cdrs' doesn't exist
Script name and line number of error: 
/var/www/siremis-2.0.0/openbiz/bin/data/BizDataObj_Lite.php:447


function: _run_search ( Array(2) ) @ 
/var/www/siremis-2.0.0/openbiz/bin/data/BizDataObj_Lite.php 243
function: fetch ( ) @ 
/var/www/siremis-2.0.0/openbiz/bin/easy/EasyForm.php 690
function: fetchDataSet ( ) @ 
/var/www/siremis-2.0.0/openbiz/bin/easy/FormRenderer.php 69
function: renderSmarty ( Object(EasyForm), 
"/var/www/siremis-2.0.0/siremis/modules/ser/template/grid.tpl" ) @ 
/var/www/siremis-2.0.0/openbiz/bin/easy/FormRenderer.php 45
function: render ( Object(EasyForm) ) @ 
/var/www/siremis-2.0.0/openbiz/bin/easy/EasyForm.php 1648
function: renderHTML ( ) @ 
/var/www/siremis-2.0.0/openbiz/bin/easy/EasyForm.php 1538
function: render ( ) @ 
/var/www/siremis-2.0.0/openbiz/bin/easy/ViewRenderer.php 83
function: renderSmarty ( Object(EasyView), 
"/var/www/siremis-2.0.0/siremis/modules/ser/template/view.tpl" ) @ 
/var/www/siremis-2.0.0/openbiz/bin/easy/ViewRenderer.php 40
function: render ( Object(EasyView) ) @ 
/var/www/siremis-2.0.0/openbiz/bin/easy/EasyView.php 274
function: _render ( ) @ 
/var/www/siremis-2.0.0/openbiz/bin/easy/EasyView.php 237
function: render ( ) @ 
/var/www/siremis-2.0.0/openbiz/bin/BizController.php 221
function: renderView ( "ser.view.CdrsListView", "", "", Null, "" ) @ 
/var/www/siremis-2.0.0/openbiz/bin/BizController.php 107
function: dispatchRequest ( ) @ 
/var/www/siremis-2.0.0/openbiz/bin/BizController.php 32
function: include_once ( 
"/var/www/siremis-2.0.0/openbiz/bin/BizController.php" ) @ 
/var/www/siremis-2.0.0/siremis/bin/controller.php 6
function: include ( 
"/var/www/siremis-2.0.0/siremis/bin/controller.php" ) @ 
/var/www/siremis-2.0.0/siremis/bin/_forward.php 90
function: include ( "/var/www/siremis-2.0.0/siremis/bin/_forward.php" 
) @ /var/www/siremis-2.0.0/siremis/index.php 3

Please ask system administrator for help...


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
   


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] SIREMIS logging problem.

[Elena-Ramona Modroiu]

Hi,

have you created siremis database? You have a checkbox at step 2 in the 
installation wizard:


http://kb.asipto.com/siremis:install20:main#step_2

Regards,
Ramona

On 01/05/2011 09:48 PM, Ricardo Martinez wrote:


Hello.

I have Siremis 2.0 installed from scratch, but I’m unable to logging.  
This is the error that I’m getting from the logs :


'01/05/2011','12:41:36','ERR','DATAOBJ','Query Error: SQLSTATE[42S02]: 
Base table or view not found: 1146 Table 'siremis.contact' doesn't 
exist','n/a'


I was checking the SIREMIS db and I can’t found the table “contact”.

Is this a bug?.. can someone help me?

Thanks

Regards,

* *

*Ricardo Martinez.-*


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
   


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] HTABLE problem

[Elena-Ramona Modroiu]

Hi,

this may be related to same issue reported at:
http://sip-router.org/tracker/index.php?do=details&task_id=114

Therefore it can be just some log message printed erroneously. Can you 
dump the htable content (or print it with xlog) to see if the assignment 
is actually done or not?


Dumping the htable content:

kamctl fifo sht_dump a

Another possible issue I spot with your config is that you don't check 
for the existence of Authorization header. Since I am not using 
auth_radius, I am not sure radius_www_authorize() return -1 only when 
the password mismatches. Might be also when there is no header carrying 
the credentials. If no Authorization header is present, the $au is null 
-- in this case you just have to do www_challenge() and exit, since 
counting failed authentications for "" user might bring you 
unexpected behaviour.


Regards,
Ramona


On 2/18/11 10:35 PM, Ricardo Martinez wrote:


Hello

I’m trying to use “htable” module with the example to block a user 
with three time s failed password.


When a REGISTER arrives I’m getting this error :

Feb 18 17:26:34 /usr/local/sbin/kamailio[5840]: ERROR:  
[lvalue.c:358]: setting pvar failed


Feb 18 17:26:34 /usr/local/sbin/kamailio[5840]: ERROR:  
[lvalue.c:411]: assignment failed at pos: (322,54-322,81)


Feb 18 17:26:34 /usr/local/sbin/kamailio[5840]: ERROR:  
[lvalue.c:358]: setting pvar failed


Feb 18 17:26:34 /usr/local/sbin/kamailio[5840]: ERROR:  
[lvalue.c:411]: assignment failed at pos: (328,47-328,49)


The lines pointing the error are these :

312if ( !radius_www_authorize("10.0.0.208") )

313{

314switch ($retcode)  {

315case -1:

316xlog("L_INFO","authentication failed 
from radius\n");


317if($sht(a=>$au::auth_count) == "null")

318{

319$sht(a=>$au::auth_count) = 0;

320}

321$sht(a=>$au::auth_count) = 
$sht(a=>$au::auth_count) + 1;


322if($sht(a=>$au::auth_count) == 3)

323{

324xlog("L_INFO","auth failed 3rd 
time - src ip: $si\n");


325}

326$sht(a=>$au::last_auth) = $Ts;

327break;

328case -5:

329sl_send_reply("403", "Forbidden");

330exit;

331}

332www_challenge("10.0.0.208", "1");

333exit;

334}

What could be the problem?

Thanks in advance.

Regards,

Ricardo.-


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Question about time display in SIREMIS 2.0

[Elena-Ramona Modroiu]

Hi,

for charts siremis uses the date() function to convert from unix 
timestamp that is written by kamailio to the displayed date. It might be 
possible to adjust the timezone from php.ini.


Regards,
Ramona

On 2/28/11 10:30 PM, Ricardo Martinez wrote:


Hello.

Is there a way to adjust the timezone to display the charts and the 
logs in the SIREMIS 2.0?  I have my linux machine with my local 
timezone, but the display in the charts and the logs are not in synch 
with my local time.


Thanks in advance.

Regards,

Ricardo Martinez.-


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Siremis - Auto update dialplan on save?

[Elena-Ramona Modroiu]

Hi Russell,

your email slipped unnoticed so far ... see more comments inline.

On 2/24/11 10:14 PM, Russell Feeser wrote:

To Siremis Admin,

I'm a bit of a php rookie, and even more of a noob with openbiz cubi, 
but I've burnt a day and a half trying to implement a new button on 
the SER Menu > Server Services > Dialplan List page, and curious if 
you could give some words of advice concerning my plight.


Ideally, I would like dialplan to auto update the Kamailio mySQL 
database with the dp_reload feature; I am simply sick of bouncing 
Kamailio with a "kamctl restart" from the command line each time 
I implement a change to the dialplan in Siremis.


I have successfully enabled this feature on the drop-down menu in SER 
Menu > Command Services > MI Commands, however, I don't want to have 
to navigate to the MI Commands page each time I wish to refresh 
dialplan. In siremisMICommands.xml, I was able to activate dp_reload 
with the following code:


(taken from siremisMICommands.xml)


Class="siremisMICommands">







command="get_statistics all"/>


 
<-- Code I added, WORKS!






Here's where I'm stuck: I can't seem to get a new button 
to implement dp_reload in the DialplanListForm.xml. I'm not sure if I 
need to write a function to call dp_reload, or if I can simply 
activate dp_reload from the DialplanListForm.xml. The code I have 
written creates a button on the  SER Menu > Server Services > Dialplan 
List page, but thats as far as I've gotten. My code currently looks 
like this:


(taken from DialplanListForm.xml)

CssClass="button_gray_m" Description="Refresh dialplan in Kamailio 
without restarting Kamailio">
Function="" ContextMenu="Activate"/>



Anything you can say would be most helpful, as this is a feature I'm 
sure many using Siremis would appreciate having.
One option is to extend the base class for the dialplan form where you 
add a new function to perform the dp_reload function, then create the 
button that will perform an action calling the new function.


There are several cases when siremis uses same approach, see 
modules/ser/common/... for the base functions and then reused to have a 
particular functionality (such as search results). You can search for 
"extended" in ser module to see what classes are extending other.


Hopefully soon the version 2.0 of siremis will get on GIT and we can 
grant access to others that want to contribute.


Regards,
Ramona
___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] siremis 2.0 documentation

[Elena-Ramona Modroiu]

Hi,

On 7/12/11 12:57 PM, Klaus Darilion wrote:

Hi!

IMO the description "Import Default Data" (Import Default Data - this
imports initial data into database 'siremis') is too ambiguous (at least
it successfully confused me and I had to dig into the code to find out
what it really does).

Suggestion:

Create Siremis Tables (Create Siremis Tables - this creates the tables
in the siremis DB and fills it with inital data).
ok, it can be updated to be more suggestive or more descriptive text 
added in that page.


Regards,
Ramona

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] siremis 2.0 statistics problem

[Elena-Ramona Modroiu]

Hi,

On 7/12/11 1:57 PM, Klaus Darilion wrote:

Hi!

I just installed siremis 2.0. I did not let siremis update the SIP DB
but did it manually (to sensitive) according to:

http://siremis.git.sourceforge.net/git/gitweb.cgi?p=siremis/siremis;a=blob_plain;f=siremis/modules/ser/mod.install.siremis.sql;hb=HEAD

But when accessing some statistics, e.g.
http://mydomain/siremis/ser/charts_tm/cg=tm I get an error:

SELECT time_stamp,tm_active FROM statistics ORDER BY id DESC LIM...
-->
Unknown column 'tm_active' in 'field list'

as statistics table does not have column "tm_active". Am I doing
something wrong?
the statistics in the default siremis were intended to show some 
examples of how to build charts - they require to have changes in 
kamailio config anyhow. The current state should be revised indeed and 
make it more coherent.


Regards,
Ramona

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] siremis 2.0: disable captcha

[Elena-Ramona Modroiu]

Hi,

On 7/12/11 2:05 PM, Klaus Darilion wrote:

Hi!

Is there an easy way to disable the captcha? As siremis is an admin
tool, not being public accessible (at least it shouldn't be) I want to
get rid of it.
captcha is part of the cubi framework and it requires some changes in 
that part of php. It is in the roadmap for next release, but there was 
no time for it so far.


Btw, the sources for 2.0 are in git hosted by sourceforge project:
http://sourceforge.net/projects/siremis/

I can grant you devel access if you want to push some updates.

Regards,
Ramona

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] siremis 2.0: generates CDRs

[Elena-Ramona Modroiu]

Hi,

On 7/12/11 2:36 PM, Klaus Darilion wrote:

Hi!

Seems like I am blind. There is a stored procedure which generates CDRs
from acc table entries - but how/when does this stored procedure gets
triggered?
you can call it periodically from a cron.d job or from kamailio config 
file by using rtimer module.


Regards,
Ramona

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] siremis 2.0: generates CDRs

[Elena-Ramona Modroiu]

Hi Klaus,

added to the wiki, thanks,

Ramona

On 7/13/11 11:27 AM, Klaus Darilion wrote:

Am 13.07.2011 09:59, schrieb Klaus Darilion:


Am 13.07.2011 09:54, schrieb Klaus Darilion:


Am 12.07.2011 19:13, schrieb Elena-Ramona Modroiu:

Hi,

On 7/12/11 2:36 PM, Klaus Darilion wrote:

Hi!

Seems like I am blind. There is a stored procedure which generates CDRs
from acc table entries - but how/when does this stored procedure gets
triggered?

you can call it periodically from a cron.d job or from kamailio config
file by using rtimer module.

It would be great if you could add config examples to
http://kb.asipto.com/siremis:install20:charts

Sorry, the correct URI is:
http://kb.asipto.com/siremis:install20:accounting

You can add the following example of how to populate CDRs from within
kamailio.

regards
Klaus

# -- for siremis CDRs --
modparam("rtimer", "timer", "name=cdr;interval=300;mode=1;")
modparam("rtimer", "exec", "timer=cdr;route=CDRS")
modparam("sqlops", "sqlcon", "cb=>mysql://openser:passw@localhost/openser")



# ==
# Populate CDRs Table of Siremis
# ==
route[CDRS] {
sql_query("cb","call kamailio_cdrs()","rb");
}



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users




___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

[SR-Users] Siremis v4.0.0 Released

[Elena-Ramona Modroiu]

Hi,

a new release of Siremis is out - v4.0.0 - web management interface that 
is compatible out of the box with Kamailio v4.0.x series.


More details, including link to install tutorial, are available at:

  - http://siremis.asipto.com/2013/05/08/siremis-v4-0-0-released/

Regards,
Ramona



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Siremis v4.0.0 Released

[Elena-Ramona Modroiu]

Fixed - a typo in file name.

Thanks,

On 5/9/13 9:07 AM, David | StyleFlare wrote:

FWIW

http://siremis.asipto.com/pub/downloads/siremis/siremis-4.0.0.tgz

Returns 404
..

Thx.


On 5/9/13 2:51 AM, Elena-Ramona Modroiu wrote:

Hi,

a new release of Siremis is out - v4.0.0 - web management interface 
that is compatible out of the box with Kamailio v4.0.x series.


More details, including link to install tutorial, are available at:

  - http://siremis.asipto.com/2013/05/08/siremis-v4-0-0-released/

Regards,
Ramona



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users




___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] HELP! I can't install siremis 3.0 for kaimailio after install kamailio, It take a long long time to wait for and no end.

[Elena-Ramona Modroiu]

Have you done:

make prepare

and set the right owner for the files inside siremis? Check:

http://kb.asipto.com/siremis:install40x:main#local_configuration

Regards,
Ramona


On 5/15/13 3:01 AM, Future Lian wrote:
I can't install siremis 3.0 for kaimailio after install kamailio, It 
take a long long time to wait for and no end.


in CRIT.log of siremis/log, I get

'05/14/2013','09:13:30','CRIT','ExceptionHandler','cache_dir must be a 
directory',''


Anyone can tell me how to do? Thank you all.


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Kamailio and Siremis

[Elena-Ramona Modroiu]

Hi Isaac,

On 5/31/13 11:55 PM, Isaac A. McDonald wrote:


Hello All,

I'm a bit confused as to how Siremis interacts with Kamailio. From 
what I understand, the dial-plan is done in the kamailio.cfg with 
regex statements and requires a restart of the Kamailio process to 
take effect. How then does Siremis change the dial-plan in Kamailio 
without writing re-writing the config?


I'm assuming Siremis is merely writing to a MySQL database and some 
additional code is required in the kamailio.cfg in order to be able to 
use the dial-plan functionality of Siremis?


What must I change in the kamailio.cfg to be able to use Siremis for 
dial-plan modification?


You can build the routing logic statically in kamailio configuration 
file. But in many cases you can use a module that loads the routing 
rules from database. It is where siremis can help, by managing those 
rules in database. Then you can send a MI/RPC command to kamailio to 
tell to a module to load its rules from database, without need to restart.


For example, pdt module, it loads its rules to translate a prefix to a 
domain from pdt table at startup. If you change something in database, 
then you can send a command using kamctl to reload all the rules from 
database. The configuration file is not affected at all by such operations.


Regards,
Ramona
___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Siremis 4.0.0 Error

[Elena-Ramona Modroiu]

Did the wizard complete ok? Have you checked the options to create 
siremis database and update the sip database?


You can check the logs in siremis/logs/ or apache/webserver logs in 
/var/log/..., maybe you get some hints from there. I haven't seen the 
error so far.


Cheers,
Ramona



On 7/11/13 7:04 PM, Geoffrey Mina wrote:
After installing Siremis as per the instructions, i get the following 
error.


Anyone know how to solve this?

"Not able to get the right data table of given form 
help.form.HelpWidgetListForm"


After clicking OK I get this:

"Unable to create object from class Openbiz.TableForm. TypeError: 
table is undefined"


Every page click invokes this error.




___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Hash Table capacity

[Elena-Ramona Modroiu]

Hi,

On 8/19/13 4:05 PM, Alex Balashov wrote:
According the docs, the hash table is restricted to a maximum size of 
2^16 (65536) buckets.
it was restricted to 2^14, I just lifted it to positive integer range 
2^31 because it is easier to get now systems with plenty of memory -- it 
will be in next major release.




This doesn't mean that the htable can only hold 65k entries, just that 
it's the maximum number of unique buckets. Assuming a theoretically 
ideal distribution where every value has a unique bucket, after 65k 
values, you will get collisions. Collision chains attached to buckets 
are linear lists. After collision chains get deep, performance becomes 
more and more linear.


So, you can put 2m values into the htable. I am not sure that it is 
the optimal use of an htable, however.


With the previous upper limit (2^14) you could get a fair distribution 
of about 125 items per slot, which is still fine for linear searching, 
provided a modern CPU server.


You can simulate some tests and measure the search performances with 
benchmark module.


Regards,
Ramona




Ricardo Martinez  wrote:

Anyone here?

Thanks!

Ricardo.-

*De:*Ricardo Martinez [mailto:rmarti...@redvoiss.net
]
*Enviado el:* miércoles, 14 de agosto de 2013 18:34
*Para:* sr-users@lists.sip-router.org

*Asunto:* Hash Table capacity

Hello list.

I have a question about the HTABLE module.  Suppose that I have a
mysql database with 2 million of records.  Is possible to load
this table as a hash table compatible with Kamailio!?

Hope someone can help me.

Thanks,
Ricardo Martinez.-



SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


--
Sent from my mobile, and thus lacking in the refinement one might 
expect from a fully fledged keyboard.


Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
United States
Tel: +1-678-954-0670
Web: http://www.evaristesys.com/, http://www.alexbalashov.com


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users