sr-users

sr-users@lists.kamailio.org

42 participants
37519 discussions

[Kamailio-Users] Res: Problems with SerMyAdmin Installation
by Flavio Goncalves 25 Sep '08

25 Sep '08

Hi Brian, I have seen some people complianing about this, but I have not being able to reproduce the problem. Could you send me a copy of your database schema, it is probably the source of the problem. Have you applied the openser.sql in the latest version? Best regards, Flavio E. Goncalves ----- Mensagem original ---- De: Brian Chamberlain <brian(a)asterisk.ie> Para: users(a)lists.kamailio.org Enviadas: Quarta-feira, 10 de Setembro de 2008 13:45:04 Assunto: Re: [Kamailio-Users] Problems with SerMyAdmin Installation Hi, Can you add your users to groups? I just went back to openser 1.2 because of the problems I was facing with sermyadmin adding users to groups and bombing out. I was using 1.33 - but it seems that that is not the problem. I can add groups ok but get the following when adding users to those groups! (GRRRR) Grails Runtime Exception Error Details Message: could not insert: [UserGroup]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [UserGroup] Caused by: org.springframework.dao.DataIntegrityViolationException: could not insert: [UserGroup]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [UserGroup] Class: UserController At Line: [115] Code Snippet: Stack Trace org.codehaus.groovy.runtime.InvokerInvocationException: org.springframework.dao.DataIntegrityViolationException: could not insert: [UserGroup]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [UserGroup] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jsecurity.web.servlet.WebInterceptorFilter.doFilterInternal(WebInterceptorFilter.java:106) at org.jsecurity.web.servlet.SecurityContextFilter.doFilterInternal(SecurityContextFilter.java:93) at org.jsecurity.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:595) Caused by: org.springframework.dao.DataIntegrityViolationException: could not insert: [UserGroup]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [UserGroup] at UserController$_closure6_closure13.doCall(UserController.groovy:115) at UserController$_closure6.doCall(UserController.groovy:105) at UserController$_closure6.doCall(UserController.groovy) ... 29 more Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [UserGroup] at $Proxy3.saveOrUpdate(Unknown Source) ... 32 more Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry 'brian-sip.asterisk.ie-' for key 2 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1011) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) ... 33 more Hello, I solved my problem with Nuno's help. My problem was with the permissions in mysql. The command GRANT ALL PRIVILEGES ON openser.* TO user@'%' IDENTIFIED BY 'Password'; did't add the user properly.. I had to also use GRANT ALL PRIVILEGES ON openser.* TO user@'localhost' IDENTIFIED BY 'password'; because sermyadmin and mysql were running in the same machine. After that I could run sermyadmin and it changed all the tables properly. -- View this message in context: http://www.nabble.com/Problems-with-SerMyAdmin-Installation-tp16965040p1941… Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com. _______________________________________________ Users mailing list Users(a)lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

2 1

[Kamailio-Users] problem with emergency calls (short-numbers)
by BERGANZ François 25 Sep '08

25 Sep '08

Hello, I have a problem with my emergency calls if (uri=~"^sip:1[578]{1}@*" || uri=~"^sip:11[29]{1}@*") if I call 170725014, it think that it is 17 (emergency in france) is my "if" syntaxe is correct ? Cordialement BERGANZ François http://www.acropolistelecom.net <http://www.acropolistelecom.net/>

2 3

[Kamailio-Users] BAD URI After $ru and avp
by Ali Jawad 25 Sep '08

25 Sep '08

Hi I am trying to change the Ruri as stated below DB usr_preferences Domain= Value=callfwd Attribute=33179974674 if(avp_db_load("$ruri/username","$avp(s:callfwd)")){ xlog("L_INFO","X0XOXOXOXOXOXOXXOXOXOXXOXOXOXOXOX"); $ru = $avp(s:callfwd); route(8); exit; }; It enters allright and it changes the rURI however It throws the errors below: Sep 25 13:31:23 [24879] DBG:avpops:db_close_query: close avp query Sep 25 13:31:23 [24879] DBG:core:db_free_rows: freeing 1 rows Sep 25 13:31:23 [24879] DBG:core:db_free_rows: row[0]=0x8187160 Sep 25 13:31:23 [24879] ERROR:core:do_action: bad uri <33179974674>, dropping packet Sep 25 13:31:23 [24879] DBG:core:parse_to: display={"9611375554"}, ruri={sip:9611375554@xyz.com} Sep 25 13:31:23 [24879] ERROR:core:parse_uri: bad uri, state 0 parsed: <3317> (4) / <33179974674> (25) Sep 25 13:31:23 [24879] ERROR:core:parse_sip_msg_uri: bad uri <33179974674(a)33.33.33.33> Sep 25 13:31:23 [24879] DBG:core:set_err_info: ec: 1, el: 3, ei: 'error parsing r-uri' Sep 25 13:31:23 [24879] ERROR:tm:new_t: uri invalid With Regards Ali Jawad System Administrator Splendor Telecom (www.splendor.net) Beirut, Lebanon Phone: +961 1 373725 Fax: + 961 1 375554

