Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Help Installing Homer5 #108

Closed
kismetgerald opened this issue Nov 10, 2015 · 33 comments
Closed

Help Installing Homer5 #108

kismetgerald opened this issue Nov 10, 2015 · 33 comments

Comments

@kismetgerald
Copy link

Hello,

I'm a newbie to Linux but a quick learner, and I'm interested in installing Homer5 on a fresh Debian 8 server. I have followed your Quick Install instructions but with the Automated Install, your site says it's a work in progress and I can confirm that after the repo is setup, I cannot find any Homer packages to install with "apt-cache search homer".

Secondly, I then try to build the package with your Build Custom Packages section. There I get stuck after running "make debian-jessie-x86_64.homer.deb". The result of this is a series of files dumped into /usr/src/homer/build/ which include several .deb files but none with the name "debian-jessie-x86_64.homer.deb". So right now I'm confused as to how to proceed further and could use some help and direction.

I saw your demo on Youtube and really would love to try it out to see if I can use this in a setup I'm putting together for a ITSP business I hope to start. Thanks.

@kismetgerald kismetgerald changed the title Help Installing Home5 Help Installing Homer5 Nov 10, 2015
@lmangani
Copy link
Member

Hi @kismetgerald
First of all apologies, this is a realtime work-in-progress and shortly the packages will be released.
Right now, you need to install all the build packages based on your needs or use the manual process.

@kismetgerald
Copy link
Author

Thanks Imangani.

I got some help from gmaruzz on the Freeswitch IRC channel - he instructed me to run "dpkg -i *deb" while in the /usr/src/homer/build/ directory. I did that, but run in to some dependency issues. But on the CLI there was a message displayed to run "apt-get -f install". Not sure what that does exactly, but I ran that and the install worked fine.

It didn't, however, install Apache or Nginx, so I had to install that manually. Anyway, I've been able to get the web page working, now I'm working on the backend database scripts.

@lmangani
Copy link
Member

Kris, all you should have left to do is configure the web server w/ proper settings, db connection and the rotation scripts.

@kismetgerald
Copy link
Author

Yes sir, that's what I'm doing now.

@kismetgerald
Copy link
Author

You'll be glad to know that I got the web interface working and the connecting to MySQL. I am able to login with the test user. Now, trying to figure out how to configure the capturing.

@kismetgerald
Copy link
Author

Unfortunately, it appears I have hit a stalemate. I'm getting the following error after copying the example kamailio.cfg file:

