Data not getting written to disk.

Discussion in 'General' started by vk3heg, Aug 30, 2019.

  1. vk3heg

    vk3heg Member

    Hi Guys,
    I have an issue that changes to the system on the webinterface work, but changes to disk based files are not being written out.
    This happens for DNS, Websites, Email accounts.
    I have done the debug instructions and they are included, along with extra information.
    The system was recently migrated from debian 8 to the new system system under 10.

    OS: Debian 10
    Ispconfig: 3.1.14p2

    mysqlcheck --defaults-file=/etc/mysql/debian.cnf --optimize --auto-repair --silent dbispconfig
    No output.

    /usr/local/ispconfig/server/server.sh
    30.08.2019-10:53 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
    30.08.2019-10:53 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    finished.

    server table contains: 14533
    making a change to a website this number stays the same

    sys_datalog/datalog_id: 2570
    making a change to a website this number increases by one

    /usr/local/ispconfig/interface/lib/config.inc.php and /usr/local/ispconfig/server/lib/config.inc.php
    both match.

    root@shadow:~# mysql -u ispconfig -D dbispconfig -p
    Enter password:
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A

    Welcome to the MariaDB monitor. Commands end with ; or \g.
    Your MariaDB connection id is 28615
    Server version: 10.3.15-MariaDB-1 Debian 10
    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    MariaDB [dbispconfig]> show tables;
    +------------------------------------+
    | Tables_in_dbispconfig |
    +------------------------------------+
    | aps_instances |
    | aps_instances_settings |
    | aps_packages |
    | aps_settings |
    | attempts_login |
    | client |
    | client_circle |
    | client_message_template |
    | client_template |
    | client_template_assigned |
    | country |
    | cron |
    | directive_snippets |
    | dns_rr |
    | dns_slave |
    | dns_soa |
    | dns_ssl_ca |
    | dns_template |
    | domain |
    | firewall |
    | ftp_traffic |
    | ftp_user |
    | help_faq |
    | help_faq_sections |
    | invoice |
    | invoice_client_settings |
    | invoice_company |
    | invoice_csv_export |
    | invoice_csv_export_definition |
    | invoice_item |
    | invoice_item_category |
    | invoice_item_template |
    | invoice_item_template_custom_field |
    | invoice_message |
    | invoice_message_template |
    | invoice_payment_log |
    | invoice_payment_term |
    | invoice_recurring_item |
    | invoice_sepa_mandate |
    | invoice_sepa_xml_export |
    | invoice_settings |
    | invoice_vat_rate |
    | iptables |
    | mail_access |
    | mail_backup |
    | mail_content_filter |
    | mail_domain |
    | mail_forwarding |
    | mail_get |
    | mail_mailinglist |
    | mail_relay_recipient |
    | mail_traffic |
    | mail_transport |
    | mail_user |
    | mail_user_filter |
    | monitor_data |
    | openvz_ip |
    | openvz_ostemplate |
    | openvz_template |
    | openvz_traffic |
    | openvz_vm |
    | remote_session |
    | remote_user |
    | server |
    | server_ip |
    | server_ip_map |
    | server_php |
    | shell_user |
    | software_package |
    | software_repo |
    | software_update |
    | software_update_inst |
    | spamfilter_policy |
    | spamfilter_users |
    | spamfilter_wblist |
    | support_message |
    | sys_config |
    | sys_cron |
    | sys_datalog |
    | sys_dbsync |
    | sys_filesync |
    | sys_group |
    | sys_ini |
    | sys_log |
    | sys_remoteaction |
    | sys_session |
    | sys_theme |
    | sys_user |
    | web_backup |
    | web_database |
    | web_database_user |
    | web_domain |
    | web_folder |
    | web_folder_user |
    | web_traffic |
    | webdav_user |
    | xmpp_domain |
    | xmpp_user |
    +------------------------------------+
    98 rows in set (0.001 sec)
    MariaDB [dbispconfig]>


    Thanks.
    Stephen
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    How did you do the migration? It seems as if you deleted data from sys_datalog or that you did not migrate sys_datralog table at all?
     
  3. vk3heg

    vk3heg Member

    I used the ispcoonfig migration toolkit.
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    The Migration Toolkit consists of two programs, which one did you use? Is this a single or multiserver setup? And what about the second question I asked?
     
  5. vk3heg

    vk3heg Member

    Hi Till.
    I used the migration tool from the kit and asked it to migrate everything. I never deleted anything from the database.
    As a test last night, I made a backup of the system and then increased the sys_datalog/datalog_id: 2570 to match the server table figure. Then ran the /usr/local/ispconfig/server/server.sh command and the system performed the events. I then made a small change to the dns for a site, and that also ran and exported the changes to bind. Editing website config also makes the changes out to apachie. Creation of email accounts also does it thing.

    Sofar everything looks like it's back on track.

    Thanks,
    Stephen
     
    till likes this.

Share This Page