How to reset alfresco 4.2.c community
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-28-2013 03:16 PM
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?
Labels:
- Labels:
-
Archive
5 REPLIES 5
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-28-2013 05:02 PM
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
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-28-2013 06:38 PM
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
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-24-2014 04:35 AM
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
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-29-2013 04:10 AM
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.
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.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-01-2013 02:15 PM
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
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