Cluster Setup - No entry of web server in servers table

[rustynail]

Hi,

I am creating a Cluster with 1 DB server, 1 Web Server and 8 Telephony servers using Vicibox 8.0 ISO. I have installed the database server using vicibox-install script with expert mode selected and selecting only DB+WEB role for it. Everything is good for this server and vicidial reports page shows entry of this server but things get interesting when I install web server.
I used vicibox-install script again on 2nd server with expert mode enabled and selected Slave DB+web role for it. It all went fine and server was added fine but there is no entry in servers table and therefor it doesn't appear in the reports page also. server entry in 'vicibox' table is fine however. I suspect it could be due to legacy mode not enabled? I am considering re installing web server and using legacy mode... can someone please shed some light on why it happens? Previously I used to select Legacy mode and entries in DB were fine.

Here is how reports page looks with only DB server and no web server entry.
https://tmpfiles.org/download/20565/vicibox.png

Below is how I installed web server :

---------------------------------------------
ViciBox v.8.0 Installer

Local IP address not found! Please enter the IP address to use for ViciDial on this machine
Local IP Address : 203.223.X.2

The installer will ask questions based upon the role that this server is
to provide for the ViciBox Call Center Suite. You should have the database
and optionally archive servers setup prior to installing any other servers.
The installer will not run without there being a configured database! If this
server is to be the database then it must be installed before the archive server
Verify that all servers are connected to the same network and have connectivity
to each other before continuing. This installer will be destructive to the the
server if it is run.


Do you want to continue with the ViciBox install? [y/N] : y

Do you want to enable expert installation? [y/N] : y

The Internal IP address found was 203.223.X.2.
Do you want to use this IP address for ViciDial? [Y/n] : y

Will this server be used as the Database? [y/N] : y
---> Will this be a Slave Databse? [y/N] : y

Please input the master database IP address (203.223.X.2) : 203.223.X.1
Do you want to connect using the default ViciDial DB settings? [Y/n] : y

Will this server be used as a Web server? [y/N] : y
---> Install Redirect Page? [y/N] : y
---> Install phpMyAdmin ? [y/N] : n

Will this server be used as a Telephony server? [y/N] : n

Will this server be used as an Archive server? [y/N] : n

Do you want to disable the built-in firewall? [y/N] : y


--- ViciBox v.8.0 Install Summary ---

Expert : Yes
Legacy : No
Database : Yes
Slave ID : 2
Web : Yes
Redirect : Yes
PMA : No
Telephony: No
Archive : No
Firewall : Disabled

--- Configuration Information ---
- Database -
SVN Rev : 3114
IP Addr : 203.223.X.1
Name : asterisk
User : cron
Password : 1234
Cust User: custom
Cust Pass: custom1234
Slave Usr: slave
Slave Pw : slave1234
Port : 3306


Please verify the above information before continuing!
Do you want to continue the installation? [y/N] : y


Beginning installation, expect lots of output...

Disabling firewall...
Removed symlink /etc/systemd/system/multi-user.target.wants/SuSEfirewall2.service.
Removed symlink /etc/systemd/system/multi-user.target.wants/SuSEfirewall2_init.service.
Removed symlink /etc/systemd/system/SuSEfirewall2_setup.service.
<38>Jun 25 14:38:59 SuSEfirewall2[2700]: Firewall rules unloaded.

