-- MySQL dump 10.13 Distrib 8.0.28, for Linux (x86_64)---- Host: 127.0.0.1 Database: asterisk-- -------------------------------------------------------- Server version8.0.28/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT*/;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS*/;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION*/;/*!50503 SET NAMES utf8mb4*/;/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE*/;/*!40103 SET TIME_ZONE='+00:00'*/;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0*/;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0*/;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'*/;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0*/;---- Table structure for table `ps_aors`--DROPTABLE IF EXISTS`ps_aors`;/*!40101 SET @saved_cs_client = @@character_set_client*/;/*!50503 SET character_set_client = utf8mb4*/;CREATETABLE `ps_aors` (`id`varchar(40)NOT NULL,`contact`varchar(255) DEFAULTNULL,`default_expiration`int DEFAULTNULL,`mailboxes`varchar(80) DEFAULTNULL,`max_contacts`int DEFAULTNULL,`minimum_expiration`int DEFAULTNULL,`remove_existing` enum('yes','no') DEFAULTNULL,`qualify_frequency`int DEFAULTNULL,`authenticate_qualify` enum('yes','no') DEFAULTNULL,`maximum_expiration`int DEFAULTNULL,`outbound_proxy`varchar(40) DEFAULTNULL,`support_path` enum('yes','no') DEFAULTNULL,`qualify_timeout` float DEFAULTNULL,`voicemail_extension`varchar(40) DEFAULTNULL,`remove_unavailable` enum('0','1','off','on','false','true','no','yes') DEFAULTNULL, UNIQUE KEY`id` (`id`), KEY`ps_aors_id` (`id`), KEY`ps_aors_qualifyfreq_contact` (`qualify_frequency`,`contact`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client*/;---- Dumping data for table `ps_aors`--LOCK TABLES`ps_aors` WRITE;/*!40000 ALTER TABLE `ps_aors` DISABLE KEYS*/;INSERT INTO`ps_aors`VALUES ('6001',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);/*!40000 ALTER TABLE `ps_aors` ENABLE KEYS*/;UNLOCK TABLES;---- Table structure for table `ps_auths`--DROPTABLE IF EXISTS`ps_auths`;/*!40101 SET @saved_cs_client = @@character_set_client*/;/*!50503 SET character_set_client = utf8mb4*/;CREATETABLE `ps_auths` (`id`varchar(40)NOT NULL,`auth_type` enum('md5','userpass','google_oauth') DEFAULTNULL,`nonce_lifetime`int DEFAULTNULL,`md5_cred`varchar(40) DEFAULTNULL,`password`varchar(80) DEFAULTNULL,`realm`varchar(40) DEFAULTNULL,`username`varchar(40) DEFAULTNULL,`refresh_token`varchar(255) DEFAULTNULL,`oauth_clientid`varchar(255) DEFAULTNULL,`oauth_secret`varchar(255) DEFAULTNULL, UNIQUE KEY`id` (`id`), KEY`ps_auths_id` (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client*/;---- Dumping data for table `ps_auths`--LOCK TABLES`ps_auths` WRITE;/*!40000 ALTER TABLE `ps_auths` DISABLE KEYS*/;INSERT INTO`ps_auths`VALUES ('6001','userpass',NULL,NULL,'6001',NULL,'6001',NULL,NULL,NULL);/*!40000 ALTER TABLE `ps_auths` ENABLE KEYS*/;UNLOCK TABLES;---- Table structure for table `ps_endpoints`--DROPTABLE IF EXISTS`ps_endpoints`;/*!40101 SET @saved_cs_client = @@character_set_client*/;/*!50503 SET character_set_client = utf8mb4*/;CREATETABLE `ps_endpoints` (`id`varchar(40)NOT NULL,`name`varchar(255) DEFAULTNULL,`credits`intNOT NULL DEFAULT'0',`transport`varchar(40) DEFAULTNULL,`aors`varchar(200) DEFAULTNULL,`auth`varchar(40) DEFAULTNULL,`context`varchar(40) DEFAULTNULL,`disallow`varchar(200) DEFAULTNULL,`allow`varchar(200) DEFAULTNULL,`direct_media` enum('yes','no') DEFAULTNULL,`connected_line_method` enum('invite','reinvite','update') DEFAULTNULL,`direct_media_method` enum('invite','reinvite','update') DEFAULTNULL,`direct_media_glare_mitigation` enum('none','outgoing','incoming') DEFAULTNULL,`disable_direct_media_on_nat` enum('yes','no') DEFAULTNULL,`dtmf_mode` enum('rfc4733','inband','info','auto','auto_info') DEFAULTNULL,`external_media_address`varchar(40) DEFAULTNULL,`force_rport` enum('yes','no') DEFAULTNULL,`ice_support` enum('yes','no') DEFAULTNULL,`identify_by`varchar(80) DEFAULTNULL,`mailboxes`varchar(40) DEFAULTNULL,`moh_suggest`varchar(40) DEFAULTNULL,`outbound_auth`varchar(40) DEFAULTNULL,`outbound_proxy`varchar(40) DEFAULTNULL,`rewrite_contact` enum('yes','no') DEFAULTNULL,`rtp_ipv6` enum('yes','no') DEFAULTNULL,`rtp_symmetric` enum('yes','no') DEFAULTNULL,`send_diversion` enum('yes','no') DEFAULTNULL,`send_pai` enum('yes','no') DEFAULTNULL,`send_rpid` enum('yes','no') DEFAULTNULL,`timers_min_se`int DEFAULTNULL,`timers` enum('forced','no','required','yes') DEFAULTNULL,`timers_sess_expires`int DEFAULTNULL,`callerid`varchar(40) DEFAULTNULL,`callerid_privacy` enum('allowed_not_screened','allowed_passed_screened','allowed_failed_screened','allowed','prohib_not_screened','prohib_passed_screened','prohib_failed_screened','prohib','unavailable') DEFAULTNULL,`callerid_tag`varchar(40) DEFAULTNULL,`100rel` enum('no','required','yes') DEFAULTNULL,`aggregate_mwi` enum('yes','no') DEFAULTNULL,`trust_id_inbound` enum('yes','no') DEFAULTNULL,`trust_id_outbound` enum('yes','no') DEFAULTNULL,`use_ptime` enum('yes','no') DEFAULTNULL,`use_avpf` enum('yes','no') DEFAULTNULL,`media_encryption` enum('no','sdes','dtls') DEFAULTNULL,`inband_progress` enum('yes','no') DEFAULTNULL,`call_group`varchar(40) DEFAULTNULL,`pickup_group`varchar(40) DEFAULTNULL,`named_call_group`varchar(40) DEFAULTNULL,`named_pickup_group`varchar(40) DEFAULTNULL,`device_state_busy_at`int DEFAULTNULL,`fax_detect` enum('yes','no') DEFAULTNULL,`t38_udptl` enum('yes','no') DEFAULTNULL,`t38_udptl_ec` enum('none','fec','redundancy') DEFAULTNULL,`t38_udptl_maxdatagram`int DEFAULTNULL,`t38_udptl_nat` enum('yes','no') DEFAULTNULL,`t38_udptl_ipv6` enum('yes','no') DEFAULTNULL,`tone_zone`varchar(40) DEFAULTNULL,`language`varchar(40) DEFAULTNULL,`one_touch_recording` enum('yes','no') DEFAULTNULL,`record_on_feature`varchar(40) DEFAULTNULL,`record_off_feature`varchar(40) DEFAULTNULL,`rtp_engine`varchar(40) DEFAULTNULL,`allow_transfer` enum('yes','no') DEFAULTNULL,`allow_subscribe` enum('yes','no') DEFAULTNULL,`sdp_owner`varchar(40) DEFAULTNULL,`sdp_session`varchar(40) DEFAULTNULL,`tos_audio`varchar(10) DEFAULTNULL,`tos_video`varchar(10) DEFAULTNULL,`sub_min_expiry`int DEFAULTNULL,`from_domain`varchar(40) DEFAULTNULL,`from_user`varchar(40) DEFAULTNULL,`mwi_from_user`varchar(40) DEFAULTNULL,`dtls_verify`varchar(40) DEFAULTNULL,`dtls_rekey`varchar(40) DEFAULTNULL,`dtls_cert_file`varchar(200) DEFAULTNULL,`dtls_private_key`varchar(200) DEFAULTNULL,`dtls_cipher`varchar(200) DEFAULTNULL,`dtls_ca_file`varchar(200) DEFAULTNULL,`dtls_ca_path`varchar(200) DEFAULTNULL,`dtls_setup` enum('active','passive','actpass') DEFAULTNULL,`srtp_tag_32` enum('yes','no') DEFAULTNULL,`media_address`varchar(40) DEFAULTNULL,`redirect_method` enum('user','uri_core','uri_pjsip') DEFAULTNULL,`set_var`text,`cos_audio`int DEFAULTNULL,`cos_video`int DEFAULTNULL,`message_context`varchar(40) DEFAULTNULL,`force_avp` enum('yes','no') DEFAULTNULL,`media_use_received_transport` enum('yes','no') DEFAULTNULL,`accountcode`varchar(80) DEFAULTNULL,`user_eq_phone` enum('yes','no') DEFAULTNULL,`moh_passthrough` enum('yes','no') DEFAULTNULL,`media_encryption_optimistic` enum('yes','no') DEFAULTNULL,`rpid_immediate` enum('yes','no') DEFAULTNULL,`g726_non_standard` enum('yes','no') DEFAULTNULL,`rtp_keepalive`int DEFAULTNULL,`rtp_timeout`int DEFAULTNULL,`rtp_timeout_hold`int DEFAULTNULL,`bind_rtp_to_media_address` enum('yes','no') DEFAULTNULL,`voicemail_extension`varchar(40) DEFAULTNULL,`mwi_subscribe_replaces_unsolicited` enum('0','1','off','on','false','true','no','yes') DEFAULTNULL,`deny`varchar(95) DEFAULTNULL,`permit`varchar(95) DEFAULTNULL,`acl`varchar(40) DEFAULTNULL,`contact_deny`varchar(95) DEFAULTNULL,`contact_permit`varchar(95) DEFAULTNULL,`contact_acl`varchar(40) DEFAULTNULL,`subscribe_context`varchar(40) DEFAULTNULL,`fax_detect_timeout`int DEFAULTNULL,`contact_user`varchar(80) DEFAULTNULL,`preferred_codec_only` enum('yes','no') DEFAULTNULL,`asymmetric_rtp_codec` enum('yes','no') DEFAULTNULL,`rtcp_mux` enum('yes','no') DEFAULTNULL,`allow_overlap` enum('yes','no') DEFAULTNULL,`refer_blind_progress` enum('yes','no') DEFAULTNULL,`notify_early_inuse_ringing` enum('yes','no') DEFAULTNULL,`max_audio_streams`int DEFAULTNULL,`max_video_streams`int DEFAULTNULL,`webrtc` enum('yes','no') DEFAULTNULL,`dtls_fingerprint` enum('SHA-1','SHA-256') DEFAULTNULL,`incoming_mwi_mailbox`varchar(40) DEFAULTNULL,`bundle` enum('yes','no') DEFAULTNULL,`dtls_auto_generate_cert` enum('yes','no') DEFAULTNULL,`follow_early_media_fork` enum('yes','no') DEFAULTNULL,`accept_multiple_sdp_answers` enum('yes','no') DEFAULTNULL,`suppress_q850_reason_headers` enum('yes','no') DEFAULTNULL,`trust_connected_line` enum('0','1','off','on','false','true','no','yes') DEFAULTNULL,`send_connected_line` enum('0','1','off','on','false','true','no','yes') DEFAULTNULL,`ignore_183_without_sdp` enum('0','1','off','on','false','true','no','yes') DEFAULTNULL,`codec_prefs_incoming_offer`varchar(128) DEFAULTNULL,`codec_prefs_outgoing_offer`varchar(128) DEFAULTNULL,`codec_prefs_incoming_answer`varchar(128) DEFAULTNULL,`codec_prefs_outgoing_answer`varchar(128) DEFAULTNULL,`stir_shaken` enum('0','1','off','on','false','true','no','yes') DEFAULTNULL,`send_history_info` enum('0','1','off','on','false','true','no','yes') DEFAULTNULL,`allow_unauthenticated_options` enum('0','1','off','on','false','true','no','yes') DEFAULTNULL,`t38_bind_udptl_to_media_address` enum('0','1','off','on','false','true','no','yes') DEFAULTNULL, UNIQUE KEY`id` (`id`), KEY`ps_endpoints_id` (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client*/;---- Dumping data for table `ps_endpoints`--LOCK TABLES`ps_endpoints` WRITE;/*!40000 ALTER TABLE `ps_endpoints` DISABLE KEYS*/;INSERT INTO`ps_endpoints`VALUES ('6001',NULL,0,'transport-udp','6001','6001','from-internal','all','ulaw',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);/*!40000 ALTER TABLE `ps_endpoints` ENABLE KEYS*/;UNLOCK TABLES;/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE*/;/*!40101 SET SQL_MODE=@OLD_SQL_MODE*/;/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS*/;/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS*/;/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT*/;/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS*/;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION*/;/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES*/;-- Dump completed on 2022-03-24 18:52:53
login any softphone e.g. zoiper or linphone with these credentials.