installing alfresco on SME 7.4

hi, i’m trying to installing alfresco in a clean SME server 7.4
but im getting the following error:
[root@test tmp]# tail /tmp/bitrock_installer.log
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ’/opt/alf resco-3.0-0/mysql/tmp/mysql.sock’ (2)
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ’/opt/alf resco-3.0-0/mysql/tmp/mysql.sock’ (2)
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ’/opt/alf resco-3.0-0/mysql/tmp/mysql.sock’ (2)
Error running /opt/alfresco-3.0-0/mysql/scripts/myscript.sh /opt/alfresco-3.0-0/ mysql qwerty : ERROR: 1049 Unknown database ‘mysql’
090519 8:58:01 [ERROR] Aborting

090519 8:58:01 [Note] /opt/alfresco-3.0-0/mysql/bin/mysqld.bin: Shutdown comple te

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ’/opt/alf resco-3.0-0/mysql/tmp/mysql.sock’ (2)
[root@test tmp]#

please help

Hi,

It is possible that mysql can not start due to a timing issue. Could you check your /opt/alfresco-3.0-0/mysql/data/mysqld.log file?

Same problem here, this time with CentOS 4.4.

This is my mysqld.log:
090611 13:28:44 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
090611 13:28:44 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait…
090611 13:28:45 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait…
090611 13:28:45 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait…
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
090611 13:28:45 InnoDB: Started; log sequence number 0 0
090611 13:28:45 [ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist
090611 13:28:45 mysqld ended

Thanks,
Francisco

Hi,

We have fixed this issue internally and we will release a new version soon. It is related to an existing my.cnf file. The workaround is to move your ”/etc/my.cnf” to ”/etc/my.cnf.bak” and then install the stack. Once installed you can move the my.cnf to the original name.

Cheers.

Thanks. It worked fine. :-)

ive installed alfresco with the advice from this post. all went well. Thanks!
but then….
i installed phpmyadmin and did the post-upgrade reboot scrip from SME 7.4 and i think i broke it!!!
i ran the ctlscript.sh to start all the processes and it said started but when i try to connect to the web interface i get the HTTP Status 404 – /alfresco/faces/jsp/dashboards/container.jsp"
type Status report
message /alfresco/faces/jsp/dashboards/container.jsp
description The requested resource (/alfresco/faces/jsp/dashboards/container.jsp) is not available.

PLEASE HELP!

Hi,

Could you post the last entries of /apache-tomcat/logs/catalina.out file?

[root@smeserver ~]# tail /opt/alfresco/apache-tomcat/logs/catalina.out
19:38:13,198 INFO [web.site.FrameworkHelper] Successfully Initialized Web Framework
19:38:20,939 INFO [config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]
19:38:23,287 ERROR [content.transform.RuntimeExecutableContentTransformer] Failed to start a runtime executable content transformer:
Execution result:
os: Linux
command: [./bin/pdf2swf, -V]
succeeded: false
exit code: 1
out:
err: java.io.IOException: ./bin/pdf2swf: not found

This is a pdf conversion error but I think that the framework should run correctly, no? Could you post more errors that you can find in that file?

Hi,

Just one question. Do i need to change anything in the installation to allow connections to alfresco remotely (from outside the local LAN).
The SME server is in server only mode. We are using dyndns to get access to the ADSL router and port 8080 and 22 is forwarded to the internal IP of the smeserver. I can access the server with ssh but not alfresco.
Any ideas?

Hi,

It is not necessary to modify the installation, changing the port forwarding ti should be enough. I have no idea what is happening. Are you trying to access at http://your_dyndns.org:8080 ? Is your router configured correctly? This post could be helpful for you: http://bitnami.org/article/how-to-install-and-m…

i’m sure my config is the same as in the suggested link, but no luck. cant it have sometime to do with tomcat binding to only allow local access?

