topic Re: Installing Community 3.4b on debian squeeze 64bit in Alfresco Archive

Installing Community 3.4b on debian squeeze 64bit

ddanninger — Thu, 16 Dec 2010 11:52:24 GMT

Hi there,iam trying to install the Alfresco Community 3.4b…. i executed the .bin file and installed it in /opt/alfresco … i didnt use the bundled mysql package … because we already have an MYSQL installed there. (So i choose existing Database at the install procedure)So far everything worked fine.As

Re: Installing Community 3.4b on debian squeeze 64bit

heiko_robert — Thu, 16 Dec 2010 13:09:06 GMT

It seems that the required jdbc-driver is missing. Please

copy the jar file (e.g. mysql-connector-java-5.x.x-bin.jar ) to <ALF_HOME>/tomcat/lib/

check if the required database has been created using the command line

restart

Hope that helps
Heiko

Re: Installing Community 3.4b on debian squeeze 64bit

ddanninger — Thu, 16 Dec 2010 13:50:26 GMT

First of all thanks for your fast response.

Well there was already and jdbc-driver -> mysql-connector-java-5.1.7-bin.jar i updated it with the newest version mysql-connector-java-5.1.14-bin.jar
Database is created and i sniffed the packages of port 3306

Alfresco is connecting to MYSQL (Server version: 5.1.49-3 (Debian)) and get packages of the MYSQL Server but MySQL still writes :

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

Re: Installing Community 3.4b on debian squeeze 64bit

heiko_robert — Thu, 16 Dec 2010 14:06:56 GMT

is the mysql located on the same machine? Are you able to connect to the database using mysql from the alfresco machine?
e.g. mysql -ualfresco-palfresco -halfserver
By default mysql is only listening on loopback 127.0.0.1. additional the user needs to be granted to connect from the alfresco machine
e.g.
grant all on alfrescoDBName.* to 'alfresco'@'IP-of-alf-machine' identified by 'alfresco' with grant option;
You may prefer more strict grant rights than all 😉

Re: Installing Community 3.4b on debian squeeze 64bit

ddanninger — Thu, 16 Dec 2010 14:13:23 GMT

Yes mysql is on the same machine. Iam able to connect:

root@intalf:~# mysql -ualfresco -palfresco
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 56
Server version: 5.1.49-3 (Debian)

Copyright © 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+——————–+
| Database |
+——————–+
| information_schema |
| alfresco |
+——————–+
2 rows in set (0.02 sec)

mysql> use alfresco; show tables;
Database changed
Empty set (0.00 sec)

mysql>

We even binded MYSQL to 0.0.0.0. …. And still doesnt work.
Its an clean DEBIAN installation + standard MYSQL Configuration just edited the bind to 0.0.0.0 to test if it works then.

But still doesnt work?

Re: Installing Community 3.4b on debian squeeze 64bit

heiko_robert — Thu, 16 Dec 2010 14:22:30 GMT

could you please post the db config from tomcat/shared/classes/alfresco-global.properties
e.g.
### database connection properties ###
db.driver=org.gjt.mm.mysql.Driver
db.username=alfresco
db.password=alfresco
db.name=alfresco34b
db.url=jdbc:mysql://localhost/alfresco34b

Re: Installing Community 3.4b on debian squeeze 64bit

ddanninger — Thu, 16 Dec 2010 14:29:04 GMT

Here again 😃

### database connection properties ###
db.driver=org.gjt.mm.mysql.Driver
db.username=alfresco
db.password=alfresco
db.name=alfresco
db.url=jdbc:mysql://localhost/alfresco
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
‍‍‍‍‍‍‍‍

Re: Installing Community 3.4b on debian squeeze 64bit

heiko_robert — Thu, 16 Dec 2010 14:43:04 GMT

where does that hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect come from?
3.4. has no longer hibernate support so far I understood.

are you able to create a table using mysql -ualfresco -palfresco -hlocalhost alfresco
?

Re: Installing Community 3.4b on debian squeeze 64bit

ddanninger — Thu, 16 Dec 2010 14:52:44 GMT

i put hibernate.dialect into the file otherwise i will get another error like
"Caused by: org.hibernate.HibernateException: Hibernate Dialect must be explicitly set"

root@intalf:/opt/alfresco# mysql -ualfresco -palfresco -hlocalhost alfresco;
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 66
Server version: 5.1.49-3 (Debian)

Copyright © 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create table test (
    -> TestId int(4) NOT NULL
    -> );
Query OK, 0 rows affected (0.13 sec)

mysql> show tables;
+——————–+
| Tables_in_alfresco |
+——————–+
| test               |
+——————–+
1 row in set (0.00 sec)

mysql>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Yes i can create a table in mysql in alfresco.

Re: Installing Community 3.4b on debian squeeze 64bit

heiko_robert — Thu, 16 Dec 2010 14:57:16 GMT

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
normally means you have a network problem. firewall?
mysql and alfresco are on the same machine?
you should try mysql with hostparameter -h hostname as stated in the alfresco config to force mysql client to use the (same) network

Re: Installing Community 3.4b on debian squeeze 64bit

ddanninger — Thu, 16 Dec 2010 15:00:37 GMT

Its same machine for sure.

As you can see when i created the test table: root@intalf:/opt/alfresco# mysql -ualfresco -palfresco -hlocalhost alfresco;

I Added the host parameter there both works. With hostparameter and without.
As it is on the local machine there is no firewall.

Weird right? Is there maybe an issue on 64 bit systems?

Re: Installing Community 3.4b on debian squeeze 64bit

heiko_robert — Thu, 16 Dec 2010 15:09:09 GMT

oh - did you use that alfresco dummy-installer which brings it's own 32bit(!) jdk and binaries? Not good idea but since jdbc driver is impelmented in java this should work.
try to set JAVA_HOME to a appropiate 64 sun-jdk version in your start script and try again.
maybe you /etc/hosts doesn't resolv localhost to a ipv4 adress try 127.0.0.1 in your config instead of localhost.