Thanks for the quick response Jeff.
Finally I made it shinning
…But I still confused, please someone clarify me.
Tested it with Tomcat 6 (apache-tomcat-6.0.35), with exactly same result as mentioned before. So decided start all over again and I performed this steps:
1 - Erased everything (tomcat and alfresco)
2 - Extracted apache-tomcat-7.0.29 to /usr/share/apache-tomcat-7.0.29, consider this as $TOMCAT_HOME.
3 - Started and stoped tomcat, everything worked great so far
4 - Unziped alfresco-4.0.e and copied the full folder alfresco-4-0-e/web-server/shared to $TOMCAT_HOME and alfresco-4-0-e/web-server/webapps/* to $TOMCAT_HOME/webapps
5 - Confirmed that mysql was correctly set up with alfresco db and appropriated grants for alfresco user as mentioned before as well.
6 - Adjusted $TOMCAT_HOME/shared/classes/alfresco-global.properties as mentioned before to consider mysql
7 - Copied mysql-connector to $TOMCAT_HOME/lib
8 - Started tomcat, same logs complaining about postgresql… (WTF, but I want to use the mysql)
9 - Done some search, where would be this insisting postgresql default configuration and found it at this file ($TOMCAT_HOME/webapps/alfresco/WEB-INF/classes/alfresco/module/test/alfresco-global.properties):
11 - Restarted tomcat and the mysql connection worked, tables created, database script executed, db patches applied, ok.
12 - if uncomment back the lines as it were at point 9, alfresco start complaining about postgresql once again.
Probably I'm doing something wrong here, or someone please clarify me, shouldn't any file within $TOMCAT_HOME/webapps/alfresco/ be ready-only. Whenever need override any propertie it shouldn't be done at $TOMCAT_HOME/shared/classes/alfresco-global.properties?
Other example is ImageMagick root, it only take effect when I change the proper "img.root" porpertie at $TOMCAT_HOME/webapps/alfresco/WEB-INF/classes/alfresco/repository.properties
There's certanely something that I'm doing wrong where or something I did not understand quite well yet about alfresco config. Or somehow $TOMCAT_HOME/shared/classes/alfresco-global.properties is not being considered on my system.
Please someone reply to this with what experiences you may have on this.
considerations:
centOS 6.3, 64bit distribution
java-1.7.0-openjdk-1.7.0.5.x86_64
mysql-5.1.61-4.el6.x86_64
mysql-connector-java-5.1.13-bin.jar
apache-tomcat-7.0.29
alfresco-4.0.e
Finally I made it shinning
…But I still confused, please someone clarify me.Tested it with Tomcat 6 (apache-tomcat-6.0.35), with exactly same result as mentioned before. So decided start all over again and I performed this steps:
1 - Erased everything (tomcat and alfresco)
2 - Extracted apache-tomcat-7.0.29 to /usr/share/apache-tomcat-7.0.29, consider this as $TOMCAT_HOME.
3 - Started and stoped tomcat, everything worked great so far
4 - Unziped alfresco-4.0.e and copied the full folder alfresco-4-0-e/web-server/shared to $TOMCAT_HOME and alfresco-4-0-e/web-server/webapps/* to $TOMCAT_HOME/webapps
5 - Confirmed that mysql was correctly set up with alfresco db and appropriated grants for alfresco user as mentioned before as well.
6 - Adjusted $TOMCAT_HOME/shared/classes/alfresco-global.properties as mentioned before to consider mysql
7 - Copied mysql-connector to $TOMCAT_HOME/lib
8 - Started tomcat, same logs complaining about postgresql… (WTF, but I want to use the mysql)
9 - Done some search, where would be this insisting postgresql default configuration and found it at this file ($TOMCAT_HOME/webapps/alfresco/WEB-INF/classes/alfresco/module/test/alfresco-global.properties):
# DB Override settings for PostGreSQL
db.driver=org.postgresql.Driver
db.url=jdbc:postgresql:${db.name}
db.username=alfresco
db.password=alfresco
# (or give the alfresco user db create permissions)
11 - Restarted tomcat and the mysql connection worked, tables created, database script executed, db patches applied, ok.
12 - if uncomment back the lines as it were at point 9, alfresco start complaining about postgresql once again.
Probably I'm doing something wrong here, or someone please clarify me, shouldn't any file within $TOMCAT_HOME/webapps/alfresco/ be ready-only. Whenever need override any propertie it shouldn't be done at $TOMCAT_HOME/shared/classes/alfresco-global.properties?
Other example is ImageMagick root, it only take effect when I change the proper "img.root" porpertie at $TOMCAT_HOME/webapps/alfresco/WEB-INF/classes/alfresco/repository.properties
There's certanely something that I'm doing wrong where or something I did not understand quite well yet about alfresco config. Or somehow $TOMCAT_HOME/shared/classes/alfresco-global.properties is not being considered on my system.
Please someone reply to this with what experiences you may have on this.
considerations:
centOS 6.3, 64bit distribution
java-1.7.0-openjdk-1.7.0.5.x86_64
mysql-5.1.61-4.el6.x86_64
mysql-connector-java-5.1.13-bin.jar
apache-tomcat-7.0.29
alfresco-4.0.e