if i do a netstat -ant on the alfresco box i get….
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 0.0.0.0:993 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:515 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:995 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:50500 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:8100 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:548 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:8005 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:389 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:8009 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:139 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:110 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:143 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:8080 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:465 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:980 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:21 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:33141 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.2:53 0.0.0.0:* LISTEN
tcp 0 0 192.168.2.101:53 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:3128 0.0.0.0:* LISTEN
tcp 0 0 192.168.2.101:3128 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:25 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:26 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:443 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:4700 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:445 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:33147 127.0.0.1:8100 ESTABLISHED
tcp 0 0 127.0.0.1:3306 127.0.0.1:33132 ESTABLISHED
tcp 0 0 127.0.0.1:3306 127.0.0.1:33133 ESTABLISHED
tcp 0 0 127.0.0.1:3306 127.0.0.1:33134 ESTABLISHED
tcp 0 0 127.0.0.1:3306 127.0.0.1:33135 ESTABLISHED
tcp 0 0 127.0.0.1:8100 127.0.0.1:33147 ESTABLISHED
tcp 0 0 127.0.0.1:3306 127.0.0.1:33130 ESTABLISHED
tcp 0 0 127.0.0.1:3306 127.0.0.1:33131 ESTABLISHED
tcp 0 0 127.0.0.1:33135 127.0.0.1:3306 ESTABLISHED
tcp 0 0 127.0.0.1:33134 127.0.0.1:3306 ESTABLISHED
tcp 0 0 127.0.0.1:33133 127.0.0.1:3306 ESTABLISHED
tcp 0 0 127.0.0.1:33132 127.0.0.1:3306 ESTABLISHED
tcp 0 0 127.0.0.1:33131 127.0.0.1:3306 ESTABLISHED
tcp 0 0 127.0.0.1:33130 127.0.0.1:3306 ESTABLISHED
tcp 0 0 127.0.0.1:33136 127.0.0.1:3306 ESTABLISHED
tcp 0 0 127.0.0.1:33151 127.0.0.1:3306 ESTABLISHED
tcp 0 0 127.0.0.1:33150 127.0.0.1:3306 ESTABLISHED
tcp 0 0 127.0.0.1:33149 127.0.0.1:3306 ESTABLISHED
tcp 0 0 127.0.0.1:33156 127.0.0.1:3306 ESTABLISHED
tcp 0 0 127.0.0.1:33155 127.0.0.1:3306 ESTABLISHED
tcp 0 0 127.0.0.1:33154 127.0.0.1:3306 ESTABLISHED
tcp 0 0 127.0.0.1:33153 127.0.0.1:3306 ESTABLISHED
tcp 0 0 127.0.0.1:33152 127.0.0.1:3306 ESTABLISHED
tcp 0 0 127.0.0.1:3306 127.0.0.1:33149 ESTABLISHED
tcp 0 0 127.0.0.1:3306 127.0.0.1:33150 ESTABLISHED
tcp 0 0 127.0.0.1:3306 127.0.0.1:33151 ESTABLISHED
tcp 0 0 127.0.0.1:3306 127.0.0.1:33136 ESTABLISHED
tcp 0 0 127.0.0.1:3306 127.0.0.1:33156 ESTABLISHED
tcp 0 0 127.0.0.1:3306 127.0.0.1:33152 ESTABLISHED
tcp 0 0 127.0.0.1:3306 127.0.0.1:33153 ESTABLISHED
tcp 0 0 127.0.0.1:3306 127.0.0.1:33154 ESTABLISHED
tcp 0 0 127.0.0.1:3306 127.0.0.1:33155 ESTABLISHED
tcp 0 2260 192.168.2.101:22 192.168.2.55:2960 ESTABLISHED
tcp 138 0 192.168.2.101:445 192.168.2.58:1104 CLOSE_WAIT
tcp 138 0 192.168.2.101:445 192.168.2.58:4943 CLOSE_WAIT
tcp 138 0 192.168.2.101:445 192.168.2.58:4991 CLOSE_WAIT
tcp 138 0 192.168.2.101:445 192.168.2.58:1133 CLOSE_WAIT

Hi,

Tomcat is configured to access from other computer. Could you access your application from other computer in your LAN? If you can access I would say that the problem is your router redirection.

Cheers.

with the help of Stefano…..

config set alfresco service access public status enabled TCPPort 8080
signal-event remoteaccess-update

solved the problem

Thanks for letting us know. This post will be helpful for other users.

i think i broke it again… im testing the backup to make sure that it works before i start using it.
this is what i did…
copy the folder to /root/alfresco
removed alfresco in /opt/
copied it back to /opt/
but now i get the following error….
[root@smeserver ~]# /opt/alfresco/ctlscript.sh start
Starting mysqld.bin daemon with databases from /opt/alfresco/mysql/data
STOPPING server from pid file /opt/alfresco/mysql/data/smeserver.pid
090727 16:07:09 mysqld ended

/opt/alfresco/mysql/scripts/ctl.sh : mysql could not be started
Using CATALINA_BASE: /opt/alfresco/apache-tomcat
Using CATALINA_HOME: /opt/alfresco/apache-tomcat
Using CATALINA_TMPDIR: /opt/alfresco/apache-tomcat/temp
Using JRE_HOME: /opt/alfresco/java
/opt/alfresco/apache-tomcat/scripts/ctl.sh : tomcat started

it looks like mysql that doesn’t want to start..

help please !

Louis

Hi,

Could you post the last entries in the /mysql/data/mysqld.log file?

090727 16:07:09 mysqld started
090727 16:07:09 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: ‘create’.
InnoDB: Cannot continue operation.
090727 16:07:09 mysqld ended

Could you check that the mysql/data folder owner and group is mysql:mysql ?

drwxr-x—- 5 mysql mysql 4096 2009-07-22 18:14 data

If not you can change them:

# chown -R mysql:mysql /mysql/data

it did belong to the mysql group, but i forced it again. and that did the trick.
I don’t know why it lost its user rights. I’ve managed to recreate in on 2 different sme boxes.

thanks for the help beltran.

I’m glad to hear this. I think that a better option than the folder copy is to create a tarball to preserve the permissions:

# tar -czvf “installdir” /tmp/stack-backup.tar.gz

Cheers.

did the same test again, but now i get…
[root@smeserver ~]# tail /opt/alfresco/mysql/data/mysqld.log
090727 17:59:00 [ERROR] Can’t start server : Bind on unix socket: Permission den ied
090727 17:59:00 [ERROR] Do you already have another mysqld server running on soc ket: /opt/alfresco/mysql/tmp/mysql.sock ?
090727 17:59:00 [ERROR] Aborting

090727 17:59:00 InnoDB: Starting shutdown…
090727 17:59:03 InnoDB: Shutdown completed; log sequence number 0 5156501
090727 17:59:03 [Note] /opt/alfresco/mysql/bin/mysqld.bin: Shutdown complete

090727 17:59:03 mysqld ended

Could you check if there is any MySQL instance running?

# ps aux | grep mysql

Could you kill them and start it again?

reboot sorted it out. thanks