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.

from homer.

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.

from homer.

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

from homer.

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

from homer.

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.

from homer.

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

from homer.

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?

from homer.

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

from homer.

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

from homer.

or maybe there is a firewall issue

from homer.

@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?

from homer.

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

from homer.

@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]: .

from homer.

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.

from homer.

@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.

from homer.

@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?

from homer.

@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

from homer.

@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.

from homer.

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

from homer.

@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.

from homer.

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 ;)

from homer.

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

from homer.

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

from homer.

@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.

from homer.

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#

from homer.

you have to install perl DBI

On 12 November 2015 at 21:55, kismetgerald [email protected] 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).

from homer.

@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.

from homer.

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?

from homer.

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 [email protected]
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).

from homer.

@recourse

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

from homer.

Yeah looks good. The sip_capture_call_20151115 are showing the partitions.

On Fri, Nov 13, 2015 at 11:10 AM, kismetgerald [email protected]
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).

from homer.

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

from homer.

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

from homer.