your session has been disabled

[iboam]

Hi i'm getting this error every 15-20 min when login as agent "your session has been disabled", i tried run the below command as ssh shell
mysqlcheck -u root -p --auto-repair --optimize --all-databases
and
mysqlcheck -u cron -p --auto-repair --optimize --all-databases

vicidial:~ # mysqlcheck -u cron -p --auto-repair --optimize --all-databases
Enter password:
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.conferences OK
asterisk.contact_information 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 optimize
asterisk.live_inbound OK
asterisk.live_inbound_log OK
asterisk.live_sip_channels
note : The storage engine for the table doesn't support optimize
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 optimize
asterisk.phone_favorites OK
asterisk.phones OK
asterisk.phones_alias OK
asterisk.recording_log OK
asterisk.routing_initiated_recordings OK
asterisk.server_performance OK
asterisk.server_updater
note : The storage engine for the table doesn't support optimize
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
error : Can't create new tempfile: '/var/lib/mysql/asterisk/user_call_log.TMM'
status : Operation failed
asterisk.vicibox 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_asterisk_output OK
asterisk.vicidial_auto_calls
note : The storage engine for the table doesn't support optimize
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_server_stats
note : The storage engine for the table doesn't support optimize
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_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_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_drop_rate_groups OK
asterisk.vicidial_dtmf_log
error : Can't create new tempfile: '/var/lib/mysql/asterisk/vicidial_dtmf_log.TMM'
status : Operation failed
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 optimize
asterisk.vicidial_html_cache_stats OK
asterisk.vicidial_inbound_dids OK
asterisk.vicidial_inbound_group_agents OK
asterisk.vicidial_inbound_groups OK
asterisk.vicidial_ivr 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
error : Can't create new tempfile: '/var/lib/mysql/asterisk/vicidial_live_agents.TMM'
status : Operation failed
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_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_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_log OK
asterisk.vicidial_user_territories OK
asterisk.vicidial_user_territory_log OK
asterisk.vicidial_users OK
asterisk.vicidial_voicemail OK
asterisk.vicidial_webservers OK
asterisk.vicidial_xfer_log 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 optimize
asterisk.www_phrases OK

Repairing tables
test.user_call_log
Error : Table 'test.user_call_log' doesn't exist
status : Operation failed
test.vicidial_dtmf_log
Error : Table 'test.vicidial_dtmf_log' doesn't exist
status : Operation failed
test.vicidial_live_agents
Error : Table 'test.vicidial_live_agents' doesn't exist
status : Operation failed

there is anyway i can repair this database or update it ??

Thanks in advance.

ViciBox_v.7.x86_64-7.0.0 | Vicidial 2.12-538a Build 160122-1401 | Asterisk 11 | Single Server | Intel Core i7-3770 8GB-RAM | 1TB Hard Drive

[williamconley]

Tables that don't exist can not be repaired. You could attempt a "drop" on these tables and attempt to create them with the original sql script snippets for those tables in /usr/src/astguiclient/trunk/extras

and be sure your HD is not full.

[iboam]

Thanks for answer my question, the hard drive is not full i'm just testing the server, i'm new in linux / vicidial, could you give me instructions to restore or repair the DB ?? thanks

[williamconley]

Thanks for answer my question, the hard drive is not full i'm just testing the server, i'm new in linux / vicidial, could you give me instructions to restore or repair the DB ?? thanks

Ya know what, you posted your entire setup configuration and even used my little "|" separated suggestion line to do it. LOL I'll see what I can do:

Code: Select all

drop table xxxxxx

then find the table name in /usr/src/astguiclient/trunk/extras

by using this:

Code: Select all

cd /usr/src/astguiclient/trunk/extras
grep 'CREATE TABLE xxxxxx' * -in


this will result in filenames with line numbers.

Code: Select all

nano +LINENUMBER FILENAME

then you'll need to execute the code that creates the tables you DROPped. In mysql.

If you need it more detailed than that, let me know. The pizza is here.

[proper]

maybe it will be useful to others, this is caused by empty TMM files already in the database directory, they are zero size and prevent new files from being created. You can safely remove this empty TMM for respective table and repair will complete.

More on this issue - http://bugs.mysql.com/bug.php?id=54828

[gservices]

Hello,

I have this problem with 3 Table of database with:
vicidial_manager
vicidial_live_agent
Vicidial_dtmf_log

I have drop all 3 table and create other 3 new... manual with import.

Now the problem is that in agent panel show me "your session has been disabled"

[williamconley]

Hello,

I have this problem with 3 Table of database with:
vicidial_manager
vicidial_live_agent
Vicidial_dtmf_log

I have drop all 3 table and create other 3 new... manual with import.

Now the problem is that in agent panel show me "your session has been disabled"

What made you think you had problems with those three tables in the first place?

Did you find crashed tables? What error did you see, and where?

There are plenty of other threads with other problems which can cause this same error. In this thread, the problem was that some TMM files needed to be deleted.

[gservices]

hello,
I find three tables on database down, and the original table after I drop table and after create new from /usr/src/astguiclient/trunk/extras/MySQL_AST_CREATE_tables.sql

The problem with Session was the version of vicidial_live_agent table, because the structure table of old version was different from the correct version.

[emel_punk]

I am having the same issue but every night at 1:00 AM. but as most of solution suggest, I cannot find any .TMM files since the mysql apparently is using innoDB. Also running mysqlcheck doesn't help.
I tried running the scripts configured in crontab manually at day but none of them seems to do repeat the error.
Sometimes the agents has a call and the system gets disabled, so that is nasty
Any other suggestion?



----
ViciBox_v8.x86_64-8.0.1 | Intel(R) Xeon(R) CPU X3430 @ 2.40GHz 16GB ram| VERSION: 2.14-684a BUILD: 180812-0902 | server cluster 1 database and web 2 asterisk

[mediasoft]

I am having the same issue but every night at 1:00 AM. but as most of solution suggest, I cannot find any .TMM files since the mysql apparently is using innoDB. Also running mysqlcheck doesn't help.
I tried running the scripts configured in crontab manually at day but none of them seems to do repeat the error.
Sometimes the agents has a call and the system gets disabled, so that is nasty
Any other suggestion?

Facing exactly the similar issue at 1:00 PM

Please suggest any solution.

----
ViciBox_v8.x86_64-8.0.1 | Intel(R) Xeon(R) CPU X3430 @ 2.40GHz 16GB ram| VERSION: 2.14-684a BUILD: 180812-0902 | server cluster 1 database and web 2 asterisk