MRatWork Forum by Mustafa Ramadhan
Sawo Project - Kloxo-MR Discussions => Kloxo-MR Releases => Topic started by: digidata 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...
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
[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.
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)
-
Do you mean upgrade from Kloxo-MR 6.5 to 7.0?. If yes, run 'sh /script/upcp -y' (that mean reinstall Kloxo-MR 7.0).
-
No, I'm using 7.0 for long time. Just updated 7.0 version from older 7.0
-
Try run cleanup again after reboot.
-
The same. SQL errors ant stucks on skeleton :-[
-
Try 'sh /script/phpm-installer php54s; sh /script/fixlxphpexe php54s' and then cleanup again.
-
no luck :-\
(https://i.gyazo.com/6b0234decdeda8232a3f11e5bc4f2ffc.png)
(https://i.gyazo.com/204ba2350dccde88c5e288cb8dd352c8.png)
-
I am not sure about sql update appear error. No error found if using MariaDB instead MySQL 5.5.
-
How to replace mysql with mariadb? Any conflicts?
Ant what about stuck on - Fix skeleton services?
-
May reinstall Kloxo-MR with 'sh /script/upcp -y'. If found trouble after that, run 'sh /script/mysql-optimize --select=upgrade'.
-
After reinstall I will lose information?
-
Running 'sh /script/upcp -y' only make setting to default (like web server back to apache) but all data (like database, website, mail and log) still exists.
-
With MYSQL now is OK, but still stucks on fix skeleton services :)
-
With MYSQL now is OK, but still stucks on fix skeleton services :)
How much domains in server?.
-
13 domains, not all used, ant 12 subdomains.
Now every 5 minutes receive email with:
Action: sh /script/restart-dns --force >/dev/null 2>&1
Bind not working, djbdns also. Now using nsd.
But in BIND "/opt/configs/bind/conf/defaults/named.acl.conf" file I can add secondary dns server ip address with it, server synchronizates dns records and makes other server to have information, because second dns is not mine, but servers provider.
acl allow-transfer {
localhost;
123.123.123.123;
};
acl allow-notify {
localhost;
123.123.123.123;
};
Any way to work samething like this in NSD?
-
See /opt/configs/nsd/conf/defaults/nsd.acl.conf but also need declare 'ip-address' in /etc/nsd/nsd.conf.
-
See /opt/configs/nsd/conf/defaults/nsd.acl.conf but also need declare 'ip-address' in /etc/nsd/nsd.conf.
Any example how declare ip-address in /etc/nsd/nsd.conf?
-
Kloxo-MR add 'ip-address:' automatically in nsd.conf where ip taken from panel detected.
You can see /opt/configs/nsd/tpl/list.transfered.conf.tpl logic for this purpose.
-
Kloxo-MR add 'ip-address:' automatically in nsd.conf where ip taken from panel detected.
You can see /opt/configs/nsd/tpl/list.transfered.conf.tpl logic for this purpose.
Something for me not working as it to be. Intodns.com always receiving ERROR: One or more of your nameservers did not respond:
The ones that did not respond are:
for one dns.
Maybe it is possible to fix named?Feb 27 19:01:26 286806 named[1712]: BIND 9 is maintained by Internet Systems Consortium,
Feb 27 19:01:26 286806 named[1712]: Inc. (ISC), a non-profit 501(c)(3) public-benefit
Feb 27 19:01:26 286806 named[1712]: corporation. Support and training for BIND 9 are
Feb 27 19:01:26 286806 named[1712]: available at https://www.isc.org/support
Feb 27 19:01:26 286806 named[1712]: ----------------------------------------------------
Feb 27 19:01:26 286806 named[1712]: adjusted limit on open files from 40960 to 1048576
Feb 27 19:01:26 286806 named[1712]: found 2 CPUs, using 2 worker threads
Feb 27 19:01:26 286806 named[1712]: using 2 UDP listeners per interface
Feb 27 19:01:26 286806 named[1712]: using up to 4096 sockets
Feb 27 19:01:26 286806 named[1712]: loading configuration from '/etc/named.conf'
Feb 27 19:01:26 286806 named[1712]: using default UDP/IPv4 port range: [1024, 65535]
Feb 27 19:01:26 286806 named[1712]: using default UDP/IPv6 port range: [1024, 65535]
Feb 27 19:01:26 286806 named[1712]: no IPv6 interfaces found
Feb 27 19:01:26 286806 named[1712]: listening on IPv4 interface lo, 127.0.0.1#53
Feb 27 19:01:26 286806 named[1712]: listening on IPv4 interface venet0:0, 123.123.123.123#53
Feb 27 19:01:26 286806 named[1712]: generating session key for dynamic DNS
Feb 27 19:01:26 286806 named[1712]: sizing zone task pool based on 26 zones
Feb 27 19:01:26 286806 named[1712]: set up managed keys zone for view _default, file 'managed-keys.bind'
Feb 27 19:01:26 286806 named[1712]: command channel listening on 127.0.0.1#953
Feb 27 19:01:26 286806 named[1712]: the working directory is not writable
Feb 27 19:01:26 286806 named[1712]: isc_stdio_open '/var/log/named/default.log' failed: permission denied
Feb 27 19:01:26 286806 named[1712]: configuring logging: permission denied
Feb 27 19:01:26 286806 named[1712]: loading configuration: permission denied
Feb 27 19:01:26 286806 named[1712]: exiting (due to fatal error)
-
Try delete '/var/log/named/default.log' file.
-
Try delete '/var/log/named/default.log' file.
Not helped :)
Fixed with different permisions to files and folders :)
-
Hello @digidata & Mustafa,
I have same problem with one of my VPS.
it stuck when run fixskeleton
what's happen ?
how did you fix this problem ?
would you mind to share ?
-
Hello @digidata & Mustafa,
I have same problem with one of my VPS.
it stuck when run fixskeleton
what's happen ?
how did you fix this problem ?
would you mind to share ?
I'm trying to remember. I fixed with skeleton, but can't remember how :(