Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2024-04-19, 22:47:27

Author Topic: Roundcube DATABASE ERROR: CONNECTION FAILED!  (Read 20082 times)

0 Members and 1 Guest are viewing this topic.

Offline ibuxxi

  • Senior Member
  • *
  • Posts: 322
  • Karma: +0/-0
    • View Profile
Roundcube DATABASE ERROR: CONNECTION FAILED!
« on: 2014-06-25, 19:35:47 »
Hello

how can i fix roundcube  DATABASE ERROR: CONNECTION FAILED!

I cleanup
and  fixwebmail say
Code: [Select]
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
Code: [Select]
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
Code: [Select]
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

« Last Edit: 2014-06-25, 19:44:16 by ibuxxi »
KVM VPS | Centos 6.8 (32) 2GB | Kloxo-MR 7.0.0.b-2016* | hiawatha | php56 | php-fpm-event | mariadb

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Roundcube DATABASE ERROR: CONNECTION FAILED!
« Reply #1 on: 2014-06-26, 03:20:37 »
Try 'sh /script/fixmail-all'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline ibuxxi

  • Senior Member
  • *
  • Posts: 322
  • Karma: +0/-0
    • View Profile
Re: Roundcube DATABASE ERROR: CONNECTION FAILED!
« Reply #2 on: 2014-06-26, 07:43:12 »
not work
Code: [Select]
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  :-(

Code: [Select]
Alert: Login Unsuccessful
KVM VPS | Centos 6.8 (32) 2GB | Kloxo-MR 7.0.0.b-2016* | hiawatha | php56 | php-fpm-event | mariadb

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Roundcube DATABASE ERROR: CONNECTION FAILED!
« Reply #3 on: 2014-06-26, 07:58:39 »
Try 'sh /script/reset-mysql-root-password YOURPASSWORD' first.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Roundcube DATABASE ERROR: CONNECTION FAILED!
« Reply #4 on: 2014-06-26, 08:00:40 »
Ok, there are something trouble if using mariadb for access to panel.

Need using php54s install php53s for panel. Try:
Code: [Select]
sh /script/php54s-installer
sh /script/fixlxphpexe php54s
sh /script/restart
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline ibuxxi

  • Senior Member
  • *
  • Posts: 322
  • Karma: +0/-0
    • View Profile
Re: Roundcube DATABASE ERROR: CONNECTION FAILED!
« Reply #5 on: 2014-06-26, 08:24:12 »
Try 'sh /script/reset-mysql-root-password YOURPASSWORD' first.

Connect failed:
Code: [Select]
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)
KVM VPS | Centos 6.8 (32) 2GB | Kloxo-MR 7.0.0.b-2016* | hiawatha | php56 | php-fpm-event | mariadb

Offline ibuxxi

  • Senior Member
  • *
  • Posts: 322
  • Karma: +0/-0
    • View Profile
Re: Roundcube DATABASE ERROR: CONNECTION FAILED!
« Reply #6 on: 2014-06-26, 09:16:18 »
Code: [Select]
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:
Code: [Select]
sh /script/php54s-installer
sh /script/fixlxphpexe php54s
sh /script/restart
KVM VPS | Centos 6.8 (32) 2GB | Kloxo-MR 7.0.0.b-2016* | hiawatha | php56 | php-fpm-event | mariadb

Offline ibuxxi

  • Senior Member
  • *
  • Posts: 322
  • Karma: +0/-0
    • View Profile
Re: Roundcube DATABASE ERROR: CONNECTION FAILED!
« Reply #7 on: 2014-06-26, 09:17:51 »
All services load  OK
but all sites or kloxo or webmail or mail not work
KVM VPS | Centos 6.8 (32) 2GB | Kloxo-MR 7.0.0.b-2016* | hiawatha | php56 | php-fpm-event | mariadb

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Roundcube DATABASE ERROR: CONNECTION FAILED!
« Reply #8 on: 2014-06-26, 09:25:40 »
Try 'sh /script/cleanup; sh /script/restart-all'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline ibuxxi

  • Senior Member
  • *
  • Posts: 322
  • Karma: +0/-0
    • View Profile
Re: Roundcube DATABASE ERROR: CONNECTION FAILED!
« Reply #9 on: 2014-06-26, 09:31:31 »
- Create database interface template (Forced)
ERROR 1045 (28000): Access denied for user 'kloxo'@'localhost' (using password: YES)

and

Hiawatha web server not start

Code: [Select]
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'.
KVM VPS | Centos 6.8 (32) 2GB | Kloxo-MR 7.0.0.b-2016* | hiawatha | php56 | php-fpm-event | mariadb

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Roundcube DATABASE ERROR: CONNECTION FAILED!
« Reply #10 on: 2014-06-26, 09:38:49 »
Run again 'sh /script/reset-mysql-root-password YOURPASSWORD; sh /script/fixmail-all'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline ibuxxi

  • Senior Member
  • *
  • Posts: 322
  • Karma: +0/-0
    • View Profile
Re: Roundcube DATABASE ERROR: CONNECTION FAILED!
« Reply #11 on: 2014-06-26, 11:44:40 »
not work web,mail,kloxo

sh /script/reset-mysql-root-password YOURPASSWORD
Code: [Select]
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
Code: [Select]
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'.
KVM VPS | Centos 6.8 (32) 2GB | Kloxo-MR 7.0.0.b-2016* | hiawatha | php56 | php-fpm-event | mariadb

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Roundcube DATABASE ERROR: CONNECTION FAILED!
« Reply #12 on: 2014-06-26, 11:53:25 »
Access to panel and then change 'MySQL Password Reset' before running fixmail-all.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline ibuxxi

  • Senior Member
  • *
  • Posts: 322
  • Karma: +0/-0
    • View Profile
Re: Roundcube DATABASE ERROR: CONNECTION FAILED!
« Reply #13 on: 2014-06-26, 11:56:12 »
No access to kloxo panel
Code: [Select]
Alert: Login Unsuccessful

Access to panel and then change 'MySQL Password Reset' before running fixmail-all.
KVM VPS | Centos 6.8 (32) 2GB | Kloxo-MR 7.0.0.b-2016* | hiawatha | php56 | php-fpm-event | mariadb

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Roundcube DATABASE ERROR: CONNECTION FAILED!
« Reply #14 on: 2014-06-26, 12:08:42 »
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:
Code: [Select]
# 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:
Code: [Select]
# 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'.

..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

 


MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix

Page created in 0.05 seconds with 21 queries.

web stats analysis