MRatWork Forum by Mustafa Ramadhan

Sawo Project - Kloxo-MR Discussions => Kloxo-MR Releases => Topic started by: digidata on 2016-02-23, 08:49:35

Title: [solved] After upgrade SQL error, sh /script/cleanup problem
Post 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...


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)
Title: Re: After upgrade SQL error, sh /script/cleanup problem
Post by: MRatWork on 2016-02-23, 12:11:38
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).
Title: Re: After upgrade SQL error, sh /script/cleanup problem
Post by: digidata on 2016-02-23, 14:54:39
No, I'm using 7.0 for long time. Just updated 7.0 version from older 7.0
Title: Re: After upgrade SQL error, sh /script/cleanup problem
Post by: MRatWork on 2016-02-23, 14:59:52
Try run cleanup again after reboot.
Title: Re: After upgrade SQL error, sh /script/cleanup problem
Post by: digidata on 2016-02-23, 15:09:49
The same. SQL errors ant stucks on skeleton  :-[
Title: Re: After upgrade SQL error, sh /script/cleanup problem
Post by: MRatWork on 2016-02-23, 15:31:30
Try 'sh /script/phpm-installer php54s; sh /script/fixlxphpexe php54s' and then cleanup again.
Title: Re: After upgrade SQL error, sh /script/cleanup problem
Post by: digidata on 2016-02-23, 21:46:22
no luck  :-\

(https://i.gyazo.com/6b0234decdeda8232a3f11e5bc4f2ffc.png)
(https://i.gyazo.com/204ba2350dccde88c5e288cb8dd352c8.png)
Title: Re: After upgrade SQL error, sh /script/cleanup problem
Post by: MRatWork on 2016-02-23, 23:07:56
I am not sure about sql update appear error. No error found if using MariaDB instead MySQL 5.5.
Title: Re: After upgrade SQL error, sh /script/cleanup problem
Post by: digidata on 2016-02-24, 11:44:40
How to replace mysql with mariadb? Any conflicts?

Ant what about stuck on - Fix skeleton services?
Title: Re: After upgrade SQL error, sh /script/cleanup problem
Post by: MRatWork on 2016-02-24, 12:09:13
May reinstall Kloxo-MR with 'sh /script/upcp -y'. If found trouble after that, run 'sh /script/mysql-optimize --select=upgrade'.
Title: Re: After upgrade SQL error, sh /script/cleanup problem
Post by: digidata on 2016-02-26, 07:07:15
After reinstall I will lose information?
Title: Re: After upgrade SQL error, sh /script/cleanup problem
Post by: MRatWork on 2016-02-26, 07:23:19
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.
Title: Re: After upgrade SQL error, sh /script/cleanup problem
Post by: digidata on 2016-02-26, 13:35:34
With MYSQL now is OK, but still stucks on fix skeleton services :)
Title: Re: After upgrade SQL error, sh /script/cleanup problem
Post by: MRatWork on 2016-02-26, 13:45:29
With MYSQL now is OK, but still stucks on fix skeleton services :)
How much domains in server?.
Title: Re: After upgrade SQL error, sh /script/cleanup problem
Post by: digidata on 2016-02-26, 19:18:13
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.

Code: [Select]
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?
Title: Re: After upgrade SQL error, sh /script/cleanup problem
Post by: MRatWork on 2016-02-27, 12:36:30
See /opt/configs/nsd/conf/defaults/nsd.acl.conf but also need declare 'ip-address' in /etc/nsd/nsd.conf.
Title: Re: After upgrade SQL error, sh /script/cleanup problem
Post by: digidata on 2016-02-27, 13:21:23
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?
Title: Re: After upgrade SQL error, sh /script/cleanup problem
Post by: MRatWork on 2016-02-27, 13:30:45
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.
Title: Re: After upgrade SQL error, sh /script/cleanup problem
Post by: digidata on 2016-02-27, 17:54:19
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
Quote
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?
Code: [Select]
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)

Title: Re: After upgrade SQL error, sh /script/cleanup problem
Post by: MRatWork on 2016-02-28, 00:57:38
Try delete '/var/log/named/default.log' file.
Title: Re: After upgrade SQL error, sh /script/cleanup problem
Post by: digidata on 2016-02-29, 15:25:44
Try delete '/var/log/named/default.log' file.

Not helped :)

Fixed with different permisions to files and folders :)
Title: Re: [solved] After upgrade SQL error, sh /script/cleanup problem
Post by: putude on 2016-03-08, 09:59:44
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 ?
Title: Re: [solved] After upgrade SQL error, sh /script/cleanup problem
Post by: digidata on 2016-03-29, 14:22:57
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 :(