[SR-Users] Script @Startup
Daniel-Constantin Mierla
miconda at gmail.com
Fri Oct 19 09:30:48 CEST 2018
You need to install libmysqlclient (-dev) -- see the readme of db_mysql
module for dependencies.
Cheers,
Daniel
On 19.10.18 09:19, Nicolas Breuer wrote:
> I install mysql server from sources
>
>
> Le 19 oct. 2018 à 09:15, Daniel-Constantin Mierla <miconda at gmail.com
> <mailto:miconda at gmail.com>> a écrit :
>
>>
>>
>> On 19.10.18 09:02, Nicolas Breuer wrote:
>>>
>>>
>>>
>>> Did you install libmysqlclient from sources?
>>>
>>> NO
>>>
>>
>> How the file /usr/local/mysql/include/mysql.h was deployed? What is
>> your operating system?
>>
>> Cheers,
>> Daniel
>>
>>
>>>
>>>
>>> Is pkg-config installed?
>>>
>>>
>>>
>>> YES
>>>
>>>
>>>
>>>
>>>
>>> Cheers,
>>> Daniel
>>>
>>>
>>>
>>> On 19.10.18 08:44, Nicolas Breuer wrote:
>>>
>>>
>>>
>>>
>>>
>>> *De :*Nicolas Breuer
>>> *Envoyé :* jeudi 18 octobre 2018 13:20
>>> *À :* miconda at gmail.com <mailto:miconda at gmail.com>; Kamailio
>>> (SER) - Users Mailing List <sr-users at lists.kamailio.org>
>>> <mailto:sr-users at lists.kamailio.org>
>>> *Objet :* RE: [SR-Users] Script @Startup
>>>
>>>
>>>
>>> Hi Daniel,
>>>
>>>
>>>
>>> Tried to compile from master on a test machine.
>>>
>>>
>>>
>>> But failed on mysql.h -> mysql.h is well present on the server.
>>>
>>> Any ideas?
>>>
>>>
>>>
>>>
>>>
>>> [root at proxy1 src]# make install
>>>
>>>
>>>
>>> touch /usr/local/sbin//kamailio
>>>
>>> install -m 755 kamailio /usr/local/sbin/
>>>
>>> CC (gcc) [M db_mysql.so] db_mysql.o
>>>
>>> In file included from db_mysql.c:30:
>>>
>>> my_con.h:30:19: warning: mysql.h: No such file or directory
>>>
>>> In file included from db_mysql.c:30:
>>>
>>> my_con.h:40: error: expected specifier-qualifier-list before âMYSQLâ
>>>
>>> In file included from db_mysql.c:31:
>>>
>>> my_cmd.h:40: error: expected specifier-qualifier-list before
>>> âMYSQL_STMTâ
>>>
>>> In file included from db_mysql.c:32:
>>>
>>> my_fld.h:45: error: expected specifier-qualifier-list before
>>> âmy_boolâ
>>>
>>> db_mysql.c: In function âmysql_mod_initâ:
>>>
>>> db_mysql.c:149: error: âMYSQL_VERSION_IDâ undeclared (first use
>>> in this function)
>>>
>>> db_mysql.c:149: error: (Each undeclared identifier is reported
>>> only once
>>>
>>> db_mysql.c:149: error: for each function it appears in.)
>>>
>>> make[1]: *** [db_mysql.o] Error 1
>>>
>>> make: *** [install-modules] Error 1
>>>
>>>
>>>
>>> [root at proxy1 src]# locate mysql.h
>>>
>>>
>>>
>>> /usr/local/mysql/include/mysql.h
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> *De :*Daniel-Constantin Mierla <miconda at gmail.com
>>> <mailto:miconda at gmail.com>>
>>> *Envoyé :* jeudi 18 octobre 2018 09:21
>>> *À :* Nicolas Breuer <Nicolas.Breuer at belcenter.biz
>>> <mailto:Nicolas.Breuer at belcenter.biz>>; Kamailio (SER) - Users
>>> Mailing List <sr-users at lists.kamailio.org
>>> <mailto:sr-users at lists.kamailio.org>>
>>> *Objet :* Re: [SR-Users] Script @Startup
>>>
>>>
>>>
>>> Well, I guess you can test somewhere else or rebuild the
>>> binaries ...
>>>
>>> Cheers,
>>> Daniel
>>>
>>>
>>>
>>> On 18.10.18 09:06, Nicolas Breuer wrote:
>>>
>>> Hello Daniel,
>>>
>>>
>>>
>>> Sorry but i don’t have the source on this server, this is
>>> the production VM 😊
>>>
>>>
>>>
>>>
>>>
>>> *De :*Daniel-Constantin Mierla <miconda at gmail.com>
>>> <mailto:miconda at gmail.com>
>>> *Envoyé :* jeudi 18 octobre 2018 09:01
>>> *À :* Nicolas Breuer <nicolas.breuer at belcenter.biz>
>>> <mailto:nicolas.breuer at belcenter.biz>; Kamailio (SER) -
>>> Users Mailing List <sr-users at lists.kamailio.org>
>>> <mailto:sr-users at lists.kamailio.org>
>>> *Objet :* Re: [SR-Users] Script @Startup
>>>
>>>
>>>
>>> Can you try with master branch or the patch from the commit
>>> linked next?
>>>
>>> -
>>> https://github.com/kamailio/kamailio/commit/a4b6a5cb1dda7576b265a23c91321b7f2a034658
>>>
>>> If all ok, I will backport to 5.1 branch.
>>>
>>> Cheers,
>>> Daniel
>>>
>>>
>>>
>>> On 17.10.18 19:45, Nicolas Breuer wrote:
>>>
>>> version: kamailio 5.1.5 (x86_64/linux) d06080
>>>
>>> flags: STATS: Off, USE_TCP, USE_TLS, USE_SCTP,
>>> TLS_HOOKS, USE_RAW_SOCKS, DISABLE_NAGLE, USE_MCAST,
>>> DNS_IP_HACK, SHM_MEM, SHM_MMAP, PKG_MALLOC, Q_MALLOC,
>>> F_MALLOC, TLSF_MALLOC, DBG_SR_MEMORY, 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_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB
>>>
>>> poll method support: poll, epoll_lt, epoll_et, sigio_rt,
>>> select.
>>>
>>> id: d06080
>>>
>>> compiled on 10:02:52 Aug 22 2018 with gcc 4.4.7
>>>
>>>
>>>
>>> *De :*Daniel-Constantin Mierla <miconda at gmail.com>
>>> <mailto:miconda at gmail.com>
>>> *Envoyé :* mercredi 17 octobre 2018 19:44
>>> *À :* Nicolas Breuer <nicolas.breuer at belcenter.biz>
>>> <mailto:nicolas.breuer at belcenter.biz>; Kamailio (SER) -
>>> Users Mailing List <sr-users at lists.kamailio.org>
>>> <mailto:sr-users at lists.kamailio.org>
>>> *Objet :* Re: [SR-Users] Script @Startup
>>>
>>>
>>>
>>> Hello,
>>>
>>> what is exact version you are running?
>>>
>>> Output for: kamailio -v
>>>
>>> Cheers,
>>> Daniel
>>>
>>>
>>>
>>> On 17.10.18 19:36, Nicolas Breuer wrote:
>>>
>>> Hello,
>>>
>>>
>>>
>>> I found the core file.
>>>
>>>
>>>
>>> Loaded symbols for
>>> /usr/lib64/kamailio/modules/alias_db.so
>>>
>>> Reading symbols from
>>> /usr/lib64/kamailio/modules/nathelper.so...Reading
>>> symbols from
>>> /usr/lib/debug/usr/lib64/kamailio/modules/nathelper.so.debug...done.
>>>
>>> done.
>>>
>>> Loaded symbols for
>>> /usr/lib64/kamailio/modules/nathelper.so
>>>
>>> Reading symbols from
>>> /usr/lib64/kamailio/modules/debugger.so...Reading
>>> symbols from
>>> /usr/lib/debug/usr/lib64/kamailio/modules/debugger.so.debug...done.
>>>
>>> done.
>>>
>>> Loaded symbols for
>>> /usr/lib64/kamailio/modules/debugger.so
>>>
>>> Core was generated by `/usr/sbin/kamailio -f
>>> /etc/kamailio/kamailio.cfg -P
>>> /var/run/kamailio/kamailio.'.
>>>
>>> Program terminated with signal 11, Segmentation fault.
>>>
>>> #0 0x00000033b7a89780 in memcpy () from
>>> /lib64/libc.so.6
>>>
>>> Missing separate debuginfos, use: debuginfo-install
>>> glibc-2.12-1.212.el6.x86_64
>>> keyutils-libs-1.4-5.el6.x86_64
>>> krb5-libs-1.10.3-65.el6.x86_64
>>> libcom_err-1.41.12-24.el6.x86_64
>>> libselinux-2.0.94-7.el6.x86_64
>>> mysql-libs-5.1.73-8.el6_8.x86_64
>>> nss-softokn-freebl-3.14.3-23.3.el6_8.x86_64
>>> openssl-1.0.1e-57.el6.x86_64 zlib-1.2.3-29.el6.x86_64
>>>
>>> (gdb) bt
>>>
>>> #0 0x00000033b7a89780 in memcpy () from
>>> /lib64/libc.so.6
>>>
>>> #1 0x000000000071e803 in select_cfg_var
>>> (res=0x7fff67b56690, s=0x7f90d37f34f8, msg=0xa50460)
>>> at core/cfg/cfg_select.c:223
>>>
>>> #2 0x000000000059d429 in run_select
>>> (res=0x7fff67b56690, s=0x7f90d37f34f8, msg=0xa50460)
>>> at core/select.c:425
>>>
>>> #3 0x00007f90d178740d in pv_get_select
>>> (msg=0xa50460, param=0x7f90d37f3428,
>>> res=0x7fff67b567b0) at pv_select.c:61
>>>
>>> #4 0x0000000000523e09 in pv_get_spec_value
>>> (msg=0xa50460, sp=0x7f90d37f3410,
>>> value=0x7fff67b567b0) at core/pvapi.c:1380
>>>
>>> #5 0x00000000005242be in pv_printf (msg=0xa50460,
>>> list=0x7f90d3924998, buf=0x7f90d2e58260 "select
>>> Status FROM x_providers_SIP where Provider like
>>> 'PROXY%' and (Proxy_ID='", len=0x7fff67b5687c) at
>>> core/pvapi.c:1439
>>>
>>> #6 0x00007f90d2c2f9f0 in ops_dbquery_avps
>>> (msg=0xa50460, query=0x7f90d3924998,
>>> dest=0x7f90d3924aa8) at avpops_impl.c:744
>>>
>>> #7 0x00007f90d2c218f5 in w_dbquery2_avps
>>> (msg=0xa50460, query=0x7f90d3924998 "pa[Ó177",
>>> dest=0x7f90d3924aa8 "\004") at avpops.c:1022
>>>
>>> #8 0x0000000000434041 in do_action
>>> (h=0x7fff67b57300, a=0x7f90d35b5cb0, msg=0xa50460)
>>> at core/action.c:1079
>>>
>>> #9 0x0000000000440bd5 in run_actions
>>> (h=0x7fff67b57300, a=0x7f90d35b4480, msg=0xa50460)
>>> at core/action.c:1565
>>>
>>> #10 0x0000000000441361 in run_top_route
>>> (a=0x7f90d35b4480, msg=0xa50460, c=0x7fff67b57300)
>>> at core/action.c:1654
>>>
>>> #11 0x0000000000441910 in run_child_one_init_route
>>> () at core/action.c:1680
>>>
>>> #12 0x000000000042424b in main_loop () at main.c:1616
>>>
>>> #13 0x000000000042b5ee in main (argc=13,
>>> argv=0x7fff67b578e8) at main.c:2638
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> *De :*Daniel-Constantin Mierla <miconda at gmail.com>
>>> <mailto:miconda at gmail.com>
>>> *Envoyé :* mercredi 17 octobre 2018 19:16
>>> *À :* Kamailio (SER) - Users Mailing List
>>> <sr-users at lists.kamailio.org>
>>> <mailto:sr-users at lists.kamailio.org>; Nicolas Breuer
>>> <nicolas.breuer at belcenter.biz>
>>> <mailto:nicolas.breuer at belcenter.biz>
>>> *Objet :* Re: [SR-Users] Script @Startup
>>>
>>>
>>>
>>> Hello,
>>>
>>> the log message says that core file was generated,
>>> get the backtrace from it with gdb and post it here
>>> in order to see where the crash was.
>>>
>>> Cheers,
>>> Daniel
>>>
>>>
>>>
>>> On 17.10.18 18:59, Nicolas Breuer wrote:
>>>
>>> Hello,
>>>
>>>
>>>
>>> Doing an avp_db_query works but we have a crash
>>> just after 😊
>>>
>>>
>>>
>>> Oct 17 18:58:11 proxy1 kernel: kamailio[8987]:
>>> segfault at 0 ip 00000033b7a89780 sp
>>> 00007fff8e7765a8 error 4 in
>>> libc-2.12.so[33b7a00000+18b000]
>>>
>>> Oct 17 18:58:12 proxy1 /usr/sbin/kamailio[8986]:
>>> ALERT: <core> [main.c:739]: handle_sigs(): child
>>> process 8987 exited by a signal 11
>>>
>>> Oct 17 18:58:12 proxy1 /usr/sbin/kamailio[8986]:
>>> ALERT: <core> [main.c:742]: handle_sigs(): core
>>> was generated
>>>
>>>
>>>
>>>
>>>
>>> -----Message d'origine-----
>>> De : sr-users
>>> <sr-users-bounces at lists.kamailio.org>
>>> <mailto:sr-users-bounces at lists.kamailio.org> De
>>> la part de Mikko Lehto
>>> Envoyé : mercredi 17 octobre 2018 09:28
>>> À : Kamailio (SER) - Users Mailing List
>>> <sr-users at lists.kamailio.org>
>>> <mailto:sr-users at lists.kamailio.org>
>>> Objet : Re: [SR-Users] Script @Startup
>>> Importance : Haute
>>>
>>>
>>>
>>> Nicolas Breuer <nicolas.breuer at belcenter.biz
>>> <mailto:nicolas.breuer at belcenter.biz>>:
>>>
>>>
>>>
>>> > Is there a way to execute some codes/scripts
>>> at the launch of the Kamailio Server ?
>>>
>>> >
>>>
>>> > So only once when we launch the server.
>>>
>>>
>>>
>>> Hi, maybe event route core:worker-one-init is
>>> helpful to you.
>>>
>>>
>>>
>>> See:
>>> http://kamailio.org/wiki/cookbooks/5.1.x/core#event_route
>>>
>>>
>>>
>>> --
>>>
>>> Mikko
>>>
>>>
>>>
>>> _______________________________________________
>>>
>>> Kamailio (SER) - Users Mailing List
>>>
>>> sr-users at lists.kamailio.org
>>> <mailto:sr-users at lists.kamailio.org>
>>>
>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>>
>>> Kamailio (SER) - Users Mailing List
>>>
>>> sr-users at lists.kamailio.org
>>> <mailto:sr-users at lists.kamailio.org>
>>>
>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>>
>>> Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com>
>>>
>>> www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda
>>> <http://www.linkedin.com/in/miconda>
>>>
>>> Kamailio World Conference -- www.kamailioworld.com <http://www.kamailioworld.com>
>>>
>>> Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com <http://www.asipto.com>
>>>
>>>
>>>
>>>
>>>
>>> --
>>>
>>> Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com>
>>>
>>> www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda
>>> <http://www.linkedin.com/in/miconda>
>>>
>>> Kamailio World Conference -- www.kamailioworld.com <http://www.kamailioworld.com>
>>>
>>> Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com <http://www.asipto.com>
>>>
>>>
>>>
>>>
>>> --
>>>
>>> Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com>
>>>
>>> www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>
>>>
>>> Kamailio World Conference -- www.kamailioworld.com <http://www.kamailioworld.com>
>>>
>>> Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com <http://www.asipto.com>
>>>
>>>
>>>
>>> --
>>>
>>> Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com>
>>>
>>> www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>
>>>
>>> Kamailio World Conference -- www.kamailioworld.com <http://www.kamailioworld.com>
>>>
>>> Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com <http://www.asipto.com>
>>>
>>>
>>>
>>> --
>>> Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com>
>>> www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>
>>> Kamailio World Conference -- www.kamailioworld.com <http://www.kamailioworld.com>
>>> Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com <http://www.asipto.com>
>>
>> --
>> Daniel-Constantin Mierla -- www.asipto.com
>> www.twitter.com/miconda -- www.linkedin.com/in/miconda
>> Kamailio World Conference -- www.kamailioworld.com
>> Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com
--
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio World Conference -- www.kamailioworld.com
Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20181019/d369d151/attachment.html>
More information about the sr-users
mailing list