Nov 10 15:20:20 freeswitch2 kamailio[1984]: 0(1995) ERROR: [sr_module.c:565]: load_module(): could not find module in </usr/lib64/kamailio/modules> 0(1995) : [cfg.y:3432]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 39, column 12-18: failed to load module 0(1995) ERROR: [sr_module.c:565]: load_module(): could not find module <db_mysql> in </usr/lib64/kamailio/modules> 0(1995) : [cfg.y:3432]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 40, column 12-24: failed to load module 0(1995) ERROR: [sr_module.c:565]: load_module(): could not find module in </usr/lib64/kamailio/modules> 0(1995) : [cfg.y:3432]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 41, column 12-26: failed to load module 0(1995) ERROR: [sr_module.c:565]: load_module(): could not find module in </usr/lib64/kamailio/modules> 0(1995) : [cfg.y:3432]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 42, column 12-23: failed to load module 0(1995) ERROR: [sr_module.c:565]: load_module(): could not find module in </usr/lib64/kamailio/modules> 0(1995) : [cfg.y:3432]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 43, column 12-22: failed to load module 0(1995) ERROR: [sr_module.c:565]: load_module(): could not find module in </usr/lib64/kamailio/modules> 0(1995) : [cfg.y:3432]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 44, column 12-20: failed to load module 0(1995) ERROR: [sr_module.c:565]: load_module(): could not find module in </usr/lib64/kamailio/modules> 0(1995) : [cfg.y:3432]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 45, column 12-22: failed to load module 0(1995) ERROR: [sr_module.c:565]: load_module(): could not find module in </usr/lib64/kamailio/modules> 0(1995) : [cfg.y:3432]: yyerror_at(): parse error in config file
Nov 10 15:20:20 freeswitch2 kamailio[1984]: /etc/kamailio/kamailio.cfg, line 46, column 12-22: failed to load module 0(1995) ERROR: [sr_module.c:565]: load_module(): could not find module in </usr/lib64/kamailio/modules> 0(1995) : [cfg.y:3432]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 47, column 12-18: failed to load module 0(1995) ERROR: [sr_module.c:565]: load_module(): could not find module in </usr/lib64/kamailio/modules> 0(1995) : [cfg.y:3432]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 48, column 12-18: failed to load module 0(1995) ERROR: [sr_module.c:565]: load_module(): could not find module in </usr/lib64/kamailio/modules> 0(1995) : [cfg.y:3432]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 49, column 12-24: failed to load module 0(1995) ERROR: [sr_module.c:565]: load_module(): could not find module in </usr/lib64/kamailio/modules> 0(1995) : [cfg.y:3432]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 50, column 12-20: failed to load module 0(1995) ERROR: [modparam.c:150]: set_mod_param_regex(): No module matching found 0(1995) : [cfg.y:3435]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 53, column 56: Can't set module parameter 0(1995) ERROR: [modparam.c:150]: set_mod_param_regex(): No module matching found 0(1995) : [cfg.y:3435]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 54, column 55: Can't set module parameter 0(1995) ERROR: [modparam.c:150]: set_mod_param_regex(): No module matching found 0(1995) : [cfg.y:3435]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 56, column 55: Can't set module parameter 0(1995) ERROR: [modparam.c:150]: set_mod_param_regex(): No module matching found 0(1995) : [cfg.y:3435]: yyerror_at(): parse error in config file /etc/kamailio/kamailio

@kismetgerald
Copy link
Author

Okay, so I had to change quite a bit of the hard coded paths inside most of the config files.............but Kamailio is now running on the Homer5 server, listening on port 9060. Now, can you offer some assistance on how to setup a Captagent on my Freeswitch server to send the sip capture to Homer5?

@kismetgerald
Copy link
Author

I was able to find instructions here https://github.com/sipcapture/captagent. I followed it and Captagent seems to be installed and running as a Daemon on my Freeswitch server. However, I'm seeing the following error in syslog:

Nov 11 01:51:52 freeswitch1 captagent[31991]: [ERR] core_hep.c:535 send error

@lmangani
Copy link
Member

@kismetgerald this usually means there is no HEP server listening. Make sure the HEP port is correct in your client configuration.

@adubovikov
Copy link
Member

or maybe there is a firewall issue

@kismetgerald
Copy link
Author

@adubovikov This is a fresh Debian box, and I haven't made any modifications to the Firewall, so do you still think it could be FW related?

@lmangani If I provided the various config files here, could you tell me if any is wrong?

@lmangani
Copy link
Member

Error logs on the server should tell the story. Check your syslog and let us know what Kamailio says.

@kismetgerald
Copy link
Author

@lmangani As far as Kamailio is concerned, everything is peachy...lol.

Nov 11 09:53:51 freeswitch2 /usr/local/sbin/kamailio[10609]: NOTICE: [main.c:693]: handle_sigs(): Thank you for flying kamailio!!!
Nov 11 09:53:51 freeswitch2 kamailio[10651]: Stopping Kamailio SIP Server: kamailio:.
Nov 11 09:53:51 freeswitch2 kamailio[10661]: Starting Kamailio SIP Server: kamailio:Listening on
Nov 11 09:53:51 freeswitch2 kamailio[10661]: udp: localhost:9060
Nov 11 09:53:51 freeswitch2 kamailio[10661]: Aliases:
Nov 11 09:53:51 freeswitch2 kamailio[10661]: .

@kismetgerald
Copy link
Author

I've been doing some more reading on your Git pages and just discovered that Freeswitch ships with built-in support to capturing. So, I think I'm going to abandon the idea of setting up Captagent and instead use the built-in capability of FS.

