Hi,
Thanks for your reply.
Below are my observations
a) Is your database server running ?
<<PP>> Yes the DB is up and running. I am using My Sql as the DB. [root@cms init.d]# /etc/init.d/mysqld status
mysqld (pid 5192) is running…
b) Have you created an empty schema for alfresco to use ?
Yes I have created. I have executed the below 3 queries.
mysqladmin -u root create alfresco
mysql -u root -e "grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;"
mysql -u root -e "grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;"
c) Have you configured your alfresco-global.properties w.r.t. your database settings.
I have make 3 changes to the alfresco-global.properties located at (/root/sware/apache-tomcat-6.0.26/shared/classes/alfresco-global.properties)
###############################
## Common Alfresco Properties #
###############################
#
# Sample custom content and index data location
#
#dir.root=/srv/alfresco/alf_data
#
# Sample database connection properties
#
#db.username=alfresco
#db.password=alfresco
#
# Property to control whether schema updates are performed automatically.
# Updates must be enabled during upgrades as, apart from the static upgrade scripts,
# there are also auto-generated update scripts that will need to be executed. After
# upgrading to a new version, this can be disabled.
#
db.schema.update=true
#
# MySQL connection
#
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://localhost/alfresco
#
# Oracle connection
#
#db.driver=oracle.jdbc.OracleDriver
#db.url=jdbc
racle:thin:@localhost:1521:alfresco
#
# SQLServer connection
# Requires jTDS driver version 1.2.5 and SNAPSHOT isolation mode
# Enable TCP protocol on fixed port 1433
# Prepare the database with:
# ALTER DATABASE alfresco SET ALLOW_SNAPSHOT_ISOLATION ON;
#
#db.driver=net.sourceforge.jtds.jdbc.Driver
#db.url=jdbc:jtds:sqlserver://localhost:1433/alfresco
#db.txn.isolation=4096
#
# PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent)
#
#db.driver=org.postgresql.Driver
#db.url=jdbc
ostgresql://localhost:5432/alfresco
# The well known RMI registry port is defined in the alfresco-shared.properties file
# alfresco.rmi.services.port=50500
#
# RMI service ports for the individual services.
# These seven services are available remotely.
#
# Assign individual ports for each service for best performance
# or run several services on the same port. You can even run everything on 50500 if needed.
#
# Select 0 to use a random unused port.
#
avm.rmi.service.port=50501
avmsync.rmi.service.port=50502
attribute.rmi.service.port=50503
authentication.rmi.service.port=50504
repo.rmi.service.port=50505
action.rmi.service.port=50506
wcm-deployment-receiver.rmi.service.port=50507
Please reply. Thanks for your attention.
Regards
PP
Thanks for your reply.
Below are my observations
a) Is your database server running ?
<<PP>> Yes the DB is up and running. I am using My Sql as the DB. [root@cms init.d]# /etc/init.d/mysqld status
mysqld (pid 5192) is running…
b) Have you created an empty schema for alfresco to use ?
Yes I have created. I have executed the below 3 queries.
mysqladmin -u root create alfresco
mysql -u root -e "grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;"
mysql -u root -e "grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;"
c) Have you configured your alfresco-global.properties w.r.t. your database settings.
I have make 3 changes to the alfresco-global.properties located at (/root/sware/apache-tomcat-6.0.26/shared/classes/alfresco-global.properties)
###############################
## Common Alfresco Properties #
###############################
#
# Sample custom content and index data location
#
#dir.root=/srv/alfresco/alf_data
#
# Sample database connection properties
#
#db.username=alfresco
#db.password=alfresco
#
# Property to control whether schema updates are performed automatically.
# Updates must be enabled during upgrades as, apart from the static upgrade scripts,
# there are also auto-generated update scripts that will need to be executed. After
# upgrading to a new version, this can be disabled.
#
db.schema.update=true
#
# MySQL connection
#
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://localhost/alfresco
#
# Oracle connection
#
#db.driver=oracle.jdbc.OracleDriver
#db.url=jdbc
racle:thin:@localhost:1521:alfresco#
# SQLServer connection
# Requires jTDS driver version 1.2.5 and SNAPSHOT isolation mode
# Enable TCP protocol on fixed port 1433
# Prepare the database with:
# ALTER DATABASE alfresco SET ALLOW_SNAPSHOT_ISOLATION ON;
#
#db.driver=net.sourceforge.jtds.jdbc.Driver
#db.url=jdbc:jtds:sqlserver://localhost:1433/alfresco
#db.txn.isolation=4096
#
# PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent)
#
#db.driver=org.postgresql.Driver
#db.url=jdbc
ostgresql://localhost:5432/alfresco# The well known RMI registry port is defined in the alfresco-shared.properties file
# alfresco.rmi.services.port=50500
#
# RMI service ports for the individual services.
# These seven services are available remotely.
#
# Assign individual ports for each service for best performance
# or run several services on the same port. You can even run everything on 50500 if needed.
#
# Select 0 to use a random unused port.
#
avm.rmi.service.port=50501
avmsync.rmi.service.port=50502
attribute.rmi.service.port=50503
authentication.rmi.service.port=50504
repo.rmi.service.port=50505
action.rmi.service.port=50506
wcm-deployment-receiver.rmi.service.port=50507
Please reply. Thanks for your attention.
Regards
PP
Hey I got it.
Have a look on the below things.
(1)Verify the path of the alf_data in repository.properties.
(2)Check Mysql is running or not /etc/init.d/mysqld status. It should be running..
(3) Check the log any issue related to pdf2swf or ImageMagick. If present u need to install swftool and set the path.
(4)Edit the Catalina.sh
Add the blow things after
elif [ "$1" = "start" ] ; then
shift
touch "$CATALINA_BASE"/logs/catalina.out
JAVA_OPTS='-server -Xss1024K -Xms1G -Xmx3G -XX:+CMSPermGenSweepingEnabled -XX:+CMSClassUnloadingEnabled -XXermSize=256m -XX:MaxPermSize=512m'
(5) Also have a look on http://forums.alfresco.com/en/viewtopic.php?f=10&t=15336
Have a look on the below things.
(1)Verify the path of the alf_data in repository.properties.
(2)Check Mysql is running or not /etc/init.d/mysqld status. It should be running..
(3) Check the log any issue related to pdf2swf or ImageMagick. If present u need to install swftool and set the path.
(4)Edit the Catalina.sh
Add the blow things after
elif [ "$1" = "start" ] ; then
shift
touch "$CATALINA_BASE"/logs/catalina.out
JAVA_OPTS='-server -Xss1024K -Xms1G -Xmx3G -XX:+CMSPermGenSweepingEnabled -XX:+CMSClassUnloadingEnabled -XX
ermSize=256m -XX:MaxPermSize=512m'(5) Also have a look on http://forums.alfresco.com/en/viewtopic.php?f=10&t=15336
