Hello,
I'm trying to compile OpenSER 1.3.3 and getting the following error i have
run a comand "make all include_modules="mysql""
--------------------------------------------------------------------------------------------------------
dbase.c:29:25: error: mysql/mysql.h: No such file or directory
dbase.c:30:26: error: mysql/errmsg.h: No such file or directory
dbase.c:31:33: error: mysql/mysql_version.h: No such file or directory
In file included from dbase.c:38:
my_con.h:38: error: expected specifier-qualifier-list before Б─≤MYSQL_RESБ─≥
dbase.c: In function Б─≤db_mysql_submit_queryБ─≥:
dbase.c:65: error: Б─≤struct my_conБ─≥ has no member named Б─≤timestampБ─≥
dbase.c:66: warning: implicit declaration of function Б─≤mysql_pingБ─≥
dbase.c:66: error: Б─≤struct my_conБ─≥ has no member named Б─≤conБ─≥
dbase.c:70: error: Б─≤struct my_conБ─≥ has no member named Б─≤timestampБ─≥
dbase.c:88: warning: implicit declaration of function Б─≤mysql_queryБ─≥
dbase.c:88: error: Б─≤struct my_conБ─≥ has no member named Б─≤conБ─≥
dbase.c:91: warning: implicit declaration of function Б─≤mysql_errnoБ─≥
dbase.c:91: error: Б─≤struct my_conБ─≥ has no member named Б─≤conБ─≥
dbase.c:92: error: Б─≤CR_SERVER_GONE_ERRORБ─≥ undeclared (first use in this
function)
dbase.c:92: error: (Each undeclared identifier is reported only once
dbase.c:92: error: for each function it appears in.)
dbase.c:92: error: Б─≤CR_SERVER_LOSTБ─≥ undeclared (first use in this
function)
dbase.c:96: warning: implicit declaration of function Б─≤mysql_errorБ─≥
dbase.c:96: error: Б─≤struct my_conБ─≥ has no member named Б─≤conБ─≥
dbase.c:96: error: Б─≤struct my_conБ─≥ has no member named Б─≤conБ─≥
dbase.c:96: warning: format Б─≤%sБ─≥ expects type Б─≤char *Б─≥, but argument
4 has type Б─≤intБ─≥
dbase.c: In function Б─≤db_mysql_store_resultБ─≥:
dbase.c:195: error: Б─≤struct my_conБ─≥ has no member named Б─≤resБ─≥
dbase.c:195: warning: implicit declaration of function
Б─≤mysql_store_resultБ─≥
dbase.c:195: error: Б─≤struct my_conБ─≥ has no member named Б─≤conБ─≥
dbase.c:196: error: Б─≤struct my_conБ─≥ has no member named Б─≤resБ─≥
dbase.c:197: warning: implicit declaration of function
Б─≤mysql_field_countБ─≥
dbase.c:197: error: Б─≤struct my_conБ─≥ has no member named Б─≤conБ─≥
dbase.c:202: error: Б─≤struct my_conБ─≥ has no member named Б─≤conБ─≥
dbase.c:202: error: Б─≤struct my_conБ─≥ has no member named Б─≤conБ─≥
dbase.c:202: warning: format Б─≤%sБ─≥ expects type Б─≤char *Б─≥, but
argument 4 has type Б─≤intБ─≥
dbase.c:216: warning: implicit declaration of function
Б─≤mysql_free_resultБ─≥
dbase.c:216: error: Б─≤struct my_conБ─≥ has no member named Б─≤resБ─≥
dbase.c:223: error: Б─≤struct my_conБ─≥ has no member named Б─≤resБ─≥
dbase.c: In function Б─≤db_mysql_free_resultБ─≥:
dbase.c:253: error: Б─≤struct my_conБ─≥ has no member named Б─≤resБ─≥
dbase.c:254: error: Б─≤struct my_conБ─≥ has no member named Б─≤resБ─≥
dbase.c: In function Б─≤db_mysql_fetch_resultБ─≥:
dbase.c:361: error: Б─≤struct my_conБ─≥ has no member named Б─≤resБ─≥
dbase.c:361: error: Б─≤struct my_conБ─≥ has no member named Б─≤conБ─≥
dbase.c:362: error: Б─≤struct my_conБ─≥ has no member named Б─≤resБ─≥
dbase.c:363: error: Б─≤struct my_conБ─≥ has no member named Б─≤conБ─≥
dbase.c:368: error: Б─≤struct my_conБ─≥ has no member named Б─≤conБ─≥
dbase.c:368: error: Б─≤struct my_conБ─≥ has no member named Б─≤conБ─≥
dbase.c:368: warning: format Б─≤%sБ─≥ expects type Б─≤char *Б─≥, but
argument 4 has type Б─≤intБ─≥
dbase.c:379: warning: implicit declaration of function Б─≤mysql_num_rowsБ─≥
dbase.c:379: error: Б─≤struct my_conБ─≥ has no member named Б─≤resБ─≥
dbase.c:414: error: Б─≤struct my_conБ─≥ has no member named Б─≤rowБ─≥
dbase.c:414: warning: implicit declaration of function Б─≤mysql_fetch_rowБ─≥
dbase.c:414: error: Б─≤struct my_conБ─≥ has no member named Б─≤resБ─≥
dbase.c:415: error: Б─≤struct my_conБ─≥ has no member named Б─≤rowБ─≥
dbase.c:416: error: Б─≤struct my_conБ─≥ has no member named Б─≤conБ─≥
dbase.c:416: error: Б─≤struct my_conБ─≥ has no member named Б─≤conБ─≥
dbase.c:416: warning: format Б─≤%sБ─≥ expects type Б─≤char *Б─≥, but
argument 4 has type Б─≤intБ─≥
dbase.c: In function Б─≤db_last_inserted_idБ─≥:
dbase.c:649: warning: implicit declaration of function Б─≤mysql_insert_idБ─≥
dbase.c:649: error: Б─≤struct my_conБ─≥ has no member named Б─≤conБ─≥
make[1]: *** [dbase.o] Error 1
make[1]: Leaving directory `/src/openser-1.3.3-notls/modules/mysql'
make: *** [modules] Error 2
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
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/>
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
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
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
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
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