Now, I'm using FusionPBX as my GUI for Freeswitch and I know it's not recommended to edit the xml files directly. So I have to figure out how to set the global parameters from the FPBX gui. I'll report back what I'm able to accomplish. If you know of how I can do this, please share.

Thanks.

@lmangani
Copy link
Member

@kismetgerald be warned the built-in capture agent in FS supports an older version of the HEP protocol with reduced features. A capture agent is still highly suggested, expecially since you are using a packaged version of FS where this would result in unsupported conditions.

@kismetgerald
Copy link
Author

@lmangani You might be right. I was able to find the commented parameter in sofia.xml and uncomented it. However, as soon as I turned on sip-capture on the internal profile, my CLI went bonkers............

I guess I'm back to getting Captagent to work eh? Anyway, so if using the built-in capturing isn't supported then why do you recommend it on your Wiki?

Anyway, I'm still going to need help getting Captagent to work then. Any ideas where to go next?

@lmangani
Copy link
Member

@kismetgerald As you might have noticed, the wiki home states we are updating the whole codebase to the latest homer, consequently some pages are obsoleted - as far as the FS capture agent, its scheduled to be upgraded in the coming months to HEP3 but Captagent remains superior in terms of flexibility and latest features and definitely suggested for packaged distributions

@kismetgerald
Copy link
Author

@lmangani Yes sir, I did notice that you guys are working hard at bringing your Wiki up-to-date, and I in no way was criticizing that. Please accept my apologies if that's the message that came across.

@lmangani
Copy link
Member

quite the opposite, thanks for helping us track priorities here and let us know how you progress - we count releasing the fully updated documentation and working packages in the coming weeks to solve this all

@kismetgerald
Copy link
Author

@lmangani Awesome!

I'm still struggling getting Captagent to send packets over to Homer5, so any assistance would be highly appreciated. I can share all the relevant config files with you if you can tell me which ones you need to see to confirm that I have my settings correct.

As I mentioned earlier, I don't suspect a firewall issue as this is a clean install of Debian 8 and I haven't made any modifications at all to IPTables.

@lmangani
Copy link
Member

ngrep on both sender and receiver UDP port 9060 and check if you see any packets out/in to begin with. Also make sure Kamailio is listening to the public interface ;)

@kismetgerald
Copy link
Author

@lmangani Unfortunately, I am not seeing any traffic traversing both servers on ports 9060.

@lmangani
Copy link
Member

As @adubovikov pointed out a firewall is likely in place on the system running captagent

@kismetgerald
Copy link
Author

@lmangani Yes, on the system running the Captagent (which is my Freeswitch server) there is a firewall in place. I'm guessing I need to see if port 9060 is being blocked. Will check and advice.

@kismetgerald
Copy link
Author

I'm trying to setup the cronjob and I'm at the point where you instruct to manually run the homer_rotate script. Doing so gives the following errors - can you help please?

