topic Re: can't login due to no database connection in Alfresco Archive

can't login due to no database connection

jackomohle — Thu, 29 Nov 2012 11:04:37 GMT

Hi guys, im a new user on this forum but i already browsed a lot of topics , none of the posters had the same problem as i have.Fist of all my hardware setup:hp proliant G6, 4 GB Ram, 1x ssd, 2x hdd 2 TB (software raid-1, mirror). (i ve read that alfresco and HP proliant servers are not compatible,

Re: can't login due to no database connection

afaust — Thu, 29 Nov 2012 11:11:38 GMT

Hello,

it seems you are missing some MySQL permissions in order for Alfresco to connect to your database after you've re-created it.
Try


GRANT ALL ON alfresco.* to 'alfresco'@'serveracg.local' WITH GRANT OPTION;
‍‍‍

If this does not work, make sure your my.cnf allows external hosts to connect (I am not sure at the moment if there is a specific option in the config apart from the socket / port options).

Regards
Axel

Re: can't login due to no database connection

jackomohle — Thu, 29 Nov 2012 11:33:14 GMT

hi alex
thx for your reply!, i added the code in mysql alfresco database. i thought i already had that code but neverless i added it . unfortuanally i did't effect anything

i should have probably mentioned that serveracg is my localhost. mysql and alfresco are running on the same server, so external connections doesn't matter.

Greetz,
Jacko

Hello,

it seems you are missing some MySQL permissions in order for Alfresco to connect to your database after you've re-created it.
Try
GRANT ALL ON alfresco.* to 'alfresco'@'serveracg.local' WITH GRANT OPTION;
‍‍‍
If this does not work, make sure your my.cnf allows external hosts to connect (I am not sure at the moment if there is a specific option in the config apart from the socket / port options).

Regards
Axel

Re: can't login due to no database connection

jackomohle — Fri, 30 Nov 2012 16:16:05 GMT

well, alfresco is working.
it seems to be a problem with the ubuntu loopback adapter. it can't connect to its own mysql server.

i thinks this is a hardware problem with the hp proliant g6 server. i solved it by storing the mysql on another server in the same network and just point everything that was 'localhost' to the IP of the other server. and the same with the mysql database user@'*alfrescoserver IP*'