2 1

[Kamailio-Users] Error compiling openser 1.2.2 notls on Ubuntu 8.04 x86_64
by Marcello Lupo 25 Sep '08

25 Sep '08

Hi, i'm getting this error on compiling openser-1.2.2-notls on Ubuntu 8.04 x86_64 Can you help me to see wath's is wrong? Same sources compiled perfect on SLES 10 x86_64. Thank you. Bye, Marcello gcc -g -O9 -funroll-loops -Wcast-align -Wall -minline-all-stringops - falign-loops -ftree-vectorize -mtune=opteron -DNAME='"openser"' - DVERSION='"1.2.2-notls"' -DARCH='"x86_64"' -DOS='"linux"' - DCOMPILER='"gcc 4.2.3"' -D__CPU_x86_64 -D__OS_linux -D__SMP_yes - DCFG_DIR='"/data/openser/etc/openser/"' -DPKG_MALLOC -DSHM_MEM - DSHM_MMAP -DUSE_IPV6 -DUSE_MCAST -DUSE_TCP -DDISABLE_NAGLE - DHAVE_RESOLV_RES -DSTATISTICS -DF_MALLOC -DFAST_LOCK -DADAPTIVE_WAIT - DADAPTIVE_WAIT_LOOPS=1024 -DHAVE_GETHOSTBYNAME2 -DHAVE_UNION_SEMUN - DHAVE_SCHED_YIELD -DHAVE_MSG_NOSIGNAL -DHAVE_MSGHDR_MSG_CONTROL - DHAVE_ALLOCA_H -DHAVE_TIMEGM -DHAVE_EPOLL -DHAVE_SIGIO_RT - DHAVE_SELECT -c action.c -o action.o In file included from parser/msg_parser.h:48, from action.h:27, from action.c:44: parser/../config.h:2: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘:’ token In file included from parser/msg_parser.h:48, from action.h:27, from action.c:44: parser/../config.h:2:38: error: invalid digit "8" in octal constant parser/../config.h:2:41: error: invalid suffix "Z" on integer constant parser/../config.h:8: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘can’ parser/../config.h:10: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘version’ parser/../config.h:14: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘even’ parser/../config.h:19: error: expected identifier or ‘(’ before ‘if’ parser/../config.h:26:63: warning: missing terminating ' character parser/../config.h:26: error: missing terminating ' character In file included from action.c:45: config.h:2: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘:’ token In file included from action.c:45: config.h:2:38: error: invalid digit "8" in octal constant config.h:2:41: error: invalid suffix "Z" on integer constant config.h:8: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘can’ config.h:10: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘version’ config.h:14: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘even’ config.h:19: error: expected identifier or ‘(’ before ‘if’ config.h:26:63: warning: missing terminating ' character config.h:26: error: missing terminating ' character In file included from route.h:32, from forward.h:39, from action.c:49: config.h:2: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘:’ token In file included from route.h:32, from forward.h:39, from action.c:49: config.h:2:38: error: invalid digit "8" in octal constant config.h:2:41: error: invalid suffix "Z" on integer constant config.h:8: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘can’ config.h:10: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘version’ config.h:14: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘even’ config.h:19: error: expected identifier or ‘(’ before ‘if’ config.h:26:63: warning: missing terminating ' character config.h:26: error: missing terminating ' character In file included from ut.h:47, from action.c:54: config.h:2: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘:’ token In file included from ut.h:47, from action.c:54: config.h:2:38: error: invalid digit "8" in octal constant config.h:2:41: error: invalid suffix "Z" on integer constant config.h:8: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘can’ config.h:10: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘version’ config.h:14: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘even’ config.h:19: error: expected identifier or ‘(’ before ‘if’ config.h:26:63: warning: missing terminating ' character config.h:26: error: missing terminating ' character In file included from mem/mem.h:35, from action.c:56: mem/../config.h:2: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘:’ token In file included from mem/mem.h:35, from action.c:56: mem/../config.h:2:38: error: invalid digit "8" in octal constant mem/../config.h:2:41: error: invalid suffix "Z" on integer constant mem/../config.h:8: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘can’ mem/../config.h:10: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘version’ mem/../config.h:14: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘even’ mem/../config.h:19: error: expected identifier or ‘(’ before ‘if’ mem/../config.h:26:63: warning: missing terminating ' character mem/../config.h:26: error: missing terminating ' character In file included from mem/mem.h:54, from action.c:56: mem/f_malloc.h:134: warning: ‘struct mem_info’ declared inside parameter list mem/f_malloc.h:134: warning: its scope is only this definition or declaration, which is probably not what you want action.c: In function ‘do_action’: action.c:387: error: ‘ser_error’ undeclared (first use in this function) action.c:387: error: (Each undeclared identifier is reported only once action.c:387: error: for each function it appears in.) action.c:564: error: ‘rlist’ undeclared (first use in this function) make: *** [action.o] Error 1

2 3

[Kamailio-Users] Bind Access To Users to their IPs
by Ali Jawad 25 Sep '08

25 Sep '08

Hi I want some of my users only to be able to logon through a certain IP, is there some ACL mechanism that can be used to do that ? With Regards Ali Jawad System Administrator Splendor Telecom (www.splendor.net) Beirut, Lebanon Phone: +961 1 373725 Fax: + 961 1 375554

2 4

[Kamailio-Users] SUBSCRIBE message with a private header
by Yoo Chan Jeon 24 Sep '08

24 Sep '08

Hi, I have a client sip agent which sends a SUBSCRIBE msg with a private header to the Kamailio presence server. Hwo do I get the private header informtaion? I want to read it and send it with a Notify message. Thanks. Jeon

2 1

[Kamailio-Users] sipgrep as non-privileged user
by Robert McNaught 24 Sep '08

24 Sep '08

Hi, I am using sipgrep to do sip traces on an openser/asterisk. I am find this great for getting readable traces - previously ngrep was difficult to read. However, to use sipgrep, I need to be logged in as the linux root user. I can change the PATH of an admin user so that they can have access to the command but they cannot use it as they need to be root in order to gain access to see the network traffic. Does anyone know of a way to do this? Is it normal to have engineers continually log in as root to take these traces - it seems awful dangerous? I know you could log in as a non-prileged user and put in sudo sipgrep -f xxx -t xxx, but not sure if people are actually doing this in production systems, or have a workaround? Thanks Robert

3 2

[Kamailio-Users] new feature: generic shared container in config language
by Elena-Ramona Modroiu 24 Sep '08

24 Sep '08

Hi, I just committed a new module: htable http://www.kamailio.org/docs/modules/devel/htable.html It adds a generic hash table container for usage in configuration file. The hash table is in shared memory, therefore the values are global over all kamailio processes. The items in hash table can be accessed via $sht(name). The name can include pseudo-variables that will be evaluated at runtime. In this way, the hash table can be used to store data per user and can offer functionality of dealing with array of values. An example of how to protect against dictionary attacks is in the README (link to online version above). As another example, loading values in hash tables from AVPs and building an array: $var(i) = 0; while($(avp(s:tmp)[$var(i)]) != NULL) { $sht(tmp[$var(i)]) = $(avp(s:tmp)[$var(i)]); $var(i) = $var(i)+1; } As a roadmap for the new module, planned for addition: - MI commands to get/set items in HT - ability to save/load in/from database - ability to init items at startup - auto-expire time for items This completes global variables space along with shared variables ($shv(name)) which are single value and allow only static name, but they are faster to access (see cfgutils readme file for more details on $shv(name)). Regards, Ramona -- Elena-Ramona Modroiu Web: http://www.asipto.com

3 2

[Kamailio-Users] Access List
by michel freiha 24 Sep '08

24 Sep '08

Hi All, Hi All,I need please to configure kamailio in order to force the user to register to my it from a specific IP...It's like creation of an access list...If the customer tries to register from another IP frm the one specified in kamailio he'll be denied Regards

3 2

[Kamailio-Users] digest or not digest ...
by BERGANZ François 24 Sep '08

24 Sep '08

Hello all, I need to choose if my users do digest auth or not! If I have : modparam("auth_db", "calculate_ha1", yes)àauth or modparam("auth_db", "calculate_ha1", 0)àauth digest! How can I choose if this user is digest after having look at a param in the database For example, user 1 have a column in the database which say ok he can do digest auth How can I ask to the client an auth digest ? Thank you Cordialement BERGANZ François http://www.acropolistelecom.net <http://www.acropolistelecom.net/>

2 2

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

sr-users