Multiserver, Centos 6.5, sql sync, NULL
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.
[root@web1 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
pls, help me, i can't use this great program :(