root@freeswitch2:~# cd /opt/sipcapture/
root@freeswitch2:/opt/sipcapture# ./homer_rotate
Can't locate DBI.pm in @inc (you may need to install the DBI module) (@inc contains: /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.20.2 /usr/local/share/perl/5.20.2 /usr/lib/x86_64-linux-gnu/perl5/5.20 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20 /usr/share/perl/5.20 /usr/local/lib/site_perl .) at ./homer_mysql_new_table.pl line 23.
BEGIN failed--compilation aborted at ./homer_mysql_new_table.pl line 23.
Can't locate DBI.pm in @inc (you may need to install the DBI module) (@inc contains: /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.20.2 /usr/local/share/perl/5.20.2 /usr/lib/x86_64-linux-gnu/perl5/5.20 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20 /usr/share/perl/5.20 /usr/local/lib/site_perl .) at ./homer_mysql_partrotate_unixtimestamp.pl line 23.
BEGIN failed--compilation aborted at ./homer_mysql_partrotate_unixtimestamp.pl line 23.
Can't locate DBI.pm in @inc (you may need to install the DBI module) (@inc contains: /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.20.2 /usr/local/share/perl/5.20.2 /usr/lib/x86_64-linux-gnu/perl5/5.20 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20 /usr/share/perl/5.20 /usr/local/lib/site_perl .) at ./homer_mysql_partrotate_unixtimestamp.pl line 23.
BEGIN failed--compilation aborted at ./homer_mysql_partrotate_unixtimestamp.pl line 23.
Can't locate DBI.pm in @inc (you may need to install the DBI module) (@inc contains: /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.20.2 /usr/local/share/perl/5.20.2 /usr/lib/x86_64-linux-gnu/perl5/5.20 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20 /usr/share/perl/5.20 /usr/local/lib/site_perl .) at ./homer_mysql_partrotate_unixtimestamp.pl line 23.
BEGIN failed--compilation aborted at ./homer_mysql_partrotate_unixtimestamp.pl line 23.
Can't locate DBI.pm in @inc (you may need to install the DBI module) (@inc contains: /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.20.2 /usr/local/share/perl/5.20.2 /usr/lib/x86_64-linux-gnu/perl5/5.20 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20 /usr/share/perl/5.20 /usr/local/lib/site_perl .) at ./homer_mysql_partrotate_unixtimestamp.pl line 23.
BEGIN failed--compilation aborted at ./homer_mysql_partrotate_unixtimestamp.pl line 23.
Can't locate DBI.pm in @inc (you may need to install the DBI module) (@inc contains: /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.20.2 /usr/local/share/perl/5.20.2 /usr/lib/x86_64-linux-gnu/perl5/5.20 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20 /usr/share/perl/5.20 /usr/local/lib/site_perl .) at ./homer_mysql_partrotate_unixtimestamp.pl line 23.
BEGIN failed--compilation aborted at ./homer_mysql_partrotate_unixtimestamp.pl line 23.
Can't locate DBI.pm in @inc (you may need to install the DBI module) (@inc contains: /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.20.2 /usr/local/share/perl/5.20.2 /usr/lib/x86_64-linux-gnu/perl5/5.20 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20 /usr/share/perl/5.20 /usr/local/lib/site_perl .) at ./homer_mysql_partrotate_unixtimestamp.pl line 23.
BEGIN failed--compilation aborted at ./homer_mysql_partrotate_unixtimestamp.pl line 23.
Can't locate DBI.pm in @inc (you may need to install the DBI module) (@inc contains: /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.20.2 /usr/local/share/perl/5.20.2 /usr/lib/x86_64-linux-gnu/perl5/5.20 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20 /usr/share/perl/5.20 /usr/local/lib/site_perl .) at ./homer_mysql_partrotate_unixtimestamp.pl line 23.
BEGIN failed--compilation aborted at ./homer_mysql_partrotate_unixtimestamp.pl line 23.
Can't locate DBI.pm in @inc (you may need to install the DBI module) (@inc contains: /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.20.2 /usr/local/share/perl/5.20.2 /usr/lib/x86_64-linux-gnu/perl5/5.20 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20 /usr/share/perl/5.20 /usr/local/lib/site_perl .) at ./homer_mysql_partrotate_unixtimestamp.pl line 23.
BEGIN failed--compilation aborted at ./homer_mysql_partrotate_unixtimestamp.pl line 23.
Warning: Using a password on the command line interface can be insecure.
root@freeswitch2:/opt/sipcapture#

@adubovikov
Copy link
Member

you have to install perl DBI

On 12 November 2015 at 21:55, kismetgerald notifications@github.com wrote:

I'm trying to setup the cronjob and I'm at the point where you instruct to
manually run the homer_rotate script. Doing so gives the following errors -
can you help please?

