[SR-Users] DBURL
shmick at riseup.net
shmick at riseup.net
Wed Nov 5 10:46:41 CET 2014
not previously no
$ sudo grep -e '#!define' /etc/kamailio/kamailio.cfg
# Several features can be enabled using '#!define WITH_FEATURE' directives:
#!define MULTIDOMAIN 1
#!define MULTIDOMAIN 0
#!define FLT_ACC 1
#!define FLT_ACCMISSED 2
#!define FLT_ACCFAILED 3
#!define FLT_NATS 5
#!define FLB_NATB 6
#!define FLB_NATSIPPING 7
$ sudo cat /etc/kamailio/kamailio-local.cfg
#!define WITH_MYSQL
#!define WITH_AUTH
#!define WITH_USRLOCDB
#!define WITH_NAT
#!define WITH_TLS
all the above didn't work thanks to a useless howto
if i remove /etc/kamailio/kamailio-local.cfg and add only #!define
WITH_MYSQL to /etc/kamailio/kamailio.cfg
i then get the following with offending lines below and the service
restart error
####### Defined Values #########
# *** Value defines - IDs used later in config
#!ifdef WITH_MYSQL
# - database URL - used to connect to database server by modules such
# as: auth_db, acc, usrloc, a.s.o.
#!ifndef DBURL
DBURL "mysql://kamailio:kamailiorw@localhost/kamailio" *offending line*
#!endif
#!endif
#!ifdef WITH_MULTIDOMAIN
# - the value for 'use_domain' parameters
#!define MULTIDOMAIN 1
#!else
#!define MULTIDOMAIN 0
#!endif
####### Global Parameters #########
### LOG Levels: 3=DBG, 2=INFO, 1=NOTICE, 0=WARN, -1=ERR
#!ifdef WITH_DEBUG
debug=4
log_stderror=yes
#!else
debug=2 <---- *offending line*
log_stderror=no
#!endif
$ sudo service kamailio start
[FAIL] Not starting Kamailio SIP Server: invalid configuration file! ...
failed!
failed!
[....] 0(5959) : <core> [cfg.y:3436]: yyerror_at(): parse error in
config file /etc/kamailio/kamailio.cfg, line 119, column 7-54: syntax
error 0(5959) : <core> [cfg.y:3439]: yyerror_at(): parse error in config
file /etc/kamailio/kamailio.cfg, line 147, column 6: unknown config
variable 0(5959) : <core> [cfg.y:3439]: yyerror_at(): parse error in
config file /etc/kamailio/kamailio.cfg, line 147, column 7: ERROR: bad
config file (3 errors) 0(5959) WARNING: <core> [pp[FAIL:219]:
pp_ifdef_level_check(): different number of preprocessor directives:
N(#!IF[N]DEF) - N(#!ENDIF) = 1 ... failed!
appart from the howto i have not altered anything else except for
creating the local cfg which is now deleted
kamilio docs are very hard to digest, aren't they !
Daniel-Constantin Mierla:
> Do you have:
>
> #!define WITH_MYSQL
>
> in your config?
>
> Cheers,
> Daniel
>
> On 04/11/14 16:32, shmick at riseup.net wrote:
>> [i have no idea about email subject nor anything else for this except
>> prior i configured rtpproxy to work with kamailio on a unix socket and
>> updated tls.cfg to use my cert/key]
>>
>> running kamailio from
>>
>> deb http://deb.kamailio.org/kamailio jessie main
>>
>>
>> $ sudo service kamailio restart
>> [FAIL] Not starting Kamailio SIP Server: invalid configuration file! ...
>> failed!
>> failed!
>> [....] 0(15228) INFO: tls [tls_init.c:385]: init_tls_compression(): tls:
>> init_tls: disabling compression... 0(15228) : <core> [cfg.y:3436]:
>> yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg,
>> line 353, column 30-34: syntax error 0(15228) : <core> [cfg.y:3436]:
>> yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg,
>> line 353, column 30-34: Invalid arguments 0(15228) : <core>
>> [cfg.y:3439]: yyerror_at(): parse error in config file
>> /etc/kamailio/kamailio.cfg, line 353, column 35: ERROR: bad config file
>> (3 errors) 0(15228) WARNING: <core> [ppcfg.c:219]:
>> pp_ifdef_level_check(): different numbe[FAILpreprocessor directives:
>> N(#!IF[N]DEF) - N(#!ENDIF) = 1 ... failed!
>> failed!
>>
>>
>> /* enhanced DB accounting */
>> #!ifdef WITH_ACCDB
>> modparam("acc", "db_flag", FLT_ACC)
>> modparam("acc", "db_missed_flag", FLT_ACCMISSED)
>> modparam("acc", "db_url", DBURL)
>> modparam("acc", "db_extra",
>> "src_user=$fU;src_domain=$fd;src_ip=$si;"
>> "dst_ouser=$tU;dst_user=$rU;dst_domain=$rd")
>> #!endif
>>
>>
>> # ----- usrloc params -----
>> /* enable DB persistency for location entries */
>> #!ifdef WITH_USRLOCDB
>> modparam("usrloc", "db_url", *DBURL*) <--------not happy with DBURL here
>> modparam("usrloc", "db_mode", 2)
>> modparam("usrloc", "use_domain", MULTIDOMAIN)
>> #!endif
>>
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>> sr-users at lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
More information about the sr-users
mailing list