Multiserver, Centos 6.5, sql sync, NULL from bugreport

Discussion in 'Installation/Configuration' started by Celtix, May 30, 2014.

  1. Celtix

    Celtix New Member

    http://bugtracker.ispconfig.org/index.php?do=details&task_id=3522

    Hello!

    We have begun to use ispconfig (i test it now).
    Four server:
    - admin (mysql, httpd, ispconfig web interface)
    - web1 (httpd,mysql,ftp)
    - web2 (nginx, mysql, ftp)
    - mail (postfix and Dovecot)

    All the four machine are XEN vm, centos 6.5, Oracle MySQL 5.6.17

    sync dbispconfig database is not good. If I runnin the /usr/local/ispconfig/server/serverr.sh i see the messages:

    case 1.

    [[email protected] server]# ./server.sh
    27.05.2014-09:43 - ERROR - Replication failed. Error: (client) in MySQL server: (localhost) Incorrect integer value: '' for column 'created_at' at row 1 # SQL: REPLACE INTO client (`client_id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`company_name`,`company_id`,`gender`,`contact_name`,`customer_no`,`vat_id`,`street`,`zip`,`city`,`state`,`country`,`telephone`,`mobile`,`fax`,`email`,`internet`,`icq`,`notes`,`bank_account_owner`,`bank_account_number`,`bank_code`,`bank_name`,`bank_account_iban`,`bank_account_swift`,`paypal_email`,`default_mailserver`,`mail_servers`,`limit_maildomain`,`limit_mailbox`,`limit_mailalias`,`limit_mailaliasdomain`,`limit_mailforward`,`limit_mailcatchall`,`limit_mailrouting`,`limit_mailfilter`,`limit_fetchmail`,`limit_mailquota`,`limit_spamfilter_wblist`,`limit_spamfilter_user`,`limit_spamfilter_policy`,`default_webserver`,`web_servers`,`limit_web_ip`,`limit_web_domain`,`limit_web_quota`,`web_php_options`,`limit_cgi`,`limit_ssi`,`limit_perl`,`limit_ruby`,`limit_python`,`force_suexec`,`limit_hterror`,`limit_wildcard`,`limit_ssl`,`limit_web_subdomain`,`limit_web_aliasdomain`,`limit_ftp_user`,`limit_shell_user`,`ssh_chroot`,`limit_webdav_user`,`limit_backup`,`limit_aps`,`default_dnsserver`,`db_servers`,`limit_dns_zone`,`default_slave_dnsserver`,`limit_dns_slave_zone`,`limit_dns_record`,`default_dbserver`,`dns_servers`,`limit_database`,`limit_database_quota`,`limit_cron`,`limit_cron_type`,`limit_cron_frequency`,`limit_traffic_quota`,`limit_client`,`limit_domainmodule`,`limit_mailmailinglist`,`limit_openvz_vm`,`limit_openvz_vm_template_id`,`parent_client_id`,`username`,`password`,`language`,`usertheme`,`template_master`,`template_additional`,`created_at`,`locked`,`canceled`,`can_use_api`,`tmp_data`,`id_rsa`,`ssh_rsa`,`customer_no_template`,`customer_no_start`,`customer_no_counter`,`added_date`,`added_by`) VALUES ('1','1','1','riud','riud','','An','','','szilvi','C1','','','','','','HU','','','','','http://','','','','','','','','','','2','','-1','-1','-1','-1','-1','-1','0','-1','-1','-1','0','0','0','1','','','-1','-1','no,fast-cgi,cgi,mod,suphp,php-fpm','n','n','n','n','n','y','n','n','n','-1','-1','-1','0','no,jailkit,ssh-chroot','0','y','-1','0','','-1','0','-1','-1','1','','-1','-1','0','url','5','-1','1','0','-1','0','0','0','szilvi','$1$VirgxbEn$EUqTSvEk.sSqoqsfPvJU6/','hu','blue','0','','','n','n','n','','','','C[CUSTOMER_NO]','1','0','2014-05-26','admin')
    27.05.2014-09:43 - ERROR - Error in Replication, changes were not processed.
    finished.

    case 2.

    27.05.2014-15:34 - ERROR - Replication failed. Error: (web_domain) in MySQL server: (localhost) Incorrect date value: '' for column 'last_quota_notification' at row 1 # SQL: REPLACE INTO web_domain (`domain_id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`serv
    er_id`,`ip_address`,`ipv6_address`,`domain`,`type`,`parent_domain_id`,`vhost_type`,`document_root`,`web_folder`,`system_user`,`system_group`,`hd_quota`,`traffic_quota`,`cgi`,`ssi`,`suexec`,`errordocs`,`is_subdomainwww`,`subdomain`,`php`,`ruby`,`python`,`perl`,`redirect_type`,`redirect_path`,`seo_redirect`,`ssl`,`ssl_state`,`ssl_locality`,`ssl_organisation`,`ssl_organisation_unit`,`ssl_country`,`ssl_domain`,`ssl_request`,`ssl_cert`,`ssl_bundle`,`ssl_key`,`ssl_action`,`stats_password`,`stats_type`,`allow_override`,`apache_directives`,`nginx_directives`,`php_fpm_use_socket`,`pm`,`pm_max_children`,`pm_start_servers`,`pm_min_spare_servers`,`pm_max_spare_servers`,`pm_process_idle_timeout`,`pm_max_requests`,`php_open_basedir`,`custom_php_ini`,`backup_interval`,`backup_copies`,`backup_excludes`,`active`,`traffic_quota_lock`,`fastcgi_php_version`,`proxy_directives`,`last_quota_notification`,`rewrite_rules`,`added_date`,`added_by`) VALUES ('4','1','5','riud','riud','','3','','','test2.anweb.local','alias','3','','','','','','0','-1','y','y','y','1','1','www','y','n','n','n','','','','n','','','','','','','','','','','','','webalizer','All','','','y','dynamic','10','2','1','5','10','0','','','none','1','','y','n','','','','','0000-00-00','')


    And search in the databasae, first case:
    "client" table, "created at" row is NULL. I delete, and re create. Not ok. I replace the value with "2014-05-27" but not good. Search in the database and found the next table:
    "sys_datalog". Here is the sql command. I replace here the value and everything is ok. But the next case the same thing happened :( now in the "web_domain" table. (2. case)



    The wrong values (NULL):

    27.05.2014-11:26 - ERROR - Replication failed. Error: (web_database) in MySQL server: (localhost) Incorrect integer value: '' for column 'database_quota' at row 1 # SQL: REPLACE INTO web_database

    27.05.2014-11:16 - ERROR - Replication failed. Error: (web_domain) in MySQL server: (localhost) Incorrect date value: '' for column 'last_quota_notification' at row 1 # SQL: REPLACE INTO web_domain

    27.05.2014-15:34 - ERROR - Replication failed. Error: (web_domain) in MySQL server: (localhost) Incorrect date value: '' for column 'last_quota_notification' at row 1 # SQL: REPLACE INTO web_domain
     
  2. Celtix

    Celtix New Member

    Till's answer

    What you posted above is a installation issue and not a bug in ispconfig. Please use our forum to get help with installation issues and not the bugtracker:

    http://www.howtoforge.com/forums

    I guess your problem is related to the use of a non supported mysql version from Oracle instead of using the default one from centos.

    Open theMySQL configuration file /etc/my.cnf with an editor and change the line "sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES" to:
     
  3. Celtix

    Celtix New Member

    [[email protected] ~]# mysql -e "show global variables" | grep sql_mode
    sql_mode NO_ENGINE_SUBSTITUTION
    [[email protected] ~]#


    Ok, i'll try the default mysql from centos install.
     
  4. vaio1

    vaio1 ISPConfig Developer ISPConfig Developer

Share This Page