root@freeswitch2:~# cd /opt/sipcapture/
root@freeswitch2:/opt/sipcapture# ./homer_rotate
Can't locate DBI.pm in @inc https://github.com/INC (you may need to
install the DBI module) (@inc https://github.com/INC contains:
/etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.20.2
/usr/local/share/perl/5.20.2 /usr/lib/x86_64-linux-gnu/perl5/5.20
/usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20 /usr/share/perl/5.20
/usr/local/lib/site_perl .) at ./homer_mysql_new_table.pl line 23.
BEGIN failed--compilation aborted at ./homer_mysql_new_table.pl line 23.
Can't locate DBI.pm in @inc https://github.com/INC (you may need to
install the DBI module) (@inc https://github.com/INC contains:
/etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.20.2
/usr/local/share/perl/5.20.2 /usr/lib/x86_64-linux-gnu/perl5/5.20
/usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20 /usr/share/perl/5.20
/usr/local/lib/site_perl .) at ./homer_mysql_partrotate_unixtimestamp.pl
line 23.
BEGIN failed--compilation aborted at ./
homer_mysql_partrotate_unixtimestamp.pl line 23.
Can't locate DBI.pm in @inc https://github.com/INC (you may need to
install the DBI module) (@inc https://github.com/INC contains:
/etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.20.2
/usr/local/share/perl/5.20.2 /usr/lib/x86_64-linux-gnu/perl5/5.20
/usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20 /usr/share/perl/5.20
/usr/local/lib/site_perl .) at ./homer_mysql_partrotate_unixtimestamp.pl
line 23.
BEGIN failed--compilation aborted at ./
homer_mysql_partrotate_unixtimestamp.pl line 23.
Can't locate DBI.pm in @inc https://github.com/INC (you may need to
install the DBI module) (@inc https://github.com/INC contains:
/etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.20.2
/usr/local/share/perl/5.20.2 /usr/lib/x86_64-linux-gnu/perl5/5.20
/usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20 /usr/share/perl/5.20
/usr/local/lib/site_perl .) at ./homer_mysql_partrotate_unixtimestamp.pl
line 23.
BEGIN failed--compilation aborted at ./
homer_mysql_partrotate_unixtimestamp.pl line 23.
Can't locate DBI.pm in @inc https://github.com/INC (you may need to
install the DBI module) (@inc https://github.com/INC contains:
/etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.20.2
/usr/local/share/perl/5.20.2 /usr/lib/x86_64-linux-gnu/perl5/5.20
/usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20 /usr/share/perl/5.20
/usr/local/lib/site_perl .) at ./homer_mysql_partrotate_unixtimestamp.pl
line 23.
BEGIN failed--compilation aborted at ./
homer_mysql_partrotate_unixtimestamp.pl line 23.
Can't locate DBI.pm in @inc https://github.com/INC (you may need to
install the DBI module) (@inc https://github.com/INC contains:
/etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.20.2
/usr/local/share/perl/5.20.2 /usr/lib/x86_64-linux-gnu/perl5/5.20
/usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20 /usr/share/perl/5.20
/usr/local/lib/site_perl .) at ./homer_mysql_partrotate_unixtimestamp.pl
line 23.
BEGIN failed--compilation aborted at ./
homer_mysql_partrotate_unixtimestamp.pl line 23.
Can't locate DBI.pm in @inc https://github.com/INC (you may need to
install the DBI module) (@inc https://github.com/INC contains:
/etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.20.2
/usr/local/share/perl/5.20.2 /usr/lib/x86_64-linux-gnu/perl5/5.20
/usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20 /usr/share/perl/5.20
/usr/local/lib/site_perl .) at ./homer_mysql_partrotate_unixtimestamp.pl
line 23.
BEGIN failed--compilation aborted at ./
homer_mysql_partrotate_unixtimestamp.pl line 23.
Can't locate DBI.pm in @inc https://github.com/INC (you may need to
install the DBI module) (@inc https://github.com/INC contains:
/etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.20.2
/usr/local/share/perl/5.20.2 /usr/lib/x86_64-linux-gnu/perl5/5.20
/usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20 /usr/share/perl/5.20
/usr/local/lib/site_perl .) at ./homer_mysql_partrotate_unixtimestamp.pl
line 23.
BEGIN failed--compilation aborted at ./
homer_mysql_partrotate_unixtimestamp.pl line 23.
Can't locate DBI.pm in @inc https://github.com/INC (you may need to
install the DBI module) (@inc https://github.com/INC contains:
/etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.20.2
/usr/local/share/perl/5.20.2 /usr/lib/x86_64-linux-gnu/perl5/5.20
/usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20 /usr/share/perl/5.20
/usr/local/lib/site_perl .) at ./homer_mysql_partrotate_unixtimestamp.pl
line 23.
BEGIN failed--compilation aborted at ./
homer_mysql_partrotate_unixtimestamp.pl line 23.
Warning: Using a password on the command line interface can be insecure.
root@freeswitch2:/opt/sipcapture#


