MRatWork Forum by Mustafa Ramadhan
Sawo Project - Kloxo-MR Discussions => Kloxo-MR Development => Topic started by: ibuxxi on 2014-06-25, 19:35:47
-
Hello
how can i fix roundcube DATABASE ERROR: CONNECTION FAILED!
I cleanup
and fixwebmail say
sh /script/fixwebmail
Preparing Horde database
- Fix MySQL commands in import files of Horde
- Generating password
- Add password to configuration file
Could not grant privileges. Script Aborted
sh /script/reset-mysql-root-password keyword
sh /script/reset-mysql-root-password keyword
Stop MySQL service...
MySQL ROOT password reset...
Start MySQL service...
Connect failed: Access denied for user 'root'@'localhost' (using password: YES)
sysinfo
A. Kloxo-MR: 6.5.1.b-2014062401
B. OS: CentOS release 6.5 (Final) i686
C. Apps:
1. MySQL: MariaDB-server-5.5.36-1.el6.i686
2. PHP: php53u-5.3.28-5.ius.el6.i686
3. Httpd: httpd-2.2.27-1.mr.e6.i386
4. Lighttpd: --uninstalled--
5. Hiawatha: hiawatha-9.6-2.mr.el6.i386
6. Nginx: --uninstalled--
7. Cache: --uninstalled--
8. Dns: bind-9.9.5-1.el6.i686
9. Qmail: qmail-toaster-1.03-1.3.38.mr.el6.i386
- with: courier-imap-toaster-4.1.2-1.3.16.mr.el6.i386
D. Php-type (for Httpd/proxy): php-fpm_event
E. Memory:
total used free shared buffers cached
Mem: 1893 1661 232 0 88 1294
-/+ buffers/cache: 278 1615
Swap: 0 0 0
-
Try 'sh /script/fixmail-all'.
-
not work
sh /script/fixmail-all
Change qmail.init
--------------------------
Fix '89' uid to vpopmail:vchkpw ownership
--------------------------
Set '/home/vpopmail/bin/vchkpw' for root:root ownership
--------------------------
Set '/home/vpopmail' for 755 permissions
Set '/home/vpopmail/domains' for 755 permissions
Set '/home/lxadmin' for 755 permissions
Set '/home/lxadmin/mail' for 755 permissions
Set '/home/lxadmin/mail/domains' for 755 permissions
Set '/home/vpopmail/bin/vchkpw' for 4751 permissions
--------------------------
Set '/var/qmail/control/locals' with 'localhost' only
--------------------------
Using qmail-toaster - fix '/home/vpopmail/etc/vpopmail.mysql'
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
--------------------------
--------------------------
- For help, type '/script/fixmail --help'
- No argument supplied. Defaulting to localhost (master) servers
Fixing Mail accounts (also 'lists' if exists)
--------------------------
Fixing Domainkeys
--------------------------
Preparing Horde database
- Fix MySQL commands in import files of Horde
- Generating password
- Add password to configuration file
Could not grant privileges. Script Aborted
and no login kloxo admin :-(
Alert: Login Unsuccessful
-
Try 'sh /script/reset-mysql-root-password YOURPASSWORD' first.
-
Ok, there are something trouble if using mariadb for access to panel.
Need using php54s install php53s for panel. Try:
sh /script/php54s-installer
sh /script/fixlxphpexe php54s
sh /script/restart
-
Try 'sh /script/reset-mysql-root-password YOURPASSWORD' first.
Connect failed:
sh /script/reset-mysql-root-password keyword
Stop MySQL service...
MySQL ROOT password reset...
Start MySQL service...
Connect failed: Access denied for user 'root'@'localhost' (using password: YES)
-
sh /script/php54s-installer
=== BEGIN 'php54s' (2014/06/26 03:08:26) install ===
- 'php54' ready to installed
- Install php general dependencies rpms... Please wait!
-- Check installed dependencies rpms
-- Install for not installed dependencies rpms
- Download all rpms (debug and devel will be deleted)... Please wait!
- Extract all rpms to '/opt/php54s'
- Disable certain modules (rename to .nonini) in '/etc/php54s/etc/' + 'php.d' and 'php-zts.d'
-- Disable 'dba' modules in '/etc/php54s/etc/php.d'
-- Disable 'dba' modules in '/etc/php54s/etc/php-zts.d'
-- Disable 'pdo_dblib' modules in '/etc/php54s/etc/php.d'
-- Disable 'pdo_dblib' modules in '/etc/php54s/etc/php-zts.d'
-- Disable 'pdo_odbc' modules in '/etc/php54s/etc/php.d'
-- Disable 'pdo_odbc' modules in '/etc/php54s/etc/php-zts.d'
-- Disable 'pdo_pgsql' modules in '/etc/php54s/etc/php.d'
-- Disable 'pdo_pgsql' modules in '/etc/php54s/etc/php-zts.d'
-- Disable 'pgsql' modules in '/etc/php54s/etc/php.d'
-- Disable 'pgsql' modules in '/etc/php54s/etc/php-zts.d'
-- Disable 'suhosin' modules in '/etc/php54s/etc/php.d'
-- Disable 'odbc' modules in '/etc/php54s/etc/php.d'
-- Disable 'odbc' modules in '/etc/php54s/etc/php-zts.d'
-- Disable 'mongo' modules in '/etc/php54s/etc/php.d'
-- Disable 'apc' modules in '/etc/php54s/etc/php.d'
-- Disable 'imagick' modules in '/etc/php54s/etc/php.d'
-- Disable 'interbase' modules in '/etc/php54s/etc/php.d'
-- Disable 'interbase' modules in '/etc/php54s/etc/php-zts.d'
-- Disable 'ioncube-loader' modules in '/etc/php54s/etc/php.d'
-- Disable 'memcache' modules in '/etc/php54s/etc/php.d'
-- Disable 'memcached' modules in '/etc/php54s/etc/php.d'
-- Disable 'mssql' modules in '/etc/php54s/etc/php.d'
-- Disable 'mssql' modules in '/etc/php54s/etc/php-zts.d'
-- Disable 'pdo_firebird' modules in '/etc/php54s/etc/php.d'
-- Disable 'pdo_firebird' modules in '/etc/php54s/etc/php-zts.d'
-- Enable 'mysqlnd' instead 'mysql' modules in '/etc/php54s/etc/php.d'
-- Enable 'mysqlnd' instead 'mysql' modules in '/etc/php54s/etc/php-zts.d'
-- Enable 'mysqlnd' instead 'mysql' modules in '/etc/php54s/etc/php.d'
-- Enable 'mysqlnd' instead 'mysql' modules in '/etc/php54s/etc/php-zts.d'
-- Enable 'mysqlnd' instead 'mysql' modules in '/etc/php54s/etc/php.d'
-- Enable 'mysqlnd' instead 'mysql' modules in '/etc/php54s/etc/php-zts.d'
-- Enable 'mysqlnd' instead 'mysql' modules in '/etc/php54s/etc/php.d'
-- Enable 'mysqlnd' instead 'mysql' modules in '/etc/php54s/etc/php-zts.d'
-- Enable 'mysqlnd' instead 'mysql' modules in '/etc/php54s/etc/php.d'
-- Enable 'mysqlnd' instead 'mysql' modules in '/etc/php54s/etc/php-zts.d'
-- Disable 'xdebug' modules in '/etc/php54s/etc/php.d'
-- Disable 'xcache' modules in '/etc/php54s/etc/php.d'
-- Disable 'lzf' modules in '/etc/php54s/etc/php.d'
-- Disable 'redis' modules in '/etc/php54s/etc/php.d'
-- Disable 'redis' modules in '/etc/php54s/etc/php-zts.d'
-- Disable 'enchant' modules in '/etc/php54s/etc/php.d'
-- Disable 'enchant' modules in '/etc/php54s/etc/php-zts.d'
-- Disable 'phar' modules in '/etc/php54s/etc/php.d'
-- Disable 'phar' modules in '/etc/php54s/etc/php-zts.d'
-- Disable 'intl' modules in '/etc/php54s/etc/php.d'
-- Disable 'intl' modules in '/etc/php54s/etc/php-zts.d'
-- Disable 'geoip' modules in '/etc/php54s/etc/php.d'
-- Disable 'fileinfo' modules in '/etc/php54s/etc/php.d'
-- Disable 'fileinfo' modules in '/etc/php54s/etc/php-zts.d'
-- Disable 'tidy' modules in '/etc/php54s/etc/php.d'
-- Disable 'tidy' modules in '/etc/php54s/etc/php-zts.d'
- Copy certain files to '/opt/php54s/custom'
- Set .sh to 755
- Create .sh symlink
-- From '/opt/php54s/custom/php54s-cgi.sh' to '/usr/bin/php54s-cgi'
-- From '/opt/php54s/custom/php54s-cli.sh' to '/usr/bin/php54s-cli'
-- From '/opt/php54s/custom/php54s-ls.sh' to '/usr/bin/php54s-ls'
-- From '/opt/php54s/custom/php54s-fpm.sh' to '/usr/bin/php54s-fpm'
=== END 'php54s' (2014/06/26 03:08:26) install ===
Note:
- See '/opt/php54s/install.log' for detail install process
- Example: copy 'xcache.nonini' to '_xcache.ini' for enable 'xcache' module
in '/etc/php54s/etc/php.d'
- Running 'sh /script/php53m-installer' as the same as
'sh /script/phpm-installer php53m'
- For config setup only, run 'sh /script/phpm-config-setup php53m
[root@happy2 ~]# sh /script/fixlxphpexe php54s
Execute fixlxphpexe for php54s...
[root@happy2 ~]# sh /script/restart-all
Shutting down MySQL. [ OK ]
Starting MySQL.. [ OK ]
nsd beenden: [ OK ]
nsd starten: [ OK ]
httpd beenden: [ OK ]
httpd starten: [ OK ]
Stopping qmail-toaster: svscan qmail logging.
qmail-send: Kein Prozess abgebrochen
Starting qmail-toaster: svscan.
xinetd beenden: [ OK ]
xinetd starten: [ OK ]
Execute fixlxphpexe for php54s...
Stopping kloxo-phpcgi: [ OK ]
Starting kloxo-phpcgi: [ OK ]
Stopping kloxo-hiawatha: [ OK ]
Starting kloxo-hiawatha: [ OK ]
php-fpm beenden: [ OK ]
php-fpm starten: [ OK ]
[root@happy2 ~]#
Ok, there are something trouble if using mariadb for access to panel.
Need using php54s install php53s for panel. Try:
sh /script/php54s-installer
sh /script/fixlxphpexe php54s
sh /script/restart
-
All services load OK
but all sites or kloxo or webmail or mail not work
-
Try 'sh /script/cleanup; sh /script/restart-all'.
-
- Create database interface template (Forced)
ERROR 1045 (28000): Access denied for user 'kloxo'@'localhost' (using password: YES)
and
Hiawatha web server not start
sh /script/cleanup; sh /script/restart-all
Execute fixlxphpexe for php54s...
*** 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
Fix Services
- 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)
ERROR 1045 (28000): Access denied for user 'kloxo'@'localhost' (using password: YES)
>>> 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
- php-cgi binary already installed
- Symlink /usr/local/bin/php already exists
Remove lighttpd errorlog
- Remove process
Fix the secure logfile
- Fix process
Clean hosts.deny
- Clean process
Killing gettraffic system process
- Killing process
Update Services Branch List
- List for 'dns' branch
- List for 'httpd' branch
- List for 'mysql' branch
- List for 'nginx' branch
- List for 'php' branch
- List for 'qmail' branch
- List for 'webcache' branch
Checking for rpm packages
- For autorespond-toaster package
- For courier-authlib-toaster package
- For courier-imap-toaster package
- For daemontools-toaster package
- For ezmlm-toaster package
- For libdomainkeys-toaster package
- For libsrs2-toaster package
- For maildrop-toaster package
- For qmail-pop3d-toaster package
- For qmail-toaster package
- For ripmime-toaster package
- For ucspi-tcp-toaster package
- For vpopmail-toaster package
- For fetchmail package
- For bogofilter package
- For spamdyke package
- For spamdyke-utils package
- For pure-ftpd package
- For php53u package
- For php53u-mbstring package
- For php53u-mysql package
- For php53u-pear package
- For php53u-pecl-geoip package
- For php53u-gd package
- For php53u-mcrypt package
- For php53u-xml package
- For php53u-bcmath package
- For php53u-pgsql package
- For webalizer package
- For dos2unix package
- For rrdtool package
- For xinetd package
- For lxjailshell package
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* 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
Enable the correct drivers (Service daemons)
Remove cache dir
- Remove process
Restart syslog service
- Restart process
Initialize awstats dirdata
- Initialize process
Update Kloxo database
- Updating process
Remove old lxlabs ssh key
- Remove process
- Preparing MySQL/MariaDB service
- MariaDB activated
- Updating Main services
Updating Core packages
- New kloxomr version installed
- New httpd* lighttpd* nginx* hiawatha* openlitespeed* gwan* version installed
- New mod_* mysql* mariadb* MariaDB* php* version installed
- New bind* djbdns* maradns* pdns* nsd* version installed
Error: No matching Packages to list
- No 'varnish* trafficserver* squid*' update found/not installed
- New pure-ftpd* *-toaster bogofilter version installed
- New kloxomr-webmail-*.noarch version installed
- New kloxomr-thirdparty-*.noarch version installed
- New kloxomr-editor-*.noarch version installed
- Preparing some services again
- qmail enabled and restart queue
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
- chown apache:apache FOR /home/kloxo/httpd/ AND INSIDE
- chmod 644 FOR *.php* INSIDE /home/kloxo/httpd/
- chmod 755 FOR *.pl* 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
- 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 of bind
- Copy /usr/local/lxlabs/kloxo/file/bind to /home/bind
- Copy /home/bind/etc/conf/named.conf to /etc//named.conf
Copy all contents of djbdns
- Copy /usr/local/lxlabs/kloxo/file/djbdns to /home/djbdns
Copy all contents of maradns
- Copy /usr/local/lxlabs/kloxo/file/maradns to /home/maradns
- Copy /home/maradns/etc/mararc to /etc//mararc
Copy all contents of pdns
- Copy /usr/local/lxlabs/kloxo/file/pdns to /home/pdns
- Copy /home/pdns/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 of nsd
- Copy /usr/local/lxlabs/kloxo/file/nsd to /home/nsd
- Copy /home/nsd/etc/conf/nsd.conf to /etc//nsd/nsd.conf
Initialize apache config
- /etc/httpd/conf.d dir already exists
- /home/apache/tpl dir already exists
- /home/apache/conf dir already exists
- /home/apache/etc dir already exists
- /home/apache/etc/conf dir already exists
- /home/apache/etc/conf.d dir already exists
Copy all contents of apache
- Copy /usr/local/lxlabs/kloxo/file/apache to /home/apache
- Copy /home/apache/etc/conf/httpd.conf to /etc/httpd/conf/httpd.conf
- Copy /home/apache/etc/conf.d/~lxcenter.conf to /etc/httpd/conf.d/~lxcenter.conf
- Copy /home/apache/etc/conf.d/ssl.conf to /etc/httpd/conf.d/ssl.conf
- Copy /home/apache/etc/conf.d/__version.conf to /etc/httpd/conf.d/__version.conf
- chown root:root FOR /home/apache/ AND INSIDE
- chmod 755 FOR *.sh INSIDE /home/apache/
Initialize lighttpd config
- /etc/lighttpd/conf.d dir already exists
- /home/lighttpd/tpl dir already exists
- /home/lighttpd/conf dir already exists
- /home/lighttpd/etc dir already exists
- /home/lighttpd/etc/conf dir already exists
- /home/lighttpd/etc/conf.d dir already exists
Copy all contents of lighttpd
- Copy /usr/local/lxlabs/kloxo/file/lighttpd to /home/lighttpd
- Copy /home/lighttpd/etc/conf/lighttpd.conf to /etc/lighttpd/lighttpd.conf
- Copy /home/lighttpd/etc/conf.d/~lxcenter.conf to /etc/lighttpd/conf.d/~lxcenter.conf
- chown root:root FOR /home/lighttpd/ AND INSIDE
- chmod 755 FOR *.sh INSIDE /home/lighttpd/
Initialize nginx config
- /etc/nginx/conf.d dir already exists
- /home/nginx/tpl dir already exists
- /home/nginx/conf dir already exists
- /home/nginx/etc dir already exists
- /home/nginx/etc/conf dir already exists
- /home/nginx/etc/conf.d dir already exists
Copy all contents of nginx
- Copy /usr/local/lxlabs/kloxo/file/nginx to /home/nginx
- Copy /home/nginx/etc/conf/nginx.conf to /etc/nginx/nginx.conf
- Copy /home/nginx/etc/conf.d/~lxcenter.conf to /etc/nginx/conf.d/~lxcenter.conf
- chown root:root FOR /home/nginx/ AND INSIDE
- chmod 755 FOR *.sh INSIDE /home/nginx/
Initialize hiawatha config
- /etc/hiawatha/conf.d dir already exists
- /home/hiawatha/tpl dir already exists
- /home/hiawatha/conf dir already exists
- /home/hiawatha/etc dir already exists
- /home/hiawatha/etc/conf dir already exists
- /home/hiawatha/etc/conf.d dir already exists
Copy all contents of hiawatha
- Copy /usr/local/lxlabs/kloxo/file/hiawatha to /home/hiawatha
- Copy /home/hiawatha/etc/conf/hiawatha.conf to /etc/hiawatha/hiawatha.conf
- chown root:root FOR /home/hiawatha/ AND INSIDE
- chmod 755 FOR *.sh INSIDE /home/hiawatha/
Copy all contents of varnish
- Copy /usr/local/lxlabs/kloxo/file/varnish to /home/varnish
Copy all contents of trafficserver
- Copy /usr/local/lxlabs/kloxo/file/trafficserver to /home/trafficserver
Copy all contents of squid
- Copy /usr/local/lxlabs/kloxo/file/squid to /home/squid
- Install /etc/php-fpm.conf
- Copy php-fpm init to /etc/init.d dir
Copy all contents of openssl
- Copy /usr/local/lxlabs/kloxo/file/openssl to /home/openssl
Initialize PureFtp service
- Initialize process
Make pure-ftpd user database
- Restart xinetd service for pureftp
Initialize logrotate
Preparing RoundCube database
- Fixing MySQL commands in import files
- Generating password
- Add Password to configuration file
- Could not grant privileges. Script Abort
*** Restart services - BEGIN ***
Shutting down MySQL. [ OK ]
Starting MySQL.. [ OK ]
nsd beenden: [ OK ]
nsd starten: [ OK ]
httpd beenden: [ OK ]
httpd starten: [ OK ]
Stopping Hiawatha web server: [FEHLGESCHLAGEN]
Stopping qmail-toaster: svscan qmail logging.
qmail-send: Kein Prozess abgebrochen
Starting qmail-toaster: svscan.
xinetd beenden: [ OK ]
xinetd starten: [ OK ]
Execute fixlxphpexe for php54s...
Stopping kloxo-phpcgi: [ OK ]
Starting kloxo-phpcgi: [ OK ]
Stopping kloxo-hiawatha: [ OK ]
Starting kloxo-hiawatha: [ OK ]
php-fpm beenden: [ OK ]
php-fpm starten: [ OK ]
*** Restart services - END ***
Process Time: 00:00:02:11.131731 (dd:hh:mm:ss:xxxxxx)
Shutting down MySQL. [ OK ]
Starting MySQL.. [ OK ]
nsd beenden: [ OK ]
nsd starten: [ OK ]
httpd beenden: [ OK ]
httpd starten: [ OK ]
Stopping qmail-toaster: svscan qmail logging.
qmail-send: Kein Prozess abgebrochen
Starting qmail-toaster: svscan.
xinetd beenden: [ OK ]
xinetd starten: [ OK ]
Execute fixlxphpexe for php54s...
Stopping kloxo-phpcgi: [ OK ]
Starting kloxo-phpcgi: [ OK ]
Stopping kloxo-hiawatha: [ OK ]
Starting kloxo-hiawatha: [ OK ]
php-fpm beenden: [ OK ]
php-fpm starten: [ OK ]
[root@happy2 ~]#
Try 'sh /script/cleanup; sh /script/restart-all'.
-
Run again 'sh /script/reset-mysql-root-password YOURPASSWORD; sh /script/fixmail-all'.
-
not work web,mail,kloxo
sh /script/reset-mysql-root-password YOURPASSWORD
sh /script/reset-mysql-root-password keyword
Stop MySQL service...
MySQL ROOT password reset...
Start MySQL service...
Connect failed: Access denied for user 'root'@'localhost' (using password: YES)
sh /script/fixmail-all
sh /script/fixmail-all
Change qmail.init
--------------------------
Fix '89' uid to vpopmail:vchkpw ownership
--------------------------
Set '/home/vpopmail/bin/vchkpw' for root:root ownership
--------------------------
Set '/home/vpopmail' for 755 permissions
Set '/home/vpopmail/domains' for 755 permissions
Set '/home/lxadmin' for 755 permissions
Set '/home/lxadmin/mail' for 755 permissions
Set '/home/lxadmin/mail/domains' for 755 permissions
Set '/home/vpopmail/bin/vchkpw' for 4751 permissions
--------------------------
Set '/var/qmail/control/locals' with 'localhost' only
--------------------------
Using qmail-toaster - fix '/home/vpopmail/etc/vpopmail.mysql'
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
--------------------------
--------------------------
- For help, type '/script/fixmail --help'
- No argument supplied. Defaulting to localhost (master) servers
Fixing Mail accounts (also 'lists' if exists)
--------------------------
Fixing Domainkeys
--------------------------
Preparing Horde database
- Fix MySQL commands in import files of Horde
- Generating password
- Add password to configuration file
Could not grant privileges. Script Aborted
Run again 'sh /script/reset-mysql-root-password YOURPASSWORD; sh /script/fixmail-all'.
-
Access to panel and then change 'MySQL Password Reset' before running fixmail-all.
-
No access to kloxo panel
Alert: Login Unsuccessful
Access to panel and then change 'MySQL Password Reset' before running fixmail-all.
-
In latest mratwork.repo, Kloxo-MR using MariaDB 10.0 instead 5.5. And you are using MariaDB 5.5.
I don't know what's happen in latest version of MariaDB 5.5 because Kloxo-MR recommend to use 10.0.
So, modified your /etc/yum.repos.d/mratwork.repo:
# for mariadb
[mratwork-mariadb-32]
name=Kloxo-MR - mariadb 32bit repo
baseurl=http://yum.mariadb.org/10.0/centos6-x86
enabled=0
gpgcheck=0
to:
# for mariadb
[mratwork-mariadb-32]
name=Kloxo-MR - mariadb 32bit repo
baseurl=http://yum.mariadb.org/10.0/centos6-x86
enabled=1
gpgcheck=0
and then running 'yum clean all; yum update'.
-
Error in PREIN scriptlet in rpm package MariaDB-server-10.0.12-1.el6.i686
yum clean all; yum update
Loaded plugins: fastestmirror, priorities, protectbase, replace
Cleaning repos: base extras mod-pagespeed mratwork-epel mratwork-google-mod-pagespeed mratwork-ius-archive mratwork-ius-stable mratwork-litespeed
: mratwork-litespeed-update mratwork-mariadb-32 mratwork-nginx mratwork-nginx-stable mratwork-release-neutral-noarch mratwork-release-version-arch
: mratwork-testing-neutral-noarch mratwork-varnish-3.0 updates
Cleaning up Everything
Cleaning up list of fastest mirrors
Loaded plugins: fastestmirror, priorities, protectbase, replace
Determining fastest mirrors
mratwork-epel/metalink | 10 kB 00:00
* base: www.gtlib.gatech.edu
* extras: www.gtlib.gatech.edu
* mratwork-epel: ftp.linux.ncsu.edu
* mratwork-ius-stable: archive.linux.duke.edu
* updates: www.gtlib.gatech.edu
base | 3.7 kB 00:00
base/primary_db | 3.5 MB 00:01
extras | 3.4 kB 00:00
extras/primary_db | 18 kB 00:00
mod-pagespeed | 951 B 00:00
mod-pagespeed/primary | 5.7 kB 00:00
mod-pagespeed 36/36
mratwork-epel | 4.4 kB 00:00
mratwork-epel/primary_db | 5.1 MB 00:00
mratwork-google-mod-pagespeed | 951 B 00:00
mratwork-google-mod-pagespeed/primary | 5.7 kB 00:00
mratwork-google-mod-pagespeed 36/36
mratwork-ius-archive | 2.2 kB 00:00
mratwork-ius-archive/primary_db | 1.4 MB 00:00
mratwork-ius-stable | 2.1 kB 00:00
mratwork-ius-stable/primary_db | 143 kB 00:00
mratwork-litespeed | 951 B 00:00
mratwork-litespeed/primary | 32 kB 00:00
mratwork-litespeed 156/156
mratwork-litespeed-update | 951 B 00:00
mratwork-litespeed-update/primary | 18 kB 00:00
mratwork-litespeed-update 90/90
mratwork-mariadb-32 | 1.9 kB 00:00
mratwork-mariadb-32/primary_db | 18 kB 00:00
mratwork-nginx | 2.9 kB 00:00
mratwork-nginx/primary_db | 21 kB 00:00
mratwork-nginx-stable | 2.9 kB 00:00
mratwork-nginx-stable/primary_db | 30 kB 00:00
mratwork-release-neutral-noarch | 951 B 00:00
mratwork-release-neutral-noarch/primary | 22 kB 00:00
mratwork-release-neutral-noarch 75/75
mratwork-release-version-arch | 951 B 00:00
mratwork-release-version-arch/primary | 95 kB 00:00
mratwork-release-version-arch 274/274
mratwork-testing-neutral-noarch | 951 B 00:00
mratwork-testing-neutral-noarch/primary | 30 kB 00:00
mratwork-testing-neutral-noarch 124/124
mratwork-varnish-3.0 | 951 B 00:00
mratwork-varnish-3.0/primary | 3.6 kB 00:00
mratwork-varnish-3.0 10/10
updates | 3.4 kB 00:00
updates/primary_db | 3.4 MB 00:01
0 packages excluded due to repository protections
Setting up Update Process
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-client.i686 0:5.5.36-1.el6 will be updated
---> Package MariaDB-client.i686 0:10.0.12-1.el6 will be an update
---> Package MariaDB-common.i686 0:5.5.36-1.el6 will be updated
---> Package MariaDB-common.i686 0:10.0.12-1.el6 will be an update
---> Package MariaDB-compat.i686 0:5.5.36-1.el6 will be updated
---> Package MariaDB-compat.i686 0:10.0.12-1.el6 will be an update
---> Package MariaDB-server.i686 0:5.5.36-1.el6 will be updated
---> Package MariaDB-server.i686 0:10.0.12-1.el6 will be an update
---> Package MariaDB-shared.i686 0:5.5.36-1.el6 will be updated
---> Package MariaDB-shared.i686 0:10.0.12-1.el6 will be an update
---> Package coreutils.i686 0:8.4-31.el6_5.1 will be updated
---> Package coreutils.i686 0:8.4-31.el6_5.2 will be an update
---> Package coreutils-libs.i686 0:8.4-31.el6_5.1 will be updated
---> Package coreutils-libs.i686 0:8.4-31.el6_5.2 will be an update
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================================================================================================
Package Arch Version Repository Size
================================================================================================================================================================
Updating:
MariaDB-client i686 10.0.12-1.el6 mratwork-mariadb-32 11 M
MariaDB-common i686 10.0.12-1.el6 mratwork-mariadb-32 23 k
MariaDB-compat i686 10.0.12-1.el6 mratwork-mariadb-32 2.6 M
MariaDB-server i686 10.0.12-1.el6 mratwork-mariadb-32 40 M
MariaDB-shared i686 10.0.12-1.el6 mratwork-mariadb-32 1.2 M
coreutils i686 8.4-31.el6_5.2 updates 3.0 M
coreutils-libs i686 8.4-31.el6_5.2 updates 50 k
Transaction Summary
================================================================================================================================================================
Upgrade 7 Package(s)
Total download size: 58 M
Is this ok [y/N]: y
Downloading Packages:
(1/7): MariaDB-10.0.12-centos6-i686-client.rpm | 11 MB 00:04
(2/7): MariaDB-10.0.12-centos6-i686-common.rpm | 23 kB 00:00
(3/7): MariaDB-10.0.12-centos6-i686-compat.rpm | 2.6 MB 00:00
(4/7): MariaDB-10.0.12-centos6-i686-server.rpm | 40 MB 00:08
(5/7): MariaDB-10.0.12-centos6-i686-shared.rpm | 1.2 MB 00:00
(6/7): coreutils-8.4-31.el6_5.2.i686.rpm | 3.0 MB 00:01
(7/7): coreutils-libs-8.4-31.el6_5.2.i686.rpm | 50 kB 00:00
----------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 3.5 MB/s | 58 MB 00:16
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Updating : MariaDB-compat-10.0.12-1.el6.i686 1/14
Updating : MariaDB-common-10.0.12-1.el6.i686 2/14
Updating : MariaDB-client-10.0.12-1.el6.i686 3/14
Updating : coreutils-8.4-31.el6_5.2.i686 4/14
Updating : coreutils-libs-8.4-31.el6_5.2.i686 5/14
Error in PREIN scriptlet in rpm package MariaDB-server-10.0.12-1.el6.i686
******************************************************************
A MySQL or MariaDB server package (MariaDB-server-5.5.36-1.el6.i686) is installed.
Upgrading directly from MySQL 5.5 to MariaDB 10.0 may not
be safe in all cases. A manual dump and restore using mysqldump is
recommended. It is important to review the MariaDB manual's Upgrading
section for version-specific incompatibilities.
A manual upgrade is required.
- Ensure that you have a complete, working backup of your data and my.cnf
files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages. Usually this command will
list the packages you should remove:
rpm -qa | grep -i '^mysql-'
You may choose to use 'rpm --nodeps -ev <package-name>' to remove
the package which contains the mysqlclient shared library. The
library will be reinstalled by the MariaDB-shared package.
- Install the new MariaDB packages supplied by Monty Program AB
- Ensure that the MariaDB server is started
- Run the 'mysql_upgrade' program
This is a brief description of the upgrade process. Important details
can be found in the MariaDB manual, in the Upgrading section.
******************************************************************
error: %pre(MariaDB-server-10.0.12-1.el6.i686) scriptlet failed, exit status 1
error: install: %pre scriptlet failed (2), skipping MariaDB-server-10.0.12-1.el6
Updating : MariaDB-shared-10.0.12-1.el6.i686 7/14
Cleanup : coreutils-8.4-31.el6_5.1.i686 8/14
Cleanup : coreutils-libs-8.4-31.el6_5.1.i686 9/14
Cleanup : MariaDB-shared-5.5.36-1.el6.i686 10/14
Cleanup : MariaDB-client-5.5.36-1.el6.i686 11/14
Cleanup : MariaDB-compat-5.5.36-1.el6.i686 12/14
Cleanup : MariaDB-common-5.5.36-1.el6.i686 13/14
Verifying : MariaDB-common-10.0.12-1.el6.i686 1/14
Verifying : coreutils-libs-8.4-31.el6_5.2.i686 2/14
Verifying : MariaDB-compat-10.0.12-1.el6.i686 3/14
Verifying : coreutils-8.4-31.el6_5.2.i686 4/14
Verifying : MariaDB-client-10.0.12-1.el6.i686 5/14
Verifying : MariaDB-shared-10.0.12-1.el6.i686 6/14
Verifying : MariaDB-client-5.5.36-1.el6.i686 7/14
Verifying : MariaDB-shared-5.5.36-1.el6.i686 8/14
MariaDB-server-5.5.36-1.el6.i686 was supposed to be removed but is not!
Verifying : MariaDB-server-5.5.36-1.el6.i686 9/14
Verifying : MariaDB-common-5.5.36-1.el6.i686 10/14
Verifying : coreutils-libs-8.4-31.el6_5.1.i686 11/14
Verifying : coreutils-8.4-31.el6_5.1.i686 12/14
Verifying : MariaDB-server-10.0.12-1.el6.i686 13/14
Verifying : MariaDB-compat-5.5.36-1.el6.i686 14/14
Updated:
MariaDB-client.i686 0:10.0.12-1.el6 MariaDB-common.i686 0:10.0.12-1.el6 MariaDB-compat.i686 0:10.0.12-1.el6 MariaDB-shared.i686 0:10.0.12-1.el6
coreutils.i686 0:8.4-31.el6_5.2 coreutils-libs.i686 0:8.4-31.el6_5.2
Failed:
MariaDB-server.i686 0:5.5.36-1.el6 MariaDB-server.i686 0:10.0.12-1.el6
Complete!
[root@happy2 ~]#
-
Huh, still exists bug in MariaDB 10.0.
Try with:
## back to use mysql first
sh /script/mariadb-to-mysql
## change back to mariadb
sh /script/mysql-to-mariadb
-
Warning: RPMDB altered outside of yum.
** Found 7 pre-existing rpmdb problem(s), 'yum check' output follows:
courier-authlib-toaster-0.59.2-1.3.12.mr.el6.i686 has missing requires of libmysqlclient.so.18
courier-authlib-toaster-0.59.2-1.3.12.mr.el6.i686 has missing requires of libmysqlclient.so.18(libmysqlclient_16)
qmail-toaster-1.03-1.3.38.mr.el6.i386 has missing requires of libmysqlclient.so.18
qmail-toaster-1.03-1.3.38.mr.el6.i386 has missing requires of libmysqlclient.so.18(libmysqlclient_16)
vpopmail-toaster-5.4.33-1.4.3.mr.el6.i686 has missing requires of libmysqlclient.so.18
vpopmail-toaster-5.4.33-1.4.3.mr.el6.i686 has missing requires of libmysqlclient.so.18(libmysqlclient_16)
vpopmail-toaster-5.4.33-1.4.3.mr.el6.i686 has missing requires of mysql >= ('0', '5.0.22', None)
sh /script/mariadb-to-mysql
sh /script/mariadb-to-mysql
*** Change MariaDB to MySQL - begin ***
Loaded plugins: fastestmirror, priorities, protectbase, replace
Cleaning repos: base extras mod-pagespeed mratwork-epel
: mratwork-google-mod-pagespeed mratwork-ius-archive
: mratwork-ius-stable mratwork-litespeed mratwork-litespeed-update
: mratwork-mariadb-32 mratwork-nginx mratwork-nginx-stable
: mratwork-release-neutral-noarch mratwork-release-version-arch
: mratwork-testing-neutral-noarch mratwork-varnish-3.0 updates
Cleaning up Everything
Cleaning up list of fastest mirrors
Update Services Branch List
- List for 'dns' branch
- List for 'httpd' branch
- List for 'mysql' branch
- List for 'nginx' branch
- List for 'php' branch
- List for 'qmail' branch
- List for 'webcache' branch
- Remove MariaDB packages
rpm: Es wurden keine Pakete für die Deinstallation angegeben
- Install MySQL
Loaded plugins: fastestmirror, priorities, protectbase, replace
Loading mirror speeds from cached hostfile
* base: mirror.atlanticmetro.net
* extras: mirror.atlanticmetro.net
* mratwork-epel: ftp.linux.ncsu.edu
* mratwork-ius-stable: archive.linux.duke.edu
* updates: mirror.atlanticmetro.net
0 packages excluded due to repository protections
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql55.i686 0:5.5.38-1.ius.el6 will be installed
--> Processing Dependency: mysql55-libs = 5.5.38-1.ius.el6 for package: mysql55-5.5.38-1.ius.el6.i686
--> Processing Dependency: mysqlclient16 for package: mysql55-5.5.38-1.ius.el6.i686
---> Package mysql55-server.i686 0:5.5.38-1.ius.el6 will be installed
--> Running transaction check
---> Package mysql55-libs.i686 0:5.5.38-1.ius.el6 will be installed
---> Package mysqlclient16.i686 0:5.1.61-4.ius.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
mysql55 i686 5.5.38-1.ius.el6 mratwork-ius-stable 9.1 M
mysql55-server i686 5.5.38-1.ius.el6 mratwork-ius-stable 9.8 M
Installing for dependencies:
mysql55-libs i686 5.5.38-1.ius.el6 mratwork-ius-stable 787 k
mysqlclient16 i686 5.1.61-4.ius.el6 mratwork-ius-stable 1.4 M
Transaction Summary
================================================================================
Install 4 Package(s)
Total download size: 21 M
Installed size: 90 M
Downloading Packages:
--------------------------------------------------------------------------------
Total 15 MB/s | 21 MB 00:01
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
** Found 13 pre-existing rpmdb problem(s), 'yum check' output follows:
courier-authlib-toaster-0.59.2-1.3.12.mr.el6.i686 has missing requires of libmysqlclient.so.18
courier-authlib-toaster-0.59.2-1.3.12.mr.el6.i686 has missing requires of libmysqlclient.so.18(libmysqlclient_16)
perl-DBD-MySQL-4.013-3.el6.i686 has missing requires of libmysqlclient.so.16
perl-DBD-MySQL-4.013-3.el6.i686 has missing requires of libmysqlclient.so.16(libmysqlclient_16)
php53u-mysql-5.3.28-5.ius.el6.i686 has missing requires of libmysqlclient.so.16
php53u-mysql-5.3.28-5.ius.el6.i686 has missing requires of libmysqlclient.so.16(libmysqlclient_16)
pure-ftpd-1.0.36-5.mr.el6.i686 has missing requires of libmysqlclient.so.16
pure-ftpd-1.0.36-5.mr.el6.i686 has missing requires of libmysqlclient.so.16(libmysqlclient_16)
qmail-toaster-1.03-1.3.38.mr.el6.i386 has missing requires of libmysqlclient.so.18
qmail-toaster-1.03-1.3.38.mr.el6.i386 has missing requires of libmysqlclient.so.18(libmysqlclient_16)
vpopmail-toaster-5.4.33-1.4.3.mr.el6.i686 has missing requires of libmysqlclient.so.18
vpopmail-toaster-5.4.33-1.4.3.mr.el6.i686 has missing requires of libmysqlclient.so.18(libmysqlclient_16)
vpopmail-toaster-5.4.33-1.4.3.mr.el6.i686 has missing requires of mysql >= ('0', '5.0.22', None)
Installing : mysql55-libs-5.5.38-1.ius.el6.i686 1/4
Installing : mysqlclient16-5.1.61-4.ius.el6.i686 2/4
Installing : mysql55-5.5.38-1.ius.el6.i686 3/4
Installing : mysql55-server-5.5.38-1.ius.el6.i686 4/4
Warnung: /var/log/mysqld.log erstellt als /var/log/mysqld.log.rpmnew
Verifying : mysql55-server-5.5.38-1.ius.el6.i686 1/4
Verifying : mysql55-5.5.38-1.ius.el6.i686 2/4
Verifying : mysqlclient16-5.1.61-4.ius.el6.i686 3/4
Verifying : mysql55-libs-5.5.38-1.ius.el6.i686 4/4
Installed:
mysql55.i686 0:5.5.38-1.ius.el6 mysql55-server.i686 0:5.5.38-1.ius.el6
Dependency Installed:
mysql55-libs.i686 0:5.5.38-1.ius.el6 mysqlclient16.i686 0:5.1.61-4.ius.el6
Complete!
- Restart MySQL
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
- Note: remove 'skip-innodb' from '/etc/my.cnf' and '/etc/my.cnf.d/my.cnf'.
Need reboot!.
*** Change MariaDB to MySQL - end ***
[root@happy2 ~]#
sh /script/mysql-to-mariadb
sh /script/mysql-to-mariadb
*** Change MySQL to MariaDB - begin ***
Loaded plugins: fastestmirror, priorities, protectbase, replace
Cleaning repos: base extras mod-pagespeed mratwork-epel
: mratwork-google-mod-pagespeed mratwork-ius-archive
: mratwork-ius-stable mratwork-litespeed mratwork-litespeed-update
: mratwork-mariadb-32 mratwork-nginx mratwork-nginx-stable
: mratwork-release-neutral-noarch mratwork-release-version-arch
: mratwork-testing-neutral-noarch mratwork-varnish-3.0 updates
Cleaning up Everything
Cleaning up list of fastest mirrors
Update Services Branch List
- List for 'dns' branch
- List for 'httpd' branch
- List for 'mysql' branch
- List for 'nginx' branch
- List for 'php' branch
- List for 'qmail' branch
- List for 'webcache' branch
Loaded plugins: fastestmirror, priorities, protectbase, replace
Cleaning repos: base extras mod-pagespeed mratwork-epel
: mratwork-google-mod-pagespeed mratwork-ius-archive
: mratwork-ius-stable mratwork-litespeed mratwork-litespeed-update
: mratwork-mariadb-32 mratwork-nginx mratwork-nginx-stable
: mratwork-release-neutral-noarch mratwork-release-version-arch
: mratwork-testing-neutral-noarch mratwork-varnish-3.0 updates
Cleaning up Everything
Cleaning up list of fastest mirrors
- Remove MySQL packages
Warnung: /var/log/mysqld.log als /var/log/mysqld.log.rpmsave gesichert
Warnung: /etc/my.cnf als /etc/my.cnf.rpmsave gesichert
rpm: Es wurden keine Pakete für die Deinstallation angegeben
- Install MariaDB
Loaded plugins: fastestmirror, priorities, protectbase, replace
Determining fastest mirrors
* base: ftp.usf.edu
* extras: ftp.usf.edu
* mratwork-epel: mirror.cogentco.com
* mratwork-ius-stable: archive.linux.duke.edu
* updates: ftp.usf.edu
0 packages excluded due to repository protections
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-client.i686 0:10.0.12-1.el6 will be installed
---> Package MariaDB-common.i686 0:10.0.12-1.el6 will be installed
---> Package MariaDB-compat.i686 0:10.0.12-1.el6 will be installed
---> Package MariaDB-server.i686 0:10.0.12-1.el6 will be installed
---> Package MariaDB-shared.i686 0:10.0.12-1.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
MariaDB-client i686 10.0.12-1.el6 mratwork-mariadb-32 11 M
MariaDB-common i686 10.0.12-1.el6 mratwork-mariadb-32 23 k
MariaDB-compat i686 10.0.12-1.el6 mratwork-mariadb-32 2.6 M
MariaDB-server i686 10.0.12-1.el6 mratwork-mariadb-32 40 M
MariaDB-shared i686 10.0.12-1.el6 mratwork-mariadb-32 1.2 M
Transaction Summary
================================================================================
Install 5 Package(s)
Total download size: 54 M
Installed size: 217 M
Downloading Packages:
--------------------------------------------------------------------------------
Total 9.8 MB/s | 54 MB 00:05
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
** Found 7 pre-existing rpmdb problem(s), 'yum check' output follows:
courier-authlib-toaster-0.59.2-1.3.12.mr.el6.i686 has missing requires of libmysqlclient.so.18
courier-authlib-toaster-0.59.2-1.3.12.mr.el6.i686 has missing requires of libmysqlclient.so.18(libmysqlclient_16)
qmail-toaster-1.03-1.3.38.mr.el6.i386 has missing requires of libmysqlclient.so.18
qmail-toaster-1.03-1.3.38.mr.el6.i386 has missing requires of libmysqlclient.so.18(libmysqlclient_16)
vpopmail-toaster-5.4.33-1.4.3.mr.el6.i686 has missing requires of libmysqlclient.so.18
vpopmail-toaster-5.4.33-1.4.3.mr.el6.i686 has missing requires of libmysqlclient.so.18(libmysqlclient_16)
vpopmail-toaster-5.4.33-1.4.3.mr.el6.i686 has missing requires of mysql >= ('0', '5.0.22', None)
Installing : MariaDB-common-10.0.12-1.el6.i686 1/5
Installing : MariaDB-compat-10.0.12-1.el6.i686 2/5
Installing : MariaDB-client-10.0.12-1.el6.i686 3/5
Installing : MariaDB-server-10.0.12-1.el6.i686 4/5
Installing : MariaDB-shared-10.0.12-1.el6.i686 5/5
Verifying : MariaDB-compat-10.0.12-1.el6.i686 1/5
Verifying : MariaDB-shared-10.0.12-1.el6.i686 2/5
Verifying : MariaDB-client-10.0.12-1.el6.i686 3/5
Verifying : MariaDB-common-10.0.12-1.el6.i686 4/5
Verifying : MariaDB-server-10.0.12-1.el6.i686 5/5
Installed:
MariaDB-client.i686 0:10.0.12-1.el6 MariaDB-common.i686 0:10.0.12-1.el6
MariaDB-compat.i686 0:10.0.12-1.el6 MariaDB-server.i686 0:10.0.12-1.el6
MariaDB-shared.i686 0:10.0.12-1.el6
Complete!
- Restart MariaDB
MySQL server PID file could not be found! [FAILED]
Starting MySQL. [ OK ]
- Note: remove 'skip-innodb' from '/etc/my.cnf' and '/etc/my.cnf.d/my.cnf'.
Need reboot!.
*** Change MySQL to MariaDB - end ***
[root@happy2 ~]#
Huh, still exists bug in MariaDB 10.0.
Try with:
## back to use mysql first
sh /script/mariadb-to-mysql
## change back to mariadb
sh /script/mysql-to-mariadb
-
Don't care about 'has missing requires of libmysqlclient.so.18(libmysqlclient_16)'.
-
sh /script/reset-mysql-root-password keyword
Stop MySQL service...
MySQL ROOT password reset...
Start MySQL service...
Connect failed: Access denied for user 'root'@'localhost' (using password: YES)
cleanup
create database interface template (Forced)
ERROR 1045 (28000): Access denied for user 'kloxo'@'localhost' (using password: YES)
-
For awhile try back to use mysql with 'sh /script/mariadb-to-mysql'. Still something wrong with MariaDB.
-
i switch back to mysql
sh /script/mariadb-to-mysql
*** Change MariaDB to MySQL - begin ***
Loaded plugins: fastestmirror, priorities, protectbase, replace
Cleaning repos: base extras mod-pagespeed mratwork-epel
: mratwork-google-mod-pagespeed mratwork-ius-archive
: mratwork-ius-stable mratwork-litespeed mratwork-litespeed-update
: mratwork-mariadb-32 mratwork-nginx mratwork-nginx-stable
: mratwork-release-neutral-noarch mratwork-release-version-arch
: mratwork-testing-neutral-noarch mratwork-varnish-3.0 updates
Cleaning up Everything
Cleaning up list of fastest mirrors
Update Services Branch List
- List for 'dns' branch
- List for 'httpd' branch
- List for 'mysql' branch
- List for 'nginx' branch
- List for 'php' branch
- List for 'qmail' branch
- List for 'webcache' branch
- Remove MariaDB packages
rpm: Es wurden keine Pakete für die Deinstallation angegeben
- Install MySQL
Loaded plugins: fastestmirror, priorities, protectbase, replace
Loading mirror speeds from cached hostfile
* base: ftp.usf.edu
* extras: ftp.usf.edu
* mratwork-epel: ftp.linux.ncsu.edu
* mratwork-ius-stable: archive.linux.duke.edu
* updates: ftp.usf.edu
0 packages excluded due to repository protections
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql55.i686 0:5.5.38-1.ius.el6 will be installed
--> Processing Dependency: mysql55-libs = 5.5.38-1.ius.el6 for package: mysql55-5.5.38-1.ius.el6.i686
---> Package mysql55-server.i686 0:5.5.38-1.ius.el6 will be installed
--> Running transaction check
---> Package mysql55-libs.i686 0:5.5.38-1.ius.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
mysql55 i686 5.5.38-1.ius.el6 mratwork-ius-stable 9.1 M
mysql55-server i686 5.5.38-1.ius.el6 mratwork-ius-stable 9.8 M
Installing for dependencies:
mysql55-libs i686 5.5.38-1.ius.el6 mratwork-ius-stable 787 k
Transaction Summary
================================================================================
Install 3 Package(s)
Total download size: 20 M
Installed size: 86 M
Downloading Packages:
--------------------------------------------------------------------------------
Total 4.5 MB/s | 20 MB 00:04
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
** Found 7 pre-existing rpmdb problem(s), 'yum check' output follows:
courier-authlib-toaster-0.59.2-1.3.12.mr.el6.i686 has missing requires of libmysqlclient.so.18
courier-authlib-toaster-0.59.2-1.3.12.mr.el6.i686 has missing requires of libmysqlclient.so.18(libmysqlclient_16)
qmail-toaster-1.03-1.3.38.mr.el6.i386 has missing requires of libmysqlclient.so.18
qmail-toaster-1.03-1.3.38.mr.el6.i386 has missing requires of libmysqlclient.so.18(libmysqlclient_16)
vpopmail-toaster-5.4.33-1.4.3.mr.el6.i686 has missing requires of libmysqlclient.so.18
vpopmail-toaster-5.4.33-1.4.3.mr.el6.i686 has missing requires of libmysqlclient.so.18(libmysqlclient_16)
vpopmail-toaster-5.4.33-1.4.3.mr.el6.i686 has missing requires of mysql >= ('0', '5.0.22', None)
Installing : mysql55-libs-5.5.38-1.ius.el6.i686 1/3
Installing : mysql55-5.5.38-1.ius.el6.i686 2/3
Installing : mysql55-server-5.5.38-1.ius.el6.i686 3/3
Warnung: /var/log/mysqld.log erstellt als /var/log/mysqld.log.rpmnew
Verifying : mysql55-server-5.5.38-1.ius.el6.i686 1/3
Verifying : mysql55-5.5.38-1.ius.el6.i686 2/3
Verifying : mysql55-libs-5.5.38-1.ius.el6.i686 3/3
Installed:
mysql55.i686 0:5.5.38-1.ius.el6 mysql55-server.i686 0:5.5.38-1.ius.el6
Dependency Installed:
mysql55-libs.i686 0:5.5.38-1.ius.el6
Complete!
- Restart MySQL
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
- Note: remove 'skip-innodb' from '/etc/my.cnf' and '/etc/my.cnf.d/my.cnf'.
Need reboot!.
*** Change MariaDB to MySQL - end ***
sh /script/reset-mysql-root-password keyword
Stop MySQL service...
MySQL ROOT password reset...
Start MySQL service...
Connect failed: No such file or directory
no kloxo,web,
no start mysql
cleanup
- Create database interface template (Forced)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
-
Inform here 'dir -l /etc/*my.cnf*; cat /etc/my.cnf; cat /etc/my.cnf/my.conf'.
-
dir -l /etc/*my.cnf*; cat /etc/my.cnf; cat /etc/my.cnf/my.conf
-rw-r--r-- 1 root root 202 12. Jun 05:26 /etc/my.cnf
-rw-r--r-- 1 root root 1124 26. Jun 08:28 /etc/my.cnf._bck_
-rw-r--r-- 1 root root 1124 26. Jun 08:08 /etc/my.cnf.rpmsave
/etc/my.cnf.d:
insgesamt 16
-rw-r--r-- 1 root root 295 12. Jun 05:26 client.cnf
-rw-r--r-- 1 root root 1124 26. Jun 08:29 my.cnf
-rw-r--r-- 1 root root 232 12. Jun 05:26 mysql-clients.cnf
-rw-r--r-- 1 root root 725 12. Jun 05:26 server.cnf
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
cat: /etc/my.cnf/my.conf: Ist kein Verzeichnis
/etc/my.cnf.d/my.cnf
[mysqld]
default-storage-engine=innodb
#OpenVZ AIO bug fix
innodb_use_native_aio=0
# Settings user and group are ignored when systemd is used (fedora >= 15).
# If you need to run mysqld under different user or group,
# customize your systemd unit file for mysqld according to the
# instructions in http://fedoraproject.org/wiki/Systemd
user=mysql
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Semisynchronous Replication
# http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html
# uncomment next line on MASTER
;plugin-load=rpl_semi_sync_master=semisync_master.so
# uncomment next line on SLAVE
;plugin-load=rpl_semi_sync_slave=semisync_slave.so
# Others options for Semisynchronous Replication
;rpl_semi_sync_master_enabled=1
;rpl_semi_sync_master_timeout=10
;rpl_semi_sync_slave_enabled=1
# http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html
;performance_schema
max_allowed_packet = 64M
wait_timeout = 6000
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
-
Run 'cp -f /etc/my.cnf._bck_ /etc/my.cnf; sh /script/restart-all'.
-
reset mysql password no error
but no cp or web works
[root@happy2 my.cnf.d]# sh /script/reset-mysql-root-password broiler27465
Stop MySQL service...
MySQL ROOT password reset...
Start MySQL service...
[root@happy2 my.cnf.d]# sh /script/restart-all
Shutting down MySQL... [ OK ]
Starting MySQL. [ OK ]
nsd beenden: [ OK ]
nsd starten: [ OK ]
httpd beenden: [ OK ]
httpd starten: [ OK ]
Stopping qmail-toaster: svscan qmail logging.
qmail-send: Kein Prozess abgebrochen
Starting qmail-toaster: svscan.
xinetd beenden: [ OK ]
xinetd starten: [ OK ]
Execute fixlxphpexe for php54s...
Stopping kloxo-phpcgi: [ OK ]
Starting kloxo-phpcgi: [ OK ]
Stopping kloxo-hiawatha: [ OK ]
Starting kloxo-hiawatha: [ OK ]
php-fpm beenden: [ OK ]
php-fpm starten: [ OK ]
-
cleanup
sh /script/cleanup
Execute fixlxphpexe for php54s...
*** 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
Fix Services
- 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
- php-cgi binary already installed
- Symlink /usr/local/bin/php already exists
Remove lighttpd errorlog
- Remove process
Fix the secure logfile
- Fix process
Clean hosts.deny
- Clean process
Killing gettraffic system process
- Killing process
Update Services Branch List
- List for 'dns' branch
- List for 'httpd' branch
- List for 'mysql' branch
- List for 'nginx' branch
- List for 'php' branch
- List for 'qmail' branch
- List for 'webcache' branch
Checking for rpm packages
- For autorespond-toaster package
- For courier-authlib-toaster package
- For courier-imap-toaster package
- For daemontools-toaster package
- For ezmlm-toaster package
- For libdomainkeys-toaster package
- For libsrs2-toaster package
- For maildrop-toaster package
- For qmail-pop3d-toaster package
- For qmail-toaster package
- For ripmime-toaster package
- For ucspi-tcp-toaster package
- For vpopmail-toaster package
- For fetchmail package
- For bogofilter package
- For spamdyke package
- For spamdyke-utils package
- For pure-ftpd package
- For php53u package
- For php53u-mbstring package
- For php53u-mysql package
- For php53u-pear package
- For php53u-pecl-geoip package
- For php53u-gd package
- For php53u-mcrypt package
- For php53u-xml package
- For php53u-bcmath package
- For php53u-pgsql package
- For webalizer package
- For dos2unix package
- For rrdtool package
- For xinetd package
- For lxjailshell package
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* 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
Enable the correct drivers (Service daemons)
Remove cache dir
- Remove process
Restart syslog service
- Restart process
Initialize awstats dirdata
- Initialize process
Update Kloxo database
- Updating process
Remove old lxlabs ssh key
- Remove process
- Preparing MySQL/MariaDB service
- MariaDB activated
- Updating Main services
Updating Core packages
- New kloxomr version installed
- New httpd* lighttpd* nginx* hiawatha* openlitespeed* gwan* version installed
- New mod_* mysql* mariadb* MariaDB* php* version installed
- New bind* djbdns* maradns* pdns* nsd* version installed
Error: No matching Packages to list
- No 'varnish* trafficserver* squid*' update found/not installed
- New pure-ftpd* *-toaster bogofilter version installed
- New kloxomr-webmail-*.noarch version installed
- New kloxomr-thirdparty-*.noarch version installed
- New kloxomr-editor-*.noarch version installed
- Preparing some services again
- qmail enabled and restart queue
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
- chown apache:apache FOR /home/kloxo/httpd/ AND INSIDE
- chmod 644 FOR *.php* INSIDE /home/kloxo/httpd/
- chmod 755 FOR *.pl* 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
- 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 of bind
- Copy /usr/local/lxlabs/kloxo/file/bind to /home/bind
- Copy /home/bind/etc/conf/named.conf to /etc//named.conf
Copy all contents of djbdns
- Copy /usr/local/lxlabs/kloxo/file/djbdns to /home/djbdns
Copy all contents of maradns
- Copy /usr/local/lxlabs/kloxo/file/maradns to /home/maradns
- Copy /home/maradns/etc/mararc to /etc//mararc
Copy all contents of pdns
- Copy /usr/local/lxlabs/kloxo/file/pdns to /home/pdns
- Copy /home/pdns/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 of nsd
- Copy /usr/local/lxlabs/kloxo/file/nsd to /home/nsd
- Copy /home/nsd/etc/conf/nsd.conf to /etc//nsd/nsd.conf
Initialize apache config
- /etc/httpd/conf.d dir already exists
- /home/apache/tpl dir already exists
- /home/apache/conf dir already exists
- /home/apache/etc dir already exists
- /home/apache/etc/conf dir already exists
- /home/apache/etc/conf.d dir already exists
Copy all contents of apache
- Copy /usr/local/lxlabs/kloxo/file/apache to /home/apache
- Copy /home/apache/etc/conf/httpd.conf to /etc/httpd/conf/httpd.conf
- Copy /home/apache/etc/conf.d/~lxcenter.conf to /etc/httpd/conf.d/~lxcenter.conf
- Copy /home/apache/etc/conf.d/ssl.conf to /etc/httpd/conf.d/ssl.conf
- Copy /home/apache/etc/conf.d/__version.conf to /etc/httpd/conf.d/__version.conf
- chown root:root FOR /home/apache/ AND INSIDE
- chmod 755 FOR *.sh INSIDE /home/apache/
Initialize lighttpd config
- /etc/lighttpd/conf.d dir already exists
- /home/lighttpd/tpl dir already exists
- /home/lighttpd/conf dir already exists
- /home/lighttpd/etc dir already exists
- /home/lighttpd/etc/conf dir already exists
- /home/lighttpd/etc/conf.d dir already exists
Copy all contents of lighttpd
- Copy /usr/local/lxlabs/kloxo/file/lighttpd to /home/lighttpd
- Copy /home/lighttpd/etc/conf/lighttpd.conf to /etc/lighttpd/lighttpd.conf
- Copy /home/lighttpd/etc/conf.d/~lxcenter.conf to /etc/lighttpd/conf.d/~lxcenter.conf
- chown root:root FOR /home/lighttpd/ AND INSIDE
- chmod 755 FOR *.sh INSIDE /home/lighttpd/
Initialize nginx config
- /etc/nginx/conf.d dir already exists
- /home/nginx/tpl dir already exists
- /home/nginx/conf dir already exists
- /home/nginx/etc dir already exists
- /home/nginx/etc/conf dir already exists
- /home/nginx/etc/conf.d dir already exists
Copy all contents of nginx
- Copy /usr/local/lxlabs/kloxo/file/nginx to /home/nginx
- Copy /home/nginx/etc/conf/nginx.conf to /etc/nginx/nginx.conf
- Copy /home/nginx/etc/conf.d/~lxcenter.conf to /etc/nginx/conf.d/~lxcenter.conf
- chown root:root FOR /home/nginx/ AND INSIDE
- chmod 755 FOR *.sh INSIDE /home/nginx/
Initialize hiawatha config
- /etc/hiawatha/conf.d dir already exists
- /home/hiawatha/tpl dir already exists
- /home/hiawatha/conf dir already exists
- /home/hiawatha/etc dir already exists
- /home/hiawatha/etc/conf dir already exists
- /home/hiawatha/etc/conf.d dir already exists
Copy all contents of hiawatha
- Copy /usr/local/lxlabs/kloxo/file/hiawatha to /home/hiawatha
- Copy /home/hiawatha/etc/conf/hiawatha.conf to /etc/hiawatha/hiawatha.conf
- chown root:root FOR /home/hiawatha/ AND INSIDE
- chmod 755 FOR *.sh INSIDE /home/hiawatha/
Copy all contents of varnish
- Copy /usr/local/lxlabs/kloxo/file/varnish to /home/varnish
Copy all contents of trafficserver
- Copy /usr/local/lxlabs/kloxo/file/trafficserver to /home/trafficserver
Copy all contents of squid
- Copy /usr/local/lxlabs/kloxo/file/squid to /home/squid
- Install /etc/php-fpm.conf
- Copy php-fpm init to /etc/init.d dir
Copy all contents of openssl
- Copy /usr/local/lxlabs/kloxo/file/openssl to /home/openssl
Initialize PureFtp service
- Initialize process
- Restart xinetd service for pureftp
Initialize logrotate
Preparing RoundCube database
- Fixing MySQL commands in import files
- Generating password
- Add Password to configuration file
- Could not grant privileges. Script Abort
*** Restart services - BEGIN ***
Shutting down MySQL.. [ OK ]
Starting MySQL. [ OK ]
nsd beenden: [ OK ]
nsd starten: [ OK ]
httpd beenden: [ OK ]
httpd starten: [ OK ]
Stopping Hiawatha web server: [FEHLGESCHLAGEN]
Starting Hiawatha web server: Error binding 0.0.0.0:80
[FEHLGESCHLAGEN]
Stopping qmail-toaster: svscan qmail logging.
qmail-send: Kein Prozess abgebrochen
Starting qmail-toaster: svscan.
xinetd beenden: [ OK ]
xinetd starten: [ OK ]
Execute fixlxphpexe for php54s...
Stopping kloxo-phpcgi: [ OK ]
Starting kloxo-phpcgi: [ OK ]
Stopping kloxo-hiawatha: [ OK ]
Starting kloxo-hiawatha: [ OK ]
php-fpm beenden: [ OK ]
php-fpm starten: [ OK ]
*** Restart services - END ***
Process Time: 00:00:01:58.118452 (dd:hh:mm:ss:xxxxxx)
[root@happy2 my.cnf.d]#
-
Ok Kloxo cp works ,web works
bind or pdns not work
-
Try djbdns or nsd. To make sure, run 'sh /script/fixdns; sh /script/restart-dns'.
-
nsd works
but roundcube
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.
horde no login
afterlogic not work