Dear All,
Please help me with error messages.
Am trying to configure kamailio MYSQL as DBEGINE base on the tutorial available in the SIP ROUTING WITH KAMAILIO book, when I executed the /usr/local/sbin/kamdbctl create and got the Error messages below.
ERROR: could not load the script in /usr/local/lib64/kamailio//kamctl/kamdbctl.mysql for database engine MYSQL
ERROR: database engine not loaded - tried 'MYSQL'
Here this the version of kamailio I installed.
./kamailio -I.
Print out of kamailio internals
Version: kamailio 4.4.6 (x86_64/linux) 75f13d
Default config: /usr/local/etc/kamailio/kamailio.cfg
Default paths to modules: /usr/local/lib64/kamailio/modules
Compile flags: STATS: Off, USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, 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
MAX_RECV_BUFFER_SIZE=262144
MAX_LISTEN=16
MAX_URI_SIZE=1024
BUF_SIZE=65535
DEFAULT PKG_SIZE=8MB
DEFAULT SHM_SIZE=64MB
ADAPTIVE_WAIT_LOOPS=1024
TCP poll methods: poll, epoll_lt, epoll_et, sigio_rt, select
Source code revision ID: 75f13d
Compiled with: gcc 4.9.2
Compiled on: 10:56:51 Sep 28 2017
Thank you for flying kamailio!
Regards
Olawuyi Timothy Oladapo | IT/VAS Operation | Information System Dept |Pethahiah Rehoboth INTL. Limited | 2nd Floor Rubby Block All seasons Plaza , Lateef Jakande Rd, Agidingbi, Ikeja, Lagos. | Mobile: +2348052612001,+2348098797928 |Skype: daptims | htttp://www.pethahiah.com/ htttp://www.pethahiah.com
Use The below steps to install mysql and create database:
1) yum install mariadb-server mariadb 2) systemctl start mariadb.service 3) systemctl enable mariadb.service 4) mysql
5) nano -w /usr/local/etc/kamailio/kamctlrc 6) DBENGINE=MYSQL 7) /usr/local/sbin/kamdbctl create
Thanks & Kind Regards, *Logeshwaran G*
*"Be Hungry, Stay Foolish"*
On Thu, Sep 28, 2017 at 3:56 PM, Timothy oladapo olawuyi < dolawuyi@pethahiah.com> wrote:
Make sure the kamctl files exist there as in the path in can’t locate if not copy them from I believe src/Uriel/kamctl to the desired path it is looking for and or symlink.
On Thu, Sep 28, 2017 at 3:27 AM Timothy oladapo olawuyi < dolawuyi@pethahiah.com> wrote:
src/utils/kamctl
On Thu, Sep 28, 2017 at 4:06 AM Brandon Armstead brandon@cryy.com wrote:
Hello Brandon,
Thank for you the quick response I found the file and copy to the appropriate directory.
However, when kamdbctl create again I got the error below.
/usr/local/lib64/kamailio//kamctl/kamdbctl.mysql: line 264: ./mysql/standard-create.sql: No such file or directory
ERROR: Creating core tables failed at standard!
Regards
Olawuyi Timothy Oladapo | IT/VAS Operation | Information System Dept |Pethahiah Rehoboth INTL. Limited | 2nd Floor Rubby Block All seasons Plaza , Lateef Jakande Rd, Agidingbi, Ikeja, Lagos. | Mobile: +2348052612001,+2348098797928 |Skype: daptims | htttp://www.pethahiah.com htttp://www.pethahiah.com/
From: sr-users [mailto:sr-users-bounces@lists.kamailio.org] On Behalf Of Brandon Armstead Sent: Thursday, September 28, 2017 12:07 PM To: Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Subject: Re: [SR-Users] mysql installation error
src/utils/kamctl
On Thu, Sep 28, 2017 at 4:06 AM Brandon Armstead <brandon@cryy.com mailto:brandon@cryy.com > wrote:
Make sure the kamctl files exist there as in the path in can’t locate if not copy them from I believe src/Uriel/kamctl to the desired path it is looking for and or symlink.
On Thu, Sep 28, 2017 at 3:27 AM Timothy oladapo olawuyi <dolawuyi@pethahiah.com mailto:dolawuyi@pethahiah.com > wrote:
Dear All,
Please help me with error messages.
Am trying to configure kamailio MYSQL as DBEGINE base on the tutorial available in the SIP ROUTING WITH KAMAILIO book, when I executed the /usr/local/sbin/kamdbctl create and got the Error messages below.
ERROR: could not load the script in /usr/local/lib64/kamailio//kamctl/kamdbctl.mysql for database engine MYSQL
ERROR: database engine not loaded - tried 'MYSQL'
Here this the version of kamailio I installed.
./kamailio -I.
Print out of kamailio internals
Version: kamailio 4.4.6 (x86_64/linux) 75f13d
Default config: /usr/local/etc/kamailio/kamailio.cfg
Default paths to modules: /usr/local/lib64/kamailio/modules
Compile flags: STATS: Off, USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, 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
MAX_RECV_BUFFER_SIZE=262144
MAX_LISTEN=16
MAX_URI_SIZE=1024
BUF_SIZE=65535
DEFAULT PKG_SIZE=8MB
DEFAULT SHM_SIZE=64MB
ADAPTIVE_WAIT_LOOPS=1024
TCP poll methods: poll, epoll_lt, epoll_et, sigio_rt, select
Source code revision ID: 75f13d
Compiled with: gcc 4.9.2
Compiled on: 10:56:51 Sep 28 2017
Thank you for flying kamailio!
Regards
Olawuyi Timothy Oladapo | IT/VAS Operation | Information System Dept |Pethahiah Rehoboth INTL. Limited | 2nd Floor Rubby Block All seasons Plaza , Lateef Jakande Rd, Agidingbi, Ikeja, Lagos. | Mobile: +2348052612001,+2348098797928 |Skype: daptims | htttp://www.pethahiah.com
_______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org mailto:sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
I would copy all of the kamctl files over not sure why entirely but I think there is s bug in the build process or maybe user error but I’ve ran into this issue before too and just cp -fr the kamctl dir over of course after backing up original.
On Thu, Sep 28, 2017 at 5:42 AM Timothy oladapo olawuyi < dolawuyi@pethahiah.com> wrote:
I believe if you also run this kamdbctl relatively inside the current contextual path it may also give you a pass - don’t quote me on this, writing from los angelos at 6am in bed :/ tossing and turning haha.
But a let’s say you git checkout to /use/local/src/kamailio
cp -fr {path to src kamctl dir under used local src} /usr/local/lib64/kamailio/kamctl essentially iirc.
On Thu, Sep 28, 2017 at 6:00 AM Brandon Armstead brandon@cryy.com wrote:
Hello Brandon,
Sorry for disturbing your sleep
I just copy mysql dir that contains standard-create.sql and other files to kamctl using cp -fr /usr/local/src/kamailio/utils/kamctl/mysql /usr/local/lib64/kamailio//kamctl/mysql
I still got the same error /usr/local/lib64/kamailio//kamctl/kamdbctl.mysql: line 264: ./mysql/standard-create.sql: No such file or directory , ERROR: Creating core tables failed at standard!
after the copied the folder. It seems am missing something.
Regards
Olawuyi Timothy Oladapo | IT/VAS Operation | Information System Dept |Pethahiah Rehoboth INTL. Limited | 2nd Floor Rubby Block All seasons Plaza , Lateef Jakande Rd, Agidingbi, Ikeja, Lagos. | Mobile: +2348052612001,+2348098797928 |Skype: daptims | htttp://www.pethahiah.com htttp://www.pethahiah.com/
From: sr-users [mailto:sr-users-bounces@lists.kamailio.org] On Behalf Of Brandon Armstead Sent: Thursday, September 28, 2017 2:08 PM To: Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Subject: Re: [SR-Users] mysql installation error
I believe if you also run this kamdbctl relatively inside the current contextual path it may also give you a pass - don’t quote me on this, writing from los angelos at 6am in bed :/ tossing and turning haha.
But a let’s say you git checkout to /use/local/src/kamailio
cp -fr {path to src kamctl dir under used local src} /usr/local/lib64/kamailio/kamctl essentially iirc.
On Thu, Sep 28, 2017 at 6:00 AM Brandon Armstead <brandon@cryy.com mailto:brandon@cryy.com > wrote:
I would copy all of the kamctl files over not sure why entirely but I think there is s bug in the build process or maybe user error but I’ve ran into this issue before too and just cp -fr the kamctl dir over of course after backing up original.
On Thu, Sep 28, 2017 at 5:42 AM Timothy oladapo olawuyi <dolawuyi@pethahiah.com mailto:dolawuyi@pethahiah.com > wrote:
Hello Brandon,
Thank for you the quick response I found the file and copy to the appropriate directory.
However, when kamdbctl create again I got the error below.
Regards
Olawuyi Timothy Oladapo | IT/VAS Operation | Information System Dept |Pethahiah Rehoboth INTL. Limited | 2nd Floor Rubby Block All seasons Plaza , Lateef Jakande Rd, Agidingbi, Ikeja, Lagos. | Mobile: +2348052612001,+2348098797928 |Skype: daptims | htttp://www.pethahiah.com
From: sr-users [mailto:sr-users-bounces@lists.kamailio.org mailto:sr-users-bounces@lists.kamailio.org ] On Behalf Of Brandon Armstead Sent: Thursday, September 28, 2017 12:07 PM To: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org mailto:sr-users@lists.kamailio.org > Subject: Re: [SR-Users] mysql installation error
src/utils/kamctl
On Thu, Sep 28, 2017 at 4:06 AM Brandon Armstead <brandon@cryy.com mailto:brandon@cryy.com > wrote:
Make sure the kamctl files exist there as in the path in can’t locate if not copy them from I believe src/Uriel/kamctl to the desired path it is looking for and or symlink.
On Thu, Sep 28, 2017 at 3:27 AM Timothy oladapo olawuyi <dolawuyi@pethahiah.com mailto:dolawuyi@pethahiah.com > wrote:
Dear All,
Please help me with error messages.
Am trying to configure kamailio MYSQL as DBEGINE base on the tutorial available in the SIP ROUTING WITH KAMAILIO book, when I executed the /usr/local/sbin/kamdbctl create and got the Error messages below.
ERROR: could not load the script in /usr/local/lib64/kamailio//kamctl/kamdbctl.mysql for database engine MYSQL
ERROR: database engine not loaded - tried 'MYSQL'
Here this the version of kamailio I installed.
./kamailio -I.
Print out of kamailio internals
Version: kamailio 4.4.6 (x86_64/linux) 75f13d
Default config: /usr/local/etc/kamailio/kamailio.cfg
Default paths to modules: /usr/local/lib64/kamailio/modules
Compile flags: STATS: Off, USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, 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
MAX_RECV_BUFFER_SIZE=262144
MAX_LISTEN=16
MAX_URI_SIZE=1024
BUF_SIZE=65535
DEFAULT PKG_SIZE=8MB
DEFAULT SHM_SIZE=64MB
ADAPTIVE_WAIT_LOOPS=1024
TCP poll methods: poll, epoll_lt, epoll_et, sigio_rt, select
Source code revision ID: 75f13d
Compiled with: gcc 4.9.2
Compiled on: 10:56:51 Sep 28 2017
Thank you for flying kamailio!
Regards
Olawuyi Timothy Oladapo | IT/VAS Operation | Information System Dept |Pethahiah Rehoboth INTL. Limited | 2nd Floor Rubby Block All seasons Plaza , Lateef Jakande Rd, Agidingbi, Ikeja, Lagos. | Mobile: +2348052612001,+2348098797928 |Skype: daptims | htttp://www.pethahiah.com http://www.pethahiah.com
_______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org mailto:sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Hello Brandon,
It works after copied mysql directory from /usr/local/src/kamailio/utils/kamctl/mysql to /usr/local/share/kamailio/mysql with cp -fr /usr/local/src/kamailio/utils/kamctl/mysql /usr/local/share/kamailio/mysql
Regards
Olawuyi Timothy Oladapo | IT/VAS Operation | Information System Dept |Pethahiah Rehoboth INTL. Limited | 2nd Floor Rubby Block All seasons Plaza , Lateef Jakande Rd, Agidingbi, Ikeja, Lagos. | Mobile: +2348052612001,+2348098797928 |Skype: daptims | htttp://www.pethahiah.com htttp://www.pethahiah.com/
From: sr-users [mailto:sr-users-bounces@lists.kamailio.org] On Behalf Of Timothy oladapo olawuyi Sent: Thursday, September 28, 2017 2:58 PM To: 'Kamailio (SER) - Users Mailing List' sr-users@lists.kamailio.org Subject: Re: [SR-Users] mysql installation error
Hello Brandon,
Sorry for disturbing your sleep
I just copy mysql dir that contains standard-create.sql and other files to kamctl using cp -fr /usr/local/src/kamailio/utils/kamctl/mysql /usr/local/lib64/kamailio//kamctl/mysql
I still got the same error /usr/local/lib64/kamailio//kamctl/kamdbctl.mysql: line 264: ./mysql/standard-create.sql: No such file or directory , ERROR: Creating core tables failed at standard!
after the copied the folder. It seems am missing something.
Regards
Olawuyi Timothy Oladapo | IT/VAS Operation | Information System Dept |Pethahiah Rehoboth INTL. Limited | 2nd Floor Rubby Block All seasons Plaza , Lateef Jakande Rd, Agidingbi, Ikeja, Lagos. | Mobile: +2348052612001,+2348098797928 |Skype: daptims | htttp://www.pethahiah.com htttp://www.pethahiah.com/
From: sr-users [mailto:sr-users-bounces@lists.kamailio.org] On Behalf Of Brandon Armstead Sent: Thursday, September 28, 2017 2:08 PM To: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org mailto:sr-users@lists.kamailio.org > Subject: Re: [SR-Users] mysql installation error
I believe if you also run this kamdbctl relatively inside the current contextual path it may also give you a pass - don’t quote me on this, writing from los angelos at 6am in bed :/ tossing and turning haha.
But a let’s say you git checkout to /use/local/src/kamailio
cp -fr {path to src kamctl dir under used local src} /usr/local/lib64/kamailio/kamctl essentially iirc.
On Thu, Sep 28, 2017 at 6:00 AM Brandon Armstead <brandon@cryy.com mailto:brandon@cryy.com > wrote:
I would copy all of the kamctl files over not sure why entirely but I think there is s bug in the build process or maybe user error but I’ve ran into this issue before too and just cp -fr the kamctl dir over of course after backing up original.
On Thu, Sep 28, 2017 at 5:42 AM Timothy oladapo olawuyi <dolawuyi@pethahiah.com mailto:dolawuyi@pethahiah.com > wrote:
Hello Brandon,
Thank for you the quick response I found the file and copy to the appropriate directory.
However, when kamdbctl create again I got the error below.
Regards
Olawuyi Timothy Oladapo | IT/VAS Operation | Information System Dept |Pethahiah Rehoboth INTL. Limited | 2nd Floor Rubby Block All seasons Plaza , Lateef Jakande Rd, Agidingbi, Ikeja, Lagos. | Mobile: +2348052612001,+2348098797928 |Skype: daptims | htttp://www.pethahiah.com
From: sr-users [mailto:sr-users-bounces@lists.kamailio.org mailto:sr-users-bounces@lists.kamailio.org ] On Behalf Of Brandon Armstead Sent: Thursday, September 28, 2017 12:07 PM To: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org mailto:sr-users@lists.kamailio.org > Subject: Re: [SR-Users] mysql installation error
src/utils/kamctl
On Thu, Sep 28, 2017 at 4:06 AM Brandon Armstead <brandon@cryy.com mailto:brandon@cryy.com > wrote:
Make sure the kamctl files exist there as in the path in can’t locate if not copy them from I believe src/Uriel/kamctl to the desired path it is looking for and or symlink.
On Thu, Sep 28, 2017 at 3:27 AM Timothy oladapo olawuyi <dolawuyi@pethahiah.com mailto:dolawuyi@pethahiah.com > wrote:
Dear All,
Please help me with error messages.
Am trying to configure kamailio MYSQL as DBEGINE base on the tutorial available in the SIP ROUTING WITH KAMAILIO book, when I executed the /usr/local/sbin/kamdbctl create and got the Error messages below.
ERROR: could not load the script in /usr/local/lib64/kamailio//kamctl/kamdbctl.mysql for database engine MYSQL
ERROR: database engine not loaded - tried 'MYSQL'
Here this the version of kamailio I installed.
./kamailio -I.
Print out of kamailio internals
Version: kamailio 4.4.6 (x86_64/linux) 75f13d
Default config: /usr/local/etc/kamailio/kamailio.cfg
Default paths to modules: /usr/local/lib64/kamailio/modules
Compile flags: STATS: Off, USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, 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
MAX_RECV_BUFFER_SIZE=262144
MAX_LISTEN=16
MAX_URI_SIZE=1024
BUF_SIZE=65535
DEFAULT PKG_SIZE=8MB
DEFAULT SHM_SIZE=64MB
ADAPTIVE_WAIT_LOOPS=1024
TCP poll methods: poll, epoll_lt, epoll_et, sigio_rt, select
Source code revision ID: 75f13d
Compiled with: gcc 4.9.2
Compiled on: 10:56:51 Sep 28 2017
Thank you for flying kamailio!
Regards
Olawuyi Timothy Oladapo | IT/VAS Operation | Information System Dept |Pethahiah Rehoboth INTL. Limited | 2nd Floor Rubby Block All seasons Plaza , Lateef Jakande Rd, Agidingbi, Ikeja, Lagos. | Mobile: +2348052612001,+2348098797928 |Skype: daptims | htttp://www.pethahiah.com http://www.pethahiah.com
_______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org mailto:sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
-
Brandon Armstead -
Logeshwaran G -
Timothy oladapo olawuyi