AO Logo
 
  
  
  
AOServ Protocols
AO
AO Industries, Inc.
Application Infrastructure ProviderApplication Infrastructure Provider
Sign UpWhat's NewClient AreaContact UsSite Map
 
your location:   home page ··· aoserv platform ··· software components ··· aoserv client ··· tables ··· public tables ··· aoserv protocols

TABLE NAME

aoserv_protocols

DESCRIPTION

aoserv_protocols keeps track of the different versions of the protocol and what is available in that protocol.

TABLE ROWS

versioncreatedcommentslastUsed
1.0a1002003-07-08Last release before API version support.
1.0a1012003-07-15Multiple API version support added added table backup_reports
1.0a1022003-09-15Added mod_php support to Apache and private Apache instances.
1.0a1032003-10-04added column businesses.can_see_prices. added column httpd_servers.use_mod_perl.
1.0a1042003-10-14Simplified monitoring info on net_binds to just monitoring_enabled added column ao_servers.monitoring_passwords Improved protocol version support
1.0a1052003-10-21Added user control over net_binds. added column protocols.is_user_service added column protocols.net_protocol added column failover_file_replications.max_bit_rate added table email_blacklists Converted distro_files.file_md5 to distro_files.file_md5_hi and distro_files.file_md5_lo.
1.0a1062003-11-08added column email_blacklists.spamhaus_lists.
1.0a1072003-11-10To support backing up Windows servers, make necessary columns of file_backups nullable.
1.0a1082003-12-26ao_servers.emailmon_password is now nullable. ao_servers.ftpmon_password is now nullable. added column operating_system_versions.architecture. added column operating_system_versions.is_aoserv_daemon_supported. added column architectures.bits. removed column servers.architecture added column servers.asset_label. Modified syntax and protocol for add_business_server AOSH command, dropped support for previous versions. added column distro_files.pkey. added column distro_files.operating_system_version. distro_files.path is no longer unique. added column technology_versions.operating_system_version.
1.0a1092004-01-14removed support for REMOVE_UNUSED_BACKUP_DATAS command. Compatibly and silently ignored for previous versions of clients. removed column file_backup_stats.delete_unused_backup_data1 removed column file_backup_stats.delete_unused_backup_data2
1.0a1102004-02-10removed column postgres_versions.default_port
1.0a1112004-02-25added column mysql_db_users.create_tmp_table_priv added column mysql_db_users.lock_tables_priv added column mysql_users.show_db_priv added column mysql_users.super_priv added column mysql_users.create_tmp_table_priv added column mysql_users.lock_tables_priv added column mysql_users.execute_priv added column mysql_users.repl_slave_priv added column mysql_users.repl_client_priv added column mysql_server_users.max_connections added table net_tcp_redirects
1.0a1122004-03-19renamed column net_devices.delete_redhat_route to net_devices.delete_route added column net_devices.network added column net_devices.broadcast
1.0a1132004-03-22removed column private_ftp_servers.ip_address added column private_ftp_servers.net_bind added column private_ftp_servers.allow_anonymous
1.0a1142004-05-10changed interbase_databases.backup_retention to short added column interbase_databases.backup_level
1.0a1152004-07-01added column interbase_server_users.predisable_password
1.0a1162004-09-20added table email_attachment_types added table email_attachment_blocks
1.0a1172004-11-10added column backup_partitions.fill_order
1.0a1182004-11-28added column business_administrators.can_switch_users remove column master_users.can_switch_users
1.0a1192004-11-29added column ao_servers.daemon_connect_bind
1.0a1202005-02-20added table email_sa_integration_modes added column linux_server_accounts.junk_email_retention added column linux_server_accounts.sa_integration_mode
1.0a1212005-02-25added column postgres_versions.minor_version
1.0a1222005-03-18removed column email_blacklists
1.0a1232005-04-27removed table limits removed table rates removed table service_levels added table package_categories added table package_definitions added table package_definition_limits added column packages.package_definition added column resources.singular_display_unit added column resources.plural_display_unit added column resources.per_unit added table transaction_types changed monthly_charges.type to reference new transaction_types table changed transactions.type to reference new transaction_types table removed column businesses.can_set_prices removed column httpd_servers.price removed column ip_addresses.price removed column packages.level removed column packages.rate removed column packages.user_limit removed column packages.additional_user_rate removed column packages.pop_limit removed column packages.additional_pop_rate removed column private_ftp_servers.price removed column resources.unit
1.0a1242005-05-19added column linux_server_accounts.sa_required_score
1.0a1252005-05-20added column tickets.assigned_to added column tickets.contact_emails added column tickets.contact_phone_numbers
1.0a1262005-05-24removed column tickets.package added column tickets.accounting removed column tickets.administrator added column tickets.created_by
1.0a1272005-07-21added column dns_zones.ttl added column dns_records.ttl
1.0a1282005-12-01added column net_devices.mac_address changed transactions.apr_num to text type
1.0a1292005-12-04added column httpd_sites.awstats_skip_files
1.0a1302005-12-16added column httpd_servers.timeout
1.12006-02-13removed table net_device_host_routes removed table net_device_local_routes removed column postgres_server_users.usesysid removed column postgres_servers.last_postgres_usesysid
1.22006-02-20added column net_devices.max_bit_rate added table time_zones added column ao_servers.time_zone
1.32006-02-23added column operating_system_versions.sort_order
1.42006-03-11added table mysql_servers removed column mysql_backups.ao_server added column mysql_backups.mysql_server removed table mysql_hosts removed column mysql_databases.ao_server added column mysql_databases.mysql_server removed column mysql_server_users.ao_server added column mysql_server_users.mysql_server removed column ao_servers.is_mysql added column technologies.pkey added column schema_tables.default_order_by added column mysql_db_users.create_view_priv added column mysql_db_users.show_view_priv added column mysql_db_users.create_routine_priv added column mysql_db_users.alter_routine_priv added column mysql_db_users.execute_priv added column mysql_users.create_view_priv added column mysql_users.show_view_priv added column mysql_users.create_routine_priv added column mysql_users.alter_routine_priv added column mysql_users.create_user_priv added column mysql_server_users.max_questions added column mysql_server_users.max_updates added column mysql_server_users.max_user_connections
1.52006-04-02added table httpd_tomcat_data_sources added table httpd_tomcat_parameters
1.62006-05-01changed return type from boolean to int for is_linux_server_account_procmail_manual
1.72006-05-22added column ao_servers.jilter_bind
1.82006-05-23added column ao_servers.restrict_outbound_email
1.92006-05-29added column failover_file_replications.use_compression added column aoserv_protocols.last_used
1.102006-06-06made tickets.admin_priority nullable and null by default
1.112006-07-03added column ao_servers.daemon_connect_address
1.122006-07-19added column ao_servers.failover_batch_size
1.132006-07-20added column ao_servers.retention
1.142006-07-26added column failover_file_replications.connect_address
1.152006-09-20added column failover_file_replications.enabled
1.162006-09-27added column servers.minimum_power added column servers.maximum_power
1.172006-10-09added column failover_file_replications.to_path added column failover_file_replications.chunk_always
1.182006-10-11added table httpd_site_authenticated_locations
1.192006-11-27added column httpd_site_binds.redirect_to_primary_hostname
1.202007-02-04added table whois_history
1.212007-02-12added table business_administrator_permissions added table aoserv_permissions
1.222007-03-20added column failover_file_replications.connect_from
1.232007-05-01added table encryption_keys added table signup_request_options added table signup_requests
1.242007-05-13added column packages.email_in_burst added column packages.email_in_rate added column packages.email_out_burst added column packages.email_out_rate added column packages.email_relay_burst added column packages.email_relay_rate
1.252007-05-15changed encryption_keys.recipient to encryption_keys.id changed encryption_keys.use_signup_requests to encryption_keys.signup_signer added column encryption_keys.signup_recipient changed encryption_keys.use_credit_cards to encryption_keys.credit_card_signer added column encryption_keys.credit_card_recipient
1.262007-05-24added column server_farms.use_restricted_smtp_port
1.272007-06-08added column postgres_versions.postgis_version added column postgres_databases.enable_postgis
1.282007-06-12added table failover_mysql_replications added column mysql_servers.package
1.292007-06-21updated credit_cards table to support new ao-credit-cards package added credit_card_providers table to support new ao-credit-cards package added credit_card_transactions table to support new ao-credit-cards package
1.302008-03-18updated ip_address.ping_monitor_enabled
1.312008-04-12removed table backup_data removed table backup_levels removed column backup_partitions.device removed column backup_partitions.minimum_free_space removed column backup_partitions.desired_free_space removed column backup_partitions.fill_order removed table file_backups removed table file_backup_devices removed table file_backup_roots removed table file_backup_stats removed table file_paths removed table interbase_backups removed table mysql_backups removed table postgres_backups removed column cvs_repositories.backup_level removed column cvs_repositories.backup_retention removed column linux_server_accounts.cron_backup_level removed column linux_server_accounts.cron_backup_retention removed column linux_server_accounts.home_backup_level removed column linux_server_accounts.home_backup_retention removed column linux_server_accounts.inbox_backup_level removed column linux_server_accounts.inbox_backup_retention removed column httpd_shared_tomcats.config_backup_level removed column httpd_shared_tomcats.config_backup_retention removed column httpd_shared_tomcats.file_backup_level removed column httpd_shared_tomcats.file_backup_retention removed column httpd_shared_tomcats.log_backup_level removed column httpd_shared_tomcats.log_backup_retention removed column httpd_sites.config_backup_level removed column httpd_sites.config_backup_retention removed column httpd_sites.file_backup_level removed column httpd_sites.file_backup_retention removed column httpd_sites.ftp_backup_level removed column httpd_sites.ftp_backup_retention removed column httpd_sites.log_backup_level removed column httpd_sites.log_backup_retention removed column email_lists.backup_level removed column email_lists.backup_retention removed column interbase_databases.backup_level removed column interbase_databases.backup_retention removed column file_backup_settings.backup_level added column file_backup_settings.backup_enabled removed column file_backup_settings.backup_retention removed column mysql_databases.backup_level removed column mysql_databases.backup_retention removed column postgres_databases.backup_level removed column postgres_databases.backup_retention removed column majordomo_servers.backup_level removed column majordomo_servers.backup_retention removed column servers.backup_hour removed column servers.last_backup_time removed column server_farms.protected_net removed column server_farms.allow_same_server_backup removed column server_farms.backup_farm removed table server_reports removed table sr_cpu removed table sr_db_mysql removed table sr_db_postgres removed table sr_disk_access removed table sr_disk_mdstat removed table sr_disk_space removed table sr_kernel removed table sr_load removed table sr_memory removed table sr_net_devices removed table sr_net_icmp removed table sr_net_ip removed table sr_net_tcp removed table sr_net_udp removed table sr_num_users removed table sr_paging removed table sr_processes removed table sr_swap_rate removed table sr_swap_size removed table sendmail_smtp_stats removed table interbase_databases removed table interbase_db_groups removed table interbase_reserved_words removed table interbase_server_users removed table interbase_users removed column packages.daily_smtp_in_limit removed column packages.daily_smtp_in_bandwidth_limit removed column packages.daily_smtp_out_limit removed column packages.daily_smtp_out_bandwidth_limit removed column ao_servers.num_cpu removed column ao_servers.cpu_speed removed column ao_servers.ram removed column ao_servers.rack removed column ao_servers.disk removed column ao_servers.wildcard_https removed column ao_servers.is_interbase removed column ao_servers.is_dns removed column ao_servers.is_router removed column ao_servers.iptables_name removed column ao_servers.server_report_delay removed column ao_servers.server_report_interval removed column ao_servers.is_qmail removed column ao_servers.xeroscape_name removed column ao_servers.value removed column ao_servers.monitoring_enabled removed column ao_servers.emailmon_password removed column ao_servers.ftpmon_password removed column servers.owner removed column servers.administrator removed column servers.asset_label removed column servers.minimum_power removed column servers.maximum_power removed column servers.hostname added column servers.package added column servers.name (unique per package) added column ao_servers.hostname removed column business_servers.can_control_interbase removed AOSH command set_httpd_shared_tomcat_config_backup_retention removed AOSH command set_httpd_shared_tomcat_file_backup_retention removed AOSH command set_httpd_shared_tomcat_log_backup_retention removed AOSH command set_linux_server_account_cron_backup_retention removed AOSH command set_linux_server_account_home_backup_retention removed AOSH command set_linux_server_account_inbox_backup_retention removed AOSH command set_httpd_site_config_backup_retention removed AOSH command set_httpd_site_file_backup_retention removed AOSH command set_httpd_site_ftp_backup_retention removed AOSH command set_httpd_site_log_backup_retention removed AOSH command set_cvs_repository_backup_retention removed AOSH command set_email_list_backup_retention removed AOSH command set_majordomo_server_backup_retention removed AOSH command set_mysql_database_backup_retention removed AOSH command set_postgres_database_backup_retention removed AOSH command backup_mysql_database removed AOSH command backup_interbase_database removed AOSH command backup_postgres_database removed AOSH command restart_interbase removed AOSH command start_interbase removed AOSH command stop_interbase removed AOSH command get_backup_data removed AOSH command get_file_backup removed AOSH command remove_file_backup removed AOSH command add_file_backup_device removed AOSH command get_interbase_backup removed AOSH command remove_interbase_backup removed AOSH command get_mysql_backup removed AOSH command remove_mysql_backup removed AOSH command get_postgres_backup removed AOSH command remove_postgres_backup removed AOSH command add_sendmail_smtp_stat removed AOSH command add_interbase_database removed AOSH command check_interbase_database_name removed AOSH command dump_interbase_database removed AOSH command generate_interbase_database_name removed AOSH command is_interbase_database_name_available removed AOSH command remove_interbase_database removed AOSH command add_interbase_db_group removed AOSH command check_interbase_db_group_name removed AOSH command generate_interbase_db_group_name removed AOSH command is_interbase_db_group_name_available removed AOSH command remove_interbase_db_group removed AOSH command add_interbase_server_user removed AOSH command disable_interbase_server_user removed AOSH command enable_interbase_server_user removed AOSH command is_interbase_server_user_password_set removed AOSH command remove_interbase_server_user removed AOSH command set_interbase_server_user_password removed AOSH command add_interbase_user removed AOSH command are_interbase_user_passwords_set removed AOSH command check_interbase_password removed AOSH command check_interbase_username removed AOSH command disable_interbase_user removed AOSH command enable_interbase_user removed AOSH command remove_interbase_user removed AOSH command set_interbase_user_password removed AOSH command wait_for_interbase_rebuild removed column file_backup_settings.package removed column business_servers.can_configure_backup deleted from aoserv_permissions: set_interbase_server_user_password updated AOSH command add_file_backup_setting updated AOSH command set_file_backup_setting updated AOSH command remove_file_backup_setting updated AOSH command add_business_server updated AOSH command invalidate updated AOSH command invalidate ao_servers.hostname, servers.package.name||'/'||servers.name, or servers.pkey removed column file_backup_settings.recurse removed column failover_file_replications.from_server added column failover_file_replications.server removed column failover_file_replications.to_server removed column failover_file_replications.to_path added column failover_file_replications.backup_partition removed column failover_file_replications.last_start_time removed column failover_file_replications.chunk_always added column failover_file_replications.quota_gid added column backup_partitions.quota_enabled added column failover_file_schedule.minute removed column file_backup_settings.server added column file_backup_settings.replication removed column schema_table.default_order_by because there is not an easy way to provide cross-version compatibility removed column schema_table.dataverse_editor removed column schema_foreign_keys.is_bridge removed column schema_foreign_keys.tied_bridge renamed column email_lists.linux_account to linux_server_account renamed column email_lists.linux_group to linux_server_group renamed column mysql_db_users.mysql_user to mysql_server_user removed table phone_numbers removed column linux_acc_addresses.linux_account added column linux_acc_addresses.linux_server_account added column signup_requests.encryption_recipient removed column signup_requests.encryption_key added column signup_requests.encryption_from removed column encryption_keys.credit_card_signer removed column encryption_keys.credit_card_recipient removed column encryption_keys.signup_signer added column encryption_keys.signup_from added column credit_card_processors.encryption_from added column credit_card_processors.encryption_recipient added column credit_cards.encrypted_card_number added column credit_cards.encryption_card_number_from added column credit_cards.encryption_card_number_recipient added column credit_cards.encrypted_card_expiration added column credit_cards.encrypted_expiration added column credit_cards.encryption_expiration_from added column credit_cards.encryption_expiration_recipient removed column backup_reports.uncompressed_size removed column backup_reports.compressed_size removed column daemon_profile.server added column daemon_profile.ao_server
1.322008-06-28added column servers.monitoring_enabled
1.332008-08-15renamed column net_devices.ao_server to server, references servers instead of ao_servers renamed column net_binds.ao_server to server, references servers instead of ao_servers
1.342008-08-17added column ip_addresses.external_ip_address
1.352008-10-24added column ao_servers.monitoring_load_low added column ao_servers.monitoring_load_medium added column ao_servers.monitoring_load_high added column ao_servers.monitoring_load_critical added column net_devices.monitoring_bit_rate_low added column net_devices.monitoring_bit_rate_medium added column net_devices.monitoring_bit_rate_high added column net_devices.monitoring_bit_rate_critical
1.362008-11-15added table disk_types added table physical_servers added table processor_types added table racks added table raid_types added table virtual_disks added table virtual_servers
1.372008-11-16added column physical_servers.supports_hvm added column virtual_servers.requires_hvm
1.382008-11-30removed column net_devices.netmask added column ip_addresses.netmask
1.392008-12-01removed column private_ftp_servers.root removed column private_ftp_servers.linux_server_group
1.402008-12-09added column linux_server_accounts.sa_discard_score
1.412009-03-12renamed column virtual_servers.primary_minimum_processor_type to minimum_processor_type removed column virtual_servers.secondary_minimum_processor_type renamed column virtual_servers.primary_minimum_processor_speed to minimum_processor_speed removed column virtual_servers.secondary_minimum_processor_speed renamed column virtual_servers.primary_processor_cores to processor_cores removed column virtual_servers.secondary_processor_cores renamed column virtual_servers.primary_processor_weight to processor_weight removed column virtual_servers.secondary_processor_weight removed column virtual_servers.primary_physical_server removed column virtual_servers.secondary_physical_server renamed column virtual_disks.primary_minimum_raid_type to minimum_raid_type removed column virtual_disks.secondary_minimum_raid_type renamed column virtual_disks.primary_minimum_disk_type to minimum_disk_type removed column virtual_disks.secondary_minimum_disk_type renamed column virtual_disks.primary_minimum_disk_speed to minimum_disk_speed removed column virtual_disks.secondary_minimum_disk_speed renamed column virtual_disks.primary_weight to weight removed column virtual_disks.secondary_weight
1.422009-03-15removed column virtual_disks.minimum_raid_type removed column virtual_disks.minimum_disk_type removed table disk_types removed table raid_types
1.432009-03-18added column virtual_servers.primary_ram_target added column virtual_servers.secondary_ram_target added column virtual_servers.minimum_processor_speed_target added column virtual_servers.processor_cores_target added column virtual_servers.processor_weight_target added column virtual_disks.minimum_disk_speed_target added column virtual_disks.weight_target removed column virtual_disks.primary_physical_volumes_locked removed column virtual_disks.secondary_physical_volumes_locked
1.442009-05-16removed table actions added table ticket_actions removed table action_types added table ticket_action_types added table brands added table languages added table resellers added table ticket_assignments added table ticket_brand_categories added table ticket_categories added column business_administrators.support_code removed column master_users.is_ticket_admin removed column package_definitions.accounting added column package_definitions.brand removed column signup_requests.accounting added column signup_requests.brand removed column ticket_stati.description added column ticket_stati.sort_order removed column ticket_types.description removed column ticket_types.client_view added column tickets.reseller added column tickets.language added column tickets.category added column tickets.from_address added column tickets.summary made tickets.details nullable added column tickets.raw_email removed column tickets.deadline removed column tickets.close_date removed column tickets.closed_by removed column tickets.technology removed column tickets.assigned_to added column tickets.status_timeout added column tickets.internal_notes removed column encryption_keys.signup_from removed column encryption_keys.signup_recipient removed GET_OBJECT(actions) command removed GET_ACTIONS_TICKET command removed GET_ACTIONS_BUSINESS_ADMINISTRATOR command removed GET_CACHED_ROW_COUNT(actions) command removed GET_ROW_COUNT(actions) command removed GET_CACHED_ROW_COUNT(tickets) command removed GET_ROW_COUNT(tickets) command removed GET_OBJECT(tickets) command removed GET_TICKETS_BUSINESS_ADMINISTRATOR command removed GET_TICKETS_BUSINESS command removed GET_TICKETS_CREATED_BUSINESS_ADMINISTRATOR command removed GET_TICKETS_CLOSED_BUSINESS_ADMINISTRATOR command removed change_ticket_deadline AOSH command removed change_ticket_technology AOSH command updated add_business_administrator command removed ticket-related AOSH commands
1.452009-06-11removed column package_definitions.brand added column package_definitions.accounting
1.462009-06-12added column tickets.brand added column brands.smtp_host added column brands.imap_host
1.472009-06-13Cache invalidation signals only require response from client when a server is waiting for synchronous invalidation
1.482009-06-24added from_address to add_ticket command
1.492009-06-25added column ticket_actions.old_type added column ticket_actions.new_type
1.502009-07-17made ticket_actions.administrator nullable for master-generated actions
1.512009-07-19removed REQUEST_DAEMON_ACCESS added REQUEST_REPLICATION_DAEMON_ACCESS added REQUEST_VNC_CONSOLE_DAEMON_ACCESS added column business_servers.can_vnc_console added column virtual_servers.vnc_password
1.522009-07-21added column brands.aoweb_struts_vnc_bind
1.532009-07-22added column brands.aoweb_struts_keystore_type added column brands.aoweb_struts_keystore_password
1.542009-07-29added column mysql_users.event_priv added column mysql_users.trigger_priv added column mysql_db_users.event_priv added column mysql_db_users.trigger_priv
1.552009-08-01added get_mysql_table_status command
1.562009-08-06added column failover_mysql_replications.monitoring_seconds_behind_low added column failover_mysql_replications.monitoring_seconds_behind_medium added column failover_mysql_replications.monitoring_seconds_behind_high added column failover_mysql_replications.monitoring_seconds_behind_critical
1.572009-08-22added table email_smtp_smart_hosts added table email_smtp_smart_host_domains added column servers.smtp_smart_host
1.582009-09-21added column net_binds.monitoring_parameters
1.592009-10-08added column failover_mysql_replications.ao_server made failover_mysql_replications.replication nullable
1.602009-10-09now checking the table status on MySQL slaves
1.612009-12-05removed column package_categories.display removed column resources.singular_display_unit removed column resources.plural_display_unit removed column resources.per_unit removed column resources.description removed column transaction_types.display removed column transaction_types.description removed column transaction_types.unit
1.622012-03-26added column file_backup_settings.required converted failover_file_replications.max_bit_rate to long
1.632012-06-06added column physical_servers.ups_type
1.642012-07-09added create_virtual_server command added reboot_virtual_server command added shutdown_virtual_server command added destroy_virtual_server command added pause_virtual_server command added unpause_virtual_server command added get_virtual_server_status command added column business_servers.can_control_virtual_server
1.652012-08-13added table ip_reputation_sets added table ip_reputation_set_hosts added table ip_reputation_set_networks added column master_users.is_router
1.662012-08-30renamed column ip_reputation_set_hosts.set_fkey to set renamed column ip_reputation_set_networks.set_fkey to set added table ip_reputation_limiters added table ip_reputation_limiter_limits added table ip_reputation_limiter_sets
1.672012-10-18added gm and bm classes to ip_reputation_limiter_limits added column ip_reputation_sets.last_reputation_added changed ip_reputation_set_hosts.host to ip_address type changed ip_reputation_set_networks.network to ip_address type
1.682013-03-18added column httpd_servers.max_concurrency
1.692013-03-21changed business_administrators.birthday to date type changed linux_server_accounts.created to time type changed linux_server_groups.created to time type added column tickets.status_timeout added column tickets.internal_notes added domain_label to schema_types added domain_labels to schema_types added domain_name to schema_types added gecos to schema_types added group_id to schema_types added hashed_password to schema_types added linux_id to schema_types added mac_address to schema_types added money to schema_types added mysql_database_name to schema_types added mysql_server_name to schema_types added mysql_table_name to schema_types added mysql_username to schema_types added net_port to schema_types added postgres_database_name to schema_types added postgres_server_name to schema_types added postgres_username to schema_types changed ao_servers.daemon_connect_address to hostname type changed failover_file_replications.connect_address to hostname type changed failover_file_log.connect_from to ip_address type added AAAA to dns_types changed mysql_server_users.host to string type changed ao_servers.daemon_key to hashed_password type changed business_administrators.password to hashed_password type changed ao_servers.hostname to domain_name type changed brands.nameserver1 to domain_name type changed brands.nameserver2 to domain_name type changed brands.nameserver3 to domain_name type changed brands.nameserver4 to domain_name type changed daemon_profile.ao_server to domain_name type changed dns_records.domain to string type changed dns_tlds.domain to domain_name type changed email_domains.domain to domain_name type changed email_smtp_smart_host_domains.domain to domain_name type changed httpd_site_urls.hostname to domain_name type changed ip_addresses.hostname to domain_name type and made nullable changed email_smtp_relays.host to hostname type changed private_ftp_servers.hostname to domain_name type changed bank_transactions.transid to pkey type changed net_tcp_redirects.net_bind to fkey type changed private_ftp_servers.linux_server_account to fkey type changed dns_records.dhcp_address to fkey type changed linux_server_accounts.uid to fkey type changed linux_server_groups.gid to fkey type changed linux_ids.id to pkey type changed failover_file_replications.quota_gid to fkey type changed transactions.transid to pkey type changed notice_log.transid to fkey type changed net_ports.port to pkey type changed net_binds.port to fkey type changed net_tcp_redirects.destination_port to fkey type changed protocols.port to fkey type changed postgres_server_users.postgres_server to fkey type changed brands.support_toll_free to phone type changed brands.support_day_phone to phone type changed brands.support_emergency_phone1 to phone type changed brands.support_emergency_phone2 to phone type changed brands.support_fax to phone type changed signup_requests.business_phone to phone type changed signup_requests.business_fax to phone type changed signup_requests.ba_work_phone to phone type changed signup_requests.ba_cell_phone to phone type changed signup_requests.ba_home_phone to phone type changed signup_requests.ba_fax to phone type changed linux_accounts.name to gecos type changed linux_accounts.office_location to gecos type changed linux_accounts.office_phone to gecos type changed linux_accounts.home_phone to gecos type added column schema_types.since_version added column schema_types.last_version removed byte from schema_types changed business_administrators.city to string type changed business_profiles.city to string type changed credit_card_transactions.shipping_city to string type changed credit_card_transactions.credit_card_city to string type changed credit_cards.city to string type changed signup_requests.business_city to string type changed signup_requests.ba_city to string type removed city from schema_types changed business_administrators.country to string type changed business_profiles.country to string type changed country_codes.code to string type changed credit_card_transactions.shipping_country_code to string type changed credit_card_transactions.credit_card_country_code to string type changed credit_cards.country_code to string type changed signup_requests.business_country to string type changed signup_requests.ba_country to string type removed country from schema_types removed octal_int from schema_types changed business_administrators.state to string type changed business_profiles.state to string type changed credit_card_transactions.shipping_state to string type changed credit_card_transactions.credit_card_state to string type changed credit_cards.state to string type changed signup_requests.business_state to string type changed signup_requests.ba_state to string type removed state from schema_types changed business_administrators.zip to string type changed business_profiles.zip to string type changed credit_card_transactions.shipping_postal_code to string type changed credit_card_transactions.credit_card_postal_code to string type changed credit_cards.postal_code to string type changed signup_requests.business_zip to string type changed signup_requests.ba_zip to string type removed zip from schema_types changed ticket_actions.old_accounting to accounting type changed ticket_actions.new_accounting to accounting type
1.702013-05-31added column net_devices.monitoring_enabled added table distro_report_types
1.712014-02-11added verify_virtual_disk command
1.722014-02-20renamed column dns_records.mx_priority to priority added column dns_records.weight added column dns_records.port updated AOSH command add_dns_record renamed column dns_types.is_mx to has_priority added column dns_types.has_weight added column dns_types.has_port added SRV to dns_types added column virtual_disks.verify_day_of_week added column virtual_disks.verify_hour_of_day
1.732014-04-01added get_primary_physical_server command added get_secondary_physical_server command
1.742014-04-23added column failover_mysql_replications.max_alert_level added column mysql_databases.max_check_table_alert_level
1.752014-06-16added column ip_addresses.check_blacklists_over_smtp added alternate syntax in AOSH for remove_dns_record command
1.762015-05-21added get_failover_file_replication_activity command
1.772015-10-16removed pseudo-table client_jvm_profile removed pseudo-table daemon_profile removed pseudo-table master_server_profile removed pseudo-table master_history2024-03-09
1.782016-01-07added column technology_versions.disable_time added column technology_versions.disable_reason added column httpd_sites.php_version
1.792016-01-09added column httpd_sites.enable_cgi
1.802016-11-29added column ao_servers.uid_min added column ao_servers.gid_min removed column linux_ids.is_system removed column distro_files.file_md5_hi removed column distro_files.file_md5_lo added column distro_files.file_sha256_0 added column distro_files.file_sha256_1 added column distro_files.file_sha256_2 added column distro_files.file_sha256_3
1.80.02017-03-30removed table linux_ids removed table net_ports removed table net_protocols removed column protocols.rtmp removed column protocols.zip changed ao_server_daemon_hosts.host to hostname type changed distro_files.group_name to group_id type changed email_pipes.path to string type renamed column email_pipes.path to command changed failover_file_replications.quota_gid to linux_id type changed httpd_sites.group_name to group_id type changed httpd_tomcat_contexts.doc_base to path type changed linux_group_accounts.group_name to group_id type changed linux_groups.name to group_id type changed linux_server_groups.name to group_id type changed linux_server_accounts.uid to linux_id type changed linux_server_groups.gid to linux_id type changed master_hosts.host to hostname type changed mysql_databases.name to mysql_database_name type removed table mysql_reserved_words changed mysql_servers.name to mysql_server_name type changed mysql_server_users.username to mysql_username type changed mysql_users.username to mysql_username type changed net_binds.port to net_port type removed column net_binds.net_protocol changed net_devices.mac_address to mac_address type changed net_tcp_redirects.destination_port to net_port type changed postgres_databases.name to postgres_database_name type removed table postgres_reserved_words changed postgres_servers.name to postgres_server_name type changed postgres_server_users.username to postgres_username type changed postgres_users.username to postgres_username type removed column protocols.net_protocol changed protocols.port to net_port type changed ticket_actions.old_assigned_to to username type changed ticket_actions.new_assigned_to to username type removed table package changed dns_zones.package to accounting type changed email_domains.package to accounting type changed email_pipes.package to accounting type changed email_smtp_relays.package to accounting type changed httpd_sites.package to accounting type changed ip_addresses.package to accounting type changed linux_groups.package to accounting type changed monthly_charges.package to accounting type changed mysql_databases.package to accounting type changed mysql_servers.package to accounting type changed net_binds.package to accounting type changed packages.name to accounting type changed usernames.package to accounting type removed check_business_administrator_username command removed check_email_forwarding command removed check_ip_address command removed check_linux_account_username command removed check_package_name command
1.80.12017-04-14linux_accounts.name is now nullable added column linux_group_accounts.operating_system_version added column linux_server_account.sudo added column httpd_sites.enable_ssi added column httpd_sites.enable_htaccess added column httpd_sites.enable_indexes added column httpd_sites.enable_follow_symlinks added column httpd_sites.enable_anonymous_ftp added parameters to add_httpd_jboss_site command for new settings added parameters to add_httpd_tomcat_shared_site command for new settings added parameters to add_httpd_tomcat_std_site command for new settings added set_httpd_site_php_version command added set_httpd_site_enable_cgi command added set_httpd_site_enable_ssi command added set_httpd_site_enable_htaccess command added set_httpd_site_enable_indexes command added set_httpd_site_enable_follow_symlinks command added set_httpd_site_enable_anonymous_ftp command added set_httpd_tomcat_site_use_apache command added column httpd_shared_tomcats.max_post_size added column httpd_shared_tomcats.unpack_wars added column httpd_shared_tomcats.auto_deploy added column httpd_tomcat_std_sites.max_post_size added column httpd_tomcat_std_sites.unpack_wars added column httpd_tomcat_std_sites.auto_deploy added set_httpd_shared_tomcat_max_post_size command added set_httpd_shared_tomcat_unpack_wars command added set_httpd_shared_tomcat_auto_deploy command added set_httpd_tomcat_std_site_max_post_size command added set_httpd_tomcat_std_site_unpack_wars command added set_httpd_tomcat_std_site_auto_deploy command
1.80.22017-07-20check_email_list_path command altered to include ao_server parameter2019-06-25
1.81.02017-08-18added firewalld_zone_name to schema_types added table firewalld_zones added table net_bind_firewalld_zones removed column net_binds.open_firewall removed set_net_bind_open_firewall command updated parameters to add_net_binds command for firewalld_zones added set_net_bind_firewalld_zones command
1.81.12017-08-30added table httpd_site_bind_redirects
1.81.22017-09-05added can_reference parameter to add_mysql_db_user command
1.81.32017-09-09added column httpd_tomcat_contexts.server_xml_configured added server_xml_configured parameter to add_httpd_tomcat_context command added server_xml_configured parameter to set_httpd_tomcat_context_attributes command
1.81.42017-10-02added column httpd_site_binds.ssl_cert_chain_file added column httpd_site_bind_redirects.no_escape, defaulting to false
1.81.52017-10-14added column ao_servers.sftp_umask
1.81.62017-10-27httpd_sites.enable_cgi now defaults to false httpd_sites.enable_ssi now defaults to false httpd_sites.enable_htaccess now defaults to false httpd_sites.enable_indexes now defaults to false httpd_sites.enable_follow_symlinks now defaults to false httpd_sites.enable_anonymous_ftp now defaults to false removed parameters from add_httpd_jboss_site command to use defaults removed parameters from add_httpd_tomcat_shared_site command to use defaults removed parameters from add_httpd_tomcat_std_site command to use defaults added column httpd_sites.block_trace_track added column httpd_sites.block_scm added column httpd_sites.block_core_dumps added column httpd_sites.block_editor_backups added set_httpd_site_block_trace_track command added set_httpd_site_block_scm command added set_httpd_site_block_core_dumps command added set_httpd_site_block_editor_backups command added column httpd_tomcat_sites.block_webinf added set_httpd_tomcat_site_block_webinf command added table httpd_tomcat_site_jk_mounts added add_httpd_tomcat_site_jk_mount command added remove_httpd_tomcat_site_jk_mount command removed column httpd_tomcat_sites.use_apache removed set_httpd_tomcat_site_use_apache command
1.81.72017-10-30added column httpd_servers.mod_access_compat added column httpd_servers.mod_actions added column httpd_servers.mod_alias added column httpd_servers.mod_auth_basic added column httpd_servers.mod_authn_core added column httpd_servers.mod_authn_file added column httpd_servers.mod_authz_core added column httpd_servers.mod_authz_groupfile added column httpd_servers.mod_authz_host added column httpd_servers.mod_authz_user added column httpd_servers.mod_autoindex added column httpd_servers.mod_deflate added column httpd_servers.mod_dir added column httpd_servers.mod_filter added column httpd_servers.mod_headers added column httpd_servers.mod_include added column httpd_servers.mod_jk added column httpd_servers.mod_log_config added column httpd_servers.mod_mime added column httpd_servers.mod_mime_magic added column httpd_servers.mod_negotiation added column httpd_servers.mod_proxy added column httpd_servers.mod_proxy_http added column httpd_servers.mod_reqtimeout added column httpd_servers.mod_rewrite added column httpd_servers.mod_setenvif added column httpd_servers.mod_socache_shmcb added column httpd_servers.mod_ssl added column httpd_servers.mod_status2019-06-25
1.81.82018-04-28renamed column httpd_servers.number to "name" and changed type from int to string
1.81.92018-05-06added column firewalld_zones.fail2ban
1.81.102018-05-12added column httpd_servers.mod_wsgi added column httpd_site_binds.include_site_config added table ssl_certificates added table ssl_certificate_alt_names added column httpd_site_binds.certificate removed column httpd_site_binds.ssl_cert_file removed column httpd_site_binds.ssl_cert_key_file removed column httpd_site_binds.ssl_cert_chain_file added check_ssl_certificate AOSH command added table cyrus_imapd_binds added table cyrus_imapd_servers added table sendmail_binds added table sendmail_servers removed AOSH command set_imap_folder_subscribed removed column httpd_servers.is_mod_jk removed column httpd_servers.max_binds removed column httpd_shared_tomcats.is_secure removed column httpd_shared_tomcats.is_overflow removed column httpd_sites.content_src removed is_secure and is_overflow parameters from add_httpd_shared_tomcat AOSH command removed content_source parameter from add_httpd_jboss_site AOSH command removed tomcat_version and content_source parameters from add_httpd_tomcat_shared_site AOSH command removed content_source parameter from add_httpd_tomcat_std_site AOSH command
1.81.112018-06-29added column httpd_servers.monitoring_concurrency_low added column httpd_servers.monitoring_concurrency_medium added column httpd_servers.monitoring_concurrency_high added column httpd_servers.monitoring_concurrency_critical added get_httpd_server_concurrency AOSH command
1.81.122018-08-25added set_httpd_shared_tomcat_version AOSH command added set_httpd_tomcat_std_site_version AOSH command
1.81.132018-10-04added column httpd_site_authenticated_locations.handler added add_httpd_site_authenticated_location AOSH command added set_httpd_site_authenticated_location_attributes AOSH command
1.81.142018-10-24added column httpd_site_binds.name
1.81.152018-10-26added table httpd_site_bind_headers2018-11-26
1.81.162018-11-12added table ssl_certificate_other_uses2018-11-26
1.81.172018-11-16added column ip_addresses.monitoring_enabled added set_ip_address_monitoring_enabled AOSH command2018-12-31
1.81.182018-11-29Renamed all columns since_version to sinceVersion Renamed all columns last_version to lastVersion Moved sinceVersion and lastVersion columns to lower column indexes aosh_command table: renamed table_name to table renamed short_desc to description schema_columns table: renamed pkey to id renamed table_name to table renamed column_name to column changed index type from int to short renamed is_nullable to isNullable renamed is_unique to isUnique renamed is_public to isPublic schema_foreign_keys table: renamed pkey to id renamed key_column to column renamed foreign_column to foreignColumn schema_tables table: renamed table_id to id, and moved to index 0 renamed is_public to isPublic schema_types table: renamed num to id, changed type from int to pkey, and moved to index 0 renamed type to name httpd_workers table: removed pkey column renamed net_bind to bind as primary key renamed code to name renamed tomcat_siite to tomcatSite ip_addresses table: renamed pkey to id renamed ip_address to inetAddress renamed net_device to device renamed is_alias to isAlias changed package type to fkey as reference to packages.pkey renamed available to isAvailable renamed is_overflow to isOverflow renamed is_dhcp to isDhcp removed ping_monitor_enabled renamed external_ip_address to externalInetAddress removed check_blacklists_over_smtp removed monitoring_enabled mysql_servers table: removed pkey column renamed net_bind to bind as primary key removed package column net_devices: renamed device_id to deviceId ao_servers: renamed daemon_device_id to daemonDeviceId renamed uid_min to uidMin renamed gid_min to gidMin added uidMax added gidMax added lastUid added lastGid dns_records: renamed dhcp_address to dhcpAddress httpd_sites: renamed pkey to id renamed site_name to name linux_group_accounts: renamed pkey to id renamed group_name to group renamed username to user renamed operating_system_version to operatingSystemVersion postgres_servers table: removed pkey column renamed net_bind to bind as primary key net_binds: renamed pkey to id renamed ip_address to ipAddress sendmail_servers: renamed pkey to id renamed client_addr_inet to clientAddrInet renamed client_addr_inet6 to clientAddrInet6 aoserv_protocols: renamed last_used to lastUsed bank_accounts: renamed deposit_delay to depositDelay renamed withdrawal_delay to withdrawalDelay bank_transaction_types: renamed type to name renamed is_negative to isNegative expense_categories: renamed expense_code to name bank_transactions: renamed transid to id and moved to first column renamed bank_account to account renamed expense_code to expenseCategory renamed check_no to checkNo added table IpAddressMonitoring: moved column IPAddress.monitoring_enabled to IpAddressMonitoring.enabled moved column IPAddress.ping_monitor_enabled to IpAddressMonitoring.pingMonitorEnabled moved column IPAddress.check_blacklists_over_smtp to IpAddressMonitoring.checkBlacklistsOverSmtp added column IpAddressMonitoring.verifyDnsPtr added column IpAddressMonitoring.verifyDnsA2019-04-19
1.81.192018-12-03ProgressListener and TableLoadListener now notified of row counts using a 64-bit integer to handle results with more than a billion rows Renamed table billing.whois_history to billing.WhoisHistory Added table billing.WhoisHistoryAccount billing.WhoisHistory: Renamed pkey to id Changed zone to domain_name type (without the trailing period) Renamed zone to registrableDomain Added column exitStatus Renamed whois_output to output Added column error Removed column accounting2018-12-31
1.81.202018-12-09Added column account.Profile.billingEmailFormat Added column account.Profile.technicalEmailFormat Updated add_business_profile AOSH command2019-06-10
1.81.212018-12-14Renamed table httpd_site_bind_redirect to RewriteRule Renamed column RewriteRule.pkey to id Renamed column RewriteRule.httpd_site_bind to virtualHost Renamed column RewriteRule.sort_order to sortOrder Added column RewriteRule.flags Removed column RewriteRule.no_escape2019-03-07
1.81.222018-12-17Renamed account.Username to account.User Added linux_username to schema.Type Changed linux.User.username to linux_username type Changed web.Site.linux_account to linux_username type Changed linux.UserServer.username to linux_username type Changed linux.GroupUser.name to linux_username type Changed ftp.GuestUser.username to linux_username type Changed distribution.management.DistroFile.linux_account to linux_username type2019-07-11
1.82.02019-05-16Added payment.CreditCard.expirationMonth column Added payment.CreditCard.expirationYear column Removed payment.CreditCard.encrypted_expiration column Removed payment.CreditCard.encryption_expiration_from column Removed payment.CreditCard.encryption_expiration_recipient column Added payment.Payment.creditCard.expirationMonth column Added payment.Payment.creditCard.expirationYear column Added payment.Payment.authorizationResult.providerReplacementMaskedCardNumber column Added payment.Payment.authorizationResult.replacementMaskedCardNumber column Added payment.Payment.authorizationResult.providerReplacementExpiration column Added payment.Payment.authorizationResult.replacementExpirationMonth column Added payment.Payment.authorizationResult.replacementExpirationYear column2019-07-03
1.82.12019-05-29Added payment.CreditCard.customerId column Added payment.Payment.creditCard.customerId column2019-11-06
1.83.02019-07-12Added billing.Currency table Changed billing.MonthlyCharge.rate to money type New table billing.NoticeLog.balance Removed column billing.NoticeLog.balance Renamed column billing.PackageDefinition.setup_fee to setupFee and changed to money type Renamed column billing.PackageDefinition.monthly_rate to monthlyRate and changed to money type Renamed column billing.PackageDefinitionLimit.additional_rate to additionalRate and changed to money type Changed billing.Transaction.rate to money type Removed column payment.Payment.currency_code Changed payment.Payment.amount to money type Renamed column payment.Payment.tax_amount to taxAmount and changed to money type Renamed column payment.Payment.shipping_amount to shippingAmount and changed to money type Renamed column payment.Payment.duty_amount to dutyAmount and changed to money type Renamed AOSH command "add_transaction" to "billing.Transaction.add", and it now accepts a time with a value of "now", "today", "YYYY-MM-DD" or "YYYY-MM-DD HH:MM[:SS[.mmm]]" Added types "Identifier" (128-bit) and "SmallIdentifier" (64-bit) Renamed "master.Process.process_id" to "id" and changed to "SmallIdentifier" type Renamed "master.Process.connector_id" to "connectorId" and changed to "Identifier" type Renamed AOSH command "check_ssl_certificate" to "pki.Certificate.check", and it now accepts a boolean flag to enable/disable cached results2019-08-07
1.83.12019-07-29Master returns new entropy needed as entropy is added.2020-03-08
1.83.22020-02-15Added column web.tomcat.PrivateTomcatSite.tomcatAuthentication Added AOSH command web.tomcat.PrivateTomcatSite.tomcatAuthentication.set Added column web.tomcat.SharedTomcat.tomcatAuthentication Added AOSH command web.tomcat.SharedTomcat.tomcatAuthentication.set2021-04-03
1.84.132021-02-03Added type "HashedKey" Removed linux.Server.daemon_key, now stored in aoserv-daemon.properties2022-02-25
1.86.02021-08-27Added column dns.RecordType.has_flag Added column dns.RecordType.has_tag Added column dns.Record.flag Added column dns.Record.tag AOSH command add_dns_record updated with multiple shortcuts and support for flag and tag AOSH command remove_dns_record updated with tag2024-05-03
1.92.02023-10-10Added column web.tomcat.PrivateTomcatSite.maxParameterCount Added AOSH command web.tomcat.PrivateTomcatSite.maxParameterCount.set Added column web.tomcat.SharedTomcat.maxParameterCount Added AOSH command web.tomcat.SharedTomcat.maxParameterCount.set Added column web.tomcat.PrivateTomcatSite.undeployOldVersions Added AOSH command web.tomcat.PrivateTomcatSite.undeployOldVersions.set Added column web.tomcat.SharedTomcat.undeployOldVersions Added AOSH command web.tomcat.SharedTomcat.undeployOldVersions.set2024-05-03