Hyland Connect

jackomohle · ‎11-29-2012

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, i think this is non-sense)
software setup:
Ubuntu 12.10 installed in the ssd, Mysql server 5, pptpd server. i have copied the alf_data folder to my raidpartition, made the folder chown "user" and symbolic linked it to /opt/alfresco/alf_data (this way i never lose content if one disk fails) .

the problem:
when i install alfresco it works fine, i can login to the share, add users etc.., for some reason after a few hours or days (installed multiple times) i cannot login anymore. After hours of searching and almost throwing my server out of the window i figured, i shouldn't do this on my own and try to be a new community uses en maybe in the future a valued contributer. So i hope u guys can help me with my problem.

mysql:

netstat -an | grep -i mysql
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN
mysql> use alfresco;
Database changed
mysql> show tables
    -> ;
Empty set (0.00 sec)  –> this is because i deleted the database (it was filled before, but for some reason i couldn't anymore) and tried to setup an empty one with db_setup.sql ‍‍‍‍‍‍‍

the database connector (mysql-connector-java-5.1.22-bin.jar) is stored in <alfrescodir>/tomcat/lib

The config common properties:

dir.root=/opt/alfresco/alf_data
web.application.context.url=http://127.0.0.1:8080/alfresco
db.username=alfresco
db.password=alfresco
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://localhost:3306/alfresco?useUnicode=yes&characterEncoding=UTF-8
alfresco.rmi.services.host=0.0.0.0
the rest of the config is commented‍‍‍‍‍‍‍‍

The logs:
alfresco.log:
1

1:35:05,655 WARN  [org.hibernate.cfg.SettingsFactory] Could not obtain connection metadata
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (null,  message from server: "Host 'serveracg.local' is not allowed to connect to this MySQL server")
        at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
      and so on……‍‍‍‍‍

catalina log:

afaust · ‎11-29-2012

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

jackomohle · ‎11-29-2012

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

jackomohle · ‎11-30-2012

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

Hyland Connect

can't login due to no database connection