[SR-Users] Script @Startup
Daniel-Constantin Mierla
miconda at gmail.com
Fri Oct 19 09:13:31 CEST 2018
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20181019/bf504aed/attachment.html>
More information about the sr-users
mailing list