Closed kismetgerald closed 8 years ago
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.
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.
Kris, all you should have left to do is configure the web server w/ proper settings, db connection and the rotation scripts.
Yes sir, that's what I'm doing now.
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.
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:
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?
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
@kismetgerald this usually means there is no HEP server listening. Make sure the HEP port is correct in your client configuration.
or maybe there is a firewall issue
@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?
Error logs on the server should tell the story. Check your syslog and let us know what Kamailio says.
@lmangani As far as Kamailio is concerned, everything is peachy...lol.
Nov 11 09:53:51 freeswitch2 /usr/local/sbin/kamailio[10609]: NOTICE:
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.
@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.
@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?
@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
@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.
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
@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.
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 ;)
@lmangani Unfortunately, I am not seeing any traffic traversing both servers on ports 9060.
As @adubovikov pointed out a firewall is likely in place on the system running captagent
@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.
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#
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 https://github.com/sipcapture/homer/issues/108#issuecomment-156231282.
@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.
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?
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
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 https://github.com/sipcapture/homer/issues/108#issuecomment-156465906.
@recourse
Thanks for the response. I did what you suggested but don't really understand what I'm seeing. Here's a screenshot (attached)
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 https://github.com/sipcapture/homer/issues/108#issuecomment-156490780.
@recourse Thanks. Now trying to figure out how to get capturing from my Freeswitch server to Homer5.
As discussed, captagent is the answer. Closing as there is no bug/issue ehre, If you need help please use the mailing list.
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.