nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

How to reset alfresco 4.2.c community

patdelaney

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?

Find more posts tagged with

Comments

jpotts

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

patdelaney

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

fcorti

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.

jpotts

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

mth

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