[SR-Users] Script @Startup

Nicolas Breuer Nicolas.Breuer at belcenter.biz
Fri Oct 19 09:19:29 CEST 2018 

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<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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20181019/524c32c1/attachment.html>

More information about the sr-users mailing list