Updating to SVN revision 3114...
Updating '/usr/src/astguiclient/trunk':
U /usr/src/astguiclient/trunk/agi/VD_amd.agi
U /usr/src/astguiclient/trunk/agi/agi-DID_route.agi
U /usr/src/astguiclient/trunk/agi/agi-VDAD_ALL_inbound.agi
U /usr/src/astguiclient/trunk/agi/agi-VDAD_ALL_outbound.agi
U /usr/src/astguiclient/trunk/agi/agi-VDAD_inbound_calltime_check.agi
U /usr/src/astguiclient/trunk/agi/agi-VDAD_local_optimize.agi
U /usr/src/astguiclient/trunk/agi/agi-dtmf.agi
A /usr/src/astguiclient/trunk/agi/cm_cid_change.agi
U /usr/src/astguiclient/trunk/agi/cm_dnc.agi
U /usr/src/astguiclient/trunk/agi/cm_sc_ccc_lookup_insert.agi
U /usr/src/astguiclient/trunk/agi/park_CID.agi
U /usr/src/astguiclient/trunk/bin/ADMIN_archive_log_tables.pl
U /usr/src/astguiclient/trunk/bin/ADMIN_area_code_populate.pl
U /usr/src/astguiclient/trunk/bin/ADMIN_keepalive_ALL.pl
U /usr/src/astguiclient/trunk/bin/ADMIN_restart_roll_logs.pl
U /usr/src/astguiclient/trunk/bin/ADMIN_timeclock_auto_logout.pl
U /usr/src/astguiclient/trunk/bin/ADMIN_update_server_ip.pl
U /usr/src/astguiclient/trunk/bin/AST_CRON_audio_1_move_VDonly.pl
U /usr/src/astguiclient/trunk/bin/AST_CRON_audio_3_ftp.pl
A /usr/src/astguiclient/trunk/bin/AST_CRON_audio_3_ftp_FTPSSL.pl
U /usr/src/astguiclient/trunk/bin/AST_CRON_audio_4_ftp2.pl
U /usr/src/astguiclient/trunk/bin/AST_CRON_audio_4_ftp2_FTPSSL.pl
U /usr/src/astguiclient/trunk/bin/AST_DNCcom_filter.pl
A /usr/src/astguiclient/trunk/bin/AST_GDPR_audio_purge.pl
U /usr/src/astguiclient/trunk/bin/AST_VDadapt.pl
U /usr/src/astguiclient/trunk/bin/AST_VDauto_dial.pl
U /usr/src/astguiclient/trunk/bin/AST_VDauto_dial_FILL.pl
U /usr/src/astguiclient/trunk/bin/AST_VDhopper.pl
U /usr/src/astguiclient/trunk/bin/AST_VDsales_export_SFTPSSH2.pl
A /usr/src/astguiclient/trunk/bin/AST_activity_log_export.pl
U /usr/src/astguiclient/trunk/bin/AST_cleanup_agent_log.pl
U /usr/src/astguiclient/trunk/bin/AST_conf_update.pl
U /usr/src/astguiclient/trunk/bin/AST_conf_update_3way.pl
U /usr/src/astguiclient/trunk/bin/AST_email_web_report.pl
A /usr/src/astguiclient/trunk/bin/AST_expired_list_exporter.pl
U /usr/src/astguiclient/trunk/bin/AST_flush_DBqueue.pl
U /usr/src/astguiclient/trunk/bin/AST_inbound_email_parser.pl
A /usr/src/astguiclient/trunk/bin/AST_lead_select_export.pl
U /usr/src/astguiclient/trunk/bin/AST_manager_listen_AMI2.pl
A /usr/src/astguiclient/trunk/bin/AST_manager_sip_AMI2.pl
U /usr/src/astguiclient/trunk/bin/AST_output_update.pl
U /usr/src/astguiclient/trunk/bin/AST_phone_update.pl
U /usr/src/astguiclient/trunk/bin/AST_send_URL.pl
U /usr/src/astguiclient/trunk/bin/AST_send_action_child.pl
U /usr/src/astguiclient/trunk/bin/AST_update.pl
U /usr/src/astguiclient/trunk/bin/AST_update_AMI2.pl
U /usr/src/astguiclient/trunk/bin/FastAGI_log.pl
U /usr/src/astguiclient/trunk/bin/VD_email_inbound.pl
U /usr/src/astguiclient/trunk/bin/VICIDIAL_fix_list_statuses.pl
U /usr/src/astguiclient/trunk/docs/conf_examples/extensions.conf.sample-1.8
U /usr/src/astguiclient/trunk/docs/conf_examples/extensions.conf.sample-13
U /usr/src/astguiclient/trunk/docs/conf_examples/manager.conf.sample-13
U /usr/src/astguiclient/trunk/docs/AGENT_API.txt
U /usr/src/astguiclient/trunk/docs/ASTERISK_13.txt
U /usr/src/astguiclient/trunk/docs/CALLER_ID_NAME_CODES.txt
U /usr/src/astguiclient/trunk/docs/CALL_URL_FEATURES.txt
U /usr/src/astguiclient/trunk/docs/CELLPHONE_USA_TCPA_FCC_COMPLIANCE.txt
U /usr/src/astguiclient/trunk/docs/CROSS_CLUSTER_COMMUNICATION.txt
U /usr/src/astguiclient/trunk/docs/DISPO_SEND_EMAIL.txt
A /usr/src/astguiclient/trunk/docs/EU_GDPR_COMPLIANCE.txt
A /usr/src/astguiclient/trunk/docs/INBOUND_CALLBACK_QUEUE.txt
U /usr/src/astguiclient/trunk/docs/LICENSE.txt
U /usr/src/astguiclient/trunk/docs/NON-AGENT_API.txt
U /usr/src/astguiclient/trunk/docs/QUEUEMETRICS.txt
A /usr/src/astguiclient/trunk/docs/SIP_EVENT_LOGGING.txt
U /usr/src/astguiclient/trunk/docs/Sangoma_Netborder_CPD_Walkthrough.txt
U /usr/src/astguiclient/trunk/docs/VICIDIAL_statuses.txt
U /usr/src/astguiclient/trunk/extras/MySQL_AST_CREATE_tables.sql
U /usr/src/astguiclient/trunk/extras/SCRIPT_multirecording.php
U /usr/src/astguiclient/trunk/extras/SCRIPT_multirecording_AJAX.php
A /usr/src/astguiclient/trunk/extras/add_DNC_test.php
A /usr/src/astguiclient/trunk/extras/admin_listloader_third_gen.php
A /usr/src/astguiclient/trunk/extras/ast13_amd_noaudio.patch
U /usr/src/astguiclient/trunk/extras/get2post.php
A /usr/src/astguiclient/trunk/extras/sip_logging.patch
U /usr/src/astguiclient/trunk/extras/upgrade_2.12.sql
U /usr/src/astguiclient/trunk/extras/upgrade_2.14.sql
A /usr/src/astguiclient/trunk/extras/vdc_hipchat.php
A /usr/src/astguiclient/trunk/extras/vdc_webpowerswitch.php
A /usr/src/astguiclient/trunk/sounds/error_transfer.wav
A /usr/src/astguiclient/trunk/sounds/invalid_number.wav
A /usr/src/astguiclient/trunk/sounds/ok_lets_try_again.wav
A /usr/src/astguiclient/trunk/sounds/please_enter_your_number.wav
A /usr/src/astguiclient/trunk/sounds/press1_to_confirm_press2_to_reenter.wav
A /usr/src/astguiclient/trunk/sounds/thanks_we_will_call_you_back.wav
A /usr/src/astguiclient/trunk/sounds/thanks_we_will_call_you_back_pt1.wav
A /usr/src/astguiclient/trunk/sounds/thanks_we_will_call_you_back_pt2.wav
A /usr/src/astguiclient/trunk/sounds/thanks_you_entered.wav
A /usr/src/astguiclient/trunk/sounds/this_number_press1_other_number_press2.wav
A /usr/src/astguiclient/trunk/sounds/to_receive_call_back_press1.wav
A /usr/src/astguiclient/trunk/sounds/you_are_calling_from.wav
A /usr/src/astguiclient/trunk/translations/LANGUAGE_ALL_el_Greek_20190207-005409.txt
U /usr/src/astguiclient/trunk/www/agc/css/vicidial_stylesheet.css
A /usr/src/astguiclient/trunk/www/agc/images/vdc_LB_mute_recording_AVAILABLE.gif
A /usr/src/astguiclient/trunk/www/agc/images/vdc_LB_mute_recording_AVAILABLE_es.gif
A /usr/src/astguiclient/trunk/www/agc/images/vdc_LB_mute_recording_AVAILABLE_jp.gif
A /usr/src/astguiclient/trunk/www/agc/images/vdc_LB_mute_recording_DISABLED.gif
A /usr/src/astguiclient/trunk/www/agc/images/vdc_LB_mute_recording_DISABLED_es.gif
A /usr/src/astguiclient/trunk/www/agc/images/vdc_LB_mute_recording_DISABLED_jp.gif
A /usr/src/astguiclient/trunk/www/agc/images/vdc_LB_mute_recording_ON.gif
A /usr/src/astguiclient/trunk/www/agc/images/vdc_LB_mute_recording_ON_es.gif
A /usr/src/astguiclient/trunk/www/agc/images/vdc_LB_mute_recording_ON_jp.gif
U /usr/src/astguiclient/trunk/www/agc/agc_agent_manager_chat_interface.php
U /usr/src/astguiclient/trunk/www/agc/api.php
U /usr/src/astguiclient/trunk/www/agc/chat_db_query.php
U /usr/src/astguiclient/trunk/www/agc/conf_exten_check.php
U /usr/src/astguiclient/trunk/www/agc/deactivate_lead.php
U /usr/src/astguiclient/trunk/www/agc/dispo_add_FPG.php
A /usr/src/astguiclient/trunk/www/agc/dispo_change_status.php
U /usr/src/astguiclient/trunk/www/agc/dispo_move_list.php
U /usr/src/astguiclient/trunk/www/agc/dispo_send_email.php
U /usr/src/astguiclient/trunk/www/agc/functions.php
U /usr/src/astguiclient/trunk/www/agc/manager_send.php
U /usr/src/astguiclient/trunk/www/agc/options-example.php
U /usr/src/astguiclient/trunk/www/agc/phone_only.php
U /usr/src/astguiclient/trunk/www/agc/vdc_chat_display.php
U /usr/src/astguiclient/trunk/www/agc/vdc_db_query.php
U /usr/src/astguiclient/trunk/www/agc/vdc_email_display.php
U /usr/src/astguiclient/trunk/www/agc/vdc_form_display.php
U /usr/src/astguiclient/trunk/www/agc/vdc_script_display.php
U /usr/src/astguiclient/trunk/www/agc/vdc_script_notes.php
U /usr/src/astguiclient/trunk/www/agc/vdc_soundboard_display.php
U /usr/src/astguiclient/trunk/www/agc/vicidial.php
U /usr/src/astguiclient/trunk/www/agc/voicemail_check.php
A /usr/src/astguiclient/trunk/www/vicidial/images/help.png
A /usr/src/astguiclient/trunk/www/vicidial/images/icon_cidgroups.png
A /usr/src/astguiclient/trunk/www/vicidial/images/loader.gif
A /usr/src/astguiclient/trunk/www/vicidial/AST_AMD_log_report.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_API_log_report.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_CLOSER_service_level.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_CLOSERstats.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_CLOSERstats_v2.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_CLOSERsummary_hourly.php
A /usr/src/astguiclient/trunk/www/vicidial/AST_CMstats.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_DIDstats.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_IVRfilter.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_IVRstats.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_LISTS_campaign_stats.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_LISTS_pass_report.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_LISTS_stats.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_OUTBOUNDsummary_interval.php
A /usr/src/astguiclient/trunk/www/vicidial/AST_SIP_event_report.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_VDADstats.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_VICIDIAL_hopperlist.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_VICIDIAL_ingrouplist.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_admin_template_maker.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_agent_days_detail.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_agent_performance_detail.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_agent_performance_detail_SALES.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_agent_status_detail.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_agent_time_detail.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_agent_timeclock_detail.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_campaign_status_list_report.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_inbound_daily_report.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_inbound_forecasting.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_parkstats.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_performance_comparison_report.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_recording_log_report.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_rt_monitor_log_report.php
A /usr/src/astguiclient/trunk/www/vicidial/AST_rt_whiteboard_rpt.php
A /usr/src/astguiclient/trunk/www/vicidial/AST_rt_whiteboard_rpt_mobile.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_server_performance.php
A /usr/src/astguiclient/trunk/www/vicidial/AST_source_vlc_status_report.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_team_performance_detail.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_timeonVDADall.php
A /usr/src/astguiclient/trunk/www/vicidial/AST_timeonVDADallSUMMARY_mobile.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_user_group_hourly_detail.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_user_group_hourly_detail_v2.php
U /usr/src/astguiclient/trunk/www/vicidial/AST_usergroup_login_report.php
U /usr/src/astguiclient/trunk/www/vicidial/Erlang_report.php
U /usr/src/astguiclient/trunk/www/vicidial/QM_live_monitor.php
A /usr/src/astguiclient/trunk/www/vicidial/TCPAlitigatorlist_inbound_filter.php
U /usr/src/astguiclient/trunk/www/vicidial/admin.php
U /usr/src/astguiclient/trunk/www/vicidial/admin_NANPA_updater.php
U /usr/src/astguiclient/trunk/www/vicidial/admin_amm_multi.php
U /usr/src/astguiclient/trunk/www/vicidial/admin_bulk_tools.php
U /usr/src/astguiclient/trunk/www/vicidial/admin_campaign_multi_alt.php
U /usr/src/astguiclient/trunk/www/vicidial/admin_email_accounts.php
U /usr/src/astguiclient/trunk/www/vicidial/admin_header.php
U /usr/src/astguiclient/trunk/www/vicidial/admin_languages.php
U /usr/src/astguiclient/trunk/www/vicidial/admin_listloader_fourth_gen.php
U /usr/src/astguiclient/trunk/www/vicidial/admin_listloader_third_gen.php
U /usr/src/astguiclient/trunk/www/vicidial/admin_lists_custom.php
A /usr/src/astguiclient/trunk/www/vicidial/admin_mobile.php
U /usr/src/astguiclient/trunk/www/vicidial/admin_modify_lead.php
U /usr/src/astguiclient/trunk/www/vicidial/admin_phones_bulk_insert.php
U /usr/src/astguiclient/trunk/www/vicidial/admin_search_lead.php
U /usr/src/astguiclient/trunk/www/vicidial/admin_soundboard.php
U /usr/src/astguiclient/trunk/www/vicidial/admin_url_multi.php
U /usr/src/astguiclient/trunk/www/vicidial/admin_user_list_new.php
U /usr/src/astguiclient/trunk/www/vicidial/audio_store.php
U /usr/src/astguiclient/trunk/www/vicidial/call_report_export.php
U /usr/src/astguiclient/trunk/www/vicidial/call_report_export_carrier.php
U /usr/src/astguiclient/trunk/www/vicidial/callbacks_bulk_move.php
U /usr/src/astguiclient/trunk/www/vicidial/callcard_admin.php
U /usr/src/astguiclient/trunk/www/vicidial/called_counts_multilist_report.php
U /usr/src/astguiclient/trunk/www/vicidial/campaign_debug.php
A /usr/src/astguiclient/trunk/www/vicidial/campaign_summary_mobile_report.php
A /usr/src/astguiclient/trunk/www/vicidial/display_help.php
U /usr/src/astguiclient/trunk/www/vicidial/fcstats.php
U /usr/src/astguiclient/trunk/www/vicidial/fcstats_detail.php
U /usr/src/astguiclient/trunk/www/vicidial/functions.php
U /usr/src/astguiclient/trunk/www/vicidial/graphcanvas.inc
A /usr/src/astguiclient/trunk/www/vicidial/help.js
U /usr/src/astguiclient/trunk/www/vicidial/help.php
A /usr/src/astguiclient/trunk/www/vicidial/help.png
A /usr/src/astguiclient/trunk/www/vicidial/help_documentation.txt
U /usr/src/astguiclient/trunk/www/vicidial/lead_report_export.php
U /usr/src/astguiclient/trunk/www/vicidial/leadloader_template_display.php
U /usr/src/astguiclient/trunk/www/vicidial/list_download.php
U /usr/src/astguiclient/trunk/www/vicidial/list_merge.php
U /usr/src/astguiclient/trunk/www/vicidial/list_split.php
U /usr/src/astguiclient/trunk/www/vicidial/manager_chat_interface.php
U /usr/src/astguiclient/trunk/www/vicidial/medialog_inventory_report.php
U /usr/src/astguiclient/trunk/www/vicidial/non_agent_api.php
U /usr/src/astguiclient/trunk/www/vicidial/options-example.php
A /usr/src/astguiclient/trunk/www/vicidial/process_report.php
A /usr/src/astguiclient/trunk/www/vicidial/pureknob.js
U /usr/src/astguiclient/trunk/www/vicidial/qc_modify_lead.php
U /usr/src/astguiclient/trunk/www/vicidial/realtime_report.php
A /usr/src/astguiclient/trunk/www/vicidial/realtime_report_mobile.php
U /usr/src/astguiclient/trunk/www/vicidial/reset_campaign_lists.php
U /usr/src/astguiclient/trunk/www/vicidial/timeclock_report.php
U /usr/src/astguiclient/trunk/www/vicidial/user_stats.php
U /usr/src/astguiclient/trunk/www/vicidial/user_territories.php
U /usr/src/astguiclient/trunk/www/vicidial/vicidial_custom_reports_admin.php
U /usr/src/astguiclient/trunk/www/vicidial/vicidial_sales_viewer.php
A /usr/src/astguiclient/trunk/www/vicidial/vicidial_stylesheet.php
A /usr/src/astguiclient/trunk/www/vicidial/vicidial_whiteboard_functions.php
A /usr/src/astguiclient/trunk/www/vicidial/whiteboard_reports.php
U /usr/src/astguiclient/trunk/www/vicidial/xml_rpc_audio_server_vicidial.php
U /usr/src/astguiclient/trunk/UPGRADE
U /usr/src/astguiclient/trunk/install.pl
Updated to revision 3114.
Doing general DataBase requirements...
Doing Slave-specific MySQL setup...

