Kamailio + Elastix

Discussion in 'General' started by spd21, Feb 25, 2011.

  1. spd21

    Joined:
    Feb 2, 2011
    Messages:
    7
    Likes Received:
    0
    Hi All,

    Kamailio + Elastix = win and I like win.

    I have read this Blog

    http://blogs.elastix.org/en/2010/11/ela ... nstalling/
    http://blogs.elastix.org/en/2011/01/ela ... mment-2741

    It all sounds so reasonable Kamailio for a strong lan sip with presence and messaging, asterisk for the rest of what PBX has to do. Who would not want that?

    So out comes a VM test box

    I am using Elastix-2.0.3-i386-bin-15Nov2010

    First error with ./install_kamailio.sh was

    Missing modules libpurple-devel radiusclient-ng

    And

    kamailio.cfg should be placed into /etc/kamailio/kamailio.cfg not /etc/kamailio.cfg

    You will need to edit kamailio.cfg

    Change 192.168.1.150 to your elastix box ip

    And

    "mysql://asteriskuser:<your elastix password>@localhost/asterisk")

    At this point I am stuck

    When I start kamailio I get:

    Feb 25 09:58:49 pbx kamailio[5264]: INFO: usrloc [hslot.c:53]: locks array size 512
    Feb 25 09:58:49 pbx kamailio[5264]: ERROR: db_mysql [km_dbase.c:117]: driver error on query: Table 'asterisk.version' doesn't exist
    Feb 25 09:58:49 pbx kamailio[5264]: ERROR: <core> [db_query.c:101]: error while submitting query
    Feb 25 09:58:49 pbx kamailio[5264]: ERROR: <core> [db.c:366]: error in db_query
    Feb 25 09:58:49 pbx kamailio[5264]: ERROR: <core> [db.c:405]: querying version for table location
    Feb 25 09:58:49 pbx kamailio[5264]: ERROR: usrloc [dlist.c:491]: error during table version check.
    Feb 25 09:58:49 pbx kamailio[5264]: ERROR: registrar [reg_mod.c:399]: failed to register domain
    Feb 25 09:58:49 pbx kamailio[5264]: ERROR: <core> [route.c:1026]: fixing failed (code=-1) at cfg://etc/kamailio/kamailio.cfg:385
    Feb 25 09:58:49 pbx kamailio[5264]: ERROR: <core> [route.c:1026]: fixing failed (code=-1) at cfg://etc/kamailio/kamailio.cfg:388
    Feb 25 09:58:49 pbx kamailio[5264]: ERROR: <core> [route.c:1026]: fixing failed (code=-1) at cfg://etc/kamailio/kamailio.cfg:391
     
  2. spd21

    Joined:
    Feb 2, 2011
    Messages:
    7
    Likes Received:
    0
    \kamailio-v2.tgz\kamailio-v2.tar\kamailio-freepbx.tar.gz\kamailio-freepbx.tar\kamailio\install.sh

    Edit this file

    eLaStIx.asteriskuser.2oo7 wtf

    #/bin/bash
    cat /var/www/html/admin/modules/kamailio/init.sql|/usr/bin/mysql asterisk -u asteriskuser -peLaStIx.asteriskuser.2oo7
    cd /var/www/html/admin/modules/kamailio
    cat presence-create.sql rls-create.sql |/usr/bin/mysql asterisk -u asteriskuser -peLaStIx.asteriskuser.2oo7
     
  3. garcia.ronald.d

    Joined:
    Sep 24, 2008
    Messages:
    134
    Likes Received:
    0
    Re: Re:Kamailio + Elastix

    Amigo pudiste realizar la instalación del kamailio con el elastix si es así me puedes decir como lo lograste, por favor
     
  4. fmvillares

    Joined:
    Sep 8, 2007
    Messages:
    1,785
    Likes Received:
    0
    Re: Re:Kamailio + Elastix

    poder siempre se puede pero imagino que comprenden la complejidad del sip proxy y la pbx no? la clave en en nuevo sistema no es ams elastix.astersk blah sino la que uds pusieron en la instalacion.
     
  5. spd21

    Joined:
    Feb 2, 2011
    Messages:
    7
    Likes Received:
    0
    Re: Re:Kamailio + Elastix

    fmvillares. does not translate into english using goggle translator.. Use English ..
     
  6. garcia.ronald.d

    Joined:
    Sep 24, 2008
    Messages:
    134
    Likes Received:
    0
    Re: Re:Kamailio + Elastix

    Its true,

    Only I want to know how did you do the instalattion?
     
  7. spd21

    Joined:
    Feb 2, 2011
    Messages:
    7
    Likes Received:
    0
    It's in my 1st and 2dn post
     
  8. spd21

    Joined:
    Feb 2, 2011
    Messages:
    7
    Likes Received:
    0
    I think this is the issue.

    Feb 24 16:51:29 pbx /usr/sbin/kamailio[5247]: WARNING: nathelper [nathelper.c:2349]: can't get version of the RTP proxy
    Feb 24 16:51:29 pbx /usr/sbin/kamailio[5262]: WARNING: nathelper [nathelper.c:2386]: support for RTP proxy <udp:127.0.0.1:7890> has been disabled temporarily
    Feb 24 16:51:29 pbx /usr/sbin/kamailio[5263]: WARNING: nathelper [nathelper.c:2349]: can't get version of the RTP proxy
    Feb 24 16:51:29 pbx /usr/sbin/kamailio[5264]: WARNING: nathelper [nathelper.c:2349]: can't get version of the RTP proxy
    Feb 24 16:51:29 pbx /usr/sbin/kamailio[5251]: WARNING: nathelper [nathelper.c:2349]: can't get version of the RTP proxy
    Feb 24 16:51:29 pbx /usr/sbin/kamailio[5255]: WARNING: nathelper [nathelper.c:2386]: support for RTP proxy <udp:127.0.0.1:7890> has been disabled temporarily
    Feb 24 16:51:29 pbx /usr/sbin/kamailio[5247]: WARNING: nathelper [nathelper.c:2386]: support for RTP proxy <udp:127.0.0.1:7890> has been disabled temporarily
    Feb 24 16:51:29 pbx /usr/sbin/kamailio[5263]: WARNING: nathelper [nathelper.c:2386]: support for RTP proxy <udp:127.0.0.1:7890> has been disabled temporarily
    Feb 24 16:51:30 pbx /usr/sbin/kamailio[5264]: WARNING: nathelper [nathelper.c:2386]: support for RTP proxy <udp:127.0.0.1:7890> has been disabled temporarily
    Feb 24 16:51:30 pbx /usr/sbin/kamailio[5251]: WARNING: nathelper [nathelper.c:2386]: support for RTP proxy <udp:127.0.0.1:7890> has been disabled temporarily
     
  9. garcia.ronald.d

    Joined:
    Sep 24, 2008
    Messages:
    134
    Likes Received:
    0
    Re: Re:Kamailio + Elastix

    Hi, I did all the things you said. The install has not error, but when I am going to restart kamailio, the prompt show me:

    [root@astkam kamailio]# service kamailio restart
    Stopping kamailio: [FALLÃ]
    Iniciando kamailio:

    But when I do:

    [root@astkam kamailio]# service kamailio status
    kamailio inactivo pero subsistema bloqueado

    Could you help me?
     
  10. spd21

    Joined:
    Feb 2, 2011
    Messages:
    7
    Likes Received:
    0
    Re: Re:Kamailio + Elastix

    what is in this file:

    \kamailio-v2.tgz\kamailio-v2.tar\kamailio-freepbx.tar.gz\kamailio-freepbx.tar\kamailio\install.sh

    Can you do a

    tail -f /var/log/messages
     
  11. nmendoza

    Joined:
    Feb 28, 2011
    Messages:
    3
    Likes Received:
    0
    Re: Re:Kamailio + Elastix

    Regards... I have been working with the user ronald.garcia.d in this instalation.
    The message I see in /var/log/message is:

    Mar 3 12:31:25 astkam kamailio: WARNING: <core> [socket_info.c:896]: WARNING: f ix_hostname: could not rev. resolve 172.31.3.110
    Mar 3 12:31:25 astkam kamailio: WARNING: <core> [socket_info.c:896]: WARNING: f ix_hostname: could not rev. resolve 172.31.3.110
    Mar 3 12:31:25 astkam kamailio: INFO: <core> [tcp_main.c:4150]: init_tcp: using epoll_lt as the io watch method (auto detected)
    Mar 3 12:31:25 astkam /usr/sbin/kamailio[2729]: INFO: usrloc [hslot.c:53]: lock s array size 512
    Mar 3 12:31:25 astkam /usr/sbin/kamailio[2729]: ERROR: db_mysql [km_my_con.c:10 9]: driver error: Access denied for user 'asteriskuser'@'localhost' (using passw ord: YES)
    Mar 3 12:31:25 astkam /usr/sbin/kamailio[2729]: ERROR: <core> [db.c:289]: could not add connection to the pool
    Mar 3 12:31:25 astkam /usr/sbin/kamailio[2729]: ERROR: usrloc [dlist.c:486]: fa iled to open database connection
    Mar 3 12:31:25 astkam /usr/sbin/kamailio[2729]: ERROR: registrar [reg_mod.c:399 ]: failed to register domain
    Mar 3 12:31:25 astkam /usr/sbin/kamailio[2729]: ERROR: <core> [route.c:1026]: f ixing failed (code=-1) at cfg://etc/kamailio/kamailio.cfg:385
    Mar 3 12:31:25 astkam /usr/sbin/kamailio[2729]: ERROR: <core> [route.c:1026]: f ixing failed (code=-1) at cfg://etc/kamailio/kamailio.cfg:388
    Mar 3 12:31:25 astkam /usr/sbin/kamailio[2729]: ERROR: <core> [route.c:1026]: f ixing failed (code=-1) at cfg://etc/kamailio/kamailio.cfg:391
    Mar 3 12:32:08 astkam ntpd[1814]: synchronized to LOCAL(0), stratum 10
    Mar 3 12:32:08 astkam ntpd[1814]: kernel time sync enabled 0001

    About the file
    \kamailio-v2.tgz\kamailio-v2.tar\kamailio-freepbx.tar.gz\kamailio-freepbx.tar\kamailio\install.sh

    we use the same password "eLaStIx.asteriskuser.2oo7" in out DB...
    Could you help us..
    Thanks.
     
  12. nmendoza

    Joined:
    Feb 28, 2011
    Messages:
    3
    Likes Received:
    0
    Re: Re:Kamailio + Elastix

    Regards.
    I have been worrking with the user garcia.ronald.d in this instalation.
    About: tail -f /var/log/messages


    Mar 3 12:42:25 astkam kamailio: WARNING: <core> [socket_info.c:896]: WARNING: fix_hostname: could not rev. resolve 172.31.3.110
    Mar 3 12:42:25 astkam kamailio: WARNING: <core> [socket_info.c:896]: WARNING: fix_hostname: could not rev. resolve 172.31.3.110
    Mar 3 12:42:25 astkam kamailio: INFO: <core> [tcp_main.c:4150]: init_tcp: using epoll_lt as the io watch method (auto detected)
    Mar 3 12:42:25 astkam /usr/sbin/kamailio[2767]: INFO: usrloc [hslot.c:53]: locks array size 512
    Mar 3 12:42:25 astkam /usr/sbin/kamailio[2767]: ERROR: db_mysql [km_my_con.c:109]: driver error: Access denied for user 'asteriskuser'@'localhost' (using password: YES)
    Mar 3 12:42:25 astkam /usr/sbin/kamailio[2767]: ERROR: <core> [db.c:289]: could not add connection to the pool
    Mar 3 12:42:25 astkam /usr/sbin/kamailio[2767]: ERROR: usrloc [dlist.c:486]: failed to open database connection
    Mar 3 12:42:25 astkam /usr/sbin/kamailio[2767]: ERROR: registrar [reg_mod.c:399]: failed to register domain
    Mar 3 12:42:25 astkam /usr/sbin/kamailio[2767]: ERROR: <core> [route.c:1026]: fixing failed (code=-1) at cfg://etc/kamailio/kamailio.cfg:385
    Mar 3 12:42:25 astkam /usr/sbin/kamailio[2767]: ERROR: <core> [route.c:1026]: fixing failed (code=-1) at cfg://etc/kamailio/kamailio.cfg:388
    Mar 3 12:42:25 astkam /usr/sbin/kamailio[2767]: ERROR: <core> [route.c:1026]: fixing failed (code=-1) at cfg://etc/kamailio/kamailio.cfg:391

    and the file: \kamailio-v2.tgz\kamailio-v2.tar\kamailio-freepbx.tar.gz\kamailio-freepbx.tar\kamailio\install.sh

    We use the same password in ours DB: "eLaStIx.asteriskuser.2oo7"

    Could you help us.
    Thanks.
     
  13. garcia.ronald.d

    Joined:
    Sep 24, 2008
    Messages:
    134
    Likes Received:
    0
    Re: Re:Kamailio + Elastix

    Regards...

    About: tail -f /var/log/messages


    Mar 3 12:42:25 astkam kamailio: WARNING: <core> [socket_info.c:896]: WARNING: fix_hostname: could not rev. resolve 172.31.3.110
    Mar 3 12:42:25 astkam kamailio: WARNING: <core> [socket_info.c:896]: WARNING: fix_hostname: could not rev. resolve 172.31.3.110
    Mar 3 12:42:25 astkam kamailio: INFO: <core> [tcp_main.c:4150]: init_tcp: using epoll_lt as the io watch method (auto detected)
    Mar 3 12:42:25 astkam /usr/sbin/kamailio[2767]: INFO: usrloc [hslot.c:53]: locks array size 512
    Mar 3 12:42:25 astkam /usr/sbin/kamailio[2767]: ERROR: db_mysql [km_my_con.c:109]: driver error: Access denied for user 'asteriskuser'@'localhost' (using password: YES)
    Mar 3 12:42:25 astkam /usr/sbin/kamailio[2767]: ERROR: <core> [db.c:289]: could not add connection to the pool
    Mar 3 12:42:25 astkam /usr/sbin/kamailio[2767]: ERROR: usrloc [dlist.c:486]: failed to open database connection
    Mar 3 12:42:25 astkam /usr/sbin/kamailio[2767]: ERROR: registrar [reg_mod.c:399]: failed to register domain
    Mar 3 12:42:25 astkam /usr/sbin/kamailio[2767]: ERROR: <core> [route.c:1026]: fixing failed (code=-1) at cfg://etc/kamailio/kamailio.cfg:385
    Mar 3 12:42:25 astkam /usr/sbin/kamailio[2767]: ERROR: <core> [route.c:1026]: fixing failed (code=-1) at cfg://etc/kamailio/kamailio.cfg:388
    Mar 3 12:42:25 astkam /usr/sbin/kamailio[2767]: ERROR: <core> [route.c:1026]: fixing failed (code=-1) at cfg://etc/kamailio/kamailio.cfg:391

    and the file: \kamailio-v2.tgz\kamailio-v2.tar\kamailio-freepbx.tar.gz\kamailio-freepbx.tar\kamailio\install.sh

    We use the same password in ours DB: "eLaStIx.asteriskuser.2oo7"

    Could you help us.
    Thanks.
     
  14. fmvillares

    Joined:
    Sep 8, 2007
    Messages:
    1,785
    Likes Received:
    0
    Re: Re:Kamailio + Elastix

    that password does not exist anymore in 2.0 elastix as it is changed for the pass that you create in the initial install
     
  15. spd21

    Joined:
    Feb 2, 2011
    Messages:
    7
    Likes Received:
    0
    Try logging in to mysql with that username and password from shell
     
  16. nmendoza

    Joined:
    Feb 28, 2011
    Messages:
    3
    Likes Received:
    0
    We use this password in my initial install...
     
  17. fmvillares

    Joined:
    Sep 8, 2007
    Messages:
    1,785
    Likes Received:
    0
    then in your scripts asterisk user does not have any permissions to access other databases
    maybe u nedd to use root as db users as the log says
    Mar 3 12:42:25 astkam /usr/sbin/kamailio[2767]: ERROR: db_mysql [km_my_con.c:109]: driver error: Access denied for user 'asteriskuser'@'localhost' (using password: YES)
     
  18. fmvillares

    Joined:
    Sep 8, 2007
    Messages:
    1,785
    Likes Received:
    0
    then in your scripts asterisk user does not have any permissions to access other databases
    maybe u nedd to use root as db users as the log says
    Mar 3 12:42:25 astkam /usr/sbin/kamailio[2767]: ERROR: db_mysql [km_my_con.c:109]: driver error: Access denied for user 'asteriskuser'@'localhost' (using password: YES)
     

Share This Page