Error connecting to database: SQLSTATE[28000] [1045] Access denied for user 'roundcube' <at> 'localhost'

[Juan]

Franz Skale <i.bin <at> dah.am> writes:

> 
> 
> Hi,
> setup kolab will ask you for a mysql root password on setup.
> if you missed it, run  setup-kolab  -D 9 -l debug and show us the output.
> If you hit enter, try this before rerunning dpkg --coonfigure -a:
> 
> login as root and create a file called  .my.cnf
> Add this:
> [client]
> port        = 3306
> socket        = /var/run/mysqld/mysqld.sock
> password    = xxxxxxxxxx
> 
> Of course, use or own mysql root password.
> then do a chmod 700 .my.cnf
> 
> Rerun the setup and continue.
> 
> Rgds.
> 
> Franz
> 
> Am 01.09.14 21:45, schrieb Rob Badub:
> > Hi all,
> >
> > My name is Rob Badub and I'm new to Kolab. My system is a Ubuntu server
> > 14.04 and I'm following the instructions that I've found on
> > http://docs.kolab.org/installation-guide/ubuntu.html
> >
> > After executing the install script with 
> >
> > Sudo aptitude install kolab
> >
> > it fails at the install for roundcubemail
> >
> > The error message says:
> >
> > E: Sub-process /usr/bin/dpkg returned an error code (1)
> > A package failed to install.  Trying to recover:
> > Setting up roundcubemail (1:1.1~dev20140404-0~kolab3) ...
> > ERROR: Error connecting to database: SQLSTATE[28000] [1045] Access denied
> > for user 'roundcube' <at> 'localhost' (using password: YES)ERROR: Site
> > roundcubemail does not exist!
> >
> > Subsequently the following packages with dependencies fail as well.
> >
> > dpkg: error processing package roundcubemail (--configure):
> >  subprocess installed post-installation script returned error exit status 1
> > dpkg: dependency problems prevent configuration of kolab-freebusy:
> >  kolab-freebusy depends on roundcubemail; however:
> >   Package roundcubemail is not configured yet.
> >
> > And the same for 
> >
> > roundcubemail-plugins-kolab
> >  chwala
> >  irony
> >  kolab-freebusy
> >  kolab-syncroton
> >  roundcubemail-plugin-contextmenu
> >  roundcubemail-plugin-threadingasdefault
> >  kolab-webclient
> >  kolab
> >
> > Most informative errormessage:
> > ERROR: Error connecting to database: SQLSTATE[28000] [1045] Access denied
> > for user 'roundcube' <at> 'localhost' (using password: YES)ERROR: Site
> > roundcubemail does not exist!
> >
> > Options:
> > There is no user roundcube
> > It does not use the FQDN
> > Site roundcubemail does not exist (what does this mean?)
> >
> > Please advice
> >
> > Cheers,
> > Rob
> >
> > _______________________________________________
> > users mailing list
> > users <at> lists.kolab.org
> > https://lists.kolab.org/mailman/listinfo/users
> 
> 
> Attachment (smime.p7s): application/pkcs7-signature, 4254 bytes
> 
> _______________________________________________
> users mailing list
> users <at> lists.kolab.org
> https://lists.kolab.org/mailman/listinfo/users


I try this and install success ok, work for me:

1. FIX TO INSTALL KOLAB 3.3 IN UBUNTU 14.04

- After error output 'aptitude install kolab' do -

vim /usr/share/roundcubemail/config/config.inc.php

        replace this -> roundcube:pass at localhost/roundcubemail
        for this -> root:<PASSMYSQLROOT>@localhost/roundcube

mysql -u root -p
	> create database roundcube;

cd /usr/share/doc/roundcubemail/SQL/
	mysql -u root -p roundcube < mysql.initial.sql
	dpkg --configure -a

cd /etc/apache2/sites-available/
	ln -s kolab-webadmin kolab-webadmin.conf
	ln -s roundcubemail roundcubemail.conf
	dpkg --configure -a

        More errors again? continue :)

	ln -s chwala chwala.conf
	ln -s iRony iRony.conf
	ln -s kolab-freebusy kolab-freebusy.conf
	ln -s kolab-syncroton kolab-syncroton.conf
	dpkg --configure -a

        and finally:

	a2ensite kolab-webadmin.conf
	service apache2 start

setup-kolab

More errors at point mysql? no matter, its ok, the process of the
installation was completed;