PhpMyAdmin and Hiawatha not working on slave

[bigdigillc]

I have suddenly lost the ability to use PhpMyAdmin on my slave server which is where all the MySQL databases reside. I think it is because Hiawatha won't start. Does PhpMyAdmin run Hiawatha in Kloxo? Below are some the error I get.

Code: [Select]

sh /script/restart -y

This is a Slave Server. Operate it at the Master server.
Stopping kloxo-phpcgi:                                     [FAILED]
Starting kloxo-phpcgi ('php54s' in 'fpm' mode):            [  OK  ]
Starting kloxo-hiawatha: Syntax error in hiawatha.conf on line 30.
                                                           [FAILED]
-------------------------------------------------------------------



Code: [Select]

sh /script/restart-web

*** Process for PHP-FPM service ***
  - Process: restart
Stopping php-fpm:                                          [  OK  ]
Starting php-fpm:                                          [  OK  ]
-------------------------------------------------------------------

*** Process for HIAWATHA service ***
  - Process: restart
Stopping Hiawatha web server:                              [FAILED]
Starting Hiawatha web server: Error loading X.509 CA certificate from /home/klox                             o/httpd/ssl/eth0___localhost.ca: PK - Read/write of file failed (-0x3E00)
                                                           [FAILED]
-------------------------------------------------------------------



[MRatWork]

Inform here 'cat /usr/local/lxlabs/kloxo/init/hiawatha.conf' for slave.

[bigdigillc]

Code: [Select]

cat /usr/local/lxlabs/kloxo/init/hiawatha.conf
# Hiawatha main configuration file
# Convictions Hosting Custom - September 9th

ServerString = Hiawatha_for_Kloxo-MR

ServerId = lxlabs
ConnectionsTotal = 2048
ConnectionsPerIP = 64
SystemLogfile = /usr/local/lxlabs/kloxo/log/hiawatha-system.log
GarbageLogfile = /usr/local/lxlabs/kloxo/log/hiawatha-garbage.log

MaxUrlLength = 65536

PIDfile = /usr/local/lxlabs/kloxo/init/kloxo-hiawatha.pid

ChallengeClient = 300, httpheader, 60

BanOnGarbage = 300
BanOnMaxPerIP = 60
BanOnMaxReqSize = 300
KickOnBan = yes
RebanDuringBan = yes

ThreadPoolSize = 50

#CGIhandler = /opt/php53s/usr/bin/php-cgi:php
#ExecuteCGI = yes
WaitForCGI = yes

MinSSLversion = TLS1.0

FastCGIserver {
        FastCGIid = PHP5
        #ConnectTo = 127.0.0.1:39000
        ConnectTo = /usr/local/lxlabs/kloxo/init/kloxo-phpcgi.sock
        Extension = php
}

MimetypeConfig = hiawatha-mimetype.conf