Beginning database dump from master, this may take a while...

Info: Using unique option prefix 'all-database' is error-prone and can break in the future. Please use the full name 'all-databases' instead.
Beginning database load into slave, this may take a while...
The --upgrade-system-tables option was used, user tables won't be touched.
Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql
mysql.column_stats OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.gtid_slave_pos OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.index_stats OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.roles_mapping OK
mysql.servers OK
mysql.table_stats OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
Phase 2/7: Installing used storage engines... Skipped
Phase 3/7: Fixing views... Skipped
Phase 4/7: Running 'mysql_fix_privilege_tables'
Phase 5/7: Fixing table and database names ... Skipped
Phase 6/7: Checking and upgrading tables... Skipped
Phase 7/7: Running 'FLUSH PRIVILEGES'
OK
Slave loaded and started. Verify by connecting to MySQL and running 'slave show status'
Configuring Web Server...
Use of uninitialized value $randomstring in concatenation (.) or string at /usr/local/bin/vicibox-install line 390, <STDIN> line 15.
Created symlink from /etc/systemd/system/httpd.service to /usr/lib/systemd/system/apache2.service.
Created symlink from /etc/systemd/system/apache.service to /usr/lib/systemd/system/apache2.service.
Created symlink from /etc/systemd/system/multi-user.target.wants/apache2.service to /usr/lib/systemd/system/apache2.service.
/tmp/rootcron: No such file or directory


