Can anyone please assist?
I have managed to change the permission sand ownership on my /var/lib/mysql & /var/lib/mysql/asterisk directories.
I can access admin side of vicidial, without any issues, reporting, lists, campaigns all work, however the agents cannot log in.
They get the error Your Session has been disabled.
I have ran mysqlcheck and the databases show as follows:
asterisk.audio_store_details OK
asterisk.call_log OK
asterisk.call_log_archive OK
asterisk.callcard_accounts OK
asterisk.callcard_accounts_details OK
asterisk.callcard_log OK
asterisk.cid_channels_recent OK
asterisk.conferences OK
asterisk.contact_information OK
asterisk.custom_101 OK
asterisk.dialable_inventory_snapshots OK
asterisk.groups_alias OK
asterisk.inbound_email_attachments OK
asterisk.inbound_numbers OK
asterisk.live_channels
note : The storage engine for the table doesn't support check
asterisk.live_inbound OK
asterisk.live_inbound_log OK
asterisk.live_sip_channels
note : The storage engine for the table doesn't support check
asterisk.nanpa_prefix_exchanges_fast OK
asterisk.nanpa_prefix_exchanges_master OK
asterisk.nanpa_wired_to_wireless OK
asterisk.nanpa_wireless_to_wired OK
asterisk.park_log OK
asterisk.parked_channels
note : The storage engine for the table doesn't support check
asterisk.parked_channels_recent OK
asterisk.phone_favorites OK
asterisk.phones OK
asterisk.phones_alias OK
asterisk.recording_log OK
asterisk.recording_log_archive OK
asterisk.recording_log_deletion_queue OK
asterisk.routing_initiated_recordings OK
asterisk.server_performance OK
asterisk.server_updater
note : The storage engine for the table doesn't support check
asterisk.servers OK
asterisk.system_settings OK
asterisk.twoday_call_log OK
asterisk.twoday_recording_log OK
asterisk.twoday_vicidial_agent_log OK
asterisk.twoday_vicidial_closer_log OK
asterisk.twoday_vicidial_log OK
asterisk.twoday_vicidial_xfer_log OK
asterisk.user_call_log OK
asterisk.user_call_log_archive OK
asterisk.vicidial_admin_log OK
asterisk.vicidial_agent_log OK
asterisk.vicidial_agent_log_archive OK
asterisk.vicidial_agent_skip_log OK
asterisk.vicidial_agent_sph OK
asterisk.vicidial_ajax_log OK
asterisk.vicidial_amm_multi OK
asterisk.vicidial_api_log OK
asterisk.vicidial_api_log_archive OK
asterisk.vicidial_api_urls OK
asterisk.vicidial_api_urls_archive OK
asterisk.vicidial_areacode_filters OK
asterisk.vicidial_asterisk_output OK
asterisk.vicidial_auto_calls
note : The storage engine for the table doesn't support check
asterisk.vicidial_automated_reports OK
asterisk.vicidial_avatar_audio OK
asterisk.vicidial_avatars OK
asterisk.vicidial_call_menu OK
asterisk.vicidial_call_menu_options OK
asterisk.vicidial_call_notes OK
asterisk.vicidial_call_notes_archive OK
asterisk.vicidial_call_time_holidays OK
asterisk.vicidial_call_times OK
asterisk.vicidial_callbacks OK
asterisk.vicidial_callbacks_archive OK
asterisk.vicidial_campaign_agents OK
asterisk.vicidial_campaign_cid_areacodes OK
asterisk.vicidial_campaign_dnc OK
asterisk.vicidial_campaign_hotkeys OK
asterisk.vicidial_campaign_hour_counts OK
asterisk.vicidial_campaign_hour_counts_archive OK
asterisk.vicidial_campaign_server_stats
note : The storage engine for the table doesn't support check
asterisk.vicidial_campaign_stats OK
asterisk.vicidial_campaign_stats_debug OK
asterisk.vicidial_campaign_statuses OK
asterisk.vicidial_campaigns OK
asterisk.vicidial_campaigns_list_mix OK
asterisk.vicidial_carrier_hour_counts OK
asterisk.vicidial_carrier_hour_counts_archive OK
asterisk.vicidial_carrier_log OK
asterisk.vicidial_carrier_log_archive OK
asterisk.vicidial_chat_archive OK
asterisk.vicidial_chat_log OK
asterisk.vicidial_chat_log_archive OK
asterisk.vicidial_chat_participants OK
asterisk.vicidial_cid_groups OK
asterisk.vicidial_closer_log OK
asterisk.vicidial_closer_log_archive OK
asterisk.vicidial_comments OK
asterisk.vicidial_conf_templates OK
asterisk.vicidial_conferences OK
asterisk.vicidial_configuration OK
asterisk.vicidial_country_iso_tld OK
asterisk.vicidial_cpd_log OK
asterisk.vicidial_custom_cid OK
asterisk.vicidial_custom_leadloader_templates OK
asterisk.vicidial_custom_reports OK
asterisk.vicidial_daily_max_stats OK
asterisk.vicidial_daily_ra_stats OK
asterisk.vicidial_dial_log OK
asterisk.vicidial_dial_log_archive OK
asterisk.vicidial_did_agent_log OK
asterisk.vicidial_did_agent_log_archive OK
asterisk.vicidial_did_log OK
asterisk.vicidial_did_ra_extensions OK
asterisk.vicidial_dnc OK
asterisk.vicidial_dnc_log OK
asterisk.vicidial_dnccom_filter_log OK
asterisk.vicidial_dnccom_scrub_log OK
asterisk.vicidial_drop_lists OK
asterisk.vicidial_drop_log OK
asterisk.vicidial_drop_log_archive OK
asterisk.vicidial_drop_rate_groups OK
asterisk.vicidial_dtmf_log OK
asterisk.vicidial_email_accounts OK
asterisk.vicidial_email_list OK
asterisk.vicidial_email_log OK
asterisk.vicidial_extension_groups OK
asterisk.vicidial_filter_phone_groups OK
asterisk.vicidial_filter_phone_numbers OK
asterisk.vicidial_grab_call_log OK
asterisk.vicidial_hopper
note : The storage engine for the table doesn't support check
asterisk.vicidial_html_cache_stats OK
asterisk.vicidial_inbound_callback_queue OK
asterisk.vicidial_inbound_callback_queue_archive OK
asterisk.vicidial_inbound_dids OK
asterisk.vicidial_inbound_group_agents OK
asterisk.vicidial_inbound_groups OK
asterisk.vicidial_inbound_survey_log OK
asterisk.vicidial_inbound_survey_log_archive OK
asterisk.vicidial_ingroup_hour_counts OK
asterisk.vicidial_ingroup_hour_counts_archive OK
asterisk.vicidial_ip_list_entries OK
asterisk.vicidial_ip_lists OK
asterisk.vicidial_ivr OK
asterisk.vicidial_ivr_response OK
asterisk.vicidial_language_phrases OK
asterisk.vicidial_languages OK
asterisk.vicidial_lead_filters OK
asterisk.vicidial_lead_recycle OK
asterisk.vicidial_lead_search_log OK
asterisk.vicidial_lead_search_log_archive OK
asterisk.vicidial_list OK
asterisk.vicidial_list_alt_phones OK
asterisk.vicidial_list_pins OK
asterisk.vicidial_list_update_log OK
asterisk.vicidial_lists OK
asterisk.vicidial_lists_custom OK
asterisk.vicidial_lists_fields OK
asterisk.vicidial_live_agents OK
asterisk.vicidial_live_chats OK
asterisk.vicidial_live_inbound_agents OK
asterisk.vicidial_log OK
asterisk.vicidial_log_archive OK
asterisk.vicidial_log_extended OK
asterisk.vicidial_log_extended_archive OK
asterisk.vicidial_log_noanswer OK
asterisk.vicidial_log_noanswer_archive OK
asterisk.vicidial_manager OK
asterisk.vicidial_manager_chat_log OK
asterisk.vicidial_manager_chat_log_archive OK
asterisk.vicidial_manager_chats OK
asterisk.vicidial_manager_chats_archive OK
asterisk.vicidial_manual_dial_queue OK
asterisk.vicidial_monitor_calls OK
asterisk.vicidial_monitor_log OK
asterisk.vicidial_music_on_hold OK
asterisk.vicidial_music_on_hold_files OK
asterisk.vicidial_nanpa_filter_log OK
asterisk.vicidial_nanpa_prefix_codes OK
asterisk.vicidial_outbound_ivr_log OK
asterisk.vicidial_outbound_ivr_log_archive OK
asterisk.vicidial_override_ids OK
asterisk.vicidial_pause_codes OK
asterisk.vicidial_phone_codes OK
asterisk.vicidial_postal_codes OK
asterisk.vicidial_process_log OK
asterisk.vicidial_process_trigger_log OK
asterisk.vicidial_process_triggers OK
asterisk.vicidial_qc_agent_log OK
asterisk.vicidial_qc_codes OK
asterisk.vicidial_recording_access_log OK
asterisk.vicidial_remote_agent_log OK
asterisk.vicidial_remote_agents OK
asterisk.vicidial_report_log OK
asterisk.vicidial_rt_monitor_log OK
asterisk.vicidial_rt_monitor_log_archive OK
asterisk.vicidial_screen_colors OK
asterisk.vicidial_screen_labels OK
asterisk.vicidial_scripts OK
asterisk.vicidial_server_carriers OK
asterisk.vicidial_server_trunks OK
asterisk.vicidial_session_data OK
asterisk.vicidial_settings_containers OK
asterisk.vicidial_shifts OK
asterisk.vicidial_state_call_times OK
asterisk.vicidial_stations OK
asterisk.vicidial_status_categories OK
asterisk.vicidial_status_groups OK
asterisk.vicidial_statuses OK
asterisk.vicidial_territories OK
asterisk.vicidial_timeclock_audit_log OK
asterisk.vicidial_timeclock_log OK
asterisk.vicidial_timeclock_status OK
asterisk.vicidial_tts_prompts OK
asterisk.vicidial_url_log OK
asterisk.vicidial_url_multi OK
asterisk.vicidial_urls OK
asterisk.vicidial_user_closer_log OK
asterisk.vicidial_user_groups OK
asterisk.vicidial_user_list_new_lead OK
asterisk.vicidial_user_log OK
asterisk.vicidial_user_territories OK
asterisk.vicidial_user_territory_log OK
asterisk.vicidial_users OK
asterisk.vicidial_vdad_log OK
asterisk.vicidial_voicemail OK
asterisk.vicidial_webservers OK
asterisk.vicidial_xfer_log OK
asterisk.vicidial_xfer_log_archive OK
asterisk.vicidial_xfer_presets OK
asterisk.vicidial_xfer_stats OK
asterisk.vtiger_rank_data OK
asterisk.vtiger_rank_parameters OK
asterisk.vtiger_vicidial_roles OK
asterisk.web_client_sessions
note : The storage engine for the table doesn't support check
asterisk.www_phrases OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log
Error : You can't use locks with log tables.
status : OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.servers OK
mysql.slow_log
Error : You can't use locks with log tables.
status : 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
test.dbd_mysql_t30 OK
Can anyone let me know the permissions and owners of the above directories please?