UrlToolkit {
        ToolkitID = block_shellshock
        #Header * \(\)\s*\{ DenyAccess
        Header User-Agent \(\)\s*\{ DenyAccess
        Header Referer \(\)\s*\{ DenyAccess
}

UrlToolkit {
        ToolkitID = findindexfile
        Match ^([^?]*)/(\?.*)?$ Rewrite $1/index.php$2 Continue
        RequestURI isfile Return
        Match ^([^?]*)/index\.php(\?.*)?$ Rewrite $1/index.html$2 Continue
        RequestURI isfile Return
        Match ^([^?]*)/index\.html(\?.*)?$ Rewrite $1/index.htm$2 Continue
        RequestURI isfile Return
        Match ^([^?]*)/index\.htm(\?.*)?$ Rewrite $1/$2 Continue
}

UrlToolkit {
        ToolkitID = expire_needed
        Match .*\.jpg$ Expire 1 weeks
        Match .*\.png$ Expire 1 weeks
        Match .*\.gif$ Expire 1 weeks
        Match .*\.css$ Expire 1 weeks
        Match .*\.js$ Expire 1 weeks
        Match .*\.gif$ Expire 1 weeks
        Match .*\.eot$ Expire 1 weeks
        Match .*\.svg$ Expire 1 weeks
        Match .*\.ttf$ Expire 1 weeks
        Match .*\.ico$ Expire 1 weeks
}

Binding {
        BindingId = port_nonssl
        Port = 7778
        #Interface = 0.0.0.0
        MaxKeepAlive = 3600
        TimeForRequest = 3600
        MaxRequestSize = 102400
        ## not able more than 100MB; hiawatha-9.3-2 able until 2GB
        MaxUploadSize = 2000
}

Binding {
        BindingId = port_ssl
        Port = 7777
        #Interface = 0.0.0.0
        MaxKeepAlive = 3600
        TimeForRequest = 3600
        MaxRequestSize = 102400
        ## not able more than 100MB; hiawatha-9.3-2 able until 2GB
        MaxUploadSize = 2000
        #RequiredCA = /usr/local/lxlabs/kloxo/etc/program.ca
        SSLcertFile = /usr/local/lxlabs/kloxo/etc/program.pem
}

## CF - no need for Virtual Host, all default to this:
Hostname = 0.0.0.0
WebsiteRoot = /usr/local/lxlabs/kloxo/httpdocs
StartFile = index.php
AccessLogfile = /usr/local/lxlabs/kloxo/log/hiawatha-access.log
ErrorLogfile = /usr/local/lxlabs/kloxo/log/hiawatha-error.log
SecureURL = no
UseFastCGI = PHP5
UseToolkit = block_shellshock, findindexfile, expire_needed
TimeForCGI = 3600
ErrorHandler = 401:/error/401.html
ErrorHandler = 403:/error/403.html
#ErrorHandler = 404:/error/404.html
ErrorHandler = 404:/theme/lbin/sitepreview.php
ErrorHandler = 501:/error/501.html
ErrorHandler = 503:/error/503.html[root@slave1 ~]#



[MRatWork]

Look like your Kloxo-MR in slave still using old version where their hiawatha config not match with latest hiawatha.

[bigdigillc]

How do I fix that? Also this is from the master server. Is this one correct?

Code: [Select]


[root@BIGHOST ~]# cat /usr/local/lxlabs/kloxo/init/hiawatha.conf
# Hiawatha main configuration file
# Convictions Hosting Custom - September 9th

ServerString = Hiawatha_for_Kloxo-MR

ServerId = lxlabs
ConnectionsTotal = 2048
ConnectionsPerIP = 64
SystemLogfile = /var/log/hiawatha/system.log
GarbageLogfile = /var/log/hiawatha/garbage.log
ExploitLogfile = /var/log/hiawatha/exploit.log
ErrorLogfile = /var/log/hiawatha/error.log
AccessLogfile = /var/log/hiawatha/access.log

MaxUrlLength = 65536

PIDfile = /usr/local/lxlabs/kloxo/init/kloxo-hiawatha.pid

ChallengeClient = 300, httpheader, 60

BanOnGarbage = 300
BanOnMaxPerIP = 60
BanOnMaxReqSize = 300
KickOnBan = yes
RebanDuringBan = yes

ThreadPoolSize = 50

CGIhandler = /usr/bin/perl:pl
CGIhandler = /usr/bin/perl:cgi
CGIhandler = /usr/bin/php54s-cgi:php
CGIhandler = /usr/bin/python:py
CGIhandler = /usr/bin/ruby:rb
CGIhandler = /usr/bin/ssi-cgi:shtml
#CGIextension = php

#CGIwrapper = /usr/sbin/cgi-wrapper

ExecuteCGI = yes
WaitForCGI = yes

MinTLSversion = TLS1.0

FastCGIserver {
        FastCGIid = PHP5
        #ConnectTo = 127.0.0.1:39000
        ConnectTo = /usr/local/lxlabs/kloxo/init/kloxo-phpcgi.sock
        Extension = php
        SessionTimeout = 3600
}

MimetypeConfig = hiawatha-mimetype.conf

UrlToolkit {
        ToolkitID = block_shellshock
        #Header * \(\)\s*\{ DenyAccess
        Header User-Agent \(\)\s*\{ DenyAccess
        Header Referer \(\)\s*\{ DenyAccess
}

UrlToolkit {
        ToolkitID = findindexfile
        Match ^([^?]*)/(\?.*)?$ Rewrite $1/index.php$2 Continue
        RequestURI isfile Return
        Match ^([^?]*)/index\.php(\?.*)?$ Rewrite $1/index.html$2 Continue
        RequestURI isfile Return
        Match ^([^?]*)/index\.html(\?.*)?$ Rewrite $1/index.htm$2 Continue
        RequestURI isfile Return
        Match ^([^?]*)/index\.htm(\?.*)?$ Rewrite $1/$2 Continue
}

Directory {
        DirectoryID = static_file
        Path = /
        Extensions = css,eot,gif,htm,html,ico,jpeg,jpg,js,otf,pdf,png,ps,psd,svg,swf,ttf,txt,woff,woff2
        ExpirePeriod = 1 weeks
}

Binding {
        BindingId = port_nonssl
        Port = 7778
        #Interface = 0.0.0.0
        MaxKeepAlive = 3600
        TimeForRequest = 3600
        MaxRequestSize = 2096128
        MaxUploadSize = 2047
}

Binding {
        BindingId = port_ssl
        Port = 7777
        #Interface = 0.0.0.0
        MaxKeepAlive = 3600
        TimeForRequest = 3600
        MaxRequestSize = 2096128
        MaxUploadSize = 2047
        #RequiredCA = /usr/local/lxlabs/kloxo/etc/program.ca
        TLScertFile = /usr/local/lxlabs/kloxo/etc/program.pem
}

## CF - no need for Virtual Host, all default to this:
Hostname = 0.0.0.0, ::
Alias = /.well-known/acme-challenge:/var/run/acme/acme-challenge
WebsiteRoot = /usr/local/lxlabs/kloxo/httpdocs
StartFile = index.php
SecureURL = no
UseFastCGI = PHP5
UseToolkit = block_shellshock, findindexfile
UseDirectory = static_file
TimeForCGI = 3600
ErrorHandler = 401:/error/401.html
ErrorHandler = 403:/error/403.html
#ErrorHandler = 404:/error/404.html
ErrorHandler = 404:/theme/lbin/sitepreview.php
ErrorHandler = 501:/error/501.html
ErrorHandler = 503:/error/503.html[root@BIGHOST ~]#


[bigdigillc]

I don't know if it matters, but both servers were updated from the original Kloxo.

[MRatWork]

Copy /usr/local/lxlabs/kloxo/init/hiawatha.conf.base from master to slave.

[MRatWork]

Also, make sure running 'yum clean all; yum update -y' in slave.

[bigdigillc]

Still no luck. Won't start and still no PHPMyAdmin. I have also tried running upcp a few times but it doesn't seem to finish. I get a few errors like "Transaction size changed - this means we are doing the same transaction as we were before. Aborting"

What now?

[MRatWork]

If you see hiawatha.conf.base (or hiawatha.conf) you can see different. You will be 'MinSSLversion' and 'SSLcertFile' in slave but 'MinTLSversion' and 'TLScertFile' in master.

The new Kloxo-MR 7.0 use  'MinTLSversion' and 'TLScertFile' because hiawatha need it.

[bigdigillc]

Thank you! Replacing the hiawatha.conf did the trick! I'm back !

[MRatWork]

Thank you! Replacing the hiawatha.conf did the trick! I'm back !

It's weird because if your slave already using latest Kloxo-MR 7.0, hiawatha.conf.base will be updated.