Reply to this email directly or view it on GitHub
#108 (comment).

@kismetgerald
Copy link
Author

@adubovikov

Thanks - I did "apt-get install libdbi-perl" after Google'ing around on how to install perl DBI. The install was successful, but running the rotate script yielded another error. I have to run and catch my train now, but I'll search online how to install the missing mysql.pm driver - but any help from you would be appreciated:

install_driver(mysql) failed: Can't locate DBD/mysql.pm in @inc (you may need to install the DBD::mysql module) (@inc contains: /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.20.2 /usr/local/share/perl/5.20.2 /usr/lib/x86_64-linux-gnu/perl5/5.20 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20 /usr/share/perl/5.20 /usr/local/lib/site_perl .) at (eval 6) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge.
at ./homer_mysql_new_table.pl line 118.
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @inc (you may need to install the DBD::mysql module) (@inc contains: /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.20.2 /usr/local/share/perl/5.20.2 /usr/lib/x86_64-linux-gnu/perl5/5.20 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20 /usr/share/perl/5.20 /usr/local/lib/site_perl .) at (eval 5) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge.
at ./homer_mysql_partrotate_unixtimestamp.pl line 57.

@kismetgerald
Copy link
Author

Good day folks, I did some searching online and found some help in installing the mysql per drivers. I tried to run the homer_rotate script again, and this time I didn't get any of the previous errors........just the last line saying the "using a password on the command line can be insecure...."

So I believe the script worked successfully, however, how do I confirm this? Is there tables in the MySQL database that should now be present after the cron script runs that I can check for?

@recourse
Copy link

If you are comfortable with the mysql cli you can launch that look at look
at the sipcapture tables to see if the partitions have been created.

Something like

mysql -umysqluser -ppasswordforuser

use homer_data

show table status;

It will list tables with rotation dates. Kinda like this.

