Show Posts
1
Kloxo-MR Releases / [solved] After upgrade SQL error, sh /script/cleanup problem
« on: 2016-02-23, 08:49:35 »
Hi,
After upgrade I have few problems with system. I got SQL error, I don't know if its bit problem or not, but later I got stuck with "sh /script/cleanup". SOme SQL errors, later everything goes fine until "- Fix skeleton services" and here it stops until ~15-20 minutes then server disconnect me after inactivity...
And also problem with
Please help me.
After upgrade I have few problems with system. I got SQL error, I don't know if its bit problem or not, but later I got stuck with "sh /script/cleanup". SOme SQL errors, later everything goes fine until "- Fix skeleton services" and here it stops until ~15-20 minutes then server disconnect me after inactivity...
Code: [Select]
Updated:
kloxomr7.noarch 0:7.0.0.b-2016022302.mr mratwork-release.noarch 0:0.0.8-7
Complete!
[root@~]# sh /script/cleanup
Execute fixlxphpexe for php53s...
- For help, type '/script/set-kloxo-php --help'
- No argument supplied. Defaulting to 'fpm'
*** Executing Update (cleanup) - BEGIN ***
>>> Execute fixDataBaseIssues() <<<
Fix Database Issues
- Fix admin account database settings
- Set default database settings
- Fix resourceplan settings in database
- Alter some database tables to fit that of Kloxo
- Set default welcome text at Kloxo login page
- Remove default db password if exists
>>> Execute doUpdates() <<<
- Create flag dir
Fix IP Address
- Fix process
Create domain backup dirs
- Create process
- Create OS system user admin
- User admin exists
Set Watchdog defaults
- Set process
Fix MySQL root password
- Fix process
Set admin contact email
- Set process
Get Kloxo License info
- Get process
- Create database interface template (Forced)
>>> Execute driverload.php <<<
>>> Execute update_all_slave() <<<
>>> Execute cp_dbfile() <<<
>>> Execute updatecleanup() <<<
Prepare for Kloxo
- OS Create Kloxo init.d service file
- OS Fix programroot path permissions
- OS Restart Kloxo service
Check for bogofilter
- wordlist.db already exists
Remove Old dirs
- Remove process
Initialize Some Binary files
- Symlink /usr/local/bin/php already exists
Remove lighttpd errorlog
- Remove process
Fix the secure logfile
- Fix process
Clean hosts.deny
- Clean process
Turn off mouse daemon
- Turn off process
Synchronizing driver between table and slavedb
- No need synchronize for 'web' - already using 'apache'
- No need synchronize for 'webcache' - already using 'none'
- No need synchronize for 'dns' - already using 'bind'
- No need synchronize for 'spam' - already using 'spamassassin'
Update Services Branch List
- List for 'set.dns' branch
- List for 'set.httpd' branch
- List for 'set.imap' branch
- List for 'set.mysql' branch
- List for 'set.nginx' branch
- List for 'set.php' branch
- List for 'set.pop' branch
- List for 'set.smtp' branch
- List for 'set.web' branch
- List for 'set.webcache' branch
Initialize /script/ dir
- Initialize processes
Install Kloxo service
- Install process
Installing jailshell to system
- Already exists
Set /home permission to 0755
- Set process
- chown apache:apache FOR /home/kloxo/httpd/ AND INSIDE
- chmod 644 FOR *.php* INSIDE /home/kloxo/httpd/
- chmod 755 FOR *.pl/cgi/py/rb INSIDE /home/kloxo/httpd/
- chmod 755 FOR /home/kloxo/httpd/ AND INSIDE
- chmod 771 FOR /home/kloxo/httpd/
Enable xinetd service
- Enable process
Fix suexec
- Fix process
Install/Fix Services/Permissions/Configfiles
- Set permissions for /usr/bin/php-cgi
- Set permissions for closeinput binary
- Set permissions for phpsuexec.sh script
- Set permissions for /var/lib/php/session/ dir
- Set permissions for /var/bogofilter/ dir
- Kill sisinfoc system process
Execute/remove/initialize/install script
- Execute vpopmail.sh
- Remove /home/kloxo/httpd/script dir
- Initialize /home/kloxo/httpd/script dir
- Set ownership apache:apache for /home/kloxo/httpd/script dir
- Install phpinfo.php into /home/kloxo/httpd/script dir
Remove cache dir
- Remove process
Initialize awstats dirdata
- Initialize process
Update Kloxo database
- Updating process
ERROR 1064 (42000) at line 81: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS `priv_q_frontpage_flag` `priv_q_totalinode_flag` VARCHAR(255) DEFAULT ' at line 1
ERROR 1064 (42000) at line 82: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS `used_q_frontpage_flag` `used_q_totalinode_flag` VARCHAR(255) DEFAULT ' at line 1
ERROR 1064 (42000) at line 84: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `hostmaster` VARCHAR(255) AFTER `soanameserver`' at line 1
ERROR 1064 (42000) at line 86: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `spf_protocol` VARCHAR(255) NULL DEFAULT NULL AFTER `text_spf_ip`' at line 1
ERROR 1064 (42000) at line 87: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `enable_dmarc_flag` VARCHAR(255) NULL DEFAULT NULL AFTER `spf_prot' at line 1
ERROR 1064 (42000) at line 88: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `percentage_filtering` VARCHAR(255) NULL DEFAULT NULL AFTER `enabl' at line 1
ERROR 1064 (42000) at line 89: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `receiver_policy` VARCHAR(255) NULL DEFAULT NULL AFTER `percentage' at line 1
ERROR 1064 (42000) at line 90: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `mail_feedback` VARCHAR(255) NULL DEFAULT NULL AFTER `receiver_pol' at line 1
ERROR 1064 (42000) at line 91: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `dmarc_protocol` VARCHAR(255) NULL DEFAULT NULL AFTER `mail_feedba' at line 1
ERROR 1064 (42000) at line 93: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `priv_q_totalinode_usage` VARCHAR(255) NULL DEFAULT NULL AFTER `us' at line 1
ERROR 1064 (42000) at line 94: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `used_q_totalinode_usage` VARCHAR(255) NULL DEFAULT NULL AFTER `pr' at line 1
ERROR 1064 (42000) at line 96: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `defaultport` VARCHAR(255) NULL DEFAULT NULL AFTER `enable_anon_ft' at line 1
ERROR 1064 (42000) at line 98: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `enable_spf_autoip` VARCHAR(255) NULL DEFAULT NULL AFTER `text_spf' at line 1
ERROR 1064 (42000) at line 99: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `text_spf_include` VARCHAR(255) NULL DEFAULT NULL AFTER `enable_sp' at line 1
ERROR 1064 (42000) at line 100: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `text_spf_redirect` VARCHAR(255) NULL DEFAULT NULL AFTER `text_spf' at line 1
ERROR 1064 (42000) at line 102: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `parent_domain` VARCHAR(255) NULL DEFAULT NULL AFTER `upload_statu' at line 1
ERROR 1064 (42000) at line 103: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `add_type` VARCHAR(255) NULL DEFAULT NULL AFTER `parent_domain`' at line 1
ERROR 1064 (42000) at line 105: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `force_https_redirect` VARCHAR(255) NULL DEFAULT NULL AFTER `force' at line 1
ERROR 1064 (42000) at line 109: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `web_selected` VARCHAR(255) NULL DEFAULT NULL AFTER `force_https_r' at line 1
ERROR 1064 (42000) at line 110: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `php_selected` VARCHAR(255) NULL DEFAULT NULL AFTER `web_selected`' at line 1
ERROR 1064 (42000) at line 114: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `enable_tls` VARCHAR(255) NULL DEFAULT NULL AFTER `defaultport`' at line 1
Remove old lxlabs ssh key
- Remove process
- Preparing MySQL/MariaDB service
- MySQL activated
- Updating Main services
Updating All packages - WAIT to process...
- No update found/not installed
cp: cannot stat `..init/kloxo.init': No such file or directory
Removing /home/httpd/*/httpdocs
- Removing...
Add 'hostname' information to '/etc/hosts'
- Add ip, short and full name of 'hostname'
Initialize some skeletons
- Php files for default web page
- Skeleton for default web page
- robots.txt for default web page
- Php files for disable web page
- Skeleton for disable web page
- robots.txt for disable web page
- Php files for webmail web page
- Skeleton for webmail web page
- robots.txt for webmail web page
- Php files for cp web page
- Skeleton for cp web page
- robots.txt for cp web page
- Skeleton for error web page
- robots.txt for error web page
- chown apache:apache FOR /home/kloxo/httpd/ AND INSIDE
- chmod 644 FOR *.php* INSIDE /home/kloxo/httpd/
- chmod 755 FOR *.pl/cgi/py/rb INSIDE /home/kloxo/httpd/
- chmod 755 FOR /home/kloxo/httpd/ AND INSIDE
- chmod 771 FOR /home/kloxo/httpd/
- Php files for login web page
- Skeleton for login web page
- Files for error web pages
- Skeleton for error web pages
- Copy error web pages to '/home/kloxo/httpd/error'
- No exists user-skeleton
- No exists user-logo
Initialize phpMyAdmin configfile
- phpMyAdmin: Set db password in configfile
Initialize OS admin account description
- Initialize process
Copy all contents from ../file/bind
- Copy to /opt/configs/bind
- Copy etc/named.conf to /etc/named.conf
Copy all contents from ../file/djbdns
- Copy to /opt/configs/djbdns
Copy all contents from ../file/mydns
- Copy to /opt/configs/mydns
- Copy etc/conf/mydns.conf to /etc/mydns/mydns.conf
Preparing MyDns database
- Fixing MySQL commands in import files
- Generating password
- Add Password to configuration file
Copy all contents from ../file/nsd
- Copy to /opt/configs/nsd
- Copy etc/conf/nsd3.conf to /etc/nsd/nsd.conf
Copy all contents from ../file/pdns
- Copy to /opt/configs/pdns
- Copy etc/conf/pdns.conf to /etc/pdns/pdns.conf
Preparing PowerDNS database
- Install MySQL and Geo Backend
- Fixing MySQL commands in import files
- Generating password
- Add Password to configuration file
Copy all contents from ../file/yadifa
- Copy to /opt/configs/yadifa
- Copy etc/yadifad.conf to /etc/yadifad.conf
Initialize apache config
- /etc/httpd/conf.d dir already exists
- /opt/configs/apache/tpl dir already exists
- /opt/configs/apache/conf dir already exists
- /opt/configs/apache/etc dir already exists
- /opt/configs/apache/etc/conf dir already exists
- /opt/configs/apache/etc/conf.d dir already exists
Copy all contents from ../file/apache
- Copy to /opt/configs/apache
- Copy etc/conf/httpd.conf to /etc/httpd/conf/httpd.conf
- chown root:root FOR /opt/configs/apache/ AND INSIDE
- chmod 755 FOR *.sh INSIDE /opt/configs/apache/
Initialize lighttpd config
- /etc/lighttpd/conf.d dir already exists
- /opt/configs/lighttpd/tpl dir already exists
- /opt/configs/lighttpd/conf dir already exists
- /opt/configs/lighttpd/etc dir already exists
- /opt/configs/lighttpd/etc/conf dir already exists
- /opt/configs/lighttpd/etc/conf.d dir already exists
Copy all contents from ../file/lighttpd
- Copy to /opt/configs/lighttpd
- Copy etc/conf/lighttpd.conf to /etc/lighttpd/lighttpd.conf
- chown root:root FOR /opt/configs/lighttpd/ AND INSIDE
- chmod 755 FOR *.sh INSIDE /opt/configs/lighttpd/
Initialize nginx config
- /etc/nginx/conf.d dir already exists
- /opt/configs/nginx/tpl dir already exists
- /opt/configs/nginx/conf dir already exists
- /opt/configs/nginx/etc dir already exists
- /opt/configs/nginx/etc/conf dir already exists
- /opt/configs/nginx/etc/conf.d dir already exists
Copy all contents from ../file/nginx
- Copy to /opt/configs/nginx
- Copy etc/conf/nginx.conf to /etc/nginx/nginx.conf
- chown root:root FOR /opt/configs/nginx/ AND INSIDE
- chmod 755 FOR *.sh INSIDE /opt/configs/nginx/
Initialize hiawatha config
- /etc/hiawatha/conf.d dir already exists
- /opt/configs/hiawatha/tpl dir already exists
- /opt/configs/hiawatha/conf dir already exists
- /opt/configs/hiawatha/etc dir already exists
- /opt/configs/hiawatha/etc/conf dir already exists
- /opt/configs/hiawatha/etc/conf.d dir already exists
Copy all contents from ../file/hiawatha
- Copy to /opt/configs/hiawatha
- Copy etc/conf/hiawatha_standard.conf to /etc/hiawatha/hiawatha.conf
- chown root:root FOR /opt/configs/hiawatha/ AND INSIDE
- chmod 755 FOR *.sh INSIDE /opt/configs/hiawatha/
Copy all contents from ../file/varnish
- Copy to /opt/configs/varnish
Copy all contents from ../file/squid
- Copy to /opt/configs/squid
Copy all contents from ../file/trafficserver
- Copy to /opt/configs/trafficserver
Copy all contents from ../file/openssl
- Copy to /opt/configs/openssl
Copy all contents from ../file/letsencrypt
- Copy to /opt/configs/letsencrypt
Initialize PureFtp service
- Initialize process
- Restart pure-ftpd service
Initialize logrotates
Install Webmail chooser
- Install process
Initialize Mail service
- Initialize process
Fix services
- Fix dns services
- Fix webcache services
- Fix web services
- Fix php services
- Fix mail-all services
- Fix ftp-all services
- Fix skeleton services
And also problem with
Code: [Select]
[root@~]# service httpd restart
Stopping httpd: [FAILED]
Starting httpd: (98)Address already in use: make_sock: could not bind to address 0.0.0.0:80
no listening sockets available, shutting down
Unable to open logs
[FAILED]
Please help me.
Code: [Select]
sh /script/sysinfo
A. Control Panel:
- Kloxo-MR: 7.0.0.b-2016022302
- Web: hiawatha-10.1.0-f.6.mr.el5
- PHP: php53s-5.3.29-1.ius.el5 (fpm mode)
B. Plateform:
- OS: CentOS release 5.11 (Final) x86_64
- Hostname: I hide it
C. Services:
1. MySQL: mysql55-5.5.47-1.ius.el5
2. PHP:
- Branch: php54-cli-5.4.45-1.ius.el5
- Multiple:
* php52m-5.2.17-102.mr.el5
* php53m-5.3.29-1.ius.el5
* php54m-5.4.41-1.ius.el5
- Used: php54m
3. Httpd: httpd-2.2.31-1.mr.el5
- PHP Type: php-fpm_worker
4. Lighttpd: --uninstalled--
5. Hiawatha: --unused--
6. Nginx: --uninstalled--
7. Cache: --uninstalled--
8. Dns: bind-9.9.7-1.mr.el5
9. Qmail: qmail-toaster-1.03-1.3.55.mr.el5
- with: courier-imap-toaster-4.1.2-1.3.18.mr.el5
D. Memory:
total used free shared buffers cached
Mem: 2048 1687 360 0 0 1133
-/+ buffers/cache: 554 1493
Swap: 1024 151 872
E. Disk Space:
Filesystem Size Used Avail Use% Mounted on
/dev/simfs 40G 21G 20G 51% /
*** Process Time: 00:00:00:01.1390 (dd:hh:mm:ss:xxxxxx) ***
* Note: run 'sh /script/sysinfo -y' if you want run 'fix-service-list' also
(importance after Kloxo-MR update)