PLEASE use secure passwords inside vicidial. It prevents hackers
and other undesirables from compromising your system and costing
you thousands in toll fraud and long distance. A secure password
Contains at least one capital letter and one number. A good example
of a secure password would be PvdNCdTlnCAYu9N.

Don't feed the black market, secure your systems properly!

---------------------------------------------------------------------------------------
UPDATE:
Also why server_id 3 is having IP of DB server as it should have IP of web server.

Below are entries of vicibox table.

MariaDB [(none)]> select * from asterisk.vicibox\G
*************************** 1. row ***************************
server_id: 1
server: SRVR-DB
server_ip: 203.223.X.1
server_type: Database
field1: 0
field2: asterisk
field3: 3114
field4: cron
field5: 1234
field6: custom
field7: custom1234
field8: slave
field9: slave1234
*************************** 2. row ***************************
server_id: 2
server: SRVR-DB
server_ip: 203.223.X.1
server_type: Web
field1: 203.223.X.1
field2: oofcdPoFhGhWN1HJaigynQf6OzOQNSbT
field3: NULL
field4: NULL
field5: NULL
field6: NULL
field7: NULL
field8: NULL
field9: NULL
*************************** 3. row ***************************
server_id: 3
server: SRVR-WEB
server_ip: 203.223.X.1
server_type: Database
field1: 2
field2: asterisk
field3: 3114
field4: cron
field5: 1234
field6: custom
field7: custom1234
field8: slave
field9: slave1234
*************************** 4. row ***************************
server_id: 4
server: SRVR-WEB
server_ip: 203.223.X.2
server_type: Web
field1: 203.223.X.2
field2:
field3: NULL
field4: NULL
field5: NULL
field6: NULL
field7: NULL
field8: NULL
field9: NULL
4 rows in set (0.00 sec)

[williamconley]

1) The Vicibox .iso installers have a longer version, please include the whole thing not just the "8.0".

2) Why not use the latest which is presently 8.1.2?

3) This is by design. Web servers do not need an entry in the servers table

4) You should always install web and dialer on all new servers Just In Case you choose to use the other role as well. Just don't use the role you don't want, dormant roles don't use enough power that anyone (to date) has noticed in our hundreds of installs.

5) If you MUST have your web server visible in "servers" (Not a bad reflex, really) ... feel free to hit "new server" and add it. Won't hurt anything.

[rustynail]

Thanks very much William for your quick response.

1. I wrote 8.0 because this the version which I see when login to server... like below
Thank you for installing ViciBox Server v.8.0!

Here is other info of this version:
VERSION: 2.14-711a
BUILD: 190607-1525
Version: 2.14b0.5
SVN Version: 3114
DB Schema Version: 1571

2. Kind of used to with this release as using it for production. However as you mentioned in your point#3 that this is by design and not an issue then I think it will be same on latest version. Also waiting for some bug fixes that come with new releases - lol. I will definitely install latest release on next server.

3. Ok great. That's relief (used to install all roles previously so didn't encountered it before)

4. Ok noted. as mentioned in above point I used to install both roles on non-db servers previously but tried to assign specific roles this time

5. Ok sure, great point... done previously with some servers but wanted some confirmation as it is a big client and recently we are facing some odd issues

Again thank you so much for great help and support... Now I can safely use this web server as I was thinking to reinstall it before...

Cheers!

[rustynail]

Another quick question: Should I leave "Asterisk Version:" field empty or can give any version as I think it shouldn't make any difference.

[williamconley]

Another quick question: Should I leave "Asterisk Version:" field empty or can give any version as I think it shouldn't make any difference.

Shouldn't make a difference, however you may find asterisk installed but not running. In which case grabbing the version now while you're on the topic may be ... useful in a few months, should you ever decide to wake this server up.

Note that when you have a dedicated web server, you'll likely want to increase the available apache processes to avoid running out. /etc/apache2/server-tuning.conf increase the prefork and workers. Pretty sure there are some threads on the topic in here somewhere, perhaps a mention in the manual as well.

I also like to enable the apache status module. In /etc/apache2/default-server.conf

Code: Select all

LoadModule status_module /usr/lib64/apache2/mod_status.so
ExtendedStatus On
<Location /server-status>
  SetHandler server-status
  Require all granted
</Location>

http://SERVERip/server-status

Very useful module.

[rustynail]

Thanks again for detailed reply and the tip regarding apache.. I usually increase prefork but do not increase workers... can this create issues or bottleneck too?

I have this config in server-tuning.conf

<IfModule prefork.c>
StartServers 450
MinSpareServers 250
MaxSpareServers 500
ServerLimit 768
MaxClients 512
MaxRequestsPerChild 100000
</IfModule>
<IfModule worker.c>
StartServers 3
MinSpareThreads 25
MaxSpareThreads 75
ThreadLimit 64
MaxClients 512
ThreadsPerChild 25
MaxRequestsPerChild 100000
</IfModule>


Awesome tip for apache status

[williamconley]

Every instance is different. You're experience will be unique. Watch with the status monitor and wait for ... problems. Then fix 'em IF there are any.

[rustynail]

I will keep an eye and check for any issues that pop up..

Thanks