MariaDB [homer_data]> show table status\G
*************************** 1. row ***************************
Name: logs_capture
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 17
Avg_row_length: 16384
Data_length: 278528
Max_data_length: 0
Index_length: 557056
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-13 03:30:02
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment:
*************************** 2. row ***************************
Name: report_capture
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 17
Avg_row_length: 16384
Data_length: 278528
Max_data_length: 0
Index_length: 557056
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-13 03:30:02
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment:
*************************** 3. row ***************************
Name: rtcp_capture
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 17
Avg_row_length: 16384
Data_length: 278528
Max_data_length: 0
Index_length: 557056
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-13 03:30:01
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment:
*************************** 4. row ***************************
Name: sip_capture_call_20151104
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-02 03:30:01
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151104
*************************** 5. row ***************************
Name: sip_capture_call_20151105
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-03 03:30:01
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151105
*************************** 6. row ***************************
Name: sip_capture_call_20151106
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-04 03:30:01
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151106
*************************** 7. row ***************************
Name: sip_capture_call_20151107
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-05 03:30:01
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151107
*************************** 8. row ***************************
Name: sip_capture_call_20151108
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-06 03:30:01
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151108
*************************** 9. row ***************************
Name: sip_capture_call_20151109
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-07 03:30:01
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151109
*************************** 10. row ***************************
Name: sip_capture_call_20151110
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-08 03:30:01
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151110
*************************** 11. row ***************************
Name: sip_capture_call_20151111
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-09 03:30:01
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151111
*************************** 12. row ***************************
Name: sip_capture_call_20151112
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-10 03:30:01
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151112
*************************** 13. row ***************************
Name: sip_capture_call_20151113
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-11 03:30:02
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151113
*************************** 14. row ***************************
Name: sip_capture_call_20151114
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-12 03:30:02
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151114
*************************** 15. row ***************************
Name: sip_capture_call_20151115
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-13 03:30:01
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151115
*************************** 16. row ***************************
Name: sip_capture_registration_20151107
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-05 03:30:02
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151107
*************************** 17. row ***************************
Name: sip_capture_registration_20151108
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-06 03:30:01
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151108
*************************** 18. row ***************************
Name: sip_capture_registration_20151109
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-07 03:30:02
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151109
*************************** 19. row ***************************
Name: sip_capture_registration_20151110
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-08 03:30:02
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151110
*************************** 20. row ***************************
Name: sip_capture_registration_20151111
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-09 03:30:01
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151111
*************************** 21. row ***************************
Name: sip_capture_registration_20151112
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-10 03:30:01
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151112
*************************** 22. row ***************************
Name: sip_capture_registration_20151113
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-11 03:30:02
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151113
*************************** 23. row ***************************
Name: sip_capture_registration_20151114
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-12 03:30:02
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151114
*************************** 24. row ***************************
Name: sip_capture_registration_20151115
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-13 03:30:01
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151115
*************************** 25. row ***************************
Name: sip_capture_rest_20151109
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-07 03:30:02
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151109
*************************** 26. row ***************************
Name: sip_capture_rest_20151110
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-08 03:30:02
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151110
*************************** 27. row ***************************
Name: sip_capture_rest_20151111
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-09 03:30:01
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151111
*************************** 28. row ***************************
Name: sip_capture_rest_20151112
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-10 03:30:01
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151112
*************************** 29. row ***************************
Name: sip_capture_rest_20151113
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-11 03:30:02
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151113
*************************** 30. row ***************************
Name: sip_capture_rest_20151114
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-12 03:30:02
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151114
*************************** 31. row ***************************
Name: sip_capture_rest_20151115
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 2
Avg_row_length: 16384
Data_length: 32768
Max_data_length: 0
Index_length: 262144
Data_free: 0
Auto_increment: 1
Create_time: 2015-11-13 03:30:01
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: row_format=COMPRESSED key_block_size=8 partitioned
Comment: 20151115
31 rows in set (0.00 sec)

On Fri, Nov 13, 2015 at 9:37 AM, kismetgerald notifications@github.com
wrote:

Good day folks, I did some searching online and found some help in
installing the mysql per drivers. I tried to run the homer_rotate script
again, and this time I didn't get any of the previous errors........just
the last line saying the "using a password on the command line can be
insecure...."

So I believe the script worked successfully, however, how do I confirm
this? Is there tables in the MySQL database that should now be present
after the cron script runs that I can check for?


Reply to this email directly or view it on GitHub
#108 (comment).

@kismetgerald
Copy link
Author

@recourse

Thanks for the response. I did what you suggested but don't really understand what I'm seeing. Here's a screenshot (attached)

snap 2015-11-13 at 12 05 03

@recourse
Copy link

Yeah looks good. The sip_capture_call_20151115 are showing the partitions.

On Fri, Nov 13, 2015 at 11:10 AM, kismetgerald notifications@github.com
wrote:

@recourse https://github.com/recourse

Thanks for the response. I did what you suggested but don't really
understand what I'm seeing. Here's a screenshot (attached)

[image: snap 2015-11-13 at 12 05 03]
https://cloud.githubusercontent.com/assets/14914151/11152253/877f2e3c-89ff-11e5-8a6b-0e2950b11923.png


Reply to this email directly or view it on GitHub
#108 (comment).

@kismetgerald
Copy link
Author

@recourse Thanks. Now trying to figure out how to get capturing from my Freeswitch server to Homer5.

@lmangani
Copy link
Member

As discussed, captagent is the answer. Closing as there is no bug/issue ehre, If you need help please use the mailing list.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants