[SR-Users] Script @Startup

Daniel-Constantin Mierla miconda at gmail.com
Fri Oct 19 08:54:28 CEST 2018


Did you install libmysqlclient from sources?

Is pkg-config installed?

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; Kamailio (SER) - Users Mailing List
> <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
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/d78025ee/attachment.html>


More information about the sr-users mailing list