topic Re: How to reset alfresco 4.2.c community in Alfresco Archive

How to reset alfresco 4.2.c community

patdelaney — Fri, 28 Jun 2013 19:16:09 GMT

Through various experiments moving the alf_data from one location to another. I can't seem to find anything that will help me "reset" the system for a fresh install, with out re-installing. I don't care about loosing any assets at this time. Can anyone point me in the right direction?

Re: How to reset alfresco 4.2.c community

jpotts — Fri, 28 Jun 2013 21:02:14 GMT

1. Shutdown tomcat
2. Drop the alfresco database.
3. Re-create the alfresco database.
4. Remove everything in alf_data
5. (Optional) Clear everything out of $TOMCAT_HOME/webapps/alfresco and re-deploy alfresco.war
6. (Optional) Clear everything out of $TOMCAT_HOME/webapps/share and re-deploy share.war
7. Restart Tomcat

If you are going to do this more than a couple of times it is worth creating a shell script.

Jeff

Re: How to reset alfresco 4.2.c community

patdelaney — Fri, 28 Jun 2013 22:38:38 GMT

I'm still new to Alfresco Community and I used the installer to do the linus install of Community. I can figureout how to "drop" the database via sql,
but I am not sure how to recreate it? is there a script that does that?
If you could be a little more specific on the steps I can wing it from there

Thanks

Re: How to reset alfresco 4.2.c community

fcorti — Sat, 29 Jun 2013 08:10:07 GMT

Hi,

Regarding the database you simply have to drop and create the empty schema.
Tables, initial data, views and everything is necessary is built by Alfresco during the next start.

To create the database on a Postgresql db, for example, you can use simply:
CREATE ROLE alfresco WITH PASSWORD ‘alfresco’ LOGIN;
CREATE DATABASE alfresco WITH OWNER alfresco;

Hope this help.

Re: How to reset alfresco 4.2.c community

jpotts — Mon, 01 Jul 2013 18:15:28 GMT

And if you are using MySQL/MariaDB it looks like this:

create database alfresco default character set utf8 collate utf8_bin;
grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;

Jeff

Re: How to reset alfresco 4.2.c community

mth — Wed, 24 Sep 2014 08:35:49 GMT

Hi,

it might seem a little dumb, but I feel compelled to add: remove everything in alf_data <em>except</em> postgresql. Otherwise, you'd have to re-create the postgres data directory. Which I'm fighting with at the moment.

Best regards,
Martin