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

[Rob Badub]

Hi Franz,

Thanks once again for taking the time to help us out. Much appreciated :-)

At first it thought I knew the password so I tried your second suggestion.
But it was not the correct password.

The I ran : setup-kolab  -D 9 -l debug to see what was going on. I did not
record the output but did copy the MySQL root password and put it in my.cnf,
that already existed. Did the chmod.

I re-ran the setup with aptitude install kolab (which was where I left off)

This time the error is different:

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[HY000] [2002] Can't connect to
local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)ERROR:
Site roundcubemail does not exist!

This error I saw in the debug run as well...

Please supply a root password for MySQL. This password will be the
administrative
user for this MySQL server, and it should be kept a secret. After this setup
process has completed, Kolab is going to discard and forget about this
password,
but you will need it for administrative tasks in MySQL.

MySQL root password [xxxxxxxxxxxxxxx]:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)

So running the installer renders a problem when installing MySQL. After that
all fails.

Cheers,
Rob

-----Original Message-----
From: users-bounces at lists.kolab.org [mailto:users-bounces at lists.kolab.org]
On Behalf Of Franz Skale
Sent: maandag 1 september 2014 22:33
To: Rob Badub; users at lists.kolab.org
Subject: Re: Error connecting to database: SQLSTATE[28000] [1045] Access
denied for user 'roundcube'@'localhost'



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'@'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'@'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



_______________________________________________
users mailing list
users at lists.kolab.org
https://lists.kolab.org/mailman/listinfo/users